Question

In: Finance

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

Solutions

Expert Solution

Ans : Profitability Index measures the ratio of Present value of Future Cash flows to Initial Cost of Investment. It is also called as Profit Investment Ratio or Value Investment Ratio.

It is calculated as : Present Value of Cash Inflows / Present Value of Cash Outflows

a) If Discount Rate is 10%

Year Cash InFlow Present Value Factor @ 10% Present Value of Cash InFlows
1 $5,700 0.9091 $5,181.87
2 $3,200 0.8264 $2644.48
3 $5,700 0.7513 $4,282.41
Total $12,108.76


Profitability Index = $12,108.76 / $8,600 = 1.408

b) If Discount Rate is 14%

Year Cash InFlow Present Value Factor @ 14% Present Value of Cash InFlows
1 $5,700 0.8772 $5,000.04
2 $3,200 0.7695 $2,462.4
3 $5,700 0.6750 $3,847.50
Total $11,309.94

Profitability Index = $11,309.94 / $8,600 = 1.315

c) If Discount Rate is 24%

Year Cash InFlow Present Value Factor @ 24% Present Value of Cash InFlows
1 $5,700 0.8065 $4,597.05
2 $3,200 0.6504 $2,081.28
3 $5,700 0.5245 $2,989.65
Total $9,667.98

Profitability Index = $9,667.98 / $8,600 = 1.124


Ans : Profitiabality Index

At 10% = 1.408
At 14% = 1.315
At 24% = 1.124


Related Solutions

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 −$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?
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,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?
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?
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...
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....
Consider the cash flow for projects A and B Year: 0, 1, 2, 3, 4, 5...
Consider the cash flow for projects A and B Year: 0, 1, 2, 3, 4, 5 Project A: ($1000), 100, 600, 700, 900, 300 Project B: ($1000), 900, 700, 500, 300, 300 The cost of capital for both projects is 10% 1. Find NPV, IRR and profitability index (PI) of projects A and B. 2. If projects A and B are mutually exclusive, which project would you select 3. Find the crossover rate for projects A and B
Consider the cash flow for projects A and B Year: 0, 1, 2, 3, 4, 5
  Consider the cash flow for projects A and B Year: 0, 1, 2, 3, 4, 5 Project A: ($1000), 100, 600, 700, 900, 300 Project B: ($1000), 900, 700, 500, 300, 300 The cost of capital for both projects is 10% 1. Find NPV, IRR and profitability index (PI) of projects A and B. 2. If projects A and B are mutually exclusive, which project would you select 3. Find the crossover rate for projects A and B
Year Cash flow (€) 0 - Investment -? 1 150,000 2 150,000 3 4 150,000 ?...
Year Cash flow (€) 0 - Investment -? 1 150,000 2 150,000 3 4 150,000 ? Some years ago X AG paid €15’000 for a vacant lot with planning permission. The plot could easily be sold today for 10 times that amount. X AG has however a project in mind that would occupy the plot and require investment of €200,000 but generate positive cash flows of €150,000 for the next 4 years. X AG will be able to sell the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT