Fundamental analysisGuru functionsGuru StrategiesScreenersValuation Models

Buffetology-Eps Growth (Guru Screens)

Written by Robin Bisarya
Fri Mar 19 2021
See how MarketXLS helps you take advantage in the markets.
Download Option Templates →
 

What can you expect from this article?

1. A brief about the book itself- Buffetology.
2. Significance of the EPS and P/E ratios.
3. Rationale behind combing both of these ratios.
4. How to find value stocks with EPS growth?
5. Do it the marketXLS way.

Buffetology

Mr. Warren Buffett is the most renowned investor of all time. I doubt there is any finance enthusiast on this planet who has not heard about him or his investing style. His former daughter-in-law, Mary Buffett, wrote a book named “Buffettology,” She thoroughly discussed Buffet’s various investing styles’ basic tenets. EPS Growth is one of the parameters that Mr. Buffett likes to look at while picking stocks.

EPS

EPS stands for earning per share, which means how much a shareholder will make per share if the company decides to distribute all its earnings. EPS indicates a company’s profitability. More the ratio more is the company’s earnings and hence better the financial health of the company. It can be used to compare a company with its peers.

P/E ratio

P/E stands for the price to earnings ratio, which tells the price investors are willing to pay for each dollar in earnings. The primary aspect of this ratio is to find the valuation of a company. In layman’s terms, to find if a company is overpriced or under-priced. When used alone, PE ratio can be misleading. However, a high PE often suggests that a stock is overvalued and vice versa.

How to use it?

The main idea is to value a company based on its past earnings. That being said, PE alone can be misleading while predicting the future price of a stock. Therefore, it makes sense to combine it with a growth parameter, which is the EPS. Let’s see how Mr. Buffett does it.

In this method, Buffett analyses the company’s long-term growth trend to determine how it may perform in the next 10 years. He takes a combination of two metrics – EPS and P/E.

Firstly, He shortlists the stocks whose average earnings growth rate has been more than 15% over the past 5 to 10 years. Then, He takes the EPS growth of the last ten years and projects the next ten years’ growth. Similarly, He determines the average P/E ratio of the last 10 years and multiplies it with the next 10th year EPS to determine the stock price. Finally, He determines the return rate on the stock, taking the current price as entry and estimated price as an exit. If the estimated return rate comes out to be greater than 15%, he only shortlists that stock for investment.

Let’s understand this using an example:

Let’s suppose any company’s EPS is $4.62 and has been growing at an average rate of 17.6% per year. As per the forecast, it will be $23.37 in 10 years from here.
The average growth rate of the Price to Earnings ratio has been 17.7.
Estimated stock price = 23.37 * 17.7 = $413.65
If the stock price right now is $75, the rate of return will be 18.62% annually, which is greater than 15% and fits perfectly with Warren Buffett’s strategy.
We have not considered the dividend yield of a company in this, so even if the company gives 1.5% of the dividend, the overall return rate will be 20%. (18.62 + 1.5%)

Pick stocks using MS excel

Below is an MS excel template that our website provides for the valuation of a company based on EPS growth. You just enter the ticker symbol of the stock you are interested in and the template gives you the future stock price and the growth rate y-o-y. I took MSFT as an example. The current stock price is $237.1 and if everything goes fine the price will increase to about $710 by 2030. However, the growth rate of 12% doesn’t conform to the cut-off set by Buffet, which is 15%. Mr.Buffet will surely not consider this investment but 12% is not that bad either.

Disclaimer

None of the content published on marketxls.com constitutes a recommendation that any particular security, portfolio of securities, transaction, or investment strategy is suitable for any specific person.

The author is not offering any professional advice of any kind. The reader should consult a professional financial advisor to determine their suitability for any strategies discussed herein.

the article is written for helping users collect the required information from various sources deemed to be an authority in their content. The trademarks if any are the property of their owners and no representations are made.

References

Learn more about Guru screens here.

Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
Download Option Templates

Top 100 Gainers Today

Top 100 losers Today

Real gdpReal personal consumption expReal private investmentReal govt expenditureReal net exportsReal exportsReal importsFederal receiptsFederal outlaysFederal surplus or deficitFederal debtReal private investment nonresidentialReal private investment residentialReal potential gdpReal personal incomeReal personal consumption exp monthlyRpce durable goodsRpce nondurable goodsRpce servicesPersonal savings rateMonetary baseCurrency in circulationBank reservesMoney supply m1Money supply m2Sp500DjiaWilshire indexVixFinancial stress indexCorporate bond index aaCorporate bond index bbbFederal funds rateTreasury rate 3mTreasury rate 1yTreasury rate 5yTreasury rate 10yTips 5yTips 10yBond yield aaaBond yield baaMortgage rate 15yMortgage rate 30yUs dollar weighted averageUsdollar to euroUsdollar to poundYuan to usdollarCanadiandollar to usdollarYen to usdollarCpiCpi wo food energyCpi foodCpi energyChain price indexChain price index wo food energyGdp price deflatorPpi final demandPpi finished goodsPpi materialPpi crude goodsPpi final demand wo food energyPpi finished goods wo food energyHouse price indexHouse price index 20cityCrude oil priceGasoline priceNatural gas priceIndustrial productionCapacity utilisationInventoriesSales retail foodVehicle sales light weightManufacture orders durablesManufacture orders capital goodsLoansConsumer credit outstandingCorporate profitsHousing startsBuilding permitsResidential constructionEmployees nonfarmEmployees privateEmployees goods producingEmployees service providingEmployees governmentUnemployment rateInitial cliamsAverage weeks unemployedJob openingsHiresSeparationsQuitsLayoffs dischargesHours of productionHourly earningsReal outputPopulationLabor forceLabor force participation rate
Search for a stock

Top MarketXLS Rank stocks

Sanderson Farms Inc. logo

Sanderson Farms Inc.

218.61
 
USD
 
-1.29
 
(-0.59%)
81
Rank
Optionable: Yes
Market Cap: 4,908 M
Industry: Packaged Foods
52 week range    
175.42   
   221.63
Rush Enterprises Inc. Class B Common Stock logo

Rush Enterprises Inc. Class B Common Stock

49.95
 
USD
 
0.21
 
(0.42%)
81
Rank
Optionable: No
Market Cap: 2,753 M
Industry: Auto & Truck Dealerships
52 week range    
35.64   
   57.55
Gaming and Leisure Properties Inc. logo

Gaming and Leisure Properties Inc.

46.12
 
USD
 
-0.56
 
(-1.20%)
79
Rank
Optionable: Yes
Market Cap: 11,555 M
Industry: REIT - Diversified
52 week range    
40.57   
   48.57
General Mills Inc. logo

General Mills Inc.

74.72
 
USD
 
4.46
 
(6.35%)
79
Rank
Optionable: Yes
Market Cap: 42,311 M
Industry: Packaged Foods
52 week range    
55.38   
   73.99
National Retail Properties logo

National Retail Properties

44.27
 
USD
 
0.11
 
(0.25%)
78
Rank
Optionable: Yes
Market Cap: 7,768 M
Industry: REIT - Retail
52 week range    
39.12   
   48.19
Oppenheimer Holdings Inc. Class A (DE) logo

Oppenheimer Holdings Inc. Class A (DE)

34.31
 
USD
 
-0.91
 
(-2.58%)
77
Rank
Optionable: Yes
Market Cap: 421 M
Industry: Capital Markets
52 week range    
30.71   
   53.17
Kronos Worldwide Inc logo

Kronos Worldwide Inc

18.47
 
USD
 
-0.70
 
(-3.65%)
77
Rank
Optionable: Yes
Market Cap: 2,213 M
Industry: Specialty Chemicals
52 week range    
11.64   
   19.78
Cowen Inc. logo

Cowen Inc.

25.01
 
USD
 
-0.34
 
(-1.34%)
75
Rank
Optionable: Yes
Market Cap: 704 M
Industry: Capital Markets
52 week range    
21.35   
   41.61
BJ's Wholesale Club Holdings Inc. logo

BJ's Wholesale Club Holdings Inc.

62.82
 
USD
 
-0.80
 
(-1.26%)
75
Rank
Optionable: Yes
Market Cap: 8,600 M
Industry: Specialty Retail
52 week range    
45.85   
   74.09
Strategic Education Inc. logo

Strategic Education Inc.

68.03
 
USD
 
-2.49
 
(-3.53%)
74
Rank
Optionable: Yes
Market Cap: 1,760 M
Industry: Education & Training Services
52 week range    
47.09   
   80.29

More Features

Stand with Ukraine

As the situation in Ukraine escalates, many of us in MarketXLS are left with emotions too overwhelming to name. If you’d like to show your support, but aren’t sure how to, we want to help make it easier for you to act.

For any amount donated, we’ll extend your MarketXLS subscription for double of the donated amount. Please send proof of your payment to support@marketxls.com to avail the extention

From all of us at MarketXLS, thank you!