Intrinsic Value Calculator
Calculate a stock's true worth using DCF (Discounted Cash Flow) and Benjamin Graham's formula
What is Intrinsic Value?
Intrinsic value is what a stock is actually worth based on its fundamentals (earnings, cash flow, growth) — independent of its current market price. If the intrinsic value is higher than the market price, the stock may be undervalued (a potential buy). If it's lower, the stock may be overvalued.
This concept was popularized by Benjamin Graham (the "father of value investing") and his student Warren Buffett.
Enter values above and click Calculate Intrinsic Value to see results
Does this stock pay dividends?
For dividend-paying stocks like JNJ, KO, or PG, use our DDM Calculator for dividend-based valuation.
What is Intrinsic Value?
Intrinsic value is the true or fundamental worth of a stock based on its underlying financial performance, independent of its current market price. The concept was popularized by Benjamin Graham, the father of value investing, and later refined by his student Warren Buffett.
The core principle is simple: a stock is worth the present value of all the cash it will generate for shareholders in the future. If the market price is below intrinsic value, the stock is undervalued and represents a buying opportunity. If it's above, the stock is overvalued.
This calculator offers three valuation methods: the Benjamin Graham Formula (simple and conservative), Simplified DCF (discounted cash flow for intermediate users), and Advanced Multi-Stage DCF (for detailed analysis with multiple growth phases).
Intrinsic Value Formulas
Benjamin Graham Formula
- V = Intrinsic value per share
- EPS = Current earnings per share (TTM)
- 8.5 = Base P/E for a no-growth company
- g = Expected annual growth rate (%)
- 4.4 = Average AAA bond yield when Graham wrote the formula
- Y = Current AAA corporate bond yield (%)
Discounted Cash Flow (DCF)
- FCF = Free cash flow per share
- g = Growth rate during projection period
- r = Discount rate (WACC)
- Terminal Value = FCFₙ × (1+g_terminal) / (r - g_terminal)
- n = Number of projection years
Margin of Safety
Graham and Buffett recommend buying only when margin of safety is 20-30% or higher to protect against estimation errors.
Excel Formulas
| Calculation | Excel Formula |
|---|---|
| Graham Formula | =A1*(8.5+2*B1)*(4.4/C1)A1=EPS, B1=Growth Rate, C1=Bond Yield |
| DCF (5-year) | =NPV(B1,C1:G1)+H1/(1+B1)^5B1=Discount Rate, C1:G1=Projected FCFs, H1=Terminal Value |
| Terminal Value | =A1*(1+B1)/(C1-B1)A1=Final Year FCF, B1=Terminal Growth, C1=Discount Rate |
| Margin of Safety | =(A1-B1)/A1A1=Intrinsic Value, B1=Current Price |
When to Use Each Method
Graham Formula
Best for:
- Stable, profitable companies
- Predictable earnings growth
- Value investing screening
- Quick "back of envelope" valuation
- Beginners learning valuation
DCF Simplified
Best for:
- Cash-generating companies
- Moderate growth businesses
- Steady-state projections
- Comparing multiple stocks
- Intermediate investors
DCF Advanced
Best for:
- High-growth tech companies
- Companies with changing dynamics
- Detailed scenario analysis
- Professional-level valuation
- M&A and investment banking
Frequently Asked Questions
=EPS*(8.5+2*GrowthRate)*(4.4/BondYield). For DCF: Use NPV function: =NPV(DiscountRate, FCF1:FCF5) + TerminalValue/(1+DiscountRate)^5. Terminal Value formula: =LastFCF*(1+TerminalGrowth)/(DiscountRate-TerminalGrowth). Always ensure discount rate exceeds terminal growth rate.