Financial Ratios Canadian Pacific Kansas City Limited

Equities

CP

CA13646K1084

Ground Freight & Logistics

Market Closed - Toronto S.E. Other stock markets 04:00:00 2024-09-13 pm EDT			5-day change	1st Jan Change
117.35 ^CAD	-0.41%		+4.41%	+11.93%

Sep. 13	How likely is an Air Canada strike and what impact would it have?	RE
Sep. 12	National Bank on Outlook For Grain Revenue For Canadian Railways	MT

ada892d4dbfd00cc39e48ffcb178ac8.XuQDGjodiWqjDxxdWecluuLME50PEU9TkbfMeskhwVM.PahhSEtYujXpWWY2OK9Cjdf7YslXfA435da_V_5YmRAwrEBKb1DLDOFFXQ

Published financial data: CANADIAN PACIFIC KANSAS CITY LIMITED

Annual

Quarterly

Halfyear

YTD

LTM

Fiscal Period: December	2019	2020	2021	2022	2023
Revenues	7.61B	7.54B	7.82B	8.63B	12.28B
Other Revenues, Total	179M	169M	179M	187M	274M
Total Revenues	7.79B	7.71B	8B	8.81B	12.56B
Cost of Goods Sold, Total	3.45B	3.15B	3.28B	4.01B	5.97B
Gross Profit	4.34B	4.56B	4.72B	4.8B	6.59B
Depreciation & Amortization - (IS)	706M	779M	811M	853M	1.54B
Other Operating Expenses	133M	126M	128M	133M	139M
Other Operating Expenses, Total	839M	905M	939M	986M	1.68B
Operating Income	3.5B	3.65B	3.78B	3.81B	4.9B
Interest Expense, Total	-454M	-462M	-446M	-652M	-771M
Interest And Investment Income	6M	4M	6M	-	-
Net Interest Expenses	-448M	-458M	-440M	-652M	-771M
Income (Loss) On Equity Invest.	-	-	-141M	1.07B	230M
Currency Exchange Gains (Loss)	98M	15M	11M	-	-47M
Other Non Operating Income (Expenses)	-9M	-8M	-1M	-17M	1M
EBT, Excl. Unusual Items	3.15B	3.2B	3.2B	4.22B	4.32B
Restructuring Charges	-	-	-	-	-
Merger & Related Restructuring Charges	-	-	415M	-74M	-196M
Gain (Loss) On Sale Of Assets	-	-	-	-	-
Insurance Settlements	-	-	-	-	-
Legal Settlements	-	-	-	-	-
Other Unusual Items	-	-	-	-	-7.18B
EBT, Incl. Unusual Items	3.15B	3.2B	3.62B	4.14B	-3.05B
Income Tax Expense	706M	758M	768M	628M	-6.98B
Earnings From Continuing Operations	2.44B	2.44B	2.85B	3.52B	3.92B
Net Income to Company	2.44B	2.44B	2.85B	3.52B	3.92B
Minority Interest	-	-	-	-	4M
Net Income - (IS)	2.44B	2.44B	2.85B	3.52B	3.93B
Net Income to Common Incl Extra Items	2.44B	2.44B	2.85B	3.52B	3.93B
Net Income to Common Excl. Extra Items	2.44B	2.44B	2.85B	3.52B	3.93B
Per Share Items
Net EPS - Basic	3.52	3.61	4.2	3.78	4.22
Basic EPS - Continuing Operations	3.52	3.61	4.2	3.78	4.22
Basic Weighted Average Shares Outstanding	694M	678M	680M	930M	931M
Net EPS - Diluted	3.5	3.59	4.18	3.77	4.21
Diluted EPS - Continuing Operations	3.5	3.59	4.18	3.77	4.21
Diluted Weighted Average Shares Outstanding	696M	680M	683M	933M	934M
Normalized Basic EPS	2.83	2.95	2.95	2.84	2.9
Normalized Diluted EPS	2.82	2.94	2.93	2.83	2.89
Dividend Per Share	0.63	0.71	0.76	0.76	0.76
Payout Ratio	16.89	19.11	17.78	20.1	18
American Depositary Receipts Ratio (ADR)	0.25	0.25	0.25	0.25	0.25
Supplemental Items
EBITDA	4.17B	4.39B	4.55B	4.67B	6.45B
EBITA	3.51B	3.66B	3.78B	3.82B	4.97B
EBIT	3.5B	3.65B	3.78B	3.81B	4.9B
EBITDAR	4.28B	4.49B	4.64B	4.77B	6.58B
Total Revenues (As Reported)	7.79B	7.71B	8B	8.81B	12.56B
Effective Tax Rate - (Ratio)	22.44	23.67	21.22	15.15	228.5
Current Domestic Taxes	410M	412M	404M	333M	377M
Current Foreign Taxes	115M	125M	122M	159M	532M
Total Current Taxes	525M	537M	526M	492M	909M
Deferred Domestic Taxes	141M	231M	-179M	177M	238M
Deferred Foreign Taxes	40M	-10M	421M	-41M	-8.12B
Total Deferred Taxes	181M	221M	242M	136M	-7.88B
Normalized Net Income	1.97B	2B	2B	2.64B	2.7B
Interest Capitalized	17M	16M	13M	-	-
Interest on Long-Term Debt	471M	478M	459M	-	2M
Non-Cash Pension Expense	-414M	-363M	-402M	-422M	-362M
Supplemental Operating Expense Items
Research And Development Expense From Footnotes	44M	42M	40M	-	-
Net Rental Expense, Total	109M	103M	92M	101M	132M
Imputed Operating Lease Interest Expense	46.13M	41.04M	22.16M	26.12M	38.08M
Imputed Operating Lease Depreciation	62.87M	61.96M	69.84M	74.88M	93.92M
Stock-Based Comp., COGS (Total)	133M	170M	131M	113M	122M
Total Stock-Based Compensation	133M	170M	131M	113M	122M

Fiscal Period: December	2019	2020	2021	2022	2023
Assets
Cash And Equivalents	133M	147M	69M	451M	464M
Total Cash And Short Term Investments	133M	147M	69M	451M	464M
Accounts Receivable, Total	595M	637M	594M	758M	1.5B
Other Receivables	210M	188M	225M	258M	391M
Total Receivables	805M	825M	819M	1.02B	1.89B
Inventory	182M	208M	235M	284M	400M
Deferred Tax Assets Current	-	-	-	-	-
Restricted Cash	-	-	13M	-	-
Other Current Assets, Total	90M	141M	216M	138M	251M
Total Current Assets	1.21B	1.32B	1.35B	1.89B	3B
Gross Property Plant And Equipment	27.09B	28.8B	29.54B	31.95B	62.13B
Accumulated Depreciation	-7.88B	-8.38B	-8.37B	-9.3B	-10.04B
Net Property Plant And Equipment	19.2B	20.42B	21.16B	22.65B	52.09B
Long-term Investments	341M	199M	42.52B	45.31B	533M
Goodwill	194M	329M	328M	344M	17.73B
Other Intangibles, Total	324M	353M	367M	42M	2.97B
Deferred Charges Long-Term	-	-	-	-	-
Other Long-Term Assets, Total	1.1B	1.02B	2.45B	3.25B	3.57B
Total Assets	22.37B	23.64B	68.18B	73.5B	79.9B
Liabilities
Accounts Payable, Total	453M	401M	432M	503M	680M
Accrued Expenses, Total	709M	685M	689M	652M	1.09B
Current Portion of Long-Term Debt	592M	1.18B	1.45B	1.5B	3.13B
Current Portion of Leases	76M	71M	163M	76M	116M
Current Income Taxes Payable	139M	115M	164M	177M	255M
Unearned Revenue Current, Total	142M	27M	20M	-	-
Other Current Liabilities	181M	176M	245M	303M	437M
Total Current Liabilities	2.29B	2.65B	3.16B	3.21B	5.71B
Long-Term Debt	8.01B	8.45B	18.54B	18.11B	19.32B
Long-Term Leases	429M	383M	260M	232M	273M
Unearned Revenue Non Current	26M	39M	51M	54M	84M
Pension & Other Post Retirement Benefits	785M	832M	718M	538M	581M
Deferred Tax Liability Non Current	3.5B	3.67B	11.35B	12.2B	11.05B
Other Non Current Liabilities	251M	298M	267M	264M	471M
Total Liabilities	15.3B	16.32B	34.35B	34.61B	37.49B
Common Stock, Total	1.99B	1.98B	25.48B	25.52B	25.6B
Additional Paid In Capital	48M	55M	66M	78M	88M
Retained Earnings	7.55B	8.1B	10.39B	13.2B	16.42B
Comprehensive Income and Other	-2.52B	-2.81B	-2.1B	91M	-618M
Total Common Equity	7.07B	7.32B	33.83B	38.89B	41.49B
Minority Interest	-	-	-	-	919M
Total Equity	7.07B	7.32B	33.83B	38.89B	42.41B
Total Liabilities And Equity	22.37B	23.64B	68.18B	73.5B	79.9B
Supplemental Items
ECS Total Shares Outstanding on Filing Date	684M	666M	930M	931M	932M
ECS Total Common Shares Outstanding	685M	666M	930M	930M	932M
Book Value / Share	10.32	10.98	36.39	41.79	44.51
Tangible Book Value	6.55B	6.64B	33.13B	38.5B	20.79B
Tangible Book Value Per Share	9.56	9.96	35.64	41.38	22.3
Total Debt	9.11B	10.08B	20.41B	19.92B	22.84B
Net Debt	8.98B	9.94B	20.34B	19.47B	22.37B
Debt Equivalent of Unfunded Proj. Benefit Obligation	-709M	-566M	-2.05B	-2.93B	-3.17B
Debt Equivalent Oper. Leases	872M	824M	736M	808M	1.06B
Minority Interest, Total (Incl. Fin. Div)	-	-	-	-	919M
Equity Method Investments, Total	293M	150M	42.47B	45.09B	-
Account Code - Inventory Valuation	6	6	6	6	6
Land - (BS)	-	-	-	-	5.27B
Buildings, Total	833M	937M	1.02B	1.07B	1.73B
Machinery, Total	4.23B	4.4B	4.5B	4.92B	7.94B
Full Time Employees	12.69K	11.89K	11.83K	12.75K	19.93K
Assets under Capital Lease - Gross	-	-	-	-	-
Assets under Capital Lease - Accumulated Depreciation	-	-	-	-	-
Accumulated Allowance for Doubtful Accounts (Supple)	42M	25M	20M	27M	63M

Fiscal Period: December	2019	2020	2021	2022	2023
Net Income	2.44B	2.44B	2.85B	3.52B	3.93B
Depreciation & Amortization - CF	661M	734M	771M	850M	1.48B
Amortization of Goodwill and Intangible Assets - (CF)	1M	3M	-	3M	61M
Depreciation & Amortization, Total	662M	737M	771M	853M	1.54B
Amortization of Deferred Charges, Total - (CF)	44M	42M	40M	-	-
(Gain) Loss on Sale of Investments - (CF)	-	-	-	-	7.18B
Asset Writedown & Restructuring Costs	-	-	-	-	-
(Income) Loss On Equity Investments - (CF)	-	-	141M	83M	70M
Other Operating Activities, Total	-130M	-32M	-50M	-219M	-8.27B
Change In Accounts Receivable	27M	-61M	32M	-147M	-317M
Change In Inventories	-8M	-15M	-14M	-27M	1M
Change In Accounts Payable	-21M	-308M	-108M	95M	57M
Change in Other Net Operating Assets	-24M	-5M	24M	-13M	-49M
Cash from Operations	2.99B	2.8B	3.69B	4.14B	4.14B
Capital Expenditure	-1.65B	-1.67B	-1.53B	-1.56B	-2.5B
Sale of Property, Plant, and Equipment	26M	22M	96M	58M	57M
Cash Acquisitions	-174M	-379M	-	-	298M
Divestitures	-	-	-	-	-
Sale (Purchase) of Intangible assets	-	-	-	-	-
Investment in Marketable and Equity Securities, Total	-	-	-12.3B	-	7M
Other Investing Activities, Total	-8M	-2M	5M	3M	-25M
Cash from Investing	-1.8B	-2.03B	-13.73B	-1.5B	-2.16B
Short Term Debt Issued, Total	524M	275M	-	-	1.1B
Long-Term Debt Issued, Total	397M	958M	11.31B	-	-
Total Debt Issued	921M	1.23B	11.31B	-	1.1B
Short Term Debt Repaid, Total	-	-	-454M	-415M	-
Long-Term Debt Repaid, Total	-500M	-84M	-359M	-1.21B	-2.4B
Total Debt Repaid	-500M	-84M	-813M	-1.62B	-2.4B
Issuance of Common Stock	26M	52M	25M	32M	69M
Repurchase of Common Stock	-1.13B	-1.51B	-	-	-
Common Dividends Paid	-412M	-467M	-507M	-707M	-707M
Common & Preferred Stock Dividends Paid	-412M	-467M	-507M	-707M	-707M
Other Financing Activities, Total	-12M	11M	-75M	-	-17M
Cash from Financing	-1.11B	-764M	9.94B	-2.3B	-1.96B
Foreign Exchange Rate Adjustments	-4M	6M	41M	20M	-7M
Net Change in Cash	72M	14M	-65M	369M	13M
Supplemental Items
Cash Interest Paid	444M	443M	426M	641M	825M
Cash Income Tax Paid (Refund)	506M	582M	552M	408M	906M
Levered Free Cash Flow	1.25B	955M	1.53B	1.32B	1.48B
Unlevered Free Cash Flow	1.54B	1.24B	1.81B	1.72B	1.96B
Change In Net Working Capital	-154M	317M	-37M	70M	270M
Net Debt Issued / Repaid	421M	1.15B	10.49B	-1.62B	-1.3B

Fiscal Period: December	2019	2020	2021	2022	2023
Profitability
Return on Assets	10.04	9.93	5.14	3.37	4
Return on Total Capital	13.9	13.6	6.59	4.22	4.94
Return On Equity %	35.61	33.97	13.86	9.67	9.65
Return on Common Equity	35.61	33.97	13.86	9.67	9.77
Margin Analysis
Gross Profit Margin %	55.75	59.12	58.97	54.46	52.47
EBITDA Margin %	53.48	56.94	56.87	52.95	51.36
EBITA Margin %	44.99	47.42	47.23	43.31	39.55
EBIT Margin %	44.98	47.38	47.23	43.27	39.07
Income From Continuing Operations Margin %	31.31	31.7	35.67	39.9	31.25
Net Income Margin %	31.31	31.7	35.67	39.9	31.28
Net Avail. For Common Margin %	31.31	31.7	35.67	39.9	31.28
Normalized Net Income Margin	25.23	25.96	25.05	29.92	21.53
Levered Free Cash Flow Margin	16.08	12.39	19.12	14.92	11.79
Unlevered Free Cash Flow Margin	19.72	16.14	22.6	19.55	15.62
Asset Turnover