please show steps

answer on Excel by shading the entire box yellow and lobeling it. You have been hired as a benefit consultant by Pete McNown, the owner of Pete's Pet Emporium. He wants to establish a retirement plan for himself and his two employees, Ron and Aaron. Pete has provided the following information: a. The retirement plan is to be based upon the AVGSAL (the average annual salary for the LAST three years of service before retirement). i. The plan will provide for 70% of Pete's AVGSAL, ii. The plan will provide for 50% of Ron and Aaron's AVGSAL iii. In the past, Pete has given himself and each employee a 3% year-end salary increase, Pete plans to continue this practice. b. The plan will make annual payments to the employees at the beginning of each year for 20 years from the date of retirement. c. Pete wishes to fund the plan by making 15 annual deposits beginning January 1, 2017. d. Invested funds will earn 8% compounded annually until December 31,2031 . At that time, the funds will be moved to a safer investment vehicle with an annual return of 5%. e. Here is specific information on each employee. Current salaries reflect year 2016. 1. Pete MCNown, current salary of $50,000, estimated retirement 01/01/32 ii. Ron Farrell; current salary of $40,000, estimated retirement 01/01/37 iii. Aaron Cavey; current salary of $35,000 estimated retirement 01/01/42 f. Given the above information, please answer the following questions: 1. What will be the annual retirement benefit for each plan participant? Clearly indicate your answer on Excel by shading the entire box yellow and labeling it. ii. What will be the amount of the annual deposits starting on January 1,2017 ? Clearly indicate your onswer on Excel by shading the entire box yellow and labeling it