Buffett and other respected investors mention that if you need a spreadsheet to determine a fair value of a company, the investment idea should be thrown into the pass pile. I only agree to some degree on this comment. It’s true that we should concentrating on no brainer investments rather than deworsifying into extra positions just for the sake of being invested, and while most people can read the financial statements to some degree, I’m sure many have trouble grasping all the numbers and coming up with a single dollar value as a fair intrinsic value number.
For me, as I run through companies, I always look at the free cash flow and cash flow statement first to determine whether the business is worth investigating. I can’t immediately come up with a number but I can determine whether the business is a good one. The stock valuation spreadsheets you find on this site was created to determine whether these stock ideas are cheap and to determine the buy and sell price range.
So far I use the following stock valuation methods:
Discounted Cash Flow
Ben Graham Formula
Ben Graham Net Net Formula
So even with 4 analysis tools in my toolkit, there is a hole that needs to be filled. Currently, I am still unable to value companies that are:
This is where I believe Bruce Greenwald’s EPV method will come in handy. The stock valuation method allows the investor to value all of the above points.
A full detailed explanation of earnings power valuation in a practical step by step guide is available for Microsoft. The stock investment spreadsheet also allows you to perform a fully automated earnings power value stock analysis.
I was able to find Greenwald’s lecture notes from Columbia business school on the investment process and valuation which I’m sure you will all benefit from.
The EPV section starts from slide 16.