Question

In: Finance

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 are mutually exclusive) for each investment criterion. Note that cash outflows (costs) are given in parenthesis. Employ the Excel file to answer the following questions.

Part 1: Net Present Value

A) Use the Excel NPV function to calculate the NPV for each project at each cost of capital (10 points)

B) Construct NPV profiles (a data table of project NPVs relative to differing costs of capital) using the Excel NPV function for Projects A and B and graph them both in one plot (label the x-axis, y-axis, and title) (10 points)

Part 2: Internal Rate of Return

C) Use the Excel IRR function to calculate each projects IRR (10 points)

D) Use the Excel MIRR function to calculate each projects MIRR for each cost of capital (10 points)

Part 3: Payback

E) Calculate the cumulative cash flow and the regular payback for each project (10 points)

Solutions

Expert Solution

­

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

FIRST IMAGE : PART 1

SECOND AND THIRD IMAGE : PART 2

FOURTH IMAGE : PART 3


Related Solutions

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...
Capital Budgeting BioMed Engineering is considering two mutually exclusive investments. The projects' expected net cash flows...
Capital Budgeting BioMed 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          ($405)                ($705)                                                                            1          ($285)              $200                                                                              2          ($205)              $205                                                                              3          ($105)              $210                                                                              4          $605                 $215                                                                              5          $650                 $220                                                                              6          $925                 $225                                                                              7          ($200)              $230                                                                  In your report, identify which project would be selected (assuming they are mutually exclusive) for each investment criterion. Note that cash outflows (costs) are given in parenthesis. Employ the Excel file to answer the following questions. Part 1: Net Present Value C. Construct NPV profiles...
Capital Budgeting BioMed Engineering is considering two mutually exclusive investments. The projects' expected net cash flows...
Capital Budgeting BioMed 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          ($405)                ($705)                                                                            1          ($285)              $200                                                                              2          ($205)              $205                                                                              3          ($105)              $210                                                                              4          $605                 $215                                                                              5          $650                 $220                                                                              6          $925                 $225                                                                              7          ($200)              $230                                                                  In your report, identify which project would be selected (assuming they are mutually exclusive) for each investment criterion. Note that cash outflows (costs) are given in parenthesis. Employ the Excel file to answer the following questions. Part 2: Internal Rate of Return E. Use the...
Capital Budgeting BioMed Engineering is considering two mutually exclusive investments. The projects' expected net cash flows...
Capital Budgeting BioMed 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          ($405)                ($705)                                                                            1          ($285)              $200                                                                              2          ($205)              $205                                                                              3          ($105)              $210                                                                              4          $605                 $215                                                                              5          $650                 $220                                                                              6          $925                 $225                                                                              7          ($200)              $230                                                                  In your report, identify which project would be selected (assuming they are mutually exclusive) for each investment criterion. Note that cash outflows (costs) are given in parenthesis. Employ the Excel file to answer the following questions. Part 3: Payback and PI G. Calculate the cumulative...
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...
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...
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?...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT