I need the solution in Excel.

Before-Tax Replacement Analysis Using EUAC The manager of a carpet manufacturing plant became concerned about the operation of a critical pump in one of the processes. After discussing thissituation with the supervisor of plant engineering, they decided that a replacement study should be done, and that a nine-year study period would be appropriate for this situation. The company that owns the plant is using a before-tax MARR of 10% per year for its capital investment projects. The existing pump, Pump A, including driving motor with integrated controls, cost $17,000 five years ago. An estimated MV of $750 could be obtained for the pump if it were sold now. Some reliability problems have been experienced with Pump A, including annual replacement of the impeller and bearings at a cost of $1,750. Annual operating and maintenance expenses have been averaging $3,250. Annual insurance and property tax expenses are 2% of the initial capital investment. It appears that the pump will provide adequate