Please solve via excel and show calculation steps to solve table.

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

MARR: 13.00%

Inflation: 1.980%

Create the net cash flow chart for both machines.