STUMP » Home Page » visualization category listing.

Checking the Numbers: How Much are Social Security Benefits?  

by meep

No, I’m not addressing the affordability of the program, etc.

I’m looking at: how much are people actually paid in Social Security benefits

Luckily, the Office of the Chief Actuary of the Social Security Administration has lots of information so we can get a good idea. I went here, clicked through...

Keep Reading...

Mornings with Meep: Data Visualization  

by meep

I review three books on data visualization, and try out a couple visualizations using some of the ideas from the first book, Storytelling with Data.

Keep Reading...

Alternative Assets and Pension Performance: A Dive into Data  

by meep

As promised in a prior post, I’m going to be digging into the many dimensions that drive public pension deteriorating status.

I have a news hook for this:

Pa. treasurer says ‘we have seen this movie before’ as pension system shifts toward costly hedge funds:

Pennsylvania’s $30 billion state pension fund...

Keep Reading...

New Project(s): Re-visualizing the Public Pension Database  

by meep

I’ve taken the data from the Public Pension Database and put it on kaggle – while I hope this will get a few other people dipping into this data, it’s more that I can put together some notebooks that others can get and look at….using tools a bit cooler...

Keep Reading...

Happy Halloween! Some Scary Public Pension Projections  

by meep

Do you want to see something really scary?

I have updated my public pension cash flow projection spreadsheet. You can get a copy of the latest version here.

I ran the 170 plans with updated data up to (possibly) fiscal year 2016, using data from the Public Plans Database.

The...

Keep Reading...

Geeking Out (and Illinois Pensions): Fixing a Graph and Assigning Blame for Underfundedness  

by meep

I used a graph last week that I knew was wrong (well, part of it was wrong).

It’s my graph of the unfunded liabilities of the 5 Illinois state-funded pension plans, and how it stacks up over time. I know I’ve mentioned this issue before — it doesn’t work well...

Keep Reading...

Public Pensions: Why Do 100% Required Contribution Payers Have Decreasing Fundedness?  

by meep

In yesterday’s post, I looked at the press release from a public pensions advocacy group.

One key point was this quote from the paper the press release pointed to:

Pension funds are resilient and well managed. They have stood the test of time for more than 100 years through...

Keep Reading...

Rhode Island Pensions: Asset Trends  

by meep

As noted in the prior post, there are two state-level pension funds in the Public Plans Database for Rhode Island, the plan for state employees and the plan for municipal plans — it’s the second one that is involved in the proposed legislation.

Now, I can do...

Keep Reading...

South Carolina Pensions: Recent Rumblings .... or Rumbles  

by meep

In the last post on SC pensions I noted:

• South Carolina returns have underperformed similar pension funds, and have way underperformed their target return on assets.

• SC has an awful lot of “alternative assets” in their portfolio.

I will do a followup to look more closely at the liability side, but I...

Keep Reading...

South Carolina Pensions: Asset Trends  

by meep

As mentioned, I’m working my way through Theodore Konshak’s posts on South Carolina pensions, but before I get into his particular findings, I’m going to do a high-level overview of what South Carolina public pension trends have been.

Within the Public Plan Database, there are 2 public pensions represented:...

Keep Reading...