Question

In: Finance

Consider the following cash flows:    Year Cash Flow 0 $-28,400       1 15,300       2...

Consider the following cash flows:

  

Year Cash Flow
0 $-28,400      
1 15,300      
2 13,600      
3 10,000      

  

Requirement 1:

What is the profitability index for the above set of cash flows if the relevant discount rate is 8 percent? (Do not round intermediate calculations. Round your answer to 3 decimal places (e.g., 32.161).)

  

  Profitability index

  

  

Requirement 2:

What is the profitability index if the discount rate is 13 percent? (Do not round intermediate calculations.Round your answer to 3 decimal places (e.g., 32.161).)

    

  Profitability index

  

  

Requirement 3:

What is the profitability index if the discount rate is 22 percent? (Do not round intermediate calculations.Round your answer to 3 decimal places (e.g., 32.161).)

  

  Profitability index

  

Solutions

Expert Solution

Profitability Index= PV of future cash flows/Initial investment

Project A

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

  • Press the CF button.
  • CF0= -$28,400
  • 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 8%.
  • Press enter after that. Press the down arrow and CPT buttons to get the net present value.

The present value of cash flows is $5,364.50.

Profitability Index= $5,364.50/ $28,400 = 0.19

Project B

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

  • Press the CF button.
  • CF0= -$28,400
  • 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 $2,721.12.

Profitability Index= $2,721.12/ $28,400 = 0.0958 0.10.

Project C

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

  • Press the CF button.
  • CF0= -$28,400
  • 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 22%.
  • Press enter after that. Press the down arrow and CPT buttons to get the net present value.

The present value of cash flows is -$1,21.62.

Profitability Index= -$1,21.62/ $28,400 = -0.04.

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


Related Solutions

Question 1 Consider a project with the following cash flows: Year Cash Flow 0 R17,500 1...
Question 1 Consider a project with the following cash flows: Year Cash Flow 0 R17,500 1 -80,500 2 138,425 3 -105,455 4 30,030 Required: 1.1.Fill in the following table: Cost of Capital (%) Project NPV 0 5 10 15 20 25 30 35 50 1.2.Use the values developed in part (1.1) to draw an NPV profile for this project. 1.3.What is the IRR for this project? 1.4.Describe the conditions under which the company should accept this project.
Consider the following investment cash flows: Year Cash Flow 0 ($16,000) 1 3,000 2 4,000 3...
Consider the following investment cash flows: Year Cash Flow 0 ($16,000) 1 3,000 2 4,000 3 5,000 4 6,000 5 7,000 a. What is the return expected on this investment measured in dollar terms if the opportunity cost is 6%. b. What is the return on this investment measured in percentage terms? c. Is the investment profitable? Explain your answer.
Consider the following cash flows: Year 0 1 2 3 4 5 6 Cash Flow -$10,000...
Consider the following cash flows: Year 0 1 2 3 4 5 6 Cash Flow -$10,000 $2,200 $3,300 $2,500 $2,500 $2,300 $2,100 A. Payback The company requires all projects to payback within 3 years. Calculate the payback period. Should it be accepted or rejected? B. Discounted Payback Calculate the discounted payback using a discount rate of 10%. Should it be accepted or rejected? C. IRR Calculate the IRR for this project. Should it be accepted or rejected? D. NPV Calculate...
Consider the following two projects: Project Year 0 Cash Flow Year 1 Cash Flow Year 2...
Consider the following two projects: Project Year 0 Cash Flow Year 1 Cash Flow Year 2 Cash Flow Year 3 Cash Flow Year 4 Cash Flow Discount Rate A -100 40 50 60 N/A .15 B -73 30 30 30 30 .15 Assume that projects A and B are mutually exclusive. The correct investment decision and the best rational for that decision is to: Group of answer choices a.invest in project A since NPVB < NPVA. b.invest in project B...
There is a project with the following cash flows : Year Cash Flow 0 −$21,800 1...
There is a project with the following cash flows : Year Cash Flow 0 −$21,800 1 6,300 2 7,350 3 6,750 4 4,400 What is the payback period? Multiple Choice a. 4.00 years b. 3.32 years c. 3.74 years d. 3.56 years e. 2.79 years
There is a project with the following cash flows : Year Cash Flow 0 −$23,700 1...
There is a project with the following cash flows : Year Cash Flow 0 −$23,700 1 7,000 2 7,700 3 7,100 4 5,100 What is the payback period? Multiple Choice 2.73 years 4.00 years 3.81 years 3.63 years 3.37 years
A project has the following cash flows: Year Cash Flow 0 –$ 16,100 1 6,800 2...
A project has the following cash flows: Year Cash Flow 0 –$ 16,100 1 6,800 2 8,100 3 6,600 What is the NPV at a discount rate of zero percent? (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) NPV $ What is the NPV at a discount rate of 11 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) NPV $ What is the NPV...
A project has the following cash flows: Year Cash Flow 0 $ 73,000 1 –54,000 2...
A project has the following cash flows: Year Cash Flow 0 $ 73,000 1 –54,000 2 –27,600 What is the IRR for this project? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Internal rate of return             % What is the NPV of this project if the required return is 5 percent? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round...
A project has the following cash flows:    Year Cash Flow 0 $64,100 1 –30,100 2...
A project has the following cash flows:    Year Cash Flow 0 $64,100 1 –30,100 2 –48,100    a. What is the IRR for this project?    b. What is the NPV of this project, if the required return is 11.5 percent?    c. NPV at 0 percent?    d. NPV at 23 percent?
A project has the following cash flows: Year Cash Flow 0 –$ 15,600 1 6,300 2...
A project has the following cash flows: Year Cash Flow 0 –$ 15,600 1 6,300 2 7,600 3 6,100     What is the NPV at a discount rate of zero percent? (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.)      NPV $       What is the NPV at a discount rate of 9 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)      NPV $   ...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT