Projected Income Statement: Canadian Pacific Kansas City Limited

Forecast Balance Sheet: Canadian Pacific Kansas City Limited

Fiscal Period: December 2021 2022 2023 2024 2025 2026 2027 2028
Net Debt 1 20,058 19,200 22,030 21,884 23,004 23,178 22,966 23,142
Change - -4.28% 14.74% -0.66% 5.12% 0.76% -0.91% 0.77%
Announcement Date 1/27/22 1/31/23 1/30/24 1/29/25 1/28/26 - - -
1CAD in Million
Estimates

Cash Flow Forecast: Canadian Pacific Kansas City Limited

Fiscal Period: December 2021 2022 2023 2024 2025 2026 2027 2028
CAPEX 1 1,532 1,557 2,468 2,825 3,102 2,659 2,762 2,772
Change - 1.63% 58.51% 14.47% 9.81% -14.28% 3.88% 0.36%
Free Cash Flow (FCF) 1 2,156 2,585 1,669 2,444 2,207 3,635 4,048 4,203
Change - 19.9% -35.44% 46.43% -9.7% 64.72% 11.35% 3.83%
Announcement Date 1/27/22 1/31/23 1/30/24 1/29/25 1/28/26 - - -
1CAD in Million
Estimates

Forecast Financial Ratios: Canadian Pacific Kansas City Limited

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

Profitability

        
EBITDA Margin (%) 50.24% 48.29% 51.17% 51.86% 51.8% 52.81% 53.91% 54.44%
EBIT Margin (%) 40.1% 38.61% 38.88% 38.79% 37.2% 40.57% 41.98% 43.19%
EBT Margin (%) 45.28% 47.03% -24.32% 32.81% 36.36% 37.52% 38.77% 40.21%
Net margin (%) 35.67% 39.9% 31.28% 25.56% 27.46% 27.95% 28.89% 29.17%
FCF margin (%) 26.97% 29.33% 13.29% 16.8% 14.64% 22.91% 23.98% 23.13%
FCF / Net Income (%) 75.6% 73.5% 42.5% 65.73% 53.3% 81.97% 83% 79.31%

Profitability

        
ROA 6.21% 4.96% 4.67% 7.01% 4.87% 5.16% 5.74% 5.8%
ROE 12.47% 9.68% 9.77% 8.32% 8.83% 9.55% 10.47% 11.04%

Financial Health

        
Leverage (Debt/EBITDA) 4.99x 4.51x 3.43x 2.9x 2.95x 2.77x 2.52x 2.34x
Debt / Free cash flow 9.3x 7.43x 13.2x 8.95x 10.42x 6.38x 5.67x 5.51x

Capital Intensity

        
CAPEX / Current Assets (%) 19.16% 17.67% 19.66% 19.42% 20.57% 16.75% 16.36% 15.26%
CAPEX / EBITDA (%) 38.14% 36.58% 38.41% 37.45% 39.71% 31.73% 30.35% 28.02%
CAPEX / FCF (%) 71.06% 60.23% 147.87% 115.59% 140.55% 73.15% 68.24% 65.96%

Items per share

        
Cash flow per share 1 5.401 4.44 4.431 5.638 5.789 7.463 8.576 9.655
Change - -17.8% -0.21% 27.24% 2.68% 28.91% 14.92% 12.58%
Dividend per Share 1 0.76 0.76 0.76 0.76 0.874 0.962 1.068 1.215
Change - 0% 0% 0% 15% 10.07% 10.99% 13.77%
Book Value Per Share 1 49.77 41.81 44.51 51.3 51.11 54.05 56.87 62.76
Change - -15.99% 6.46% 15.25% -0.38% 5.75% 5.21% 10.37%
EPS 1 4.18 3.77 4.21 3.98 4.51 5.033 5.761 6.388
Change - -9.81% 11.67% -5.46% 13.32% 11.61% 14.46% 10.87%
Nbr of stocks (in thousands) 929,573 930,124 931,895 933,345 900,831 897,959 897,959 897,959
Announcement Date 1/27/22 1/31/23 1/30/24 1/29/25 1/28/26 - - -
1CAD
Estimates
2026 *2027 *
P/E ratio 22.5x 19.7x
PBR 2.08x 1.98x
EV / Sales 7.85x 7.37x
Yield 0.85% 0.94%

EPS & Dividend

Y-o-Y evolution of P/E

Year-on-year evolution of the Yield

Trader
Investor
Global
Quality
ESG MSCI
A
Sell
Consensus
Buy
Mean consensus
BUY
Number of Analysts
30
Last Close Price
112.69CAD
Average target price
121.55CAD
Spread / Average Target
+7.86%

Quarterly revenue - Rate of surprise

  1. Stock Market
  2. Equities
  3. CP Stock
  4. Financials Canadian Pacific Kansas City Limited
SPRING SALE -40%: The Best Tools Reserved for Subscribers to Identify Tomorrow's Top Investments!
d
:
:
BENEFIT NOW