Please solve using excel only and show the steps.

Solve the following questions by Excel ONLY: Question 7: Joan, the project manager, asks you to evaluate alternatives A and B on the basis of their PW values using a real interest rate of 10% per year and an inflation rate of 3% per year. (a) With inflation considered, which machine is better from a PW point of view? (6) Joan clearly wants alternative A to be selected. If inflation is steady at 3% per year, what real return i would machine A have to generate each year to make the choice between A and B indifferent? What is the required retum with inflation considered? A Machine First cost, $ AOC, $ per year Salvage. $ Life, years -31,000 -28.000 5.000 B 48.000 -19.000 7,000 5