Question

Solo Corp. is evaluating a project with the following cash flows:
Year Cash Flow 0 $28100 1 10,300 2 13,000 3 14,900 4 12,000 5 — 8,500
The company uses an Interest rate of 8 percent on all of Its projects.
a. Calculate the MIRR of the project using the discounting approach. (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places. e.g., 32.16.)
b. Calculate the MIRR of the project using the reinvestment approach. (Do not round Intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)
c. Calculate the MIRR of the project using the combination approach. (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)
a. Discounting approach MIRR %
b. Reinvestment approach MIRR %
c. Combination approach MIRR €Y.

Answer 1

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%