Solve it by excel

You have two machines under consideration for an improved automated wrapping process for Snick- 20 ers Fun Size candy bars as detailed below. (a) Using an AW analysis, determine which should be selected at 15% per year. Assume you want machine D to be selected and are willing to extend its estimated life, if necessary. Perform this analysis to ensure (b) D's selection using factors or a spreadsheet Machine First cost, S Annual cost, S/year Salvage value, S Life, years -40,000 -10,000 12,000 -65,000 -12,000 25,000 6 Solve it by excel