Question

In: Finance

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 financial calculator and show all steps from the calculator used. DO NOT USE EXCEL. Thank you and show all steps

Solutions

Expert Solution

Project A

Net present value is calculated using a financial calculator by inputting the below:

  • Press the CF button.
  • CF0= -$2,020. It is entered with a negative sign since it is a cash outflow.
  • Cash flow for each year should be entered.
  • Press Enter and down arrow after inputting each cash flow.
  • After entering the last cash flow cash flow, press the NPV button and enter the weighted average cost of capital of 9.5%.
  • Press enter after that. Press the down arrow and CPT buttons to get the net present value.

The net present value of cash flows is $333.84.

Internal rate of return is calculated using a financial calculator by inputting the below:

  • Press the CF button.
  • CF0= -$2,020. It is entered with a negative sign since it is a cash outflow.
  • Cash flow for each year should be entered.
  • Press Enter and down arrow after inputting each cash flow.
  • After entering the last cash flow cash flow, press the IRR and CPT button to get the IRR of the project.

The IRR of project is 16.85%

Project B

Net present value is calculated using a financial calculator by inputting the below:

  • Press the CF button.
  • CF0= -$4,100. It is entered with a negative sign since it is a cash outflow.
  • Cash flow for each year should be entered.
  • Press Enter and down arrow after inputting each cash flow.
  • After entering the last cash flow cash flow, press the NPV button and enter the weighted average cost of capital of 9.5%.
  • Press enter after that. Press the down arrow and CPT buttons to get the net present value.

The net present value of cash flows is $651.590.

Internal rate of return is calculated using a financial calculator by inputting the below:

  • Press the CF button.
  • CF0= -$4,100. It is entered with a negative sign since it is a cash outflow.
  • Cash flow for each year should be entered.
  • Press Enter and down arrow after inputting each cash flow.
  • After entering the last cash flow cash flow, press the IRR and CPT button to get the IRR of the project.

The IRR of project is 16.49%.

Value loss due to the IRR-based decision= $651.59 - $333.84

                                                                                    = $317.75.

In case of any query, kindly comment on the solution


Related Solutions

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
Nast Inc. is considering Projects S and L, whose cash flows are shown below. These projects...
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...
Yonan Inc. is considering Projects S and L, whose cash flows are shown below. These projects...
Yonan 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 shorter payback, some value may be forgone. How much value will be lost in this instance? Note that under some conditions choosing projects on the basis of the shorter payback will not cause value to be lost WACC 11.75% 0 1 2 3 4 CFs...
Nast Inc. is considering Projects S and L, whose cash flows are shown below. These projects...
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...
Poston Inc. is considering Projects S and L, whose cash flows are shown below. These projects...
Poston Inc. is considering Projects S and L, whose cash flows are shown below. These projects are mutually exclusive (must choose one or the other), equally risky, and not repeatable. If the decision is made by choosing the project with the higher IRR, how much value will be forgone? You must calculate the IRR and NPV for both projects select the project with the higher IRR and then calculate how much less the NPV is by selecting the project with...
Nast Inc. is considering Projects S and L, whose cash flows are shown below. These projects...
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...
Solora Inc. is considering Projects X and Y, whose cash flows are shown below. These projects...
Solora Inc. is considering Projects X and Y, whose cash flows are shown below. These projects are equally risky. Firm;s WACC=10%. Year 0 1 2 3 4 CF-X −$1,100 $375 $375 $375 $375 CF-Y −$2,200 $725 $725 $725 $725 a) Calculate Payback Period for these two projects. Which one do you choose if the Threshold is less than 3 years? b) Calculate NPV for these two projects. Are they acceptable? Why? Which one do you choose if they are independent?...
Sexton Inc. is considering Projects S and L, whose cash flows are shown below. These projects...
Sexton 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 IRR, how much value will be forgone? Note that under certain conditions choosing projects on the basis of the IRR will not cause any value to be lost because the one with the higher IRR will also have the higher NPV, so no value...
Sexton Inc. is considering Projects S and L, whose cash flows are shown below. These projects...
Sexton 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 IRR, how much value will be forgone? Note that under certain conditions choosing projects on the basis of the IRR will not cause any value to be lost because the one with the higher IRR will also have the higher NPV, so no value...
Rumpelstiltskin Inc. is considering Projects K and Z, whose cash flows are shown below. These projects...
Rumpelstiltskin Inc. is considering Projects K and Z, whose cash flows are shown below. These projects are mutually exclusive, equally risky, and not repeatable. The CEO wants to use the IRR criterion, while the CFO favors the NPV method. You were hired to advise Rumpelstiltskin Inc on the best procedure. If the wrong decision criterion is used, how much potential value would Rumpelstiltskin Inc. lose? r. 8.50% Year 0 1 2 3 4 CFS −$1,052 $375 $375 $375 $375 CFL...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT