Linked here is a PDF copy of my analysis of Intel Corporation (INTC) (alt.1, alt.2). Below are some highlights from the above linked analysis:
Company Description: Intel Corporation engages in the manufacture and sale of semiconductor chips, as well as in the development of advanced integrated digital technology platforms for the computing and communications industries worldwide.
Fair Value: I consider four calculations of fair value, see page 2 of the linked PDF for a detailed description: 1.) Avg. High Yield Price, 2.) 20-Year DCF Price, 3.) Avg. P/E Price and 4.) Graham Number. INTC is trading at a discount in 2 of the 4 valuations listed above - 1.) Avg. High Yield Price and 3.) Avg. P/E Price. If I exclude the high and low valuation, and average the remaining two valuations, INTC is trading at a 15.5% discount. INTC gets a Star for being fairly valued.
Dividend Analytical Data: In this section I consider five factors, see page 2 of the linked PDF for a detailed description: 1.) Rolling 4-yr Div. > 15%, 2.) Dividend Growth Rate, 3.) Years of Div. Growth, 4.) 1-Yr. > 5-Yr Growth and 5.) Payout 15% of avg. INTC earned 2 of the 4 available Stars in this section - 1.) Rolling 4-yr Div. > 15% and 2.) Dividend Growth Rate. However, two Stars were deducted in this section since it had only grew its dividend for 4 years and it increased its payout percentage by more than 15 basis point (15%) in 2006. This left INTC with a net of zero Stars in this section.
Dividend Income vs. MMA: Why would you assume the equity risk and invest in a dividend stock if you could earn a better return in a much less risky money market account (MMA)? This section compares the earning ability of this stock with a high yield MMA. Two items are considered in this section, see page 2 of the linked PDF for a detailed description: 1.) NPV MMA Diff. and 2.) Years to >MMA. INTC did not earn any Stars in this section. Although its NPV MMA Diff. was positive at $8,049, it was below the $10,000 I like to see.
Other: INTC is a company that I owned the 1990's as a growth investor. During that time, INTC and MSFT started paying a "token" dividend as the price of admission into the Dow Jones Industrial Average. Ironically, at that time, I was not happy with them paying a dividend.
Conclusion: INTC earned one Star in the Fair Value section, a net of zero Stars in the Dividend Analytical Data section, and no Stars in the Dividend Income vs. MMA section for a total of One Star, which rates it as a 1-Star Weak stock.
I do not believe the above analysis adequately tells the true story for INTC. The company's year ends on 12/31/2007, thus the last full year information available is as of 12/31/2006 - more than one year ago. There have been two dividend increases since then. Using my pre-screening model [D4L-PreScreen.xls], I entered the most recent dividend and yield information as shown in this linked PDF file (right click and select "Rotate Clockwise").
Based on the prescreen model, INTC has gone from a "Do not buy" to a "Worthy of additional consideration". So let's give it some more consideration. The first thing you will note is that in 2004 INTC doubled its dividend. It appears there was a conscience decision that year to start acting more like a mature dividend company and less like an aggressive growth company. So how are they doing?
The 15% Calc. Div. Growth is very good. However I don't think it is real or sustainable. Included in that calculation are two years where the dividend doubled (2004 and 2005) and it has steadily decreased since then. It appears to be leveling off around 10%, so let's enter 10% in the Override Div. Gro. field (cell C12). Doing that, moves INTC back to a "Do NOT Buy!". Let's see what type of yield it would take to make INTC a buy. By pressing the [Calculate Breakeven] in cell D8, we learn it would take a yield of 2.68% for INTC to meet our minimum threshold. This equates to a price of $18.66 ($0.50/2.68%).
Alas, Mr. Wolfe was correct - You can't go home again. As much as I would like to hang out with my old buddy INTC, now is not the right time. I'll be keeping tabs on him and hopefully sometime in the future we can reconnect.
Disclaimer: As always this is only my opinion and you should not rely on it. Before buying or selling any stock you should do your own research and reach your own conclusion. See my Disclaimer for more information.
Full Disclosure: At the time of this writing, I do not own any shares of INTC.
What are your thoughts on INTC?
Recent Stock Analyses:
Popular Posts - Last 7 days
Presented below are my dividend stock and ETF/CEF holdings. This is not a recommendation to buy these securities. I have classified some of...
Simple interest is where interest is calculated on the original principal amount and unpaid interest is not added to the principal for futur...
Each Sunday I highlight any notable articles that I came across over the past week, along with any Carnivals I participated in. For those re...
My goals were originally defined in this December 1, 2007 Investing Goals post and last updated in my 2014 Investing Goals . Like last year...
Throughout history there have always been great companies that stand head-and-shoulders above their peers and the competition. They are lov...
Linked here is a detailed quantitative analysis of Cardinal Health, Inc. (CAH). Below are some highlights from the above linked analysis: ...
Linked here is a detailed quantitative analysis of Chevron Corporation (CVX). Below are some highlights from the above linked analysis: C...
Once again it is time for a goals/progress update. I am pleased to report that annualized dividend income increased in November, extending ...
Monday, October 31, 2011 will mark my fourth full year of writing as Dividends4Life . It is hard to believe another year has passed. Like th...
Like many that came before me, I am on a journey to construct a portfolio that will provide me... Dividends 4 Life