Year Cash Flow 0 −$9,600 1 5,600 2 4,000 3 4,800 &nb

Year	Cash Flow
0	−$9,600
1	5,600
2	4,000
3	4,800

a. What is the profitability index for the cash flows if the relevant discount rate is 10 percent?

b. What is the profitability index for the cash flows if the relevant discount rate is 17 percent?

c. What is the profitability index for the cash flows if the relevant discount rate is 25 percent?

Expert Solution

Profitability index is Present value of future cashflows divided by initial investment.

A profitability index greater than 1 is deemed as good investment.

a) When relevant discount rate is 10%

Years	cash Flows	Discount factor @ 10%	Present value
1	5600	0.909090909	5090.909091
2	4000	0.826446281	3305.785124
3	4800	0.751314801	3606.311044
			12003.00526
Profitability index= $12003/$9600 = 1.25

b) When relevant discount rate is 17%

Years	cash Flows	Discount factor @ 17%	Present value
1	5600	0.854700855	4786.324786
2	4000	0.730513551	2922.054204
3	4800	0.624370556	2996.978671
			10705.35766
Profitability Index = $10705.36/$9600 = 1.115

c) When relevant discount rate is 25%

Years	cash Flows	Discount factor @ 25%	Present value
1	5600	0.8	4480
2	4000	0.64	2560
3	4800	0.512	2457.6
			9497.6
Profitability Index= $9497.6/$9600 = 0.989

jeff jeffy answered 3 years ago

Year Cash Flow 0 −$9,600 1 2,600 2 3,700 3 3,900 &nb

Year Cash Flow 0 −$9,600 1 2,600 2 3,700 3 3,900 (a) What is the profitability index for the cashflows if the relevant discount rate is 9 percent? $0.842 $0.931 $0.913 $0.887 $0.86 (b) What is the profitability index for the cashflows if the relevant discount rate is 15 percent? $0.834 $0.754 $0.794 $0.818 $0.77 (c) What is the profitability index for the cashflows if the relevant discount rate is 27 percent? 0.67 0.651 0.683 0.618 0.631

Year Cash Flow 0 −$9,100 1 2,200 2 3,600 3 4,800 a. What is the profitability...

Year Cash Flow 0 −$9,100 1 2,200 2 3,600 3 4,800 a. What is the profitability index for the cash flows if the relevant discount rate is 9 percent? b. What is the profitability index for the cash flows if the relevant discount rate is 16 percent? c. What is the profitability index for the cash flows if the relevant discount rate is 23 percent?

Year Cash Flow 0 −$8,600 1 5,700 2 3,200 3 5,700 &nb

Year Cash Flow 0 −$8,600 1 5,700 2 3,200 3 5,700 Required : (a) What is the profitability index for the cashflows if the relevant discount rate is 10 percent? (Click to select) $1.45 $1.408 $1.338 $1.478 $1.366 (b) What is the profitability index for the cashflows if the relevant discount rate is 14 percent? (Click to select) $1.249 $1.381 $1.315 $1.355 $1.276 (c) What is the profitability index for the cashflows if the relevant discount rate is 24 percent? (Click to select) 1.158 1.068 1.18 1.124 1.09

Year Cash Flow 0 −$7,800 1 4,300 2 5,200 3 3,200 &nb

Year Cash Flow 0 −$7,800 1 4,300 2 5,200 3 3,200 a. What is the profitability index for the cash flows if the relevant discount rate is 8 percent? b. What is the profitability index for the cash flows if the relevant discount rate is 16 percent? c. What is the profitability index for the cash flows if the relevant discount rate is 25 percent?

Year Cash Flow 0 −$9,700 1 5,800 2 2,500 3 3,400 &nb

Year Cash Flow 0 −$9,700 1 5,800 2 2,500 3 3,400 Required : (a) What is the profitability index for the cashflows if the relevant discount rate is 10 percent? (b) What is the profitability index for the cashflows if the relevant discount rate is 18 percent? (c) What is the profitability index for the cashflows if the relevant discount rate is 23 percent?

Year Cash Flow 0 −$8,600 1 4,400 2 4,700 3 4,000 a. What is the profitability...

Year Cash Flow 0 −$8,600 1 4,400 2 4,700 3 4,000 a. What is the profitability index for the cash flows if the relevant discount rate is 7 percent? b. What is the profitability index for the cash flows if the relevant discount rate is 15 percent? c. What is the profitability index for the cash flows if the relevant discount rate is 22 percent?

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.

Time Cash Flow 0 (362,000) 1 103,000 2 108,000 3 &nb

Time Cash Flow 0 (362,000) 1 103,000 2 108,000 3 116,000 4 133,000 5 142,000 What are the investment’s payback period, IRR, and NPV, assuming the firm’s WACC is 12%?- show working how you get these calculation. If the firm requires a payback period of less than 3 years, should this project be accepted? Be sure to justify your choice. Based on the IRR and NPV rules, should this project be accepted? Be sure...

For the following set of cash flows, Year Cash Flow 0 –$8,700 Year1 Cash Flow $5,600...

For the following set of cash flows, Year Cash Flow 0 –$8,700 Year1 Cash Flow $5,600 Year 2 Cash Flow $6,100 Year 3 Cash Flow $4,300 a. What is the NPV at a discount rate of 0 percent? b. What is the NPV at a discount rate of 12 percent? c. What is the NPV at a discount rate of 24 percent? d. What is the NPV at a discount rate of 29 percent?

Discounted Cash Flow: Year (n) 0 1 2 3 4 Undiscounted cash flow -$600,000 $200,000 $200,000...

Discounted Cash Flow: Year (n) 0 1 2 3 4 Undiscounted cash flow -$600,000 $200,000 $200,000 $200,000 $200,000 DCF @ 11% ∑DCF @11% DCF @ 13% ∑DCF @13% DCF @ 15% ∑DCF @15% Notes: DCF = Discounted Cash Flow ∑DCF = Cumulative Discounted Cash Flow Refer to the following video on how to calculate IRR with Excel. Provide your completed spreadsheet in the space below. Alternatively, do the exercise in Excel and enter the values back into the table above....

Question