GENERAL INSTRUCTIONS: READ THIS ENTIRE ASSIGNMENT CAREFULLY BEFORE STARTING YOUR WORK. Download all files, including the accompanying excel template, and save them.
DO NOT COPY AND PASTE THE EXCEL TEMPLATE INTO A NEW WORKBOOK AND DO NOT WORK THROUGH THE WEB BROWSER.
Use formulas in all spreadsheet cells and reference given data cells as necessary.
CLEARLY LABEL AND SUBMIT THE BASELINE SCENARIO, ALL RELEVANT SPREADSHEET SENSITIVITY RESULTS. Organize all items (including proper formatting), into a single, easy-to-follow package. SEND ONLY YOUR COMPLETED FILE (Part 1 & 2).
CASE OBJECTIVES The project consists of two parts: Part I requires completing an Excel-based financial model template; and Part II involves decision-making and analysis extensions, including cost-volume-profit and sensitivity analysis, operating income versus cash flow, benchmarking, and planning issues. This project requires the application of technology in managerial planning and decision-making but also emphasizes critical thinking and general business skills. Specifically, the case has the following objectives: (1) to obtain experience using Excel within a planning and decision context; (2) to integrate a range of managerial and financial accounting concepts; and (3) to reinforce financial statement relationships through linking projected financial statements.
Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.
[order_calculator]