Respuesta :
Answer:
Payback Period = 4 Years
Net Present value = $15692
Internal Rate of Return = 17.82%
Modified Internal Rate of Return = 14.20%
Explanation:
Payback Period = (Initial Investment / Net Cash inflows)
Payback Period = $61500/15000 = 4 Years
Net Present value using PVIF table value at 11% over the period and discount them given cash flows gives us discounted cash flows.
Year  CF    PVIF 11%,n  Discounted CF
0 -61500 Â 1.000 Â (61,500)
1 15000 Â 0.901 Â 13,514 Â
2 15000 Â 0.812 Â 12,174 Â
3 15000 Â 0.731 Â 10,968 Â
4 15000 Â 0.659 Â 9,881 Â
5 15000 Â 0.593 Â 8,902 Â
6 15000 Â 0.535 Â 8,020 Â
7 15000 Â 0.482 Â 7,225 Â
8 15000 Â 0.434 Â 6,509 Â
Summing up the discounted Cash flows gives us the Net Present value of $15692
Internal Rate of Return:
Using Excel Function IRR @ 17.82% applying it on cash flows gives the rate where Present value of Cash flows is Zero.
Modified Internal Rate of Return:
Modified internal rate of return is at the level of 14.20% as it lower than IRR because it assume positive cash flows invested at cost of capital. Â