Read the information regarding a possible new investment presented at www.mhhe.com/higgins9e. (Select Student Edition > Choose a Chapter Excel Spreadsheets.)

a. Complete the spreadsheet to estimate the project's annual after tax cash flows.

b. What is the investment's net present value at a discount rate of 10 percent?

c. What is the investment's internal rate of return?

d. How does the internal rate of return change if the discount rate equals 20 percent?

e. How does the internal rate of return change if the growth rate in EBIT is 8 percent instead of 3 percent?

AppendixLO1