Chapter 8, Problem 22QP

Summary Introduction

To calculate: The MIRR (Modified Internal Rate of Return) for the project utilizing all three methods.

Introduction:

MIRR is the Modified Internal Rate of Return; it is a financial measure of attracting investments. It is utilized in capital budgeting to rank the alternative investments of the same size.

Answer to Problem 22QP

The MIRR for the project using the discounted approach is 19.21%, reinvestment approach is 14.49%, and combination approach is 14.14%.

Explanation of Solution

Given information:

Company M is assessing a project where the cash flows are $10,430, $13,850, $11,270, $9,830, and -$4,050 for year 1, 2, 3, 4, and 5 respectively. The initial cost is $27,500.

Discounted approach:

In this approach, compute the negative cash outflows value at year 0. On the other hand, the positive cash flows remain at its time of occurrence. Hence, discount the cash outflows to year 0.

$\begin{array}{c}\text{Time 0 cash flow}=\text{Initial cost}+\frac{-\text{Cash outflows}}{{\left(1+r\right)}^t}\\ =-\$27,500+\frac{-\$4,050}{{\left(1+0.10\right)}^5}\\ =-\$30,014.73\end{array}$

Hence, the discounted cash flow at time 0 is -$30,014.73.

Equation of MIRR in a discounted approach:

$0=-\$30,014.73+\frac{\$10,430}{\left(1+\text{MIRR}\right)}+\frac{\$13,850}{{\left(1+\text{MIRR}\right)}^2}+\frac{\$11,270}{{\left(1+\text{MIRR}\right)}^3}+\frac{\$9,830}{{\left(1+\text{MIRR}\right)}^4}$

Compute MIRR using a spreadsheet:

Step 1:

• Type the equation of NPV in H6 in the spreadsheet and consider the MIRR value as H7.

Step 2:

• Assume the MIRR value as 0.10%.

Step 3:

• In the spreadsheet, go to data and select the what-if analysis.
• In the what-if analysis, select goal seek.
• In set cell, select H6 (the formula).
• The “To value” is considered as 0 (the assumption value for NPV).
• The H7 cell is selected for the by changing cell.

Step 4:

• Following the previous step click OK in the goal seek. The goal seek status appears with the MIRR value.

Step 5:

• Thevalue appears to be 19.2108278981048%.

Hence, the MIRR value is 19.21%.

Reinvestment approach:

In this approach, compute the future value of all the cash flows excluding the initial cost at the closure of the project. Hence, compute the reinvesting cash flows to year 5 is:

$\begin{array}{c}\text{Time }5\text{ cash flow}=\text{Cash flows }\left(\begin{array}{l}\text{year }1{\left(1+r\right)}^4+\text{year }2{\left(1+r\right)}^3+\text{year }3{\left(1+r\right)}^2+\\ \text{year }4\left(1+r\right)+\text{year }5\end{array}\right)\\ =\left(\begin{array}{l}\$10,430{\left(1+0.10\right)}^4+\$13,850{\left(1+0.10\right)}^3+\$11,270{\left(1+0.10\right)}^2+\\ \$9,830\left(1+0.10\right)-\$4,050\end{array}\right)\\ =\$10,430\left(1.4641\right)+\$13,850\left(1.331\right)+\$11,270\left(1.21\right)+\$9,830\left(1.10\right)-\$4,050\\ =\$54,104.61\end{array}$

Hence, the reinvesting cash flow at time 5 is $54,104.61.

Equation of MIRR in reinvestment approach:

$0=-\$27,500+\frac{\$54,104.61}{{\left(1+\text{MIRR}\right)}^5}$

Compute the MIRR:

$\begin{array}{c}0=-\$27,500+\frac{\$54,104.61}{{\left(1+\text{MIRR}\right)}^5}\\ \frac{\$54,104.61}{\$27,500}={\left(1+\text{MIRR}\right)}^5\\ \text{MIRR}={\left(\frac{\$54,104.61}{\$27,500}\right)}^{1/5}-1\\ \text{MIRR}=0.1449\text{ or }14.49\%\end{array}$

Hence, the MIRR is 14.49%.

Combination approach:

In this approach, compute all the cash outflows at year 0 and all the cash inflows at the closure of the project. Hence, the value of the cash flows is as follows:

$\begin{array}{c}\text{Time 0 cash flow}=\text{Initial cost}+\frac{-\text{Cash outflows}}{{\left(1+r\right)}^t}\\ =-\$27,500+\frac{-\$4,050}{{\left(1+0.10\right)}^5}\\ =-\$30,014.73\end{array}$

Hence, the total cash outflow at year 0 is -$30,014.73.

$\begin{array}{c}\text{Time }5\text{ cash flow}=\text{Cash flows }\left(\begin{array}{l}\text{year}1{\left(1+r\right)}^4+\text{year}2{\left(1+r\right)}^3+\text{year}3{\left(1+r\right)}^2+\\ \text{year}4\left(1+r\right)+\text{year}5\end{array}\right)\\ =\left(\begin{array}{l}\$10,430{\left(1+0.10\right)}^4+\$13,850{\left(1+0.10\right)}^3+\$11,270{\left(1+0.10\right)}^2+\\ \$9,830\left(1+0.10\right)\end{array}\right)\\ =\$10,430\left(1.4641\right)+\$13,850\left(1.331\right)+\$11,270\left(1.21\right)+\$9,830\left(1.10\right)\\ =\$58,154.61\end{array}$

Hence, the value of total cash inflows is $58,154.61.

Equation of MIRR in combination approach:

$0=-\$30,014.73+\frac{\$58,154.61}{{\left(1+\text{MIRR}\right)}^5}$

Compute the MIRR:

$\begin{array}{c}0=-\$30,014.73+\frac{\$58,154.61}{{\left(1+\text{MIRR}\right)}^5}\\ \frac{\$58,154.61}{\$30,014.73}={\left(1+\text{MIRR}\right)}^5\\ \text{MIRR}={\left(\frac{\$58,154.61}{\$30,014.73}\right)}^{1/5}-1\\ \text{MIRR}=0.1414\text{ or }14.14\%\end{array}$

Hence, the MIRR is $14.14%.