GURUFOCUS.COM » STOCK LIST » Technology » Hardware » Celestica Inc (NYSE:CLS) » Definitions » Days Inventory

Celestica (Celestica) Days Inventory

: 103.92 (As of Dec. 2023)
View and export this data going back to 1998. Start your Free Trial

Days Inventory is also known as Days Sales of Inventory (DSI). Celestica's Average Total Inventories for the three months ended in Dec. 2023 was $2,184 Mil. Celestica's Cost of Goods Sold for the three months ended in Dec. 2023 was $1,917 Mil. Hence, Celestica's Days Inventory for the three months ended in Dec. 2023 was 103.92.

The historical rank and industry rank for Celestica's Days Inventory or its related term are showing as below:

CLS' s Days Inventory Range Over the Past 10 Years
Min: 48.66   Med: 62.45   Max: 116.77
Current: 116.77

During the past 13 years, Celestica's highest Days Inventory was 116.77. The lowest was 48.66. And the median was 62.45.

CLS's Days Inventory is ranked worse than
55.64% of 2403 companies
in the Hardware industry
Industry Median: 104.02 vs CLS: 116.77

Celestica's Days Inventory declined from Dec. 2022 (114.93) to Dec. 2023 (103.92).

Inventory Turnover measures how fast the company turns over its inventory within a year. Celestica's Inventory Turnover for the three months ended in Dec. 2023 was 0.88.

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. Celestica's Inventory-to-Revenue for the three months ended in Dec. 2023 was 1.02.


Celestica Days Inventory Historical Data

The historical data trend for Celestica'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.

* Premium members only.

Celestica Annual Data
Trend Dec14 Dec15 Dec16 Dec17 Dec18 Dec19 Dec20 Dec21 Dec22 Dec23
Days Inventory
Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only 69.04 71.61 98.86 111.68 113.23

Celestica Quarterly Data
Mar19 Jun19 Sep19 Dec19 Mar20 Jun20 Sep20 Dec20 Mar21 Jun21 Sep21 Dec21 Mar22 Jun22 Sep22 Dec22 Mar23 Jun23 Sep23 Dec23
Days Inventory 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 Premium Member Only Premium Member Only Premium Member Only 114.93 129.58 123.47 114.44 103.92

Competitive Comparison

For the Electronic Components subindustry, Celestica'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.


Celestica Days Inventory Distribution

For the Hardware industry and Technology sector, Celestica's Days Inventory distribution charts can be found below:

* The bar in red indicates where Celestica's Days Inventory falls into.



Celestica Days Inventory Calculation

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

Celestica'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
=( (2350.3 + 2106.1) / 2 ) / 7182.5*365
=2228.2 / 7182.5*365
=113.23

Celestica's Days Inventory for the quarter that ended in Dec. 2023 is calculated as:

Days Inventory (Q: Dec. 2023 )
=Average Total Inventories / Cost of Goods Sold*Days in Period
=( (Total Inventories (Q: Sep. 2023 ) + Total Inventories (Q: Dec. 2023 )) / count ) / Cost of Goods Sold (Q: Dec. 2023 )*Days in Period
=( (2261.1 + 2106.1) / 2 ) / 1917.3*365 / 4
=2183.6 / 1917.3*365 / 4
=103.92

* 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.


Celestica  (NYSE:CLS) 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.

Celestica's Inventory Turnover for the three months ended in Dec. 2023 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.

Celestica's Inventory to Revenue for the three months ended in Dec. 2023 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.


Celestica Days Inventory Related Terms

Thank you for viewing the detailed overview of Celestica's Days Inventory provided by GuruFocus.com. Please click on the following links to see related term pages.


Celestica (Celestica) Business Description

Traded in Other Exchanges
Address
5140 Yonge Street, Suite 1900, Toronto, ON, CAN, M2N 6L7
Celestica Inc offers supply chain solutions. The company has two operating and reportable segments: Advanced Technology Solutions (ATS) and Connectivity & Cloud Solutions (CCS). The ATS segment consists of the ATS end market and is comprised of the Aerospace and Defense, Industrial, health tech, and Capital Equipment businesses. Its Capital Equipment business is comprised of the semiconductor, display, and robotics equipment businesses, and the CCS segment consists of Communications and Enterprise end markets, Enterprise end market is comprised of its servers and storage businesses. The company generates a majority of its revenue from the Connectivity & Cloud Solutions segment.