Canadian Pacific Kansas City (HAM:X88) Days Inventory: 19.18 (As of Mar. 2026) — 17% Above Median


HAM:X88 Canadian Pacific Kansas City Ltd HAM:X88
79 GF Score
Price €78.92
GF Value €75.70
Valuation Fairly Valued
! 7 Warning Signs
View Full Analysis

What is Canadian Pacific Kansas City Days Inventory?

Canadian Pacific Kansas City HAM:X88 +0.79% 79 Days Inventory is 19.18 as of Mar. 2026, which is 17% above its 10-year median of 16.44. GuruFocus rates HAM:X88 with a GF Score™ of 79/100 and a GF Value™ of €75.70 (Fairly Valued). The stock has 7 warning signs investors should review. Among 801 Transportation companies, Canadian Pacific Kansas City ranks worse than 65.67% on this metric.

Days Inventory is also known as Days Sales of Inventory (DSI). Canadian Pacific Kansas City's Average Total Inventories for the three months ended in Mar. 2026 was €324 Mil. Canadian Pacific Kansas City's Cost of Goods Sold for the three months ended in Mar. 2026 was €1,540 Mil. Hence, Canadian Pacific Kansas City's Days Inventory for the three months ended in Mar. 2026 was 19.18.

The historical rank and industry rank for Canadian Pacific Kansas City's Days Inventory or its related term are showing as below:

HAM:X88' s Days Inventory Range Over the Past 10 Years
Min: 13.1   Med: 16.44   Max: 18.9
Current: 18.9

During the past 13 years, Canadian Pacific Kansas City's highest Days Inventory was 18.90. The lowest was 13.10. And the median was 16.44.

HAM:X88's Days Inventory is ranked worse than
65.67% of 801 companies
in the Transportation industry
Industry Median: 12.4 vs HAM:X88: 18.90

Canadian Pacific Kansas City's Days Inventory increased from Mar. 2025 (17.33) to Mar. 2026 (19.18). It might indicate that Canadian Pacific Kansas City's sales slowed down.

Inventory Turnover measures how fast the company turns over its inventory within a year. Canadian Pacific Kansas City's Inventory Turnover for the three months ended in Mar. 2026 was 4.76.

Inventory-to-Revenue determines the ability of a company to manage their inventory levels. It measures the percentage of Inventories the company currently has on hand to support the current amount of Revenue. Canadian Pacific Kansas City's Inventory-to-Revenue for the three months ended in Mar. 2026 was 0.14.


Canadian Pacific Kansas City  (HAM:X88) Days Inventory Explanation

Days Inventory indicates the liquidity of the inventory. Generally, a lower Days Inventory is preferred as it indicates a shorter duration to clear off the inventory. An increase of the ratio may indicate the company's sales slowed. Similar ratios related to Days Inventory are:

1. Inventory Turnover measures how fast the company turns over its inventory within a year.

Canadian Pacific Kansas City's Inventory Turnover for the three months ended in Mar. 2026 is calculated as

2. Inventory-to-Revenue determines the ability of a company to manage their inventory levels. It measures the percentage of Inventories the company currently has on hand to support the current amount of Revenue.

Canadian Pacific Kansas City's Inventory to Revenue for the three months ended in Mar. 2026 is calculated as

* For Operating Data section: All numbers are indicated by the unit behind each term and all currency related amount are in USD.
* For other sections: All numbers are in millions except for per share data, ratio, and percentage. All currency related amount are indicated in the company's associated stock exchange currency.


Be Aware

A lot of business are seasonable. It makes more sense to compare Days Inventory from the same period in the previous year instead of from the previous quarter.


Canadian Pacific Kansas City Days Inventory Related Terms


Canadian Pacific Kansas City Days Inventory Historical Data

* Premium members only.

The historical data trend for Canadian Pacific Kansas City's Days Inventory can be seen below:

* For Operating Data section: All numbers are indicated by the unit behind each term and all currency related amount are in USD.
* For other sections: All numbers are in millions except for per share data, ratio, and percentage. All currency related amount are indicated in the company's associated stock exchange currency.

Canadian Pacific Kansas City Days Inventory Chart

Canadian Pacific Kansas City Annual Data
Trend Dec16 Dec17 Dec18 Dec19 Dec20 Dec21 Dec22 Dec23 Dec24 Dec25
Days Inventory
Get a 7-Day Free Trial Premium Member Only Premium Member Only 16.31 17.23 15.39 16.85 19.21

Canadian Pacific Kansas City Quarterly Data
Jun21 Sep21 Dec21 Mar22 Jun22 Sep22 Dec22 Mar23 Jun23 Sep23 Dec23 Mar24 Jun24 Sep24 Dec24 Mar25 Jun25 Sep25 Dec25 Mar26
Days Inventory Get a 7-Day Free Trial Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only 17.33 17.98 18.71 19.44 19.18

HAM:X88 vs UNP, CSX, NSC: Days Inventory Comparison

For the Railroads subindustry, Canadian Pacific Kansas City's Days Inventory, along with its competitors' market caps and Days Inventory data, can be viewed below:

* Competitive companies are chosen from companies within the same industry, with headquarter located in same country, with closest market capitalization; x-axis shows the market cap, and y-axis shows the term value; the bigger the dot, the larger the market cap. Note that "N/A" values will not show up in the chart.


Canadian Pacific Kansas City Days Inventory vs Transportation Industry

For the Transportation industry and Industrials sector, Canadian Pacific Kansas City's Days Inventory distribution charts can be found below:

* The bar in red indicates where Canadian Pacific Kansas City's Days Inventory falls into.


HAM:X88
79GF Score
Canadian Pacific Kansas City Ltd HAM:X88
Days Inventory is just one metric. See GF Score™, valuation, warning signs, and more.
View Full Analysis

Canadian Pacific Kansas City Days Inventory Calculation

Days Inventory indicates the number of days of goods in sales that a company has in the inventory.

Canadian Pacific Kansas City's Days Inventory for the fiscal year that ended in Dec. 2025 is calculated as

Days Inventory (A: Dec. 2025 )
=Average Total Inventories / Cost of Goods Sold*Days in Period
=( (Total Inventories (A: Dec. 2024 ) + Total Inventories (A: Dec. 2025 )) / count ) / Cost of Goods Sold (A: Dec. 2025 )*Days in Period
=( (306.335 + 310.771) / 2 ) / 5861.925*365
=308.553 / 5861.925*365
=19.21

Canadian Pacific Kansas City's Days Inventory for the quarter that ended in Mar. 2026 is calculated as:

Days Inventory (Q: Mar. 2026 )
=Average Total Inventories / Cost of Goods Sold*Days in Period
=( (Total Inventories (Q: Dec. 2025 ) + Total Inventories (Q: Mar. 2026 )) / count ) / Cost of Goods Sold (Q: Mar. 2026 )*Days in Period
=( (310.771 + 336.669) / 2 ) / 1540.229*365 / 4
=323.72 / 1540.229*365 / 4
=19.18

* For Operating Data section: All numbers are indicated by the unit behind each term and all currency related amount are in USD.
* For other sections: All numbers are in millions except for per share data, ratio, and percentage. All currency related amount are indicated in the company's associated stock exchange currency.

Frequently Asked Questions Learn more about Days Inventory →
What does a Days Inventory of 19.18 mean?
Canadian Pacific Kansas City (HAM:X88) has a Days Inventory of 19.18 as of Mar. 2026. Days inventory represents the average amount of days a company holds inventory before selling it. View historical data on Canadian Pacific Kansas City and its competitors. This is 17% above median its historical median of 16.44. Over the past decade, Canadian Pacific Kansas City's Days Inventory has ranged from 13.10 to 18.90. According to the industry distribution chart, Canadian Pacific Kansas City ranks #526 out of 801 companies in the Transportation industry, placing it in the top 65.7%.
Is Canadian Pacific Kansas City's Days Inventory too high?
Canadian Pacific Kansas City's current Days Inventory of 19.18 is 17% above median its 10-year median of 16.44. Over the past 10 years, this metric has ranged from a low of 13.10 to a high of 18.90. The Transportation industry median Days Inventory is 12.40. Canadian Pacific Kansas City's value of 19.18 is 54.7% above this industry median. Based on the distribution chart, Canadian Pacific Kansas City ranks #526 out of 801 companies in the Transportation industry, which is below the industry midpoint. Overall, Canadian Pacific Kansas City has a GF Score™ of 79/100 and is considered Fairly Valued, reflecting its overall financial health beyond just this single metric.
How does Canadian Pacific Kansas City's Days Inventory compare to UNP and CSX?
According to the Transportation industry distribution chart, Canadian Pacific Kansas City ranks #526 out of 801 companies for Days Inventory. This places Canadian Pacific Kansas City in the lower half of its industry. The industry median Days Inventory is 12.40. Canadian Pacific Kansas City's value of 19.18 is 54.7% above this benchmark. Historically, Canadian Pacific Kansas City's own Days Inventory has ranged from 13.10 to 18.90 over the past decade. While the company's 10-year median is 16.44 vs. the industry median of 12.40, Canadian Pacific Kansas City has consistently been above the industry average. See the competitive comparison table and distribution chart on this page for a detailed peer-by-peer breakdown.
What is a good Days Inventory for a Transportation company?
The median Days Inventory among Transportation companies is 12.40, based on 801 companies in the industry. Companies in the top quartile (top 25%) have a Days Inventory significantly above this median, while those in the bottom quartile fall well below. However, Days Inventory should not be evaluated in isolation — investors should consider it alongside profitability, growth, and financial strength metrics. Canadian Pacific Kansas City's current Days Inventory of 19.18 is 54.7% above the industry median. Use the industry distribution chart on this page to see where any company falls relative to its peers.
What does a high Days Inventory mean?
A high Days Inventory can signal that a stock is expensive relative to its fundamentals. Days inventory represents the average amount of days a company holds inventory before selling it. View historical data on Canadian Pacific Kansas City and its competitors. For the Transportation industry, the median Days Inventory is 12.40 — values significantly above this may indicate overvaluation, while values below may suggest a bargain or underlying issues. Canadian Pacific Kansas City's current Days Inventory is 19.18, which is 17% above median its own 10-year median of 16.44. However, context matters — high-growth companies often justify higher valuations. Always evaluate alongside other metrics like GF Score™ and GF Value™.
Is Canadian Pacific Kansas City stock overvalued right now?
Based on GuruFocus' analysis, Canadian Pacific Kansas City (HAM:X88) is currently considered Fairly Valued. The stock's GF Value™ is €75.70, compared to a current price of €78.92 — trading 4.3% above its estimated fair value. The current Days Inventory is 19.18, which is 17% above median its 10-year median of 16.44 and 54.7% above the Transportation industry median of 12.40. Canadian Pacific Kansas City's overall GF Score™ is 79/100 with 7 warning signs to review. Investors should evaluate multiple metrics — including profitability, growth, and financial strength — before making a decision.
How is Days Inventory calculated?
Days Inventory is calculated from a company's financial statements. For Canadian Pacific Kansas City (HAM:X88), the current Days Inventory is 19.18 as of Mar. 2026. GuruFocus calculates this using data sourced from SEC filings and annual reports. See the calculation section and 30-year financial data on this page for the full breakdown.

Is Canadian Pacific Kansas City (HAM:X88) Overvalued in 2026?

Based on GuruFocus' analysis, Canadian Pacific Kansas City stock appears to be overvalued. The current stock price of €78.92 is trading 4.3% above its estimated GF Value™ of €75.70. GuruFocus considers Canadian Pacific Kansas City to be Fairly Valued.

Key valuation signals for HAM:X88:

  • Days Inventory: 19.18 (17% above median its 10-year median of 16.44)
  • GF Value™: €75.70 vs. price of €78.92 (4.3% above fair value)
  • GF Score™: 79/100 with 7 warning signs
  • Industry Position: 54.7% above the Transportation median (#526 of 801)

No single metric tells the full story. See the HAM:X88 stock analysis page for a complete view including 30-year financials, guru trades, and insider activity.


Canadian Pacific Kansas City Business Description

Address 7550 Ogden Dale Road SE, Calgary, AB, CAN, T2C 4X9
Canadian Pacific Kansas City is a Class I railroad operating on tracks that span most of Canada and into parts of the Midwestern and Northeastern United States. Following the April 2023 Kansas City Southern merger, CPKC operates new single-linehaul services from Canada and the Upper Midwest down through Texas, the Gulf of Mexico, and into Mexico. It also hauls cross-border and intra-Mexico freight via operating concessions on more than 3,000 miles of rail in Mexico. CPKC hauls shipments of grain, intermodal containers, energy products (like crude and frac sand), chemicals, plastics, coal, fertilizer and potash, automotive products, and a diverse mix of other merchandise.
79GF Score

Get the complete analysis for HAM:X88

Days Inventory is just one metric. See GF Value™, 30-year financials, guru trades, warning signs, and more.

€78.92
Price
€75.70
GF Value