Data visualisation techniques used in annual Up-rating report
GAD publishes its annual report on the impact on the National Insurance Fund, of Up-rating Social Security Benefits and updating National Insurance Contributions.
The Government Actuary Department鈥檚 (GAD) annual report on the overall balance of the National Insurance Fund (NIF) has just been published.
Our report provides advice to MPs as they scrutinise the government鈥檚 draft legislation Up-rating Social Security Benefits and updating National Insurance Contribution (NIC) terms.
The report鈥檚 results project contribution income, benefit payments and the balance of the NIF over the coming financial year.
Main results
The headline results are that:
- income is projected to exceed expenditure by 拢8.2bn increasing the NIF balance to 拢44.9bn
- costs of the proposed changes to NICs paid to the NIF are estimated at 拢2.0bn - these deliver the government鈥檚 commitment to raise the primary threshold to 拢9,500 a year saving the typical employee 拢104 a year
- costs of the proposed benefit increases paid from the NIF are estimated at 拢3.4bn - these incorporate the government鈥檚 鈥榯riple lock鈥� policy with pensioners who receive the full basic State Pension getting an extra 拢263 a year and those receiving the full rate of new State Pension getting an extra 拢344 a year
- the NIF is not expected to need any top-up from the Treasury
- 5-year projections show the NIF balance increasing up to the 2024-2025 financial year
All the headline results are sensitive to future economic conditions.
Data visualisation
At GAD we continually look for new ways to work. Both in terms of seeking more efficient ways of working and presenting our report conclusions in clear and engaging styles.
For this report we updated our benefit and NICs projection models as part of transferring the calculation processes to our central actuarial services team. We also considered how to use data visualisation to modernise our presentation.
The Up-rating report project was led by GAD Senior Consulting Actuary Chris Morley. He said: 鈥淕AD鈥檚 increased use of our central actuarial services team means improved efficiency, consistency and quality assurance to our calculations, which will bring time and cost savings over many years to come.
鈥淕ood data visualisation allows our clients to better understand complex analysis, enabling them to make effective decisions with greater confidence.鈥�
Data science experts in GAD regularly produce informative graphics using a variety of specialist visualisation software and tools. This approach, based on conveying key messages, has helped clients quickly get to the heart of overarching issues.