Question

In: Finance

A firm is considering two mutually exclusive projects, X and Y, with the following cash flows:...

A firm is considering two mutually exclusive projects, X and Y, with the following cash flows:

0 1 2 3 4
Project X -$1,000 $100 $300 $400 $650
Project Y -$1,000 $1,000 $110 $45 $55

The projects are equally risky, and their WACC is 10%. What is the MIRR of the project that maximizes shareholder value? Do not round intermediate calculations. Round your answer to two decimal places.

  %_____

Solutions

Expert Solution

Modified IRR:

It is similar to IRR. In IRR, we are assumed that intermediary cashflows are reinvested at IRR only. In MIRR, we assume that Intermediary CFs are reinvested at
Reinvestment Rate rather than at IRR.

Project X

ReInvestment rate 10%
Initial Investment $   1,000.00
Time Period               4.00
Cash Flows for 4 Years
Year Bal Years CF FVF @0.1 FV of CFs
1 3 $    100.00     1.3310 $      133.10
2 2 $    300.00     1.2100 $      363.00
3 1 $    400.00     1.1000 $      440.00
4 0 $    650.00     1.0000 $      650.00
Future Value of CFs $   1,586.10
Thus $1000 has become $1586.1 over a period of 4 Years
Future Value = Cash Flow * ( 1 + r )^n
$ 1586.1 = $ 1000 ( 1 + r) ^ 4
( 1 + r) ^ 4 = $1586.1 / $ 1000
( 1 + r) ^ 4 = 1.5861
( 1 + r) = 1.5861 ^ ( 1 / 4 )
( 1 + r) = 1.1222
r = 1.1222 -1  
r = 0.1222
i.e MIRR is 12.22 %

FVF = (1+r)n

r = Interest rate

n= time gap

Project Y

Cash Flows for 4 Years
Year Bal Years CF FVF @0.1 FV of CFs
1 3 $ 1,000.00     1.3310 $   1,331.00
2 2 $    110.00     1.2100 $      133.10
3 1 $      45.00     1.1000 $         49.50
4 0 $      55.00     1.0000 $         55.00
Future Value of CFs $   1,568.60
Thus $1000 has become $1568.6 over a period of 4 Years
Future Value = Cash Flow * ( 1 + r )^n
$ 1568.6 = $ 1000 ( 1 + r) ^ 4
( 1 + r) ^ 4 = $1568.6 / $ 1000
( 1 + r) ^ 4 = 1.5686
( 1 + r) = 1.5686 ^ ( 1 / 4 )
( 1 + r) = 1.1191
r = 1.1191 -1  
r = 0.1191
i.e MIRR is 11.91 %

Project X has higher MIRR i.e., 12..22 % that maximizes the share holder's value

Pls do rate, if the answer is correct and comment, if any further assistance is required.


Related Solutions

A firm is considering two mutually exclusive projects, X and Y, with the following cash flows:...
A firm is considering two mutually exclusive projects, X and Y, with the following cash flows: 0 1 2 3 4 Project X -$1,000 $110 $300 $400 $700 Project Y -$1,000 $900 $100 $55 $45 The projects are equally risky, and their WACC is 10%. What is the MIRR of the project that maximizes shareholder value? Round your answer to two decimal places. Do not round your intermediate calculations.
A firm is considering two mutually exclusive projects, X and Y, with the following cash flows:...
A firm is considering two mutually exclusive projects, X and Y, with the following cash flows: 0 1 2 3 4 Project X -$1,000 $110 $280 $400 $700 Project Y -$1,000 $1,100 $110 $45 $50 The projects are equally risky, and their WACC is 11%. What is the MIRR of the project that maximizes shareholder value? Round your answer to two decimal places. Do not round your intermediate calculations.
A firm is considering two mutually exclusive projects, X and Y, with the following cash flows:...
A firm is considering two mutually exclusive projects, X and Y, with the following cash flows: 0 1 2 3 4 Project X -$1,000 $110 $320 $400 $750 Project Y -$1,000 $1,000 $90 $45 $50 The projects are equally risky, and their WACC is 11%. What is the MIRR of the project that maximizes shareholder value? Do not round intermediate calculations. Round your answer to two decimal places
A firm is considering two mutually exclusive projects, X and Y, with the following cash flows:...
A firm is considering two mutually exclusive projects, X and Y, with the following cash flows: 0 1 2 3 4 Project X -$1,000 $90 $300 $370 $650 Project Y -$1,000 $900 $100 $50 $45 The projects are equally risky, and their WACC is 10%. What is the MIRR of the project that maximizes shareholder value? Round your answer to two decimal places. Do not round your intermediate calculations. ____%
A firm is considering two mutually exclusive projects, X and Y, with the following cash flows:...
A firm is considering two mutually exclusive projects, X and Y, with the following cash flows: 0 1 2 3 4 Project X -$1,000 $110 $280 $370 $650 Project Y -$1,000 $1,100 $100 $55 $45 The projects are equally risky, and their WACC is 8%. What is the MIRR of the project that maximizes shareholder value? Round your answer to two decimal places. Do not round your intermediate calculations. %
A firm is considering two mutually exclusive projects, X and Y, with the following cash flows:...
A firm is considering two mutually exclusive projects, X and Y, with the following cash flows: Project X: CF0= -$1,000, CF1= $110, CF2= $300, CF3= $370, CF4= $750 Project Y: CF0= -$1,000, CF1= $900, CF2= $110, CF3= $50, CF4= $50 The projects are equally risky, and their WACC is 13%. What is the MIRR of the project that maximizes shareholder value? Round your answer to two decimal places. Do not round your intermediate calculations.
SHOW WORK A firm is considering two mutually exclusive projects, X and Y, with the following...
SHOW WORK A firm is considering two mutually exclusive projects, X and Y, with the following cash flows: 0 1 2 3 4 Project X -$1,000 $100 $280 $400 $650 Project Y -$1,000 $1,100 $110 $50 $55 The projects are equally risky, and their WACC is 11%. What is the MIRR of the project that maximizes shareholder value? Do not round intermediate calculations. Round your answer to two decimal places.
Your company is considering two mutually exclusive projects, X and Y, whose costs and cash flows...
Your company is considering two mutually exclusive projects, X and Y, whose costs and cash flows are shown below: Year X Y 0 −$2,000 −$2,000 1 200 2,000 2 600 200 3 800 100 4 2,400 75 The projects are equally risky, and the firm's required rate of return is 12 percent. You must make a recommendation, and you must base it on the modified IRR. What is the MIRR of the best project? a. 12.00% b. 12.89% c. 11.46%...
A firm is considering two mutually exclusive one-year projects, with the cash flows shown
(i) A firm is considering two mutually exclusive one-year projects, with the cash flows shown below. The cost of capital for both projects is 12%.a) Compute the NPV and IRR for each project.b) Indicate whether NPV or IRR should be used to choose one of the two projects. (ii) Do you agree with the following statement and justify your answer. (10 marks)"Managers have the same incentive as shareholders to maximize firm value".(iii) Do you think the following statement to be...
Jamison is considering two mutually exclusive projects with the following cash flows and the cost of...
Jamison is considering two mutually exclusive projects with the following cash flows and the cost of capital of 10%. Year XX YY 0 -$1,000 -$1,200 1 $800 $700 2 $800 $700 3 $700 a) Based on Annualized NPV, which project would you choose? Why ANPV is better than NPV in this case.?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT