In: Finance
A project has annual cash flows of $6,000 for the next 10 years and then $5,500 each year for the following 10 years. The IRR of this 20-year project is 12.46%. If the firm's WACC is 9%, what is the project's NPV? Round your answer to the nearest cent. Do not round your intermediate calculations.
Year | Cash flow | PV factor @ 12.46% | Present values | ||
1 | 6,000 | 0.889 | 5,335 | ||
2 | 6,000 | 0.791 | 4,744 | ||
3 | 6,000 | 0.703 | 4,218 | ||
4 | 6,000 | 0.625 | 3,751 | ||
5 | 6,000 | 0.556 | 3,335 | ||
6 | 6,000 | 0.494 | 2,966 | ||
7 | 6,000 | 0.440 | 2,637 | ||
8 | 6,000 | 0.391 | 2,345 | ||
9 | 6,000 | 0.348 | 2,085 | ||
10 | 6,000 | 0.309 | 1,854 | ||
11 | 5,500 | 0.275 | 1,511 | ||
12 | 5,500 | 0.244 | 1,344 | ||
13 | 5,500 | 0.217 | 1,195 | ||
14 | 5,500 | 0.193 | 1,063 | ||
15 | 5,500 | 0.172 | 945 | ||
16 | 5,500 | 0.153 | 840 | ||
17 | 5,500 | 0.136 | 747 | ||
18 | 5,500 | 0.121 | 664 | ||
19 | 5,500 | 0.107 | 591 | ||
20 | 5,500 | 0.096 | 525 | ||
Total | 42,698 | ||||
AT IRR the PV of inflow is equal to Outflow and hence | |||||
Initial Outflow is 42,698 | |||||
Now let's calculate the NPV @ 9% | |||||
Year | Cash flow | PV factor @ 9% | Present values | ||
0 | (42,698) | 1.000 | (42,698) | ||
1 | 6,000 | 0.917 | 5,505 | ||
2 | 6,000 | 0.842 | 5,050 | ||
3 | 6,000 | 0.772 | 4,633 | ||
4 | 6,000 | 0.708 | 4,251 | ||
5 | 6,000 | 0.650 | 3,900 | ||
6 | 6,000 | 0.596 | 3,578 | ||
7 | 6,000 | 0.547 | 3,282 | ||
8 | 6,000 | 0.502 | 3,011 | ||
9 | 6,000 | 0.460 | 2,763 | ||
10 | 6,000 | 0.422 | 2,534 | ||
11 | 5,500 | 0.388 | 2,131 | ||
12 | 5,500 | 0.356 | 1,955 | ||
13 | 5,500 | 0.326 | 1,794 | ||
14 | 5,500 | 0.299 | 1,646 | ||
15 | 5,500 | 0.275 | 1,510 | ||
16 | 5,500 | 0.252 | 1,385 | ||
17 | 5,500 | 0.231 | 1,271 | ||
18 | 5,500 | 0.212 | 1,166 | ||
19 | 5,500 | 0.194 | 1,070 | ||
20 | 5,500 | 0.178 | 981 | ||
NPV | 10,718 | ||||