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

Friday, August 23, 2019
By the Numbers: Restructuring Costs Over Time

Wednesday, August 21, 2019
WeWork Liabilities, Part II

Tuesday, August 20, 2019
WeWork’s Liabilities in Perspective

Wednesday, August 14, 2019
Comparing LinkedIn, Twitter Revenue

Wednesday, August 7, 2019
Leasing’s Effect on Retail Balance Sheets

Thursday, August 1, 2019
Using Calcbench to Find China Exposure

Tuesday, July 30, 2019
Leasing Details: The Comcast Example

Monday, July 29, 2019
Easy Fundamental Equity Analysis in Python

Monday, July 22, 2019
Calcbench Data and Tax Reform Insight

Wednesday, July 17, 2019
Downshifting in the Trucking World

Tuesday, July 16, 2019
New Report: Adoption of New Lease Accounting Standard

Friday, July 5, 2019
More Consequences of Lease Accounting

Archive  |  Search:

When we say Calcbench goes nuts over financial data, we mean it.

We recently launched a new feature for our customers on the Company in Detail page: the Show All History function. Now you can find all the line-item data a company has ever disclosed, for all the financial reports we have on that company, all neatly aligned in one easy-to-read page.

We’re not ones for fancy process around here, so the feature works like this. First, you find the company you’re researching on the Company in Detail database. Then you hit the Show All History button. That’s it.

Let’s take Netflix as an example. Pull up its default display, and you’ll see a short summary of its operations for the last four annual reporting periods:

Nothing unusual here, but you can see that virtually every line item has a value for every reporting period (with rare exceptions, like the one time Netflix disclosed loss on extinguishment of debt in 2013). If this summary is all you want, you can also dig back into prior annual periods by using the Add Previous Period button on the far right (circled in blue). That will add one prior year at a time, as far back as our database goes.

If you want more detail all at once, however, hit the Show All History button (below, circled in red) and you’ll see something like this:

First, we present all the annual periods we have for Netflix, going back to 2007. Look more closely, and you can see all the smaller line items Netflix has included at one time or another over the years. For example, Netflix used to split out its revenues into subscriptions and fulfillment expenses until 2009. Likewise, even earlier in its history, Netflix also reported losses from its disposal of DVDs (back when people still used DVDs). If you only looked at our summary presentation in Figure 1, you wouldn’t see that. Now you can.

Or for another view, shift from the Operations summary to Balance Sheets (the tab way over on the left side), and then hit Show All History again. Now we have the balance sheet going back to 2007, with all line items included:

You can see that starting in starting in 2010 Netflix started reporting Current Content Liabilities as a liability (that’s a custom XBRL tag), while in other years it reported prepaid revenue sharing expenses, or long-term debt due to related parties, and the like.

What can you do with all this detail? Deepen your knowledge of a company’s financial reporting history, which in turn can sharpen your thinking about questions you might want to ask management or comparisons you might make with that company’s peers. Changes in line items over the years can suggest changes in business model (think of Netflix moving from those red DVD sales boxes in supermarkets to online streaming), changes in accounting policy, changes in operations—changes in a lot of things, really. We simply give you an immediate, easy way to see what has happened and then ask better questions about why.

The Show All History feature works for all financial statements we track: cash flows, income statement, stockholder’s equity, balance sheet. You won’t necessarily get the same results for every company, since each filer has its own history, but it’s an excellent way to dive as deeply into a company’s financial data as you want.


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.