In: Finance
ManBearPig TV project has annual cash flows of $8000 for the next 8 years and then $12,000 each year for the following 5 years. The IRR of this 13-year project is 14%. If the firm's WACC is 12%, what is the project's NPV?
A. |
$4,941 |
|
B. |
$6,262 |
|
C. |
$5,183 |
|
D. |
$5,659 |
|
E. |
$5,794 |
Correct Answer =D.5659
IRR means rate at which initial investment is equal to future cash inflows | |||||
Let us calculate initial investment | |||||
Year | Cash Flow | PV Factor | PV Of Cash Flow | ||
a | b | c=1/1.14^a | d=b*c | ||
1 | $ 8,000 | 0.877192982 | $ 7,017.54 | ||
2 | $ 8,000 | 0.769467528 | $ 6,155.74 | ||
3 | $ 8,000 | 0.674971516 | $ 5,399.77 | ||
4 | $ 8,000 | 0.592080277 | $ 4,736.64 | ||
5 | $ 8,000 | 0.519368664 | $ 4,154.95 | ||
6 | $ 8,000 | 0.455586548 | $ 3,644.69 | ||
7 | $ 8,000 | 0.399637323 | $ 3,197.10 | ||
8 | $ 8,000 | 0.350559055 | $ 2,804.47 | ||
9 | $ 12,000 | 0.307507943 | $ 3,690.10 | ||
10 | $ 12,000 | 0.26974381 | $ 3,236.93 | ||
11 | $ 12,000 | 0.236617377 | $ 2,839.41 | ||
12 | $ 12,000 | 0.207559102 | $ 2,490.71 | ||
13 | $ 12,000 | 0.182069388 | $ 2,184.83 | ||
Value of investment | $ 51,552.88 | ||||
Let us calculate NPV | |||||
Year | Cash Flow | PV Factor | PV Of Cash Flow | ||
a | b | c=1/1.12^a | d=b*c | ||
0 | $ -51,552.88 | 1 | $ -51,552.88 | ||
1 | $ 8,000 | 0.892857143 | $ 7,142.86 | ||
2 | $ 8,000 | 0.797193878 | $ 6,377.55 | ||
3 | $ 8,000 | 0.711780248 | $ 5,694.24 | ||
4 | $ 8,000 | 0.635518078 | $ 5,084.14 | ||
5 | $ 8,000 | 0.567426856 | $ 4,539.41 | ||
6 | $ 8,000 | 0.506631121 | $ 4,053.05 | ||
7 | $ 8,000 | 0.452349215 | $ 3,618.79 | ||
8 | $ 8,000 | 0.403883228 | $ 3,231.07 | ||
9 | $ 12,000 | 0.360610025 | $ 4,327.32 | ||
10 | $ 12,000 | 0.321973237 | $ 3,863.68 | ||
11 | $ 12,000 | 0.287476104 | $ 3,449.71 | ||
12 | $ 12,000 | 0.256675093 | $ 3,080.10 | ||
13 | $ 12,000 | 0.22917419 | $ 2,750.09 | ||
NPV | $ 5,659 | ||||