Liability information to analyse DB universe 31 March 2026

FOI reference - FOI-478
Date - 15 June 2026

Request

We are seeking updated information from The Pensions Regulator (TPR) to enhance our understanding of how the distribution of UK defined benefit (DB) pension schemes by size, funding level, and maturity within each covenant group has evolved over the past 12 months since our previous request.

This data will support our analysis of how the defined benefit scheme landscape is expected to shift over time as schemes progress toward various endgame strategies (e.g. insurance buyout, superfund, run-on). The insights may be used in both marketing and client advisory contexts.

Information request - liability and asset data

You previously provided us with data as at 31 March 2025 (reference FOI-399) on 15 August 2025. We are now requesting an updated version of the same dataset as at 31 March 2026. For ease of reference, we have outlined the specific information below:

For each of the 4 covenant groups (Strong, Tending to Strong, Tending to Weak and Weak), please could you provide the following:

Liability Data: Please provide the data as set out in the attached spreadsheet tab titled "Table 1 – liabilities" for the year ending 31 March 2026. We request that the data is presented in separate tables for each of the four covenant groups: Strong, Tending to Strong, Tending to Weak and Weak.
Asset Data: Please provide the data as set out in the attached spreadsheet tab titled "Table 2 – assets" in respect of asset allocations with an effective date on or after 31 March 2025 (recognising that schemes don't always provide updated asset splits in their annual returns). We request that the data is presented in separate tables for each of the four covenant groups: Strong, Tending to Strong, Tending to Weak and Weak.

We envisaged that this information could be presented in the same format as previously provided but for completeness we have attached a spreadsheet of example tables.

We acknowledge that due to restrictions regarding the sharing of individual scheme data you may not be able to provide the full set of ranges requested. Where this is the case, we are happy for you to expand the ranges requested which is consistent with the approach you adopted last year.”

Response

I confirm that we hold some of the information you have requested.

It is important to note that we are unable to provide all of the information requested, even though this is a request for a repeat of the information that we provided last year. In particular we no longer have access to the covenant data requested as this has been withdrawn following the introduction of the Funding and Investment Strategy (FIS) regulations that came into force during September 2024.

Since that date TPR now assesses employer covenant, and receives employer covenant information, in line with the requirements set out in the 2024 revised DB funding code and our employer covenant guidance.

The information we have been able to supply is in the spreadsheet.

Due to restrictions placed upon TPR regarding the sharing of individual scheme data, where the information request results in less than 5 schemes under any separate category, these have been aggregated with the next grouping band in order to reduce the risks of the identification of any specific individual scheme. We have therefore expanded the ranges requested, where needed, to ensure that individual schemes cannot be identified.

Please be aware of the following caveats and limitations which apply to the modelling underlying the information that we have provided.

Data

To produce our summary of estimates as at 31 March 2026 we have used the scheme funding data on our systems as at 31 March 2026. This data is based on the information provided to us from the 2026 annual scheme return, recovery plan submissions and statement of strategy submissions received up to that date.

The raw data and model outputs have been subject to actuarial data checks which look to highlight key outliers and are adjusted as necessary, but these are not comprehensive data checks of each item.

We have also used external data sources, these include:

Market indices data obtained from London Stock Exchange Group (LSEG) in order to estimate assets as at 31 March 2026; and
Office for National Statistics (ONS) to provide estimates of benefit outgo and contributions in respect of future accrual.

It is important to note that:

The underlying data is historical. Schemes have up to 15 months to complete a valuation and need to only undertake a valuation every 3 years. As such, the liability and asset values held are generally between 1 year and 4 years out of date.
The data is a high-level summary of the results of the valuation i.e. we do not have individual member data or detailed benefit structure information that schemes have access to.
The asset breakdown is based on the last audited accounts over the scheme return year. Schemes have up to 7 months from the year end to complete their audited accounts.
We only have data from the 2026 scheme return, therefore we would expect, the asset breakdown to be generally around 2 years out of date. As such the annuity data provided in this report is likely to ignore any insurance transactions that have occurred over the last 2 years.

Modelling methodology

The figures provided in this report are based on our modelling of the DB universe which estimates the aggregate assets and liabilities as at 31 March 2026 by “rolling forward” from schemes’ latest actuarial valuations, based on scheme data and relevant financial market information, as set out above.

The data for Technical Provisions, Buyout liabilities, Assets and Buyout funding levels have been estimated by the actuarial team at TPR by adjusting the position from a schemes latest triennial Part 3 valuation (some of which relate to scheme’s positions as far back as 2021) up to 31 March 2026. These estimates allow for the following calculation methodology:

In estimating the technical provisions, we assume that trustees do not make any changes to the funding methodology due to changing market conditions. We assume financial assumptions were set with reference to gilt markets and adjust for changes in gilt markets only.

In estimating buyout liabilities, we make allowance for changes in gilt markets and some broad adjustments to allow for changes in insurance premia over time.

In estimating assets 31 March 2026, we use relevant index returns based on the asset allocations submitted to TPR in the 31 March 2026 Scheme Return. (These asset allocations are as at the date of each Scheme’s latest audited accounts, rather than all being a consistent date).

The key assumptions underlying our model include:

Trustees do not take any management action in regards of buying/selling assets or changes to the investment allocation over time.
Both assets and liabilities are adjusted in line for expected benefit payments paid combined with an adjustment for future accrual, where applicable, over the period since a schemes last valuation.
Assets are further adjusted in line with movements in market indices plus deficit repair contributions, over the period since a schemes last valuation.
Assets are rebalanced daily in order to retain the same investment allocation.

There are many more simplifications and approximations in the methods we use to estimate aggregate and individual funding positions, compared with the more robust calculations carried out for formal valuation and recovery plan reporting by scheme actuaries for trustees. Additionally, the greater the magnitude of change in market conditions, the less reliable the simplified method and data will be in illustrating the impact of changing funding levels over time. It should be noted that this is not a TPR-specific issue, but a global actuarial issue when using the approximate ‘roll-forward’ methodology to estimating assets and liabilities at alternative dates.

Where asset data indicates that schemes have leveraged LDI (Liability Driven Investment), we have made broad adjustments to the asset values for any collateral calls that may have applied. Given the high level and limited data that we hold, our calculations use broad assumptions and approximations combined with general actuarial methods and techniques. We cannot take account of all scheme-specific characteristics, and the actual position of individual schemes will vary, depending on a number of individual factors not covered in our data or methodology.

Furthermore, it should be noted that results are always approximate in nature and whilst we do not expect a pronounced systemic bias in the model, results may be materially inaccurate at an individual scheme level where experience differs to those of our key assumptions. This could be because of any of the following:

Trustees taking positive management action to change investment strategies, which are not reflected in our current data set due to time lag issues; and/or
Actual asset returns are materially different to index returns or scheme experience materially differs from that assumed.

Further information regarding the methodology of our modelling is available from the TPR Pensions Insights and Modelling team on request.

Caveats and limitations of advice

We are content that the data used in the model is appropriate to provide high-level estimates of the distribution of the DB scheme universe as at 31 March 2026.

As the model has been calculated at an aggregate level, the results should not be used to draw conclusions for individual schemes, nor provide any analysis for scheme funding levels.

Compliance

This work complies with Technical Actuarial Standard 100 (TAS 100) v2.0, as published by the Financial Reporting Council (FRC). TAS 100 v2.0 applies to technical actuarial work (as defined in Section 4 of TAS 100 v2.0) that is completed on or after 1 July 2023