Turner Video will invest $62,500 in a project. The firm’s cost of capital is 6 percent. The investment will provide the following inflows. Use Appendix A for an approximate answer but calculate your final answer using the formula and financial calculator methods.
Year | Inflow | ||
1 | $ | 17,000 | |
2 | 19,000 | ||
3 | 23,000 | ||
4 | 27,000 | ||
5 | 31,000 | ||
The internal rate of return is 11 percent.
a. If the reinvestment assumption of the net
present value method is used, what will be the total value of the
inflows after five years? (Assume the inflows come at the end of
each year.) (Do not round intermediate calculations and
round your answer to 2 decimal places.)
b. If the reinvestment assumption of the internal
rate of return method is used, what will be the total value of the
inflows after five years? (Use the given internal rate of
return. Do not round intermediate calculations and round your
answer to 2 decimal places.)
c. Which investment assumption is better?
Reinvestment assumption of IRR | |
Reinvestment assumption of NPV |
a) If reinvestment rate is WACC then
FV after 5 Years
=17000*(1+6%)^4+19000*(1+6%)^3+23000*(1+6%)^2+27000*(1+6%)^1+31000
= 129554.21
b) IRR using excel formula
A | ||
Year | Inflow | |
1 | 0 | -62500 |
2 | 1 | 17,000 |
3 | 2 | 19,000 |
4 | 3 | 23,000 |
5 | 4 | 27,000 |
6 | 5 | 31,000 |
IRR | 22.3504% | |
IRR USING EXCEL FORMULA | IRR(A1:A6) |
If reinvestment rate is IRR then
FV after 5 Years
=17000*(1+22.3504%)^4+19000*(1+22.3504%)^3+23000*(1+22.3504%)^2+27000*(1+22.3504%)^1+31000
= 171359.32
c)Reinvestment assumption of NPV is better
Please Discuss in case of Doubt
Best of Luck. God Bless
Please Rate Well
Get Answers For Free
Most questions answered within 1 hours.