In: Finance
A project has the following cash flows :
Year | Cash Flows | |
0 | −$12,000 | |
1 | 5,290 | |
2 | 7,630 | |
3 | 5,040 | |
4 | −1,580 | |
Assuming the appropriate interest rate is 10 percent, what is the
MIRR for this project using the discounting approach?
19.21%
15.23%
13.96%
11.63%
17.77%
Year | Cash Flow | Calculations | Future Value | ||
1 | $ 5,290 | =5290*1.10^3 | $ 7,040.99 | ||
2 | $ 7,630 | =7630*1.10^2 | $ 9,232.30 | ||
3 | $ 5,040 | =5040*1.10^11 | $ 5,544.00 | ||
4 | $ -1,580 | =-1580*1.10^0 | $ -1,580.00 | ||
Total | $ 20,237.29 | ||||
We need to calculate at which rate present value of $20237.3 will become 12000 | |||||
It can be calculated by using following formula | |||||
PV= FV/(1+r)^n | |||||
Where, | |||||
FV= Future Value | |||||
PV = Present Value | |||||
r = Interest rate | |||||
n= periods in number | |||||
12000=$20237.30/(1+r)^4 | |||||
r =13.96% | |||||
Therefore MIRR is 13.96% | |||||