Question

Consider the following cash flows:    Year Cash Flow 0 $-7,700    1 4,000 2 4,100...

Consider the following cash flows:

  

Year Cash Flow
0 $-7,700   
1 4,000
2 4,100   
3 5,400   
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 18 percent?

C. What is the profitability index for the cash flows if the relevant discount rate is 24 percent?

0 0
Add a comment Improve this question Transcribed image text
Answer #1

M E6 foc =SUM(E2:E5) BC year Cash flows pv@9% Present value 0 $ (7,700.00) 1.0000 $ 11 $ 4,000.00 0.9174 $ 2 $ 4,100.00 0.841

E6 fc =SUM(E2:E5) B co year Cash flows pv@9% Present value O -7700 1 =C2*D2 1 4000 =D2/1.09 =C3*D3 |4100 =D3/1.09 =C4*D4 5400

Add a comment
Know the answer?
Add Answer to:
Consider the following cash flows:    Year Cash Flow 0 $-7,700    1 4,000 2 4,100...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Year WN-O Cash Flow -$7,700 4,000 5,900 2,100 a. What is the profitability index for the...

    Year WN-O Cash Flow -$7,700 4,000 5,900 2,100 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 19 percent? c. What is the profitability index for the cash flows if the relevant discount rate is 24 percent? A firm evaluates all of its projects by using the NPV decision rule. Year WN=0 Cash Flow -$29,000...

  • Year Cash Flow 0 −$7,700           1 5,100           2 5,100           3 4,400      &nb

    Year Cash Flow 0 −$7,700           1 5,100           2 5,100           3 4,400              Required : (a) What is the profitability index for the cashflows if the relevant discount rate is 9 percent? (Click to select)$1.687$1.606$1.526$1.558$1.655     (b) What is the profitability index for the cashflows if the relevant discount rate is 17 percent? (Click to select)$1.449$1.477$1.365$1.407$1.336     (c) What is the profitability index for the cashflows if the relevant discount rate is 27 percent? (Click to select)1.2471.2111.1511.1751.272

  • Year Cash Flow 0 −$9,900 1 5,400 2 3,200 3 4,900 Required : (a) What is...

    Year Cash Flow 0 −$9,900 1 5,400 2 3,200 3 4,900 Required : (a) What is the profitability index for the cashflows if the relevant discount rate is 9 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 22 percent?

  • Consider the following cash flows: Year Cash Flow 0 −$29,500 1 16,900 2 13,600 3 8,300...

    Consider the following cash flows: Year Cash Flow 0 −$29,500 1 16,900 2 13,600 3 8,300 a. What is the profitability index for the above set of cash flows if the relevant discount rate is 10 percent? (Do not round intermediate calculations and round your answer to 3 decimal places, e.g., 32.161.) b. What is the profitability index if the discount rate is 15 percent? (Do not round intermediate calculations and round your answer to 3 decimal places, e.g., 32.161.)...

  • Consider the following cash flows:    Year Cash Flow 0 –$ 28,600 1 15,100 2 13,800...

    Consider the following cash flows:    Year Cash Flow 0 –$ 28,600 1 15,100 2 13,800 3 10,200      What is the profitability index for the cash flows if the relevant discount rate is 11 percent? (Do not round intermediate calculations and round your answer to 3 decimal places, e.g., 32.161.)    Profitability index                What is the profitability index if the discount rate is 16 percent? (Do not round intermediate calculations and round your answer to 3 decimal...

  • Year Cash Flow 0 −$8,500 1 2,200 2 3,200 3 3,200 a. What is the profitability index for the cash flows if the relevant d...

    Year Cash Flow 0 −$8,500 1 2,200 2 3,200 3 3,200 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 14 percent? c. What is the profitability index for the cash flows if the relevant discount rate is 23 percent?

  • Year Cash Flow 0 −$7,400           1 2,100     &...

    Year Cash Flow 0 −$7,400           1 2,100           2 2,100           3 5,000              a. What is the profitability index for the cash flows if the relevant discount rate is 6 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 −$7,800           1 3,000           2 5,900           3 2,300      &nb

    Year Cash Flow 0 −$7,800           1 3,000           2 5,900           3 2,300           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 16 percent c. What is the profitability index for the cash flows if the relevant discount rate is 22 percent?

  • Year Cash Flow 0 −$7,100           1 5,500           2 2,600           3 2,100      &nb

    Year Cash Flow 0 −$7,100           1 5,500           2 2,600           3 2,100              a. What is the profitability index for the cash flows if the relevant discount rate is 11 percent?    b. What is the profitability index for the cash flows if the relevant discount rate is 14 percent?    c. What is the profitability index for the cash flows if the relevant discount rate is 25 percent?

  • Consider the following cash flows: Year Cash Flow -$29,500 14,200 14,700 11,100 2 3 a. What is the profitability ind...

    Consider the following cash flows: Year Cash Flow -$29,500 14,200 14,700 11,100 2 3 a. What is the profitability index for the cash flows if the relevant disCount rate is 10 percent? (Do not round intermediate calculations and round your answer to 3 decimal places, e.g., 32.161.) b. What is the profitability index if the discount rate is 15 percent? (Do not round intermediate calculations and round your answer to 3 decimal places, e.g., 32.161.) c. What is the profitability...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT