What is the MIRR of a project that costs $675, generates free cash inflows of $254 at the end of each of the first 3 years and an outflow of 117 at the end of Year 4? The reinvestment rate is 7.03%. (Record your answer to the nearest 0.01%, drop the % symbol. E.g., if your answer is 10.7745%, record it as 10.77.)
MIRR can be calculated by two methods.
In first method, we can use Excel MIRR function, =MIRR(values,finance_rate,reinvest_rate)
In second method, MIRR = [(FV(positive cash flows, reinvestment rate) / PV(negative cash flows, finance rate)] ^ (1/n) - 1
In this case, both the finance rate and reinvest rate is same i.e. 7.03%
Both the methods have been shown below.
Note: Give it a thumbs up if it helps! Thanks in advance!
Get Answers For Free
Most questions answered within 1 hours.