Financial Statement Analysis Spreadsheet Tool

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.

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.

IMPORTANT

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).

About Jae Jun


Jae Jun is the founder of Old School Value. He is on a mission to provide practical and actionable value investing tools, tutorials and educational material to help empower the individual investor. Keep in touch with Jae via any of the methods linked below.

Get Tips and Strategies to Achieve Higher Returns
Bonus: Get 9 FREE Investing Spreadsheet Calculators
  • PlanMaestro

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

  • http://www.oldschoolvalue.com Jae Jun

    PlanMaestro,

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

  • J.C. Hyjun

    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

    Sincerely
    J. C. Hyjun

  • http://www.oldschoolvalue.com Jae Jun

    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.

  • William Gass

    Hello,
    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?

    Thanks
    William

  • http://www.oldschoolvalue.com Jae Jun

    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.

x
Receive Email Tips and Strategies on Achieving Higher Stock Returns

Bonus: FREE Set of 9 Investing Spreadsheets