Question

In: Finance

A company is analyzing two mutually exclusive projects, S and L, with the following cash flows:...

A company is analyzing two mutually exclusive projects, S and L, with the following cash flows:

0 1 2 3 4
Project S -$1,000 $887.30 $240 $5 $10
Project L -$1,000 $10 $260 $380 $766.73

The company's WACC is 10.0%. What is the IRR of the better project? (Hint: The better project may or may not be the one with the higher IRR.) Round your answer to two decimal places.

%

Solutions

Expert Solution

The net present value is the capital budgeting technique used to evaluate mutually exclusive projects.

Project S

Net present value is solved here using a financial calculator. The steps to solve on the financial calculator:

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

The net present value at 10% weighted average cost of capital is $15.57.

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

  • Press the CF button.
  • CF0= -$1,000. 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 11.40%

Project L

Net present value is solved here using a financial calculator. The steps to solve on the financial calculator:

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

The net present value at 10% weighted average cost of capital is $33.15.

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

  • Press the CF button.
  • CF0= -$1,000. 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 11.10%

Project L is the better project since it has the highest net present value. The IRR of the project is 11.10%.

In case of any query, kindly comment on the solution.


Related Solutions

A company is analyzing two mutually exclusive projects, S and L, with the following cash flows:...
A company is analyzing two mutually exclusive projects, S and L, with the following cash flows: 0 1 2 3 4 Project S -$1,000 $868.78 $260 $15 $10 Project L -$1,000 $5 $240 $380 $812.00 The company's WACC is 10.5%. What is the IRR of the better project? (Hint: The better project may or may not be the one with the higher IRR.) Round your answer to two decimal places. ___%
A company is analyzing two mutually exclusive projects, S and L, with the following cash flows:...
A company is analyzing two mutually exclusive projects, S and L, with the following cash flows: 0 1 2 3 4 Project S -$1,000 $885.70 $250 $5 $15 Project L -$1,000 $5 $250 $380 $813.38 The company's WACC is 9.0%. What is the IRR of the better project? (Hint: The better project may or may not be the one with the higher IRR.) Round your answer to two decimal places.   %
A company is analyzing two mutually exclusive projects, S and L, with the following cash flows:...
A company is analyzing two mutually exclusive projects, S and L, with the following cash flows: 0 1 2 3 4 Project S -$1,000 $878.54 $260 $10 $5 Project L -$1,000 $0 $260 $400 $790.59 The company's WACC is 8.5%. What is the IRR of the better project? (Hint: The better project may or may not be the one with the higher IRR.) Round your answer to two decimal places. %
A company is analyzing two mutually exclusive projects, S and L, with the following cash flows:...
A company is analyzing two mutually exclusive projects, S and L, with the following cash flows: 0 1 2 3 4 Project S -$1,000 $890.46 $250 $5 $5 Project L -$1,000 $0 $250 $420 $789.52 The company's WACC is 9.5%. What is the IRR of the better project? (Hint: The better project may or may not be the one with the higher IRR.) Round your answer to two decimal places.
A company is analyzing two mutually exclusive projects, S and L, with the following cash flows:...
A company is analyzing two mutually exclusive projects, S and L, with the following cash flows: 0 1 2 3 4 Project S -$1,000 $870.58 $250 $10 $10 Project L -$1,000 $5 $240 $380 $793.73 The company's WACC is 8.0%. What is the IRR of the better project? (Hint: The better project may or may not be the one with the higher IRR.) Round your answer to two decimal places.
A company is analyzing two mutually exclusive projects, S and L, with the following cash flows:...
A company is analyzing two mutually exclusive projects, S and L, with the following cash flows: 0 1 2 3 4 Project S -$1,000 $886.01 $250 $15 $10 Project L -$1,000 $5 $240 $380 $819.83 The company's WACC is 9.0%. What is the IRR of the better project? (Hint: The better project may or may not be the one with the higher IRR.) Round your answer to two decimal places.
A company is analyzing two mutually exclusive projects, S and L, with the following cash flows:...
A company is analyzing two mutually exclusive projects, S and L, with the following cash flows: 0 1 2 3 4 Project S -$1,000 $856.03 $260 $15 $15 Project L -$1,000 $10 $260 $380 $762.25 The company's WACC is 9.0%. What is the IRR of the better project? (Hint: The better project may or may not be the one with the higher IRR.) Round your answer to two decimal places.
A company is analyzing two mutually exclusive projects, S and L, with the following cash flows:...
A company is analyzing two mutually exclusive projects, S and L, with the following cash flows: 0 1 2 3 4 Project S -$1,000 $876.35 $250 $15 $10 Project L -$1,000 $5 $240 $420 $837.90 The company's WACC is 8.0%. What is the IRR of the better project? (Hint: The better project may or may not be the one with the higher IRR.) Round your answer to two decimal places. %
A company is analyzing two mutually exclusive projects, S and L, with the following cash flows:...
A company is analyzing two mutually exclusive projects, S and L, with the following cash flows: 0 1 2 3 4 Project P -$1,000 $872.56 $250 $10 $10 Project Q -$1,000 $0 $260 $380 $863.80 The company's WACC is 9.0%. What is the IRR of the better project? (Hint: The better project may or may not be the one with the higher IRR.) Round your answer to two decimal places.
A company is analyzing two mutually exclusive projects, S and L, with the following cash flows:...
A company is analyzing two mutually exclusive projects, S and L, with the following cash flows: 0 1 2 3 4 Project S -$1,000 $890.81 $240 $15 $5 Project L -$1,000 $5 $240 $400 $781.05 The company's WACC is 10.0%. What is the IRR of the better project? (Hint: The better project may or may not be the one with the higher IRR.) Round your answer to two decimal places. %
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT