Projected Income Statement: Comcast Corporation

Forecast Balance Sheet: Comcast Corporation

Forecast Balance Sheet - Comcast Corporation
Fiscal Period: December 2021 2022 2023 2024 2025 2026 2027 2028
Net Debt 1 91,309 90,062 90,875 91,771 89,456 80,773 76,791 75,730
Change - -1.37% 0.9% 0.99% -2.52% -9.71% -4.93% -1.38%
Announcement Date 27/01/22 26/01/23 25/01/24 30/01/25 29/01/26 - - -
1USD in Million
Estimates

Cash Flow Forecast: Comcast Corporation

Fiscal Period: December 2021 2022 2023 2024 2025 2026 2027 2028
CAPEX 1 9,174 10,626 12,242 12,181 11,750 11,788 11,767 11,799
Change - 15.83% 15.21% -0.5% -3.54% 0.32% -0.17% 0.27%
Free Cash Flow (FCF) 1 17,089 12,646 12,962 12,543 19,235 13,595 13,039 13,362
Change - -26% 2.5% -3.23% 53.35% -29.32% -4.09% 2.48%
Announcement Date 27/01/22 26/01/23 25/01/24 30/01/25 29/01/26 - - -
1USD in Million
Estimates

Forecast Financial Ratios: Comcast Corporation

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

Profitability

        
EBITDA Margin (%) 29.82% 30.03% 30.96% 30.77% 30.22% 27.65% 28.15% 27.76%
EBIT Margin (%) 17.89% 18.63% 19.18% 18.83% 16.71% 14.65% 15.1% 15.32%
EBT Margin (%) 16.41% 7.65% 16.84% 15.09% 20.83% 11.42% 11.91% 11.82%
Net margin (%) 12.17% 4.42% 12.66% 13.09% 16.17% 8.82% 9.07% 9.04%
FCF margin (%) 14.68% 10.41% 10.66% 10.14% 15.55% 11.35% 11.2% 11.21%
FCF / Net Income (%) 120.69% 235.49% 84.23% 77.46% 96.18% 128.67% 123.45% 123.98%

Profitability

        
ROA 5.15% 6.06% 5.89% 6.38% 5.93% 4.36% 4.41% 4.67%
ROE 16.14% 18.24% 20.16% 20.13% 17.51% 12.48% 11.77% 11.85%

Financial Health

        
Leverage (Debt/EBITDA) 2.63x 2.47x 2.41x 2.41x 2.39x 2.44x 2.34x 2.29x
Debt / Free cash flow 5.34x 7.12x 7.01x 7.32x 4.65x 5.94x 5.89x 5.67x

Capital Intensity

        
CAPEX / Current Assets (%) 7.88% 8.75% 10.07% 9.84% 9.5% 9.84% 10.11% 9.89%
CAPEX / EBITDA (%) 26.43% 29.15% 32.53% 32% 31.43% 35.59% 35.9% 35.65%
CAPEX / FCF (%) 53.68% 84.03% 94.45% 97.11% 61.09% 86.71% 90.25% 88.31%

Items per share

        
Cash flow per share 1 6.263 5.962 6.871 7.081 9.071 7.784 7.798 7.789
Change - -4.79% 15.24% 3.06% 28.1% -14.18% 0.17% -0.11%
Dividend per Share 1 1 1.08 1.16 1.24 1.32 1.326 1.389 1.469
Change - 8% 7.41% 6.9% 6.45% 0.49% 4.69% 5.79%
Book Value Per Share 1 20.65 18.27 19.94 21.89 26.89 27.11 29.14 31.34
Change - -11.5% 9.12% 9.81% 22.8% 0.84% 7.48% 7.54%
EPS 1 3.04 1.21 3.71 4.14 5.39 2.942 3.052 3.242
Change - -60.2% 206.61% 11.59% 30.19% -45.41% 3.73% 6.22%
Nbr of stocks (in thousands) 45,68,923 43,23,409 40,25,080 38,26,540 36,43,895 35,51,006 35,51,006 35,51,006
Announcement Date 27/01/22 26/01/23 25/01/24 30/01/25 29/01/26 - - -
1USD
Estimates
2026 *2027 *
P/E 7.33x 7.07x
PBR 0.8x 0.74x
EV / Sales 1.31x 1.32x
Yield 6.15% 6.44%

EPS & Dividend

EPS & Dividend - Comcast Corporation


Y-o-Y evolution of P/E

Valuation ratios - P/E - Comcast Corporation
 

Year-on-year evolution of the Yield

Valuation ratios - Yield - Comcast Corporation
Trader
Investor
Global
Quality
ESG MSCI
-
MarketScreener Ratings - Comcast Corporation
Sell
Consensus
Buy
Mean consensus
HOLD
Number of Analysts
27
Last Close Price
21.57USD
Average target price
27.98USD
Spread / Average Target
+29.70%

Quarterly revenue - Rate of surprise

Rate of surprise - Net sales - Quarterly - Comcast Corporation
  1. Stock Market
  2. Stocks
  3. CMCSA Stock
  4. CMCS34 Stock
  5. Financials Comcast Corporation