In addition to writing up my articles and analysis, I’ve tried to gather helpful tools and websites for other value investors. The Resources page has been one of the most popular sections of my blog.
While most of featured resources are free to use, I wanted to highlight one because, despite the nominal fee, it is one of the best values for other investors: the OSV Stock Valuation Spreadsheets.
Jae from Old School Value recently released the 2011 version of his stock valuation spreadsheets.
For those who are unfamiliar, the package includes 3 components: a core valuation spreadsheet, a secondary financial statement analysis spreadsheet, and a stock watchlist tracker (brand new in the 2011 update).
Updates and enhancements – and there are many – are included with the package for the first year.
Value of Automation
With the entry of a single ticker, the spreadsheets pull in 10 years of financial data and run through a host of different valuation scenarios – DCF, EPV, NNWC, NCAV, etc. The inputs/variables can then be intelligently adjusted to determine the intrinsic value of a particular business.
Other common but time-consuming financial numbers such as the Piotroski score, Z-score, and Beneish M-score are calculated automatically as well.
In 30 seconds, it provides a quick glance into a stock’s financials to see if it’s worth a closer look, automating much of the tedious work of manually entering numbers for various calculations.
In the past two years, I’ve personally ran hundreds upon hundreds of stocks through these spreadsheets, saving untold hours.
While it will never replace digging through the SEC Edgar database, it does help determine what companies to focus on.
While there are certain capabilities I wish the spreadsheets included (support for OTCBB/Pinksheet stocks comes to mind), there are very few products that are capable of providing so much value at such a price point.
To fellow value investors, I think the risk/reward is pretty compelling!
I earn a referral fee if the spreadsheets are purchased through the links above. As a general rule, I only endorse products that I use (in this case, every single day!) If every one of my readers took advantage, it might even subsidize my next spreadsheet upgrade