80.2K

Verified Solution

Link Copied!

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$

Answer & Explanation Solved by verified expert

See Answer