AI Analysis: Railway industry property accounts summary of assets and accumulated amortization by mainline companies

Executive Summary

Statistics Canada's Table 23100049 tracks railway industry property accounts for Canada's four mainline companies (Canadian National, Canadian Pacific, VIA Rail, and a total aggregate) across 39 years (1986–2024), encompassing 6,752 records and 14 property account categories valued up to $43.2 billion CAD. The dataset reveals substantial long-term growth in railway assets and accumulated amortization, with a heavily right-skewed distribution where the mean value of $2.05 billion is nearly six times the median of $350 million, driven by a small number of very large infrastructure holdings. Notable anomalies include a 21% asset decline in 2018 and a 37% surge in 2020, alongside a handful of negative value entries that warrant further investigation.

Key Findings

• The dataset spans 39 years (1986–2024) with 6,752 records tracking asset values across 4 mainline companies and 14 property account categories, with values ranging from -$14,837 thousand to $43,177,903 thousand CAD.
• The distribution is heavily right-skewed, with a mean of ~$2.05 billion versus a median of ~$350 million — a nearly 6x gap — and a standard deviation of $4.1 billion, reflecting the outsized influence of large infrastructure asset categories.
• Total mainline railway assets experienced a sharp 21% year-over-year decline in 2018, followed by an anomalous 37% surge in 2020, likely reflecting major capital investments or accounting reclassifications.
• Four negative value entries were identified as outliers: Canadian National's 'Other equipment' net book value went negative in 2000 (-$357K) and 2001 (-$460K), Canadian Pacific reported a negative net book value for 'Leasehold improvements' in 2003 (-$177K), and Canadian National's 'Work equipment and roadway machines' showed a large negative accumulated amortization of -$14,837K in 2007.
• The middle 50% of all recorded values fall between approximately $80 million and $1.97 billion (an IQR of $1,887,356 thousand), underscoring the wide variability in asset scale across companies and property account categories.
• Four value types are tracked per record — Balance at Beginning of Year, Balance at End of Year, Accumulated Amortization, and Net Book Value — enabling multi-dimensional analysis of both gross asset growth and depreciation trends over nearly four decades.
• The dataset was most recently updated by Statistics Canada on April 28, 2026, confirming its currency and relevance for ongoing analysis of Canada's mainline railway infrastructure investment and asset management.