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 file. I will ONLY grade pdf files. 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 firm 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 MARR of 9% Project Initial Investment $59,500.00 $68,000.00 $72,000.00 operating cost per year Revenue per year Salvage value Life (years) $25,000.00 $45,000.00 $4,500.00 4 $23,000.00 $41,000.00 $12,000.00 5 $25,000.00 $37,000.00 $27,000.00 10 PWA PWA PWA Choice b. The following are three competing alternatives. Project B Initial Investment $62,000.00 $68,000.00 $70,000.00 operating Cost $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 i. Calculate the IRR for each alternative IRRA IRRE- IRR- ii. Using IRR analysis, which of the three will you select ff the firm's MARR = 9%