In: Finance
|
Year cash flows calculation of NPV
Total = 454.55+330.58+225.39+68.30 = 1078.82
Less: initial outlay of 1000 = 1000.00
NPV = 78.82
We can calculate on trial & error basis:
14.5% is the correct answer. We take IRR for which cash flows almost equals zero. Calculations below:
Year cash flows calculation of IRR
TOTAL = 436.7 + 305.1 + 199.9 + 58.18 = 999.8
Less: initial outlay of 1000 = 1000
-0.18
3) MIRR:
YEAR Cash flows calculation:
Total = 1650 +880+330 = 2860
=square root of 2860/1000 – 1
=1.691 – 13.28%