Thursday, 18 April 2013

A Look at Caterpillar


I’ve been looking to beef up my exposure to industrials for some time. With the addition of CAT and DE earlier this week, my portfolio is now 16.7% industrials.

Below is my analysis of CAT. I think it is neither expensive nor cheap, but probably close to fair value. 

Average Dividend Yield Analysis*

CAT-N
Year
High Price
Low Price
1Q
div.
2Q
div.
3Q
div.
4Q
div.
Annual Dividend
High Yield
Low Yield
2002
$30.00
$16.88
$0.175
$0.175
$0.175
$0.175
$0.70
4.15%
2.33%
2003
$42.48
$20.62
$0.175
$0.175
$0.175
$0.185
$0.71
3.44%
1.67%
2004
$49.36
$34.25
$0.185
$0.185
$0.205
$0.205
$0.78
2.28%
1.58%
2005
$59.88
$41.31
$0.205
$0.205
$0.25
$0.25
$0.91
2.20%
1.52%
2006
$82.03
$57.05
$0.25
$0.25
$0.30
$0.30
$1.10
1.93%
1.34%
2007
$87.00
$57.98
$0.30
$0.30
$0.36
$0.36
$1.32
2.28%
1.52%
2008
$85.96
$31.95
$0.36
$0.36
$0.42
$0.42
$1.56
4.88%
1.81%
2009
$61.28
$21.71
$0.42
$0.42
$0.42
$0.42
$1.68
7.74%
2.74%
2010
$94.89
$50.50
$0.42
$0.42
$0.44
$0.44
$1.72
3.41%
1.81%
2011
$116.55
$67.54
$0.44
$0.44
$0.46
$0.46
$1.80
2.67%
1.54%
2012
$116.95
$78.25
$0.46
$0.46
$0.52
$0.52
$1.96
2.50%
1.68%
2013


$0.52
$0.52
$0.52
$0.52
$2.08


Stock prices are per calendar year.
11y ave
3.41%
1.78%
Dividends are recorded in the quarter they were paid.
5y ave
4.24%
1.92%







3y ave
2.86%
1.68%







5y
$49.06
$108.45







3y
$72.76
$123.98






Super Cheap
$26.88



The table shows the 3 year average dividend yield to be 2.86% ((3.41% + 2.67% + 2.50%)/3). I use the numbers in the “High Yield” column for obvious reasons.

Using the current annual dividend of $2.08, one would have to pay $72.76 for a 2.86% dividend yield.

Buying the stock at its low in 2009 would have earned you an initial yield of 7.74%. Using the current annual dividend, that corresponds to a stock price of $26.88 today (see “super cheap” price in the table above).

Graham Price

CAT’s 2010, 2011 and 2012 EPS were $4.15, $7.40 and $8.48. 3Y Ave EPS = $6.68.
CAT’s BV is $26.76.
Graham Price = SQRT (3Y Ave EPS * BV * 22.5) = $63.40

Cyclically Adjusted Price to Earnings Ratio

CAT’s 10Y Ave EPS = $4.62
CAPE = Stock Price / 10Y Ave EPS = $80.46 / $4.62 = 17.4
A CAPE below 20 is good.

Conclusion

Based on the Average Dividend Yield and Graham Price, CAT is “expensive”. A relatively low CAPE indicates otherwise.

CAT increased EPS from $1.15 in 2002 to $8.48 in 2012. That’s an increase of 7.4 times over 10 years. 2013 and 2014 EPS are estimated at $9.05 and $10.15 respectively.

I plan on adding to CAT if it reaches the mid $70’s (roughly 10% below my purchase price).


*My method is not perfect as the stocks low price may have occurred before the annual dividend increase.


2 comments:

  1. I wish we could see the 7% yield again. Heck I'd settle for 3% for CAT. With the bounce back up off around the $80 level I don't think it's a steal from a dividend perspective but it's a good buy for total return.

    ReplyDelete
    Replies
    1. I'm begining to realize the mistakes i made in 2008/2009. I purchased stocks like BPO, CLC and GWO when i should have been buying stocks like CAT and DE with very high yields and dividend growth in the years that followed. I made money on BPO and GWO, but nothing compared to where I would be had I bought CAT and DE. It's been a good learning experience and I'm prepared for the next crash, whenever it comes. Thanks for stopping by. I would have responded sooner but my business trip was extended to three weeks.

      Delete