Thursday, May 13, 2010

Rule #1 Analysis Spreadsheet for Free!

Free lunch!

You know what they say, "There's no free lunch in this world!"  Hey, I'm telling you now, there is!  If you've been reading my blog, you know that I'm a big fan of Phil Town and his book, Rule #1.  In it, he gives the reader a very methodical way of finding the intrinsic value, or its "sticker price", of a stock.  He looks at the "Big 5s", 5 numbers that tell you how well a company is doing.  They are: i) return on invested capital (ROIC), ii) sales growth, iii) earnings per share growth, iv) book value per share growth, and v) free cash flow growth.  He wants all 5 of these numbers to be greater than or equal to 10% on average for the last 10 years.

For those of us who are not accountants, not only do we not know where to find this data, we don't even know what half of these things mean!  Well, there are 2 steps to rectify this situation: read his book (link on the right), and use my spreadsheet!  I can't provide the first for free, but your local library may be able to.  I can, however, offer you my spreadsheet for free (if you feel obligated to repay me, just email your friends about how great this blog is!).  You can download it right here.  There is a macro embedded in the spreadsheet.  Don't worry, it's not a virus...I just wrote some code to simplify the process.

There is a short tutorial inside the spreadsheet itself.  So, I will not go into the details of the mechanics here.  Essentially, you type in the symbol of the stock of interest, click a few links, copy and paste a few tables, press a couple of buttons, and you have on your monitor, a Rule #1 analysis done for you, all in 2 minutes.  If you are having trouble with it, just leave me a comment.  I'll be sure to respond.

You guys can all thank Anthony for leaving a comment on my previous post on how to read the Form 10-K of True Religion.  He reminded me that I should share this spreadsheet with the rest of the world.  Anyway, give it a try.  I've saved countless hours with it.  On my next post, I'll talk about the results I got for True Religion with this spreadsheet.  Stay tuned!

Update February 17, 2011: I've updated the sheet.  Go to the Investing Resources to download the latest sheet.