Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Guru functionsValuation Models

Ben Graham Formula

Written by admin
Mon Jun 19 2017
Ben Graham Formula - MarketXLS
See how MarketXLS helps you take advantage in the markets.
Download Option Template →
Ben Graham Formula - MarketXLS

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
I agree to the MarketXLS Terms and Conditions
Call: 1-877-778-8358
Ankur Mohan MarketXLS
I am so happy you are here. My name is Ankur and I am the founder/CEO of MarketXLS. Over the past four years, I have helped more than 2500 customers to implement their own investment research strategies and monitoring systems in Excel.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and starter sheets.
Get started today
Search for a stock

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today

Top MarketXLS Rank stocks

Williams-Sonoma Inc. (DE) logo

Williams-Sonoma Inc. (DE)

139.46
 
USD
 
4.52
 
(3.35%)
89
Rank
Optionable: Yes
Market Cap: 8,983 M
Industry: Specialty Retail
52 week range    
101.58   
   176.89
Rush Enterprises Inc. Class A Common Stock logo

Rush Enterprises Inc. Class A Common Stock

55.74
 
USD
 
1.93
 
(3.59%)
88
Rank
Optionable: Yes
Market Cap: 2,929 M
Industry: Auto & Truck Dealerships
52 week range    
42.72   
   56.01
Haverty Furniture Companies Inc. logo

Haverty Furniture Companies Inc.

35.01
 
USD
 
0.09
 
(0.26%)
88
Rank
Optionable: Yes
Market Cap: 564 M
Industry: Home Improvement Stores
52 week range    
22.77   
   35.40
PulteGroup Inc. logo

PulteGroup Inc.

58.44
 
USD
 
1.55
 
(2.72%)
87
Rank
Optionable: Yes
Market Cap: 12,961 M
Industry: Residential Construction
52 week range    
35.03   
   58.65
Toll Brothers Inc. logo

Toll Brothers Inc.

60.26
 
USD
 
0.77
 
(1.29%)
86
Rank
Optionable: Yes
Market Cap: 6,578 M
Industry: Residential Construction
52 week range    
39.53   
   63.19
Weis Markets Inc. logo

Weis Markets Inc.

86.71
 
USD
 
0.37
 
(0.43%)
85
Rank
Optionable: Yes
Market Cap: 2,322 M
Industry: Grocery Stores
52 week range    
58.40   
   95.57
Victory Capital Holdings Inc. logo

Victory Capital Holdings Inc.

30.34
 
USD
 
0.70
 
(2.36%)
85
Rank
Optionable: Yes
Market Cap: 2,030 M
Industry: Asset Management
52 week range    
22.22   
   36.90
Regional Management Corp. logo

Regional Management Corp.

35.98
 
USD
 
1.49
 
(4.32%)
85
Rank
Optionable: Yes
Market Cap: 331 M
Industry: Credit Services
52 week range    
26.52   
   56.95
Penske Automotive Group Inc. logo

Penske Automotive Group Inc.

130.72
 
USD
 
2.90
 
(2.27%)
85
Rank
Optionable: Yes
Market Cap: 9,114 M
Industry: Auto & Truck Dealerships
52 week range    
88.58   
   131.67
El Pollo Loco Holdings Inc. logo

El Pollo Loco Holdings Inc.

12.22
 
USD
 
-0.05
 
(-0.41%)
85
Rank
Optionable: Yes
Market Cap: 455 M
Industry: Restaurants
52 week range    
8.15   
   13.97

More Features