Question

In: Finance

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?

Solutions

Expert Solution

a. Profitability Index                         0.96
Working:
Year Cash Inflow Discount factor Present Value of cash inflow
a b c=1.09^-a d=b*c
1 $         2,200 0.917431193 $         2,018.35
2 $         3,600 0.841679993 $         3,030.05
3 $         4,800 0.77218348 $         3,706.48
Total $         8,754.88
Profitability Index = Present Value of cash inflow / Initial cost
= $            8,754.88 / $ 9,100.00
=                         0.96
b. Profitability Index                         0.84
Working:
Year Cash Inflow Discount factor Present Value of cash inflow
a b c=1.16^-a d=b*c
1 $         2,200 0.862068966 $         1,896.55
2 $         3,600 0.743162901 $         2,675.39
3 $         4,800 0.640657674 $         3,075.16
Total $         7,647.10
Profitability Index = Present Value of cash inflow / Initial cost
= $            7,647.10 / $ 9,100.00
=                         0.84
c. Profitability Index                         0.74
Working:
Year Cash Inflow Discount factor Present Value of cash inflow
a b c=1.23^-a d=b*c
1 $         2,200 0.81300813 $         1,788.62
2 $         3,600 0.66098222 $         2,379.54
3 $         4,800 0.537383918 $         2,579.44
Total $         6,747.60
Profitability Index = Present Value of cash inflow / Initial cost
= $            6,747.60 / $ 9,100.00
=                         0.74

Related Solutions

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 −$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?
15. Calculating Profitability Index YEAR Cash flow 0 -$16700 1 9700 2 7800 3 4300 a....
15. Calculating Profitability Index YEAR Cash flow 0 -$16700 1 9700 2 7800 3 4300 a. What is the profitability index if the appropriate discount rate is 10% for the following cash flows? b. What if the discount rate is 15 percent? c. What if the discount rate is 22%?
Year Cash Flows 0 -17189 1 11331 2 9978 3 6764 What is the profitability index...
Year Cash Flows 0 -17189 1 11331 2 9978 3 6764 What is the profitability index for the set of cash flows if the relevant discount rate is 9 percent? (Do not round intermediate calculations and round your final answer to 3 decimal places. (e.g., 32.161)) Year Cash Flows 0 -68683 1 30297 2 31668 3 30408 What is the profitability index for the set of cash flows if the relevant discount rate is 10 percent? (Do not round intermediate...
Year Cash Flow 0 $0 1 $250 2 $400 3 $500 4 $600 5 $600 What...
Year Cash Flow 0 $0 1 $250 2 $400 3 $500 4 $600 5 $600 What is the present (Year 0) value if the opportunity cost (discount) rate is 10 percent? Add an outflow (or cost) of $1,000 at Year 0. What is the present value (or net present value) of the stream?
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....
Year Cash Flow 0 –$ 8,300 1 2,100 2 3,000 3 2,300 4 1,700 What is...
Year Cash Flow 0 –$ 8,300 1 2,100 2 3,000 3 2,300 4 1,700 What is the payback period for the set of cash flows given above? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32. Bronco, Inc., imposes a payback cutoff of three years for its international investment projects. Year Cash Flow (A) Cash Flow (B) 0 –$ 35,000 –$ 45,000 1 12,000 11,000 2 17,000 13,000 3 14,000 16,000 4 9,000 255,000...
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
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
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT