Please solve in excel and explain any functions used.

5-34 Quinton's refrigerator has just died. He can get a basic refrigerator or a more efficient refrigerator with an Energy Star designation. Quinton earns 4% compounded annually on his investments, he wants to consider a 10-year planning horizon, and he will use present worth analysis to determine the best alterative. What is your recommendation? Contributed by Paul R. McCright, University of South Florida Basic Energy Unit Star Unit Initial cost 700 Delivery and installation 60 Professional servicing (year 5) 100 Annual energy costs 120 Salvage value (year 10) 150 800 60 100 55 175