Case Study: Efficiency and control through Milliman Mind
This briefing note provides a short case study on migrating an Excel/VBA model to Milliman Mind.
The Milliman 100 PFI funded ratio increases to 85.1% as discount rates rise during October
The funded status of the 100 largest corporate defined benefit pension plans increased by $21 billion during October as measured by the Milliman 100 Pension Funding Index (PFI). The deficit declined to $285 billion primarily due to liability gains resulting from an increase in the benchmark corporate bond interest rates used to value those pension liabilities. This is the lowest PFI pension deficit since March, when it was $243 billion. As of October 31, the funded ratio improved to 85.1%, from 84.4% at the end of September. The market value of assets fell by $20 billion as a result of October’s 0.93% investment loss. The Milliman 100 PFI asset value decreased to $1.629 trillion at the end of October. By comparison, the 2020 Milliman Pension Funding Study reported that the monthly median expected investment return during 2019 was 0.53% (6.5% annualized). The full results of the annual 2020 study can be found at milliman.com/pfs. October’s asset decline is now the second consecutive month of negative investment returns.
|MV||PBO||FUNDED STATUS||FUNDED PERCENTAGE|
Note: Numbers may not add up precisely due to rounding
The projected benefit obligation (PBO) decreased by $41 billion during October, moving the Milliman 100 PFI liability value to $1.915 trillion. The PBO improvement was the result of a 14 basis point increase in the monthly discount rate, to 2.71% for October from 2.57% in September. Discount rates have now been on the rise for the last three months.
Over the last 12 months (November 2019–October 2020), the cumulative asset return for these pensions has been 5.75% and the Milliman 100 PFI funded status deficit has worsened by $42 billion. The primary reason for this widening of the funded status deficit has been discount rate declines over the past 12 months. Discount rates eroded, falling from 3.08% as of October 31, 2019 to 2.71% a year later. During the same time period the funded ratio of the Milliman 100 companies has decreased to 85.1% from 86.8%. We will continue to closely monitor the movement of the financial markets and the interest rate environment as year-end approaches.
If the Milliman 100 PFI companies were to achieve the expected 6.5% median asset return (as per the 2020 pension funding study), and if the current discount rate of 2.71% were maintained during years 2020 through 2021, we forecast that the funded status of the surveyed plans would increase. This would result in a projected pension deficit of $275 billion (funded ratio of 85.6%) by the end of 2020 and a projected pension deficit of $202 billion (funded ratio of 89.3%) by the end of 2021. For purposes of this forecast, we have assumed 2020 and 2021 aggregate annual contributions of $40 billion and $50 billion, respectively.
Under an optimistic forecast with rising interest rates (reaching 2.81% by the end of 2020 and 3.41% by the end of 2021) and asset gains (10.5% annual returns), the funded ratio would climb to 87% by the end of 2020 and 103% by the end of 2021. Under a pessimistic forecast with similar interest rate and asset movements (2.61% discount rate at the end of 2020 and 2.01% by the end of 2021 and 2.5% annual returns), the funded ratio would decline to 84% by the end of 2020 and 77% by the end of 2021.
For the past 20 years, Milliman has conducted an annual study of the 100 largest defined benefit pension plans sponsored by U.S. public companies. The Milliman 100 Pension Funding Index projects the funded status for pension plans included in our study, reflecting the impact of market returns and interest rate changes on pension funded status, utilizing the actual reported asset values, liabilities, and asset allocations of the companies’ pension plans.
The results of the Milliman 100 Pension Funding Index were based on the actual pension plan accounting information disclosed in the footnotes to the companies’ annual reports for the 2019 fiscal year and for previous fiscal years. This pension plan accounting disclosure information was summarized as part of the Milliman 2020 Pension Funding Study, which was published on April 28, 2020. In addition to providing the financial information on the funded status of U.S. qualified pension plans, the footnotes may also include figures for the companies’ nonqualified and foreign plans, both of which are often unfunded or subject to different funding standards than those for U.S. qualified pension plans. They do not represent the funded status of the companies’ U.S. qualified pension plans under ERISA.