Complete TRIP Stock Valuation Analysis
Comprehensive intrinsic value analysis using 6 different methodologies
TRIP DCF Analysis
TRIP (Tripadvisor, 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 | $1.5B | $1.8B | $1.8B | $2.3B | $2.8B | $3.4B | $4.0B | $4.7B |
| Revenue Growth % | - | 19.8% | 2.6% | 25.0% | 22.5% | 20.3% | 18.2% | 16.4% |
| EBIT | $101.0M | $126.0M | $92.0M | $144.0M | $179.2M | $218.9M | $262.8M | $310.6M |
| EBIT Margin % | 6.8% | 7.0% | 5.0% | 6.3% | 6.4% | 6.5% | 6.6% | 6.7% |
| Tax Rate % | 50.0% | 50.0% | 50.0% | 40.0% | 38.5% | 37.0% | 35.5% | 34.0% |
| NOPAT | $50.5M | $63.0M | $46.0M | $86.4M | $110.2M | $137.9M | $169.5M | $205.0M |
| NOPAT Margin % | 3.4% | 3.5% | 2.5% | 3.8% | 3.9% | 4.1% | 4.2% | 4.4% |
| Capex | $56.0M | $63.0M | $74.0M | $121.1M | $141.0M | $161.1M | $180.9M | $200.1M |
| Capex / Revenue % | 3.8% | 3.5% | 4.0% | 5.3% | 5.0% | 4.8% | 4.5% | 4.3% |
| Depreciation | $97.0M | $87.0M | $85.0M | $122.3M | $149.9M | $180.2M | $213.1M | $248.1M |
| D&A / Revenue % | 6.5% | 4.9% | 4.6% | 5.3% | 5.3% | 5.3% | 5.3% | 5.3% |
| Change in NWC | $154.0M | $-12.0M | $-33.0M | $-18.9M | $-18.5M | $-17.8M | $-16.8M | $-15.7M |
| NWC Change / Revenue % | 10.3% | -0.7% | -1.8% | -0.8% | -0.7% | -0.5% | -0.4% | -0.3% |
| Unlevered FCF | $-62.5M | $99.0M | $90.0M | $106.5M | $137.6M | $174.9M | $218.6M | $268.7M |
| UFCF % Chg. | - | 258.4% | -9.1% | 18.3% | 29.2% | 27.1% | 25.0% | 22.9% |
| FCF / Revenue % | -4.2% | 5.5% | 4.9% | 4.6% | 4.9% | 5.2% | 5.5% | 5.8% |
| Discount Factor | - | - | - | 0.925 | 0.855 | 0.791 | 0.731 | 0.676 |
| Present Value of FCF | - | - | - | $98.5M | $117.7M | $138.3M | $159.8M | $181.7M |
| Sum of PV of UFCF | - | - | - | $98.5M | $216.1M | $354.4M | $514.2M | $695.9M |
WACC Calculation
Weighted Average Cost of Capital used for discounting cash flows.
| WACC Calculation | Value |
|---|---|
| Cost of Debt | 7.4% |
| Tax Rate | 40.0% |
| After Tax Cost of Debt | 4.4% |
| Risk Free Rate | 4.40% |
| Market Risk Premium | 4.3% |
| Beta | 1.33 |
| Cost of Equity | 10.1% |
| Total Debt | $903.0M |
| Market Cap | $1.7B |
| Total Capital | $2.6B |
| Debt Weighting | 35.1% |
| Equity Weighting | 64.9% |
| WACC | 8.1% |
Terminal Value
Choose between perpetuity growth or exit multiple methods.
| Terminal Value Calculation | Value |
|---|---|
| Terminal Growth Rate | 2.5% |
| Final Year FCF | $268.7M |
| Terminal Value | $4.9B |
| PV of Terminal Value | $3.3B |
| Cumulative PV of UFCF | $695.9M |
| Net Debt | $-161.0M |
| Equity Value | $4.2B |
| Shares Outstanding | 145.0M |
| Implied Share Price | $29 |
| Current Share Price | $14 |
| Implied Upside/(Downside) | +102.4% |
Valuation Summary
$28.67
Implied Price
$14.16
Current Price
+102.4%
Upside/Downside
8.1%
WACC
TRIP Peer Valuation Analysis
Relative valuation based on comparable company trading multiples
Peer Valuation Analysis
Fair Value Range Analysis
Based on median multiples from 11 peer companies in Consumer Cyclical
P/E Ratio
$14.53
+2.6%
Peer Median: 19.1x
EV/EBITDA
$16.70
+17.9%
Peer Median: 10.3x
P/S Ratio
$17.36
+22.6%
Peer Median: 1.1x
Interpretation: Each multiple provides a different perspective on fair value. Consider which multiple is most relevant for TRIP's business model and current situation.
Multiple Comparison
| Multiple | TRIP Current | Peer Median | Peer Average | Premium/Discount | Assessment |
|---|---|---|---|---|---|
| P/E Ratio | 18.7x | 19.1x | 37.2x | -2.5% | Fair Value |
| EV/EBITDA | 7.9x | 10.3x | 13.8x | -23.4% | Undervalued |
| P/S Ratio | 0.9x | 1.1x | 2.6x | -18.4% | Fair Value |
Peer Companies
Click any company to view their valuation
| Company | Market Cap | P/E Ratio | EV/EBITDA | P/S Ratio |
|---|---|---|---|---|
| $3.97B | 0.0x | 0.0x | 39.2x | |
| $11.26B | 83.0x | 85.0x | 9.3x | |
| $3.16B | 86.7x | 15.9x | 3.5x | |
| $2.88B | 642.3x | 3.8x | 0.8x | |
| $2.36B | 17.4x | 9.5x | 1.6x | |
| $1.67B | 18.7x | 7.9x | 0.9x | |
| $1.39B | 19.1x | 5.7x | 1.0x | |
| $1.18B | 16.3x | 43.0x | 0.7x | |
| $1.14B | 0.0x | 0.0x | 1.1x | |
| $1.18B | 37.0x | 10.3x | 0.7x | |
| $2107.01B | 19.1x | 14.1x | 5.9x |
TRIP Graham Number
Benjamin Graham's conservative valuation formula for defensive investors
Input Data
| EPS (TTM) | $0.76 | Latest 10-K |
| Book Value per Share | $6.50 | Latest 10-K Balance Sheet |
| Graham Constant | 22.5 | Benjamin Graham's formula |
Graham Number Result
$10.54
Intrinsic Value
$14.16
Current Price
-25.6%
Upside/Downside
Confidence: High
Conservative value investing approach
Calculation Breakdown
Formula:
√(22.5 × EPS × BVPS)
Step 1: Multiply constant by EPS
22.5 × 0.76 = 17.07
Step 2: Multiply by Book Value per Share
17.07 × 6.50 = 111.04
Step 3: Take square root
√111.04 = 10.54
Graham Number Result:
$10.54
TRIP Graham Intrinsic Value
Growth-adjusted intrinsic value with two formula variants
Formula Selection
V = EPS × (8.5 + 2g)
Graham's original P/E shortcut for growth, no interest-rate adjustment
V = [EPS × (8.5 + 2g) × 4.4] / Y
Graham's 1974 refinement: adds rate-environment sensitivity
Active Formula: Base-Growth
0.76 × (8.5 + 2 × 8.0%)
Input Data & Growth Assumptions
Current EPS (TTM)$0.76
Latest 10-K • 2024-12-31T00:00:00
No positive historical growth rates available.
Graham's formula is designed for growing companies. Use the custom input below with a conservative positive growth estimate (5-10%).
Custom
%
Enter a positive growth rate estimate (0-50%)
Graham Intrinsic Value Result
$18.59
Intrinsic Value
$14.16
Current Price
+31.3%
Upside/Downside
Base Formula
Growth: 8.0%
TRIP Peter Lynch Fair Value
Growth-based valuation using PEG ratio analysis for growth stocks
Fair Value Calculation
EPS (TTM)$0.76
Latest 10-K • 2024-12-31T00:00:00
No positive historical growth rates available. Using custom growth rate slider.
10.0%
1%50%
Fair Value Formula: EPS × Growth Rate
$0.76 × 10.0% = $7.59
$7.59
Fair Value
$14.16
Current Price
-46.4%
Upside/Downside
PEG Analysis
18.7x
Current P/E
10.0%
Growth Rate
1.87
PEG Ratio (P/E ÷ Growth Rate)
Overvalued
PEG Ratio Interpretation:
• PEG < 1.0: Undervalued (growth exceeds P/E)
• PEG = 1.0: Fairly valued (ideal Lynch ratio)
• PEG > 1.5: Overvalued (paying premium for growth)
Peter Lynch's Rule:
"The P/E ratio of any company that's fairly priced will equal its growth rate." A stock with 15% growth should trade at a P/E of 15 (PEG = 1.0).
TRIP Earnings Power Value (EPV)
Normalized earnings-based valuation for sustainable earning power assessment
Earnings Normalization
| Earnings Component | Amount ($B) | Description |
|---|---|---|
| Reported Earnings | 0.0 | Base earnings from financial statements |
| Normalized Earnings | 0.0 | Final normalized earning power |
One-time Items: Remove non-recurring gains/losses
Cyclical Adjustment: Normalize for economic cycle position
EPV Result
$0.46
EPV per Share
$14.16
Current Price
-96.7%
Upside/Downside
7.4%
WACC: 7.4% (calculated from market data)
Confidence: High
Normalized earnings approach
EPV Calculation Breakdown
Enterprise Value Calculation
| Normalized Earnings | $0.0B |
| Cost of Capital | 7.4% |
| Enterprise Value | $0.1B |
Per Share Value
| Enterprise Value | $0.1B |
| Shares Outstanding | 0.1B |
| EPV per Share | $0.46 |
WACC Components
| Cost of Equity | 9.2% |
| After-Tax Cost of Debt | 3.5% |
| Equity Weight | 69.5% |
| Debt Weight | 30.5% |
| WACC | 7.4% |