By Ed Ring / September 9, 2014 / California Policy Center
Summary: The total state and local government pensions in the United States at the end of 2013 had an estimated $3.6 trillion in assets. They were 74% funded, with liabilities totaling an estimated $4.86 trillion, and an unfunded liability of $1.26 trillion. These funds, in aggregate, project annual returns of 7.75%. If you apply a 6.2% average annual return to recalculate the liability, using formulas provided by Moody’s Investor Services, the liability increases to $5.87 trillion and the unfunded liability increases to $2.27 trillion. Using the 4.33% discount rate recommended by Moody’s for valuing pension liabilities, the Citibank Pension Liability Index for July 2014, increases the estimated liability to $7.39 trillion and the unfunded liability to $3.79 trillion. That is, if America’s state and local pension funds were to no longer make aggressive market investments but were to return to relatively risk free investments, the payment required just to return these funds to solvency would be more than $12,000 per American.
This study concludes with four recommendations to ensure the ongoing solvency of public sector pensions. Based on the principals governing Social Security benefits, they are (1) Increase employee contributions, (2) Lower benefit formulas, (3) Increase the age of eligibility, (4) Calculate the benefit based on lifetime average earnings instead of the final few years, and (5) Structure progressive formulas so the more participants make, the lower their actual return on investment is in the form of a pension benefit. Finally, the study recommends all active public employees immediately be enrolled in Social Security, which would not only improve the financial health of the Social Security System, but would begin to realign public and private workers so they share the same sets of incentives and formulas when earning government administered retirement benefits.
* * *
Introduction and Methodology:
This study relies on the most recent data compiled by the U.S. Census Bureau, combined with recent analysis performed by Wilshire Associates, an investment advisory firm, to estimate America’s total state and local government pension fund assets, liabilities, earnings, contributions and payments to retirees. This study then applies formulas provided by Moody’s Investor Services to estimate how much the unfunded liability deviates from the Census Bureau’s estimate, based on using lower rate of return projections. This study is limited to state and local government pension funds and does not include analysis of the federal retirement pension systems. In most cases, instead of footnotes, citations and links to sources are included within the text. This report concludes with some recommendations designed to stimulate discussion and debate.
* * *
Total Assets – All U.S. State and Local Government Pension Systems:
The most recent compilation of total assets, contributions and payments for America’s state and local government pension funds is the “Summary of the Quarterly Survey of Public Pensions for 2014: Q1,” released on June 26, 2014 by the U.S. Census Bureau. It provides data for the quarter ended March 31, 2014.
In the introduction, the report states “total holdings and investments of major public pension systems increased to over $3.2 trillion, reaching the highest level since the survey began in 1968.” In the footnotes, the report provides clarification that they are only referring to state and local pension systems. They also estimate these “major public pension systems” to only represent 89.4% of all state/local pension system assets, which allows the means to reasonably extrapolate an estimate representing 100% of the total state/local pension system assets, contributions, and payments. They write:
“This summary is based on the Quarterly Survey of Public Pensions, which consists of a panel of the 100 largest state and local government pension systems, as determined by their total cash and security holdings reported in the 2007 Census of Governments. These 100 systems comprised 89.4% of financial activity among such entities, based on the 2007 Census of Governments.”
In table 1, below, the total pension assets are determined by taking the Census Bureau’s reported $3.218 trillion representing the 100 largest state/local pension funds, and dividing by 89.4%, yielding an estimated total assets for all state/local pension systems in the United States of $3.6 trillion.
Similarly, in table 1, using Census Bureau data, the most recent reported quarterly total employer and employee contributions for the 100 largest state/local pension funds are multiplied by four, with the product then divided by 89.4%. The resulting estimates are that during the 12 month period through March 31, 2014, $163.8 billion was contributed into these funds by employers and employees, and $251.6 billion was paid out to state and local government retirees. Presumably the cash flow deficit, $87.8 billion, was covered by investment returns.
* * *
Official Funding Status – All U.S. State and Local Government Pension Systems:
At face value, it would appear that the funding status of these pension systems is quite healthy, since the deficit implied by payments to retirees exceeding contributions by employers and employees, $87.8 billion, represents only 2.4% of the estimated $3.6 trillion in assets. It isn’t nearly so simple, however.
The funding status of a pension system is determined by comparing the value of the invested assets to the present value of the estimated future payments to retirees. These future payments include estimates for people who have not yet retired. Since most state and local government employee participants in their pension systems are still working, the fact that current investment returns easily cover the deficit between contributions and payments to retirees is irrelevant. For a pension system to be 100% funded, payments into the fund, combined with investment returns earned by the fund, need to ensure that the total assets invested by the fund are equal to the present value of the liability. More on this later.
Wilshire Associates, a global investment advisory firm, performs in-depth analysis of America’s public employee pension systems through research papers that are updated annually. Their most recent reports are a “2014 Report on State Retirement Systems,” which primarily discusses data for the fiscal year ended 6-30-2013, and a “2013 Report on City and County Retirement Systems,” which primarily discusses data for the fiscal year ended 6-30-2012. Taking into account the improvement in the investment markets between June 2012 and June 2013, the weighted average funding ratio of the state and city/county pension systems combined, in accordance with the estimates provided by Wilshire Associates, at the end of June 2013 was 74%.
As previously discussed, the estimated total assets for all state/local pension systems in the United States is $3.6 trillion. Assuming that $3.6 trillion in assets represents 74% of the total pension liability carried by these same pension systems, then the estimated total liabilities for all state/local pension systems in the United States is $4.86 trillion. This means the total unfunded liability for these systems is estimated to be $1.26 trillion.
* * *
Funding Status Scenarios – All U.S. State and Local Government Pension Systems:
As part of their analysis of America’s state/local pension systems, Wilshire Associates compiles a “median actuarial interest rate assumption,” representing both the average annual rate of return these systems expect to earn over the next 20-30 years, as well as the discount rate they use to derive a present value for the estimated stream of payments they expect to make to current and future retirees. For both state and local systems, in their “Summary of Findings” in both of their reports, Wilshire Associates estimates this median interest rate assumption to be 7.75%.
As alluded to earlier, to be 100% funded, a pension plan must have invested assets equal to the present value of all future pension payments. For every participating employee, whether they are active or retired, actuaries estimate their salary growth, their year of retirement, their initial pension, their subsequent pension payouts based on COLAs, and their life expectancy. The present value of all these future payments is how much a fully funded pension plan’s assets must be worth.
The rate at which these future payments are discounted per year must be equivalent to whatever rate the pension fund managers believe they will earn interest, on average, over the life of the fund. The theory is that if no future work were performed, and therefore no additional future pension benefits were earned and no additional money was contributed to the fund, the assets currently invested in a fully funded plan would earn enough interest to support every future pension payment until the last participant died of old age.
Since the amount of assets in a pension plan is a known, objective quantity, the debate over how much unfunded liability a plan may have centers on what assumptions are used to estimate the present value of the future payments, i.e., the “Actuarial accrued liability (AAL),” which, as discussed and noted on table 2, is estimated as of 6-30-2013 at $4.86 trillion. In order to assess whether or not that amount is overstated or understated, we can use a short-cut formulated by Moody’s Investor Services in their July 2012 proposal, “Moody’s Adjustments to US State and Local Government Reported Pension Data.”
In order to revalue a pension fund’s liabilities without having access to every actuarial calculation from every fund, what Moody’s does is estimate the midpoint of the future payments stream. They select 13 years into the future, which is quite conservative. Using a longer duration than 13 years will greatly increase the sensitivity of the liability to changes in the projected rate-of-return. As discussed in their July 2012 proposal, here is their rationale:
“To implement the discount rate adjustment, we propose using a common 13-year duration estimate for all plans. This is a measure of the time-weighted average life of benefit payments. Each plan’s reported actuarial accrued liability (“AAL”) is projected forward for 13 years at the plan’s reported discount rate, and then discounted back at 5.5%. This calculation results in an increase in AAL of roughly 13% for each one percentage point difference between 5.5% and the plan’s discount rate. For example, a plan with a $10 billion reported AAL based on a discount rate of 8% would have an adjusted AAL of $13.56 billion, or 35.6% greater than reported.
We recognize this duration estimate may be higher than warranted for some plans and lower than warranted for others. Each pension plan has a unique benefit structure and demographic profile that affects the time-weighted profile (duration) of future benefit payment liabilities. However, plan durations are not reported, and calculating duration individually for each plan is not feasible. Our proposed 13-year duration is the median calculated from a sample of pension plans whose durations ranged from about 10 to 17 years. Plans with shorter durations usually are closed or have a preponderance of older or retired members.”
Here is the formula that governs this recalculation of the present value of the liability (“PV”):
Adj PV = [ PV x ( 1 + official %i ) ^ years ] / ( 1 + adjusted %i ) ^ years
As made explicit in the above formula, along with duration (years), the other key variable in order to use Moody’s formula to evaluate funding status scenarios, of course, is the “%i,” the discount rate, which is also the rate of return projection. It is worth noting that the discount rate and the rate of return projection don’t have to be the same number. In private sector pension plans, the discount rate is required to differ from the rate of return projection. Private sector pension plans are required to use a lower, more conservative discount rate in order to calculate the present value of their future liabilities in order to avoid understating the present value of the liability. Public sector pension plans have not yet been subjected to this reform regulation, and the rate used to project interest is invariably the same as the rate used to discount future liabilities. This puts enormous pressure on these funds to adopt an aggressively high rate of return projection.
Here are explanations for the various alternative rate of return projections applied in Table 3.
Case 1, 6.2% – here is the rationale for this rate-of-return, excerpted from the report “Pension Math: How California’s Retirement Spending is Squeezing The State Budget” authored by Joe Nation, a Ph.D., Stanford Institute for Economic Policy Research, and former California Democratic assemblyman: “This 6.0 to 6.5 percent figure is based on the performance of a hypothetical fund containing 80 percent equity and 20 percent income instruments between 1900 and 1999. It assumes an equity rate based on the 20th-century Dow Jones industrial annual average of 5.3 percent, plus 2 percent in dividends, less 0.5 percent in fees. Combined with income instruments with a net rate of return of 4.5 percent, this hypothetical fund would have earned an average annual rate of 6.2 percent.”
Case 2, 4.33% – the rationale for this rate-of-return comes from Moody’s Investor Services “Moody’s Revised New Approach to Adjusting Reported State and Local Government Pension Data,” released in April 2013: “For adjustments to pension data, Moody’s will use the Citibank Pension Liability Index (Index) posted on the date of the valuation instead of its original proposal to apply a single rate for all plans each year.” Citigroup Pension Discount rate as posted by the Society of Actuaries in July 2014 was 4.33%.
Table 3, below, shows how much the unfunded liability for all of America’s state/local pension systems will increase based on various alternative rate-of-return projections, all of which are lower than the official composite rate of 7.75% currently used by America’s state/local pension funds. As can be seen, if a rate of 6.20% is used, reflecting the historical performance of U.S. equities, the total liability for America’s state/local pension systems rises from $4.86 trillion to $5.87 trillion; the unfunded liability rises from $1.26 trillion to $2.27 trillion; the funding status declines from 74% to 61%.
If the relatively risk-free rate of 4.33% is used, reflecting Moody’s recommendation to adhere to the Citibank pension liability index rate, the total liability for America’s state/local pension systems rises from $4.86 trillion to $7.39 trillion; the unfunded liability rises from $1.26 trillion to $3.79 trillion; the funding status declines from 74% to 49%.
Please note the above table can be downloaded here . It is a useful tool for quickly estimating how much the unfunded liability may increase for any pension fund if the projected rate of return is lowered from the official rate. In this table, and on the spreadsheet, the yellow highlighted cells represent assumptions, and require input from the user. The green highlighted cells depict key results from the calculations.
* * *
Observations and Recommendations
The data gathered for this study, combined with reasonable assumptions, allows one to estimate the pension fund assets for the total state and local government pension systems, combined, to equal $3.6 trillion, with an attendant liability of $4.86 trillion. In turn this means the total unfunded liability for these pension systems is estimated at $1.26 trillion. Using formulas provided by Moody’s investor services, one may apply lower rate-of-return assumptions to the official total liability estimate, and calculate how much the liability – and unfunded liability – will increase based on lower projected returns. While none of these various estimates can be considered precise and indisputable, the credibility of the source data and formulas strongly suggest they are reasonably accurate.
Not beyond serious debate, however, are financial questions and policy issues relating to pensions that are of critical importance to the solvency of America’s state and local governments. For example, even if the 74% funded ratio is accurate, it is a best case scenario that still raises troubling questions. Because the $183 billion in reported annual contributions must include not only the “normal contribution,” representing the present value of future pensions earned by workers in the most recent fiscal year, but also the “unfunded contribution,” the catch-up payment designed to pay down the unfunded liability. Even if the total unfunded liability for all of America’s state/local government pension systems is only $1.26 trillion, to eliminate the underfunding over 20 years at 7.75% interest would require annual payments of $126 billion per year. That would leave only $63 billion to cover the normal payment.
Although consolidated contribution data that breaks out the normal and unfunded contributions separately is not readily available for America’s state/local government pension systems, it is possible to impute the normal contribution – an exercise that leaves wide latitude for interpretation. Nonetheless, in a 2013 study, “A Method to Estimate the Pension Contribution and Pension Liability for Your City or County,” the California Policy Center did just that. The worksheet showing the assumptions and formulas can be downloaded here, ref. the tab “normal contribution (imputed).” As it is, assuming 16 million full-time equivalent active state/local government workers, accruing pension benefits at an aggregate rate of 2.0% of final payroll per year worked – keeping the rate-of-return assumption at 20 years, the imputed normal contribution is $120 billion per year.  By this logic, the total contribution of $183 billion is inadequate. The normal contribution of $120 billion plus the unfunded contribution of $126 billion suggests an adequate contribution should be $246 billion per year.
To summarize the immediately preceding paragraphs, if one continues to assume these funds will earn 7.75% per year, annual contributions were $67 billion short of the $246 billion total necessary to pay not only the normal contribution, but enough of a catch-up “unfunded contribution” to restore 100% funded status within 20 years. Aspiring to at least do this much is crucial, because the 7.75% rate-of-return projection may not be achieved. As already shown, the amount of a pension system’s liability is highly sensitive to the assumed rate of return. So are the normal and unfunded contributions. Here is the impact of lower rates of return on those payment estimates:
On Table 3, above, the impact of a 6.2% rate-of-return projection is shown to increase the unfunded liability from $1.26 trillion to $2.27 trillion, and lower the funded ratio from 74% to 61%. Using the tools and assumptions summarized in the preceding paragraphs, the impact of a 6.2% rate of return – representing the historical performance of U.S. equities over the past 60 years – on the unfunded contribution is to increase it from $126 billion to $201 billion; the normal contribution increases from $120 billion to $176 billion. Put another way, if realistic repayment terms are adopted for the unfunded liability, at a rate-of-return of 6.2% the total required contribution for America’s state/local government pension systems could rise from the current $183 billion to $377 billion.
Similarly, at a hopefully risk-free rate-of-return of 4.33% (the July 2014 Citibank Pension Liability Index Rate recommended by Moody’s), the normal contribution estimate rises to $281 billion and the unfunded contribution estimate rises to $287 billion – a total of $586 billion vs. $183 billion being actually contributed today.
These figures are not outlandishly inflated. They merely indicate how extraordinarily sensitive pension fund solvency is to rate-of-return projections, and how perilously dependent pension funds are on investment returns.
This, again, brings up the most salient question of all: What rate of return is truly achievable over the next 2-3 decades?
To at least recap this economic debate is necessary because this one assumption is central to policy decisions of extraordinary significance. If the optimists are right, rates-of-return will rise into the high single-digits and stay there, rendering pensions financially sustainable. The states and locales who offer them can therefore keep their contributions flat and allow a few more good years in the market to wipe out their unfunded liabilities. If the pessimists are correct, rates-of-return are going to shrink into the low single digits and stay there, making aggressive paydowns of a swollen unfunded liability a mandatory proposition. Required contributions will rise to untenable levels, crowding out other government services, causing taxpayer revolts, union lawsuits, and a string of bankruptcies.
The case for pessimism – or realism – is strong. Economic growth over the past 30 years has been fueled by debt accumulation; economic growth creates profits, profits create stock appreciation. Debt accumulation stimulates consumption, low interest rates stimulate purchases of real estate and durable goods, driving prices up. Debt accumulation and easy credit causes an asset bubble, and asset bubbles create collateral for additional debt. Total market debt in the U.S. is now higher than it was in 1929, immediately before the great depression. We are at the point now where there is no precedent in economic history that enables us to assume we can continue to use debt to stimulate economic growth.
The other economic headwind facing investments is the aging population. In 1980, 11% of the U.S. population was over 65. By 2030, over 22% of the U.S. population will be over 65. This means that compared to 1980, when America’s current era of of debt accumulation began, by 2030 there will be twice as many people, as a percentage of the U.S. population, selling assets to finance their retirements. The impact of so many sellers in the markets, combined with interest rates having now fallen to near zero – meaning a primary method to stimulate debt formation has been exhausted – will at the very least take the growth out of asset bubbles, if not cause their collapse. The state/local pension funds, based on current data as presented here, are already net sellers in the markets. All of this augers poorly for returns-on-investment. And while, as noted in the next paragraph, America’s economy remains extraordinarily resilient, especially compared to the rest of the world, a collapse of collateral values would trigger a global financial meltdown, and that would take America down with it.
The case for optimism is not unfounded. To stave off recession, or worse, the U.S. has pursued a policy in recent years of injecting trillions of dollars of new money into the system through massive Federal Reserve Bank intervention. But the only way this impetuous gambit can backfire is via a global loss of confidence in the U.S. currency. Despite wails of panic from predictable quarters, that isn’t likely, since every other central bank in the world is playing the same game, with less success. The largest currency group apart from the U.S. dollar is the Euro, and the Eurozone, unlike the U.S., faces a demographic crisis that is genuinely alarming, and their debt burden combined with their level of structural entitlements is much worse than in the U.S. China’s economy is far more dependent on trade, they face a demographic crisis similar to Europe’s, their society is the most likely among the major economies to experience social upheaval in the future, their real estate bubble is worse than in the U.S., and despite the opacity of their banking system, their debt burden is quite likely more severe than in the U.S. Japan is still reeling from a generation of deflation and crippling debt. No other currencies are supported by economies that are big enough to matter. Especially since the energy boom began in the U.S., no other country has anywhere near America’s capacity to domestically source raw materials and manufactured goods for export. The U.S. is basically daring the world to depreciate the dollar, because currency depreciation might actually help the U.S. economy more than it would hurt.
And so the debate over realistic rates of return rages on.
There is another question, however, which considers not the economic issues, but the issue of equity and fairness. A recently published book “Capital in the Twenty-First Century,” by Thomas Piketty, has become a favorite among leftist intellectuals who provide thought leadership for, among others, the public sector unions who control most public sector pension fund boards and who advocate tenaciously for keeping pension benefits as they are. Piketty makes the following claim:
“The rate of capital return in developed countries is persistently greater than the rate of economic growth, and that this will cause wealth inequality to increase in the future.”
Piketty is certainly correct that the rate of capital return exceeds the rate of economic growth. But his moral arguments fail when it comes to public sector pensions. Because public sector pensions have provided the means whereby public sector employees are granted immunity from the very forces that Piketty is arguing have empowered the oligarchy at the expense of ordinary workers. Public sector pensions have essentially creating a common cause between government workers and the oligarchy they allege is exploiting ordinary workers. This point cannot be emphasized enough. Government workers, through their pension funds, benefit from all policies designed to elevate asset values, including bubble levels of asset appreciation, because that is essential to the solvency of their funds. Their interests are aligned with those of central bankers, international corporations, and individual billionaires, whose self-interests impel them to support policies to keep interest rates artificially low, heap additional levels of debt onto the economy despite diminishing returns, and push asset values to even higher, more unsustainable levels. Because to stop doing that will crash these pension funds.
Is it equitable for government sponsored investment entities to control over $3.6 trillion in market investments, investments made in an economic environment which, if successful, perpetuates the gains of productivity flowing disproportionately to the wealthy elite, yet which, when unsuccessful, hits up taxpayers to cover the losses?
When considering solutions to both the financial challenges and issues of equity and fairness surrounding public sector pensions, it is important to understand that even if these systems are able to recover fully funded status based on surprisingly good and sustained market performance, it does not follow that their performance is something that can be extended to the entire population, because if so, instead of 20% of the retired population funding their retirement income through selling assets on the markets, 100% of the retirement population would be doing so, exerting far more downward pressure on asset values.
A relevant question to ask is therefore whether or not pension systems that are funded by taxpayers and bailed out by taxpayers should be investing in the market at all – why aren’t government employee pensions funded through a combination of low risk investments such as T-Bills and contributions from current workers?
The example of Social Security provides several instructive points which should be considered in any discussions of pension reform, or the larger question of what the government’s role should be in providing financially sustainable retirement security to Americans. Social Security, unlike state/local government worker pensions, has a positive cash flow. As seen here from this table on their website “Fiscal Year Trust Fund Operations,” during 2013 Social Security collected $851 billion from active workers and paid out $813 billion, primarily to retirees. The so-called Social Security “Trust Fund” had a balance at the end of 2013 of $2.76 billion.
If public sector pensions are indeed facing serious, potentially fatal financial challenges, they should consider adopting five elements from Social Security:
(1) Make it possible to increase employee contributions – Social Security withholding can be increased or decreased at the option of the federal government. If collections into public employee pension funds are inadequate, increase the withholding from employee paychecks – not only for the normal contribution, but also to help pay the unfunded contribution.
(2) Make it possible to decrease benefits – nothing in Social Security is guaranteed. Benefits can be cut at any time to preserve solvency. Decreasing benefits may be the only way to preserve defined benefit pensions. Equitable ways to do this must be spread over as many participant classes as possible. For example, the reform passed by voters in San Jose (tied up in court by the unions) called for suspending cost-of-living increases for retirees, and prospectively lowering the annual rates of benefit accruals for existing workers.
(3) Increase the retirement age. This has already been done several times with Social Security. Pension reforms to-date have also increased the age of eligibility for benefits.
(4) Calculate benefits based on lifetime earnings. Social Security calculates a participant’s benefit based on the 35 years during which they made the most. Public sector pensions, inexplicably, apply benefit formulas to the final year of earnings, or the final few years. These pension benefits should be calculated based on lifetime earnings.
(5) Make the benefit progressive. The more you make and contribute into Social Security, the less you get back. At the least, applying a ceiling to pension benefits should be considered. But it would serve both the goals of solvency and social justice to implement a comprehensive system of tiers whereby highly compensated public servants, who make enough to save themselves for retirement, get progressively less back in the form of a pension depending on how much they make.
These suggested reforms are meant to be taken to evolve defined benefit pensions into a plan that provides a minimal level of retirement security. The government should not be in the business of providing retirement benefits to anyone, private or within government, that go beyond providing a minimal safety net. The government certainly shouldn’t be in the business of providing pensions to government employees that are many times better than what they provide to private citizens in the form of Social Security. And the government, or government employees through their union controlled pension funds, should not be playing the market with $3.6 trillion of taxpayer sourced dollars, then forcing taxpayers to bail out these funds when they don’t meet projections.
A unique and elegant way to provide equitable, minimal, government administered and financially sustainable retirement security to all American’s would be to immediately require all active government workers to join Social Security. These workers, and retirees, would keep whatever pension benefits they’d qualified for so far, subject to reductions per the five options just noted in order to preserve solvency for the fund. They would begin to pay into the Social Security system, with the employer contribution into their pension funds proportionally reduced to make it an expense-neutral proposition. Since government workers are relatively highly compensated compared to private sector workers, the participation, for example, of 16 million active state/local government workers would immediately improve the solvency of the Social Security Fund. The five options available to preserve Social Security, as noted above, would be far less onerous in their implementation over the coming decades if tens of millions of highly compensated government workers were to participate. And since their unions purportedly speak for the common man, they should have no objection to the highly compensated among them getting less back in retirement than those less fortunate.
Who knows, maybe the much vaunted, potentially real Social Security “Trust Fund” assets could be used to purchase Treasury Bills. Such a policy would have the twin virtues of taking pressure off the federal reserve, and augmenting Social Security collections with modest investment returns.
Ed Ring is the executive director of the California Policy Center.
* * *
(1) The tables in this study are all found on this spreadsheet, State-and-Local-Pension-Liability.xlsx. The spreadsheet also contains additional notes on the assumptions used, as well as links to the source data.
(2) To estimate a fund’s required normal pension contribution using the Impact-of-Returns-and-Amortization-Assumptions-on-Pension-Contributions.xlsx spreadsheet, “normal contribution (imputed)” spreadsheet, the assumptions used and referenced above were as follows:
– Average Salary = $70,000
– % cola growth/yr = 2.0%
– % merit growth/yr = 1.0%
– avg years till retire = 17
– proj % discount (fund’s assumed annual rate of return) = 7.75%
– base year 2000+ = 11
– avg years retired = 20
– pension formula/yr = 2.00%
– pension cola % = 2.0%
– elig # workers = 16,000,000
Please note this spreadsheet does not default to these values. They have to be entered in the yellow highlighted input cells. The spreadsheet is designed to calculate results for whatever set of assumptions the user wishes to enter. This spreadsheet also contains tabs, similarly highlighted with yellow to denote cells to input user assumptions, to recalculate estimates for the unfunded liability and the unfunded contribution. On this spreadsheet, as noted above, there are tools to recalculate the normal contribution based on having that information, or imputing it if that information is not available.