Spreadsheet: 51fcb3d9-04d8-441a-af69-6172a9a97adb
Sheet: Pension Data

 | This sheet contains additional pension information from HAL and from the ONS and other sources.
 | Additional Pension Analysis based on GAD report
 | January 2013 FBP Forecast |  |  |  | Q5 |  |  |  |  | Q5+1 | Q6 |  |  |  |  |  | Q6 Total | CAGR | per year
 | £m 2011/12 |  |  |  | 2008/09 | 2009/10 | 2010/11 | 2011/12 | 2012/13 | 2013/14 | 2014/15 | 2015/16 | 2016/17 | 2017/18 | 2018/19
 | DB costs |  |  |  | " | " | " | " | " | " | " | " | " | " | " |  | " | " | "
 | DC costs |  |  |  | " | " | " | " | " | " | " | " | " | " | " |  | " | " | "
 | Deficit costs |  |  |  | " | " | " | " | " | " | " | " | " | " | " |  | " | " | "
 | Pension Cost Total
 | DB Members (estimate) |  |  |  | " | " | " | " | " | " | " | " | " | " | " |  |  | "
 | DC Members (estimate) |  |  |  | " | " | " | " | " | " | " | " | " | " | " |  |  | "
 | Total Members (estimate) |  |  |  | " | " | " | " | " | " | " | " | " | " | " |  |  | "
 | Pension Cost Index 2011/12 = 1
 | Pension Costs Data
 | Table 8.1
 | Weighted-average contribution rates to private sector occupational pension schemes: by benefit structure and contributor, 2000 to 2011
 | United Kingdom |  |  |  |  |  | Percentages
 |  | Defined benefit |  |  | Defined contribution
 |  | Employee | Employer | Total | Employee | Employer | Total
 | 2000 | 4.2 | 9.9 | 14 | 2.7 | 4.3 | 7
 | 2004 | 4.3 | 14.5 | 18.8 | 2.9 | 6 | 8.9
 | 2005 | 4.4 | 16 | 20.4 | 2.7 | 6.3 | 9
 | 2006 | 4.7 | 15 | 19.7 | 3 | 5.9 | 8.9
 | 2007 | 4.9 | 15.6 | 20.5 | 2.7 | 6.5 | 9.1
 | 2008 | 4.9 | 16.6 | 21.6 | 3 | 6.1 | 9
 | 2009 | 5.171982480558015 | 16.53726238245681 | 21.70924486301482 | 2.944927107699112 | 6.365810294102107 | 9.31073740180122
 | 2010 | 5.1 | 15.8 | 20.8 | 2.7 | 6.2 | 8.9
 | 2011 | 4.9 | 14.2 | 19.2 | 2.8 | 6.6 | 9.4
 | 1. Includes schemes where standard contributions (either from the employee or the employer) were zero.
 | 2. Excludes normal contributions paid as fixed amounts.
 | 3. Includes rates for open, closed and frozen schemes.
 | 4. Excludes schemes with fewer than 12 members.
 | 5. Caution should be used when analysing trends in average contribution rates over time as there have been several changes to the OPSS questionnaire. In particular, in 2010, the OPSS questionnaire was redeveloped to ensure that, if there were different contribution rates for different groups of members, then these were recorded. The scheme was asked to give the different rates and the corresponding proportion of active members to whom that rate applied. Prior to 2010, only the contribution rate that applied to the majority of members was recorded. This means that caution should be exercised when comparing the figures for 2010 and 2011 with earlier estimates.
 | Source: Occupational Pension Schemes Survey, Office for National Statistics
 | Table 7: Weighted-average contribution rates to private sector occupational
 | pension schemes by benefit structure and contributor
 |  |  |  |  |  |  |  | Percentages
 |  | 2010 |  |  |  | 2011
 |  | Member | Employer | Total |  | Member | Employer | Total
 | Defined benefit schemes | 5.1 | 15.8 | 20.8 |  | 4.9 | 14.2 | 19.2
 | Career average schemes | 5.4 | 11.8 | 17.2 |  | 5.4 | 11.5 | 16.9
 | Defined contribution schemes | 2.7 | 6.21 | 8.9 |  | 2.8 | 6.6 | 9.4
 | 1. Includes schemes where standard contributions were zero. |  |  |  |  |  |  | Source: Office for National Statistics
 | 2. Excludes normal contributions paid as fixed amounts.
 | 3. Includes rates for open, closed and frozen schemes.
 | 4. Excludes schemes with fewer than 12 members.
 | 5. Components in tables may not sum to totals due to rounding.
 | Data for figure 8.13
 | Distribution of employee members of private sector group personal pensions and stakeholder pensions where employer has 100 employees or more: by employer contribution rates, 2012
 | United Kingdom |  | Percentages
 |  | Group personal pensions | Stakeholder pensions
 | No contribution | 3 | 3
 | Greater than zero and under 3% | 10 | 15
 | 3% to under 6% | 40 | 35
 | 6% to under 9% | 23 | 23
 | 9% to under 12% | 13 | 13
 | 12% to under 15% | 5 | 6
 | 15% and over | 6 | 5
 | 1. Pension is arranged through an employer, main pension only.
 | 2. Contributions include one-off fixed amount payments, but exclude employer contributions covering more than one employee.
 | 3.  The private sector is classified using the legal status from the Inter-Departmental Business Register and does not include 'third sector' organisations such as charities.
 | Source: Annual Survey of Hours and Earnings, Office for National Statistics
 | Data for figure 8.4
 | Distribution of active membership of private sector occupational pension schemes: by type of scheme and employer contribution rate, 2007 to 2011
 | United Kingdom |  |  |  |  |  |  |  |  |  |  |  | Percentages
 |  |  | Defined benefit |  |  |  |  |  | Defined contribution
 |  |  | 2007 | 2008 | 2009 | 2010 | 2011 |  | 2007 | 2008 | 2009 | 2010 | 2011 |  | Sum
 | Under 4% |  | 0.56 | 0.17 | 0.99 | 0.22 | 0.62 |  | 13.71 | 19.74 | 16.74 | 12.96 | 12.31
 | 4% to under 8% |  | 3.39 | 1.81 | 2.32 | 8.03 | 2.42 |  | 47.71 | 47.11 | 48.1 | 45.48 | 41.89
 | 8% to under 10% |  | 6.28 | 5.56 | 4.84 | 6.66 | 6.49 |  | 24.31 | 18.41 | 20.11 | 21.19 | 22.55
 | 10% to under 12% |  | 13.33 | 12.3 | 13.45 | 13.46 | 17.41 |  | 12.87 | 11.65 | 10.82 | 11.78 | 13.02
 | 12% to under 15% |  | 17.73 | 17.33 | 19.81 | 13.36 | 15.14 |  | 0.9 | 1.98 | 3.34 | 5.32 | 6.79
 | 15% and over |  | 58.7 | 62.83 | 58.6 | 58.28 | 57.92 |  | 0.5 | 1.12 | 0.89 | 3.27 | 3.43
 | 1 | Excludes schemes with fewer than 12 members.
 | 2 | Excludes non-contributory arrangements and contributions paid as fixed amounts only.
 | 3 | Percentages are calculated excluding non-response.
 | 4 | Caution should be used when analysing trends in contribution rates over time as there have been several changes to the OPSS questionnaire. In particular, in 2010, the OPSS questionnaire was redeveloped to ensure that, if there were different contribution rates for different groups of members, then these were recorded. The scheme was asked to give the different rates and the corresponding proportion of active members to whom that rate applied. Prior to 2010, only the contribution rate that applied to the majority of members was recorded. This means that caution should be exercised when comparing the figures for 2010 and 2011 with earlier estimates.
 | Source: Occupational Pension Scheme Survey, Office for National Statistics
 | Table 4.2: Weighted-average contribution rates to private sector occupational pension schemes: by size, benefit structure and contributor1,2,3,4,5, 2010
 |  | Defined benefit |  |  | Defined contribution
 | % | Member | Employer | Total | Member | Employer | Total
 | 10,000+ | 4.9 | 15.6 | 20.5 | 2.5 | 6.7 | 9.2
 | 5,000 to 9,999 | 5.8 | 16.9 | 22.7 | 2.6 | 7.1 | 9.7
 | 1,000 to 4,999 | 5.5 | 16.1 | 21.6 | 2.9 | 4.5 | 7.4
 | 100 to 999 | 5.1 | 15.4 | 20.5 | 3.5 | 8.2 | 11.7
 | 12 to 99 | 3.3 | 18.6 | 21.8 | 2.8 | 5.8 | 8.6
 | Total | 5.1 | 15.8 | 20.8 | 2.7 | 6.2 | 8.9
 | Defined benefit Defined contribution
 | Member Employer Total Member Employer Total
 | 10,000+ 4.9 15.6 20.5 2.5 6.7 9.2 5,000 to 9,999 5.8 16.9 22.7 2.6 7.1 9.7 1,000 to 4,999 5.5 16.1 21.6 2.9 4.5 7.4 100 to 999 5.1 15.4 20.5 3.5 8.2 11.7 12 to 99 3.3 18.6 21.8 2.8 5.8 8.6 Total 5.1 15.8 20.8 2.7 6.2 8.9
 | 1 Includes schemes where standard contributions were
 | zero.
 | 2 Excludes normal contributions paid as fixed amounts.
 | 3 Includes rates for open, closed and frozen schemes.
 | 4 Excludes schemes with fewer than 12 members.
 | 5 Breakdowns by size band for defined contribution
 | schemes are based on relatively small samples.
 | Source: Occupational Pension Schemes Survey
 | http://www.ons.gov.uk/ons/rel/pensions/occupational-pension-scheme-survey-annual-report/2010-annual-report/index.html
 | End