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 |