Project2-Excel.xlsx
Template
| NAME | | Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
| Official EBIT |
| | Owner's Salary |
| | Reasonable Salary |
| | Depreciation |
| | Personal Expenses |
| Estimated EBITDA |
| | New Equipment |
| | Inventory Investment |
| Free Cash Flow |
| Current EBIT | | | | | Weight Of Debt |
| Owner's Salary | | | | | Weight Of Equity |
| Reasonable Salary | | | | | Cost Of Debt |
| Depreciation | | | | | Cost Of Equity |
| Personal Expenses | | | | | WACC |
| New Equipment |
| Inventory Investment | | | | | Value Of Firm |
| Estimated Growth Rate | | | | | Basis Of Firm |
| Tax Rate | | | | | Gain |
| | | | | | Taxes Owed |
| Terminal Value | | | | | Value Of Debt |
| CF1 | | | | | Net Proceeds |
| CF2 | | | | | Sell For $900k? |
| CF3 | | | | | Sell For $700k? |
| CF4 |
| CF5 |
| NPV |
Kikotynr
