Coles Group (ASX:COL) Days Inventory : 28.63 (As of Dec. 2023)

View and export this data going back to 2018. Start your Free Trial

What is Coles Group Days Inventory?

Days Inventory is also known as Days Sales of Inventory (DSI). Coles Group's Average Total Inventories for the six months ended in Dec. 2023 was A$2,596 Mil. Coles Group's Cost of Goods Sold for the six months ended in Dec. 2023 was A$16,545 Mil. Hence, Coles Group's Days Inventory for the six months ended in Dec. 2023 was 28.63.

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

ASX:COL' s Days Inventory Range Over the Past 10 Years
Min: 25.39 Med: 27.1 Max: 31.3
Current: 31.3

During the past 6 years, Coles Group's highest Days Inventory was 31.30. The lowest was 25.39. And the median was 27.10.

ASX:COL's Days Inventory is ranked better than
57.76% of 303 companies
in the Retail - Defensive industry
Industry Median: 36.41 vs ASX:COL: 31.30

Coles Group's Days Inventory declined from Dec. 2022 (31.20) to Dec. 2023 (28.63).

Inventory Turnover measures how fast the company turns over its inventory within a year. Coles Group's Inventory Turnover for the six months ended in Dec. 2023 was 6.37.

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. Coles Group's Inventory-to-Revenue for the six months ended in Dec. 2023 was 0.12.

Coles Group Days Inventory Historical Data

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

Coles Group Days Inventory Chart

Coles Group Annual Data

Trend

Jun18

Jun19

Jun20

Jun21

Jun22

Jun23

Days Inventory

Get a 7-Day Free Trial

25.39

26.88

27.10

28.46

28.99

Coles Group Semi-Annual Data
	Dec18	Jun19	Dec19	Jun20	Dec20	Jun21	Dec21	Jun22	Dec22	Jun23	Dec23
Days Inventory	Get a 7-Day Free Trial						26.72	31.83	31.20	32.15	28.63

Competitive Comparison of Coles Group's Days Inventory

For the Grocery Stores subindustry, Coles Group'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.

Coles Group's Days Inventory Distribution in the Retail - Defensive Industry

For the Retail - Defensive industry and Consumer Defensive sector, Coles Group's Days Inventory distribution charts can be found below:

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

Coles Group Days Inventory Calculation

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

Coles Group's Days Inventory for the fiscal year that ended in Jun. 2023 is calculated as

	Days Inventory (A: Jun. 2023 )
=	Average Total Inventories					/	Cost of Goods Sold	*	Days in Period
=	( (Total Inventories (A: Jun. 2022 )	+	Total Inventories (A: Jun. 2023 ))	/	count )	/	Cost of Goods Sold (A: Jun. 2023 )	*	Days in Period
=	( (2448	+	2323)	/	2 )	/	30034	*	365
=	2385.5					/	30034	*	365
=	28.99

Coles Group'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: Jun. 2023 )	+	Total Inventories (Q: Dec. 2023 ))	/	count )	/	Cost of Goods Sold (Q: Dec. 2023 )	*	Days in Period
=	( (2323	+	2868)	/	2 )	/	16545	*	365 / 2
=	2595.5					/	16545	*	365 / 2
=	28.63

Coles Group (ASX:COL) 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.

Coles Group's Inventory Turnover for the six months ended in Dec. 2023 is calculated as

Inventory Turnover	=	Cost of Goods Sold	/	Average Total Inventories
	=	16545	/	2595.5
	=	6.37

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.

Coles Group's Inventory to Revenue for the six months ended in Dec. 2023 is calculated as

Inventory-to-Revenue	=	Average Total Inventories	/	Revenue
	=	2595.5	/	22274
	=	0.12

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.

Coles Group Days Inventory Related Terms

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

Coles Group (ASX:COL) Business Description

Industry

GURUFOCUS.COM » STOCK LIST » Consumer Defensive » Retail - Defensive » Coles Group Ltd (ASX:COL) » Definitions » Days Inventory

Comparable Companies

Traded in Other Exchanges

CLEGF:USA 2OF:Germany

Address

800-838 Toorak Road, Hawthorn East, Melbourne, VIC, AUS, 3123

Website

https://www.colesgroup.com.au

Coles Group Limited is one of Australia's largest retailers, operating the second-largest supermarket chain behind market leader Woolworths, and is the country's third-largest liquor retailer. The group has an extensive store network of about 2,500 store outlets and roughly 80% of Australian live within a 10-minute drive from their nearest Coles store. The retailer employs some 110,000 people, who process over 20 million individual customer transactions a week. This compares with Woolworths processing almost 30 million customer transactions per week from Australia's population of 25 million.