Thursday, April 15, 2021

The other day we had a blog post about CEO pay ratios, which are one example of the compensation data that Calcbench tracks. Today we’re going to stick with that theme, but explore something a bit larger — how to pull executive compensation data for a large number of executives quickly and simply (professional subscribers only).

Begin on our XBRL Raw Data Query page, and look near the top. You’ll see a link to another page called Non-XBRL Earnings Release data. See Figure 1, below.

That page lets you find various pieces of non-GAAP data that firms include in their financial report, such as adjusted earnings, free cash flow, and similar items. But Calcbench also lets users pull certain predetermined non-GAAP reports — and executive compensation is one of them.

Say you want a quick download of 2020 executive compensation data for all firms in the Dow Jones Industrial Average. You would start on this page, and set your “Choose Companies” selection to the DJIA. In the “Fiscal Year” field, top right, you’d enter 2020.

Then at the bottom of the page, you’ll see the option for an “Executive Compensation” report. See Figure 2, below; and note the red arrow pointing to the report you want.

Click that choice, and you’ll get a spreadsheet with all firms in the DJIA that have already filed their 2020 proxy statements. Each executive gets his or her own line, with a neat breakdown of compensation data by type: base salary, bonus, share grants, option grants, pension payments, and the ever-popular “other.” The far right column will report total compensation.

See Figure 3, below, for an example. It’s not the best shot because, well, there’s just too much data for us to show in one image. (#HumbleBrag.) But you get the idea.

You can also use this page to conduct more expansive searches of data. For example, you could search a single company for several years’ of data at once; or even multiple companies for multiple years of data, although you’ll probably get to a large pile of data quite quickly. And as you can see from Figure 3, above, every line of data we return also includes a link back to the original source document filed with the SEC.

Happy searching!

FREE Calcbench Premium
Two Week Trial

Research financial & accounting data like never before. Get features designed for better insights. Try our enhanced Excel Add-in. Sign up now to try the Premium Suite.