Please solve in excel and show the spreadsheets; I would like to know how each of the formulas are input into excel.

An industrial engineer at a fiber optic manufactur- ing company is considering two robots to reduce costs in a production line. Robot X will have a first cost of $82,000, an annual maintenance and oper- ation (M&O) cost of $30,000, and salvage values of $50,000, $42,000, and $35,000 after 1, 2, and 3 years, respectively. Robot Y will have a first cost of $97,000, an annual M&O cost of $27,000, and salvage values of $60,000, $51,000, and $42,000 after 1, 2, and 3 years, respectively. Which robot should be selected if a 2-year study period is used at an interest rate of 15% per year