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
Item
Value
Assets today
8.00
Liabilities today
10.00
Funded ratio today
80.0%
Benefit payments a year
0.70
Contributions a year
0.40
New benefits earned a year (service cost)
0.25
Liability discount rate and assumed return
6.75%
Horizon
10 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
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
Case
Assets, $bn
Funded ratio
Earns 5.75% a year
10.084
77.1%
Earns 6.75% a year
11.277
86.3%
Earns 7.75% a year
12.581
96.2%
Earns 6.75% with $0.131bn more contributed a year
13.072
100.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
Assuming the assumed return closes the gap. Earning exactly 6.75% leaves the plan 86.3% funded after ten years, with a gap of $1.80bn still open.
Ignoring the starting gap and the net outflow. The assets are $2.00bn short and the plan pays $0.30bn more than it receives each year. That is why the required return, 8.10%, is well above the 6.75% that the liabilities grow at.
Comparing the required return with the assumption alone. It also has to be compared with what the portfolio can plausibly earn after fees, and more risk to earn more can widen the gap in a bad decade.
Holding the discount rate fixed in the argument. A lower discount rate raises the liabilities and the return needed. The figures here assume it stays at 6.75%.
Takeaway
A plan below 100% funded needs a return above its liability growth rate to close the gap; solve it with RATE on assets, net cash flow and the target liabilities.
Here the plan needs 8.10% a year for ten years, against a 6.75% assumption that leaves it 86.3% funded.
Contributions of $0.531bn a year, $0.131bn more, close the gap at the assumed return.
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.
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 →