Wednesday, January 30, 2019

Dividend Cash Flow Forecasting


Telescope Image for forecasting
Forecasting Future Dividends
As a Dividend Farmer, I’m concerned less with value appreciation than I am with the cash flow I hope my farm will deliver at some point in the future.  Consequently, I pay attention to the rate at which my dividend stream is growing.  Conducting “what if” analysis to forecast where I think my dividend stream will be in the future under different assumptions is a regular activity.

For instance, I may run calculations using what I believe to be conservative assumptions e.g., 2% stock price appreciation and 3% dividend growth over a short horizon such as 8-10 years.  I’ll also do the analysis using moderate trends as well as what I think may be best case conditions.  From my perspective historical market trends are what I consider best case e.g., 3.5% price growth with 3.5% to 4% dividend to start plus moderate dividend growth annually and a time horizon beyond 15 years.
 
As a DIY dividend investor, I generally focus on the conservative case to bake in a margin of safety (thank you Mr. Graham).  Then I’ll look at the other two scenarios to gauge the upside under moderate to best case conditions.  Rarely are my exercises conducted using assumptions above historical averages.  Growth rates have a tendency to revert to the mean over time.  Variables beyond the average aren’t likely to be sustained through my investment horizon and therefore aren’t used in the models.

So what models do I use?  There are a few I like to run for cross-checking projections.  As you might expect, different models produce different outcomes since each can include variables the others don’t.
 
For instance, I start with a simple Future Value (FV) model using Excel.  This is a good one because there are only a few variables in it allowing me to run it from any handy spreadsheet.  However, the minimal variable model also means it’s tough to bake in assumptions about future dividend growth rates. 

In FV, the interest rate used may be a composite of the expected price appreciation and dividend growth rates rather than separate levers adjusted individually.  Also, FV provides a final output rather than showing the position each year between the beginning and ending years.

The next model I’ll use is the Dollar-Cost-Averaging (DCA) model from the DRIP Investing web site which publishes the list of Champions, Contenders, and Challengers.  This model is nice because it allows me to  plug in separate figures for dividend and stock price growth rates respectively.  Consequently, there are more variables to tinker with; exploring various assumptions and fine tuning the model.

Finally, I may drop my basic numbers into the Compound Growth Rate (CGR) vs Annualized Rate model found within the same tool as the DCA.  The model doesn’t allow for many variable adjustments.  However, its value lies in offering an aggregate look at possible outcomes from a valuation standpoint while providing compound and annualized rates to see how quickly (or slowly) my portfolio is growing.

The number of adjustable “knobs and dials” on each model is different meaning each produces a slightly different answer.  However, when starting with common items like beginning value, investment horizon, periodic additions, and similar growth rates, whether aggregated or broken out, the range of values across models may fall within 10% - 15% of one another.

In my latest analysis, the FV model provided the most conservative estimate.  The DCA model produced the best case outcome which was about 15% higher given similar inputs.  The CGR model fell roughly half way between the two.  As stated earlier, I generally focus on the output from the FV model since it’s the most conservative.

Once the figures are developed in the models, I’ll apply my current portfolio dividend yield to the final values to see what my expected stream of dividend payments may be at the end of my horizon.  If the forecast payment stream for the horizon in question is lower than expected I need to determine whether to add seed money to the farm, extend the horizon, modify the assumptions in the models, or some combination of the three.

Regularly checking my assumptions and reviewing future possibilities helps me keep my eye on the target.  It allows me to consider whether or not I’m retaining a sufficient margin of safety across my portfolio as I go.  Finally, I don’t aspire to be excessively rich, but would like to run a solid dividend farm, provide for my family, help others when and where I can, and enjoy a modest, comfortable retirement.  Anything beyond that is frosting on the cake.

The thoughts and opinions expressed here are those of the author, who is not a financial professional.  Opinions expressed here should not be considered investment advice.  They are presented for discussion and entertainment purposes only.  For specific investment advice or assistance, please contact a registered investment advisor, licensed broker, or other financial professional.


Monday, January 28, 2019

Dividend Farming Scorecard: General Mills (GIS)


Dividend Farming means reviewing agriculturally related firms once in a while.  General Mills (GIS) is frequently listed in the Consumer Staples group.  However, there aren’t many pure play agricultural firms listed in the CCC.  Consequently, I’m looking at it as providing a small, agricultural lean to my portfolio.  Besides, I’ve often considered General as a potential add to the Dividend Farm so why not take a look now?
General Mills Logo


The table below offers a summary of the criteria I explore within my selection process applied to General Mills on January 25, 2019.  Financial data was sourced from Yahoo.Finance.com.  The dividend history is courtesy of DRiPInvesting.org.

FACTOR
TARGET METRICS
GIS
CCC List
Champion
Contender
Current Yield
4.0%
4.5%
Company Profile
Red Flags
Treasury Stock?
Industry Leadership
Top 10
#10
Market Cap
$10 B+
$25.8 B+
P/E
< 20
12.6
P/B
< 2
3.88
Debt / Equity
< 1
1.2*
Dividend History
25 Years
15
12 Month Price Range
Lower Half
Bottom Third
Dividend Payout Ratio
< 75%
57%
Portfolio Weight
Max of Slightly Over
Under

The first column lists the major factors I review.  The middle column lists benchmarks I’m targeting.  The last column highlights General Mills’ metrics so I can see how well they align with my benchmarks.

CCC List: The list is found on the DRIPinvesting.org web site specified as Champions, Contenders, and Challengers.  GIS is listed as a Contender which is solid if unspectacular.

Current Yield:  GIS’s yield is currently 4.5% which is above my target yield and therefore appealing.

Company Profile:  GIS is involved in nearly all things food from processing to distribution including both standard and organic products.  Brands it markets include Cheerios, Betty Crocker, Bisquick, Fruit Roll-ups, Larabar, and a host of others.  HQ in Minneapolis-St. Paul puts it squarely in agricultural country.

Industry Leadership:  Foodprocessing.com listed GIS as the tenth largest food processing firm in the nation so it squeaks under the wire regarding my leadership benchmark.

Market Capitalization:  The market cap for GIS is 2.5 times my target so it has adequate size.

Price to Earnings:  The P/E of 12.6 is very solid.  Coupled with the yield it looks good thus far.

Price to Book:  P/B lands at 3.88 which is nearly double my target.  That needs additional consideration.  I suspect it means investors are paying for brand recognition versus material value in which case I would have to consider the amount of blue sky I want to purchase.

Debt to Equity:  D/E shows 1.2 with an asterisk.  As with a previous post regarding UnitedTechnologies, the Treasury Stock line item can do a number on the D/E figure.  In this case, the Treasury Stock was stripped out, but if included in the paper calculation, the resulting D/E would put GIS out of contention.

Dividend History:  15 consecutive years of dividends is solid, but unspectacular as stated earlier.

Price Range:  At $43.29 as of 1.25.19, GIS is in the bottom third of its trailing 12-month (TTM) range trending downward.  This improves the yield, which is good, and may represent a buy opportunity, but the book value metric needs strong consideration.

Payout Ratio:  A payout ratio at 57% is well within my range leaving ample room for growth.  The Dividend Growth Rate (DRG) tracked by DRIP Investing is at 4.3%, down from its 10-year mark of 9.8%.

Portfolio Distribution:  GIS would improve my portfolio weight in the agri sector if I allocate it as such.  However, if I leave it as a consumer staples firm where many analysts place it, then it merely adds to an already solid position in that space. 

Analysis: 

GIS’s metrics are not pristine, but not a total bust by any stretch.  As a Dividend Farmer I need to look long and hard at Treasury Stock use and outcomes since it’s shown up in two successive posts.  If I continue to see it as a major factor in other D/E calculations, I’ll need to delve into that item as well as the ways in which different management teams have used (manipulated?) it before pulling the buy trigger.  Otherwise, one other consideration is the quantity of blue sky I’m willing to pay for with a book value approaching 4 to 1.  I’ll keep a watchful eye going forward. 

The thoughts and opinions expressed here are those of the author, who is not a financial professional.  Opinions expressed here should not be considered investment advice.  They are presented for discussion and entertainment purposes only.  For specific investment advice or assistance, please contact a registered investment advisor, licensed broker, or other financial professional.

Saturday, January 26, 2019

Dividend Farming Scorecard: United Technologies (UTX)


As a fan of aerospace ventures, I frequently look for investment opportunities in that sector – assuming they meet my basic criteria.  Because I enjoy things that fly doesn’t mean I’ll buy an interest in a company in that sector if it doesn’t meet my needs.

In an earlier post I looked at General Dynamics (GD) which held promise.  I’ll keep an eye on it, but thought I’d see if there were other possibilities in that sector as well.  As a result, I’m reviewing United Technologies (UTX) which is listed as a Champion in the DRIP Investing CCC list.

United Technologies Logo
UTX: A Dividend Champion

The table below offers a summary of the criteria I explore within my selection process as applied to United Technologies on January 25, 2019.  Financial data was sourced from Yahoo.Finance.com.  The dividend history is courtesy of DRiPInvesting.org.

FACTOR
TARGET METRICS
UTX
CCC List
Champion
Champion
Current Yield
4.0%
2.45%
Company Profile
Red Flags
Treasury Stock?
Industry Leadership
Top 10
#3
Market Cap
$10 B+
$99.9 B+
P/E
< 20
17.8
P/B
< 2
2.5
Debt / Equity
< 1
1.1*
Dividend History
25 Years
25
12 Month Price Range
Lower Half
Top 10%
Dividend Payout Ratio
< 75%
44%
Portfolio Weight
Max of Slightly Over
Under

The first column lists major factors I review.  The middle column includes target benchmarks.  The last column highlights United Technology’s metrics so I can see how well they align with my benchmarks.

CCC List: The list comprises firms found on the DRIPinvesting.org web site specified as Champions, Contenders, and Challengers.  UTX is listed as a Champion so it’s off to a good start.

Current Yield:  UTX’s yield is currently 2.45% which is less than 75% of my target yield.

Company Profile:  UTX is involved in much more than aerospace defense contracting.  It also produces elevators and escalators, climate control and security systems, and space products and systems.

Industry Leadership:  Army-Technology.com listed UTX as the third largest aerospace / defense firm behind only Boeing and Airbus.

Market Capitalization:  UTX’s market cap stands at $99.9 billion which puts it in good stead.

Price to Earnings:  The P/E of 17.8 is within my range, so that’s good.

Price to Book:  P/B is just over my target at 2.5, which by itself doesn’t completely rule it out depending on other metrics.

Debt to Equity:  D/E is just over 1 as well – with an asterisk.  UTX carries over $43 B in company Treasury Stock which, on paper, obliterates all owner’s equity.  And then some.  If the company reissues the stock to generate cash or uses it for acquisitions that add value and reconstitute the negative owner’s equity, that’s not bad.  On the flip side, if all that stock is released back on the market, it will dilute earnings and probably the dividend yield which doesn’t help the Dividend Farming cause.  In any event, the D/E of just over 1 doesn’t consider the Treasury Stock.  If it did, the effect would put D/E so far out of range as to eliminate the stock from contention.  Management’s stewardship will determine whether it gets worked out well or poorly.  In either case, it’s likely outside the Dividend Farmer’s conservative range.

Dividend History:  25 consecutive years of dividends put UTX in with the Champions, which is a plus but the asterisk still looms.

Price Range:  The price range of UTX as of 1.25.19 is within 10% of its trailing 12-month (TTM) high and doesn’t currently appear to be a bargain.  At $115.81 and trending upward, it isn’t doing my dividend yield target any favors.

Payout Ratio:  The payout ratio is 44% falling well below my upper limit.  There’s plenty of room for growth but the Dividend Growth Rate (DRG) tracked by DRIP Investing has tailed off to 3.8% from its 10-year mark of 9%.  Maybe it was conserving cash to buy back its stock but doing so drives up the equity sapping Treasury Stock figure already mentioned.

Portfolio Distribution:  From a portfolio standpoint UTX would represent a significantly underweight position.  One that would be nice to bulk up if the right opportunity presented itself.
 

Analysis: 

For the most part, the metrics and history for UTX are solid.  The equity position effects of the Treasury Stock represent a deal of uncertainty for me.  I may need to study the use of Treasury Stock to a greater degree but I believe that companies can use it to generate great value while others mismanage it destroying value.  I don’t know enough about UTX’s management to offer an opinion on how that will play out.  Consequently, I can exercise due diligence to enlighten myself on the situation or I can deploy that time and effort in the investigation of other firms that may offer less uncertainty.  As much as I like aviation and aerospace, I believe I’ll put the energy to use elsewhere. 

The thoughts and opinions expressed here are those of the author, who is not a financial professional.  Opinions expressed here should not be considered investment advice.  They are presented for discussion and entertainment purposes only.  For specific investment advice or assistance, please contact a registered investment advisor, licensed broker, or other financial professional.


Tuesday, January 15, 2019

Dividend Farming Scorecards: Comparing MSFT, GD, and SO


During the first couple weeks of the new year I’ve had the chance to look at three possible adds to the Dividend Farm: Microsoft (MSFT), General Dynamics (GD), and The Southern Company (SO).  The firms represent technology, aerospace manufacturing, and utilities.  I chose to look at MSFT and GD because they represent segments currently under weight in my portfolio while SO is a company I’ve had my eye on for years.

It’s not uncommon to review multiple possibilities within a short span of time.  Doing so offers me the chance to see how alternatives compare to one another in light of my preferred selection criteria.
Investment review character with magnifying glass.
Analyzing Alternatives Side-by-Side

The following table summarizes my findings for the companies in question.  In keeping with simplified DIY dividend investing, I draw my financial data from Yahoo.Finance.com.  The dividend history and CCC classification is courtesy of DRiPInvesting.org.  Characteristics falling below my targeted selection metrics have been highlighted in yellow for ease of visibility.


FACTOR
TARGET METRICS
MSFT
GD
SO
CCC List
Champion
Contender
Champion
Contender
Current Yield
4.0%
1.7%
2.4%
5.7%
Company Profile
Red Flags
Software, Services, Cloud
Aerospace and Defense
Telco Svcs?
Industry Leadership
Top 10
#1
#4
#9
Market Cap
$10 B+
$789 B+
$42.7 B
$45 B
P/E
< 20
42.3
15.4
18.3
P/B
< 2
9.2
3.6
1.8
Debt / Equity
< 1
2
2.1
6
Dividend History
25 Years
17
27
18
12 Month Price Range
Lower Half
Upper Half
Bottom Quartile
Lower Half
Dividend Payout Ratio
< 75%
69
35.30%
98.3
Portfolio Weight
Slightly Over
Under
Under
Slightly Over
Date

1.11.19
1.6.19
1.2.19


The first two columns include factors I review and their desired target benchmarks.  The following columns include the relevant metrics of the firms in question.

CCC List: All three firms are on the CCC lists from DRIPinvesting.org, which is good, but only GD is considered a champion so it’s off to an early lead.

Current Yield:  Two of three firms offer current yields below my target.  SO is 42% above target so it gained ground on GD and then some!

Company Profile:  From a profile standpoint, none of the companies present anything overly distressing.  However, as noted earlier I find it curious that SO also participates in the telecom segment.

Industry Leadership:  All three firms are among the ten largest in their sector with MSFT standing head and shoulders above the rest.  As a result, the options are evenly stacked at this point.

Market Capitalization:  MSFT’s market cap dwarfs the other two combined by nearly 2 to 1. If that were the only consideration, there would be no question about which to add.

Price to Earnings:  Whatever separation there may have been in terms of size, that separation completely evaporated with P/E.  While GD and SO are comfortably within range, MSFT is well out of bounds.

Price to Book:  P/B is another area in which MSFT falls behind its rivals.  However, GD also finds itself well above target.

Debt to Equity:  D/E is above my target across the board and far afield in terms of SO.  GD is also over by nearly 2:1.  Despite lacking the infrastructure requirements inherent with SO, for instance, MSFT is still fond of more debt than I’d like to see.
    
Dividend History:  The record of consecutive payments for the alternatives is solid.  However, only GD has amassed more than 25 straight years of dividends.  It’s not to say the others won’t eventually, but today there’s only 1 having done so.

Price Range:  GD and SO’s prices are in the bottom half of their TTM range while MSFT is well into the high end.  I suspect this disparity may have as much to do with the segment tag “technology” that MSFT carries, but it’s still a factor in favor of GD and SO.

Payout Ratio:  SO’s payout ratio leaves practically no room for growth while MSFT has some.  GD, however, has ample room to grow its dividend assuming it decides to.  That potential is nice, but potential and actual are related the same way profit and cash are – one’s theory and the other fact.  How badly do I want to buy theory?

Portfolio Distribution:  MSFT might be a nice way to open a technology position if its metrics weren’t so far off the ranch vis my targets.  SO expands my third largest segment a bit and could be a decent add.  GD would do the most to bolster the light end of my portfolio.  The price in the $150 - $160 range coupled with P/E and P/B outside my comfort zone make it tough to punch the buy button now.  If price, P/E, or P/B improve in the short run, GD may suddenly become compelling.  

Analysis:
If you told me today I had to purchase one of the three firms above, I’d likely do so in favor of SO.  Both GD and SO are outside my target metrics in 3 areas while MSFT is off target in 6 of 10.  GD is misses the market for both P/E and debt to equity while SO is outside the boundary only for D/E.  Also, SO’s yield is considerably higher than GD’s.  Although GD has room for growth, it will take a long time for GD’s yield to equal that of SO even with aggressive annual dividend increases.

Fortunately, I don’t have to make the buy decision today.  My research and investigation will continue to see if an alternative better than SO exists.  I suspect it does.  Finding those gems is one of the fun, rewarding aspects of being a Dividend Farmer.  In the meantime, I’ll also keep an eye on GD.  Who knows, it may yet become one of the dividend crops on the farm!

The thoughts and opinions expressed here are those of the author, who is not a financial professional.  Opinions expressed here should not be considered investment advice.  They are presented for discussion and entertainment purposes only.  For specific investment advice or assistance, please contact a registered investment advisor, licensed broker, or other financial professional.