RECENT POSTS
Sunday, January 19, 2020
Calcbench Tip: Email Alerts

Sunday, January 19, 2020
Calcbench Tip: Text Disclosures

Tuesday, January 14, 2020
Devising an Impairment Sensitivity Test

Thursday, January 9, 2020
Acuity Impairment on Leased Asset

Thursday, January 9, 2020
Calcbench Excel Add-in for Office 365 (The Excel Add-in on Mac)

Tuesday, January 7, 2020
Restructuring After Restructuring at Jabil

Friday, January 3, 2020
New Year, New Risks for Uber & Others

Friday, December 27, 2019
Looking Again at Legalized Weed

Sunday, December 22, 2019
An Update on Trucking Industry Slowness

Wednesday, December 18, 2019
Coming Up in 2020: CECL Disclosures

Wednesday, December 11, 2019
Finding and Assessing ‘Contribution Margin’

Monday, December 9, 2019
Cycling Through Peloton’s Financials

Monday, November 25, 2019
Calcbench and Academic Research

Friday, November 22, 2019
Disney’s Cliffhanger With Hulu

Tuesday, November 19, 2019
Starbucks on Leasing Costs

Friday, November 15, 2019
The Devil Is in the Discount Rate

Tuesday, November 12, 2019
A Look at Product Warranty Accruals

Thursday, November 7, 2019
CHS Limps Through Weather & War

Wednesday, November 6, 2019
Master Class: Preparing for Recession

Sunday, October 27, 2019
When Operating Leases Weigh Down ROA

Archive  |  Search:
Tracking  Pension Data in Calcbench
Wednesday, October 9, 2019

You may have seen news recently that General Electric ($GE) is freezing pension benefits for 20,000 employees, to help the company close an $8 billion deficit in its pension plan.

We at Calcbench love financial data analytics so much that we plan to keep working until we die. Still, GE’s news is a reminder that corporate pension liabilities are still a big issue — and Calcbench offers numerous ways for financial analysts to understand exactly how big that issue might be for firms you follow.

For example, in our Data Query Tool, we track dozens of footnote disclosures a firm might make about its pension obligations. Scroll to the lower portion of the page and you’ll see a laundry list of “footnote points” we track in corporate filings. Look for “Employee Benefits & Pension” and you’ll see a sub-menu of several dozen more data points we track within that category — everything from defined-benefit plan obligations; to maximum and minimum discount rates; to expected future benefit payments due in coming years. See Figure 1, below.



Mark whatever pension data you want to track, for whatever companies you want to track (don’t forget how to set peer groups you want to research), and then the whole thing is delivered to you via Excel for further analysis.

You can do much the same research on our Multi-Company Page, using the standardized metrics search field on the left side of your screen. Those metrics are the same data points we cited above; on the multi-company page, you can compare them quickly on your screen across numerous companies or other metrics. (Say, defined-benefit obligations compared to total liabilities, among the Dow Jones Industrials — you can get that on your screen in a snap.) See Figure 2, below.



And of course, you can always search our Interactive Disclosure Page for detailed, narrative disclosure of pension items that firms report in the footnotes. Firms do sometimes report pension costs under various headings, so the simplest trick here might be to search “pensions” in the text field and see what comes up.

For real, many firms do still offer pensions and report costs related to those benefits. You won’t just get, “Ha! You’re kidding, right?” when you go looking.

To demonstrate how much pension accounting can matter, we looked at all the discount rates for firms that still offered pension plans in 2018. You can see the scatter plot, below.



Most firms use discount rates somewhere near 4 percent — but many use discount rates below that figure. A few brave filers even use discount rates of zero.

Remember that companies use the discount rate to determine the cost of future benefits, and thus what they must contribute today to cover those benefits in the future. The contributions move in step with the discount rate — so the lower your rate is, the more confident you are that your plan’s current value will endure over time, and the less you need to contribute today.

So if Firm X uses a discount rate of zero, does that seem like a reasonable number, or something you might step in while crossing a cow pasture? That’s for you to decide. Calcbench just serves up plenty of data to help you make your decision.


FREE Calcbench Premium
Two Week Trial

Research Financial & Accounting Data Like Never Before. More features and try our Excel add-in. Sign up now to try the Premium Suite.