The CapEdge data charts let you plot and compare up to five years of detailed financial data for a company. Click the Data tab on a company dashboard to access the financial data charts for that company.
How to use the chart tool
The metrics list displays all financial metrics that have been submitted by the company in the last five years. Next to each metric is a list of segments that can be plotted for that metric, e.g. by geography or corporate department. Click the checkbox next to a metric to plot the value. Metrics often only have a single segment, named Default, that displays the default (total) data for that metric. Note that metrics may be available for differing date ranges, or a single date, depending on what data the company has filed for each over the last five years.
Use the filter at the top of the metrics list to narrow-down the list of metrics by name, e.g. type Revenue to list all metrics with Revenue in their name.
When you select a metric, it will display in the chart and chart key. If data is available for multiple periods, e.g. Quarterly and Annual, you can use the buttons in the chart keys to choose the period. Metrics that don’t display a period in the chart key are point in time measurements, rather than a measurement for a quarter or year. For example, Assets is typically measured as a total figure at any particular time, rather than a quarterly or annual value.
To remove a metric from chart, either uncheck the checkbox in the metrics list, or click the icon in the key list. The Clear button above the chart will remove all metrics and clear the chart.
Click the Plot relative toggle switch to change all plotted metrics to relative values. This plots all metrics on a scale of percentage change, starting at a zero value for the first available figure. This allows you to more easily compare the relative growth of metrics from different scales or units, e.g. to compare how revenues have changed relatively to costs over time.
Click the Compare to link in the metrics list to compare any other company to the current company. Each may have filed different sets of metrics – click the Common only button under the metrics filter to display only metrics that are available for both companies.
Click the Stock price toggle switch to include stock prices in the charts. Stock prices also respond to the Plot relative toggle so that you can compare the relative change in stock price to any other metrics.
Click the Download data button above the chart to download a CSV file of all data currently plotted on the charts.
About the data source
The data comes directly from SEC company filings, specifically the XBRL data files that are commonly filed with 10-Q, 10-K, and other routine financial reports. We aggregate data from up to five years of filings for each company, using the latest figure for a metric if there are differing values, e.g. a subsequent 10-K/A amended value will override a previous 10-K value.
Apart from a limited number of U.S. GAAP metrics, companies are free to choose their own names for metrics, and how they do or do not break down a metric into segments of data, e.g. by geography or product-line. Companies can also be inconsistent about naming metrics from one year to the next, so they may use one metric name until 2017, then a different name after that. At the moment we do not attempt to map or normalize these inconsistent names.
Interpolated quarterly values
In quarterly reports, companies often report values for the financial year up to that quarter, e.g. the first 3 months for Q1, the first 6 months for Q2, and the first 9 months for Q3. In order to present more useful and consistent quarterly data, we interpolate quarterly data from the difference in these periods when it is not available. For example, the second quarter financials can be interpolated by subtracting the value for the first 3 months from the first 6 months. Interpolated values are highlighted in yellow on the charts to show they have been calculated by CapEdge, and not filed directly by the company.
Financial statements help
Financial statements – income statements, balance sheets and cash flow statements – are automatically created from the raw data ("XBRL") filed in financial reports. Every company files slight variations on the same metrics, which can sometimes include their own proprietary metric definitions. They can also use the wrong metric names to file a similar but incorrect item of data.
We use the official FASB XBRL US-GAAP Reporting Taxonomy to map all standard GAAP metrics to the same line-items in the financial statements you see on CapEdge. This means that while most of the commonly filed top-level metrics are usually accurate and consistent with the published earnings reports (e.g. Revenue, EPS, Net Income, Assets, Liabilities, Cash Position, Cash Flow), you should be aware of the following:
- Blank entries are not necessarily zero; they are entries that could not be mapped for that period/metric. Common reasons for this are because the company didn't file the particular line-item, or they filed a custom, non-GAAP equivalent for the metric (e.g. TSLA does this often).
- Sub-totals and totals aren't necessarily totals of the line-items above, because the line-items aren't comprehensive. For example, we don't list all possible operating expenses on the income statement, or all possible current assets on the balance sheet. If there's a missing common line-item you think we should include, please contact us and let us know.
- Values may not match the values in company earnings reports for some line-items, because they have used a GAAP metric in a non-standard way. For example, AMZN use the standard GAAP "Cost of Sales" metric in their FY 2019 earnings report as an "Operating Expense" line-item, but the FASB standard accounting practice defines this metric as a "Cost of Revenue", not as an operating expense.
Cash burn rate
The cash burn rate is estimated based on data from the company's previous financial reports, and doesn't take account of any filings or fundraising since the last report, e.g. additional sale of securities.
The estimated burn rate is calculated using three different techniques:
- Change in cash. This is the simplest technique and calculates the burn based on the change of "cash on hand" between subsequent quarters. This includes all historic elements of cash flow, including cash raised/spent on investing and financing activities, e.g. sale of securities.
- Operating income/loss. This calculates the burn based on the quarterly operating loss (i.e. not including investing/financing cash-flow), converted into a monthly value.
- FCF (Free Cash Flow). This is the monthly equivalent of operating cash flow plus capital expenditure.
Depending on the availability of historic data, we calculate each of the above burn rates twice:
- Last Q. This uses financial data from the last reported quarter only, i.e. is the most accurate if the most recent quarter represents a typical quarter.
- Avg 4Q. This calculates an average for each burn rate over the last year, by calculating the burn rate for each of the previous four quarters and then averaging the total. This may be more accurate for cyclical industries.