Please solve via EXCEL and show EXCEL calculations functions used to get solutions.

Merry Industries is considering a new piece of equipment for a project lasting 10 years with details as shown below. The costs and benefits are expected to keep increasing with the inflation rate even when a new machine is put into operation. Taking these into account, what is the annual worth that the company can expect from the machine? $7,823 $6,051 $8,246 $5,634