Projected Income Statement: Crown Castle Inc.

Forecast Balance Sheet: Crown Castle Inc.

Fiscal Period: December 2020 2021 2022 2023 2024 2025 2026 2027
Net Debt 1 19,048 20,337 21,573 22,816 23,962 24,797 18,728 19,402
Change - 6.77% 6.08% 5.76% 5.02% 3.48% -24.47% 3.6%
Announcement Date 1/27/21 1/26/22 1/25/23 1/24/24 3/13/25 - - -
1USD in Million
Estimates

Cash Flow Forecast: Crown Castle Inc.

Fiscal Period: December 2020 2021 2022 2023 2024 2025 2026 2027
CAPEX 1 1,624 1,229 1,310 1,424 1,222 210.8 219.5 228.1
Change - -24.32% 6.59% 8.7% -14.19% -82.75% 4.12% 3.92%
Free Cash Flow (FCF) 1 1,431 1,560 1,568 1,702 1,721 1,942 2,334 3,289
Change - 9.01% 0.51% 8.55% 1.12% 12.86% 20.17% 40.91%
Announcement Date 1/27/21 1/26/22 1/25/23 1/24/24 3/13/25 - - -
1USD in Million
Estimates

Forecast Financial Ratios: Crown Castle Inc.

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

Profitability

        
EBITDA Margin (%) 63.46% 60.19% 62.12% 63.24% 63.35% 66.53% 68.23% 69.59%
EBIT Margin (%) 31.9% 31.56% 34.71% 33.93% -44.73% 46.68% 49.99% 53.01%
EBT Margin (%) 18.42% 18.6% 24.21% 21.89% -59.06% 23.48% 30.65% 34.9%
Net margin (%) 17.11% 17.29% 23.98% 21.52% -59.42% 5.7% 28.14% 31.16%
FCF margin (%) 24.5% 24.61% 22.44% 24.38% 26.2% 46.05% 53.72% 73.83%
FCF / Net Income (%) 143.24% 142.34% 93.61% 113.32% -44.09% 807.27% 190.88% 236.92%

Profitability

        
ROA 2.59% 2.82% 4.3% 3.88% -10.95% 0.97% 4.91% 6.18%
ROE 10.02% 12.37% 21.33% 21.72% -124.94% - - -

Financial Health

        
Leverage (Debt/EBITDA) 5.14x 5.33x 4.97x 5.17x 5.76x 8.84x 6.32x 6.26x
Debt / Free cash flow 13.31x 13.04x 13.76x 13.41x 13.92x 12.77x 8.02x 5.9x

Capital Intensity

        
CAPEX / Current Assets (%) 27.81% 19.38% 18.75% 20.4% 18.61% 5% 5.05% 5.12%
CAPEX / EBITDA (%) 43.82% 32.21% 30.18% 32.25% 29.37% 7.51% 7.4% 7.36%
CAPEX / FCF (%) 113.49% 78.78% 83.55% 83.67% 71.01% 10.85% 9.4% 6.94%

Items per share

        
Cash flow per share 1 7.188 6.426 6.631 7.203 6.781 4.284 4.562 5.192
Change - -10.6% 3.19% 8.62% -5.85% -36.82% 6.48% 13.82%
Dividend per Share 1 4.93 5.46 5.98 6.26 6.26 4.719 4.588 4.764
Change - 10.75% 9.52% 4.68% 0% -24.62% -2.78% 3.84%
Book Value Per Share 1 21.95 19.12 17.2 14.7 -0.3057 -3.732 -7.321 -10.17
Change - -12.92% -10.01% -14.53% -102.08% -1,120.91% -96.16% -38.89%
EPS 1 2.35 2.53 3.86 3.46 -8.98 0.5578 2.868 3.281
Change - 7.66% 52.57% -10.36% -359.54% 106.21% 414.17% 14.41%
Nbr of stocks (in thousands) 431,298 432,203 433,048 433,689 434,598 435,459 435,459 435,459
Announcement Date 1/27/21 1/26/22 1/25/23 1/24/24 3/13/25 - - -
1USD
Estimates
2025 *2026 *
P/E ratio 178x 34.7x
PBR -26.6x -13.6x
EV / Sales 16.1x 14.3x
Yield 4.75% 4.62%
More valuation ratios * Estimated data

EPS & Dividend

Year-on-year evolution of the PER

Year-on-year evolution of the Yield

Sell
Consensus
Buy
Mean consensus
OUTPERFORM
Number of Analysts
21
Last Close Price
99.38USD
Average target price
114.01USD
Spread / Average Target
+14.72%
Consensus

Quarterly revenue - Rate of surprise

  1. Stock Market
  2. Equities
  3. CCI Stock
  4. Financials Crown Castle Inc.