Question

In: Finance

You are choosing between two mutually exclusive projects: Year Cash Flow (I) Cash Flow (II) 0...

You are choosing between two mutually exclusive projects:

Year Cash Flow (I) Cash Flow (II)
0 –$78,000       –$36,000      
1 30,000       12,000      
2 38,000       25,500      
3 44,000       19,500      
Requirement 1:
(a)

If the required return is 13 percent, what is the profitability index for each project? (Do not round intermediate calculations. Round your answers to 3 decimal places (e.g., 32.161).)

Profitability index
  Project I     
  Project II     
(b)

If the required return is 13 percent and the company applies the profitability index decision rule, which project should the firm accept?

(Click to select)Project IProject II

Requirement 2:
(a)

If the required return is 13 percent, what is the NPV for each project? (Do not round intermediate calculations. Round your answers to 2 decimal places (e.g., 32.16).)

Net present value
  Project I $     
  Project II $     

Solutions

Expert Solution

a.Project I

PV of future cash flows is calculated using a financial calculator by inputting the below:

  • Press the CF button.
  • CF0= -$78,000.
  • 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 discount rate of 13%.
  • Press enter after that. Press the down arrow and CPT buttons to get the net present value.

The present value of cash flows is $8,802.45.

Profitability Index= $8,802.45/ $78,000 = 0.11.

Project II

PV of future cash flows is calculated using a financial calculator by inputting the below:

  • Press the CF button.
  • CF0= -$36,000.
  • 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 required return of 13%.
  • Press enter after that. Press the down arrow and CPT buttons to get the net present value.

The present value of cash flows is $8,104.19.

Profitability Index= $8,104.19/ $36,000 = 0.23.

b.The company should accept Project II since it has the higher profitability index.

c. Project I

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

  • Press the CF button.
  • CF0= -$78,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 required return of 13%.
  • Press the down arrow and CPT buttons to get the net present value.

Present value of cash flows at 13% required return is $8,802.45.

Project II

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

  • Press the CF button.
  • CF0= -$36,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 required return of 13%.
  • Press the down arrow and CPT buttons to get the net present value.

Present value of cash flows at 13% required return is $8,104.19.

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


Related Solutions

Consider the following two mutually exclusive projects: Year Cash Flow (Project I) Cash Flow (Project II)...
Consider the following two mutually exclusive projects: Year Cash Flow (Project I) Cash Flow (Project II) 0 -$12,300 -$44,000 1 $1,800 $14,000 2 $6,000 $30,000 3 $2,000 $5,000 4 $5,000 $10,000 5 $7,000 $5,000 The required return is 10% for both projects. Assume that the internal rate of return (IRR) of Project I and Project II is 18% and 15%, respectively. a) Which project will you choose if you apply the NPV criterion? Why? b) Which project will you choose...
Consider the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B) 0 –$...
Consider the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B) 0 –$ 364,000 –$ 52,000 1 46,000 25,000 2 68,000 22,000 3 68,000 21,500 4 458,000 17,500 Whichever project you choose, if any, you require a return of 11 percent on your investment. a-1. What is the payback period for each project? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.)    a-2. If you apply the payback criterion, which...
Consider the following two mutually exclusive projects:    Year Cash Flow (A) Cash Flow (B) 0...
Consider the following two mutually exclusive projects:    Year Cash Flow (A) Cash Flow (B) 0 –$199,124        –$15,993          1 25,800        5,691          2 51,000        8,855          3 54,000        13,391          4 416,000        8,695             Whichever project you choose, if any, you require a 6 percent return on your investment. a. What is the payback period for Project A?     b. What is the payback period for Project B? c. What is the discounted...
Consider the following two mutually exclusive projects:    Year Cash Flow (A) Cash Flow (B) 0...
Consider the following two mutually exclusive projects:    Year Cash Flow (A) Cash Flow (B) 0 –$ 360,000 –$ 45,000 1 35,000 23,000 2 55,000 21,000 3 55,000 18,500 4 430,000 13,600    Whichever project you choose, if any, you require a 14 percent return on your investment.    a-1 What is the payback period for each project? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.)    Payback period   Project A years     Project...
Consider the following two mutually exclusive projects:    Year Cash Flow (A) Cash Flow (B) 0...
Consider the following two mutually exclusive projects:    Year Cash Flow (A) Cash Flow (B) 0 –$260,730        –$15,011          1 27,800        4,942          2 56,000        8,023          3 55,000        13,040          4 426,000        9,138             Whichever project you choose, if any, you require a 6 percent return on your investment. a. What is the payback period for Project A?     b. What is the payback period for Project B? c. What is the discounted...
Consider the following two mutually exclusive projects:    Year Cash Flow (A) Cash Flow (B) 0...
Consider the following two mutually exclusive projects:    Year Cash Flow (A) Cash Flow (B) 0 –$251,835        –$15,247          1 25,100        4,828          2 55,000        8,358          3 50,000        13,472          4 385,000        8,102             Whichever project you choose, if any, you require a 6 percent return on your investment. a.What is the discounted payback period for Project A? b.What is the discounted payback period for Project B?
Consider the following two mutually exclusive projects:    Year Cash Flow (A) Cash Flow (B) 0...
Consider the following two mutually exclusive projects:    Year Cash Flow (A) Cash Flow (B) 0 –$251,835        –$15,247          1 25,100        4,828          2 55,000        8,358          3 50,000        13,472          4 385,000        8,102             Whichever project you choose, if any, you require a 6 percent return on your investment. a.What is the discounted payback period for Project A? b.What is the discounted payback period for Project B?
Consider the following two mutually exclusive projects:    Year Cash Flow (A) Cash Flow (B) 0...
Consider the following two mutually exclusive projects:    Year Cash Flow (A) Cash Flow (B) 0 –$216,888        –$15,026          1 26,900        4,016          2 51,000        8,270          3 54,000        13,423          4 420,000        9,668             Whichever project you choose, if any, you require a 6 percent return on your investment. a. What is the payback period for Project A?     b. What is the payback period for Project B? c. What is the discounted...
Consider the following two mutually exclusive projects:    Year Cash Flow (A) Cash Flow (B) 0...
Consider the following two mutually exclusive projects:    Year Cash Flow (A) Cash Flow (B) 0 –$ 345,000 –$ 48,500 1 50,000 24,500 2 70,000 22,500 3 70,000 20,000 4 445,000 15,100    Whichever project you choose, if any, you require a 14 percent return on your investment.    a-1 What is the payback period for each project? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.)    Payback period   Project A years     Project...
Consider the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B) 0 –$...
Consider the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B) 0 –$ 430,000 –$ 74,000 1 78,000 32,000 2 98,000 30,000 3 73,000 27,500 4 448,000 22,600 Whichever project you choose, if any, you require a 15% return on your investment. a-1. What is the payback period for each project? (Round the final answers to 2 decimal places.) Payback Period Project A years Project B years a-2. If you apply the payback criterion, which investment will...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT