ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Objective:The purpose of this file is to provide access to the data that were compiled for the December update of the 2021 Equable State of Pensions Report.
2
Organization:The data in this file are organized using separate tabs for each of the figures presented in the main State of Pensions report. Each tab is labeled by page number with a short abbreviation or description of the graphic. Not all graphics from the main report are replicated in the December update. However, data are still provided for each graphic.
3
Note that none of the graphics are contained in this file, as they have been removed to keep the size of this file small for any interested parties.
4
Data Sources:The data for the State of Pensions Report were drawn from the following sources:
5
1)Pension Data: All data pertaining to pension plan assets, liabilities, payroll, contributions, or other elements of the public retirement systems examined in the report were compiled using plan-specific reports. This means data were extracted primarily from plan valuation reports and comprehensive annual financial reports (CAFRs), but other supplemental data were also collected from state CAFRs, investment reports, and other publicly available sources.
6
2)Federal Reserve/Bureau of Economic Analysis Data: The Federal Reserve (Fed) and Bureau of Economic Analysis (BEA) compile a variety of data and make them readily available to the public. For this report BEA data were used to record GDP by state while Fed data were used to report their measure of public pension liabilities, assets, and GDP (page 22 of the report). Fed data were also used to report average annual treasury yields (pages 26, 28, and 29 of the report).
7
BEA data can be accessed at the following:
8
https://www.bea.gov/data/gdp/gdp-state
9
Fed data can be accessed at the following:
10
https://www.federalreserve.gov/datadownload/Build.aspx?rel=Z1
11
3)State Budgetary Data: All data pertaining to state general fund spending (pages 44 and 45 of the report) were drawn from the National Association of State Budget Officers' annual expenditure reports.
12
NASBO expenditure reports can be accessed at the following:
13
https://www.nasbo.org/reports-data/state-expenditure-report
14
4)S&P 500 Market Data: All data recording the closing values of the S&P 500 (page 57 of the report) were compiled from Yahoo Finance.
15
S&P data can be accessed at the following:
16
https://finance.yahoo.com/quote/%5EGSPC/history?p=%5EGSPC
17
Notes:Please note that as of this publication, not all plans have finished their FY 2021. In those cases, we have collected reported investment returns for partial years or have used our asset benchmarks to estimate 2021 funded levels. As new data are released, we will update our figures.
18
Questions:For any questions related to the data in this file, please contact jon@equable.org
19
Additional Data:
For additional data (or to access the raw data used to compile the figures reported in this file), please send an inquiry to either anthony@equable.org or jon@equable.org
20
Last Updated:December 8, 2021
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100