Question

In: Finance

Comparing Investment Criteria. Consider the following cash flows of two mutually exclusive projects for Spartan Rubber...

Comparing Investment Criteria. Consider the following cash flows of two mutually exclusive projects for Spartan Rubber company.  Assume the discount rate for both projects is 10 percent.

a. Based on the payback period, which project should be taken?

b. Based onthe NPV, which project should be taken?

c.  Based on the IRR, which project should be taken?

d.  Based on the above analysis, is incremental IRR analysis necessary?  If yes, please conduct the analysis.

Year Dry Prepreg Solvent Prepreg
0 (1,800,000) (925,000)
1 690,000 565,000
2 430,000 410,000
3 1,400,000 340,000

Solutions

Expert Solution

Part A

Payback period of Dry prepreg:

Payback period = 2 + 680,000/ 1,400,000

Payback period = 2.49 years

Payback period of Solvent prepreg:

Payback period = 1 + 360,000/ 410,000

Payback period = 1.88 years

As payback period of Solvent Prepreg is less as compared to dry prepreg, we will choose Solvent Prepreg project

Part B

NPV of Project Dry Prepreg

NPV = -1,800,000 + 690,000/ 1.1 + 430,000/ 1.12 + 1,400,000/ 1.13

NPV = -1,800,000 + 627,272.73 + 355,371.90 + 1,051,840.72

NPV = 234,485.35

NPV of Project Solvent Prepreg

NPV = -925,000 + 565,000/ 1.1 + 410,000/ 1.12 + 340,000/ 1.13

NPV = -925,000 + 513,636.36 + 338,842.98 + 255,447.03

NPV = 182,926.37

As NPV of Dry Prepreg is more, we will choose Dry Prepreg project

Part C

IRR of Project Dry Prepreg

1,800,000 = 690,000/ (1 + r) + 430,000/ (1 + r)2 + 1,400,000/ (1 + r)3

IRR = 16.34%

IRR of Project Solvent Prepreg

925,000 = 565,000/ (1 + r) + 410,000/ (1 + r)2 + 340,000/ (1 + r)3

IRR = 22.06%

As IRR of Solvent Prepreg is more and is also high than required rate of return of 10%, we will choose Solvent Prepreg project

Part D

Incremental IRR:

Net cash flows:

CF0 = -875,000

CF1 = 125,000

CF2 = 20,000

CF3 = 1,060,000

IRR:

875,000 = 125,000/ (1 + r) + 20,000/ (1 + r)2 + 1,060,000/ (1 + r)3

IRR = 12.33%

For investing-type projects, accept the larger project when the incremental IRR is greater than the discount rate which is true in this case we will choose dry prepreg project


Related Solutions

Comparing Investment Criteria. Consider the following cash flows of two mutually exclusive projects for Tokyo Rubber...
Comparing Investment Criteria. Consider the following cash flows of two mutually exclusive projects for Tokyo Rubber Company. Assume the discount rate for both projects is 8% Year                Deepwater Fishing                  New Submarine Ride 0                      -$1,700,000                             -$750,000 1                      1,100,000                               375,000           2                         900,000                                600,000 3                         750,000                                390,000 b) Based on the NPV, which project should be taken? c) Based on IRR, which project should be taken?
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...
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 8 percent. Year Dry Prepreg Solvent Prepreg 0 –$ 1,810,000 –$ 805,000 1 1,111,000 430,000 2 922,000 710,000 3 761,000 412,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 1.92 1.92 Incorrect years Solvent Prepreg 2.20 2.20 Incorrect...
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 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 8 percent. Year Dry Prepreg Solvent Prepreg 0 –$ 1,810,000 –$ 805,000 1 1,111,000 430,000 2 922,000 710,000 3 761,000 412,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.)      Payback period   Dry Prepeg years   Solvent Prepeg years          b. What is...
Consider the following cash flows of two mutually exclusive projects for Braisl Rubber Co. Assume the...
Consider the following cash flows of two mutually exclusive projects for Braisl Rubber Co. Assume the discount rate for both projects is 9 Percent. Year Dry PrePreg Solvent PrePreg 0 1,820,000 810,000 1 1,112,000 435,000 2 924,000 720,000 3 762,000 414,000 a. What is the payback period for both projects? Dry PrePreg Years Solvent PrePreg Years b. What is the NPV for both projects? Dry PrePreg Solvent PrePreg c. What is the IRR for both projects? Dry PrePreg % Solvent...
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 9 percent. YearDry PrepregSolvent Prepreg 0–$1,850,000 –$825,000 1 1,115,000  450,000 2 930,000  750,000 3 765,000  420,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 calculations. Round your answers to 2 decimal places,...
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 10 percent. Year Dry Prepreg Solvent Prepreg 0 –$ 1,830,000 –$ 815,000 1 1,113,000 440,000 2 926,000 730,000 3 763,000 416,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 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 7 percent. Year Dry Prepreg Solvent Prepreg 0 –$ 1,870,000 –$ 835,000 1 1,117,000 460,000 2 934,000 770,000 3 767,000 424,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 calculations....
Comparing Investment Criteria. Consider the following two mutually exclusive design projects using a required return of...
Comparing Investment Criteria. Consider the following two mutually exclusive design projects using a required return of 18%: Year Cash flow (A) Cash flow (B) 0 -22000 -2200 1 500 1100 2 4000 900 3 10000 1100 4 42000 4000 1. Find the NPV for both projects a and b. (round to second decimal) 2. Find the IRR for both projects a and b. (round to secound decimal) 3. Find the PI for both projects A and B. (round to second...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT