In: Finance
Present value = sum of present value of all individual cash flows discounted at 11%
PVIF = 1/(1+r)^n where r = cost of capital = 11% and n is the year of the cash flow.
PV = cash flow*PVIF
NPV (net present value) = sum of all PVs
a | b | c = a*b | ||
Year | Cash flow | 1+r | PVIF | PV |
0 | - 240,000.00 | 1.11 | 1.0000 | - 240,000.00 |
1 | 20,000.00 | 0.9009 | 18,018.02 | |
2 | 20,000.00 | 0.8116 | 16,232.45 | |
3 | 20,000.00 | 0.7312 | 14,623.83 | |
4 | 20,000.00 | 0.6587 | 13,174.62 | |
5 | 20,000.00 | 0.5935 | 11,869.03 | |
6 | 20,000.00 | 0.5346 | 10,692.82 | |
7 | 20,000.00 | 0.4817 | 9,633.17 | |
8 | 20,000.00 | 0.4339 | 8,678.53 | |
9 | 20,000.00 | 0.3909 | 7,818.50 | |
10 | 20,000.00 | 0.3522 | 7,043.69 | |
11 | - 23,000.00 | 0.3173 | - 7,297.52 | |
Total | -129,512.88 |
Thus NPV = -$129,512.88