Guru functionsValuation Models

Ben Graham Formula

Written by admin
Mon Jun 19 2017
See how MarketXLS helps you take advantage in the markets.
Download Option Templates →
 

Better Investments, Faster Decisions, Better Research

Book your demo

Meet the #1 Excel-based Investment Research Solution for Serious Investors

Benjamin Graham, popularly known as the ‘father of value investing’, provided an elaborate framework to identify undervalued stocks. he proposed this in his books ‘Security Analyst’ and ‘The Intelligent Investor’. He also proposed a simple intrinsic value formula to identify these underpriced stocks, now known as the Ben Graham Formula. In this article we will learn about what Ben Graham formula is and how we can use it to measure a company’s intrinsic value.

Ben Graham Formula

The Ben Graham formula is a simple and straightforward formula that investors can use to evaluate a stock’s intrinsic value. The stock’s intrinsic value is the key idea behind it. The belief is that the stock market doesn’t really reflect the intrinsic value of the company. The intrinsic value itself is an estimate of a company’s value and depends on both tangible and intangible aspects of the company. We calculate intrinsic value using fundamental analysis. With this view, if the stock price is below the intrinsic value by a significant margin, then the investors should invest the stock for long-term to gain excess returns.

The Ben Graham Formula is provided below:

There are four key inputs:

  • Value is the intrinsic value that we are calculating
  • EPS: The trailing 12-month EPS (Earnings per Share). This helps us adjust EPS to a more normalized number
  • 8.5: The constant represents the PE ratio of the company with 0% growth as proposed by Graham. It is reasonable to assume this number to be anywhere between 7 and 8.5.
  • g: the company’s long-term (5-10 years) earnings growth rate
  • 4.4: The minimum required rate of return. The risk-free rate was 4.4% in around 1962, when this model was introduced
  • Y: The current 20-year AAA corporate bond rate

Identifying Under-priced Stocks

Using the Ben Graham Formula, we can calculate Relative Graham Value (RGV) by dividing the stock’s intrinsic value by its stock price. If the RGV is above one, as per theory the stock is undervalued and is a good buy. If the RGV is below 1, then the stock is overvalued and is a good sell.

We should note that many modern investors consider the formula to be too simplistic. Also, they doesn’t reflect our learning in the modern financial theory. However, studies have shown that the approach does work. Just like any other value investing approaches, we should not look at the intrinsic value we calculate using the formula as the absolute fair value of the stock, but rather as an indicator of the value.

The Ben graham Formula also has a drawback that it considers growth rate as an important element. It is important for analyst to exercise care while choosing an appropriate growth rate.

Ben Graham Formula in Excel

We have setup an excel template that we can use to calculate the intrinsic value of a stock using the Ben Graham Formula. The excel template is very flexible and we can extend and customize it to value any stock. You can also make assumptions according to your requirements. The spreadsheet makes use of MarketXLS functions to fetch the various inputs such as EPS, and stock prices.

Better Investments, Faster Decisions, Better Research

Book your demo

Meet the #1 Excel-based Investment Research Solution for Serious Investors

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

Cowen Inc. logo

Cowen Inc.

30.93
 
USD
 
6.89
 
(28.66%)
83
Rank
Optionable: Yes
Market Cap: 859 M
Industry: Capital Markets
52 week range    
21.35   
   41.05
Booz Allen Hamilton Holding Corporation logo

Booz Allen Hamilton Holding Corporation

90.12
 
USD
 
-2.72
 
(-2.93%)
82
Rank
Optionable: Yes
Market Cap: 11,928 M
Industry: Business Services
52 week range    
69.32   
   93.45
Rush Enterprises Inc. Class B Common Stock logo

Rush Enterprises Inc. Class B Common Stock

51.41
 
USD
 
-0.14
 
(-0.27%)
81
Rank
Optionable: No
Market Cap: 2,846 M
Industry: Auto & Truck Dealerships
52 week range    
35.64   
   57.55
Amdocs Limited logo

Amdocs Limited

83.04
 
USD
 
-1.41
 
(-1.67%)
80
Rank
Optionable: Yes
Market Cap: 10,201 M
Industry: Software - Infrastructure
52 week range    
67.36   
   87.76
NBT Bancorp Inc. logo

NBT Bancorp Inc.

38.30
 
USD
 
0.14
 
(0.37%)
79
Rank
Optionable: Yes
Market Cap: 1,640 M
Industry: Banks - Regional - US
52 week range    
31.68   
   41.70
CRA InternationalInc. logo

CRA InternationalInc.

89.64
 
USD
 
0.49
 
(0.55%)
79
Rank
Optionable: Yes
Market Cap: 661 M
Industry: Business Services
52 week range    
78.05   
   115.47
CatchMark Timber Trust Inc. Class A logo

CatchMark Timber Trust Inc. Class A

10.23
 
USD
 
0.01
 
(0.10%)
78
Rank
Optionable: Yes
Market Cap: 504 M
Industry: REIT - Diversified
52 week range    
7.05   
   12.39
America's Car-Mart Inc. logo

America's Car-Mart Inc.

107.19
 
USD
 
5.55
 
(5.46%)
77
Rank
Optionable: Yes
Market Cap: 683 M
Industry: Auto & Truck Dealerships
52 week range    
72.50   
   165.50
ManTech International Corporation logo

ManTech International Corporation

95.66
 
USD
 
0.26
 
(0.27%)
76
Rank
Optionable: Yes
Market Cap: 3,917 M
Industry: Software - Application
52 week range    
66.09   
   95.87
CACI International Inc. Class A logo

CACI International Inc. Class A

279.18
 
USD
 
-8.01
 
(-2.79%)
76
Rank
Optionable: Yes
Market Cap: 6,536 M
Industry: Information Technology Services
52 week range    
238.29   
   313.52

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!