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 $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.

Solutions

Expert Solution

The net present value is the capital budgeting criteria used to make a decision in case of mutually exclusive projects.

Project S

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

  • Press the CF button.
  • CF0= -$1,000. Indicate the initial cash flow by 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%.
  • Press enter after that. Press the down arrow and CPT buttons to get the net present value.  

Net present value at 9% weighted average cost of capital is $41.94.

Project L

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

  • Press the CF button.
  • CF0= -$1,000. Indicate the initial cash flow by 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%.
  • Press enter after that. Press the down arrow and CPT buttons to get the net present value.  

Net present value at 9% weighted average cost of capital is $80.81.

Project L is the better project since it generates the largest net present value.

Project L

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

  • Press the CF button.
  • CF0= -$1,000. The initial cash flow is indicated by a negative sign since it is a cash outflow.  
  • Cash flow for each of the fifteen years 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 the project is 11.57%.

                                                                                                                                    


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 $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. %
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 $877.71 $250 $15 $10 Project L -$1,000 $10 $240 $380 $842.17 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.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT