Complete EXPE Stock Valuation Analysis
Comprehensive intrinsic value analysis using 6 different methodologies
EXPE DCF Analysis
EXPE (Expedia Group, Inc.) discounted cash flow analysis with multiple scenarios, growth assumptions, and terminal value calculations
Financial Projections
Metrics | 2022 (Historical) | 2023 (Historical) | 2024 (Historical) | 2025 (Projected) | 2026 (Projected) | 2027 (Projected) | 2028 (Projected) | 2029 (Projected) |
---|---|---|---|---|---|---|---|---|
Revenue | $11.7B | $12.8B | $13.7B | $16.3B | $19.2B | $22.2B | $25.3B | $28.5B |
Revenue Growth % | - | 10.0% | 6.6% | 19.3% | 17.4% | 15.7% | 14.1% | 12.7% |
EBIT | $864.0M | $1.0B | $1.3B | $1.4B | $1.6B | $1.9B | $2.2B | $2.5B |
EBIT Margin % | 7.4% | 8.0% | 9.6% | 8.4% | 8.5% | 8.6% | 8.7% | 8.8% |
Tax Rate % | 36.2% | 32.4% | 20.6% | 27.9% | 27.6% | 27.3% | 27.0% | 26.7% |
NOPAT | $550.8M | $698.1M | $1.0B | $985.7M | $1.2B | $1.4B | $1.6B | $1.8B |
NOPAT Margin % | 4.7% | 5.4% | 7.6% | 6.0% | 6.1% | 6.2% | 6.3% | 6.4% |
Capex | $662.0M | $846.0M | $756.0M | $1.3B | $1.5B | $1.6B | $1.8B | $1.9B |
Capex / Revenue % | 5.7% | 6.6% | 5.5% | 8.2% | 7.8% | 7.4% | 7.0% | 6.7% |
Depreciation | $792.0M | $807.0M | $838.0M | $1.0B | $1.2B | $1.4B | $1.6B | $1.8B |
D&A / Revenue % | 6.8% | 6.3% | 6.1% | 6.4% | 6.4% | 6.4% | 6.4% | 6.4% |
Change in NWC | $-718.0M | $-566.0M | $-1.2B | $-802.3M | $-753.6M | $-697.4M | $-636.6M | $-573.9M |
NWC Change / Revenue % | -6.2% | -4.4% | -9.1% | -4.9% | -3.9% | -3.1% | -2.5% | -2.0% |
Unlevered FCF | $1.4B | $1.2B | $2.4B | $1.5B | $1.7B | $1.9B | $2.1B | $2.3B |
UFCF % Chg. | - | -12.4% | 93.6% | -37.0% | 11.3% | 11.7% | 11.9% | 12.0% |
FCF / Revenue % | 12.0% | 9.5% | 17.3% | 9.2% | 8.7% | 8.4% | 8.2% | 8.2% |
Discount Factor | - | - | - | 0.912 | 0.832 | 0.758 | 0.691 | 0.630 |
Present Value of FCF | - | - | - | $1.4B | $1.4B | $1.4B | $1.4B | $1.5B |
Sum of PV of UFCF | - | - | - | $1.4B | $2.7B | $4.2B | $5.6B | $7.1B |
Weighted Average Cost of Capital used for discounting cash flows.
WACC Calculation | Value |
---|---|
Cost of Debt | 5.5% |
Tax Rate | 27.9% |
After Tax Cost of Debt | 3.9% |
Risk Free Rate | 4.46% |
Market Risk Premium | 4.3% |
Beta | 1.62 |
Cost of Equity | 11.5% |
Total Debt | $6.5B |
Market Cap | $20.5B |
Total Capital | $27.0B |
Debt Weighting | 24.1% |
Equity Weighting | 75.9% |
WACC | 9.7% |
Choose between perpetuity growth or exit multiple methods.
Terminal Value Calculation | Value |
---|---|
Terminal Growth Rate | 2.5% |
Final Year FCF | $2.3B |
Terminal Value | $33.3B |
PV of Terminal Value | $21.0B |
Cumulative PV of UFCF | $7.1B |
Net Debt | $957.0M |
Equity Value | $27.1B |
Shares Outstanding | 137.9M |
Implied Share Price | $197 |
Current Share Price | $169 |
Implied Upside/(Downside) | +16.5% |
EXPE Peer Valuation Analysis
Relative valuation based on comparable company trading multiples
Fair Value Range Analysis
Based on median multiples from 11 peer companies in Consumer Cyclical
Multiple | EXPE Current | Peer Median | Peer Average | Premium/Discount | Assessment |
---|---|---|---|---|---|
P/E Ratio | 18.6x | 22.7x | 23.7x | -18.2% | Fair Value |
EV/EBITDA | 8.6x | 14.7x | 17.8x | -41.5% | Undervalued |
P/S Ratio | 1.5x | 3.9x | 3.7x | -61.4% | Undervalued |
Company | Market Cap | P/E Ratio | EV/EBITDA | P/S Ratio |
---|---|---|---|---|
$83.25B | 33.1x | 30.8x | 7.4x | |
$72.53B | 29.7x | 21.0x | 2.9x | |
$72.50B | 22.7x | 14.7x | 4.3x | |
$59.74B | 38.9x | 27.6x | 5.3x | |
$31.06B | 15.3x | 9.3x | 1.2x | |
$20.51B | 18.6x | 8.6x | 1.5x | |
$20.56B | 131.5x | 24.4x | 3.9x | |
$12.73B | 16.5x | 14.2x | 1.9x | |
$8.16B | 9.5x | 10.7x | 0.9x | |
$6.43B | 19.7x | 14.2x | 4.5x | |
$178.35B | 33.3x | 20.2x | 7.4x |
EXPE Graham Number
Benjamin Graham's conservative valuation formula for defensive investors
EPS (TTM) | $9.09 | Latest 10-K |
Book Value per Share | $11.29 | Latest 10-K Balance Sheet |
Graham Constant | 22.5 | Benjamin Graham's formula |
EXPE Graham Intrinsic Value
Growth-adjusted intrinsic value with two formula variants
EXPE Peter Lynch Fair Value
Growth-based valuation using PEG ratio analysis for growth stocks
EXPE Earnings Power Value (EPV)
Normalized earnings-based valuation for sustainable earning power assessment
Earnings Component | Amount ($B) | Description |
---|---|---|
Reported Earnings | 1.2 | Base earnings from financial statements |
Normalized Earnings | 1.2 | Final normalized earning power |
One-time Items: Remove non-recurring gains/losses
Cyclical Adjustment: Normalize for economic cycle position
Enterprise Value Calculation
Normalized Earnings | $1.2B |
Cost of Capital | 8.0% |
Enterprise Value | $15.5B |
Per Share Value
Enterprise Value | $15.5B |
Shares Outstanding | 0.1B |
EPV per Share | $112.31 |
WACC Components
Cost of Equity | 9.2% |
After-Tax Cost of Debt | 3.5% |
Equity Weight | 78.1% |
Debt Weight | 21.9% |
WACC | 8.0% |