I need help with projections & NPV....please see attachments for instructions and spreadsheet to base work off.
**See attached spreadsheet for reference. Use provided spreadsheet and add required worksheets to it. Required worksheets are highlighted.
Spreadsheet: Projections, NPV, Compilation:
Strategy Implementation: assume 10% internal rate return. Initial investment of $5M applied to the first projected year.
Projected Income Statement, Projected Balance Sheet and Projected Statement of Cash Flows for 3 years into the future. This must be broken down by year into two (2) columns: 1 column without your strategy and 1 column with your strategy.
Include Projected Ratios for the without and with strategy by year.
Cost Analysis completed on an Excel tab that outlines the cost that will be incurred to implement the strategy. This information should correspond with the With Strategy on the Projected Financial Statements, linking of cells to the financial statements is encouraged.
Net Present Value analysis. From the income statement the change in operating income between your with and without strategy should serve as your cash inflow for each year.