Alphabet Inc.
GOOGL$141.80
+$0.95(++0.67%)
Overview
Trading Stats
Open$140.25
Day Range$139.80 - $142.50
52W Range$102.21 - $153.78
Volume18.2M
Market Cap1.8T
Price History
Financials
P/E Ratio
24.80
P/B Ratio
N/A
P/S Ratio
N/A
ROE
+25.00%
ROA
+10.00%
Profit Margin
+20.00%
Op. Margin
N/A
Gross Margin
N/A
Revenue Growth
+10.00%
Earnings Growth
N/A
D/E Ratio
0.50
Current Ratio
1.50
Profitability Margins
Gross: 0.0%
Operating: 0.0%
Net: 20.0%
Financial Health Score
Higher scores indicate better financial health
Valuation Analysis
Fair Value Estimate
$69.80-50.8% upside
Potentially Overvalued
Based on 1 valuation methods
DCF
$69.80
-50.8%
Alphabet Inc. (GOOGL)
DCF Valuation Analysis
Potentially Overvalued
-50.8% from current price
Intrinsic Value
$69.80
Market Price
$141.80
WACC
+10.00%
Enterprise Value
876.2B
Key Assumptions
Revenue Growth (Y1)
+10.00%
Terminal Growth
+2.50%
Target Op Margin
+15.00%
Beta
1.00
Projected Free Cash Flows
| Year | Revenue | Growth | FCF | PV of FCF |
|---|---|---|---|---|
| Year 1 | 652.7B | +10.00% | 54.4B | 49.5B |
| Year 2 | 709.8B | +8.75% | 59.9B | 49.5B |
| Year 3 | 763B | +7.50% | 65.3B | 49B |
| Year 4 | 810.7B | +6.25% | 70.2B | 48B |
| Year 5 | 851.2B | +5.00% | 74.7B | 46.4B |
| Terminal Value (PV) | +2.50% perpetuity | 633.8B | ||
Enterprise to Equity Value Bridge
Sum of PV (FCF)242.4B
+ PV of Terminal Value633.8B
Enterprise Value876.2B
− Net Debt(0)
Equity Value876.2B
Shares Outstanding12.6B
Intrinsic Value / Share$69.80
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.00% | $83.63 | $89.23 | $95.86 | $103.81 | $113.53 |
| +9.00% | $72.17 | $76.19 | $80.82 | $86.22 | $92.61 |
| +10.00% | $63.42 | $66.41 | $69.80 | $73.67 | $78.13 |
| +11.00% | $56.52 | $58.82 | $61.38 | $64.26 | $67.52 |
| +12.00% | $50.94 | $52.75 | $54.74 | $56.95 | $59.42 |
Understanding This DCF
- Terminal Value represents +72.33% of Enterprise Value — typical for DCF models (60-80%)
- The model uses a +10.00% WACC based on CAPM with beta of 1.00
- 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.