EXCEL FORUMULA ONLY!

Perry Industries has a defined benefit pension plan that specifies annual, year-end retirement benefits equal to 1.3% x 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%.

table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} tr {mso-height-source:auto;} col {mso-width-source:auto;} td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; text-align:general; vertical-align:bottom; border:none; white-space:nowrap; mso-rotate:0;} .xl74 {text-align:left; white-space:normal;} .xl83 {white-space:normal;} .xl140 {border:.5pt solid windowtext; background:#FFFFAA; mso-pattern:black none;}

Percentage of final year's salary						1.30%
Total years of service						40	years
Service years through December 31, 2025						10	years
Clark's salary at December 31, 2025						$60,000
Retirement is expected to span						15	years
Clark's projected salary at retirement						$210,000
Actuary's discount rate						6%
Required:
1. Estimate the amount of Carols annual retirement payments for the 15 retirement years earned as of the end of 2025.
$27,300
2. Suppose Perrys pension plan permits a lump-sum payment at retirement in lieu of annuity 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).
3. What is the companys projected benefit obligation at the end of 2025 with respect to Carol?