Ideally, show how to answer this using excel functions. Thanks!

Problem 7. The manager of engineering at the 900-megawatt Hamilton Nuclear Power Plant has three options to supply personal safety equipment to employees. Two are vendors who sell the items, and the third alternative is to rent the equipment for $50,000 per year, but for no more than 3 years per contract. These items have relatively short lives due to constant use. The MARR is 10% per year. a. Select from the two vendors using the LCM and NPV analysis. b. Determine which of the three options is cheaper over a study period of 3 years. Vendor R Rental Vendor T - 125,000 75,000 0 -27,000 - 12,000 0 Initial cost, $ Annual upkeep, $ per year Annual rental, $ per year Salvage value, $ Estimated life, years 0 0 50,000 30,000 0 2 3 Maximum of 3