Projected Income Statement: Alphabet Inc.

Forecast Balance Sheet: Alphabet Inc.

balance-sheet-analysis-chart ALPHABET-INC
Fiscal Period: December 2019 2020 2021 2022 2023 2024 2025 2026
Net Debt 1 -115,121 -122,762 -124,832 -99,061 -97,663 -92,668 -110,397 -143,448
Change - -206.64% -201.69% -179.36% -198.59% -194.89% -219.13% -229.94%
Announcement Date 2/3/20 2/2/21 2/1/22 2/2/23 1/30/24 - - -
1USD in Million
Estimates

Cash Flow Forecast: Alphabet Inc.

Fiscal Period: December 2019 2020 2021 2022 2023 2024 2025 2026
CAPEX 1 23,548 22,281 24,640 31,485 32,251 50,273 54,446 57,781
Change - -5.38% 10.59% 27.78% 2.43% 55.88% 8.3% 6.13%
Free Cash Flow (FCF) 1 30,972 42,843 67,012 60,010 69,495 76,012 91,891 106,416
Change - 38.33% 56.41% -10.45% 15.81% 9.38% 20.89% 15.81%
Announcement Date 2/3/20 2/2/21 2/1/22 2/2/23 1/30/24 - - -
1USD in Million
Estimates

Forecast Financial Ratios: Alphabet Inc.

Fiscal Period: December 2019 2020 2021 2022 2023 2024 2025 2026

Profitability

        
EBITDA Margin (%) 36.14% 37.21% 41.35% 38.94% 38.61% 42.3% 43.57% 44.54%
EBIT Margin (%) 21.15% 22.59% 30.55% 26.46% 27.42% 31.3% 32.05% 32.63%
EBT Margin (%) 24.48% 26.34% 35.22% 25.22% 27.89% 32.48% 32.82% 33.38%
Net margin (%) 21.22% 22.06% 29.51% 21.2% 24.01% 27.44% 27.65% 28.15%
FCF margin (%) 19.14% 23.47% 26.01% 21.22% 22.61% 21.89% 23.75% 24.78%
FCF / Net Income (%) 90.18% 106.39% 88.14% 100.06% 94.17% 79.75% 85.89% 88.03%

Profitability

        
ROA 14.39% 13.52% 22.4% 16.55% 19.23% 21.8% 21.37% 20.66%
ROE 19.31% 19% 32.07% 23.62% 29.73% 29.87% 28.15% 26.05%

Financial Health

        
Leverage (Debt/EBITDA) - - - - - - - -
Debt / Free cash flow - - - - - - - -

Capital Intensity

        
CAPEX / Current Assets (%) 14.55% 12.21% 9.56% 11.13% 10.49% 14.47% 14.07% 13.45%
CAPEX / EBITDA (%) 40.25% 32.81% 23.13% 28.59% 27.17% 34.22% 32.3% 30.2%
CAPEX / FCF (%) 76.03% 52.01% 36.77% 52.47% 46.41% 66.14% 59.25% 54.3%

Items per share

        
Cash flow per share 1 3.902 4.74 6.762 7.121 7.998 10.57 11.86 13.32
Change - 21.45% 42.68% 5.3% 12.31% 32.13% 12.21% 12.37%
Dividend per Share 1 - - - - - 0.6002 0.8125 0.895
Change - - - - - - 35.37% 10.15%
Book Value Per Share 1 14.63 16.48 19 19.93 22.27 26.1 30.96 36.25
Change - 12.62% 15.31% 4.91% 11.74% 17.18% 18.62% 17.09%
EPS 1 2.458 2.93 5.61 4.56 5.8 7.653 8.706 10.06
Change - 19.22% 91.43% -18.72% 27.19% 31.94% 13.76% 15.58%
Nbr of stocks (in thousands) 13,793,749 13,528,525 13,275,280 12,943,000 12,516,000 12,310,000 12,310,000 12,310,000
Announcement Date 2/3/20 2/2/21 2/1/22 2/2/23 1/30/24 - - -
1USD
Estimates
2024 *2025 *
P/E ratio 21.3x 18.8x
PBR 6.25x 5.27x
EV / Sales 5.54x 4.93x
Yield 0.37% 0.5%
More valuation ratios * Estimated data

EPS & Dividend

eps-dividend-chart ALPHABET-INC

Year-on-year evolution of the PER

evolution-chart ALPHABET-INC

Year-on-year evolution of the Yield

evolution-chart ALPHABET-INC
Trading Rating
Investor Rating
ESG Refinitiv
C+
surperformance-ratings-light-chart ALPHABET-INCMore Ratings
Sell
Consensus
Buy
Mean consensus
BUY
Number of Analysts
64
Last Close Price
163.24USD
Average target price
201.77USD
Spread / Average Target
+23.61%
Consensus
  1. Stock Market
  2. Equities
  3. GOOGL Stock
  4. Financials Alphabet Inc.