Projected Income Statement: Canadian National Railway Company

Forecast Balance Sheet: Canadian National Railway Company

Fiscal Period: December 2020 2021 2022 2023 2024 2025 2026 2027
Net Debt 1 12,337 11,647 15,101 17,998 20,505 21,124 21,567 22,011
Change - -5.59% 29.66% 19.18% 13.93% 3.02% 2.1% 2.06%
Announcement Date 26/01/21 25/01/22 24/01/23 23/01/24 30/01/25 - - -
1CAD in Million
Estimates

Cash Flow Forecast: Canadian National Railway Company

Fiscal Period: December 2020 2021 2022 2023 2024 2025 2026 2027
CAPEX 1 2,863 2,891 2,750 3,187 3,549 3,333 2,800 3,039
Change - 0.98% -4.88% 15.89% 11.36% -6.09% -15.99% 8.53%
Free Cash Flow (FCF) 1 3,302 4,080 3,917 3,778 3,150 3,403 4,290 4,695
Change - 23.56% -4% -3.55% -16.62% 8.03% 26.08% 9.44%
Announcement Date 26/01/21 25/01/22 24/01/23 23/01/24 30/01/25 - - -
1CAD in Million
Estimates

Forecast Financial Ratios: Canadian National Railway Company

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

Profitability

        
EBITDA Margin (%) 49.58% 49.87% 50.22% 50% 48.2% 49.5% 50.27% 50.93%
EBIT Margin (%) 38.09% 38.83% 40.11% 39.2% 37.11% 38.04% 38.98% 40%
EBT Margin (%) 32.88% 43.75% 39.53% 38.55% 34.33% 35.78% 36.31% 37.24%
Net margin (%) 25.78% 33.79% 29.92% 33.43% 26.09% 27.16% 27.54% 28.26%
FCF margin (%) 23.89% 28.18% 22.9% 22.45% 18.48% 19.71% 23.93% 24.85%
FCF / Net Income (%) 92.7% 83.4% 76.53% 67.16% 70.82% 72.58% 86.87% 87.96%

Profitability

        
ROA 8.04% 10.48% 10.32% 10.89% 8.11% 8.12% 8.37% 8.83%
ROE 18.9% 23.08% 23.2% 27.11% 21.61% 22.01% 23.29% 25.32%

Financial Health

        
Leverage (Debt/EBITDA) 1.8x 1.61x 1.76x 2.14x 2.5x 2.47x 2.39x 2.29x
Debt / Free cash flow 3.74x 2.85x 3.86x 4.76x 6.51x 6.21x 5.03x 4.69x

Capital Intensity

        
CAPEX / Current Assets (%) 20.72% 19.97% 16.08% 18.94% 20.82% 19.31% 15.61% 16.09%
CAPEX / EBITDA (%) 41.78% 40.04% 32.01% 37.88% 43.19% 39% 31.06% 31.58%
CAPEX / FCF (%) 86.71% 70.86% 70.21% 84.36% 112.67% 97.94% 65.26% 64.72%

Items per share

        
Cash flow per share 1 8.647 9.814 9.686 10.57 10.56 10.68 12.22 13.93
Change - 13.5% -1.3% 9.1% -0.09% 1.17% 14.41% 13.96%
Dividend per Share 1 2.3 2.46 2.93 3.16 3.38 3.544 3.69 3.82
Change - 6.96% 19.11% 7.85% 6.96% 4.85% 4.11% 3.53%
Book Value Per Share 1 27.67 32.45 31.87 30.59 33.53 34.15 35.14 36.48
Change - 17.29% -1.79% -4.02% 9.61% 1.86% 2.91% 3.79%
EPS 1 5 6.89 7.44 8.53 7.01 7.508 8.156 9.063
Change - 37.8% 7.98% 14.65% -17.82% 7.11% 8.62% 11.13%
Nbr of stocks (in thousands) 710,200 706,300 676,000 645,695 629,500 615,500 615,500 615,500
Announcement Date 26/01/21 25/01/22 24/01/23 23/01/24 30/01/25 - - -
1CAD
Estimates
2025 *2026 *
P/E ratio 18x 16.6x
PBR 3.96x 3.85x
EV / Sales 6.05x 5.85x
Yield 2.62% 2.73%
More valuation ratios * Estimated data

EPS & Dividend

Y-o-Y evolution of P/E

Year-on-year evolution of the Yield

Trader
Investor
Global
Quality
ESG MSCI
AA
More Ratings
Sell
Consensus
Buy
Mean consensus
OUTPERFORM
Number of Analysts
30
Last Close Price
135.38CAD
Average target price
154.15CAD
Spread / Average Target
+13.86%
Consensus

Quarterly revenue - Rate of surprise

  1. Stock Market
  2. Equities
  3. CNR Stock
  4. Financials Canadian National Railway Company