So, with all its glory, I present to you my automated Rule #1 Analysis Spreadsheet! With this spreadsheet, you really only need to look at 3 tabs.
- Go to the "Stock" tab. Fill out the 3 pieces of information there. Click on "Refresh Data" and wait for Excel to update the data from the web.
- (Optional) Go to the "Sticker Price" tab. Change the growth and P/E numbers if you want.
- Go to the "Summary" tab. Look at the results. Voila!
Update December 3, 2011: I've updated the sheet. Go to the Investing Resources to download the latest sheet.