Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

1. Consider the following cash flows on two mutually exclusive projects that req

ID: 2810803 • Letter: 1

Question

1. Consider the following cash flows on two mutually exclusive projects that require an annual return of 15%. (They are mutually exclusive because T. Bennett Resorts, Inc. owns only one dock in the harbor.) Working in the financial planning department for the T. Bennett Resorts you are trying to compare different investment criteria to arrive at a sensible choice of these two projects Yacht Rentals Reef Diving Tour -$800,000 370,000 450,000 300,000 Year 0 -$2,200,000 1,000,000 900,000 1,100,000 2 a. Based on the payback period rule (including fractions of a year), which project should be chosen? b. If your decision rule is to accept the project with a greater IRR, which project should you choose? (You can use a hand-held calculator or spreadsheet to solve this problem or you can interpolate using the present value table in the case packet.) c. To be prudent, you compute the NPV for each project. Which project should you choose? Why? Note: NPV assumes capital is available at the rate of 15% per year d. What would your decision be if the projects were not mutually exclusive?

Explanation / Answer

a)
Payback:
Reff:
=1+(800000-370000)/450000=1.955555556
Yacht:
=2+(2200000-1000000-900000)/1100000=2.272727273
Accept Reef

b)
IRR:
Reef:
IRR=19.544%
Yacht:
IRR=16.972%

Accept Reef

c)
NPV:
Reef:
NPV=-800000+370000/1.15+450000/1.15^2+300000/1.15^3=59258.65045

Yacht:
NPV=-2200000+1000000/1.15+900000/1.15^2+1100000/1.15^3=73362.37363

Accept Yacht because NPV is higher

d)
If the projects were not mutually exclusive accept both