There are hundreds of websites around that provide real-time quotes and basic fundamental data for stocks such as P/E ratio, EPS, etc. Usually only current information is available however, as of the current trading day. Value investors by contrast often need up to 10 years of historical fundamental stock data to complete their research. Fortunately there are two excellent websites available that provide free ten year historical data. We’re going to look at both of them today.
The two historical data resources we’re going to look at each have their pros and cons, but both are excellent:
- GuruFocus: A site geared towards providing value investors with data specific to their needs. Besides offering 10-year financials, GuruFocus also calculates valuable metrics not available on other sites such as the Piotroski F-Score, Altman Z-Score, and Beneish M-Score. All data can be downloaded for use in MS-Excel.
- Morningstar: Beautiful interface and offers 5-year and 10-year historical financial data. It also allows users download historical data directly to excel, saving a lot of time for detailed analysis.
Guide to GuruFocus Historical Financials
GuruFocus has tons of tools, calculators, and information available to help value investors make decisions, but in this article I’m going to focus specifically on the historical financial data that’s available, and how to access it.
After navigating to the GuruFocus website and entering a ticker symbol, you’ll be brought up with a great summary page, which does an excellent job of outlining the current condition of the stock. For this example I am going to use Apple (AAPL). The historical financials can be found by navigating to the 10-Y Financials tab in the navigation menu (click to enlarge).
This is the most useful and thoughtfully laid out set of company financials I have ever seen. The income statement, balance sheet, and cashflow statement are all displayed on the same page so that information can easily be compared without having to flip back and forth between multiple pages. The past 10 years of annual historical data, the past 5 quarters of quarterly data, and the latest TTM data are all displayed in one easy-to-use layout. The numbers can be displayed as either dollar amounts or as a percentage by clicking the toggle button.
Besides the financials, GuruFocus also displays all of the common per share metrics such as EPS, RPS, BVPS for the past 10 years as well. Below that are all of the historical key ratios such as historical ROE, ROC, ROA, margin data etc. A premium subscription to GuruFocus allows access to historical P/E, as well as some other data not available on other sites to my knowledge such as historical Graham Number, Piotroski F-Score, Altman Z-Score, and Beneish M-Scores.
One of the most useful features however is the ability to export all of this data directly to excel. This is accomplished by clicking on the export button near the top right corner of the table. Unfortunately it is only available to premium members, but GuruFocus does usually offer a free trial.
Guide to Morningstar Historical Financials
We’ll now look at the Morningstar site in more detail and look at the data that’s available to us. Each of the key features will be explored in detail, including explanations of where to find the relevant data.
Quick Summary of Recent Historical Data
Morningstar offers a quick snapshot of the past three years of annual financials, along with the most recent quarterly financials alongside the same quarter’s data from a year ago. This is extremely useful for getting an immediate feel for how the company has been performing in the recent past.
The key line items from the income statement, balance sheet, and cash flow are all included in this concise summary. It can be found on the Quote tab of the navigation menu.
10-year and 5-year Historical Financials
Morningstar offers a beautiful interface for exploring long term historical financials. There are two settings – 5 year data is available for free, while 10-year data requires a premium subscription. By clicking buttons in the interface you can choose whether to display the numbers as dollar amounts, percentages, or fractions. You can select whether to display annual or quarterly data, and the table also includes another column for trailing twelve months (ttm) financials.
These financials are all found surprisingly enough under the Financials tab of the navigation bar, and then the Income Statement, Balance Sheet, or Cash Flow Statement can be selected from the smaller navigation bar down below. The home-run feature offered by Morningstar however, is the ability to download historical financial data directly into excel, simply by clicking the Export button. Here’s a screen shot of the data above imported into excel, without any other data manipulation:
Historical Price Data
Morningstar also includes historical price data. Both the date range and frequency can be selected, and there’s no limit to how many years back you can pull data from. Best of all, the data is exportable to an excel spreadsheet just by clicking the export button. Historical price data can be found under the Performance tab, and then the Price History sub-tab.
Historical Key Ratios, Growth Rates, and more
Under the Key Ratios navigation tab, there’s a wealth of information available, all presented in 10-year historical format, along with the latest ttm data. Included in the upper table are key metrics such as historical EPS, dividends, number of shares, book value per share, free cash flow, margin data, etc. The bottom table includes sub-tabs that display profitability, growth, cash flow, financial health, and efficiency ratios – again all over the past 10 years. Best of all, this entire dataset can be exported to excel.
Historical P/E and other Valuation Ratios
Clicking on the Valuation tab of the navigation menu brings up a summary of both current and forward valuations. More interesting however are the tables down below which provide historical P/E, P/B, P/S, and P/CF data for the past 10 years along with graphs. Historical P/E data can be useful in particular for determining the behavior of a company’s stock price is with respect to its earnings over time. Usually high growth companies command a higher price, but slow down as the company matures.