A few readers have accused me in the past of being a sadist who wants them to do the dirty work of analyzing companies on their own, instead of simply recommending stocks like so many other blogs do.
But I’d rather give you a compass instead of a map, for you can confuse map with territory and lose your life’s savings walking that path!
In this pursuit of handing you another compass, here is Version 2.0 of my Stock Analysis Excel Sheet that you can download on to your computer, and analyze not just the past performance of a company but also arrive at its approximate intrinsic value.
If you have been into financial modelling in the past, this excel file may seem like a child’s play. But, if my fourteen years of experience as an analyst is anything to go by, this is most of all you require to “quantitatively” analyse stocks…not models running into hundreds of rows and tens of sheets.
[Read more…] about Analyze a Stock in 60 Minutes (Free Stock Analysis Excel Version 2.0)