please add an excel link with the answer

5 Project C 300,000 10,000 10,000 560,000 Consider the following alternatives: 5 Project A Project B First Cost 100,000 200,000 8 M&O 15,000 25,000 9 Annual Benefit 30,000 40,000 10 Salvage Value 100,000 270,000 1 Life, years 5 6 12 13 When each project reaches end of life, it will be sold for its salvage 14 value and there will be no replacement. 15 16 Using the Spreadsheets and Graphs tabs below complete the following items: 17 (a) Prepare a spreadsheet of EUAW as a function of interest 18 rate for each individual project and for the relevent incrementals. (20 Points) 20 (b) Prepare a cash flow table for each alternative and for the relevent incrementals. (20 points) 21 22 (c) Calculate Individual RORs and incremental IRRs. (20 points) 19 23 24 (d) Graph EUAW as a function of interest rate for each project; 25 save on a separate sheet and label all titles and all relevent IRRs and RORS. (20 points) 26 27 (e) Construct a choice table to present the information in compact and easily understandable form. (10 Points) 28 29 () Which project is preferred at MARR = 10.00%? (10 Points) TH 5 Project C 300,000 10,000 10,000 560,000 Consider the following alternatives: 5 Project A Project B First Cost 100,000 200,000 8 M&O 15,000 25,000 9 Annual Benefit 30,000 40,000 10 Salvage Value 100,000 270,000 1 Life, years 5 6 12 13 When each project reaches end of life, it will be sold for its salvage 14 value and there will be no replacement. 15 16 Using the Spreadsheets and Graphs tabs below complete the following items: 17 (a) Prepare a spreadsheet of EUAW as a function of interest 18 rate for each individual project and for the relevent incrementals. (20 Points) 20 (b) Prepare a cash flow table for each alternative and for the relevent incrementals. (20 points) 21 22 (c) Calculate Individual RORs and incremental IRRs. (20 points) 19 23 24 (d) Graph EUAW as a function of interest rate for each project; 25 save on a separate sheet and label all titles and all relevent IRRs and RORS. (20 points) 26 27 (e) Construct a choice table to present the information in compact and easily understandable form. (10 Points) 28 29 () Which project is preferred at MARR = 10.00%? (10 Points) TH