please show all work for number 8 and do not use excel for number 8. ignore all work and answer chosen (they are wrong)

Use the following information for questions 8, 9, and 10. Can, Co. $70,000 Can 2, Inc. $100,000 Initial Cost Benefits O&M Costs Salvage $22,000 per year $30,000 per year $7,000 per year $10,000 per year e (in years)$16,000 13 .55% $8,000 14.97% ROR 8. The AROR is closest to Z. c) 7.2% 9.4% 1110.3% Continued from the previous page... Can 2, Ine. $100,000 Can, Co. $70,000 Initial Cost Benefits $22,000 per year$30,000 per year $7,000 per year $10,000 per year O&M Costs Salva Life (in years) $8,000 $16,000 14.97% ROR 13.55% 9 Assume the ROR 12.7% (this is not the true value . the range of MARR over which Can 2 Inc. is the optimal choice is closest to Note: Do-Nothing is an option a) 0-1 2.7% b) 0-13.55% c) 0-1 4.26% d) 0-1 4.97% e) 12.7-13.55% 0127-1426% 12.7-14.97% ) 13.55-14.26% i) 13.55-14.97% j) 14.26-14.97% m) greater than 14.26% n) greater than 14.97% o) none of the above k) greater than 12.7% greater than 13.55% 10. Assume the ROR-| 2.7% (this is not the true value). the range of MARR over which Do-Nothing is the optimal choice is closest to Note: Do-Nothing is an option 0-12.7% ) 0-13.55% c) 0-1 4.26% d) 0-1 4.97% e) 12.7-13.55% f) 12.7-14.26% g) 12.7-14.97% h) 13.55-14.26% i) 13.55-14.97% j) 14.26-14.97% k) greater than 12.7% l) greater than 13.55% m) greater than 14.26% n) greater than 14.97% o) none of the above 11. Consider the following year-by-year cash flows located in an Excel spreadsheet beginning in cell E10 and continuing through cell E15: -$50,000; $12,000; $12,000; S16,000;$14,000; $12,000. The Excel code necessary to find the Present Value of the identified cash flows is Note: MARR=10% )-PW(0.1, El1:E15) + E10 b) NPV(0.1, E10:E15) c)-PV(0.1, E10:E15) d) NPW(0.1, E10:E15) e)-PRESENT(0.1 , E 10:El 5) 0 PRESENT(0.1, EI1:E15) + E10 g) none of the above Use the following information for questions 8, 9, and 10. Can, Co. $70,000 Can 2, Inc. $100,000 Initial Cost Benefits O&M Costs Salvage $22,000 per year $30,000 per year $7,000 per year $10,000 per year e (in years)$16,000 13 .55% $8,000 14.97% ROR 8. The AROR is closest to Z. c) 7.2% 9.4% 1110.3% Continued from the previous page... Can 2, Ine. $100,000 Can, Co. $70,000 Initial Cost Benefits $22,000 per year$30,000 per year $7,000 per year $10,000 per year O&M Costs Salva Life (in years) $8,000 $16,000 14.97% ROR 13.55% 9 Assume the ROR 12.7% (this is not the true value . the range of MARR over which Can 2 Inc. is the optimal choice is closest to Note: Do-Nothing is an option a) 0-1 2.7% b) 0-13.55% c) 0-1 4.26% d) 0-1 4.97% e) 12.7-13.55% 0127-1426% 12.7-14.97% ) 13.55-14.26% i) 13.55-14.97% j) 14.26-14.97% m) greater than 14.26% n) greater than 14.97% o) none of the above k) greater than 12.7% greater than 13.55% 10. Assume the ROR-| 2.7% (this is not the true value). the range of MARR over which Do-Nothing is the optimal choice is closest to Note: Do-Nothing is an option 0-12.7% ) 0-13.55% c) 0-1 4.26% d) 0-1 4.97% e) 12.7-13.55% f) 12.7-14.26% g) 12.7-14.97% h) 13.55-14.26% i) 13.55-14.97% j) 14.26-14.97% k) greater than 12.7% l) greater than 13.55% m) greater than 14.26% n) greater than 14.97% o) none of the above 11. Consider the following year-by-year cash flows located in an Excel spreadsheet beginning in cell E10 and continuing through cell E15: -$50,000; $12,000; $12,000; S16,000;$14,000; $12,000. The Excel code necessary to find the Present Value of the identified cash flows is Note: MARR=10% )-PW(0.1, El1:E15) + E10 b) NPV(0.1, E10:E15) c)-PV(0.1, E10:E15) d) NPW(0.1, E10:E15) e)-PRESENT(0.1 , E 10:El 5) 0 PRESENT(0.1, EI1:E15) + E10 g) none of the above