Chapter 8: Long-Term (Capital Investment) Decisions
8-9
C.
Cash Flow
Year
Amount
12
Percent
Factor
Present
Value
Initial investment New $4,000,000 1.0000 $(4,000,000)
Using Excel’s NPV function, we see that the NPV of the investment is now
$285,649. Using Excel’s IRR function indicates that the investment’s internal
rate of return is 13.65 percent. Under both NPV and IRR, the project is now
24. (LO1, 3, and 5—NPV versus payback method versus profitability index)
Note to Instructors: Without doing any calculations, students should be able to
see that Project 1 will always be preferred to Project 2 regardless of the discount
A. At 8 percent, Project 1 has an NPV of $987 and Project 2 has an NPV of
$941. Both are acceptable investments, and 1 is preferred over 2.
B. Payback for Project 1 is 1.67 years. Payback for Project 2 is 2.125 years.
Given Alfred’s cautious nature, we would still recommend Project 1.