Complete GOOGL Stock Valuation Analysis
Comprehensive intrinsic value analysis using 6 different methodologies
GOOGL DCF Analysis
GOOGL (Alphabet 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 | $282.8B | $307.4B | $350.0B | $399.8B | $451.0B | $502.9B | $555.1B | $606.9B |
Revenue Growth % | - | 8.7% | 13.9% | 14.2% | 12.8% | 11.5% | 10.4% | 9.3% |
EBIT | $74.8B | $84.3B | $112.4B | $114.6B | $129.7B | $145.2B | $160.8B | $176.4B |
EBIT Margin % | 26.5% | 27.4% | 32.1% | 28.7% | 28.8% | 28.9% | 29.0% | 29.1% |
Tax Rate % | 15.9% | 13.9% | 16.4% | 15.7% | 16.7% | 17.6% | 18.5% | 19.4% |
NOPAT | $62.9B | $72.6B | $93.9B | $96.6B | $108.1B | $119.6B | $131.0B | $142.1B |
NOPAT Margin % | 22.2% | 23.6% | 26.8% | 24.2% | 24.0% | 23.8% | 23.6% | 23.4% |
Capex | $31.5B | $32.3B | $52.5B | $46.7B | $50.0B | $53.0B | $55.6B | $57.7B |
Capex / Revenue % | 11.1% | 10.5% | 15.0% | 11.7% | 11.1% | 10.5% | 10.0% | 9.5% |
Depreciation | $15.9B | $11.9B | $15.3B | $18.5B | $20.9B | $23.3B | $25.7B | $28.1B |
D&A / Revenue % | 5.6% | 3.9% | 4.4% | 4.6% | 4.6% | 4.6% | 4.6% | 4.6% |
Change in NWC | $-28.4B | $-5.8B | $-15.1B | $-3.7B | $-3.3B | $-3.0B | $-2.6B | $-2.3B |
NWC Change / Revenue % | -10.0% | -1.9% | -4.3% | -0.9% | -0.7% | -0.6% | -0.5% | -0.4% |
Unlevered FCF | $75.8B | $58.0B | $71.8B | $72.1B | $82.3B | $92.9B | $103.7B | $114.8B |
UFCF % Chg. | - | -23.4% | 23.7% | 0.4% | 14.2% | 12.9% | 11.7% | 10.6% |
FCF / Revenue % | 26.8% | 18.9% | 20.5% | 18.0% | 18.2% | 18.5% | 18.7% | 18.9% |
Discount Factor | - | - | - | 0.919 | 0.845 | 0.776 | 0.714 | 0.656 |
Present Value of FCF | - | - | - | $66.2B | $69.5B | $72.1B | $74.0B | $75.3B |
Sum of PV of UFCF | - | - | - | $66.2B | $135.8B | $207.9B | $281.9B | $357.2B |
Weighted Average Cost of Capital used for discounting cash flows.
WACC Calculation | Value |
---|---|
Cost of Debt | 5.5% |
Tax Rate | 15.7% |
After Tax Cost of Debt | 4.6% |
Risk Free Rate | 4.46% |
Market Risk Premium | 4.3% |
Beta | 1.01 |
Cost of Equity | 8.9% |
Total Debt | $25.5B |
Market Cap | $2032.8B |
Total Capital | $2058.2B |
Debt Weighting | 1.2% |
Equity Weighting | 98.8% |
WACC | 8.8% |
Choose between perpetuity growth or exit multiple methods.
Terminal Value Calculation | Value |
---|---|
Terminal Growth Rate | 2.5% |
Final Year FCF | $114.8B |
Terminal Value | $1867.5B |
PV of Terminal Value | $1225.1B |
Cumulative PV of UFCF | $357.2B |
Net Debt | $2.0B |
Equity Value | $1580.3B |
Shares Outstanding | 12447.0M |
Implied Share Price | $127 |
Current Share Price | $167 |
Implied Upside/(Downside) | -23.9% |
GOOGL Peer Valuation Analysis
Relative valuation based on comparable company trading multiples
Fair Value Range Analysis
Based on median multiples from 9 peer companies in Communication Services
Multiple | GOOGL Current | Peer Median | Peer Average | Premium/Discount | Assessment |
---|---|---|---|---|---|
P/E Ratio | 18.5x | 18.5x | 17.9x | 0.0% | Fair Value |
EV/EBITDA | 13.6x | 13.6x | 14.6x | 0.0% | Fair Value |
P/S Ratio | 5.7x | 6.0x | 7.6x | -5.2% | Fair Value |
Company | Market Cap | P/E Ratio | EV/EBITDA | P/S Ratio |
---|---|---|---|---|
$2032.79B | 18.5x | 13.6x | 5.7x | |
$1680.86B | 26.0x | 19.5x | 9.9x | |
$22.43B | 12.1x | 99.8x | 6.0x | |
$20.48B | 191.0x | 691.3x | 14.1x | |
$14.01B | 0.0x | 0.0x | 2.5x | |
$7.47B | 15.2x | 10.8x | 2.2x | |
$4.83B | 0.0x | 0.0x | 1335.5x | |
$4.60B | 0.0x | 89.1x | 12.7x | |
$3.83B | 0.0x | 0.0x | 37.8x |
GOOGL Graham Number
Benjamin Graham's conservative valuation formula for defensive investors
EPS (TTM) | $9.03 | Latest 10-K |
Book Value per Share | $26.12 | Latest 10-K Balance Sheet |
Graham Constant | 22.5 | Benjamin Graham's formula |
GOOGL Graham Intrinsic Value
Growth-adjusted intrinsic value with two formula variants
GOOGL Peter Lynch Fair Value
Growth-based valuation using PEG ratio analysis for growth stocks
GOOGL Earnings Power Value (EPV)
Normalized earnings-based valuation for sustainable earning power assessment
Earnings Component | Amount ($B) | Description |
---|---|---|
Reported Earnings | 100.1 | Base earnings from financial statements |
Normalized Earnings | 100.1 | Final normalized earning power |
One-time Items: Remove non-recurring gains/losses
Cyclical Adjustment: Normalize for economic cycle position
Enterprise Value Calculation
Normalized Earnings | $100.1B |
Cost of Capital | 9.2% |
Enterprise Value | $1093.8B |
Per Share Value
Enterprise Value | $1093.8B |
Shares Outstanding | 12.4B |
EPV per Share | $87.87 |
WACC Components
Cost of Equity | 9.2% |
After-Tax Cost of Debt | 3.5% |
Equity Weight | 98.8% |
Debt Weight | 1.2% |
WACC | 9.2% |