Filing size of 10-K reports

No too long ago a student asked me if it was possible to find out what the size was for specific filings of companies with the SEC. Specifically it concerned the 10-K filings which are the annual reports with a comprehensive summary of the companies financial health. As I understand it, the file size of these filings was to be used in an exercise and served as a proxy for financial reporting readability.

To find the original filings it is of course possible to use the EDGAR search option to find the original full-text filings and parts (including the XBRL filings):

Using the Central Index Key (CIK), Ticker, or Company name it is easy to find a specific company. Using the Filing Type search box you can narrow the search down to specific filings, like 10-K. This is often possible going back to 1993/1994 (depends on the company).

A specific 10-K filing overview in Edgar would look as follows:

If you need to do this for several hundreds of companies and multiple years it would take some time to collect the file size data. If you have access to the Audit Analytics database it is possible to get the 10-K file size for a large number of companies at once through the WRDS platform. Audit Analytics has a part database that is called Accelerated Filer.


Through this part database it is possible to get filings data (from 2000 to now) using Ticker lists or CIK lists. In the example output below I have put the following variables:

NAME = Company Name
FORM FKEY = Form name (10-K and 10-Q)
FISCAL YE = Fiscal Year End
FILE SIZE = Filing size
MATCHFY_SUMFEES_FY = Fiscal Year

Example output using Excel to filter for just 10-K filings:

Important: If you look at the 2015 10-K form file size according to Audit Analytics for the company ADVANCE AUTO PARTS INC this is 17 MB. This corresponds (roughly) with the size of Complete submission file according to EDGAR: 17.748.770. The Complete submission file in Edgar includes not just text and html codes, but may also include pictures and any other file types (Excel files etc.).

Email

Audit Analytics versions

The database Contains information on the accounting and financial institutions in the United States of America. The database is used by:

* 18 of the top 20 public accounting firms
* 4 of the top 5 Errors And Omissions insurers
* Over 200 universities
* 7 regulatory bodies.

Audit Analytics covers over 20,000 public companies and more than 1,500 accounting firms from filings at the Security and Exchange Commission. Two versions may be used of the Audit Analytics database: the version availabe through the IVES Group company website and (if you have access to it) the version available through the WRDS portal.

The main advantage of the WRDS version is, that it is easy to download data for many years in one go, using the easy 4 steps that are virtually exactly the same for each database that can be used through WRDS. You may need to study the Audit Analytics manual (= Data dictionary excel file) carefully to find out which data items are available in which part-databases.

The IVES website version, however, is more intuitive and allows for easy switching between the separate parts and clicking on to specific sections for more data. Also, it offers many links to the SEC database Edgar with its public SEC Filings (the full historical Edgar is available through LexisNexis).

Email

Using XBRL files

More and more companies publish company results not only in quarterly and annual reports but also in the XBRL format. This makes it easier to view the filings and export reporting figures to other prorams like Excel for comparisons and further analysis. Specific features are built into accounting programs to allow for the production of XBRL filings. Some free software programs to view and use these filings have also been made. Two examples that are (mostly) targeted towards US company filings are:

Calcbench.com is an excellent free web-based program that allows you to view US company filings in XBRL and even allows for an easy comparison for more than one year. The program has an easy export option (after registration) for Microsoft Excel. Calcbench was named the 2012 winner of the XBRL Challenge, a contest for developers to build applications leveraging XBRL-formatted data from the Securities and Exchange Commission’s EDGAR database. A sample screen is shown below:

Dragon View (version 6.1) is a program from Rivet Software. It is a good tool that is easy to use and allows you to export the reported data to Microsoft Excel and HTML formats. The Excel export option is only available in the a licensed version of the program. A sample screen is shown below.

Email