Can anyone please let me know how to solve this problem using excel

prom per Widget Is malt: r to p15.) 2. (Chg) You have been asked to evaluate two pieces of equipment and recommend which on: to purchase for your plant. They have different useful lives and have the cash flows shown in the table. The salvage value for both options is assumed to be zero. Assume that both alternatives may be replaced at the end of their useful lives. For the analysis, you will be using MARR of 8%. (a) What would be a good horizon to evaluate the options based on PW? (1 pt) (b) For that horizon compare each alternative's PW. (2 pts) (0) Compare each alternative's EAC. (2 pts) OtionB Life= 4 rs. Year Purchase Annual 0&M I-m Annual Year Purchases &M 0 15000 _ 2 1250 1500 2000 45L)