****PLEASE ADD EXCEL EQUATIONS TO YELLOW BOXES. FIRST BOX IS D20

Payback, NPV, and IRR Rieger International is evaluating the feasibility of investing $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. 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? Answers (insert your answers in the highlighted cells; use cell references, equations, and functions wherever possible) b. Calculate the net nresent 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