The Legendary Stocks to Watch Worksheet Revisited
Lisa | Sep 20, 2008 | Comments 35
Time for me to break out my Legendary Stocks to Watch Worksheet. The market’s incredibly low, and there’s still many sound companies out there. Time to get in while the gettin’s good.
To justify playing the market at all - aka rolling the dice - I’ve stopped drinking coffee at work. That two dollars a day goes into a can. When I have $50 or $100, I allow myself to spend it on whatever I choose. One of the things I buy sometimes is stocks.
“Hey, Big Spender,” you may be thinking.
This is a lot of money in my book. That’s because I’m not the gambling type. I’m a tightwad when it comes to stock investing. I don’t like to lose. I haven’t bought shares lately. The market is nuts lately, and I haven’t taken the time to do the proper research.
But with dips like last week’s plunge, there has to be a lot of good buys out there.
My definition of a good buy: value companies with sound financials and a high dividend.
Here’s my original post describing my version of the worksheet - adapted from Jason Kelly’s version. If you’d like a copy, please leave a comment with your request on this post, or e-mail me at lisa dot spinelli at comcast dot net. I’ve already sent out about 25 copies.
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 [or leave a comment on this post].
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.
Related Posts
Related Websites - The Day Trading Robot They claim to have a robot installed to your PC and it gives you every kind of information, technical analysis, fundamental analysis, annual reports and...
- Stock Trading Pro System Tips We know the stock market is a very lucrative niche to be in and when you are a day trader or an options trader you...
- Good Stock Investors [caption id="attachment_122" align="aligncenter" width="515" caption="Stock Tips Good Day Trader"][/caption] The fantastic four are really four strong stocks that we will focus on a lucrative investment...
Filed Under: Investing • Stock Market Investing Tips 101: The Series
Linda
The Passive Dad
J. Money
Matt
Mr. GoTo
Could you be so kind as to send me copy of the excel file for the stocks to watch?
@David - Just got it out. I’d love it if you could let the readers here know what you think. Best - Lisa
Also a copy for me, at your pleasure.
I would also like to analyze your spreadsheet if you don’t mind!
Was just about to create an excel spreadsheet myself then came across this site
Could you also mail me a copy please?
Hi could you please send me your stocks to watch spreadsheet?
@Dario and Karl: glad to oblige. My access to your e-mails is down- if you could e-mail me at lisa dot spinelli at comcast dot net I’ll get it right to you.
Nice information. Little doubt on how and ordinary investor create there own excel sheet with these informations. Adding the Return on Capital will add more glory to this sheet.
A person who interested to make a formula to calculate all the ratios mentioned here can buy and read the “Financial statement analysis guide” written by Benjamin Graham. That will be a best source.
Sherin
http://investinternals.blogspot.com
Sherins last blog post..Investing ideas in a down market
Would love a copy in Excel as well…could you email to me at jtou812@hotmail.com ?
Thanks!
@jtou812 - I’ll get it right out- Lisa
Hi Lisa! Could you also send your Excel version to me? This sounds so ridiculous, but I don’t know which numbers refer to Kelly’s simple “Cash” and “Total Debt” columns. When I try to compare what others are saying, the numbers never match up! Grrrrr.
Thanks!
Hi Todd,
I’ll get the excel file out tonight. I’m no expert, but would cash be in the cash flow section of the financials at this link, and Total Debt be Total Liabilities, again in the financials section (you have to scroll down a bit?)
http://finance.google.com/finance?q=NYSE:NLY
Thanks for your interest - Lisa
Thanks for the excel sheet and the response! It’s much appreciated.
I mean, one would think it would be that simple…and maybe it is…but when I see reports of companies and where they stand in terms of cash and debt, the numbers in the reports never match up neatly with the numbers found on the linked page you submit as an example.
I know I’m just overlooking something simple…that is, I MUST be. It’s making me feel pretty silly, I tell you that.
Thanks again!
I would love a copy of your worksheet. Thanks much.
Hi Eric,
I just emailed you a copy of the Worksheet. Let me know what you think. I’ll be doing a new revision in about a month, and would love input.
Best,
Lisa
I would also love a copy of your excel worksheet.
Thanks.
Hi Fred,
Thanks for your request. I just sent you version 1. I’m working on version 2. Any suggestions would be welcome. Best, Lisa
Hi Lisa,
I was just about to create an Excel spreadsheet of Jason Kelly’s stocks to watch list and came across your kind offer to provide your version. I would greatly appreciate receiving a copy.
Thanks so much for your generosity.
Best regards,
Dave
Hi David,
I’ll get it right out to you. I’m in the midst of a revision, so any feedback you have is much appreciated. I hope it’s helpful. - Lisa
@ David- Could you send me your e-mail again? In an e-mail purging frenzy I accidentally deleted it- Lisa
Lisa:
I was doing some homework on dividend stocks and came across your Web posting offering an Excel “Legendary Stocks to Watch Worksheet.” I noticed the initial posting was in October, but if it’s not too late, I’d like to have a copy of the worksheet as well.
Thanks
Gary
Hi there. I just finished Jason’s book and was about to make a spreadsheet of my own! I’d love to take a look at yours!
@Gary&Marcus- emailed out the worksheet. Let me know if you have any questions. Thanks for your interest. Best-Lisa
Hey, interesting article. Ive used Kelly’s worksheet in the past. Can you send up that file? Thanks.
@Matt - I’ll get it out today. Let me know what you think. I’m working on a second revision, which will incorporate some of O’Neil’s ideas (IBD.) Best, Lisa
I’m currently waiting for your nifty excel sheet and can’t wait to get started.
Actually, I kinda already started and that’s where my question stems from.
Where do you find all this info? Why isn’t it all in one neat little place? I find myself looking at 20 different sites and it has taken me almost 5 hours to complete one stock option. I know this isn’t easy, but come on. There’s got to be a better way.
And I’m hoping you know what that better way is.
Thanks again for all your help. I hope to hear from you soon.
@ Just got it out, along with a couple of lists of aristocrat stocks I thought you might enjoy. re your question - I agree, unless you’re paying for a service such as IBD, you have to go to a few different places to locate the information. The thing that I find confusing, as well, is that different sites will use different names to describe the same parameter. You might want to sign up for IBD for free- The online is especially great. I don’t invest enough to get it regularly, but I pick up there newspaper once or twice a week.
Let me know how it’s going!
Please send me the file. I will use it for the stock in Chile, wher I live…
Would you mind forwarding me the excel version of the spreadsheet? Thanks!
This is my first conscious effort into investing in the stock market, a copy of that spreadsheet would really help me get started! Thanks!
Please send me a copy of the spreadsheet. I’m in the process of creating one for my Investment Club.
@ Joanne B - it’s on its way. In addition to Jason Kelly, I recommend William O’Neil (IBD) as well.