In: Finance
A project has annual cash flows of $3,500 for the next 10 years and then $10,500 each year for the following 10 years. The IRR of this 20-year project is 13.44%. If the firm's WACC is 11%, what is the project's NPV? Do not round intermediate calculations. Round your answer to the nearest cent.
IRR means the rate at which present value of cash inflow is equal to Initial investment. | ||||||
Hence using IRR rate we can calculate initial investment amount | ||||||
Year | Cash Flow | PV Factor | PV Of Cash Flow | |||
a | b | c=1/1.1344^a | d=b*c | |||
1 | $ 3,500 | 0.88152 | $ 3,085.33 | |||
2 | $ 3,500 | 0.77708 | $ 2,719.79 | |||
3 | $ 3,500 | 0.68502 | $ 2,397.56 | |||
4 | $ 3,500 | 0.60386 | $ 2,113.50 | |||
5 | $ 3,500 | 0.53232 | $ 1,863.10 | |||
6 | $ 3,500 | 0.46925 | $ 1,642.37 | |||
7 | $ 3,500 | 0.41365 | $ 1,447.79 | |||
8 | $ 3,500 | 0.36464 | $ 1,276.26 | |||
9 | $ 3,500 | 0.32144 | $ 1,125.05 | |||
10 | $ 3,500 | 0.28336 | $ 991.76 | |||
11 | $ 10,500 | 0.24979 | $ 2,622.77 | |||
12 | $ 10,500 | 0.22019 | $ 2,312.04 | |||
13 | $ 10,500 | 0.19411 | $ 2,038.11 | |||
14 | $ 10,500 | 0.17111 | $ 1,796.64 | |||
15 | $ 10,500 | 0.15084 | $ 1,583.78 | |||
16 | $ 10,500 | 0.13297 | $ 1,396.14 | |||
17 | $ 10,500 | 0.11721 | $ 1,230.73 | |||
18 | $ 10,500 | 0.10333 | $ 1,084.92 | |||
19 | $ 10,500 | 0.09108 | $ 956.38 | |||
20 | $ 10,500 | 0.08029 | $ 843.07 | |||
Initial Investment | $ 34,527.11 | |||||
Calculation of NPV using 11% rate | ||||||
Year | Cash Flow | PV Factor | PV Of Cash Flow | |||
a | b | c=1/1.11^a | d=b*c | |||
0 | $ -34,527.11 | 1.00000 | $ -34,527.11 | |||
1 | $ 3,500 | 0.90090 | $ 3,153.15 | |||
2 | $ 3,500 | 0.81162 | $ 2,840.68 | |||
3 | $ 3,500 | 0.73119 | $ 2,559.17 | |||
4 | $ 3,500 | 0.65873 | $ 2,305.56 | |||
5 | $ 3,500 | 0.59345 | $ 2,077.08 | |||
6 | $ 3,500 | 0.53464 | $ 1,871.24 | |||
7 | $ 3,500 | 0.48166 | $ 1,685.80 | |||
8 | $ 3,500 | 0.43393 | $ 1,518.74 | |||
9 | $ 3,500 | 0.39092 | $ 1,368.24 | |||
10 | $ 3,500 | 0.35218 | $ 1,232.65 | |||
11 | $ 10,500 | 0.31728 | $ 3,331.47 | |||
12 | $ 10,500 | 0.28584 | $ 3,001.33 | |||
13 | $ 10,500 | 0.25751 | $ 2,703.90 | |||
14 | $ 10,500 | 0.23199 | $ 2,435.95 | |||
15 | $ 10,500 | 0.20900 | $ 2,194.55 | |||
16 | $ 10,500 | 0.18829 | $ 1,977.07 | |||
17 | $ 10,500 | 0.16963 | $ 1,781.14 | |||
18 | $ 10,500 | 0.15282 | $ 1,604.63 | |||
19 | $ 10,500 | 0.13768 | $ 1,445.62 | |||
20 | $ 10,500 | 0.12403 | $ 1,302.36 | |||
NPV | $ 42,390.32 | |||||