PLEASE ANSWER all questions and show your work. Thank you!!

The following information is available about an investment opportunity. Investment will occur at time 0 and sales will commence at time 1. a. Prepare a spreadsheet to estimate the project's annual ATCFs. b. Calculate the investment's internal rate of return and its NPV. c. How do your answers to questions (a) and (b) change when you assume a uniform inflation rate of 8 percent a year over the next 10 years? (Use the following equation to calculate the nominal discount rate: i_n = (1 + i_r) (1 + p) - 1, where i_n is the nominal discount rate, i_r is the real discount rate, and p is expected inflation.) d. How do you explain the fact that inflation causes the internal rate of return to increase and the NPV to decrease? e. Does inflation make this investment more attractive or less attractive? Why