Coles Group (ASX:COL) Days Payable : 45.78 (As of Dec. 2023)

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

What is Coles Group Days Payable?

Coles Group's average Accounts Payable for the six months ended in Dec. 2023 was A$4,151 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 Payable for the six months ended in Dec. 2023 was 45.78.

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

ASX:COL' s Days Payable Range Over the Past 10 Years
Min: 36.1 Med: 36.98 Max: 51.86
Current: 51.86

During the past 6 years, Coles Group's highest Days Payable was 51.86. The lowest was 36.10. And the median was 36.98.

ASX:COL's Days Payable is ranked better than
57.93% of 309 companies
in the Retail - Defensive industry
Industry Median: 43.96 vs ASX:COL: 51.86

Coles Group's Days Payable declined from Dec. 2022 (48.45) to Dec. 2023 (45.78). It may suggest that Coles Group accelerated paying its suppliers.

Coles Group Days Payable Historical Data

The historical data trend for Coles Group's Days Payable 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 Payable Chart

Coles Group Annual Data

Trend

Jun18

Jun19

Jun20

Jun21

Jun22

Jun23

Days Payable

Get a 7-Day Free Trial

36.98

36.18

36.10

37.52

39.45

Coles Group Semi-Annual Data
	Dec18	Jun19	Dec19	Jun20	Dec20	Jun21	Dec21	Jun22	Dec22	Jun23	Dec23
Days Payable	Get a 7-Day Free Trial						42.07	49.32	48.45	51.58	45.78

Competitive Comparison of Coles Group's Days Payable

For the Grocery Stores subindustry, Coles Group's Days Payable, along with its competitors' market caps and Days Payable 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 Payable Distribution in the Retail - Defensive Industry

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

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

Coles Group Days Payable Calculation

Days Payable indicates the number of days that the account payable relative to cost of goods sold the company has. An increase of Days Payable may suggest that the company delays paying its suppliers.

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

	Days Payable (A: Jun. 2023 )
=	Average Accounts Payable					/	Cost of Goods Sold	*	Days in Period
=	( (Accounts Payable (A: Jun. 2022 )	+	Accounts Payable (A: Jun. 2023 ))	/	count )	/	Cost of Goods Sold (A: Jun. 2023 )	*	Days in Period
=	( (3211	+	3281)	/	2 )	/	30034	*	365
=	3246					/	30034	*	365
=	39.45

Coles Group's Days Payable for the quarter that ended in Dec. 2023 is calculated as:

	Days Payable (Q: Dec. 2023 )
=	Average Accounts Payable					/	Cost of Goods Sold	*	Days in Period
=	( (Accounts Payable (Q: Jun. 2023 )	+	Accounts Payable (Q: Dec. 2023 ))	/	count )	/	Cost of Goods Sold (Q: Dec. 2023 )	*	Days in Period
=	( (3281	+	5020)	/	2 )	/	16545	*	365 / 2
=	4150.5					/	16545	*	365 / 2
=	45.78

Coles Group Days Payable Related Terms

Thank you for viewing the detailed overview of Coles Group's Days Payable 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 Payable

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.