Orkney Islands Council Pension Fund
Report on the actuarial valuation at 31 March 2023
March 2024
Tom Hoare FFA
Julie West FFA
For and on behalf of Hymans Robertson LLP
Hymans Robertson LLP
One London Wall
London EC2Y 5EA
t 020 7082 6000
f 020 7082 6082
20 Waterloo Street
Glasgow G2 6DB
t 0141 566 7777
f 0141 566 7788
45 Church Street
Birmingham B3 2RT
t 0121 210 4333
f 0121 210 4343
1 Semple Street
Edinburgh EH3 8BL
t 0131 656 5000
f 0131 656 5050
Hymans Robertson LLP® is a limited liability partnership registered in England and Wales with registered number OC310282. Authorised and regulated by the Financial Conduct Authority and licensed by the Institute and Faculty of Actuaries for a range of investment business activities.
© Hymans Robertson LLP. All rights reserved.
Classification: Public
IMAGE: The report cover shows the Hymans Robertson logo and the title “Orkney Islands Council Pension Fund — Report on the actuarial valuation at 31 March 2023”, dated March 2024, over a landscape with a setting sun and hills. It also identifies Tom Hoare FFA and Julie West FFA, for and on behalf of Hymans Robertson LLP, and lists the firm’s four office addresses.
Contents
Report on the actuarial valuation as at 31 March 2023
- 1 Executive summary — Page 1
- 2 Approach to the valuation — Page 2
- 3 Valuation results — Page 4
- 4 Sensitivity and risk analysis — Page 10
- 5 Final comments — Page 13
- Appendix 1: Data — Page 15
- Appendix 2: Assumptions — Page 17
- Appendix 3: Reliances & limitations — Page 21
- Appendix 4: Glossary — Page 22
- Appendix 5: Rates and Adjustments Certificate — Page 25
- Appendix 6: Section 13 dashboard — Page 27
1 Executive summary
We have been commissioned by Orkney Islands Council (“the Administering Authority”) to carry out a valuation of Orkney Islands Council Pension Fund (“the Fund”) as at 31 March 2023. This fulfils Regulation 60 of the Local Government Pension Scheme (Scotland) Regulations 2018. This report is a summary of the valuation.
1. Contribution rates
The contribution rates for individual employers set at this valuation can be found in the Rates and Adjustments certificate. Table 1 shows the combined individual employer rates set at this valuation and the last valuation.
Table 1: Whole fund contribution rates compared with the previous valuation
| 31 March 2023 | 31 March 2020 | |
|---|---|---|
| Primary rate | 22.1% of pay | 24.0% of pay |
| Secondary rate — 2024/25 / 2021/22 | -7.1% | -7.0% |
| Secondary rate — 2025/26 / 2022/23 | -7.1% | -7.0% |
| Secondary rate — 2026/27 / 2023/24 | -7.1% | -7.0% |
The overall contribution rate, expressed as a percentage of pay, has reduced due to both an improvement in the past service funding position and higher assumed future investment returns at 2023 compared to 2020.
2. Funding position
At 31 March 2023, the past service funding position has improved from the last valuation at 31 March 2020. Table 2 shows the single reported funding position at this valuation and the last valuation.
Table 2: Single reported funding position compared with the previous valuation
| 31 March 2023 (£m) | 31 March 2020 (£m) | |
|---|---|---|
| Employees | 124 | 154 |
| Deferred Pensioners | 46 | 50 |
| Pensioners | 123 | 115 |
| Total liabilities | 292 | 319 |
| Assets | 480 | 377 |
| Surplus (Deficit) | 188 | 58 |
| Fund level | 164% | 118% |
The required investment return to be 100% funded is c.2.5% p.a. (2.0% p.a. at 2020). The likelihood of the Fund’s investment strategy achieving the required return is 95% (83% at 2020).
1 Approach to the valuation
1.1 Valuation purpose
The triennial actuarial valuation is an important part of the Fund’s risk management framework. Its main purpose is to ensure the Fund continues to have a contribution plan and investment strategy that will achieve the objectives set out in the Funding Strategy Statement.
This report marks the culmination of the valuation process and contains its two key outcomes:
- Employer contribution rates for the period 1 April 2024 to 31 March 2027.
- The funding level of the whole Fund at 31 March 2023.
Further information on the valuation process, methodology and strategy is set out in the publicly available Funding Strategy Statement, Statement of Investment Principles and published papers of the Fund’s Pension Fund Sub-committee and Pension Board. Additional material is also contained in Hymans Robertson’s LGPS 2023 valuation toolkit.
1.2 Setting employer contribution rates
Employer contributions need to be set at a level which ensures the Fund has a reasonable likelihood of having enough money to pay members’ benefits. Identifying the amount of benefits that may be paid is complex, as benefits earned today may only start being paid in 50 years’ time. Over that period, there is significant uncertainty over factors which affect the cost of benefits e.g. inflation and investment returns. These uncertainties are allowed for by taking a risk-based approach to setting employer contribution rates. This approach is built around three key funding decisions set by the Fund.
1.2.1 Key funding decisions
Decision 1: What is the funding target for the employers?
Consider: Will the employer remain in the Fund for the long-term or exit at some point?Decision 2: What is the funding time horizon?
Consider: How long will the employers participate in the Fund?Decision 3: What is the required likelihood of success?
Consider: How much prudence can the employers’ covenant support in its funding plan?
1.2.2 Modelling approach
Asset-liability modelling is used to project each employer’s assets and benefit payments into the future using 5,000 different economic scenarios. These are generated using Hymans Robertson’s Economic Scenario Service (ESS). Further information on this can be found in Appendix 2.
A contribution rate is set for each employer which has (at least) the required likelihood of meeting the funding target over the relevant funding time horizon. The 5,000 projections of the employers’ assets and benefits from the asset-liability model are used to quantify the likelihood that a given contribution rate will meet this target.
1.3 Measuring the funding level
The past service funding level is measured at the valuation date. While it is limited in providing insight into a funding plan, it is a useful high-level summary statistic. A market-related approach is taken to calculate both the assets and the liabilities to ensure they are consistent with one another:
- The market value of the Fund’s assets at the valuation date has been used.
- The liabilities have been valued using assumptions based on market indicators at the valuation date (these assumptions are detailed in Appendix 2).
1.3.1 Calculating the liabilities
The liabilities are the value of all future payments to members based on all benefits earned up to the valuation date, expressed in today’s money.
Chart 1 shows the projected payments for all members in the Fund at the valuation date. The projections are based on the membership data provided for the valuation (Appendix 1), the assumptions (Appendix 2), and our understanding of the LGPS benefit structure as at 31 March 2023 (details at www.scotlgpsregs.org).
IMAGE: Chart 1 is a bar chart of projected benefit payments for all service earned up to 31 March 2023. The horizontal axis shows years from the valuation date, from year 1 to approximately year 96. The vertical axis shows benefits in £m, from 0 to £25m. Payments rise from approximately £11m in year 1 to a peak of approximately £20m around years 18–25, then decline steadily to near zero after approximately year 80.
Chart 1: Projected benefit payments for all service earned up to 31 March 2023
To express the future payments in today’s money, each projected payment is discounted back to the valuation date in line with an assumed rate of future investment return (known as the discount rate’).
2 Valuation results
2.1 Employer contribution rates
The primary objective of the Fund is to set employer contribution rates that will enable it to pay members’ benefits. A secondary objective is to ensure the rates are as stable as possible. The risk-based approach detailed earlier is used to meet both those objectives.
The employer contribution rate is made up of two components.
- A primary rate: the level sufficient to cover benefits that will be accrued in the future.
- A secondary rate: the costs associated with sufficiently funding benefits accrued up to the valuation date.
Each employer has a contribution rate which is appropriate to their circumstances, and these can be found in the Rates & Adjustments Certificate (Appendix 5).
Contribution rates have reduced at this valuation due to both an improvement in the past service funding position and higher assumed future investment returns at 2023 compared to 2020.
Table 3 shows the total of all employer contribution rates to be paid into the Fund over the period 1 April 2024 to 31 March 2027.
Table 3: Whole fund contribution rates compared with the previous valuation
| 31 March 2023 | 31 March 2020 | |
|---|---|---|
| Primary rate | 22.1% of pay | 24.0% of pay |
| Secondary rate — 2024/25 / 2021/22 | -7.1% | -7.0% |
| Secondary rate — 2025/26 / 2022/23 | -7.1% | -7.0% |
| Secondary rate — 2026/27 / 2023/24 | -7.1% | -7.0% |
The primary rate includes an allowance of 1.0% of pensionable pay for the Fund’s expenses (0.9% of pay at the last valuation).
Employees pay a contribution to the Fund in addition to these rates. These rates are set by the LGPS Regulations. The average employee contribution rate at 31 March 2023 is 6.0% of pay (6.0% at 31 March 2020).
2.2 Funding level
The funding level is the ratio of assets to liabilities. The market value of the assets at the valuation date is known. The value (in ‘today’s money’) of the future benefit payments is uncertain given that the level of future investment returns is unknown.
To help understand funding risk, the liabilities and therefore the funding level has been calculated across a range of different assumptions for future investment returns (also known as ‘discount rates’). The likelihood of the Fund’s investment strategy (detailed in Appendix 1) achieving those levels of return has also been calculated.
Chart 2 shows how the funding level varies with different future investment return assumptions at 31 March 2023 (blue line). The green line shows the same analysis at 31 March 2020.
- The funding position at 2023 is stronger than it was in 2020.
- The funding level at 2023 will be 100% if future returns are around 2.5% pa. The likelihood of the Fund’s assets yielding at least this return is around 95%.
- The comparator at 2020 was a return of 2.0% pa which had a likelihood of 83%.
- There is a 50% likelihood of an investment return of 7.2% pa, so the “best estimate” funding level is 225% at 31 March 2023.
IMAGE: Chart 2 compares funding levels across assumed future investment returns for 2020 and 2023. The horizontal axis ranges from 2.0% to 7.0% p.a.; the vertical axis ranges from 80% to 200% funding level. The 2020 line rises from approximately 100% funding at 2.0% return to approximately 173% at 5.0%, with likelihood labels including 80%, 75%, 70%, 66%, 60%, 55% and 50%. The 2023 line rises from approximately 100% at 2.5% return to above 200% at approximately 6.3%, with likelihood labels including 95%, 90%, 85%, 80%, 75%, 70% and 66%.
Chart 2: Funding level across a range of future investment returns.
Figures on each line show the likelihood of the Fund’s assets exceeding the level of return over the next 20 years.
2.3 Single funding level as at 31 March 2023
Whilst Chart 2 provides a better understanding of the past service funding position, there is still a requirement to report a single funding level at 31 March 2023.
To report a single funding level and funding surplus/deficit for the 2023 valuation, an assumed future investment return of 5.2% pa has been used. There is an 75% likelihood associated with this level of future investment return.
Table 4 sets out the assets and liabilities at the valuation date. The results at the 2020 valuation are shown for comparison.
The funding level and surplus/deficit figures provide a high-level snapshot of the funding position as at 31 March 2023, but there are limitations:
- The liabilities are calculated using a single set of assumptions about the future and so are very sensitive to the choice of assumptions.
- The market value of assets held by the Fund will change daily.
The future progression of the funding position is uncertain. If the financial and demographic assumptions made at this valuation occur in practice, employers pay contributions in line with the R&A certificate, and there are no other changes in the financial or demographic environment, we project that the funding level at the next valuation (31 March 2026) will stay approximately the same at 151%.
Table 4: Single reported funding position compared with the previous valuation
| 31 March 2023 (£m) | 31 March 2020 (£m) | |
|---|---|---|
| Employees | 124 | 154 |
| Deferred pensioners | 46 | 50 |
| Pensioners | 123 | 115 |
| Total liabilities | 292 | 319 |
| Assets | 480 | 377 |
| Surplus/(Deficit) | 188 | 58 |
| Funding level | 164% | 118% |
The reported funding level does not directly drive the contribution rates for employers. The contribution rates take into consideration how assets and liabilities will evolve over time in different economic scenarios. They also reflect each employer’s funding profile and covenant.
2.4 Changes since the last valuation
2.4.1 Events between 2020 and 2023
The most significant external event to occur since the last valuation has been the Covid-19 pandemic. However, the analysis below shows that mortality experience was broadly as expected over the period with minimal impact on the funding position.
A significant factor which has affected the funding strategy is better than expected investment returns. This has had a material positive impact on the funding position.
Table 5: Analysis of investment return experience between 2020 and 2023 valuations
| Financial | Expected | Actual | Difference | Impact on funding position |
|---|---|---|---|---|
| Investment returns — 3-year period | 9.0% | 26.4% | 17.4% | +£66m |
| Investment returns — Annual | 2.9% pa | 8.1% pa | 5.2% pa |
Table 6: Analysis of membership experience between 2020 and 2023 valuations
| Membership | Expected | Actual | Difference | Impact on funding position |
|---|---|---|---|---|
| Pre-retirement | ||||
| Early leavers | 622 | 477 | -145 | -£0.3m |
| Ill-health retirements | 32 | 37 | 5 | +£0.1m |
| Salary increases | 2.9% pa | 7.0% pa | 4.2% pa | -£11m |
| Post-retirement | ||||
| Benefit increases | 1.7% pa | 4.5% pa | 2.8% pa | -£26m |
| Pension ceasing | £0.5m | £0.6m | £0.1m | +£1m |
2.4.2 Outlook for the future
Expectations about the future, which inform the assumptions used to value the liabilities, have changed since the last valuation. The most significant changes are:
- Future inflation: this is expected to be on average higher than at 2020 due to the current high level of inflation.
- Investment returns: due to changes in financial markets, future investment returns are now expected to be higher than at the last valuation.
Table 7: Summary of change in outlook
| Factor | What does it affect? | What’s changed? | Impact on liabilities |
|---|---|---|---|
| Future investment returns | The rate at which you discount back future benefits payments (also known as the discount rate assumption) | Future investment returns are anticipated to be higher than at 2020. | Decrease of £149m |
| Inflation | The rate at which pensions (both in payment and deferment) and CARE pots increase. | Significant increase in short-term future inflation expectations. | Increase of £49m |
| Salary increases | The rate at which future salaries will increase. This affects benefits that are still linked to final salary, i.e. accrued before 1 April 2015. | No material change since last valuation given competing factors, eg tighter budgetary conditions vs. strong job market and pressure from National Living Wage increases. | Neutral |
| Current life expectancy | How long we expect most people to live for based on today’s current observed mortality rates. | Slight reduction in life expectancy (not allowing for Covid-related excess deaths) | Decrease of £2m |
| Future improvements in life expectancy | How we expect life expectancies to change (increase) in the future. | Updated model of future improvements to the most recent model available, including allowance for some recent mortality experience related to the excess deaths from the Covid 19 pandemic. | Decrease of £8m |
2.5 Reconciling the overall change in funding position
Tables 8 & 9 provide insight into the funding position change between 31 March 2020 and 31 March 2023. Firstly, the changes expected to happen (Table 8), which relate mostly to assets. Then the impact of actual experience (Table 9), which affects mainly the liabilities.
2.5.1 Expected development
Table 8: Expected development of funding position between 2020 and 2023 valuations
| Surplus/deficit (£m) | |
|---|---|
| 31 March 2020 valuation | 58 |
| Cash flows | |
| Employer contributions paid in | 24 |
| Employee contributions paid in | 9 |
| Benefits paid out | - |
| Net transfers into/out of the Fund | * |
| Other cash flows (e.g. expenses) | (5) |
| Expected changes | |
| Expected investment returns | 37 |
| Interest on benefits already accrued | (30) |
| Accrual of new benefits | (51) |
| Expected position at 31 March 2023 | 41 |
- We have insufficient data to accurately value the impact on the liabilities from transfers in/out. This has instead been combined with “Other cash flows”.
2.5.2 Impact of actual events
Table 9: Impact of actual events on the funding position at 31 March 2023
| Surplus/deficit (£m) | |
|---|---|
| Expected position at 31 March 2023 | 41 |
| Events between 2020 and 2023 | |
| Salary increases greater than expected | (11) |
| Benefit increases greater than expected | (26) |
| Early retirement strain (and contributions) | 0 |
| Ill health retirement strain | 0 |
| Early leavers less than expected | 0 |
| Pensioner mortality less than expected | 1 |
| Other membership experience | 9 |
| Higher than expected investment returns | 66 |
| Changes in future expectations | |
| Investment returns | 149 |
| Inflation | (49) |
| Salary increases | 0 |
| Longevity | 10 |
| Other demographic assumptions | (3) |
| Actual position at 31 March 2023 | 188 |
Numbers may not sum due to rounding.
3 Sensitivity and risk analysis
Funding benefits that are going to be paid in the future involves risk and uncertainty. The Fund therefore maintains a risk register which is regularly reviewed. Additionally, as part of the valuation, the Fund reviews sources of risk that may impact its funding position and the contribution rates payable by employers.
This section discusses some of the most significant sources of funding risk (assumptions, regulatory, administration and governance, and climate change). Further information about the Fund’s approach to funding risk management, including monitoring, mitigation, and management, is set out in the Funding Strategy Statement.
The valuation results depend on the actual assumptions made about the future. By their nature, these assumptions are uncertain which means it’s important to understand their sensitivity and risk levels.
3.1 Contribution rates
The risk-based approach to setting employer contribution rates mitigates the limitation of relying on one set of assumptions. Therefore, there is no need to carry out additional analysis of the sensitivity of contribution rates to changes in financial assumptions, but they are sensitive to changes in demographic assumptions. The results in this section in relation to the funding position can be broadly applied to the contribution rates.
3.2 Funding level
3.2.1 Financial assumptions
In Section 3.2 we have already set out how the results vary with the assumed future investment return. Here we consider inflation.
Table 10: Sensitivity of funding position to inflation assumption
| CPI assumption | Surplus/Deficit (£m) | Funding level (%) |
|---|---|---|
| 2.1% pa | 196 | 169% |
| 2.3% pa | 188 | 164% |
| 2.5% pa | 180 | 160% |
3.2.2 Demographic assumptions
The main area of demographic risk is if people live longer than expected. Table 11 shows the impact of longer-term longevity rates improving at a faster pace (1.75% pa vs 1.5% pa used in the headline results).
Table 11: Sensitivity of the funding to longevity assumption
| Long-term rate of improvement | Surplus/Deficit (£m) | Funding level (%) |
|---|---|---|
| 1.50% pa | 188 | 164% |
| 1.75% pa | 186 | 163% |
3.3 Other risks
3.3.1 Regulatory, Administration and Governance risks
Potential risks in this area include change in central government legislation, which alters the future cost of the LGPS, and failures in administration processes leading to incorrect data and inaccuracies in actuarial calculations. At this valuation, specific risks include:
McCloud
Benefits accrued by certain members between 2015 and 2022 may increase following the McCloud case, which ruled that transitional protections introduced in 2015 for older members were discriminatory. We’ve made an allowance for the cost of these potential improvements, based on the guidance issued by the Scottish Public Pensions Agency on 28 April 2023. Details are set out in guide 12 of Hymans Robertson’s LGPS 2023 valuation toolkit.
Cost sharing mechanism
Benefits could change because of the 2020 cost cap valuation; the outcome is currently unknown. We have assumed that there will be no changes required to the benefit structure due to the cost cap.
Goodwin
As the remedy to this issue is still uncertain, it is difficult to identify who it would apply to. Given its impact is estimated to be very small for an LGPS fund, we have made no allowance for this change at the 2023 valuation.
GMP Indexation
It is assumed that all increases on GMPs for members reaching State Pension age after 6 April 2016 will be paid for by LGPS employers in the Fund. This is the same approach that was taken for the 2020 valuation.
3.3.2 Post valuation events
Since 31 March 2023, there has been continued volatility in financial markets and rises in interest rates by central banks. These events affect the value of the Fund’s assets and liabilities.
- The Fund’s investment return since 31 March 2023 is estimated to be between 5% and 10%.
- Liability valuations are likely to be lower now than at 31 March 2023 due to rises in expected future investment returns and a reduction in long-term inflation expectations.
As an open scheme, with a strong covenant, the Fund takes a long-term view when considering the funding impact of such events. For employers who have a very short time horizon recent volatility may be more immediately impactful, and the Fund has engaged with these employers as appropriate.
No explicit allowance has been made for this volatility in the valuation results or contribution rates detailed in the Rates & Adjustments Certificate. The Fund will continue to monitor changes in the financial and demographic environment as part of its ongoing risk management approach.
3.4 Climate change
3.4.1 Background
Climate change is a major source of uncertainty which could affect future investment returns, inflation, and life expectancies. Therefore, the Fund has explicitly explored the resilience of its funding and investment strategy to future potential climate change outcomes.
It is impossible to confidently quantify the effect of climate risk given the significant uncertainty over the impact of different possible climate outcomes. Instead, three different climate change scenarios have been considered as a stress test (instead of trying to predict how climate change affects the funding level in the future).
All the scenarios assume that there will be a period of disruption linked either to the response to climate risk (transition risks) or the effect of it (physical risks). This disruption will lead to high volatility in financial markets, and the later the disruption, the more pronounced it will be.
More information about the scenarios detailed below can be found in guide 10 of Hymans Robertson’s LGPS 2023 valuation toolkit.
3.4.2 Outcome of analysis
The Fund has set its funding and investment strategy using asset-liability modelling and considering two main risk metrics.
- Likelihood of success — the chance of being fully funded in 20 years’ time.
- Downside risk — the average worst 5% of funding levels in 20 years’ time.
When exploring the potential impact of climate change, the Fund has compared how these risk metrics change under each climate change scenario (against the ‘core’ model used when setting the funding and investment strategy). The stress-test results for the Fund are shown in Table 12. All results are in absolute terms.
Table 12: Modelling results with additional climate risk testing
| Scenario | Likelihood of success | Downside risk |
|---|---|---|
| In comparison to ‘core’ modelling results | ||
| Green revolution | 1% higher | 3% higher |
| Delayed transition | 1% lower | 1% lower |
| Head in the sand | 1% lower | 6% lower |
The ‘likelihood of success' is broadly the same in the climate scenarios. However, climate scenarios are a stress test so it is important understand the potential impact on the downside risk. The ‘downside risk’ measure is better in the ‘green revolution’ scenario and worse in the ‘delayed transition’ and ‘head in the sand’ scenarios which highlights the importance of monitoring this risk and how it may evolve.
The climate risk results are not materially different to the ‘core’ modelling results, and not enough to suggest that the funding strategy is unduly exposed to climate change risk. The Fund will continue to monitor this risk as more information emerges and climate change modelling techniques evolve.
4 Final comments
The Fund’s valuation operates within a broader framework, and this document should be considered alongside the following:
- The Funding Strategy Statement, which in particular highlights how different employers in different circumstances have their contributions calculated.
- The Statement of Investment Principles, which sets out the investment strategy for the Fund.
- The general governance of the Fund, including meetings of the Pensions Committee and Local Pensions Board, decisions delegated to officers, the Fund’s business plan, etc.
4.1 New employers joining the Fund
Any new employers or admission bodies joining the Fund should be referred to the Fund Actuary to assess the required level of contribution. Depending on the number of transferring members the ceding employer’s rate may also need to be reviewed.
4.2 Cessation and bulk transfers
Any employer who ceases to participate in the Fund should be referred to the Fund Actuary in accordance with Regulation 61 of the LGPS regulations.
Any bulk movement of scheme members:
- involving 10 or more scheme members being transferred from or to another LGPS fund;
- involving 2 or more scheme members being transferred from or to a non-LGPS pension arrangement;
should be referred to the Fund Actuary to consider the impact on the Fund.
4.3 Valuation frequency
Under the LGPS regulations, the next formal valuation of the Fund is due to be carried out as at 31 March 2026 where contribution rates payable from 1 April 2027 will be set.
Tom Hoare FFA
Julie West FFA
February 2024
For and on behalf of Hymans Robertson LLP
Hymans Robertson LLP® is a limited liability partnership registered in England and Wales with registered number OC310282. Authorised and regulated by the Financial Conduct Authority and licensed by the Institute and Faculty of Actuaries for a range of investment business activities.
© Hymans Robertson LLP. All rights reserved.
Appendices
Appendix 1: Data
Membership data
A summary of the membership data provided by the Fund for the 2023 valuation is set out in Table 13. The corresponding membership data from the previous valuation is also shown for reference.
The results of the valuation are dependent on the quality of the data used. We have carried out a series of validation checks on the data supplied to us by the Administering Authority to ensure that it is fit for purpose.
More information on how we verify the quality of the data used in the valuation has been shared with the Administering Authority in our report ‘Data Report for the 2023 Valuation, dated 27 November 2023.
Asset data
To check the membership data and derive employer asset values, we have used asset and accounting data and employer level cash flow data provided by the Fund.
Table 13: Whole Fund membership data at this valuation compared with the previous valuation
| Whole Fund membership data | 31 March 2023 | 31 March 2020 |
|---|---|---|
| Employee members | ||
| Number | 2,781 | 2,669 |
| Total actual pay (£000) | 52,308 | 43,528 |
| Total accrued pension (£000) | 10,141 | 8,283 |
| Average age (liability weighted) | 53.7 | 52.1 |
| Future working lifetime (years) | 10.1 | 8.7 |
| Deferred pensioners (including undecideds) | ||
| Number | 1,478 | 1,311 |
| Total accrued pension (£000) | 3,573 | 2,504 |
| Average age (liability weighted) | 53.5 | 51.1 |
| Pensioners and dependants | ||
| Number | 1,307 | 1,081 |
| Total pensions in payment (£000) | 8,789 | 6,518 |
| Average age (liability weighted) | 68.1 | 67.2 |
Investment strategy
A summary of the investment strategy allocation used for the calculation of employer contribution rates and to derive the future investment return is set out in Table 14.
This information was provided by Fund Officers.
Table 14: Investment strategy allocation used for the calculation of employer contribution rates
| Asset class | Allocation |
|---|---|
| UK equities | 7% |
| Overseas equities | 36% |
| DGF High Beta | 17% |
| Total growth assets | 60% |
| Index-linked gilts | 10% |
| Fixed interest gifts | 10% |
| Total protection assets | 20% |
| Infrastructure | 10% |
| Private lending | 10% |
| Total income generating assets | 20% |
| Total | 100% |
Appendix 2: Assumptions
To set and agree assumptions for the valuation, the Fund carried out an in-depth analysis and review in August 2023 with the final set noted by the Pensions Committee on 20 September 2023.
Financial assumptions
Setting employer contribution rates
An asset-liability model was used to set employer contributions at the 2023 valuation. This model relies on Hymans Robertson’s proprietary economic model, the Economic Scenario Service (ESS). The ESS reflects the uncertainty associated with future levels of inflation and asset returns and the interactions and correlations between different asset classes and wider economic variables. In the short term (first few years), the models are fitted with current financial market expectations. Over the longer term, models are built around views of fundamental economic parameters, for example equity risk premium, credit spreads and long-term inflation. The table below shows the calibration of the ESS at 31 March 2023. Further information on the assumptions used for contribution rate setting is included in the Funding Strategy Statement.
Table 15: ESS individual asset class return distributions at 31 March 2023
| Time period | Percentile | DGF (high equity beta) | All World ex UK Equity (unhedged) | UK Equity | Index Linked Gilts (long) | Fixed Interest Gilts (medium) | Unlisted Infrastructure Equity | Direct Lending (private debt) Hedged | Inflation (CPI) | 17 year real yield (CPI) | 17 year yield |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 10 years | 16th | 2.6% | 1.4% | 1.3% | 0.4% | 2.4% | 2.4% | 4.8% | 0.9% | -0.3% | 2.7% |
| 10 years | 50th | 7.0% | 7.6% | 7.5% | 2.7% | 3.7% | 7.8% | 7.6% | 2.5% | 0.9% | 4.1% |
| 10 years | 84th | 11.3% | 13.7% | 13.5% | 5.4% | 4.9% | 13.2% | 10.3% | 4.1% | 2.2% | 5.9% |
| 20 years | 16th | 3.9% | 3.1% | 3.0% | 0.7% | 3.3% | 3.9% | 5.7% | 0.7% | -0.5% | 1.4% |
| 20 years | 50th | 7.1% | 7.7% | 7.5% | 2.4% | 4.1% | 7.9% | 7.8% | 2.3% | 1.3% | 3.4% |
| 20 years | 84th | 10.6% | 12.5% | 12.0% | 4.2% | 4.8% | 12.0% | 9.8% | 3.9% | 2.9% | 5.9% |
| 40 years | 16th | 4.3% | 4.0% | 3.9% | 0.9% | 2.9% | 4.5% | 5.7% | 0.6% | -0.6% | 1.2% |
| 40 years | 50th | 7.0% | 7.4% | 7.4% | 2.3% | 3.7% | 7.7% | 7.6% | 2.0% | 1.3% | 3.3% |
| 40 years | 84th | 9.9% | 11.2% | 10.9% | 4.0% | 4.9% | 11.1% | 9.7% | 3.5% | 3.2% | 6.1% |
| Volatility (5yr) | 13% | 18% | 18% | 8% | 5% | 15% | 9% | 3% | - | - |
Calculating the funding level
Table 16 summarises the assumptions used to calculate the funding level at 31 March 2023, along with a comparison at the last valuation.
Table 16: Summary of assumptions used for measuring the funding level, compared to last valuation
| Assumption | 31 March 2023 | Required for | 31 March 2020 |
|---|---|---|---|
| Discount rate | 5.2% pa | To place a ‘today’s money’ value on all the benefits promised to scheme members at the valuation date. The Fund’s assets are estimated to have a 75% likelihood of achieving a return that is at least equal the discount rate. | 2.9% pa |
| Benefit increases/CARE revaluation | 2.3% pa | To determine the size of future benefit payments. | 1.7% pa |
| Salary increases | 2.8% pa | To determine the size of future final-salary linked benefit payments. | 2.2% pa |
*plus a promotional salary scale
Demographic assumptions
The same demographic assumptions are used to set contribution rates and assess the current funding level.
Longevity
Table 17: Summary of longevity assumptions at this valuation compared with the previous valuation
| 31 March 2023 | 31 March 2020 | |
|---|---|---|
| Baseline assumptions | VitaCurves based on member-level lifestyle factors | VitaCurves based on member-level lifestyle factors |
| Future improvements | CMI 2022 model; Initial addition = 0.25% (both Male and Female); Smoothing factor = 7.0; Weighting = 0% (2020 & 2021 data), 25% (2022 data); 1.5% pa long-term rate | CMI 2019 model; Initial addition = 0.5% (both Male and Female); Smoothing factor = 7.0; 1.5% pa long-term rate of improvement |
Other demographic assumptions
Table 18: Summary of other demographic assumptions
| Assumption | Explanation |
|---|---|
| Death in service | See sample rates in Table 19 |
| Retirements in ill health | See sample rates in Table 19 |
| Withdrawals | See sample rates in Table 19 |
| Promotional salary increases | See sample rates in Table 19 |
| Commutation | 50% of future retirements elect to exchange pension for additional tax-free cash up to HMRC limits |
| 50:50 option | 0.0% of members (uniformly distributed across the age, service and salary range) will choose the 50:50 option |
| Retirement age | The earliest age at which a member can retire with their benefits unreduced |
| Proportion married | A varying proportion of members are assumed to have a dependant at retirement or on earlier death. For example, at age 60 this is assumed to be 85% for males and 60% for females. The dependant of a male member is assumed to be 2 years younger than him and the dependant of a female member is assumed to be 3.5 years older than her. |
Sample rates for demographic assumptions
Males
| Age | Salary scale | Death before retirement FT & PT | Withdrawals FT | Withdrawals PT | Ill health Tier 1 FT | Ill health Tier 1 PT | Ill health Tier 1 FT | Ill health Tier 1 PT |
|---|---|---|---|---|---|---|---|---|
| 20 | 105 | 0.21 | 270.14 | 410.03 | 0 | 0 | 0 | 0 |
| 25 | 117 | 0.21 | 178.44 | 270.84 | 0.11 | 0.02 | 0.13 | 0.02 |
| 30 | 131 | 0.26 | 126.57 | 192.12 | 0.21 | 0.03 | 0.23 | 0.03 |
| 35 | 144 | 0.30 | 98.87 | 150.07 | 0.41 | 0.14 | 0.46 | 0.15 |
| 40 | 154 | 0.51 | 79.56 | 120.76 | 0.62 | 0.26 | 0.69 | 0.24 |
| 45 | 164 | 0.86 | 46.50 | 98.81 | 0.99 | 0.51 | 1.09 | 0.49 |
| 50 | 174 | 1.37 | 36.02 | 76.54 | 1.86 | 1.31 | 2.59 | 1.45 |
| 55 | 179 | 2.15 | 34.60 | 73.52 | 5.83 | 4.52 | 4.67 | 3.11 |
| 60 | 184 | 3.86 | 30.82 | 65.48 | 9.91 | 6.97 | 3.87 | 2.65 |
| 65 | 185 | 6.44 | 0 | 0 | 18.92 | 13.49 | 0 | 0 |
Females
| Age | Salary scale | Death before retirement FT & PT | Withdrawals FT | Withdrawals PT | Ill health Tier 1 FT | Ill health Tier 1 PT | Ill health Tier 1 FT | Ill health Tier 1 PT |
|---|---|---|---|---|---|---|---|---|
| 20 | 105 | 0.11 | 218.44 | 186.33 | 0 | 0 | 0 | 0 |
| 25 | 117 | 0.11 | 146.95 | 125.35 | 0.16 | 0.13 | 0.09 | 0.10 |
| 30 | 131 | 0.16 | 123.14 | 105.04 | 0.21 | 0.18 | 0.12 | 0.13 |
| 35 | 144 | 0.27 | 75.86 | 90.60 | 0.41 | 0.34 | 0.24 | 0.25 |
| 40 | 154 | 0.44 | 63.10 | 75.35 | 0.61 | 0.51 | 0.36 | 0.37 |
| 45 | 164 | 0.71 | 51.94 | 62.03 | 0.82 | 0.68 | 0.48 | 0.50 |
| 50 | 174 | 1.04 | 39.58 | 47.27 | 1.50 | 1.23 | 1.11 | 1.13 |
| 55 | 179 | 1.37 | 37.03 | 44.22 | 5.47 | 4.43 | 2.32 | 2.35 |
| 60 | 184 | 1.75 | 29.77 | 35.55 | 11.52 | 9.30 | 2.38 | 2.40 |
| 65 | 185 | 2.25 | 0 | 0 | 20.73 | 16.76 | 0 | 0 |
Table 19: Sample rates of male and female demographic assumptions.
Figures are incidence rates per 1,000 members except salary scale.
FT and PT denoted full-time and part-time members respectively.
Appendix 3: Reliances & limitations
We have been commissioned by Orkney Islands Council (‘the Administering Authority’) to carry out a full actuarial valuation of Orkney Islands Council Pension Fund (‘the Fund’) at 31 March 2023, as required under Regulation 60 of the Local Government Pension Scheme (Scotland) Regulations 2018 (‘the Regulations’).
This report is addressed to the Administering Authority. It has been prepared by us as actuaries to the Fund and is solely for the purpose of summarising the main outcomes of the 2023 actuarial valuation. It has not been prepared for any other third party or for any other purpose. We make no representation or warranties to any third party as to the accuracy or completeness of this report, no reliance should be placed on this report by any third party and we accept no responsibility or liability to any third party in respect of it.
Hymans Robertson LLP is the owner of all intellectual property rights in this report. All such rights are reserved.
This summary report is the culmination of other communications in relation to the valuation, in particular:
- our 2023 valuation toolkit which sets out the methodology used when reviewing funding plans;
- our paper dated 8 December 2023 which discusses the funding strategy for the Fund’s employers;
- our paper dated 16 August 2023 which discusses the valuation assumptions;
- our initial results report dated 3 November 2023 which outlines the whole Fund results and inter-valuation experience;
- our data report dated 27 November 2023 which summarises the data used for the valuation, the approach to ensuring it is fit for purpose and any adjustments made to it during the course of the valuation;
- the Funding Strategy Statement which details the approach taken to adequately fund the current and future benefits due to members.
The totality of our advice complies with the Regulations as they relate to actuarial valuations.
The following Technical Actuarial Standards apply to this advice, and have been complied with where material and to a proportionate degree. They are:
- TAS100 – Principles for technical actuarial work
- TAS300 – Pensions
Hymans Robertson LLP is a limited liability partnership registered in England and Wales with registered number OC310282.
A list of members of Hymans Robertson LLP is available for inspection at One London Wall, London EC2Y 5EA, the firm’s registered office. Authorised and regulated by the Financial Conduct Authority and licensed by the Institute and Faculty of Actuaries for a range of investment business activities. Hymans Robertson is a registered trademark of Hymans Robertson LLP.
Appendix 4: Glossary
| Term | Explanation |
|---|---|
| 50:50 option | An option for LGPS members to pay half contributions and earn half the retirement benefit (pre-retirement protection benefits are unreduced). |
| Asset-liability modelling | An approach to modelling and understanding risk for a pension fund. The assets and liabilities are projected forwards into the future under many different future scenarios of inflation, investment returns and interest rates. The future scenarios are then analysed to understand the risk associated with a particular combination of contribution rates and investment strategy. Different combinations of contribution rates and/or investment strategies may be tested. |
| Baseline longevity | The rates of death (by age and sex) in a given group of people based on current observed data. |
| Club Vita | A firm of longevity experts who Hymans Robertson partner with for longevity analysis. They combine data from thousands of pension schemes and use it to create detailed baseline longevity assumptions at member-level, as well as insights on general longevity trends and future improvements. |
| Commutation | The option for members to exchange part of their annual pension for a one-off lump sum at retirement. In the LGPS, every £1 of pension exchanged gives the member £12 of lump sum. The amounts that members commute is heavily influenced by tax rules which set an upper limit on how much lump sum can be taken tax-free. |
| CPI inflation | The annual rate of change of the Consumer Prices Index (CPI). The CPI is the UK government’s preferred measure of inflation and is the measure used to increase LGPS (and all other public sector pension scheme) benefits each year. |
| Deferred pensioner | A former employee who has left employment (or opted out of the pension fund) but is not yet in receipt of their benefits from the fund. |
| Demographic assumptions | Assumptions concerned with member and employer choices rather than macroeconomic or financial factors. For example, retirement age or promotional salary scales. Demographic assumptions typically determine the timing of benefit payments. |
| Discount rate | An assumption for the annual rate of future investment return. Used to place a single ‘today’s money’ value on a stream of future payments. |
| Employee members | Members who are currently employed by employers who participate in the Fund and are paying contributions into the Fund. |
| ESS | Economic Scenario Service - Hymans Robertson’s proprietary economic scenario generator used to create thousands of simulations of future inflation, asset class returns and interest rates. |
| Funding position | The extent to which the assets held by the Fund at 31 March 2023 cover the accrued benefits ie the liabilities. The two measures of the funding position are: the funding level - the ratio of assets to liabilities; and the funding surplus/deficit - the difference between the asset and liabilities values. |
| Inflation | Prices tend to increase over time, which is called inflation. Inflation is measured in different ways, using a different ‘basket’ of goods and mathematical formulas. |
| Liabilities | An employer’s liability value is the single value at a given point in time of all the benefit payments expected to be made in future to all members. Benefit payments are projected using demographic and financial assumptions and the liability is calculated using a discount rate. |
| Longevity improvements | An assumption about how rates of death will change in future. Typically, we assume that death rates will fall and life expectancies will improve over time, continuing the long-running trend. |
| Pensioner | A former employee who is in receipt of their benefits from the fund. This category includes eligible dependants of the former employee. |
| Primary rate | The estimated cost of future benefits, expressed in percentage of pay terms. The primary rate will include an allowance to cover the Fund’s expenses. |
| Prudence | To be prudent means to err on the side of caution in the overall set of assumptions. We build prudence into the choice of discount rate by choosing an assumption with a prudence level of more than 50%. All other assumptions aim to be best estimate. |
| Prudence level | A percentage indicating the likelihood that the assumed rate of investment return will be achieved in practice, based on the ESS model. The higher the prudence level, the more prudent the assumed rate of investment return. |
| Secondary rate | An adjustment to the primary rate, generally to reflect costs associated with benefits that have already been earned up to the valuation date. This may be expressed as a percentage of pay and/or monetary amount. |
| Withdrawal | Refers to members leaving the scheme before retirement. These members retain an entitlement to an LGPS pension when they retire but are no longer earning new benefits. |
Appendix 5: Rates and Adjustments Certificate
In accordance with Regulation 60(4) of the Regulations, we have assessed the contributions that should be paid into the Fund by participating employers for the period 1 April 2024 to 31 March 2027 to maintain the solvency of the Fund.
The method and assumptions used to calculate the contributions set out in this Rates and Adjustments Certificate are detailed in the Funding Strategy Statement dated 1 April 2024 and in Appendix 2 of the report on the actuarial valuation dated 20 March 2024. These assumptions underpin our estimate of the number of members who will become entitled to a payment of pensions under the provisions of the LGPS and the amount of liabilities arising in respect of such members.
The table below summarises the whole Fund primary and secondary contribution rates for the period 1 April 2024 to 31 March 2027. The primary rate is the payroll weighted average of the underlying individual employer primary rates and the secondary rate is the total of the underlying individual employer secondary rates, calculated in accordance with the LGPS regulations and CIPFA guidance. The secondary rate has been shown both as a monetary amount and an equivalent percentage of the projected pensionable pay.
Tom Hoare FFA
Julie West FFA
March 2024
For and on behalf of Hymans Robertson LLP
Table 20: Whole fund contribution rates from 1 April 2024 to 31 March 2027
| This valuation (31 March 2023) | |
|---|---|
| Primary rate | 22.1% of pay |
| Secondary rate | % of payroll |
| 2024/25 | -7.1% |
| 2025/26 | -7.1% |
| 2026/27 | -7.1% |
The required minimum contribution rates for each employer in the Fund are set out in the remainder of this certificate.
| Employer code | Employer name | Primary rate (% of pay) | Secondary rate (% of pay), 2024/25 | Secondary rate (% of pay), 2025/26 | Secondary rate (% of pay), 2026/27 | Total contributions, 2024/25 | Total contributions, 2025/26 | Total contributions, 2026/27 | Notes |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Orkney Islands Council | 22.1% | -7.1% | -7.1% | -7.1% | 15.0% | 15.0% | 15.0% | |
| 10 | Orkney Ferries Limited | 22.1% | -7.1% | -7.1% | -7.1% | 15.0% | 15.0% | 15.0% | |
| 14 | Pickaquoy Centre Trust | 22.1% | -7.1% | -7.1% | -7.1% | 15.0% | 15.0% | 15.0% | |
| 16 | Orkney Islands Property Development Ltd | 22.1% | -7.1% | -7.1% | -7.1% | 15.0% | 15.0% | 15.0% |
Notes to the Rates & Adjustments Certificate
- Contributions expressed as a percentage of payroll should be paid into the Fund at a frequency in accordance with the requirements of the Regulations.
- Further sums should be paid to the Fund to meet the costs of any early retirements and/or augmentations using methods and factors issued by us from time to time or as otherwise agreed.
- The certified contribution rates represent the minimum level of contributions to be paid. Employing authorities may pay further amounts at any time and future periodic contributions may be adjusted on a basis approved by the Fund Actuary.
Appendix 6: Section 13 dashboard
2023 funding position – local funding basis
| Metric | Unit | 2023 Valuation |
|---|---|---|
| Funding level (assets/liabilities) | % | 164% |
| Funding level (change since previous valuation) | % | 46% increase |
| Asset value used at the valuation | £m | 480 |
| Value of liabilities (including McCloud liability) | £m | 292 |
| Surplus (deficit) | £m | 188 |
| Discount rate (past service) | % pa | 5.2% |
| Discount rate (future service) | % pa | Past service and future service are consistently valued with the same underlying assumptions, methodologies, and models regarding future expected levels of inflation, interest rates and investment returns. |
| Assumed pension increase (CPI) | % pa | 2.3% |
| Method of derivation of discount rate, plus any changes since previous valuation | There is an 75% likelihood that the Fund's assets will return at least 5.2% over the 20 years following the 2023 valuation date. The same methodology was used for the 2020 valuation. |
Assumed life expectancy at age 65
| Metric | Unit | 2023 Valuation |
|---|---|---|
| Life expectancy for current pensioners – men age 65 | Years | 20.9 |
| Life expectancy for current pensioners – women age 65 | Years | 23.7 |
| Life expectancy for future pensioners – men age 45 | Years | 22.1 |
| Life expectancy for future pensioners – women age 45 | Years | 25.6 |
Past service funding position – SAB basis (for comparison purposes only)
| Metric | Unit | 2023 Valuation |
|---|---|---|
| Market value of assets | £m | 480 |
| Value of liabilities | £m | 332 |
| Funding level on SAB basis (assets/liabilities) | % | 144% |
| Funding level on SAB basis (change since last valuation) | % | 2% decrease |
Contribution rates payable
| Metric | Unit | 2023 Valuation | 2020 Valuation |
|---|---|---|---|
| Primary contribution rate | % of pay | 22.1% | 24.0% |
| Secondary contribution rate — 1st year of rates and adjustments certificate | £m | -3.926 | -3.184 |
| Secondary contribution rate — 2nd year of rates and adjustments certificate | £m | -4.036 | -3.256 |
| Secondary contribution rate — 3rd year of rates and adjustments certificate | £m | -4.149 | -3.328 |
| Giving total expected contributions — 1st year (£ figure based on assumed payroll) | £m | 8.294 | 7.734 |
| Giving total expected contributions — 2nd year (£ figure based on assumed payroll) | £m | 8.527 | 7.906 |
| Giving total expected contributions — 3rd year (£ figure based on assumed payroll) | £m | 8.766 | 8.083 |
| Assumed payroll — 1st year rates and adjustments certificate | £m | 55.291 | 45.492 |
| Assumed payroll — 2nd year rates and adjustments certificate | £m | 56.845 | 46.507 |
| Assumed payroll — 3rd year rates and adjustments certificate | £m | 58.443 | 47.545 |
| Three-year average | % of pay | 15.0% | 17.0% |
| Average employee contribution | % of pay | 6.0% | 6.0% |
| Employee contribution rate (£ figure based on year 1 assumed payroll) | £m pa | 3.32 | 2.73 |
Deficit recovery and surplus spending plan
| Metric | Unit | 2023 Valuation | 2020 Valuation |
|---|---|---|---|
| Latest deficit recovery period end date, where this methodology is used by the fund’s actuarial advisor. | Year | Methodology not used | Methodology not used |
| Earliest surplus spreading period end date, where this methodology is used by the fund’s actuarial advisor. | Year | Methodology not used | Methodology not used |
| The time horizon end date, where this methodology is used by the fund’s actuarial advisor | Year | 2043 | 2040 |
| The funding plan’s likelihood of success, where this methodology is used by the fund’s actuarial advisor. | % | 75% | 75% |
| Percentage of liabilities relating to employers with deficit recovery periods of longer than 20 years | % | 0% | 0% |
Additional information
| Metric | Unit | 2023 Valuation | 2020 Valuation |
|---|---|---|---|
| Percentage of total liabilities that are in respect of Tier 3 employers | % | 0% | 0.14% |
| Included climate change analysis/comments in the 2023 valuation report | Yes | Not applicable | |
| Value of McCloud liability in the 2023 valuation report (on local funding basis) | £m | 2 | Not applicable |