Financial Statements Spreadsheet Upgrade

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.

13 responses to “Financial Statements Spreadsheet Upgrade”

  1. peekay says:

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

  2. Graham Jervis says:

    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 says:

    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 says:

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

  5. Brad says:

    Price to forecasted earnings would be nice 🙂

  6. eric says:

    Hello Jae,

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


  7. Jae Jun says:

    @ 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 says:

    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 says:

    @ k007,

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

  10. Jason says:

    Looks good Jae, looking forward to the upgrade.

  11. k007 says:

    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 says:

    @ 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 says:

    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 Reply

Your email address will not be published. Required fields are marked *

Ready to try Old School Value?