Costington's Case Group Assignment: Prepare a three-year forecast based on Costington's actual financial statements (Exhibit 10). Note this requires that you create an entirely new spreadsheet model that includes all the accounts in Exhibit 10, i.e., do not combine individual accounts. You will also have to setup the spreadsheet model to calculate manually and enable iteration. (In the Costington's Case module in Canvas, there is an Excel file, Costington's Exhibit 10.xlsx, from which you can copy and paste the firm's financial statements into your forecast spreadsheet so that you do not have to manually input Exhibit 10 into your forecast spreadsheet.) Make Short-Term Debt/Excess Cash the plug figure. Include "input data" rows that indicate the assumptions you're using for your forecast. Each group will independently arrive at the unique assumptions for their particular forecasts. Organize your spreadsheet so that anyone outside your group could follow your analysis. The following additional information will be helpful to you in completing your forecasts:

Answer rating: 100% (QA)

To prepare a threeyear forecast based on Costingtons actual financial statements Exhibit 10 you can follow these steps using Excel 1 Set Up the Spread... View the full answer