When the calculations for the requirements below are correct, the cells will change to yellow.

Sachs Brands's defined benefit pension plan specifies annual retirement benefits equal to $1\mathrm{.}6\%\backslash$times service years $\backslash$times final year's salary,

payable at the end of each year. Angela Davenport was hired by Sachs at the beginning of $2010$ and is expected to retire at the end of

$2044$ after $35$ years' service. Her retirement is expected to span $18$ years. Davenport's salary is $$90,000$ at the end of $2024$ and the

company's actuary projects her salary to be $$240,000$ at retirement. The actuary's discount rate is $7\%.$

Use Excel to calculate the requirements below.

Required:

$1.$Estimate by the projected benefits approach the amount of Davenport's annual retirement payments earned as of the end of $2024.$

$2.$What is the company's projected benefit obligation at the end of $2024$ with respect to Davenport?$($Do not round intermediate calculations.

Round your final answer to the nearest whole dollar.$)$

$3.$If no estimates are changed in the meantime, what will be the accumulated benefit obligation at the end of $2027($three years later$)$

with respect to Davenport? $($Do not round intermediate calculations. Round your final answer to the nearest whole dollar.$)$

$1.$ Annual retirement payments $$57,600$

$2.$ Projected benefit obligation $2024$

$3.$ Projected benefit obligation $2027$