Answer and Explanation:
The computation of MIRR under the following methods are shown below:
a. Using the Discounting Approach:
Interest Rate = 8%
The Present Value of Cash Outflows os
= -$28,100 - $8,500 ÷ 1.08^5
= -$33,884.96
Now
Let us assume the MIRR be i%
So,
0 = -$33,884.96 + $10,300 ÷ (1 + i) + $13,000 ÷ (1 + i)^2 + $14,900 ÷ (1 + i)^3 + $12,000 ÷ (1 + i)^4
Now use the financial calculator, after using it i is 17.18%
Thus, MIRR is 17.18%
b. Using the Reinvestment Approach:
Interest Rate = 8%
The Future Value of Cash Flows is
= $10,300 × 1.08^4 + $13,000 × 1.08^3 + $14,900 × 1.08^2 + $12,000 × 1.08 - $8,500
= $52,228.65
Let us assume MIRR be i%
So,
0 = -$28,100 + $52,228.65 ÷ (1 + i)^5
(1 + i)^5 = 1.85867
1 + i = 1.1320
i = 0.1320
= 13.20%
Thus, MIRR is 13.20%
c. Using the Combination Approach:
Interest Rate = 8%
Present Value of Cash Outflows is
= -$28,100 - $8,500 ÷ 1.08^5
= -$33,884.96
And,
Future Value of Cash Inflows is
= $10,300 × 1.08^4 + $13,000 × 1.08^3 + $14,900 × 1.08^2 + $12,000 × 1.08
= $60,728.65
Let us assume MIRR be i%
So,
0 = -$33,884.96 + $60,728.65 ÷ (1 + i)^5
(1 + i)^5 = 1.7922
1 + i = 1.1238
i = 0.1238
= 12.38%
Thus, MIRR is 12.38%
