Question

Ehrmann Data Systems is considering a project that has the following cash flow and WACC data. What is the project's MIRR? Note that a project's projected MIRR can be less than the WACC (and even negative), in which case it will be rejected.


WACC: 9%
Year 0 1 2 3
Cash flows -$1,000 $450 $450 $450

a. 13.70%
b. 13.84%
c. 13.28%
d. 17.29%
e. 14.53%

Answer 1

Answer:

the project's MIRR is 13.84 %

Explanation:

MODIFIED INTERNAL RATE OF RETURN (MIRR)

-It is the rate that causes the Present Value of the Terminal Value (Future Cash flows at the end of the Project) to equal Present Value of Cash outflows.

-MIRR assumes a reinvestment rate at the end of the project

The First Step is to Calculate the Terminal Value at end of year 3.

Terminal Value (FV) = Sum of (PV x (1 + r) ^ 3 - n)

                   = $450 x (1.09) ^ 2 + $450 x (1.09) ^ 1 + $450 x (1.09) ^ 0

                   = $534.65 + $490.50 + $450.00

                   = $1,475.15

The Next Step is to Calculate the MIRR using a Financial Calculator :

(-$1,000)          CFj

0           CFj

0           CFj

$1,475.15   CFj

Shift IRR/Yr 13.84 %

Therefore, the project's MIRR is 13.84 %.