In: Finance
Nast Inc. is considering Projects S and L, whose cash flows are
shown below. These projects are mutually exclusive, equally risky,
and not repeatable. If the decision is made by choosing the project
with the higher MIRR rather than the one with the higher NPV, how
much value will be forgone? Note that under some conditions
choosing projects on the basis of the MIRR will cause $0.00 value
to be lost.
WACC: |
10.75% |
||||
0 |
1 |
2 |
3 |
4 |
|
CFS |
-$1,100 |
$375 |
$375 |
$375 |
$375 |
CFL |
-$2,200 |
$725 |
$725 |
$725 |
$725 |
The following are the data inputs in spreadsheet:
The following are the obtained results in spreadsheet: