I’ve been experimenting with Quora, the new Q&A site that has been getting a lot of buzz lately. Recently, a question came up:
“Which web site gives the previous 10 years earnings of a public company?”
As value investors, looking at a company’s financials for the past ten years provides a nice overview of how the business performs during the ups and downs of the business cycle.
By using these averages, it helps smooth out one-time events and usually results in a much more conservative analysis – the hallmark of many great value investors.
My answer, reprinted from Quora:
While the SEC Edgar database is the time-consuming method, it is also the most accurate, and the only source I would trust if I was truly looking for thorough due diligence.
However, there are several other sources for historical financials:
MSN – http://moneycentral.msn.com – MSN provides 10-year financial summary information, but the summary is missing many key pieces (such as cash flow information).
SmartMoney – http://www.smartmoney.com/quote/… – Enter stock quote, click on financials, then change to the annual option (income statement, balance sheet, or cash flow statement). Must toggle between 5 years at a time and can’t export.
ADVFN – http://www.advfn.com – One of the most comprehensive sources of information, ADVFN provides financial statements that often cover a date range as far back as the EDGAR filings (1993 for many stocks). Search for a stock, then click on company information to find a host of ratios, charts, and links to the annual reports. However, you are limited to seeing a 5 year period at one time.
GuruFocus – http://www.gurufocus.com – Search for ticker symbol, click on 10-Year Financials. Provides single-page view of last 10 years AND last five quarters. Export to excel option is only available for premium members ($250/yr)
Morningstar – http://www.morningstar.com – Search for Ticker symbol, click on Financials. 10-year financials are only available for premium members ($185/yr). However, the export to excel option is available for the past 5 years of financial information. IMO, the cleanest and fastest export option with nicely formatted information.
SMF Excel Plug-in – http://finance.groups.yahoo.com/… – My personal favorite by far, this free excel plug-in allows you to build your own custom spreadsheets to pull updated information using over 14000 data points from various financial websites. 10-year financials, insider ownership, valuation ratios, etc. Requires some excel knowledge. For true flexibility and power, it’s hard to beat.
Personally, I spend most of my time in EDGAR but these other options can provide a provide a quick signal that further due diligence is required.
While the SEC Edgar database is the time-consuming method, it is also the most accurate, and the only source I would trust if I was truly looking for thorough due diligence.
However, there are several other sources for historical financials:
MSN – http://moneycentral.msn.com – MSN provides 10-year financial summary information, but the summary is missing many key pieces (such as cash flow information).
SmartMoney – http://www.smartmoney.com/quote/… – Enter stock quote, click on financials, then change to the annual option (income statement, balance sheet, or cash flow statement). Must toggle between 5 years at a time and can’t export.
ADVFN – http://www.advfn.com – One of the most comprehensive sources of information, ADVFN provides financial statements that often cover a date range as far back as the EDGAR filings (1993 for many stocks). Search for a stock, then click on company information to find a host of ratios, charts, and links to the annual reports. However, you are limited to seeing a 5 year period at one time.
GuruFocus – http://www.gurufocus.com – Search for ticker symbol, click on 10-Year Financials. Provides single-page view of last 10 years AND last five quarters. Export to excel option is only available for premium members ($250/yr)
Morningstar – http://www.morningstar.com – Search for Ticker symbol, click on Financials. 10-year financials are only available for premium members ($185/yr). However, the export to excel option is available for the past 5 years of financial information. IMO, the cleanest and fastest export option with nicely formatted information.
SMF Excel Plug-in – http://finance.groups.yahoo.com/… – My personal favorite by far, this free excel plug-in allows you to build your own custom spreadsheets to pull updated information using over 14000 data points from various financial websites. 10-year financials, insider ownership, valuation ratios, etc. Requires some excel knowledge. For true flexibility and power, it’s hard to beat.
Personally, I spend most of my time in EDGAR but these other options can provide a provide a quick signal that further due diligence is required.
Feel free to check out the other answers to this and other questions on Quora.
P. S. – Jae’s spreadsheets from OSV pull in ten year financials automatically, in addition to performing tons of other valuable calculations. I spent weeks tweaking my own spreadsheet using the excel plug-in above – the OSV offering is so much better!
See my spreadsheet review for further details.