You are choosing between two projects. The cash flows for the projects are given in the...

Question

Question

You are choosing between two projects. The cash flows for the projects are given in the following table ($ million): Project

Answer 1

Answer #1

B10 : X V fx =IRR(B4:B8) HI B C D E F 1 Cash flows Present value 2 Year Project A Project B PVIF@4.7% Project A | Project B 3

Please rate thumbs up

Add a comment

Answer 2

Similar Homework Help Questions

You are choosing between two projects. The cash flows for the projects are given in the...

You are choosing between two projects. The cash flows for the projects are given in the following table ($ million): Project Year 0 Year 1 Year 2 -$52 $26 $22 - $102 $20 $41 Year 4 Year 3 $21 $49 $14 $58 a. What are the IRRs of the two projects? b. If your discount rate is 5.5%, what are the NPVs of the two projects? c. Why do IRR and NPV rank the two projects differently? a. What are...
You are choosing between two projects. The cash flows for the projects are given in the...

You are choosing between two projects. The cash flows for the projects are given in the following table ($ million): Project Year 0 - $49 - $98 Year 1 $26 $20 Year 2 $20 $39 Year 3 $19 $49 Year 4 $16 $61 a. What are the IRRs of the two projects? b. If your discount rate is 4.7%, what are the NPVs of the two projects? c. Why do IRR and NPV rank the two projects differently? a. What...
You are choosing between two projects. The cash flows for the projects are given in the...

You are choosing between two projects. The cash flows for the projects are given in the following table ($ million): Project Year 0 Year 1 Year 2 Year 3 Year 4 A −$48 $ 26 $ 18 $22 $ 13 B −$102 $ 20 $ 42 $50 $61 a. What are the IRRs of the two projects? b. If your discount rate is 4.7 % 4.7%, what are the NPVs of the two projects? c. Why do IRR and NPV...

You are choosing between two projects. The cash flows for the projects are given in the...

You are choosing between two projects. The cash flows for the projects are given in the following table ($ milion); Project Year Year 2 Year o -$48 - $101 Year 3 $21 $50 Year 4 $14 $27 $20 $40 $62 Tes a What are the IRRs of the two projects? b. If your discount rate is 4.7%, what are the NPVs of the two projects? c. Why do IRR and NPV rank the two projects differently? a. What are the...
You are choosing between two projects. The cash flows for the projects are given in the...

You are choosing between two projects. The cash flows for the projects are given in the following table ($ million): Project Year 0 - $49 - $101 Year 1 $26 $18 Year 2 $19 $42 Year 3 $21 $52 Year 4 $17 $61 a. What are the IRRs of the two projects? b. If your discount rate is 5.2%, what are the NPVs of the two projects? c. Why do IRR and NPV rank the two projects differently? a. What...
You are choosing between two projects. The cash flows for the projects are given in the...

You are choosing between two projects. The cash flows for the projects are given in the following table (S million) Year 1 Project Year 0 Year 2 Year 3 Year 4 $15 -$49 - $102 $24 $21 $19 $38 $18 $52 $60 a. What are the IRRS of the two projects? b. If your discount rate is 5.2%, what are the NPVS of the two projects? c. Why do IRR and NPV rank the two projects differently?

You are choosing between two projects. The cash flows for the projects are given in the...

You are choosing between two projects. The cash flows for the projects are given in the following table ($ million): Year 1 Year 2 Year 3 Year 4 Project A Year 0 - $50 - $100 $27 $19 $18 $38 $21 $49 $17 $58 В a. What are the IRRS of the two projects? b. If your discount rate is 4.8%, what are the NPVS of the two projects? c. Why do IRR and NPV rank the two projects differently?
You are choosing between two projects. The cash flows for the projects are given in the...

You are choosing between two projects. The cash flows for the projects are given in the following table ($ million): Project Year 0 Year 1 Year 2 Year 3 Year 4 - $50 $18 $19 $17 - $101 $21 $40 $51 $26 $59 a. What are the IRRs of the two projects? b. If your discount rate is 5.1%, what are the NPVs of the two projects? c. Why do IRR and NPV rank the two projects differently? a. What...
You are choosing between two projects. The cash flows for the projects are given in the...

You are choosing between two projects. The cash flows for the projects are given in the following table (s million) Project Year 1 Year 3 Year 0 -$50 - $99 Year 2 $20 $25 $18 Year 4 $16 $19 $442 $49 a. What are the IRRs of the two projects? b. If your discount rate is 53% what are the NPVs of the two projects? c. Why do IRR and NPV rank the two projects differently? a. What are the...

You are choosing between two projects. The cash flows for the projects are given in the...

You are choosing between two projects. The cash flows for the projects are given in the following table (S million): Project A Year 0 Year 1 Year 2 Year 3 Year 4 $25 $22 -$49 -$98 $19 $48 $17 $60 B $20 $42 a. What are the IRRS of the two projects? b. If your discount rate is 4.6%, what are the NPVS of the two projects? c. Why do IRR and NPV rank the two projects differently? a. What...