In: Finance
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 | -$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: $
Project B: $
What is each project's IRR? Do not round intermediate calculations. Round your answers to two decimal places.
Project A: %
Project B: %
What is each project's MIRR? (Hint: Consider Period 7 as the end of Project B's life.) Do not round intermediate calculations. Round your answers to two decimal places.
Project A: %
Project B: %
Construct NPV profiles for Projects A and B. If an amount is zero, enter 0. Negative values, if any, should be indicated by a minus sign. Do not round intermediate calculations. Round your answers to the nearest cent.
| Discount Rate | NPV Project A | NPV Project B |
| 0% | $ | $ |
| 5 | ||
| 10 | ||
| 12 | ||
| 15 | ||
| 18.1 | ||
| 24.18 |
Calculate the crossover rate where the two projects' NPVs are equal. Do not round intermediate calculations. Round your answer to two decimal places.
%
What is each project's MIRR at a WACC of 18%? Do not round intermediate calculations. Round your answers to two decimal places.
Project A: %
Project B: %
As per rules I am answering the first 4 subparts of the question
| Sub Part | ||
| a | NPV | |
| Project A | $162.48 | |
| Project B | $131.67 | |
| b | IRR | |
| Project A | 18.10% | |
| Project B | 24.18% | |
| c | MIRR | |
| Project A | 15.60% | |
| Project B | 17.69% |
d:
| Discount Rate | NPV Project A | NPV Project B |
| 0% | $890 | $398 |
| 5 | ($370) | ($373) |
| 10 | ($337) | ($387) |
| 12 | ($331) | ($389) |
| 15 | ($325) | ($391) |
| 18.1 | ($321) | ($393) |
| 24.18 | ($316) | ($394) |
Workings
