Projected Income Statement: Canadian Pacific Kansas City Limited

Forecast Balance Sheet: Canadian Pacific Kansas City Limited

Fiscal Period: December 2020 2021 2022 2023 2024 2025 2026 2027
Net Debt 1 9,624 20,058 19,200 22,030 21,884 22,365 21,964 22,271
Change - 108.42% -4.28% 14.74% -0.66% 2.2% -1.79% 1.4%
Announcement Date 1/27/21 1/27/22 1/31/23 1/30/24 1/29/25 - - -
1CAD in Million
Estimates

Cash Flow Forecast: Canadian Pacific Kansas City Limited

Fiscal Period: December 2020 2021 2022 2023 2024 2025 2026 2027
CAPEX 1 1,671 1,532 1,557 2,468 2,825 2,887 2,845 2,888
Change - -8.32% 1.63% 58.51% 14.47% 2.19% -1.45% 1.49%
Free Cash Flow (FCF) 1 1,131 2,156 2,585 1,669 2,444 3,235 3,890 4,547
Change - 90.63% 19.9% -35.44% 46.43% 32.36% 20.24% 16.89%
Announcement Date 1/27/21 1/27/22 1/31/23 1/30/24 1/29/25 - - -
1CAD in Million
Estimates

Forecast Financial Ratios: Canadian Pacific Kansas City Limited

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

Profitability

        
EBITDA Margin (%) 53.05% 50.24% 48.29% 51.17% 51.86% 52.08% 53.71% 54.64%
EBIT Margin (%) 42.94% 40.1% 38.61% 38.88% 38.79% 40.01% 41.98% 43.46%
EBT Margin (%) 41.53% 45.28% 47.03% -24.32% 32.81% 36.69% 39.46% 41.55%
Net margin (%) 31.7% 35.67% 39.9% 31.28% 25.56% 27.27% 29.45% 29.64%
FCF margin (%) 14.67% 26.97% 29.33% 13.29% 16.8% 20.86% 23.55% 25.8%
FCF / Net Income (%) 46.28% 75.6% 73.5% 42.5% 65.73% 76.48% 79.97% 87.03%

Profitability

        
ROA 10.62% 6.21% 4.96% 4.67% 7.01% 4.86% 5.4% 5.65%
ROE 33.4% 12.47% 9.68% 9.77% 8.32% 8.77% 9.59% 10.38%

Financial Health

        
Leverage (Debt/EBITDA) 2.35x 4.99x 4.51x 3.43x 2.9x 2.77x 2.48x 2.31x
Debt / Free cash flow 8.51x 9.3x 7.43x 13.2x 8.95x 6.91x 5.65x 4.9x

Capital Intensity

        
CAPEX / Current Assets (%) 21.67% 19.16% 17.67% 19.66% 19.42% 18.61% 17.23% 16.38%
CAPEX / EBITDA (%) 40.86% 38.14% 36.58% 38.41% 37.45% 35.74% 32.07% 29.98%
CAPEX / FCF (%) 147.75% 71.06% 60.23% 147.87% 115.59% 89.24% 73.15% 63.51%

Items per share

        
Cash flow per share 1 4.121 5.401 4.44 4.431 5.638 6.681 8.036 9.21
Change - 31.08% -17.8% -0.21% 27.24% 18.51% 20.28% 14.61%
Dividend per Share 1 0.712 0.76 0.76 0.76 0.76 0.8407 0.9427 0.9738
Change - 6.74% 0% 0% 0% 10.62% 12.14% 3.3%
Book Value Per Share 1 10.8 49.77 41.81 44.51 51.3 54.38 57.74 60.63
Change - 360.71% -15.99% 6.46% 15.25% 5.99% 6.19% 5%
EPS 1 3.594 4.18 3.77 4.21 3.98 4.549 5.341 5.916
Change - 16.3% -9.81% 11.67% -5.46% 14.29% 17.43% 10.76%
Nbr of stocks (in thousands) 671,558 929,573 930,124 931,895 933,345 930,456 930,456 930,456
Announcement Date 1/27/21 1/27/22 1/31/23 1/30/24 1/29/25 - - -
1CAD
Estimates
2025 *2026 *
P/E ratio 24.5x 20.8x
PBR 2.05x 1.93x
EV / Sales 8.11x 7.6x
Yield 0.76% 0.85%
More valuation ratios * Estimated data

EPS & Dividend

Year-on-year evolution of the PER

Year-on-year evolution of the Yield

Trading Rating
Investor Rating
ESG MSCI
A
More Ratings
Sell
Consensus
Buy
Mean consensus
OUTPERFORM
Number of Analysts
30
Last Close Price
111.22CAD
Average target price
118.24CAD
Spread / Average Target
+6.31%
Consensus

Quarterly revenue - Rate of surprise

  1. Stock Market
  2. Equities
  3. CP Stock
  4. Financials Canadian Pacific Kansas City Limited