this question has been answered three times and all wrong. please put it in excel formulas . i just need question 3 answered, 1&2 are correct. thanks!

Perry Industries has a defined benefit pension plan that specifies annual, year-end retirement benefits equal to 1.3% x 6 Service years x Final year's salary. Carol was hired by Perry at the beginning of 2016. Clark is expected to retire at the 7 end of 2055 after 40 years of service. Her retirement is expected to span 15 years. At the end of 2025, 10 years after 8 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%.

Total years of service 13

Service years through December 31, 2025 Clark's salary at December 31, 2025 Retirement is expected to span 15 years

Clark's projected salary at retirement $210,000

Actuary's discount rate 6%

Required:

in second photo

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%. Required: 1. Estimate the amount of Carol's annual retirement payments for the 15 retirement years earned as of the end of 2025 . 19 Required: 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. $27,300 2. Suppose Perry's pension plan permits a lump-sum payment at retirement in lieu of annuify payments. Determine the lump-sum equivalent as the present value as of the earned retirement annuity at the expected date of retirement (the end of 2055). $265,144 3. What is the company's projected benefit obligation at the end of 2025 with respect to Carol? $1,358