Old School Value blog

Empowering value investors with stock valuation, ideas and tutorials

Financial Statements Spreadsheet Upgrade

March 25th, 2010

13 Comments

Automatic Financial Statements  Analysis Spreadsheet Major Upgrade

There’s a reason why I haven’t been writing many articles in March.

I’ve spent the majority of Feb and March on

  • completely redesigning
  • implementing and testing new ideas
  • including new features
  • making it easier to read
  • helping you to save as much time

so that you can spend your precious time on analysis rather than time consuming, ugly data collection and organization.

I’ve got the dirty work covered.

The major upgrade to the automated financial statement spreadsheet will be released to all premium spreadsheet buyers very soon.

Make sure you get the spreadsheets quickly and you’ll be the first to see the free upgrade in your inbox when it is released.

Here’s a quick guide of what has changed. Some images are large so you’ll have to click to view the full size.

Cool Professional Design + Functionality

Notice the enter ticker and help button to make life easier. You wanted explanations and I listened. In the future, I’ll try to include as much info into the help as possible.

Quarterly Inventory Analysis

This section was built on the example provided in the CONN inventory analysis. The first image is an expanded view and the second is the grouped view. You use the two buttons to switch views.

Debt Interest Expense Analysis

Another example of a simple analysis that I perform when analyzing stocks. Since I do it so often, why not automate it?

EPS Due to Tax Rate Changes

Find how the tax rate change yoy or qoq can have an affect on EPS with this spreadsheet.

EPS Due to Non Operating & Non Recurring Income

You can choose which line to check. Choose from either interest income, other special charges, R&D and SG&A. Don’t forget you can find something completely different by entering in your own values.

Earnings Due to Depreciation Expense

You may think these new tabs look the same but when you look at it for yourself, you’ll notice the differences and the different methods of calculating each one.

Remember that all premium spreadsheet buyers up to 1 year ago will receive the new version in their mailbox very soon. New buyers will automatically receive it as well when released.

You may also like:

  1. Investing Book Review: Financial Statements
  2. Financial Statement Analysis Spreadsheet Tool
  3. Investment Spreadsheet: How to Use Tutorial
  4. Free Altman Z Score Spreadsheet
  5. Investing without a framework is financial suicide

Are your stocks cheap or overvalued? Check with the stock valuation spreadsheets

13 Comments

  1. - peekay

    Great Job Jae ..! looking fwd to it..

  2. - Graham Jervis

    Hi Jae,

    cant wait for this. also remember to slip in the Altman Z score into the spreadsheet also. I believe this would be a nice addition in terms of Risk.

  3. - Jae Jun

    Thanks peekay.

    @ Graham,
    The Altman Z score is going to be included in the stock valuation spreadsheet as it is just a single number. I’ve got a loooong way to go on that one.

  4. - slinj

    Jae, Great job, it looks really good. I love all the nice functions you are adding to it.

  5. - Brad

    Price to forecasted earnings would be nice :)

  6. - eric

    Hello Jae,

    Do you by any chance have any plans to make this or the other spreadsheet available for Mac users?

    Thanks

  7. - Jae Jun

    @ slinj,
    Thanks. Your feedback helps a lot.

    @ Brad,
    I don’t know where to get that info so if it’s a simple addition, send me the link and I’ll take a look, but I rarely add earnings related items.

    @ eric,
    Sorry. I didn’t create the add-in so that’s out of my hands. But from what I’ve heard and read, I don’t see it happening for now.

  8. - k007

    the sheet is amazing. have you thought of working on a sheet that would allow a user to place several tickers on the left with important valuation info on the right, thereby allowing one to screen for “cheap” stocks daily in real-time?

  9. - Jae Jun

    @ k007,

    Thanks. I believe that can be covered by using the competitor comparison sheet. Have you looked at that?

  10. - Jason

    Looks good Jae, looking forward to the upgrade.

  11. - k007

    i meant something that i can place 50-100 stocks that i am watching (a watchlist) with important valuation parameters and real-time price for each ticker so that if i have cash at any one given time i can quickly assess what my cheapest value stock option is…

  12. - Jae Jun

    @ k007,

    Yes I see what you mean. I’ve already created a stock tracking database feature but haven’t released it. Still fiddling around with the presentation and coding.

    That upgrade will be in the next quarter or so. Not the one that is coming up in a few days.

  13. - kidchoi

    Jae, your spreadsheets are great. The “watchlist” feature would be good to have in the database version, wherby you can set alarms when certain thresholds or user defined M.O.S. are met. Anything to help take the emotion out of decision making. We value investors need to take it out as much as possible because when the day comes we need to be ready and decisive. I am also looking forward to the day you upgrade the spreadsheet to also be capable to analyze financial companies too. I know the valuation process is different but I’m sure you can develop a new or integrated format that would work! Maybe start with just commercial banks and go from there.

Leave a comment


(Required)


(Required and not published nor shared)