Valuation Models and Methods

45 minintermediate

2. Valuation Models and Methods

Valuation is the process of determining the economic value of an asset or company. In equity valuation, we seek to determine the fair value of a company's stock by analyzing its financial performance, growth prospects, and risk characteristics. Different valuation models use different approaches and assumptions, and understanding when to apply each model is crucial for accurate valuation. This section provides a comprehensive framework for understanding and applying the major valuation methodologies used in equity analysis.

The Three Approaches to Valuation

Valuation methodologies can be broadly categorized into three approaches: the income approach, the market approach, and the asset approach. Each approach has its theoretical foundation, practical applications, and limitations. Professional valuation practice often involves using multiple approaches and triangulating results to arrive at a well-supported valuation conclusion.

Income Approach: Value from Future Cash Flows

The income approach values a company based on the present value of its expected future cash flows. This approach is grounded in the fundamental principle that an asset's value equals the present value of the benefits it will provide to its owner. For equity valuation, these benefits are typically measured as dividends, free cash flows, or earnings available to shareholders.

The income approach is theoretically sound because it directly addresses the question: "What is this investment worth to me based on the cash flows I expect to receive?" This approach is most appropriate when:

  • The company has a history of generating positive cash flows
  • Future cash flows can be reasonably estimated
  • The company's business model is stable and predictable
  • There are sufficient data points to support cash flow projections

The mathematical foundation of the income approach is the present value formula:

V=∑t=1nCFt(1+r)tV = \sum_{t=1}^{n}\frac{CF_t}{(1+r)^t}

Where:

  • VV = Present value (intrinsic value)
  • CFtCF_t = Cash flow in period rr
  • nn = Discount rate (required rate of return)
  • V=Metric×MultipleV = Metric \times Multiple = Number of periods

This formula captures the time value of money - the principle that a dollar received today is worth more than a dollar received in the future because money can be invested to earn returns. The discount rate reflects the opportunity cost of capital and the risk associated with the investment.

Income Approach: A valuation methodology that determines value by discounting expected future cash flows to their present value. The income approach is based on the principle that an asset's value equals the present value of the economic benefits it will provide to its owner.

Market Approach: Value from Comparable Transactions

The market approach values a company by comparing it to similar companies that have been recently sold or are publicly traded. This approach is based on the principle that similar assets should have similar values. The market approach is particularly useful when:

  • There are active markets with comparable companies
  • Market transactions provide reliable pricing signals
  • The company being valued operates in a well-established industry
  • Market multiples are readily available and meaningful

The market approach uses valuation multiples - ratios that relate a company's value to a financial metric. Common multiples include:

  • Price-to-Earnings (P/E): Market value per share ÷ Earnings per share
  • Enterprise Value to EBITDA (EV/EBITDA): Enterprise value ÷ EBITDA
  • Price-to-Book (P/B): Market value per share ÷ Book value per share
  • Price-to-Sales (P/S): Market value per share ÷ Revenue per share

The market approach can be expressed mathematically as:

rr

Where:

  • nn = Estimated value
  • V=Metric×MultipleV = Metric \times Multiple = Financial metric (earnings, sales, book value, etc.)
  • Equity=Assets−LiabilitiesEquity = Assets - Liabilities = Valuation multiple from comparable companies

Market Approach: A valuation methodology that determines value by comparing the subject company to similar companies that have been recently sold or are publicly traded. The market approach uses valuation multiples derived from comparable companies to estimate value.

Asset Approach: Value from Underlying Assets

The asset approach values a company based on the value of its underlying assets, less its liabilities. This approach is most appropriate when:

  • The company's value is primarily derived from its assets rather than its operations
  • The company is being liquidated or restructured
  • Asset values can be reliably determined
  • The company has significant tangible assets

The asset approach can be expressed as:

nn

Where:

  • V=Metric×MultipleV = Metric \times Multiple = Equity value
  • Equity=Assets−LiabilitiesEquity = Assets - Liabilities = Fair market value of assets
  • Equity=AssetsFMV−LiabilitiesFMVEquity = Assets_{FMV} - Liabilities_{FMV} = Fair market value of liabilities

The asset approach has several variations:

  • Book Value: Uses accounting values from the balance sheet
  • Adjusted Book Value: Adjusts book values to reflect fair market values
  • Liquidation Value: Value if assets were sold in an orderly liquidation
  • Replacement Cost: Cost to replace the company's assets

Asset Approach: A valuation methodology that determines value based on the fair market value of a company's assets, less its liabilities. The asset approach is most useful when a company's value is primarily derived from its assets rather than its operations.

Let's visualize how these three approaches compare and when each is most appropriate:

Python exercise

#| label: valuation-approaches-comparison
#| fig-cap: "Comparison of Three Valuation Approaches: Income, Market, and Asset-Based"
#| fig-width: 14
#| fig-height: 10
#| echo: false
#| warning: false

# Sandbox metadata (auto-generated from lesson.ts)
# libraries: numpy, matplotlib

import numpy as np
import matplotlib.pyplot as plt
from IPython.display import display

# Simulate a company valuation using three different approaches
# Company parameters
revenue = 50_000_000  # $50M revenue
ebitda = 10_000_000   # $10M EBITDA
net_income = 6_000_000  # $6M net income
book_value = 40_000_000  # $40M book value
assets_fmv = 60_000_000  # $60M fair market value of assets
liabilities = 20_000_000  # $20M liabilities

# Income approach: DCF
fcf = 8_000_000  # Free cash flow
wacc = 0.10  # 10% WACC
growth = 0.03  # 3% terminal growth
terminal_value = (fcf * (1 + growth)) / (wacc - growth)
dcf_value = (fcf / wacc) + (terminal_value / ((1 + wacc) ** 5))

# Market approach: Comparable multiples
pe_multiple = 15  # P/E multiple from peers
ev_ebitda_multiple = 8  # EV/EBITDA multiple from peers
market_value_pe = net_income * pe_multiple
market_value_ev = (ebitda * ev_ebitda_multiple) - liabilities

# Asset approach
book_value_approach = book_value - liabilities
adjusted_book_value = assets_fmv - liabilities
liquidation_value = assets_fmv * 0.7 - liabilities  # 70% of FMV in liquidation

# Create visualization
fig, axes = plt.subplots(2, 2, figsize=(16, 12))
fig.suptitle('Valuation Approaches Comparison', fontsize=16, fontweight='bold')

# Plot 1: Income Approach Components
ax1 = axes[0, 0]
components = ['PV of FCF\n(5 years)', 'Terminal Value\n(Present)', 'Total DCF Value']
values = [fcf / wacc, terminal_value / ((1 + wacc) ** 5), dcf_value]
colors = ['#2E86AB', '#A23B72', '#F18F01']
bars1 = ax1.bar(components, [v / 1_000_000 for v in values], color=colors, alpha=0.8, edgecolor='black', linewidth=1.5)
ax1.set_ylabel('Value ($ Millions)', fontsize=11, fontweight='bold')
ax1.set_title('Income Approach: DCF Model', fontsize=12, fontweight='bold')
ax1.grid(True, alpha=0.3, axis='y')
for i, (bar, val) in enumerate(zip(bars1, values)):
    height = bar.get_height()
    ax1.text(bar.get_x() + bar.get_width()/2., height,
             f'${val/1_000_000:.1f}M', ha='center', va='bottom', fontweight='bold', fontsize=10)

# Plot 2: Market Approach Multiples
ax2 = axes[0, 1]
multiples = ['P/E Multiple\n(15x)', 'EV/EBITDA\n(8x)']
market_values = [market_value_pe, market_value_ev]
bars2 = ax2.bar(multiples, [v / 1_000_000 for v in market_values], color=['#06A77D', '#D00000'], alpha=0.8, edgecolor='black', linewidth=1.5)
ax2.set_ylabel('Value ($ Millions)', fontsize=11, fontweight='bold')
ax2.set_title('Market Approach: Comparable Multiples', fontsize=12, fontweight='bold')
ax2.grid(True, alpha=0.3, axis='y')
for bar, val in zip(bars2, market_values):
    height = bar.get_height()
    ax2.text(bar.get_x() + bar.get_width()/2., height,
             f'${val/1_000_000:.1f}M', ha='center', va='bottom', fontweight='bold', fontsize=10)

# Plot 3: Asset Approach Methods
ax3 = axes[1, 0]
asset_methods = ['Book Value\n(Adjusted)', 'Adjusted Book\n(FMV Assets)', 'Liquidation\nValue']
asset_values = [book_value_approach, adjusted_book_value, liquidation_value]
bars3 = ax3.bar(asset_methods, [v / 1_000_000 for v in asset_values], color=['#7209B7', '#F72585', '#4CC9F0'], alpha=0.8, edgecolor='black', linewidth=1.5)
ax3.set_ylabel('Value ($ Millions)', fontsize=11, fontweight='bold')
ax3.set_title('Asset Approach: Various Methods', fontsize=12, fontweight='bold')
ax3.grid(True, alpha=0.3, axis='y')
for bar, val in zip(bars3, asset_values):
    height = bar.get_height()
    ax3.text(bar.get_x() + bar.get_width()/2., height,
             f'${val/1_000_000:.1f}M', ha='center', va='bottom', fontweight='bold', fontsize=10)

# Plot 4: Summary Comparison
ax4 = axes[1, 1]
approaches = ['Income\n(DCF)', 'Market\n(P/E)', 'Market\n(EV/EBITDA)', 'Asset\n(Adjusted)', 'Asset\n(Liquidation)']
all_values = [dcf_value, market_value_pe, market_value_ev, adjusted_book_value, liquidation_value]
colors_summary = ['#2E86AB', '#06A77D', '#D00000', '#7209B7', '#4CC9F0']
bars4 = ax4.barh(approaches, [v / 1_000_000 for v in all_values], color=colors_summary, alpha=0.8, edgecolor='black', linewidth=1.5)
ax4.set_xlabel('Value ($ Millions)', fontsize=11, fontweight='bold')
ax4.set_title('Valuation Range: All Approaches', fontsize=12, fontweight='bold')
ax4.grid(True, alpha=0.3, axis='x')
for i, (bar, val) in enumerate(zip(bars4, all_values)):
    width = bar.get_width()
    ax4.text(width, bar.get_y() + bar.get_height()/2.,
             f'${val/1_000_000:.1f}M', ha='left', va='center', fontweight='bold', fontsize=10)

# Add median line
median_value = np.median(all_values)
ax4.axvline(x=median_value / 1_000_000, color='red', linestyle='--', linewidth=2, alpha=0.7, label=f'Median: ${median_value/1_000_000:.1f}M')
ax4.legend(loc='lower right', fontsize=9)

plt.tight_layout()
display(fig)
plt.close()

Income-Based Valuation Models

Discounted Cash Flow (DCF) Models

DCF models are the most theoretically rigorous income-based valuation method. They value a company by discounting its expected future free cash flows to their present value. DCF models require:

  1. Projections: Forecasts of future free cash flows
  2. Terminal Value: The value of cash flows beyond the projection period
  3. Discount Rate: The weighted average cost of capital (WACC)

The basic DCF formula is:

V=Metric×MultipleV = Metric \times Multiple

Where:

  • Equity=Assets−LiabilitiesEquity = Assets - Liabilities = Enterprise value
  • Equity=AssetsFMV−LiabilitiesFMVEquity = Assets_{FMV} - Liabilities_{FMV} = Free cash flow in period V=∑t=1nFCFt(1+WACC)t+TV(1+WACC)nV = \sum_{t=1}^{n}\frac{FCF_t}{(1+WACC)^t} + \frac{TV}{(1+WACC)^n}
  • P0=∑t=1∞Dt(1+r)tP_0 = \sum_{t=1}^{\infty}\frac{D_t}{(1+r)^t} = Weighted average cost of capital
  • P0=D0(1+g)r−gP_0 = \frac{D_0(1+g)}{r-g} = Terminal value
  • P=EPS×P/EP = EPS \times P/E = Number of projection periods

DCF models are powerful because they:

  • Focus on cash generation, not accounting earnings
  • Incorporate the time value of money explicitly
  • Allow for detailed scenario analysis
  • Provide a framework for understanding value drivers

However, DCF models are sensitive to assumptions, particularly:

  • Growth rates in cash flow projections
  • Terminal value assumptions
  • Discount rate estimates
  • Projection period length

Dividend Discount Models (DDM)

DDM values a stock based on the present value of expected future dividends. This model is most appropriate for:

  • Mature companies with stable dividend policies
  • Companies that pay regular dividends
  • Income-focused investors

The basic DDM formula is:

Equity=Assets−LiabilitiesEquity = Assets - Liabilities

Where:

  • Equity=AssetsFMV−LiabilitiesFMVEquity = Assets_{FMV} - Liabilities_{FMV} = Stock price
  • V=∑t=1nFCFt(1+WACC)t+TV(1+WACC)nV = \sum_{t=1}^{n}\frac{FCF_t}{(1+WACC)^t} + \frac{TV}{(1+WACC)^n} = Expected dividend in period P0=∑t=1∞Dt(1+r)tP_0 = \sum_{t=1}^{\infty}\frac{D_t}{(1+r)^t}
  • P0=D0(1+g)r−gP_0 = \frac{D_0(1+g)}{r-g} = Required rate of return

For a company with constant dividend growth, the Gordon Growth Model applies:

Equity=AssetsFMV−LiabilitiesFMVEquity = Assets_{FMV} - Liabilities_{FMV}

Where:

  • V=∑t=1nFCFt(1+WACC)t+TV(1+WACC)nV = \sum_{t=1}^{n}\frac{FCF_t}{(1+WACC)^t} + \frac{TV}{(1+WACC)^n} = Current dividend
  • P0=∑t=1∞Dt(1+r)tP_0 = \sum_{t=1}^{\infty}\frac{D_t}{(1+r)^t} = Growth rate
  • P0=D0(1+g)r−gP_0 = \frac{D_0(1+g)}{r-g} = Required rate of return

DDM has limitations:

  • Many companies don't pay dividends
  • Dividend policy may not reflect value creation
  • Growth rates are difficult to estimate
  • Not suitable for high-growth companies

Earnings-Based Models

Earnings-based models value companies using earnings multiples or capitalized earnings. The most common approach is the Price-to-Earnings (P/E) ratio:

V=∑t=1nFCFt(1+WACC)t+TV(1+WACC)nV = \sum_{t=1}^{n}\frac{FCF_t}{(1+WACC)^t} + \frac{TV}{(1+WACC)^n}

Where:

  • P0=∑t=1∞Dt(1+r)tP_0 = \sum_{t=1}^{\infty}\frac{D_t}{(1+r)^t} = Estimated stock price
  • P0=D0(1+g)r−gP_0 = \frac{D_0(1+g)}{r-g} = Earnings per share
  • P=EPS×P/EP = EPS \times P/E = P/E multiple

Earnings-based models are popular because:

  • Earnings are widely reported and understood
  • P/E ratios are readily available
  • Easy to compare across companies

However, earnings-based models have limitations:

  • Earnings can be manipulated through accounting choices
  • Don't account for capital structure differences
  • May not reflect cash generation ability
  • Earnings quality varies significantly

Let's compare different income-based models:

Python exercise

#| label: income-models-comparison
#| fig-cap: "Comparison of Income-Based Valuation Models: DCF, DDM, and Earnings-Based"
#| fig-width: 14
#| fig-height: 8
#| echo: false
#| warning: false

# Sandbox metadata (auto-generated from lesson.ts)
# libraries: numpy, matplotlib

import numpy as np
import matplotlib.pyplot as plt
from IPython.display import display

# Company parameters
current_dividend = 2.00  # $2.00 per share
dividend_growth = 0.05  # 5% growth
required_return = 0.12  # 12% required return
eps = 4.00  # Earnings per share
pe_ratio = 15  # P/E multiple
fcf = 10_000_000  # Free cash flow
shares = 5_000_000  # Shares outstanding
wacc = 0.10  # WACC

# DDM: Gordon Growth Model
ddm_price = (current_dividend * (1 + dividend_growth)) / (required_return - dividend_growth)

# Earnings-based: P/E model
pe_price = eps * pe_ratio

# DCF: Simplified
dcf_price_per_share = (fcf / shares) / wacc

# Create comparison
fig, axes = plt.subplots(1, 2, figsize=(16, 8))
fig.suptitle('Income-Based Valuation Models Comparison', fontsize=16, fontweight='bold')

# Plot 1: Model Values
ax1 = axes[0]
models = ['DDM\n(Gordon Growth)', 'Earnings\n(P/E Multiple)', 'DCF\n(Simplified)']
prices = [ddm_price, pe_price, dcf_price_per_share]
colors = ['#2E86AB', '#A23B72', '#F18F01']
bars = ax1.bar(models, prices, color=colors, alpha=0.8, edgecolor='black', linewidth=2)
ax1.set_ylabel('Estimated Price per Share ($)', fontsize=12, fontweight='bold')
ax1.set_title('Valuation by Model', fontsize=13, fontweight='bold')
ax1.grid(True, alpha=0.3, axis='y')
for bar, price in zip(bars, prices):
    height = bar.get_height()
    ax1.text(bar.get_x() + bar.get_width()/2., height,
             f'${price:.2f}', ha='center', va='bottom', fontweight='bold', fontsize=11)

# Plot 2: Sensitivity Analysis - Growth Rate Impact on DDM
ax2 = axes[1]
growth_rates = np.linspace(0.01, 0.08, 50)
ddm_prices_sens = [(current_dividend * (1 + g)) / (required_return - g) for g in growth_rates]
ax2.plot(growth_rates * 100, ddm_prices_sens, 'b-', linewidth=2.5, label='DDM Price')
ax2.axhline(y=pe_price, color='r', linestyle='--', linewidth=2, label=f'P/E Model: ${pe_price:.2f}', alpha=0.7)
ax2.axhline(y=dcf_price_per_share, color='g', linestyle='--', linewidth=2, label=f'DCF Model: ${dcf_price_per_share:.2f}', alpha=0.7)
ax2.set_xlabel('Dividend Growth Rate (%)', fontsize=12, fontweight='bold')
ax2.set_ylabel('Estimated Price per Share ($)', fontsize=12, fontweight='bold')
ax2.set_title('DDM Sensitivity to Growth Rate', fontsize=13, fontweight='bold')
ax2.grid(True, alpha=0.3)
ax2.legend(loc='best', fontsize=10)
ax2.set_xlim(1, 8)

plt.tight_layout()
display(fig)
plt.close()

Market-Based Valuation Models

Comparable Company Analysis

Comparable company analysis (also called "comps") values a company by comparing it to similar publicly traded companies. The process involves:

  1. Identify Peer Group: Select companies with similar business models, size, growth, and risk
  2. Calculate Multiples: Compute valuation multiples for each peer
  3. Normalize Multiples: Adjust for differences in accounting, capital structure, or business mix
  4. Apply Multiples: Use peer multiples to estimate the subject company's value

Common multiples used in comparable company analysis:

  • EV/Revenue: Enterprise value ÷ Revenue
  • EV/EBITDA: Enterprise value ÷ EBITDA
  • P/E: Price ÷ Earnings per share
  • P/B: Price ÷ Book value per share
  • PEG: P/E ÷ Growth rate

The value estimate is calculated as:

P0=∑t=1∞Dt(1+r)tP_0 = \sum_{t=1}^{\infty}\frac{D_t}{(1+r)^t}

Where the multiple is typically the median or mean of the peer group, sometimes adjusted for differences in growth, profitability, or risk.

Comparable Company Analysis: A valuation method that estimates value by applying valuation multiples from similar publicly traded companies to the subject company's financial metrics.

Precedent Transaction Analysis

Precedent transaction analysis values a company based on multiples paid in recent acquisitions of similar companies. This approach is useful because:

  • Transaction prices reflect control premiums
  • Provides market evidence of value
  • Reflects strategic value, not just trading value
  • Shows what buyers are willing to pay

The process involves:

  1. Identify Transactions: Find recent M&A transactions in the same industry
  2. Calculate Transaction Multiples: Compute multiples paid in each transaction
  3. Analyze Premiums: Calculate control premiums paid
  4. Apply Multiples: Use transaction multiples to estimate value

Transaction multiples are typically higher than trading multiples because they include:

  • Control Premium: Value of controlling the company
  • Synergy Value: Expected cost savings or revenue enhancements
  • Strategic Value: Value to a specific buyer

The control premium can be calculated as:

P0=D0(1+g)r−gP_0 = \frac{D_0(1+g)}{r-g}

Where:

  • P=EPS×P/EP = EPS \times P/E = Control premium
  • CFtCF_t = Transaction price per share
  • Liquidation Value=∑Assetsliquidation−∑LiabilitiesLiquidation\ Value = \sum Assets_{liquidation} - \sum Liabilities = Market price per share before announcement

Let's visualize how comparable company and precedent transaction analysis work:

Python exercise

#| label: market-valuation-analysis
#| fig-cap: "Market-Based Valuation: Comparable Companies and Precedent Transactions"
#| fig-width: 14
#| fig-height: 10
#| echo: false
#| warning: false

# Sandbox metadata (auto-generated from lesson.ts)
# libraries: numpy, matplotlib

import numpy as np
import matplotlib.pyplot as plt
from IPython.display import display

# Comparable companies data
peer_companies = ['Peer A', 'Peer B', 'Peer C', 'Peer D', 'Peer E']
peer_pe_ratios = [14, 16, 15, 17, 15.5]
peer_ev_ebitda = [7.5, 8.2, 8.0, 8.5, 7.8]

# Subject company
subject_eps = 3.50
subject_ebitda = 12_000_000
subject_shares = 4_000_000
subject_debt = 20_000_000
subject_cash = 5_000_000

# Precedent transactions
transactions = ['Transaction 1', 'Transaction 2', 'Transaction 3']
transaction_premiums = [0.25, 0.30, 0.28]  # 25%, 30%, 28% premiums
transaction_ev_ebitda = [9.0, 9.5, 9.2]

# Calculate valuation ranges
median_pe = np.median(peer_pe_ratios)
median_ev_ebitda = np.median(peer_ev_ebitda)

# Comparable company valuation
comp_pe_value = subject_eps * median_pe * subject_shares
comp_ev_value = (subject_ebitda * median_ev_ebitda) - subject_debt + subject_cash

# Precedent transaction valuation (with control premium)
avg_premium = np.mean(transaction_premiums)
market_price = comp_pe_value / subject_shares
control_premium_value = market_price * (1 + avg_premium) * subject_shares

# Transaction multiple valuation
avg_transaction_multiple = np.mean(transaction_ev_ebitda)
transaction_ev_value = (subject_ebitda * avg_transaction_multiple) - subject_debt + subject_cash

# Create visualization
fig, axes = plt.subplots(2, 2, figsize=(16, 12))
fig.suptitle('Market-Based Valuation Analysis', fontsize=16, fontweight='bold')

# Plot 1: Peer P/E Ratios
ax1 = axes[0, 0]
bars1 = ax1.bar(peer_companies, peer_pe_ratios, color='#2E86AB', alpha=0.8, edgecolor='black', linewidth=1.5)
ax1.axhline(y=median_pe, color='r', linestyle='--', linewidth=2, label=f'Median: {median_pe:.1f}x', alpha=0.7)
ax1.set_ylabel('P/E Ratio', fontsize=11, fontweight='bold')
ax1.set_title('Comparable Companies: P/E Multiples', fontsize=12, fontweight='bold')
ax1.grid(True, alpha=0.3, axis='y')
ax1.legend(loc='best', fontsize=10)
for bar, ratio in zip(bars1, peer_pe_ratios):
    height = bar.get_height()
    ax1.text(bar.get_x() + bar.get_width()/2., height,
             f'{ratio:.1f}x', ha='center', va='bottom', fontweight='bold', fontsize=9)

# Plot 2: Peer EV/EBITDA Ratios
ax2 = axes[0, 1]
bars2 = ax2.bar(peer_companies, peer_ev_ebitda, color='#A23B72', alpha=0.8, edgecolor='black', linewidth=1.5)
ax2.axhline(y=median_ev_ebitda, color='r', linestyle='--', linewidth=2, label=f'Median: {median_ev_ebitda:.1f}x', alpha=0.7)
ax2.set_ylabel('EV/EBITDA Ratio', fontsize=11, fontweight='bold')
ax2.set_title('Comparable Companies: EV/EBITDA Multiples', fontsize=12, fontweight='bold')
ax2.grid(True, alpha=0.3, axis='y')
ax2.legend(loc='best', fontsize=10)
for bar, ratio in zip(bars2, peer_ev_ebitda):
    height = bar.get_height()
    ax2.text(bar.get_x() + bar.get_width()/2., height,
             f'{ratio:.1f}x', ha='center', va='bottom', fontweight='bold', fontsize=9)

# Plot 3: Control Premiums
ax3 = axes[1, 0]
bars3 = ax3.bar(transactions, [p * 100 for p in transaction_premiums], color='#F18F01', alpha=0.8, edgecolor='black', linewidth=1.5)
ax3.axhline(y=avg_premium * 100, color='r', linestyle='--', linewidth=2, label=f'Average: {avg_premium*100:.1f}%', alpha=0.7)
ax3.set_ylabel('Control Premium (%)', fontsize=11, fontweight='bold')
ax3.set_title('Precedent Transactions: Control Premiums', fontsize=12, fontweight='bold')
ax3.grid(True, alpha=0.3, axis='y')
ax3.legend(loc='best', fontsize=10)
for bar, premium in zip(bars3, transaction_premiums):
    height = bar.get_height()
    ax3.text(bar.get_x() + bar.get_width()/2., height,
             f'{premium*100:.1f}%', ha='center', va='bottom', fontweight='bold', fontsize=9)

# Plot 4: Valuation Summary
ax4 = axes[1, 1]
valuation_methods = ['Comp Co.\n(P/E)', 'Comp Co.\n(EV/EBITDA)', 'Precedent\n(w/ Premium)', 'Precedent\n(Transaction Multiple)']
valuations = [comp_pe_value, comp_ev_value, control_premium_value, transaction_ev_value]
colors = ['#2E86AB', '#A23B72', '#F18F01', '#06A77D']
bars4 = ax4.barh(valuation_methods, [v / 1_000_000 for v in valuations], color=colors, alpha=0.8, edgecolor='black', linewidth=1.5)
ax4.set_xlabel('Enterprise Value ($ Millions)', fontsize=11, fontweight='bold')
ax4.set_title('Valuation Range: Market Approaches', fontsize=12, fontweight='bold')
ax4.grid(True, alpha=0.3, axis='x')
for i, (bar, val) in enumerate(zip(bars4, valuations)):
    width = bar.get_width()
    ax4.text(width, bar.get_y() + bar.get_height()/2.,
             f'${val/1_000_000:.1f}M', ha='left', va='center', fontweight='bold', fontsize=10)

# Add median line
median_valuation = np.median(valuations)
ax4.axvline(x=median_valuation / 1_000_000, color='red', linestyle='--', linewidth=2, alpha=0.7, label=f'Median: ${median_valuation/1_000_000:.1f}M')
ax4.legend(loc='lower right', fontsize=9)

plt.tight_layout()
display(fig)
plt.close()

Asset-Based Valuation Models

Book Value Approach

The book value approach uses accounting values from the balance sheet:

P=EPS×P/EP = EPS \times P/E

Book value is simple to calculate but has significant limitations:

  • Accounting values may not reflect economic reality
  • Assets may be undervalued (e.g., real estate, intangibles)
  • Liabilities may be understated (e.g., contingent liabilities)
  • Doesn't reflect going concern value

Adjusted Book Value Approach

Adjusted book value adjusts accounting values to reflect fair market values:

CFtCF_t

Adjustments typically include:

  • Revaluing assets to fair market value
  • Adjusting for off-balance-sheet items
  • Accounting for contingent liabilities
  • Reflecting intangible asset values

Liquidation Value Approach

Liquidation value estimates what assets would fetch in a forced sale:

Liquidation Value=∑Assetsliquidation−∑LiabilitiesLiquidation\ Value = \sum Assets_{liquidation} - \sum Liabilities

Liquidation value is typically lower than going concern value because:

  • Assets must be sold quickly
  • Selling costs reduce proceeds
  • Assets may be worth less outside the business
  • No value for business operations

Model Selection and Application

Choosing the Right Model

The choice of valuation model depends on several factors:

Company Characteristics:

  • Mature, stable companies: DDM, earnings multiples
  • High-growth companies: DCF, revenue multiples
  • Asset-heavy companies: Asset-based approaches
  • Service companies: Earnings or cash flow multiples

Industry Considerations:

  • Financial services: P/B ratios, asset-based
  • Technology: Revenue multiples, DCF
  • Real estate: Asset-based, cash flow multiples
  • Consumer goods: Earnings multiples, DCF

Data Availability:

  • Limited data: Market multiples
  • Rich data: DCF models
  • No cash flows: Asset-based

Purpose of Valuation:

  • M&A: Precedent transactions, DCF
  • IPO: Comparable companies, DCF
  • Fairness opinion: Multiple approaches
  • Tax purposes: Asset-based

Best Practices in Valuation

  1. Use Multiple Approaches: Triangulate value using different methods
  2. Understand Assumptions: Know what drives each model
  3. Sensitivity Analysis: Test how changes in assumptions affect value
  4. Reality Check: Compare results to market prices and transactions
  5. Document Rationale: Explain why certain models were chosen
  6. Consider Context: Adjust for market conditions and company-specific factors

Let's create a comprehensive valuation dashboard that compares multiple approaches:

Python exercise

#| label: comprehensive-valuation-dashboard
#| fig-cap: "Comprehensive Valuation Dashboard: Triangulating Multiple Approaches"
#| fig-width: 16
#| fig-height: 10
#| echo: false
#| warning: false

# Sandbox metadata (auto-generated from lesson.ts)
# libraries: numpy, matplotlib

import numpy as np
import matplotlib.pyplot as plt
from IPython.display import display

# Company parameters
revenue = 50_000_000
ebitda = 10_000_000
net_income = 6_000_000
fcf = 8_000_000
shares = 5_000_000
wacc = 0.10
growth = 0.03

# Multiple valuation approaches
# Income approach
dcf_value = (fcf / wacc) + ((fcf * (1 + growth)) / ((wacc - growth) * (1 + wacc) ** 5))

# Market approach - P/E
pe_multiple = 15
pe_value = (net_income / shares) * pe_multiple * shares

# Market approach - EV/EBITDA
ev_ebitda_multiple = 8
ev_value = (ebitda * ev_ebitda_multiple)

# Asset approach
assets_fmv = 60_000_000
liabilities = 20_000_000
asset_value = assets_fmv - liabilities

# Create comprehensive dashboard
fig = plt.figure(figsize=(16, 10))
gs = fig.add_gridspec(3, 3, hspace=0.3, wspace=0.3)
fig.suptitle('Comprehensive Valuation Dashboard', fontsize=18, fontweight='bold', y=0.98)

# Plot 1: Valuation by Approach
ax1 = fig.add_subplot(gs[0, 0])
approaches = ['DCF', 'P/E\nMultiple', 'EV/EBITDA\nMultiple', 'Asset\nBased']
values = [dcf_value, pe_value, ev_value, asset_value]
colors = ['#2E86AB', '#A23B72', '#F18F01', '#06A77D']
bars1 = ax1.bar(approaches, [v / 1_000_000 for v in values], color=colors, alpha=0.8, edgecolor='black', linewidth=2)
ax1.set_ylabel('Value ($ Millions)', fontsize=11, fontweight='bold')
ax1.set_title('Valuation by Approach', fontsize=12, fontweight='bold')
ax1.grid(True, alpha=0.3, axis='y')
for bar, val in zip(bars1, values):
    height = bar.get_height()
    ax1.text(bar.get_x() + bar.get_width()/2., height,
             f'${val/1_000_000:.1f}M', ha='center', va='bottom', fontweight='bold', fontsize=10)

# Plot 2: Valuation Range
ax2 = fig.add_subplot(gs[0, 1])
min_val = min(values)
max_val = max(values)
median_val = np.median(values)
ax2.barh(['Min', 'Median', 'Max'], 
         [min_val / 1_000_000, median_val / 1_000_000, max_val / 1_000_000],
         color=['#D00000', '#F18F01', '#06A77D'], alpha=0.8, edgecolor='black', linewidth=2)
ax2.set_xlabel('Value ($ Millions)', fontsize=11, fontweight='bold')
ax2.set_title('Valuation Range', fontsize=12, fontweight='bold')
ax2.grid(True, alpha=0.3, axis='x')
for i, val in enumerate([min_val, median_val, max_val]):
    ax2.text(val / 1_000_000, i, f'${val/1_000_000:.1f}M', ha='left', va='center', fontweight='bold', fontsize=10)

# Plot 3: Sensitivity Analysis - WACC
ax3 = fig.add_subplot(gs[0, 2])
wacc_range = np.linspace(0.08, 0.15, 50)
dcf_sensitivity = [(fcf / w) + ((fcf * (1 + growth)) / ((w - growth) * (1 + w) ** 5)) for w in wacc_range]
ax3.plot(wacc_range * 100, [v / 1_000_000 for v in dcf_sensitivity], 'b-', linewidth=2.5)
ax3.axvline(x=wacc * 100, color='r', linestyle='--', linewidth=2, label=f'Base WACC: {wacc*100:.1f}%', alpha=0.7)
ax3.set_xlabel('WACC (%)', fontsize=11, fontweight='bold')
ax3.set_ylabel('DCF Value ($ Millions)', fontsize=11, fontweight='bold')
ax3.set_title('DCF Sensitivity to WACC', fontsize=12, fontweight='bold')
ax3.grid(True, alpha=0.3)
ax3.legend(loc='best', fontsize=9)

# Plot 4: Multiple Comparison
ax4 = fig.add_subplot(gs[1, :])
multiple_types = ['P/E\n(15x)', 'EV/Revenue\n(2x)', 'EV/EBITDA\n(8x)', 'P/B\n(1.5x)', 'P/S\n(1.2x)']
multiple_values = [pe_value, revenue * 2, ev_value, asset_value * 1.5, revenue * 1.2]
bars4 = ax4.bar(multiple_types, [v / 1_000_000 for v in multiple_values], 
                color=['#2E86AB', '#A23B72', '#F18F01', '#06A77D', '#7209B7'], 
                alpha=0.8, edgecolor='black', linewidth=1.5)
ax4.set_ylabel('Value ($ Millions)', fontsize=12, fontweight='bold')
ax4.set_title('Valuation Using Different Multiples', fontsize=13, fontweight='bold')
ax4.grid(True, alpha=0.3, axis='y')
for bar, val in zip(bars4, multiple_values):
    height = bar.get_height()
    ax4.text(bar.get_x() + bar.get_width()/2., height,
             f'${val/1_000_000:.1f}M', ha='center', va='bottom', fontweight='bold', fontsize=10)

# Plot 5: Weighted Average Valuation
ax5 = fig.add_subplot(gs[2, 0])
weights = [0.40, 0.30, 0.20, 0.10]  # DCF, P/E, EV/EBITDA, Asset
weighted_avg = sum(v * w for v, w in zip([dcf_value, pe_value, ev_value, asset_value], weights))
weighted_values = [v * w for v, w in zip([dcf_value, pe_value, ev_value, asset_value], weights)]
bars5 = ax5.bar(approaches, [v / 1_000_000 for v in weighted_values], color=colors, alpha=0.8, edgecolor='black', linewidth=2)
ax5.axhline(y=weighted_avg / 1_000_000, color='r', linestyle='--', linewidth=2, 
            label=f'Weighted Avg: ${weighted_avg/1_000_000:.1f}M', alpha=0.7)
ax5.set_ylabel('Weighted Value ($ Millions)', fontsize=11, fontweight='bold')
ax5.set_title('Weighted Average Valuation', fontsize=12, fontweight='bold')
ax5.grid(True, alpha=0.3, axis='y')
ax5.legend(loc='best', fontsize=9)

# Plot 6: Valuation Distribution
ax6 = fig.add_subplot(gs[2, 1])
all_valuations = [dcf_value, pe_value, ev_value, asset_value] + multiple_values
ax6.hist([v / 1_000_000 for v in all_valuations], bins=15, color='#2E86AB', alpha=0.7, edgecolor='black', linewidth=1.5)
ax6.axvline(x=np.mean(all_valuations) / 1_000_000, color='r', linestyle='--', linewidth=2, 
            label=f'Mean: ${np.mean(all_valuations)/1_000_000:.1f}M', alpha=0.7)
ax6.axvline(x=np.median(all_valuations) / 1_000_000, color='g', linestyle='--', linewidth=2, 
            label=f'Median: ${np.median(all_valuations)/1_000_000:.1f}M', alpha=0.7)
ax6.set_xlabel('Value ($ Millions)', fontsize=11, fontweight='bold')
ax6.set_ylabel('Frequency', fontsize=11, fontweight='bold')
ax6.set_title('Valuation Distribution', fontsize=12, fontweight='bold')
ax6.grid(True, alpha=0.3, axis='y')
ax6.legend(loc='best', fontsize=9)

# Plot 7: Summary Statistics
ax7 = fig.add_subplot(gs[2, 2])
ax7.axis('off')
stats_text = f"""
VALUATION SUMMARY

Approach Values:
  DCF:          ${dcf_value/1_000_000:.1f}M
  P/E Multiple: ${pe_value/1_000_000:.1f}M
  EV/EBITDA:    ${ev_value/1_000_000:.1f}M
  Asset Based:  ${asset_value/1_000_000:.1f}M

Statistics:
  Minimum:      ${min(all_valuations)/1_000_000:.1f}M
  Maximum:      ${max(all_valuations)/1_000_000:.1f}M
  Mean:         ${np.mean(all_valuations)/1_000_000:.1f}M
  Median:       ${np.median(all_valuations)/1_000_000:.1f}M
  Std Dev:      ${np.std(all_valuations)/1_000_000:.1f}M

Weighted Average:
  ${weighted_avg/1_000_000:.1f}M
"""
ax7.text(0.1, 0.5, stats_text, fontsize=10, fontfamily='monospace', 
         verticalalignment='center', fontweight='bold',
         bbox=dict(boxstyle='round', facecolor='wheat', alpha=0.5))

plt.tight_layout()
display(fig)
plt.close()

Valuation Adjustments

Control Premiums and Discounts

Control Premium: Additional value for controlling interest

  • Ability to set strategy
  • Control over cash flows
  • Ability to sell assets
  • Control over management

Minority Discount: Reduction in value for non-controlling interest

  • Lack of control
  • Limited influence on decisions
  • Difficulty in selling

Marketability Discounts

Lack of Marketability Discount: Reduction for illiquid interests

  • Private company shares
  • Restricted stock
  • Limited partnership interests

Typical discounts range from 20-40% depending on:

  • Company size and profitability
  • Dividend policy
  • Transfer restrictions
  • Market conditions

Key Person Discounts

Key Person Discount: Reduction when value depends on specific individuals

  • Founder-dependent companies
  • Single-customer businesses
  • Management-dependent operations

Summary

Valuation is both an art and a science. While mathematical models provide structure, professional judgment is essential in:

  • Selecting appropriate models
  • Making reasonable assumptions
  • Interpreting results
  • Adjusting for company-specific factors

The most robust valuations use multiple approaches and triangulate results. Understanding the theoretical foundations, practical applications, and limitations of each approach enables analysts to develop well-supported valuation conclusions that withstand scrutiny and serve their intended purpose.

Key takeaways:

  1. Three Approaches: Income, market, and asset approaches each have distinct applications
  2. Model Selection: Choose models based on company characteristics, industry, and data availability
  3. Multiple Methods: Use several approaches and triangulate results
  4. Assumptions Matter: Valuation is sensitive to assumptions; document and test them
  5. Professional Judgment: Models provide structure, but judgment is essential

In Module 6: Equity Valuation

  1. Introduction
  2. Fundamental Analysis
  3. Valuation Models and Methods
  4. Discounted Cash Flow Analysis
  5. Relative Valuation Techniques
  6. Valuation in Practice
  7. Special Valuation Cases
  8. Valuation Challenges
  9. Advanced Valuation Topics
  10. End-of-Module Assessment