| Assumptions |
| Predicted sales for 2016 | | 1000000 | | Please re-create Table 2-5 from our textbook. Use cell reference when constructing the following pro forma statements. NPV and IRR should update automatically when you change any of the values in the assumption table (cell C2-C17). |
| sales growth for 2017-2021 | | 10% |
| Gross profit margin | | 40% |
| OEBD/Sales | | 25% |
| Tax Rate | | 30% |
| Net PP&E/Sales | | 40% |
| AR plus accrued expenses/sales | | 20% |
| AP plus accrued expenses/sales | | 15% |
| STD/TA | | 0% |
| ST borrowing rate | | 5% |
| LTD/TA | | 0% |
| LTD borrowing rate | | 6% |
| Depreciation life | | 10% |
| Depreciation method | | Straight line |
| Residual Value of BV | | 100% |
| Cost of Capital | | 18% |
| Income Statement | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 |
| Sales |
| COGS |
| Gross Profit |
| OEBD |
| Dep |
| EBIT |
| Int |
| EBT |
| Taxes |
| NI |
| Balance Sheet | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 |
| AR+Inv |
| Gross PP&E |
| Dep |
| Net PP&E |
| Total Assets |
| AP+Accrued expenses |
| STD |
| CL |
| LTD |
| CE |
| TL+CE |
| FCF Calculation | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 |
| EBIT |
| Taxes |
| NOPAT |
| Dep |
| CAPEX |
| ChgONWC |
| Residual Value |
| FCF |
| NPV |
| IRR |
cattlejock87
2.xlsx
