Question

In: Finance

NPV and IRR Analysis Cummings Products Company is considering two mutually exclusive investments whose expected net...

NPV and IRR Analysis Cummings Products Company is considering two mutually exclusive investments whose expected net cash flows are as follows: EXPECTED NET CASH FLOWS Year Project A Project B 0 -$400 -$650 1 -528 210 2 -219 210 3 -150 210 4 1,100 210 5 820 210 6 990 210 7 -325 210 What is each project's IRR? Do not round intermediate calculations. Round your answers to two decimal places. Project A: % Project B: % Calculate the two projects' NPVs, if each project's cost of capital was 10%. Do not round intermediate calculations. Round your answers to the nearest cent. Project A: $ Project B: $ Which project, if either, should be selected? should be selected. Calculate the two projects' NPVs, if each project's cost of capital was 17%. Do not round intermediate calculations. Round your answers to the nearest cent. Project A: $ Project B: $ What would be the proper choice? is the proper choice. What is each project's MIRR at a cost of capital of 10%? (Hint: Consider Period 7 as the end of Project B's life.) Do not round intermediate calculations. Round your answers to two decimal places. Project A: % Project B: % What is each project's MIRR at a cost of capital of 17%? (Hint: Consider Period 7 as the end of Project B's life.) Do not round intermediate calculations. Round your answers to two decimal places. Project A: % Project B: % What is the crossover rate? Do not round intermediate calculations. Round your answer to two decimal places. % What is its significance? I. The crossover rate has no significance in capital budgeting analysis. II. If the cost of capital is greater than the crossover rate, both the NPV and IRR methods will lead to the same project selection. III. If the cost of capital is less than the crossover rate, both the NPV and IRR methods lead to the same project selections. Check My Work (1 remaining) Icon Key Previous Question 6 of 7 NextProblem 12-13 (NPV and IRR Analysis)

Solutions

Expert Solution

Machines A B
Year cash flow cash flow
0 -400 -650
1 -528 210
2 -219 210
3 -150 210
4 1100 210
5 820 210
6 990 210
7 325 210
IRR = Using IRR function in MS excel =irr(cell reference cash flow year 0: cell reference year 7) 25.22% IRR = Using IRR function in MS excel =irr(cell reference cash flow year 0: cell reference year 7) 25.84%
NPV at 10% = Using NPV function in MS excel =npv(rate, cash flow year 0, cash flow year 1, cash flow year 2………………………………….cash flow year 7) NPV(10%,-400,-528,-219,-150,1100,820,990,325) $738.53 NPV = Using NPV function in MS excel =npv(rate, cash flow year 0, cash flow year 1, cash flow year 2………………………………….cash flow year 7) $338.52 $338.52
On the basis of NPV Project A should be selected
NPV at 17% = Using NPV function in MS excel =npv(rate, cash flow year 0, cash flow year 1, cash flow year 2………………………………….cash flow year 7) NPV(17%,-400,-528,-219,-150,1100,820,990,325) $299.43 NPV = Using NPV function in MS excel =npv(rate, cash flow year 0, cash flow year 1, cash flow year 2………………………………….cash flow year 7) NPV(17%,-650,210,210,210,210,210,210,210) $148.46
On the basis of NPV Project A should be selected
MIRR at 10% = Using MIRR function in MS excel =MIRR(cell reference cash flows,finance rate,reinvestment rate) (cell reference Year 0 cash flow:cell reference year 7 cash flow,10%,10%) 18.58% MIRR = Using MIRR function in MS excel =MIRR(cell reference cash flows,finance rate,reinvestment rate) (cell reference Year 0 cash flow:cell reference year 7 cash flow,10%,10%) 17.35%
MIRR at 17% = Using MIRR function in MS excel =MIRR(cell reference cash flows,finance rate,reinvestment rate) (cell reference Year 0 cash flow:cell reference year 7 cash flow,17%,17%) 29.77% MIRR = Using MIRR function in MS excel =MIRR(cell reference cash flows,finance rate,reinvestment rate) (cell reference Year 0 cash flow:cell reference year 7 cash flow,10%,10%) 21.03%
Year A B
cash flow cash flow incremental cash flow
0 -400 -650 -250
1 -528 210 738
2 -219 210 429
3 -150 210 360
4 1100 210 -890
5 820 210 -610
6 990 210 -780
7 325 210 -115
crossover rate = Using IRR function in MS excel =irr(cell reference incremntal cash flow year 0: cell reference year 7 incremental cash flow) 24.64%
III. If the cost of capital is less than the crossover rate, both the NPV and IRR methods lead to the same project selections.

Related Solutions

NPV and IRR Analysis Cummings Products Company is considering two mutually exclusive investments whose expected net...
NPV and IRR Analysis Cummings Products Company is considering two mutually exclusive investments whose expected net cash flows are as follows: EXPECTED NET CASH FLOWS Year Project A Project B 0 -$340 -$630 1 -528 210 2 -219 210 3 -150 210 4 1,100 210 5 820 210 6 990 210 7 -325 210     What is each project's IRR? Do not round intermediate calculations. Round your answers to two decimal places. Project A:   % Project B:   % Calculate the two projects'...
NPV and IRR Analysis Cummings Products Company is considering two mutually exclusive investments whose expected net...
NPV and IRR Analysis Cummings Products Company is considering two mutually exclusive investments whose expected net cash flows are as follows: EXPECTED NET CASH FLOWS Year Project A Project B 0 -$280 -$430 1 -387 134 2 -193 134 3 -100 134 4 600 134 5 600 134 6 850 134 7 -180 134 What is each project's IRR? Do not round intermediate calculations. Round your answers to two decimal places. Project A  % Project B  % Calculate the two projects' NPVs,...
Cummings Products Company is considering two mutually exclusive investments whose expected net cash flows are as...
Cummings Products Company is considering two mutually exclusive investments whose expected net cash flows are as follows: Year Project A Project B 0 -430 -680 1 -528 210 2 -219 210 3 -150 210 4 1100 210 5 820 210 6 990 210 7 -325 210 a.) What is each project's IRR? Do not round intermediate calculations. Round your answers to two decimal places. b.) Calculate the two projects' NPVs, if each project's cost of capital was 11%. Do not...
Practice Problem: Cummings Products is considering two mutually exclusive investments whose expected net cash flows are...
Practice Problem: Cummings Products is considering two mutually exclusive investments whose expected net cash flows are as follows: Expected Net Cash Flows Year Project A Project B 0 -400 -650 1 -528 210 2 -219 210 3 -150 210 4 1100 210 5 820 210 6 990 210 7 -325 210 Construct the NPV profiles for Project A and B What is each project’s IRR? If each project’s cost of capital were 10%, which project, if either, should be selected?...
The company is considering two mutually exclusive investments in plant expansion projects. The projects’ expected net...
The company is considering two mutually exclusive investments in plant expansion projects. The projects’ expected net cash flows are as follows: Expected Net Cash Flows Year Project A Project B 0 -9,000 -7,000 1 2,000 3,000 2 4,000 3,000 3 6,000 3,000 Construct NPV profiles for Projects A and B assuming that each project’s cost of capital is 10%. What is each project’s IRR? Which project should be selected? Rank the projects according to their NPV Rank the projects according...
Flower Engineering is considering two mutually exclusive investments. The projects' expected net cash flows are as...
Flower Engineering is considering two mutually exclusive investments. The projects' expected net cash flows are as follows: Expected Net Cash Flows                                                                                                                              Time      Project A              Project B                                                                                                              0              ($400)                 ($700)                                                                                                    1              ($280)                   $201                                                                                                      2              ($200)                   $202                                                                                                      3              ($100)                   $203                                                                                                      4              $600                      $204                                                                                                      5              $600                      $205                                                                                                      6              $925                      $206                                                                                                      7              ($170)                   $207 In your report, identify which project would be selected (assuming they...
Flower Engineering is considering two mutually exclusive investments. The projects' expected net cash flows are as...
Flower Engineering is considering two mutually exclusive investments. The projects' expected net cash flows are as follows: Expected Net Cash Flows                                                                                                                              Time      Project A              Project B                                                                                                              0              ($400)                 ($700)                                                                                                    1              ($280)                   $201                                                                                                      2              ($200)                   $202                                                                                                      3              ($100)                   $203                                                                                                      4              $600                      $204                                                                                                      5              $600                      $205                                                                                                      6              $925                      $206                                                                                                      7              ($170)                   $207 In your report, identify which project would be selected (assuming they...
Flower Engineering is considering two mutually exclusive investments. The projects' expected net cash flows are as...
Flower Engineering is considering two mutually exclusive investments. The projects' expected net cash flows are as follows: Expected Net Cash Flows                                                                                                                              Time      Project A              Project B                                                                                                              0              ($400)                 ($700)                                                                                                    1              ($280)                   $201                                                                                                      2              ($200)                   $202                                                                                                      3              ($100)                   $203                                                                                                      4              $600                      $204                                                                                                      5              $600                      $205                                                                                                      6              $925                      $206                                                                                                      7              ($170)                   $207 In your report, identify which project would be selected (assuming they...
Flower Engineering is considering two mutually exclusive investments. The projects' expected net cash flows are as...
Flower Engineering is considering two mutually exclusive investments. The projects' expected net cash flows are as follows: Expected Net Cash Flows                                                                                                                              Time      Project A              Project B                                                                                                              0              ($400)                 ($700)                                                                                                    1              ($280)                   $201                                                                                                      2              ($200)                   $202                                                                                                      3              ($100)                   $203                                                                                                      4              $600                      $204                                                                                                      5              $600                      $205                                                                                                      6              $925                      $206                                                                                                      7              ($170)                   $207 In your report, identify which project would be selected (assuming they...
Flower Engineering is considering two mutually exclusive investments. The projects' expected net cash flows are as...
Flower Engineering is considering two mutually exclusive investments. The projects' expected net cash flows are as follows: Expected Net Cash Flows                                                                                                                              Time      Project A              Project B                                                                                                              0              ($400)                 ($700)                                                                                                    1              ($280)                   $201                                                                                                      2              ($200)                   $202                                                                                                      3              ($100)                   $203                                                                                                      4              $600                      $204                                                                                                      5              $600                      $205                                                                                                      6              $925                      $206                                                                                                      7              ($170)                   $207 In your report, identify which project would be selected (assuming they...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT