Question

A company has a 13% WACC and is considering two mutually exclusive investments (that cannot be...

A company has a 13% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows:

0 1 2 3 4 5 6 7
Project A -$300 -$387 -$193 -$100 $600 $600 $850 -$180
Project B -$405 $134 $134 $134 $134 $134 $134 $0

The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.

Open spreadsheet

  1. What is each project's NPV? Round your answer to the nearest cent. Do not round your intermediate calculations.

    Project A: $  

    Project B: $  

  2. What is each project's IRR? Round your answer to two decimal places.

    Project A: %

    Project B: %

  3. What is each project's MIRR? (Hint: Consider Period 7 as the end of Project B's life.) Round your answer to two decimal places. Do not round your intermediate calculations.

    Project A: %

    Project B: %

  4. From your answers to parts a-c, which project would be selected?

    _________Project AProject B

    If the WACC was 18%, which project would be selected?

    _________Project AProject B


  5. Construct NPV profiles for Projects A and B. Round your answers to the nearest cent. Do not round your intermediate calculations. Negative value should be indicated by a minus sign.

    Discount Rate NPV Project A NPV Project B
    0% $   $  
    5 $   $  
    10 $   $  
    12 $   $  
    15 $   $  
    18.1 $   $  
    23.97 $   $  
  6. Calculate the crossover rate where the two projects' NPVs are equal. Round your answer to two decimal places. Do not round your intermediate calculations.

    %

  7. What is each project's MIRR at a WACC of 18%? Round your answer to two decimal places. Do not round your intermediate calculations.

    Project A: %

    Project B: %

Homework Answers

Answer #1
Year Project A Project B B - A
0 -300 -405 -105
1 -387 134 521
2 -193 134 327
3 -100 134 234
4 600 134 -466
5 600 134 -466
6 850 134 -716
7 -180 0 180
NPV $162.48 $130.67
IRR 18.10% 23.97% 14.53%
MIRR 15.60% 17.61%
NPV (18%) $2.66 $63.68
MIRR (18%) 18.05% 20.49%

NPV, IRR and MIRR can be calculated using the same function in excel

Choose Project A as it has higher NPV for WACC = 13%

For WACC = 18%, Choose Project B as its NPV is higher now.

Crossover Rate can be calculated using IRR function on the difference in cash flows = 14.53%

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
A company has a 12% WACC and is considering two mutually exclusive investments (that cannot be...
A company has a 12% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows: 0 1 2 3 4 5 6 7 Project A -$300 -$387 -$193 -$100 $600 $600 $850 -$180 Project B -$400 $135 $135 $135 $135 $135 $135 $0 What is each project's NPV? Negative values, if any, should be indicated by a minus sign. Do not round intermediate calculations. Round your answers to the nearest cent. Project A:...
A company has an 11% WACC and is considering two mutually exclusive investments (that cannot be...
A company has an 11% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows: 0 1 2 3 4 5 6 7 Project A -$300 -$387 -$193 -$100 $600 $600 $850 -$180 Project B -$400 $133 $133 $133 $133 $133 $133 $0 What is each project's NPV? Negative values, if any, should be indicated by a minus sign. Do not round intermediate calculations. Round your answers to the nearest cent. Project A:...
A company has a 13% WACC and is considering two mutually exclusive investments (that cannot be...
A company has a 13% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows: 0 1 2 3 4 5 6 7 Project A -$300 -$387 -$193 -$100 $600 $600 $850 -$180 Project B -$405 $131 $131 $131 $131 $131 $131 0 A. What is each project's NPV? Round your answer to the nearest cent. Project A: Project B: B. What is each project's IRR? Round your answer to two decimal places....
A company has a 12% WACC and is considering two mutually exclusive investments (that cannot be...
A company has a 12% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows: 0 1 2 3 4 5 6 7 Project A -$300 -$387 -$193 -$100 $600 $600 $850 -$180 Project B -$400 $133 $133 $133 $133 $133 $133 $0 What is each project's NPV? Round your answer to the nearest cent. Do not round your intermediate calculations. What is each project's IRR? Round your answer to two decimal places....
Cummings Products Company is considering two mutually exclusive investments whose expected net cash flows are as...
Cummings Products Company is considering two mutually exclusive investments whose expected net cash flows are as follows: EXPECTED NET CASH FLOWS Year Project A Project B 0 -$320 -$360 1 -387 134 2 -193 134 3 -100 134 4 600 134 5 600 134 6 850 134 7 -180 134 What is each project's IRR? Do not round intermediate calculations. Round your answers to two decimal places Calculate the two projects' NPVs, if you were told that each project's cost...
NPV and IRR Analysis Cummings Products Company is considering two mutually exclusive investments whose expected net...
NPV and IRR Analysis Cummings Products Company is considering two mutually exclusive investments whose expected net cash flows are as follows: EXPECTED NET CASH FLOWS Year Project A Project B 0 -$300 -$405 1 -387 134 2 -193 134 3 -100 134 4 600 134 5 600 134 6 850 134 7 -180 134 What is each project's MIRR at a cost of capital of 10%? (Hint: Consider Period 7 as the end of Project B's life.) Do not round...
13. NPV and IRR Analysis Cummings Products Company is considering two mutually exclusive investments whose expected...
13. NPV and IRR Analysis Cummings Products Company is considering two mutually exclusive investments whose expected net cash flows are as follows: Expected Net Cash Flows Year Project A Project B 0 -$400 -$650 1 -528 210 2 -219 210 3 -150 210 4 1,100 210 5 820 210 6 990 210 7 -325 210 Select the correct graph for NPV profiles for Projects A and B.     The correct graph is (select one) graph __? What is each project's...
Gardial Fisheries is considering two mutually exclusive investments. The projects' expected net cash flows are as...
Gardial Fisheries is considering two mutually exclusive investments. The projects' expected net cash flows are as follows: Expected Net Cash Flows Time Project A Project B 0 ($375) ($575) 1 ($300) $190 2 ($200) $190 3 ($100) $190 4 $600 $190 5 $600 $190 6 $926 $190 7 ($200) $0 a. If each project's cost of capital is 12%, which project should be selected? If the cost of capital is 18%, what project is the proper choice? @ 12% cost...
A company is considering two mutually exclusive expansion plans. Plan A requires a $40 million expenditure...
A company is considering two mutually exclusive expansion plans. Plan A requires a $40 million expenditure on a large-scale integrated plant that would provide expected cash flows of $6.39 million per year for 20 years. Plan B requires a $12 million expenditure to build a somewhat less efficient, more labor-intensive plant with an expected cash flow of $2.69 million per year for 20 years. The firm's WACC is 11%. The data has been collected in the Microsoft Excel Online file...
MIRR A firm is considering two mutually exclusive projects, X and Y, with the following cash...
MIRR 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 $320 $400 $700 Project Y -$1,000 $1,100 $90 $45 $45 The projects are equally risky, and their WACC is 12%. What is the MIRR of the project that maximizes shareholder value? Round your answer to two decimal places. Do not round your intermediate calculations. _____%