In: Finance
| Year | 0 | 1 | 2 | 3 | 4 | 5 | ||
| A | Initial investment | -451000 | ||||||
| B | Working capital | -71000 | 71000 | |||||
| i | Revenue | 260000 | 260000 | 260000 | 260000 | 260000 | ||
| ii | Cost | 85000 | 85000 | 85000 | 85000 | 85000 | ||
| iii | depreciation | 90200 | 90200 | 90200 | 90200 | 90200 | ||
| iv=i-ii-iii | Profit before tax | 84800 | 84800 | 84800 | 84800 | 84800 | ||
| v=iv*40% | Tax @ 40% | 33920 | 33920 | 33920 | 33920 | 33920 | ||
| vi=iv-v | Net income | 50880 | 50880 | 50880 | 50880 | 50880 | ||
| vii=vi+iii | Operating cash flow | 141080 | 141080 | 141080 | 141080 | 141080 | ||
| viii | Post tax salvage value | 51000 | ||||||
| 85000*(1-40%) | ||||||||
| ix=A+B+vii+viii | net cash flow | -522000 | 141080 | 141080 | 141080 | 141080 | 263080 | |
| x | PVIF @ 10% | 1.0000 | 0.9091 | 0.8264 | 0.7513 | 0.6830 | 0.6209 | |
| xi=ix*x | Present value | (522,000) | 128,255 | 116,595 | 105,995 | 96,360 | 163,352 | 88,557 |
| NPV = | 88,557 | |||||||
| Ans = | $ 88,557 |