Question

In: Finance

NPV Your division is considering two investment projects, each of which requires an up-front expenditure of...

NPV

Your division is considering two investment projects, each of which requires an up-front expenditure of $17 million. You estimate that the investments will produce the following net cash flows:

Year Project A Project B
1 $  6,000,000 $20,000,000
2 10,000,000 10,000,000
3 20,000,000 7,000,000
  1. What are the two projects' net present values, assuming the cost of capital is 5%? Round your answers to the nearest dollar.
    Project A $  
    Project B $  

    What are the two projects' net present values, assuming the cost of capital is 10%? Round your answers to the nearest dollar.
    Project A $  
    Project B $  

    What are the two projects' net present values, assuming the cost of capital is 15%? Round your answers to the nearest dollar.
    Project A $  
    Project B $  
  2. What are the two projects' IRRs at these same costs of capital? Round your answers to two decimal places.
    Project A     %
    Project B     %

Solutions

Expert Solution

a.Project A

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

  • Press the CF button.
  • CF0= -$17,000,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 cost of capital of 5%.
  • Press the down arrow and CPT buttons to get the net present value.

Net Present value of cash flows at 5% the cost of capital is $15,061,332.47

Project B

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

  • Press the CF button.
  • CF0= -$17,000,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 cost of capital of 5%.
  • Press the down arrow and CPT buttons to get the net present value.

Net Present value of cash flows at 5% the cost of capital is $17,164,777.02.

2.Project A

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

  • Press the CF button.
  • CF0= -$17,000,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 cost of capital of 5%.
  • Press the down arrow and CPT buttons to get the net present value.

Net Present value of cash flows at 10% the cost of capital is $11,745,304.28.

Project B

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

  • Press the CF button.
  • CF0= -$17,000,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 cost of capital of 10%.
  • Press the down arrow and CPT buttons to get the net present value.

Net Present value of cash flows at 10% the cost of capital is $14,705,484.60.

3.Project A

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

  • Press the CF button.
  • CF0= -$17,000,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 cost of capital of 15%.
  • Press the down arrow and CPT buttons to get the net present value.

Net Present value of cash flows at 15% the cost of capital is $8,929,152.63.

Project B

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

  • Press the CF button.
  • CF0= -$17,000,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 cost of capital of 15%.
  • Press the down arrow and CPT buttons to get the net present value.

Net Present value of cash flows at 15% the cost of capital is $12,555,354.65.

b.Project A

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

  • Press the CF button.
  • CF0= -$17,000,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 button and CPT keys to get the IRR of the project.

The IRR is 38.77%.

Project B

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

  • Press the CF button.
  • CF0= -$17,000,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 button and CPT keys to get the IRR of the project.

The IRR is 67.65%.

In case of any query, kindly comment on the solution


Related Solutions

NPV Your division is considering two investment projects, each of which requires an up-front expenditure of...
NPV Your division is considering two investment projects, each of which requires an up-front expenditure of $15 million. You estimate that the investments will produce the following net cash flows: Year Project A Project B 1 $  5,000,000 $20,000,000 2 10,000,000 10,000,000 3 20,000,000 6,000,000 What are the two projects' net present values, assuming the cost of capital is 5%? Do not round intermediate calculations. Round your answers to the nearest dollar. Project A: $   Project B: $   What are the...
NPV Your division is considering two investment projects, each of which requires an up-front expenditure of...
NPV Your division is considering two investment projects, each of which requires an up-front expenditure of $17 million. You estimate that the investments will produce the following net cash flows: Year Project A Project B 1 $  4,000,000 $20,000,000 2 10,000,000 10,000,000 3 20,000,000 6,000,000 What are the two projects' net present values, assuming the cost of capital is 5%? Do not round intermediate calculations. Round your answers to the nearest dollar. Project A: $   Project B: $   What are the...
NPV Your division is considering two investment projects, each of which requires an up-front expenditure of...
NPV Your division is considering two investment projects, each of which requires an up-front expenditure of $23 million. You estimate that the investments will produce the following net cash flows: Year Project A Project B 1 $ 5,000,000 $20,000,000 2 10,000,000 10,000,000 3 20,000,000 6,000,000 What are the two projects' net present values, assuming the cost of capital is 5%? Round your answers to the nearest dollar. Project A $ Project B $ What are the two projects' net present...
NPV Your division is considering two investment projects, each of which requires an up-front expenditure of...
NPV Your division is considering two investment projects, each of which requires an up-front expenditure of $23 million. You estimate that the investments will produce the following net cash flows: Year Project A Project B 1 $  6,000,000 $20,000,000 2 10,000,000 10,000,000 3 20,000,000 8,000,000 What are the two projects' net present values, assuming the cost of capital is 5%? Round your answers to the nearest dollar. Project A $ Project B $ What are the two projects' net present values,...
1.NPV Your division is considering two investment projects, each of which requires an up-front expenditure of...
1.NPV Your division is considering two investment projects, each of which requires an up-front expenditure of $17 million. You estimate that the investments will produce the following net cash flows: Year Project A Project B 1 $ 6,000,000 $20,000,000 2 10,000,000 10,000,000 3 20,000,000 7,000,000 What are the two projects' net present values, assuming the cost of capital is 5%? Do not round intermediate calculations. Round your answers to the nearest dollar. Project A: $   Project B: $   What are...
Your division is considering two investment projects, each of which requires an up-front expenditure of $17...
Your division is considering two investment projects, each of which requires an up-front expenditure of $17 million. You estimate that the investments will produce the following net cash flows: Year Project A Project B 1 $ 5,000,000 $20,000,000 2 10,000,000 10,000,000 3 20,000,000 6,000,000 What are the two projects' net present values, assuming the cost of capital is 5%, 10% and 15%? What are the two projects' IRRs at these same costs of capital?
Your division is considering two investment projects, each of which requires an up-front expenditure of $17...
Your division is considering two investment projects, each of which requires an up-front expenditure of $17 million. You estimate that the investments will produce the following net cash flows: Year Project A Project B 1 $  5,000,000 $20,000,000 2 10,000,000 10,000,000 3 20,000,000 6,000,000 What are the two projects' net present values, assuming the cost of capital is 5%? Do not round intermediate calculations. Round your answers to the nearest dollar. Project A: $   Project B: $   What are the two...
Your division is considering two investment projects, each of which requires an up-front expenditure of $24...
Your division is considering two investment projects, each of which requires an up-front expenditure of $24 million. You estimate that the cost of capital is 11% and that the investments will produce the following after-tax cash flows (in millions of dollars): Year Project A Project B 1 5 20 2 10 10 3 15 8 4 20 6 What is the regular payback period for each of the projects? Round your answers to two decimal places. Project A Project B...
Your division is considering two investment projects, each of which requires an up-front expenditure of $20...
Your division is considering two investment projects, each of which requires an up-front expenditure of $20 million. You estimate that the investments will produce the following net cash flows: Year Project A Project B 1 $4,500,000 $20,000,000 2 10,000,000 10,000,000 3 20.000.000 6,500,000 What are the two project’s NPVs assuming the cost of capital is 3%, 12%, 17%? What are the two projects’ IRRs at those same costs of capital?
Your division is considering two facility investment projects, each of which requires an up-front expenditure of...
Your division is considering two facility investment projects, each of which requires an up-front expenditure of $15 million. You estimate that the investments will produce the following net cash flows: Year Project A Project B 1 $5,000,000 $20,000,000 2 $10,000,000 $10,000,000 3 $20,000,000 $6,000,000 What are the project's net present values, assuming the cost of the capital is a)10% b)5% )15%? What does this analysis tell you about the projects?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT