Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Logout MarketXLS
Basics

Ben Graham Valuation Model (Excel Template)

Written by Vanshika Kothari
Thu Jul 22 2021
Ben Graham
See how MarketXLS helps you take advantage in the markets.
Download Option Template →
Ben Graham

Ben Graham Valuation model is a simple and straightforward model used by investors to calculate the intrinsic value of a stock using fundamental analysis. It has to be noted that the Ben Graham model is applicable only from a long-term investment perspective.

Intrinsic value of the company is calculated using a company’s factors such as its assets, earnings, and dividend payouts. If the intrinsic value is less than the current market price, the stock is considered to be overvalued. On the contrary, if the intrinsic value is greater than the market price it is considered to be undervalued. 

About Ben Graham and Value Investing 

Ben Graham is widely known to be the ‘father of value investing’ and is the author of the two best-selling books: The Intelligent Investor and Security Analysis with David Dodd. 

His investment philosophy is based on value investing, investor psychology, minimal debt, buy-and-hold investing, fundamental analysis, concentrated diversification, buying within the margin of safety, activist investing, and contrarian mindsets.

Ben Graham Valuation Formula

Ben Graham strongly believed in efficient markets because the point of value investing would be pointless if markets were not efficient, as the fundamental principle of value investments lies in the ability of the markets to eventually correct to their intrinsic values. Common stocks will not remain inflated or bottomed-out forever despite the irrationality of investors in the market. 

Key to Graham’s approach is the margin of safety concept. He believes that due to the irrational behavior of investors and other factors, there is room for human error which results in stocks being undervalued/overvalued.  

The Ben Graham formula is a simple and straightforward formula that investors can use to evaluate a stock’s intrinsic value using fundamental analysis. Please note that it is applicable only for long-term investment.

Valuation Model

MarketXLS Template

MarketXLS provides a template for this valuation model. Enter a Stock Ticker in the cell of this sheet to get the result.

Ben Graham

For the purpose of this blog, we have used Amazon stock, and the template shows whether the stock is undervalued or overvalued and by how much percent.

Ben Graham

For deeper analysis, switch to the Calculation sheet and look at the detailed working of the Ben Graham model.

Find this template here: https://marketxls.com/template/ben-graham-valuation-model/ 

The Bottom Line

Ben Graham offered a very simple formula to calculate the intrinsic value of a growth stock. It can be applied to other sectors and industries, but it works the best using a long-term perspective.

Disclaimer

All trademarks referenced are the property of their respective owners. Other trademarks and trade names may be used in this document to refer to either the entity claiming the marks and names or their products. MarketXLS disclaims any proprietary interest in trademarks and trade names other than its own, or affiliation with the trademark owners.
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.

Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
Download Option Template
Stock screens
Public saved screens

Top 100 Gainers Today

Top 100 losers Today

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

Academy Sports and Outdoors Inc logo

Academy Sports and Outdoors Inc

48.24
 
USD
 
-1.68
 
(-3.37%)
84
Rank
Optionable: Yes
Market Cap: 3,991 M
Industry: Beer, Wine, and Liquor Stores
52 week range    
25.10   
   52.34
Rush Enterprises Inc. Class B Common Stock logo

Rush Enterprises Inc. Class B Common Stock

55.02
 
USD
 
0.88
 
(1.63%)
83
Rank
Optionable: No
Market Cap: 2,827 M
Industry: Auto & Truck Dealerships
52 week range    
44.18   
   60.01
Rush Enterprises Inc. Class A Common Stock logo

Rush Enterprises Inc. Class A Common Stock

53.64
 
USD
 
1.44
 
(2.76%)
82
Rank
Optionable: Yes
Market Cap: 2,751 M
Industry: Auto & Truck Dealerships
52 week range    
42.72   
   60.89
Group 1 Automotive Inc. logo

Group 1 Automotive Inc.

188.93
 
USD
 
-3.23
 
(-1.68%)
81
Rank
Optionable: Yes
Market Cap: 2,791 M
Industry: Auto & Truck Dealerships
52 week range    
136.16   
   211.37
CRA InternationalInc. logo

CRA InternationalInc.

118.47
 
USD
 
-3.42
 
(-2.81%)
81
Rank
Optionable: Yes
Market Cap: 864 M
Industry: Business Services
52 week range    
78.35   
   125.80
Best Buy Co. Inc. logo

Best Buy Co. Inc.

84.32
 
USD
 
-2.28
 
(-2.63%)
81
Rank
Optionable: Yes
Market Cap: 18,947 M
Industry: Specialty Retail
52 week range    
60.79   
   112.96
Utah Medical Products Inc. logo

Utah Medical Products Inc.

101.88
 
USD
 
12.98
 
(14.60%)
80
Rank
Optionable: No
Market Cap: 321 M
Industry: Medical Instruments & Supplies
52 week range    
80.10   
   116.60
SCIENCE APPLICATIONS INTERNATIONAL CORPORATION logo

SCIENCE APPLICATIONS INTERNATIONAL CORPORATION

113.96
 
USD
 
4.70
 
(4.30%)
79
Rank
Optionable: Yes
Market Cap: 6,039 M
Industry: Information Technology Services
52 week range    
78.10   
   117.94
Guess? Inc. logo

Guess? Inc.

20.86
 
USD
 
-0.32
 
(-1.51%)
79
Rank
Optionable: Yes
Market Cap: 1,107 M
Industry: Apparel Stores
52 week range    
14.27   
   25.27
Buckle Inc. (The) logo

Buckle Inc. (The)

44.66
 
USD
 
0.24
 
(0.54%)
79
Rank
Optionable: Yes
Market Cap: 2,232 M
Industry: Apparel Stores
52 week range    
26.50   
   51.55

More Features