Articles

What return does a pension plan need to reach full funding in ten years?

A plan that earns exactly its assumed return closes only part of a funding gap in a decade. The return it needs is higher, and the contribution that avoids that is a number you can solve.

A pension plan has $8.0bn of assets against $10.0bn of liabilities, an 80.0% funded ratio. It pays $0.70bn a year of benefits and receives $0.40bn of contributions. If it earns its assumed 6.75% every year it is only 86.3% funded after ten years. To reach 100% it needs 8.10% a year, or an extra $0.131bn of contributions a year at the assumed return.

The assumptions

Illustrative public pension plan, invented figures, $bn
ItemValue
Assets today8.00
Liabilities today10.00
Funded ratio today80.0%
Benefit payments a year0.70
Contributions a year0.40
New benefits earned a year (service cost)0.25
Liability discount rate and assumed return6.75%
Horizon10 years

Benefits, contributions and service cost are held flat to keep the arithmetic visible; in a real plan each moves. Liabilities grow at the discount rate and with new benefits earned, and fall as benefits are paid.

Step 1: where the liabilities will be

Each year: liabilities = liabilities × 1.0675 + service cost − benefits

Year 10 = 10.00 × 1.067510 + (0.25 − 0.70) × [(1.067510 − 1) ÷ 0.0675] = $13.072bn

Step 2: where the assets end if the assumption is met

Each year: assets = assets × 1.0675 + contributions − benefits

Year 10 = 8.00 × 1.067510 + (0.40 − 0.70) × [(1.067510 − 1) ÷ 0.0675] = $11.277bn

Funded ratio = 11.277 ÷ 13.072 = 86.3%

The plan earning exactly 6.75% a year, $bn
YearAssetsLiabilitiesFunded ratio
08.0010.0080.0%
18.2410.2380.6%
28.5010.4781.2%
59.3711.2983.0%
1011.2813.0786.3%

The dollar gap narrows only from $2.00bn to $1.80bn. The assets are 80% of the liabilities and the plan pays out $0.30bn more than it receives each year, so the same percentage return adds fewer dollars to the assets than to the liabilities.

Step 3: the return that closes the gap

Solve for R in 8.00 × (1 + R)10 + (0.40 − 0.70) × [((1 + R)10 − 1) ÷ R] = 13.072

R = 8.10%, which is 1.35 percentage points above the assumption

Excel: =RATE(10,-0.30,8,-13.072)

What if: a worse decade, a higher contribution

Funded ratio after ten years
CaseAssets, $bnFunded ratio
Earns 5.75% a year10.08477.1%
Earns 6.75% a year11.27786.3%
Earns 7.75% a year12.58196.2%
Earns 6.75% with $0.131bn more contributed a year13.072100.0%

Each point of return is worth about 5.0 points of funded ratio over the decade. Adding $0.10bn of contributions a year lowers the return needed to 7.07%, and $0.20bn lowers it to 6.05%, below the 6.75% assumption.

The common mistakes

Takeaway

Questions readers ask

How do you find the return a pension plan needs to be fully funded?

Project the liabilities to the target date, then solve for the return at which assets, with contributions and benefits, reach that figure. Here that is 8.10% a year, found with RATE in Excel.

Why does a plan that earns its assumed return stay underfunded?

Because the assets start below the liabilities and the plan pays out more than it takes in. At 6.75% this plan ends year ten 86.3% funded, with a dollar gap of $1.80bn.

How much extra contribution closes the gap?

$0.131bn a year more, taking contributions from $0.400bn to $0.531bn, if the plan earns 6.75% every year.

The workbooks behind this article

The free companion files for The Asset Owner Investment Officer rebuild a fictional US public pension plan, its capital market assumptions, policy portfolios and asset-liability Monte Carlo with live formulas. The plan in this article is simplified and its figures are invented. No account and no email address.

Open the companion files →

Paperback on this topic

The Pension Risk Transfer Professional
170 pages, printed on demand and shipped worldwide, direct from the author: $32.99 paperback, $19.99 PDF. Not sold on Amazon. See the book →

The bookshop
151 handbooks and exam guides by Julian R. Sterling that are not on Amazon, sorted by subject. 15% off from 2 books. Browse the bookshop →

Also on this site

Reading guide: private equity and private markets → · All 1908 articles →