Projected Income Statement: Alphabet Inc.

Forecast Balance Sheet: Alphabet Inc.

Fiscal Period: December 2021 2022 2023 2024 2025 2026 2027 2028
Net Debt 1 -124,832 -99,061 -97,663 -84,774 -80,296 -59,069 -83,699 -87,402
Change - 20.64% 1.41% 13.2% 5.28% 26.44% -41.7% -4.42%
Announcement Date 01/02/22 02/02/23 30/01/24 04/02/25 04/02/26 - - -
1USD in Million
Estimates

Cash Flow Forecast: Alphabet Inc.

Fiscal Period: December 2021 2022 2023 2024 2025 2026 2027 2028
CAPEX 1 24,640 31,485 32,251 52,535 91,447 180,973 186,215 190,504
Change - 27.78% 2.43% 62.89% 74.07% 97.9% 2.9% 2.3%
Free Cash Flow (FCF) 1 67,012 60,010 69,495 72,764 73,266 23,513 49,464 90,704
Change - -10.45% 15.81% 4.7% 0.69% -67.91% 110.36% 83.37%
Announcement Date 01/02/22 02/02/23 30/01/24 04/02/25 04/02/26 - - -
1USD in Million
Estimates

Forecast Financial Ratios: Alphabet Inc.

Fiscal Period: December 2021 2022 2023 2024 2025 2026 2027 2028

Profitability

        
EBITDA Margin (%) 41.35% 38.94% 38.61% 42.99% 43.47% 46.45% 48.52% 50.16%
EBIT Margin (%) 30.55% 26.46% 27.42% 32.11% 32.03% 33.78% 34.2% 34.44%
EBT Margin (%) 35.22% 25.22% 27.89% 34.23% 39.43% 35.24% 35.45% 35.98%
Net margin (%) 29.51% 21.2% 24.01% 28.6% 32.81% 29.7% 29.7% 30.01%
FCF margin (%) 26.01% 21.22% 22.61% 20.79% 18.19% 5.02% 9.18% 14.75%
FCF / Net Income (%) 88.14% 100.06% 94.17% 72.68% 55.43% 16.89% 30.92% 49.17%

Profitability

        
ROA 22.4% 16.55% 19.23% 23.48% 25.28% 20.83% 20.01% 18.53%
ROE 32.07% 23.62% 29.73% 32.91% 35.7% 29% 26.14% 24.03%

Financial Health

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

Capital Intensity

        
CAPEX / Current Assets (%) 9.56% 11.13% 10.49% 15.01% 22.7% 38.62% 34.57% 30.98%
CAPEX / EBITDA (%) 23.13% 28.59% 27.17% 34.91% 52.22% 83.15% 71.25% 61.77%
CAPEX / FCF (%) 36.77% 52.47% 46.41% 72.2% 124.82% 769.66% 376.47% 210.03%

Items per share

        
Cash flow per share 1 6.762 7.121 7.998 10.07 13.47 16.68 20.14 23.6
Change - 5.3% 12.31% 25.87% 33.79% 23.82% 20.75% 17.19%
Dividend per Share 1 - - - 0.6 - 0.8647 0.8936 0.939
Change - - - - - - 3.34% 5.08%
Book Value Per Share 1 19 19.93 22.27 26.62 34.35 43.51 55.27 71.37
Change - 4.91% 11.74% 19.52% 29.04% 26.65% 27.04% 29.12%
EPS 1 5.61 4.56 5.8 8.04 10.81 11.44 13.28 15.21
Change - -18.72% 27.19% 38.62% 34.45% 5.85% 16.05% 14.52%
Nbr of stocks (in thousands) 13,275,280 12,943,000 12,516,000 12,241,000 12,067,000 12,097,000 12,097,000 12,097,000
Announcement Date 01/02/22 02/02/23 30/01/24 04/02/25 04/02/26 - - -
1USD
Estimates
2026 *2027 *
P/E ratio 27.8x 24x
PBR 7.32x 5.76x
EV / Sales 8.1x 7x
Yield 0.27% 0.28%

EPS & Dividend

Y-o-Y evolution of P/E

Year-on-year evolution of the Yield

Trader
Investor
Global
-
Quality
-
ESG MSCI
-
Sell
Consensus
Buy
Mean consensus
BUY
Number of Analysts
65
Last Close Price
318.58USD
Average target price
371.72USD
Spread / Average Target
+16.68%

Quarterly revenue - Rate of surprise