Question

In: Finance

Consider the cash flows from two mutually exclusive projects

Use the following information to answer the next three questions. 

Consider the cash flows from two mutually exclusive projects: 


Cash Flow

YearProject AProject B
0-$420,000-$420,000
1$140,000$400,000
2$230,000$110,000
3$331,000$140,000


The appropriate discount rate is 8.5%.

Calculate the internal rate of return (IRR) for both projects, and determine which project should be accepted based on IRR.


Solutions

Expert Solution

Project A

Internal rate of return can be calculated using a financial calculator by inputting the below:

  • Press the CF button.
  • CF0= -$420,000. The initial cash flow is indicated by a negative sign since it is a cash outflow.  
  • Cash flow for each of the fifteen years should be entered.
  • Press Enter and down arrow after inputting each cash flow.
  • After entering the last cash flow cash flow, press the IRR and CPT button to get the IRR of the project.

The IRR of the project is 26.20%.

Project B

Internal rate of return can be calculated using a financial calculator by inputting the below:

  • Press the CF button.
  • CF0= -$420,000. The initial cash flow is indicated by a negative sign since it is a cash outflow.  
  • Cash flow for each of the fifteen years should be entered.
  • Press Enter and down arrow after inputting each cash flow.
  • After entering the last cash flow cash flow, press the IRR and CPT button to get the IRR of the project.

The IRR of the project is 33.54%.

Project B should be selected since it generates the largest internal rate of return.

  

In case of any query, kindly comment on the solution.


Related Solutions

Consider the following two mutually exclusive projects and their Cash Flows ($)
Consider the following two mutually exclusive projects and their Cash Flows ($)Project                                            C0                               C1                               C2                               C3K                                                       –$100                 +$45 +$45 +$60    W                                                     –$150                 +$45 +$45 +$125Which statement is correct based on the above information about Projects K and W?a. If the discount rate is 7.5%, accept project W because the cross-over rate is 9%b. Accept project K, because at a 9% discount rate K and W have the same net present value.c. If the discount rate is 9.5%, reject project K, because the...
Consider the following cash flows on two mutually exclusive projects for A- Z motorcars.Assuming both projects...
Consider the following cash flows on two mutually exclusive projects for A- Z motorcars.Assuming both projects require an annual return of 11 percent. year AZM Mini-Suv AFL Full-Suv 0 - 470000 - 820000 1 324000 354000 2 188000 428000 3 154000 294000 A    What is the pay back period for each projects B What is the NPV for each project C What is the IRR for each project Please note Do not do intermediate and run your answers to...
Consider the following cash flows on two mutually exclusive projects for the BHC Corporation . Both...
Consider the following cash flows on two mutually exclusive projects for the BHC Corporation . Both projects require an annual return of 10 percent. Year Project A Project B 0 -$425,000 -$750,000 1 $160,000 $360,000 2 $235,000 $300,000 3 $205,000 $300,000 As a financial analyst for BHC, you are asked the following questions: a. If your decision rule is to accept the project with the greater IRR, which project should you choose? b. Because you are fully aware of the...
Consider the following cash flows on two mutually exclusive projects for the Bahamas Recreation Corporation (BRC)....
Consider the following cash flows on two mutually exclusive projects for the Bahamas Recreation Corporation (BRC). Both projects require an annual return of 15%. Year Deepwater Fishing New Submarine Ride year0 -600,000 -1,800,000 year1 270,000 1,000,000 year2 350,000 700,000 year3 300,000 900,000 as a financial analyst for BRC, you are asked the following questions: a. Based on the discounted payback period rule, which project should be chosen? b. If your decision rule is to accept the project with the greater...
Consider the following cash flows on two mutually exclusive projects for the Bahamas Recreation Corporation (BRC)....
Consider the following cash flows on two mutually exclusive projects for the Bahamas Recreation Corporation (BRC). Both projects require an annual return of 15%. Year Deepwater Fishing New Submarine Ride 0 -600,000 -1,800,000 1 270,000 1,000,000 2 350,000 700,000 3 300,000 900,000 as a financial analyst for BRC, you are asked the following questions: a. Based on the discounted payback period rule, which project should be chosen? b. If your decision rule is to accept the project with the greater...
Consider the following cash flows of two mutually exclusive projects for Spartan Rubber Company. Assume the...
Consider the following cash flows of two mutually exclusive projects for Spartan Rubber Company. Assume the discount rate for both projects is 7 percent. Year Dry Prepreg Solvent Prepreg 0 –$ 1,890,000 –$ 900,000 1 1,119,000 470,000 2 938,000 790,000 3 769,000 428,000 a. What is the payback period for each project? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Payback period Dry Prepreg years Solvent Prepreg years b. What is the NPV...
NPV versus IRR. Consider the following cash flows on two mutually exclusive projects for the Bahamas...
NPV versus IRR. Consider the following cash flows on two mutually exclusive projects for the Bahamas Recreation Corporation. Both projects require an annual return of 15 percent. Year Fishing Submarine 0 -835000 -1650000 1 450000 1050000 2 410000 675000 3 335000 520000 As a financial analyst for the company, you are asked the following questions. a) If your decision rule is to accept the project with the greater IRR, which project should you chose? b) Since you are fully aware...
Consider the following cash flows of two mutually exclusive projects for Tokyo Rubber Company. Assume the...
Consider the following cash flows of two mutually exclusive projects for Tokyo Rubber Company. Assume the discount rate for both projects is 12 percent. Year Dry Prepreg Solvent Prepreg 0 –$ 1,800,000 –$ 800,000 1 1,110,000 425,000 2 920,000 700,000 3 760,000 410,000    a. What is the payback period for both projects? (Do not round intermediate calculations. Round your answers to 2 decimal places, e.g., 32.16.)     b. What is the NPV for both projects? (Do not round intermediate...
Consider the following cash flows on two mutually exclusive projects for the Bahamas Recreation Corporation (BRC)....
Consider the following cash flows on two mutually exclusive projects for the Bahamas Recreation Corporation (BRC). Both projects require an annual return of 15%. Year Deepwater Fishing New Submarine Ride 0 -600,000 -1,800,000 1 270,000 1,000,000 2 350,000 700,000 3 300,000 900,000 as a financial analyst for BRC, you are asked the following questions: a. Based on the discounted payback period rule, which project should be chosen? b. If your decision rule is to accept the project with the greater...
Consider the following cash flows on two mutually exclusive projects for the Bahamas Recreation Corporation (BRC)....
Consider the following cash flows on two mutually exclusive projects for the Bahamas Recreation Corporation (BRC). Both projects require an annual return of 15%. Deepwater fishing Year 0 -600,000 year 1 270,000 year 2 350,000 year 3 300,000 Fishing New Submarine Ride year 0 -1,800,000 year 1 1,000,000 year2 700,000 year3 900,000 as a financial analyst for BRC, you are asked the following questions: a. Based on the discounted payback period rule, which project should be chosen? b. If your...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT