Answers need to be an excel formula please.

Perry industries has a defined benefit pension plan that specifies annual, year-end retirement benefits, equal to 1.3% X service years X final years salary. Carol was hired by Perry at the beginning of 2016. Clark is expected to retire at the end of 2055, after 40 years of service. Her retirement is expected to span 15 years. At the end of 2025, 10 years after being hired, her salary is $60,000. The companies actuary projects, Clark salary to be $210,000 at retirement. The actuary's discount rate is 6%.

Perry Industries has a defined benefit pension plan that specifies annual, year-end retirement benefits equal to 1.3% Service years x Final year's salary. Carol was hired by Perry at the beginning of 2016. Clark is expected to retire at the end of 2055 after 40 years of service. Her retirement is expected to span 15 years. At the end of 2025,10 years after being hired, her salary is $60,000. The company's actuary projects Clark's salary to be $210,000 at retirement. The actuary's discount rate is 6%. 20 21 1. Estimate the amount of Carol's annual retirement payments for the 15 retirement years earned as of the 22 end of 2025 . 23 . 24 2. Suppose Perry's pension plan permits a lump-sum payment at retirement in lieu of annuity payments. 25 Determine the lump-sum equivalent as the present value as of the earned retirement annuity at the 26 expected date of retarement (the end of 2055). 3. What is the company's projected benefit obligatoon at the end of 2025 with respect to Carol