Question

In: Finance

10-11. Your company is considering two mutually exclusive projects, J and K, whose costs and cash...

10-11. Your company is considering two mutually exclusive projects, J and K, whose costs and cash flows are shown below:

Year

J

K

0

$(5,000)

$(5,000)

1

1,000

4,500

2

1,500

1,500

3

2,000

1,000

4

4,000

500

The projects are equally risky, and their cost of capital is 12%. You must make a recommendation, and you must base it on the modified IRR (MIRR). What is the MIRR of the better project?

Solutions

Expert Solution

The Modified Internal Rate of return has a reinvestment assumption that the cash flows are re invested at the cost of capital ,rather than at the IRR(which is the assumption for IRR method)

The MIRR can be determined using the excel formula =MIRR()

The Discount rate =12%

For Project J

The MIRR can be determined using the formula =MIRR(B2:B6,12%,12%) we get MIRR as 17.49%

For Project K

The MIRR can be determined using the formula =MIRR(C2:C6,12%,12%) we get MIRR as 18.39%

Project K is the better project with an MIRR of 18.39%


Related Solutions

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%...
Your company is considering two mutually exclusive projects, X and Y, whose costs and cash flows are shown below:
Problem 10-11MIRR and NPVYour company is considering two mutually exclusive projects, X and Y, whose costs and cash flows are shown below:YearXY0-$5,000-$5,000110004,50021500150032000100044000500The projects are equally risky, and their cost of capital is 15%. You must make a recommendation, and you must base it on the modified IRR (MIRR). Calculate the two projects' MIRRs. Round your answers to two decimal places.Project X       %Project Y       %Which project has the higher MIRR?-Select-XYItem 3
1. A company is analyzing two mutually exclusive projects, A and B, whose cash flows are...
1. A company is analyzing two mutually exclusive projects, A and B, whose cash flows are shown below: Years        0 r = 10%    1                   2                   3 |                    |                    |                    | A -3,100 1,800 1750 750 B -3,100 700 0 3,500 The company's cost of capital is 10 percent, and it can get an unlimited amount of capital at that cost. What is the IRR of the better project, i.e., the project which the company should choose if...
1.A company is analyzing two mutually exclusive projects, E and F, whose cash flows are shown...
1.A company is analyzing two mutually exclusive projects, E and F, whose cash flows are shown below: Years 0 1 2 3 4 Cash Flow E -$1,100 $900 $350 $50 $10 Cash Flow F -$1,100 $0 $300 $400 $850 The company's cost of capital is 12 percent, and it can get an unlimited amount of capital at that cost. What is the regular IRR (not MIRR) of the better project? (Hint: Note that the better project may or may not...
Suppose your firm is considering two mutually exclusive, required projects with the cash flows shown as...
Suppose your firm is considering two mutually exclusive, required projects with the cash flows shown as follows. The required rate of return on projects of both of their risk class is 10 percent, and the maximum allowable payback and discounted payback statistic for the projects are two and a half and three and a half years, respectively. Calculate the payback and use the payback decision rule to evaluate these projects; which one(s) should be accepted or rejected and why? Trying...
Mary Inc. is considering mutually exclusive Projects A and B, whose cash flows are shown below....
Mary Inc. is considering mutually exclusive Projects A and B, whose cash flows are shown below. If the decision is made by choosing the project with the higher IRR, will there be any value loss due to the IRR-based decision? If there is a loss, how much value will be forgone? The WACC is assumed to be 9.5%. WACC: Year 9.5% 0 1 2 3 4 CFA −$2,020 $730 $730 $740 $740 CFB −$4,100 $1,400 $1,500 $1,520 $1,530 Use a...
Your company is considering investing in one of two mutually exclusive projects. The cost of capital...
Your company is considering investing in one of two mutually exclusive projects. The cost of capital is 11%. The first project Has $25,000 annual cash inflows, a 10-year life, and will cost $120,000 at time zero. The second project has a 7-year life, Annual cash inflows of $20,000 per year, and a cost of $75,000 at time zero. Which project has the highest NPV. Assuming that these projects will most likely be repeated indefinitely into the future, which project would...
Your company is considering investing in one of two mutually exclusive projects. The cost of capital...
Your company is considering investing in one of two mutually exclusive projects. The cost of capital is 11%. The first project Has $25,000 annual cash inflows, a 10-year life, and will cost $120,000 at time zero. The second project has a 7-year life, Annual cash inflows of $20,000 per year, and a cost of $75,000 at time zero. Which project has the highest NPV. Assuming that these projects will most likely be repeated indefinitely into the future, which project would...
The Camel Company is considering two mutually exclusive projects with the following cash flows. Assume discount...
The Camel Company is considering two mutually exclusive projects with the following cash flows. Assume discount rate of 12%. Compute NPV, IRR, PI. Assume the discount rate is 12%. Please recommend the firm which project(s) to choose under the following scenarios: Year Project A cash flow Project B Cash flow 0 -75,000 $-60,000 1 $30,000 $25,000 2 $35,000 $30,000 3 $35,000 $25,000     Assume Independent Projects: (i) which project(s) would you recommend? (ii) Would your answer change if the firm...
A company is considering two mutually exclusive projects that have the following cash flows: Year                       Project...
A company is considering two mutually exclusive projects that have the following cash flows: Year                       Project A Cash Flow                      Project B Cash Flow 0                              -$10,000                                             -$8,000 1                                   1000                                                7000 2                                   2000                                                1000             3                                   6000                                                1000 4                                   6000                                                1000 If the company’s required rate of return is 10%, find the project’s NPV, IRR, PI, and payback period. Which project they should invest in?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT