Tag Archives: formula

Explaining The Dugan Stock Scoring System In Detail

Many SA readers have asked me to explain the Dugan stock scoring formula. I do so in this article, in detail. After reading the detailed explanation, please provide comments and suggestions for improvements. Many SA readers have asked me to explain, in detail, the Dugan stock scoring system. I will do so in this article. First, I’ll provide an explanation. The scoring system was borne from my dissatisfaction with using filtering as a primary process to identify high-quality stocks which also met my needs and wants by having specific minimum or maximum performance criteria. Note, there are 2 primary goals when trying to identify stocks to buy: high quality AND meeting my specific needs and wants. Meeting my specific needs and wants is easily determined by filtering for them, such as: Estimated 5-year EPS growth greater than 7% MR, 1-year, 3-year and 5-year dividend increase greater than 7% Payout ratio less than 70% Relative Graham less than 70 Minimum yield of 2.3%. But that filtering doesn’t necessarily cause them to meet the “high quality” part of the goal. Please don’t get me wrong, filtering is a valuable part of the process, and will identify stocks which meet my specific criteria. But, it has 2 weaknesses: one weakness is that a stock I might otherwise prefer from a qualitatively holistic point of view could be filtered out by only a single value. For instance, I like and own Johnson & Johnson (NYSE: JNJ ) and Pfizer (NYSE: PFE ). If I filtered for 10 variables, including a yield greater than 3% and an EPS payout ratio less than 75%, both would not have made the cut because, at the end of July, JNJ’s yield was 2.99% and PFE’s p/o ratio was about 77%. They may have scored very high on all other nine of the 10 variables, and may even have been higher quality, from a balanced and holistic point of view than some stocks which made the cut, but they missed the cut because of only one of ten variables, and then only very slightly. I believe an investor will achieve better results if the investor first identifies companies which do meet some definition of high quality, and only then filters for her/his specific needs and wants. I tried to find a method of first identifying “high quality” stocks, but couldn’t find one. So, I created one that would work with David Fish’s CCC lists. I believe to make it onto the CCC lists is a quality criteria in its own right. So, I’m doubly blessed to have both the CCC lists and my own scoring system as quality filters. Some have pointed out that only using CCC limits me to 700-plus stocks in the selection universe. Since I only need about 40 stocks in my portfolio, 700 plus is big enough, plus, over time, only dealing with 700 allows me to learn and understand deeply about the stocks in the lists. That learning and understanding, I believe, gives me a leg up in expected results and provides the ultimate sleep-well-at-night portfolio. Now, to the main point of answering the question about the specifics of the formula. Here is the formula: =IF(D9> 30,”10″,IF(D9> 20,”8″,IF(D9> 10,”6″,IF(D9> 7,”4″, IF(D9> 5,”2″,0)))))+IF(L9=”n/a”,”0″,IF(L9> 20,”5″,IF(L9> 15,”4″, IF(L9> 10,”3″,IF(L9> 7,”2″,IF(L9> 5,”1″,0))))))+IF(S9> 100,”0″, IF(S9> 90,”1″,IF(S9> 80,”2″,IF(S9> 70,”3″,IF(S9> 60,”4″, IF(S9> 50,”5″,IF(S9> 40,”6″,IF(S9> 30,”7″,IF(S9> 20,”8″, IF(S9> 10,”9″,IF(S9> 0,”10″,0)))))))))))+ IF(AND(T9> =-100,T9 -30,T9 -10,T9 0,T9 15,T9 30,T9 50,T9 70,T9 20,”5″,IF(AB9> 15,”4″,IF(AB9> 10,”3″, IF(AB9> 7,”2″,IF(AB9> 3,”1″,0))))))+IF(AC9=”n/a”,”0″, IF(AC9> =30,”20″,IF(AND(AC9 =0),AC9/1.5,0)))+ IF(AE9=”n/a”,”0″,IF(AE9> 30,”20″, IF(AND(AE9 =0),AE9/1.5,0)))+IF(AF9> 100000,”10″, IF(AF9> 50000,”8″,IF(AF9> 20000,”6″,IF(AF9> 5000,”4″, IF(AF9> 1000,”2″,IF(AF9> 500,”1″,IF(AF9 20,”10″,IF(AL9> 15,”8″,IF(AL9> 10,”6″, IF(AL9> 7,”4″,IF(AL9> 5,”3″,IF(AL9> 3,”2″,0)))))))+ IF(AM9=”n/a”,”0″,IF(AM9> 20,”10″,IF(AM9> 15,”8″,IF(AM9> 10,”6″, IF(AM9> 7,”4″,IF(AM9> 5,”3″,IF(AM9> 3,”2″,0)))))))+ IF(AN9=”n/a”,”0″,IF(AN9> 20,”10″,IF(AN9> 15,”8″,IF(AN9> 10,”6″, IF(AN9> 7,”4″,IF(AN9> 5,”3″,IF(AN9> 3,”2″,0))))))) I’m sure the formula doesn’t mean much. I have summarized the revised formula in the past as: In the table below, I’ll explain the way each sub-category’s score works: I hope this explanation is satisfactory to everyone. I am interested in comments and suggestions. I would remind everyone that with a little experience, anyone can revise and use the formula in the CCC lists to reflect values which better align with their own thoughts and priorities. Happy investing. Additional disclosure: Disclaimer: The opinions in this document are for informational and educational purposes only and should not be construed as a recommendation to buy or sell the stocks mentioned or to solicit transactions or clients. Past performance of the companies discussed may not continue and the companies may not achieve the earnings growth as predicted. The information in this document is believed to be accurate, but under no circumstances should a person act upon the information contained within. We do not recommend that anyone act upon any investment information without first consulting an investment advisor as to the suitability of such investments for his specific situation. (Stolen from Chuck Carnevale).

How To Tell The Difference Between The Graham Formula And The Graham Number

This article will aim to help you as a reader understand the difference between the Graham Formula and the Graham Number. The Graham Formula is the formula which Benjamin Graham provided in his classic book The Intelligent Investor. The Graham Number is a figure used by some investors as an upper limit to how much an investor should pay for a stock. The Graham Number formula was never actually provided by Benjamin Graham. Even though the Graham Number isn’t used in the ModernGraham approach, the figure is now provided with each individual ModernGraham valuation. (click to enlarge) Often I get questions about the Graham Formula versus the Graham Number. There seems to be some misunderstanding out there between the two concepts, and this article will aim to help you as a reader understand the difference between the Graham Formula and the Graham Number. Both figures can be useful in their own ways, and can be combined in the ModernGraham approach. What is the Graham Formula? The Graham Formula is the formula which Benjamin Graham provided in his classic book The Intelligent Investor . Specifically, the formula Graham recommended is: According to Graham, this formula resulted from a study of various valuation methods and is to be considered an effective shorthand way of estimating the intrinsic value of stocks. The formula should result in figures “fairly close to those resulting from the more refined mathematical calculations.” Where does the Graham Formula Come From? Graham placed the Graham Formula in Chapter 11 of The Intelligent Investor , titled “Security Analysis for the Lay Investor: General Approach.” This chapter deals specifically with finding ways to simplify some of the complex mathematical analysis methods which have grown in popularity over the years. After dealing with analyzing bonds and preferred stocks, Graham addresses the issue of valuing stocks, beginning with the sentence “The ideal form of common-stock analysis leads to a valuation of the issue which can be compared with the current price to determine whether or not the security is an attractive purchase.” Graham then went into some detail regarding how many valuation methods utilize future estimates of various figures such as sales, operating margin, etc. in order to then capitalize those figures back to the present in order to determine a value based on the future earnings of the company. However, he then said that “The reader will note that quite a number of the individual forecasts were wide of the mark.” Further, the present value of future earnings is widely dependent on various factors such as: General Long-Term Prospects. Management. Financial Strength and Capital Structure. Dividend Record. Current Dividend Rate. Discussion of each of those factors is beyond the intended scope of this particular article, but together those items constitute items that an analyst must consider when determining an intrinsic value. With all of that in mind, it makes sense that Graham then proceeded to provide the Graham Formula as a way to simplify some of the process for the lay investor. Analysts can spend a lot of time considering each and every little detail about what they think a company is going to do, generating complex mathematical formulas and scenarios in order to determine a value, but Graham’s formula is intended to help the average Intelligent Investor to estimate a value while making as few assumptions about the company as possible. What about the Footnote? Immediately after listing the formula itself, Graham stated that “The growth figure should be that expected over the next seven to ten years.” He also included a footnote on that sentence. The footnote reads: Note that we do not suggest that this formula gives the “true value” of a growth stock, but only that it approximates the results of the more elaborate calculations in vogue.” Some have taken that footnote to mean that the Graham Formula should not be used for estimating an intrinsic value, but I consider the footnote to be more of a reminder from Graham that the calculation of an intrinsic value is not an exact science and cannot be done with 100% certainty. Rather, the investor can only estimate at the intrinsic value due to the vast number of variables involved. Graham provided this formula specifically as a way to approximate the more complex formulas used in an analysis in order to give a “foreshortened and quite simple formula for the valuation of growth stocks, which is intended to produce figures fairly close to those resulting from the more refined mathematical calculations.” Therefore, the Graham Formula is to be used for estimating intrinsic value within a margin of safety which will accommodate the possibility of error in calculation. What is the Graham Number? The Graham Number is a figure used by some investors as an upper limit to how much an investor should pay for a stock. Here’s an example of how some investors use the Graham Number when analyzing dividend aristocrats. The Graham Number is calculated using this formula: According to the Graham Number calculation, the price must be below the square root of the product of 22.5, the Earnings Per Share, and the Book Value Per Share. Where does the Graham Number Come From? The Graham Number formula was never actually provided by Benjamin Graham. Rather, it seems to be engineered out of one of Graham’s recommended requirements for the Defensive Investor. In Chapter 14 of The Intelligent Investor , Graham provided a list of suggested criteria to help the Defensive Investor find quality securities for consideration. Those criteria are as follows: Adequate Size of the Enterprise A Sufficiently Strong Financial Condition Earnings Stability Dividend Record Earnings Growth Moderate Price / Earnings Ratio Moderate Ratio of Price to Assets In the seventh criteria, Moderate Ratio of Price to Assets, Graham says that “Current prices should not be more than 1.5 times the book value last reported. However, a multiplier of earnings below 15 could justify a correspondingly higher multiple of assets. As a rule of thumb we suggest that the product of the multiplier times the ratio of price to book value should not exceed 22.5.” The 22.5 number comes from the product of his suggested maximum price to earnings ratio of 15 and the suggested maximum book value of 1.5. Somewhere along the line, analysts took this suggestion from Graham and extrapolated it into the Graham Number. The Graham Number is Only a Shorthand Version of the Graham Requirements for Defensive Investors. It is my belief that the Graham Number is only a way to easily and quickly screen companies to be used by individual investors not interested in applying all of Graham’s suggested investment techniques. In some ways it seems to be a figure created to simplify Graham’s work into a single recommendation, which to me seems to miss the overall point Graham is trying to make altogether. The Defensive Investor requirements are intended to assist the investor in narrowing down his potential list of investments to only those that are of the highest quality. Graham provided a list of suggested requirements to achieve that purpose, while he specifically provided the Graham Formula as a metric for estimating the intrinsic value of companies. Why would Graham have listed the suggested criteria in an area separately from the formula if he did not intend both items to be used? What Approach Does ModernGraham Use? Here on ModernGraham, I’ve developed our approach to utilize the full breadth of Graham’s recommendations. This is through utilizing both the suggested selection criteria to narrow down the list of potential investments and through the use of the formula to estimate an intrinsic value. Doing this allows the investor to narrow down the focus to a select number of companies and then generate an estimated intrinsic value based on the Graham Formula for comparison to the current price. Each ModernGraham valuation of a company begins with determining whether it is suitable for either the Defensive Investor or the Enterprising Investor, based on a modernized version of Benjamin Graham’s suggested selection criteria for each investor type. Here’s a great post on how you can determine which type of investor you are. After that step is completed, the valuation continues to determining an estimated intrinsic value for the company based on the ModernGraham formula. The ModernGraham formula has been modified slightly from the Graham Formula, only in the sense that it uses a weighted-average of five years of earnings data (EPSmg). The rationale is that Graham suggested using a normalized earnings per share figure in order to smooth out the effects of the business cycle, and also specifically suggested taking an average of earnings per share data when using the figure in analysis. You can learn more about how to estimate a growth rate in this post. Here’s the ModernGraham Formula: This formula is specifically intended to provide only an estimate of the company’s intrinsic value and must be utilized in tandem with a margin of safety because it does not provide an exact figure but only approximates some of the more complicated valuation methods. ModernGraham utilizes multiple layers of safety margins including: Maximum possible estimated growth rate of 15% Estimated growth rate is reduced by 25% To receive a rating of “undervalued” a company must be trading at 75% or less of its intrinsic value. To receive a rating of “overvalued” a company must be trading at 110% or more of its intrinsic value. Each valuation is intended to be a useful source for investors to utilize when conducting research into investment opportunities, and after the first two steps of the ModernGraham analysis, investors are encouraged to continue their research in order to determine if the opportunity is right for their own individual situation. Where Can You Find the Graham Number? Even though the Graham Number isn’t used in the ModernGraham approach, the figure is now provided with each individual ModernGraham valuation. In addition, as of today all new valuations will include a chart showing the Graham Number over time in comparison to the stock price. For those investors who place an emphasis on utilizing the Graham Number, this can be a great tool to see how the strategy has performed over time with respect to the specific company. Disclosure: I/we have no positions in any stocks mentioned, and no plans to initiate any positions within the next 72 hours. (More…) I wrote this article myself, and it expresses my own opinions. I am not receiving compensation for it. I have no business relationship with any company whose stock is mentioned in this article.