Alphabet Inc.
GOOGL$313.56
+$0.05(++0.02%)
Overview
Trading Stats
Open$311.37
Day Range$310.65 - $314.02
52W Range$140.53 - $328.83
Volume17.8M
Market Cap3.8T
Price History
Financials
P/E Ratio
30.95
P/B Ratio
9.79
P/S Ratio
9.85
ROE
+35.45%
ROA
+16.28%
Profit Margin
+32.23%
Op. Margin
+30.51%
Gross Margin
+59.17%
Revenue Growth
+15.90%
Earnings Growth
+35.30%
D/E Ratio
11.42
Current Ratio
1.75
Profitability Margins
Gross: 59.2%
Operating: 30.5%
Net: 32.2%
Financial Health Score
Higher scores indicate better financial health
Valuation Analysis
Fair Value Estimate
$161.06-48.6% upside
Potentially Overvalued
Based on 3 valuation methods
DCF
$268.21
-14.5%
DDM
$12.36
-96.1%
Relative
$202.60
-35.4%
Alphabet Inc. (GOOGL)
DCF Valuation Analysis
Fairly Valued
-14.5% from current price
Intrinsic Value
$268.21
Market Price
$313.56
WACC
+10.32%
Enterprise Value
1.5T
Key Assumptions
Revenue Growth (Y1)
+15.90%
Terminal Growth
+2.50%
Target Op Margin
+30.51%
Beta
1.07
Projected Free Cash Flows
| Year | Revenue | Growth | FCF | PV of FCF |
|---|---|---|---|---|
| Year 1 | 446.8B | +15.90% | 87.2B | 79B |
| Year 2 | 508.9B | +13.91% | 100.1B | 82.2B |
| Year 3 | 569.6B | +11.92% | 112.9B | 84.1B |
| Year 4 | 626.2B | +9.94% | 125.1B | 84.5B |
| Year 5 | 676B | +7.95% | 136.2B | 83.4B |
| Terminal Value (PV) | +2.50% perpetuity | 1.1T | ||
Enterprise to Equity Value Bridge
Sum of PV (FCF)413.2B
+ PV of Terminal Value1.1T
Enterprise Value1.5T
− Net Debt(54.3B)
Equity Value1.6T
Shares Outstanding5.8B
Intrinsic Value / Share$268.21
Sensitivity Analysis: Intrinsic Value per Share
Values show how intrinsic value changes with different WACC and terminal growth assumptions
| WACC ↓ / Growth → | +1.50% | +2.00% | +2.50% | +3.00% | +3.50% |
|---|---|---|---|---|---|
| +8.32% | $318.17 | $337.92 | $361.05 | $388.54 | $421.74 |
| +9.32% | $277.04 | $291.37 | $307.80 | $326.83 | $349.13 |
| +10.32% | $245.28 | $256.06 | $268.21 | $282.03 | $297.87 |
| +11.32% | $220.04 | $228.37 | $237.65 | $248.05 | $259.77 |
| +12.32% | $199.50 | $206.09 | $213.35 | $221.39 | $230.35 |
Understanding This DCF
- Terminal Value represents +72.57% of Enterprise Value — typical for DCF models (60-80%)
- The model uses a +10.32% WACC based on CAPM with beta of 1.07
- Small changes in assumptions significantly impact value — always use a range, not a single number
Educational Purposes Only. This DCF model uses simplified assumptions and publicly available data. Real valuations require detailed financial analysis, industry expertise, and consideration of many factors not captured here. Never make investment decisions based solely on this analysis.