Essentials of Corporate Finance
Essentials of Corporate Finance
8th Edition
ISBN: 9780078034756
Author: Stephen A. Ross, Randolph W. Westerfield, Bradford D. Jordan
Publisher: MCGRAW-HILL HIGHER EDUCATION
Question
Book Icon
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.

Expert Solution & Answer
Check Mark

Answer to Problem 22QP

The MIRR for the project using the discounted approach is 19.74%, reinvestment approach is 14.89%, and combination approach is 14.38%.

Explanation of Solution

Given information:

Company C is assessing a project where the cash flows are$7,930, $9,490, $8,970, $7,210, and -$3,980 for year1, 2, 3, 4, and 5 respectively. The initial cost is -$19,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.

Time 0 cash flow=Initial cost+Cash outflows(1+r)t=$19,500+$3,980(1+0.10)5=$21,971.26

Hence, the discounted cash flow at time 0 is -$21,971.26.

Equation of MIRR in a discounted approach:

0=$21,971.26+$7,930(1+MIRR)+$9,490(1+MIRR)2+$8,970(1+MIRR)3+$7,210(1+MIRR)4

Compute MIRR using a spreadsheet:

Step 1:

Essentials of Corporate Finance, Chapter 8, Problem 22QP , additional homework tip  1

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

Step 2:

Essentials of Corporate Finance, Chapter 8, Problem 22QP , additional homework tip  2

  • Assume the MIRRvalue as 0.10%.

Step 3:

Essentials of Corporate Finance, Chapter 8, Problem 22QP , additional homework tip  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:

Essentials of Corporate Finance, Chapter 8, Problem 22QP , additional homework tip  4

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

Step 5:

Essentials of Corporate Finance, Chapter 8, Problem 22QP , additional homework tip  5

  • The value appears to be 19.746172029783%.

Hence, the MIRR value is 19.74%.

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:

Time 5 cash flow=Cash flows (year 1(1+r)4+year 2(1+r)3+year 3(1+r)2+year 4(1+r)+year 5)=($7,930(1+0.10)4+$9,490(1+0.10)3+$8,970(1+0.10)2+$7,210(1+0.10)$3,980)=$7,930(1.4641)+$9,490(1.331)+$8,970(1.21)+$7,210(1.10)$3,980=$39,046.203

Hence, the reinvesting cash flow at time 5 is $39,046.203.

Equation of MIRR in reinvestment approach:

0=$19,500+$39,046.203(1+MIRR)5

Compute the MIRR:

0=$19,500+$39,046.203(1+MIRR)5$39,046.203$19,500=(1+MIRR)5MIRR=($39,046.203$19,500)1/51MIRR=0.1489 or 14.89%

Hence, the MIRR is 14.89%.

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:

Time 0 cash flow=Initial cost+Cash outflows(1+r)t=$19,500+$3,980(1+0.10)5=$21,971.26

Hence, the total cash outflow at year 0 is -$21,971.26.

Time 5 cash flow=Cash flows (year 1(1+r)4+year 2(1+r)3+year 3(1+r)2+year 4(1+r)+year 5)=($7,930(1+0.10)4+$9,490(1+0.10)3+$8,970(1+0.10)2+$7,210(1+0.10))=$7,930(1.4641)+$9,490(1.331)+$8,970(1.21)+$7210(1.10)=$43,026.203

Hence, the value of total cash inflows is $43,026.203.

Equation of MIRR in combination approach:

0=$21,971.26+$43,026.203(1+MIRR)5

Compute the MIRR:

0=$21,971.26+$43,026.203(1+MIRR)5$43,026.203$21,971.26=(1+MIRR)5MIRR=($43,026.203$21,971.26)1/51MIRR=0.1438 or 14.38%

Hence, the MIRR is $14.38%.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
An insurance company has liabilities of £7 million due in 10 years' time and £9 million due in 17 years' time. The assets of the company consist of two zero-coupon bonds, one paying £X million in 7 years' time and the other paying £Y million in 20 years' time. The current interest rate is 6% per annum effective. Find the nominal value of X (i.e. the amount, IN MILLIONS, that bond X pays in 7 year's time) such that the first two conditions for Redington's theory of immunisation are satisfied. Express your answer to THREE DECIMAL PLACES.
An individual is investing in a market where spot rates and forward rates apply. In this market, if at time t=0 he agrees to invest £5.3 for two years, he will receive £7.4 at time t=2 years. Alternatively, if at time t=0 he agrees to invest £5.3 at time t=1 for either one year or two years, he will receive £7.5 or £7.3 at times t=2 and t=3, respectively. Calculate the price per £5,000 nominal that the individual should pay for a fixed-interest bond bearing annual interest of 6.6% and is redeemable after 3 years at 110%. State your answer at 2 decimal places.
The one-year forward rates of interest, f+, are given by: . fo = 5.06%, f₁ = 6.38%, and f2 = 5.73%. Calculate, to 4 decimal places (in percentages), the three-year par yield.

Chapter 8 Solutions

Essentials of Corporate Finance

Knowledge Booster
Background pattern image
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,
Text book image
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:9781260013962
Author:BREALEY
Publisher:RENT MCG
Text book image
Financial Management: Theory & Practice
Finance
ISBN:9781337909730
Author:Brigham
Publisher:Cengage
Text book image
Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,
Text book image
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Text book image
Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education