Seeking Alpha

# K L Beck's  Instablog

K L Beck
Send Message
I am an Individual Investor and have been investing since 1993.
• ##### Dividend Stock Worksheet

Unfortunately the Worksheet can't fit in this space, so please feel free to view or download a working ODT copy or PDF file here (Scribd.) or here (GoogleDocs). I've added a few questions that are explained on the 2nd page.

Oct 15 12:54 PM | Link | Comment!
• ##### A Simple Dividend Stock Worksheet

In August 2011 I purchased 10 well respected dividend stocks. Two days later the market plunged and I realized a new approach was needed for future stock selection and timing. A better way of understanding what to look for to locate undervalued stocks and when to buy them. Never again did I want to waste an opportunity to buy at a much better price.

This worksheet is the culmination of that search.

After completing this checklist I know whether to buy a dividend stock now, or wait, and know exactly why this decision is being made. I also have a much better grasp of stocks owned and what to keep track of in the future.

Each heading or question has a blue link directly to the info needed. The following may look confusing at first glance but only takes about 15 minutes per stock. Each step is explained below using Abbott Labs (ABT) earnings as of June 2012 as an example. You can view or download a copy in ODT or PDF form here with simplified directions attached or from GoogleDocs here.

(click to enlarge)

Each passing answer is marked in green - a failing one in red.

A - Pr/OE

Price to Owners Earnings - This is a gauge on how much cash per share there is after all expenses are paid. Less than 15 rates the stock a buy - 30 and above is a sell.

Scroll down the Key Ratios page to Free Cash Flow (I will refer to this as: FCF). Use the last numbers available in that row. Then find Shares Outstanding five rows above. FCF ÷ Shares Outstanding = the Owners Earning (OE) Per Share number. Then divide the share price by the OE.

For ABT I'm using the ttm (trailing twelve months) numbers from June 2012 and get OE of 4.845 (\$7.631 billion dollars divided by 1.575 billion shares). Now divide the stock price by 4.845 and get a number of 12.883. That is entered on the checklist. You can see the finished worksheet at the bottom of the page.

Here's a quote from the article by Peter Mycroft Psaras where I first learned of OE:"... you will see that I have proven that anyone buying stocks selling for 15 times or less a company's price to levered free cash flow would have done very well over the last 60 years, putting up results close to what Warren Buffett has achieved, which is only logical as he is the creator of the Owner Earnings ratio...". Link to source article is here.

B - Cap Flow

This number is the percent of Cash Flow going towards capital expenditures. It should be less than 50%. Go to Morningstar.com Key Ratios page and scroll down to Operating Cash Flow and Cap Spending. Divide Cap Spending by the number above it. I get 16.9%.

C - FROIC

This simply tells you how much profit is in each dollar of capital invested. FCF is divided by Total Capitalization. Go to the Balance Sheet under the Company Profile at TheStreet.com and scroll down to Total Capitalization. This should be more than 15%. \$7.631 FCF ÷\$36.48 billion Total Cap = 20.9%.

D - ROE

Return on Equity should be greater than 15% - ROE for Abbott is 20.1%.

E - Payout Ratio

Should be less than 50%. ABT's is 59% - I'll watch for that next year.

F - TRowePrGrR

This measures the growth rate of an investment. Take the ROE number of 20.1% x (100 minus the Payout Ratio of 59% = 41%) which is a growth rate of: 20.1% x 41% = 8.24%. You want this above 15%. Source article here for details.

This is an alternate to the payout ratio on how safe a dividend is. It shows how much FCF is used to pay dividends. Ideal is less than 50%. Scroll down to Payment of Cash Dividends at TheStreet.com under Cash Flow. This number is divided by FCF and gives me 38.5%. \$2.94 billion in dividends paid ÷ \$7.631 FCF = 38.5%.

H - Debt/Eq - copy this from the Company Profile page at TheStreet.com - we'd like to see this under 50%. Abbott's is 65%. I will watch out for deterioration in this number next year.

I - Yield

For the latest yield increase I go to Yahoo Finance and get 3.26% for ABT. Three percent is my limit on any prospective dividend growth stock.

J - 4YrDivGr

Four Year Dividend Growth Average - using the latest yearly dividend of \$2.04 from Yahoo, go to Morningstar.com's - Key Ratio page and subtract the 2008 dividend of \$1.41 which equals 63 cents. Divide that by \$1.41 for a total four year 44.68% rise. Divide 44.68% by four years = 11.17% average growth per year. It should be greater than 8% per year with the Yield and Dividend Growth added together and totaling 10 or more. ABT's total is 14.37.

Questions 1 - 5

These are Yes / No questions. Go to Morningstar.com's Key Ratios page. Check each row of numbers for stability and growth for the past 10 years. Operating Margins have fallen for ABT from 20.3% to 14.8% last year - this rates a No. The rest are growing. Link to source article for Questions 1 - 10 by Adam Bauer here.

Question 6

Check the share count for declining numbers. Abbott has had almost the same share count for the past 10 years.

Question 7 - 9

Using the same Key Ratios page, Abbott passes these also.

Question - 10

Valuation - Is the present P/E is less than the 5 year average. ABT's is higher than the 5 year and rates a No.

Question - 11

Has this investment kept up with the market - going to the Performance page and you can see that it beat the S&P by 19.18% in 2011. (This can be somewhat confusing - it lists how ABT did for the past 5 years, as well as year to date. It also lists the S&P. Two lines below that is: +/- S&P 500 TR - This line represents how ABT did in comparison to the S&P.) Source article by David Van Knapp here.

There are a total of five marks against ABT. Seven and above will make me wait and watch. Five is within the parameters I use for putting new money to work, so on to the 5 year chart.

(click to enlarge)

Before buying any company, the 5 year chart is checked with a 50 Day Moving Average & 100 DMA to see the direction it's heading. Also checked is SIA-Charts.com, which is a free site created by Peter Mycroft Psaras for this very reason.

In most cases:

1) When the 50 day moving average is above the 100 day moving average, the underlying stock price tends to continue to go up consistently over time.

2) When the 50 day moving average drops below its 100 day moving average, the stock price tends to continue to go down consistently over time.

A buy signal is when the stock price is above the 50 and 100 DMA with the chart showing an upward bias.

A wait and watch signal is given when the stock price breaks below its 50 DMA and/or 100 DMA. Wait for it to bottom and turn up before buying.

Here's the source article on the 50/100 DMA in detail. As per the chart, ABT is passing this one also.

Abbott Labs certainly rates a buy with both the worksheet and the 5 year chart test. Since purchasing it in August 2011 it is up 25.57%.

(click to enlarge)

Any errors or omissions in this article are solely the fault of the originator of this worksheet, and there are no connections to any of the attributed authors.

Disclosure: I am long ABT.

Tags: ABT
Oct 11 2:49 PM | Link | Comment!
##### Posts by Themes
Instablogs are Seeking Alpha's free blogging platform customized for finance, with instant set up and exposure to millions of readers interested in the financial markets. Publish your own instablog in minutes.