Financial Statement Analysis Spreadsheet Tool

Pick the best value stocks with our Stock Ranks, screening and valuation tool. Try the live demo today.

There is a new addition to the suite of investment tools offered here at Old School Value.

By using the SMF Add-In, the new financial statement analysis spreadsheet retrieves 10 years of annual financial statements and 20 previous quarterly financial statements from ADVFN. Morningstar has a good database, which is what I still  use in the intrinsic value spreadsheets, but this new one is very detailed.

You can now see things like how much raw materials make up inventory, the full list of items that affect Cash from Operations, the price of acquisitions and a host of financial ratios.

The free financial statement spreadsheet is simply a raw file which just retrieves the data. There is no formatting. It contains the past 6 annual statements and 7 quarterly statements.

The best dcf spreadsheet version is fully formatted and edited. 5885 individual cells had to be hand edited in order to get it working. Total time spent working on this amount to approx 30 hours as I am not much of a programmer and  had to do things the hard way.

There are no graphs at this point as I feel that graphs take the focus away from other numbers and trends that are just as important. However, should I decide to do more with it, I will provide free updates to buyers.

Click to get your ratios list now

Trouble Shooting Notes

  • To improve loading time, the financial statement spreadsheets does not perform any calculation when loaded. To start the calculation, press F9.
  • Does not support financial companies
  • All other troubleshooting solutions remain the same which you can find from this PDF.


Please read the guide and FAQ section. To date, I’ve been spending hours helping people with simple excel issues on a free product rather than anything spreadsheet related.

So for all excel and install problems, place all questions in the comment sections below. That way I won’t have to answer the same question again and again.

Download Section

Download the free financial statement analysis spreadsheet.

Download PDF of the Premium Version. MSFT example.

Go here for a cheap premium version. (Save yourself 60 hours of labor).

What is Old School Value?

Old School Value is a suite of value investing tools designed to fatten your portfolio by identifying what stocks to buy and sell.

It is a stock grader, value screener, and valuation tools for the busy investor designed to help you pick stocks 4x faster.

Check out the live preview of AMZN, MSFT, BAC, AAPL and FB.

6 responses to “Financial Statement Analysis Spreadsheet Tool”

  1. PlanMaestro says:

    This looks like very good work. How many companies are included?

  2. Jae Jun says:


    It is automated so it will pull up data for an public company that has filed its 10-Q’s and K’s properly.

  3. J.C. Hyjun says:

    Jae Jun,

    Thank you for very useful spreadsheets. I tried to use Financial Statement Analysis Spreadsheet for JNJ and GE it shows me only 5 years Annual and 7 Quarterly statements. I guess the cause is the limited history in WWW source.

    You probably noted that data for the same company at different WWW sites are different – it would be nice to have clone of your spreadsheet based on each WWW portal, so your customers can get more inputs.

    BTW, more deep history and lot of raw data can be downloaded from http://www.smartmoney.com/

    Thank you again

    J. C. Hyjun

  4. Jae Jun says:

    For the free version, I just limited it to 5 years and 7 quarters. It is still a lot considering that the spreadsheet is free and can be tweaked anyway you like.
    The premium stock valuation spreadsheet uses smartmoney by the way.

  5. William Gass says:

    I have been thinking about purchasing this program; however, I cannot get the free version to work. I have downloaded the SMF function and activated the function in excel. Is the free version supposed to retrieve the data from the WWW. For example, I tried the FDX ticker and no information was returned through excel. I am running excel 2007, could this be the problem?


  6. Jae Jun says:

    There were many changes that caused the spreadsheet on this page not to work. To get the latest working versions, sign up with your email and you will get a list of downloads.

Pick Winning Stocks and Fatten Your Portfolio