templet1.xlsx
Sheet1
| | Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | TV |
| Revenue | | | |
| Direct Expenses | 20 |
| Direct Dep |
| InDirect Cost | 30 |
| Other Costs | 20 |
| Gross Profit | |
| | |
| | |
| | | | | | | | | | | | | | | | |
| Operating Income |
| Capex |
| Working Capital | | | | | | | | | | | | | | | |
| FCF |
| Discount Factor |
| PV | | | | | | | | | | | | | | | |
| NPV | | | | | | | | | | | | | | | |
| IRR | | | | | | | | | | | | | | | |
| MRR |
| | | | | | | | | | | | Free Cash flow for Tv | = |
| | | | | | | | | | | | | | |