Please solve via EXCEL and show Table Calculation Functions used to get solutions. (Refer to the charts below to solve questions)

BELOW IS THE NET CASH FLOW CHART FOR BOTH MACHINES A & B

QUESTION: What is the NPW, EUAW, NFW & IRR for BOTH machines?

What is the DELTA IRR?

Please provide excel function used.

You are selecting equipment for a project. There are two machines under consideration. They will provide the same function, but there are difference in cost, benefits, life and other details. Costs, machine prices AND salvage all go up at the rate of inflation. Costs and benefits are shown for year 1. Benefits go up by the % given. Salvage costs are given for an 10 yr old machne A or a 5 yr old machine B TODAY. Adjust with inflation. Help your employer to determine which machine is the best choice. You are selecting equipment for a project. There are two machines under consideration. They will provide the same function, but there are difference in cost, benefits, life and other details. Costs, machine prices AND salvage all go up at the rate of inflation. Costs and benefits are shown for year 1. Benefits go up by the % given. Salvage costs are given for an 10 yr old machne A or a 5 yr old machine B TODAY. Adjust with inflation. Help your employer to determine which machine is the best choice