Stock Market Investing Tips 101: #8- A Legendary Stock Watch Worksheet
In the first 7 articles of this series, I covered basic definitions of investing, and free internet resources for stock analysis. If any of the information in this post feels unfamiliar to you, I encourage you to review these previous entries.
In this article I present a classic stock analysis technique. I outline Jason Kelly’s Stocks to Watch Worksheet defined in Chapter Seven of his book The Neatest Little Guide to Stock Market Investing. This is how Kelly describes this sheet:
“ This is the legendary system for picking winners, thoroughly explained in the book and revered around the world. You will not find analysis this complete in such a small space anywhere else. Entire investment clubs have sprung up around this remarkable approach. A must-have!”
You can download a free PDF of this worksheet from Kelly’s website. I have created my own version on Microsoft Excel. I prefer excel because I can manipulate the data more easily. On my version, I have also added Kelly’s definitions, required/ideal criteria, and “where to find it” information for each statistic. Until I feel comfortable with these many terms, I want to have the explanations right in front of me. If you would like a copy, e-mail me at lisa.spinelli@comcast.net.
About the Stocks to Watch Worksheet
Purpose: To allow you to look at key evaluative statistics of each stock on one page. Here you can easily compare each company’s strengths and weaknesses before determining the best stocks for your portfolio.
Lay-out: There are thirty two columns for entering the information you’ll collect for each stock. Each column is put into one of five categories: Basic Information, Company Health, Past Performance, Projected Performance, and Stock Ratios. Here’s how they’re broken up.
Basic Information:
Company Name, Symbol, and Phone
Current Price
52 wk Hi/lo
Market Cap
Daily Dollar Volume
Sales
Company Health:
Net Profit Margin
Cash
Total Debt
Sales per Share
Cash Flow per Share
Earnings per Share (EPS)
Dividend Yield (dollar/%)
Return on Equity (ROE)
Insider Buys
Insider Ownership
Stock Buyback
Past Performance:
EPS Rank
Relative Price Strength Rank
5-Year Sales and Earnings Gain
5-Year Price Appreciation
Projected Performance:
Projected Sales and Earnings in the Next 5 Years
Projected Stock Hi/Low
Valueline Timeliness/Safety
S&P Stars/Fair Value
Stock Ratios:
Current Price-to-Earnings (PE)
Average Price-to-Earnings
Price-to-Sale
Price-to-Book
Current Ratio
Quick Ratio
Max and Min
The goal is to have twenty potential stocks to purchase on your list. In my Stocks 101 #9 entry, I’ll discuss the stocks I’ve found so far. I’ll also discuss the ease/difficulties I have finding the information.
| 2.5 |
I join the movement 
Yea, Entrecard is loading really slow these days, I can hardly get into Entrecard site and widgets are loading slow ...
I will leave you a comment, but I recently left EC because it is down 90% of the time. ...
Y - I - K - E - S !!! Nothing like disappearing for a while. I thought ...
I agree...
The need (or willingness?) to win sometimes makes people unable to think about the real value of the goods ...
@Dario and Karl: glad to oblige. My access to your e-mails is down- if you could e-mail me at lisa ...
