AI Analysis: Railway industry operating and income accounts, by mainline companies

Executive Summary

Statistics Canada's Table 23100045 tracks 39 years (1986–2024) of financial data across four mainline Canadian railway companies — Canadian National, Canadian Pacific, VIA Rail, and a total aggregate — spanning 64 operating account categories. By 2024, total rail operating revenues reached nearly $20 billion against $12.8 billion in expenses, reflecting decades of sustained industry growth and healthy operating margins. The data is highly right-skewed with extreme variability, and freight revenues are the dominant financial driver, correlating almost perfectly (r = 0.999) with total operating revenues.

Key Findings

• Total rail operating revenues for all mainline companies reached $19,951,392 thousand (~$20 billion) in 2024, up substantially from 1986 levels, demonstrating strong long-term industry growth.
• Total rail operating expenses in 2024 stood at $12,764,509 thousand (~$12.8 billion), with train-related expenses highly correlated (r = 0.995) with total operations expenses, confirming they are the dominant cost driver.
• The dataset is heavily right-skewed, with a mean value of $438,794 thousand — nearly 10 times the median of $45,365 thousand — indicating a small number of very large financial figures pull the average significantly upward.
• Freight revenues and total rail operating revenues share a near-perfect correlation of 0.999, establishing freight as the overwhelming revenue driver for Canada's mainline railway industry.
• Approximately 6% of the 6,804 recorded values (428 records) are negative, representing losses or expense accounts, with values ranging from a low of -$1,654,093 thousand to a high of $19,951,392 thousand.
• Special amortization for ways and structures shows strong negative correlations with freight revenues (−0.888) and locomotive amortization (−0.898), suggesting this legacy cost category declined as the broader industry expanded.
• Outlier analysis identified 7 anomalous data points out of 234 (~3%) across the top 6 operating accounts, likely reflecting major economic events or structural industry shifts over the nearly 40-year period.