AI Analysis: Statement of government operations and balance sheet, government finance statistics, quarterly

Executive Summary

Canada's consolidated government finances show strong long-term growth over 35 years, with revenues rising 376% and expenses rising 325% to reach $334B and $355B respectively in the most recent quarter, resulting in a deficit of -$20.8B. The dataset spans 144 quarters from 1990 to 2025, covering 305 unique time series across 5 government sectors and 61 financial statement categories, with values ranging from -$1.01 trillion to +$4.07 trillion CAD. Most government finance metrics are highly correlated and trend upward together, while outlier analysis flags COVID-era quarters and April 2012 as periods of extreme fiscal activity.

Key Findings

• Revenue grew 376.1% from 1990 to 2025, reaching $334,281M CAD in the latest quarter, while expenses grew 325.1% to $355,103M, producing a net operating deficit of -$20,822M.
• The dataset contains 43,920 records across 305 time series, with a heavily right-skewed distribution — the mean value of $48,451M is nearly 28 times higher than the median of $1,750M, driven by large consolidated government totals.
• At least 25% of all recorded values are zero or near-zero (Q25 = $0), and approximately 10.8% of records are negative, reflecting deficit periods and liability entries across government accounts.
• The strongest correlation in the dataset is between Compensation of Employees and Consumption of Fixed Capital (r = 0.996), with 25 variable pairs exceeding an absolute correlation of 0.9, indicating broad co-movement across government finance metrics over time.
• The most extreme recorded values — a peak of $4,071,974M in Liabilities and a trough of -$1,013,682M in Net Financial Worth — both occurred in April 2012, flagged as the dataset's most significant outliers.
• 19 outlier data points were detected using a strict 3× IQR threshold, and several quarters breached rolling ±2 standard deviation bands in the time series, with the most notable anomalies linked to COVID-era fiscal stimulus measures.
• The Consolidated Government sector reports the largest financial figures across all categories, aggregating activity from Federal, Provincial & Territorial, Local, and CPP/QPP pension plan sectors into the broadest view of Canadian public finances.