6.. Use Excel (ONLY) to do this. Show all your work. Print the spread sheet showing your data and all your Analyses. Scan this sheet with your other sheets and save it as ONE pdf le. I will ONLY grade pdf les. You can also take a picture of your computer screen showing all your numbers. Make sure it is clear. ALSO COPY THE KEY NUMBERS IN THE BOXES BELOW a. A rm is considering a new machine for its assembly line. The following are three competing alternatives. Use the present worth analysis to select the best alternative. Use MARE of 9% Project Initial Investment $59,500.00 $63,000.00 $02,000.00 operating Cost per year $25,000.00 $23,000.00 $25,000.00 RevEnue per year $45,000.00 $41,000.00 $37,000.00 Salvage value $4,500.00 $12,000.00 $27,000.00 Life {years} 10 b. The following are three competing alternatives. E g Initial Investment reratin. C051: evenue oer ear Salva-e value 'fe ears 1:? i 15.\" i l- . -_ . E 58888 Calculate the IRR for each alternative