Defined Benefit Plan Contribution Calculator

Calculator Inputs

Current Age

Retirement Age

Years of Service

Current Annual Salary

Salary Growth %

Benefit Accrual Rate %

Discount Rate %

Retirement Payment Years

Current Plan Assets

Target Funding Ratio %

Amortization Years

Administrative Expense

Employee Contribution

Benefit Payment Timing

Example Data Table

Case	Age	Salary	Service	Assets	Rate	Estimated Contribution
Small employer	42	$75,000	8	$180,000	5%	$31,240
Professional plan	50	$140,000	16	$600,000	4.5%	$67,890
Owner focused	55	$210,000	20	$950,000	4%	$112,430

Formula Used

Years to retirement = Retirement age − Current age.

Projected final salary = Current salary × (1 + Salary growth rate)^{Years to retirement}.

Annual pension benefit = Final salary × Benefit accrual rate × Service at retirement.

Annuity factor = [1 − (1 + Discount rate)^{−Payment years}] ÷ Discount rate.

Present value today = Present value at retirement ÷ (1 + Discount rate)^{Years to retirement}.

Unfunded liability = Target liability − Current plan assets.

Employer contribution = Normal cost + Amortization payment + Expenses − Employee contribution.

How to Use This Calculator

Enter the worker age, retirement age, and completed service.
Add current salary and the expected yearly salary growth rate.
Enter the plan benefit accrual percentage.
Add the discount rate and expected retirement payment years.
Enter current assets and the desired funding ratio.
Add the amortization period, expenses, and employee contribution.
Press the calculate button to view the result above the form.
Download the CSV or PDF report for records.

Defined Benefit Contribution Planning

A defined benefit plan promises a retirement income. That promise creates a funding need today. This calculator gives a practical estimate. It is not an actuarial valuation. It helps sponsors review assumptions before formal advice.

What the Calculator Measures

The tool starts with pay, age, service, and accrual rate. It projects salary to retirement. It then estimates the yearly pension benefit. The benefit is converted into a present value. Existing plan assets reduce the target amount. Any gap is spread over the selected amortization period. The result is an estimated employer contribution.

Why Assumptions Matter

A plan sponsor can test many assumptions. Salary growth changes the final benefit. The discount rate changes the present value. Longer retirement payment periods increase the liability. A higher target funding ratio raises required funding. Employee contributions reduce the employer amount. Administrative expenses are added after the core pension cost.

Calculation Method

This estimate uses a simplified entry-age style method. The normal cost represents one more year of earned benefit. The accrued liability measures the value of the projected pension promise today. The unfunded liability is the difference between the target liability and assets. The amortization payment is calculated like a level yearly payment.

Planning Value

The calculator is useful for planning, budgeting, and education. It can compare conservative and optimistic scenarios. It can also show why assumptions matter. Small rate changes can move the required contribution sharply. For that reason, results should be reviewed with care. Laws, plan documents, mortality tables, and actuarial standards may require different calculations.

Record Keeping

Use the CSV option to save assumptions and results. Use the PDF option to create a simple report. Keep copies for board meetings or internal reviews. Update the inputs when salaries, assets, or funding targets change. Good records make pension planning easier.

Final Review

A defined benefit plan can be valuable. It can also create large obligations. Regular contribution reviews help protect workers and sponsors. This calculator gives a transparent starting point. Professional actuarial review should guide final funding decisions.

For better analysis, run three cases. Use a base case, a cautious case, and a stress case. Compare contribution amounts beside the funding ratio. This simple habit shows risk early. It also supports cleaner discussions with owners, trustees, finance teams, and employees before budgets are approved for the year.

FAQs

What is a defined benefit plan contribution?

It is the amount a sponsor may need to fund promised pension benefits. The amount depends on salary, service, assets, discount rate, and plan rules.

Is this an actuarial valuation?

No. This calculator gives an educational estimate. A certified actuary should prepare formal funding, tax, legal, and compliance calculations.

Why does the discount rate matter?

The discount rate converts future pension payments into today’s value. A lower rate usually increases liabilities and raises the contribution estimate.

What is normal cost?

Normal cost is the estimated value of one more year of earned pension benefit. It is part of the annual funding need.

What is unfunded liability?

Unfunded liability is the gap between the target liability and current plan assets. This calculator spreads that gap over the amortization period.

Can employee contributions reduce the employer cost?

Yes. The calculator subtracts employee contributions after estimating normal cost, amortization payment, and administrative expense.

Why include payment timing?

Payments made at the beginning of each year have a higher present value than payments made at year end. Timing can change the estimate.

How often should inputs be updated?

Update inputs when salary, plan assets, assumptions, or funding targets change. Annual review is useful for budgeting and planning.