*please show your work in excel. Thank you in advance*

PART FIVE Long-Term Investment Decisions P10-22 Payback, NPV, and IRR Rieger International is evaluating the feasibility of invest- ing $95,000 in a piece of equipment that has a 5-year life. The firm has estimated the cash inflows associated with the proposal, as shown in the following table. The firm has a 12% cost of capital. a Year (1) 1 2 3 Cash inflows (CF) $20,000 25,000 30,000 35,000 40,000 5 a. Calculate the payback period for the proposed investment. b. Calculate the net present value (NPV) for the proposed investment. c. Calculate the internal rate of return (IRR), rounded to the nearest whole percent, for the proposed investment. d. Evaluate the acceptability of the proposed investment using NPV and IRR. What recommendation would you make relative to implementation of the project? Why