How to Calculate Stock Intrinsic Value: Step-by-Step Guide

Understanding Stock Intrinsic Value

Determining a stock's intrinsic value is a cornerstone of fundamental analysis, allowing investors to identify whether a stock is overvalued or undervalued relative to its true worth. Unlike market price, which is influenced by supply, demand, and sentiment, intrinsic value represents the underlying value of a company's assets, earnings, and future cash flows. This guide will walk you through calculating intrinsic value using three widely recognized methods: a simplified Discounted Earnings/Cash Flow (DCF) approach, the P/E Ratio method, and Benjamin Graham's Formula.

Prerequisites for Calculation

Before you begin, ensure you have the following key financial inputs:

• Earnings Per Share (EPS): The portion of a company's profit allocated to each outstanding share of common stock.
• Expected Growth Rate (g): The anticipated annual rate at which the company's earnings or dividends are expected to grow over a specific period (e.g., 5-10 years).
• Discount Rate (r) / Required Rate of Return: The rate used to discount future cash flows back to their present value, reflecting the risk and opportunity cost of the investment. This is often your desired rate of return or the Weighted Average Cost of Capital (WACC).
• Perpetual Growth Rate (g_p): The constant rate at which a company's earnings or cash flows are expected to grow indefinitely after the initial high-growth period (typically 2-4%).
• Target P/E Ratio: An appropriate Price-to-Earnings ratio for the company, often based on industry averages, historical P/E, or a subjective assessment of quality.
• AAA Corporate Bond Yield (Y): The current yield on high-grade corporate bonds, used specifically for Graham's formula.

Method 1: Discounted Earnings/Cash Flow (DCF) - Simplified Earnings Model

This method estimates intrinsic value by projecting future earnings and discounting them back to the present. For simplicity and manual calculation, we'll use a two-stage model: an initial period of high growth, followed by a perpetual growth phase.

Formula:

Intrinsic Value = Σ [EPS_n / (1 + r)^n] + [Terminal Value / (1 + r)^T]

Where:

• EPS_n = Projected Earnings Per Share in year 'n'
• r = Discount Rate
• n = Year number
• T = Last year of the initial high-growth phase
• Terminal Value = (EPS_T * (1 + g_p)) / (r - g_p) (using the Gordon Growth Model for terminal earnings)

Method 2: P/E Ratio Method

This straightforward method determines intrinsic value by multiplying a company's current earnings per share by a justified or target P/E ratio.

Formula:

Intrinsic Value = Current EPS × Target P/E Ratio

Method 3: Benjamin Graham's Formula

Benjamin Graham, the father of value investing, developed a formula to estimate a stock's intrinsic value. The revised formula is more commonly used today to account for changing interest rates.

Formula:

Intrinsic Value = (EPS × (8.5 + 2G) × 4.4) / Y

Where:

• EPS = Trailing Twelve Months (TTM) Earnings Per Share
• G = Expected annual earnings growth rate for the next 7-10 years
• 8.5 = P/E ratio of a non-growth company (Graham's base)
• 4.4 = Average yield of high-grade corporate bonds in 1962
• Y = Current yield of AAA corporate bonds

Worked Example: TechCo Inc.

Let's calculate the intrinsic value for a hypothetical company, TechCo Inc., using the following inputs:

• Current EPS: $5.00
• Expected Growth Rate (next 5 years): 15% (g = 0.15)
• Perpetual Growth Rate (after 5 years): 3% (g_p = 0.03)
• Discount Rate (Required Rate of Return): 10% (r = 0.10)
• Target P/E Ratio (for P/E method): 20x
• Current AAA Corporate Bond Yield: 5% (Y = 0.05)

1. DCF (Simplified Earnings Model)

• Projected EPS:

  • Year 1: $5.00 * (1 + 0.15) = $5.75
  • Year 2: $5.75 * (1 + 0.15) = $6.61
  • Year 3: $6.61 * (1 + 0.15) = $7.60
  • Year 4: $7.60 * (1 + 0.15) = $8.74
  • Year 5: $8.74 * (1 + 0.15) = $10.05

• Discounted EPS (Present Value):

  • Year 1: $5.75 / (1 + 0.10)^1 = $5.23
  • Year 2: $6.61 / (1 + 0.10)^2 = $5.46
  • Year 3: $7.60 / (1 + 0.10)^3 = $5.71
  • Year 4: $8.74 / (1 + 0.10)^4 = $5.97
  • Year 5: $10.05 / (1 + 0.10)^5 = $6.24

• Terminal Value (at end of Year 5):

  • EPS for Year 6 = $10.05 * (1 + 0.03) = $10.35
  • Terminal Value = $10.35 / (0.10 - 0.03) = $10.35 / 0.07 = $147.86

• Present Value of Terminal Value:

  • $147.86 / (1 + 0.10)^5 = $147.86 / 1.6105 = $91.81

• Total Intrinsic Value (DCF):

  • Sum of PV of EPS (Years 1-5) + PV of Terminal Value
  • ($5.23 + $5.46 + $5.71 + $5.97 + $6.24) + $91.81 = $28.61 + $91.81 = $120.42

2. P/E Ratio Method

• Intrinsic Value = Current EPS × Target P/E Ratio
• Intrinsic Value = $5.00 × 20 = $100.00

3. Benjamin Graham's Formula

• Intrinsic Value = (EPS × (8.5 + 2G) × 4.4) / Y
• Intrinsic Value = ($5.00 × (8.5 + 2 * 15) × 4.4) / 5
  • Note: For G, use the percentage as a whole number (e.g., 15 for 15%). For Y, use the percentage as a whole number (e.g., 5 for 5%).
• Intrinsic Value = ($5.00 × (8.5 + 30) × 4.4) / 5
• Intrinsic Value = ($5.00 × 38.5 × 4.4) / 5
• Intrinsic Value = $847 / 5 = $169.40

Common Pitfalls to Avoid

• Overly Optimistic Growth Rates: Projecting unrealistic high growth rates can significantly inflate intrinsic value. Be conservative.
• Incorrect Discount Rate: A small change in the discount rate can lead to a large change in intrinsic value. Ensure your required rate of return accurately reflects the risk.
• Reliance on a Single Method: No single method is perfect. Using multiple approaches provides a more robust estimate and helps cross-verify your findings.
• Ignoring Qualitative Factors: Intrinsic value calculations are quantitative. Always consider qualitative aspects like management quality, competitive advantages, and industry trends.
• Sensitivity to Inputs: These models are highly sensitive to their inputs. Understand how changes in EPS, growth, or discount rates impact the final value.

When to Use an Intrinsic Value Calculator

While understanding manual calculation is crucial for comprehension, an intrinsic value calculator offers significant advantages for practical application:

• Speed and Efficiency: Quickly perform complex calculations across multiple scenarios without manual errors.
• Sensitivity Analysis: Easily test how different inputs (e.g., varying growth rates or discount rates) affect the intrinsic value, allowing for robust scenario planning.
• Comparative Analysis: Rapidly compare intrinsic values for several stocks or different valuation methods for the same stock.
• Error Reduction: Minimize human calculation errors, especially with multi-step DCF models.

Using a calculator allows you to focus on the assumptions and interpretation, rather than getting bogged down in arithmetic, making your investment analysis more efficient and reliable.