RECENT POSTS
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

Wednesday, October 23, 2019
Feeling the Squeeze on China

Tuesday, October 22, 2019
Netflix and the Cost of Content

Wednesday, October 9, 2019
U.S. firms with Sales in China through 2018.

Wednesday, October 9, 2019
Tracking  Pension Data in Calcbench

Friday, October 4, 2019
In Depth: Leasing Costs in Retail Sector

Thursday, September 19, 2019
Alibaba and Cloud Computing

Monday, September 16, 2019
Introducing Critical Audit Matters

Wednesday, September 11, 2019
Our Fireside Chat on Goodwill Assets

Friday, September 6, 2019
Pulling Forward Share Buybacks

Saturday, August 31, 2019
A Quick Catch-Up on VMWare

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.