Obtain NPV
AmazingExpert
phase3ip.xlsxSheet1
| Year | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | ||
| T = | 0 | 1 | 2 | 3 | 4 | 5 | 6 | ||
| Cost of Capital | 6% | 6% | 7% | 8% | 8% | 7% | |||
| (US$ in millions) | |||||||||
| Revenue | 30.1 | 34.2 | 38.1 | 40.4 | 45.6 | 50 | |||
| Selling, General & | -16.1 | -17.2 | -18.9 | -19.5 | -21.4 | -24.3 | |||
| Admin. | |||||||||
| Depreciation | -4.1 | -4.4 | -4.8 | -4.9 | -5.3 | -5.7 | |||
| Interest Expense | -0.45 | -0.56 | -0.69 | -0.73 | -0.78 | -0.81 | |||
| Taxes | -1.1 | -1.3 | -1.7 | -1.9 | -2 | -2.1 | |||
| Increase in fixed assets | -1.3 | -2.4 | -0.9 | 0 | -4.9 | -2.1 | |||
| Capital Investment | -18 | ||||||||
| Net Income | |||||||||
| Operating Cash Flows | 4.25 | 6.34 | 7.21 | 8.47 | 10.82 | 11.39 | |||
| PVif (PV Interest Factor) | 0.943 | 0.89 | 0.816 | 0.735 | 0.681 | 0.666 |
