CP has been successfully added to your Stock Email Alerts list.
You can manage your stock email alerts here.
CP has been removed from your Stock Email Alerts list.
Please enter Portfolio Name for new portfolio.
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 Sep. 2024 was $304 Mil. Canadian Pacific Kansas City's Cost of Goods Sold for the three months ended in Sep. 2024 was $1,272 Mil. Hence, Canadian Pacific Kansas City's Days Inventory for the three months ended in Sep. 2024 was 21.80.
The historical rank and industry rank for Canadian Pacific Kansas City's Days Inventory or its related term are showing as below:
During the past 13 years, Canadian Pacific Kansas City's highest Days Inventory was 23.28. The lowest was 17.38. And the median was 20.92.
Canadian Pacific Kansas City's Days Inventory increased from Sep. 2023 (21.60) to Sep. 2024 (21.80). 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 Sep. 2024 was 4.19.
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 Sep. 2024 was 0.12.
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 Annual Data | |||||||||||||||||||||
Trend | Dec14 | Dec15 | Dec16 | Dec17 | Dec18 | Dec19 | Dec20 | Dec21 | Dec22 | Dec23 | |||||||||||
Days Inventory | Get a 7-Day Free Trial | 18.46 | 20.98 | 22.63 | 23.05 | 20.10 |
Canadian Pacific Kansas City Quarterly Data | ||||||||||||||||||||
Dec19 | Mar20 | Jun20 | Sep20 | Dec20 | Mar21 | Jun21 | Sep21 | Dec21 | Mar22 | Jun22 | Sep22 | Dec22 | Mar23 | Jun23 | Sep23 | Dec23 | Mar24 | Jun24 | Sep24 | |
Days Inventory | Get a 7-Day Free Trial | 21.60 | 20.32 | 20.45 | 21.76 | 21.80 |
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.
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.
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. 2023 is calculated as
Days Inventory (A: Dec. 2023 ) | |||||||||
= | Average Total Inventories | / | Cost of Goods Sold | * | Days in Period | ||||
= | ( (Total Inventories (A: Dec. 2022 ) | + | Total Inventories (A: Dec. 2023 )) | / | count ) | / | Cost of Goods Sold (A: Dec. 2023 ) | * | Days in Period |
= | ( (209.054 | + | 298.151) | / | 2 ) | / | 4605.695 | * | 365 |
= | 253.6025 | / | 4605.695 | * | 365 | ||||
= | 20.10 |
Canadian Pacific Kansas City's Days Inventory for the quarter that ended in Sep. 2024 is calculated as:
Days Inventory (Q: Sep. 2024 ) | |||||||||
= | Average Total Inventories | / | Cost of Goods Sold | * | Days in Period | ||||
= | ( (Total Inventories (Q: Jun. 2024 ) | + | Total Inventories (Q: Sep. 2024 )) | / | count ) | / | Cost of Goods Sold (Q: Sep. 2024 ) | * | Days in Period |
= | ( (307.187 | + | 300.458) | / | 2 ) | / | 1271.963 | * | 365 / 4 |
= | 303.8225 | / | 1271.963 | * | 365 / 4 | ||||
= | 21.80 |
* 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 (NYSE:CP) 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 Sep. 2024 is calculated as
Inventory Turnover | = | Cost of Goods Sold | / | Average Total Inventories |
= | 1271.963 | / | 303.8225 | |
= | 4.19 |
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 Sep. 2024 is calculated as
Inventory-to-Revenue | = | Average Total Inventories | / | Revenue |
= | 303.8225 | / | 2619.962 | |
= | 0.12 |
* 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.
Thank you for viewing the detailed overview of Canadian Pacific Kansas City's Days Inventory provided by GuruFocus.com. Please click on the following links to see related term pages.
John Kenneth Brooks | officer: SVP & Chief Marketing Officer | 7550 OGDEN DALE ROAD S.E., CALGARY A0 T2C 4X9 |
Mike Foran | officer: VP Network Transportation | 7550 OGDEN DALE ROAD S.E., CALGARY A0 T2C 4X9 |
Clements James Dominic Luther | officer: VP Planning & Transportation | 7550 OGDEN DALE ROAD S.E., CALGARY A0 T2C 4X9 |
Mark Kenneth Wallace | officer: VP Corp Affrs & Chief of Staff | 7550 OGDEN DALE ROAD S.E., CALGARY A0 T2C 4X9 |
E Hunter Harrison | director, officer: Chief Executive Officer | 2708 SHELTINGHAM, WELLINGTON FL 33414 |
Trafton Gordon T. Ii | director | 2632 SUTTON CIRCLE, NAPERVILLE IL 60564 |
Ubavka Rebecca Macdonald | director | 130 KING STREET WEST, TORONTO A6 M5X 1E1 |
Jane L Peverett | director | 1489 MARINE DRIVE, SUITE 802, WEST VANCOUVER A1 V7T 1B8 |
Peter John Edwards | officer: VP HR & Labour Relations | 7550 OGDEN DALE ROAD S.E., CALGARY A0 T2C 4X9 |
Robert Allen Johnson | officer: Executive VP Operations | 7550 OGDEN DALE ROAD S.E., CALGARY A0 T2C 4X9 |
John E Derry | officer: Vice-President Human Resources | 7550 OGDEN DALE ROAD S.E., CALGARY A0 T2C 4X9 |
William R. Fatt | director | 129 ROCHESTER AVENUE, TORONTO A6 M4N 1N9 |
Gillian H Denham | director | C/O CANADIAN PACIFIC RAILWAY LIMITED, 7550 OGDEN DALE ROAD S.E., CALGARY A0 T2C 4X9 |
Nadeem Velani | officer: Interim VP and CFO | 7550 OGDEN DALE ROAD S. E., CALGARY A0 T2C 4X9 |
Pershing Square Capital Management, L.p. | director | 787 11TH AVENUE, 9TH FLOOR, NEW YORK NY 10019 |
From GuruFocus
By PRNewswire • 07-29-2024
By PRNewswire • 08-22-2024
By PRNewswire • 08-23-2024
By PRNewswire • 09-17-2024
By PRNewswire • 04-23-2024
By PRNewswire • 08-22-2024
By GuruFocus Research • 07-30-2024
By PRNewswire • 05-02-2024
By PRNewswire • 08-25-2024
By PRNewswire • 04-03-2024
Disclaimers: GuruFocus.com is not operated by a broker or a dealer. It has an affiliated registered investment adviser, which serves as the subadviser to an exchange traded fund. This investment adviser does not provide advice to individual investors. Under no circumstances does any information posted on GuruFocus.com represent a recommendation to buy or sell a security. The information on this site, and in its related newsletters, is not intended to be, nor does it constitute investment advice or recommendations. The individuals or entities selected as "gurus" may buy and sell securities before and after any particular article and report and information herein is published, with respect to the securities discussed in any article and report posted herein. Gurus may be added or dropped from the GuruFocus site at any time. In no event shall GuruFocus.com be liable to any member, guest or third party for any damages of any kind arising out of the use of any content or other material published or available on GuruFocus.com, or relating to the use of, or inability to use, GuruFocus.com or any content, including, without limitation, any investment losses, lost profits, lost opportunity, special, incidental, indirect, consequential or punitive damages. Past performance is a poor indicator of future performance. The information on this site, and in its related newsletters, is not intended to be, nor does it constitute investment advice or recommendations. The information on this site is in no way guaranteed for completeness, accuracy or in any other way. The gurus listed in this website are not affiliated with GuruFocus.com, LLC. Stock quotes provided by InterActive Data. Fundamental company data provided by Morningstar, updated daily.