Analysis of Short-term (Operating) Activity Ratios
Quarterly Data
Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.
Short-term Activity Ratios (Summary)
Sherwin-Williams Co., short-term (operating) activity ratios (quarterly data)
Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).
| Short-term activity ratio | Description | The company |
|---|---|---|
| Inventory turnover | An activity ratio calculated as cost of goods sold divided by inventory. | Sherwin-Williams Co. inventory turnover ratio deteriorated from Q4 2021 to Q1 2022 but then slightly improved from Q1 2022 to Q2 2022. |
| Receivables turnover | An activity ratio equal to revenue divided by receivables. | Sherwin-Williams Co. receivables turnover ratio deteriorated from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022. |
| Payables turnover | An activity ratio calculated as cost of goods sold divided by payables. | Sherwin-Williams Co. payables turnover ratio decreased from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022. |
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average inventory processing period | An activity ratio equal to the number of days in the period divided by inventory turnover over the period. | |
| Average receivable collection period | An activity ratio equal to the number of days in the period divided by receivables turnover. | Sherwin-Williams Co. number of days of receivables outstanding deteriorated from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022. |
| Operating cycle | Equal to average inventory processing period plus average receivables collection period. | Sherwin-Williams Co. operating cycle deteriorated from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022. |
| Average payables payment period | An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. | Sherwin-Williams Co. number of days of payables outstanding increased from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022. |
| Cash conversion cycle | A financial metric that measures the length of time required for a company to convert cash invested in its operations to cash received as a result of its operations; equal to average inventory processing period plus average receivables collection period minus average payables payment period. | Sherwin-Williams Co. cash conversion cycle deteriorated from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022. |
Inventory Turnover
Sherwin-Williams Co., inventory turnover calculation (quarterly data)
| Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | Dec 31, 2017 | Sep 30, 2017 | Jun 30, 2017 | Mar 31, 2017 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | |||||||||||||||||||||||||||||
| Cost of goods sold | 3,423,300) | 2,945,800) | 2,882,400) | 3,007,100) | 2,968,400) | 2,544,000) | 2,360,100) | 2,666,900) | 2,395,100) | 2,257,000) | 2,220,395) | 2,642,096) | 2,696,425) | 2,305,784) | 2,381,538) | 2,721,066) | 2,735,168) | 2,278,159) | 2,180,825) | 2,604,878) | 1,998,761) | 1,418,113) | |||||||
| Inventories | 2,411,600) | 2,328,600) | 1,927,200) | 1,816,000) | 1,804,100) | 1,847,300) | 1,804,100) | 1,672,800) | 1,788,600) | 1,954,800) | 1,889,600) | 1,824,969) | 1,894,865) | 1,993,437) | 1,815,275) | 1,861,328) | 1,874,651) | 2,001,630) | 1,801,375) | 1,704,213) | 1,854,937) | 1,247,688) | |||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||
| Inventory turnover1 | 5.08 | 5.07 | 5.92 | 5.99 | 5.84 | 5.39 | 5.37 | 5.70 | 5.32 | 5.02 | 5.22 | 5.49 | 5.33 | 5.09 | 5.57 | 5.33 | 5.23 | 4.53 | 4.55 | — | — | — | |||||||
| Benchmarks | |||||||||||||||||||||||||||||
| Inventory Turnover, Competitors2 | |||||||||||||||||||||||||||||
| Linde plc | 10.66 | 10.36 | 10.12 | 9.86 | 9.56 | 9.20 | 8.90 | 8.93 | 9.16 | 9.69 | 9.81 | — | — | — | — | — | — | — | — | — | — | — | |||||||
Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).
1 Q2 2022 Calculation
Inventory turnover
= (Cost of goods soldQ2 2022
+ Cost of goods soldQ1 2022
+ Cost of goods soldQ4 2021
+ Cost of goods soldQ3 2021)
÷ Inventories
= (3,423,300 + 2,945,800 + 2,882,400 + 3,007,100)
÷ 2,411,600 = 5.08
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Inventory turnover | An activity ratio calculated as cost of goods sold divided by inventory. | Sherwin-Williams Co. inventory turnover ratio deteriorated from Q4 2021 to Q1 2022 but then slightly improved from Q1 2022 to Q2 2022. |
Receivables Turnover
Sherwin-Williams Co., receivables turnover calculation (quarterly data)
| Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | Dec 31, 2017 | Sep 30, 2017 | Jun 30, 2017 | Mar 31, 2017 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | |||||||||||||||||||||||||||||
| Net sales | 5,872,300) | 4,998,700) | 4,762,100) | 5,146,700) | 5,379,800) | 4,656,000) | 4,488,800) | 5,122,200) | 4,604,000) | 4,146,700) | 4,114,429) | 4,867,650) | 4,877,860) | 4,040,861) | 4,064,221) | 4,731,470) | 4,773,796) | 3,965,006) | 3,979,564) | 4,507,020) | 3,735,817) | 2,761,387) | |||||||
| Accounts receivable, net | 2,982,500) | 2,783,600) | 2,352,400) | 2,598,000) | 2,590,600) | 2,414,100) | 2,078,100) | 2,454,500) | 2,472,500) | 2,291,500) | 2,088,900) | 2,479,043) | 2,659,051) | 2,339,551) | 2,018,768) | 2,584,280) | 2,625,066) | 2,326,411) | 2,104,555) | 2,426,222) | 2,377,874) | 1,356,851) | |||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||
| Receivables turnover1 | 6.97 | 7.29 | 8.48 | 7.57 | 7.58 | 7.82 | 8.84 | 7.33 | 7.17 | 7.86 | 8.57 | 7.20 | 6.66 | 7.53 | 8.69 | 6.75 | 6.56 | 6.96 | 7.12 | — | — | — | |||||||
| Benchmarks | |||||||||||||||||||||||||||||
| Receivables Turnover, Competitors2 | |||||||||||||||||||||||||||||
| Linde plc | 6.79 | 6.56 | 6.84 | 6.82 | 6.67 | 6.70 | 6.54 | 6.71 | 6.81 | 6.86 | 6.53 | — | — | — | — | — | — | — | — | — | — | — | |||||||
Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).
1 Q2 2022 Calculation
Receivables turnover
= (Net salesQ2 2022
+ Net salesQ1 2022
+ Net salesQ4 2021
+ Net salesQ3 2021)
÷ Accounts receivable, net
= (5,872,300 + 4,998,700 + 4,762,100 + 5,146,700)
÷ 2,982,500 = 6.97
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Receivables turnover | An activity ratio equal to revenue divided by receivables. | Sherwin-Williams Co. receivables turnover ratio deteriorated from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022. |
Payables Turnover
Sherwin-Williams Co., payables turnover calculation (quarterly data)
| Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | Dec 31, 2017 | Sep 30, 2017 | Jun 30, 2017 | Mar 31, 2017 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | |||||||||||||||||||||||||||||
| Cost of goods sold | 3,423,300) | 2,945,800) | 2,882,400) | 3,007,100) | 2,968,400) | 2,544,000) | 2,360,100) | 2,666,900) | 2,395,100) | 2,257,000) | 2,220,395) | 2,642,096) | 2,696,425) | 2,305,784) | 2,381,538) | 2,721,066) | 2,735,168) | 2,278,159) | 2,180,825) | 2,604,878) | 1,998,761) | 1,418,113) | |||||||
| Accounts payable | 2,992,900) | 2,860,800) | 2,403,000) | 2,675,400) | 2,502,800) | 2,217,000) | 2,117,800) | 2,056,200) | 1,848,400) | 1,958,400) | 1,876,300) | 2,028,402) | 2,067,854) | 1,894,005) | 1,799,424) | 2,165,724) | 2,049,123) | 1,975,323) | 1,791,552) | 1,832,434) | 1,783,648) | 1,221,778) | |||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||
| Payables turnover1 | 4.10 | 4.13 | 4.74 | 4.07 | 4.21 | 4.50 | 4.57 | 4.64 | 5.15 | 5.01 | 5.26 | 4.94 | 4.89 | 5.36 | 5.62 | 4.58 | 4.78 | 4.59 | 4.58 | — | — | — | |||||||
| Benchmarks | |||||||||||||||||||||||||||||
| Payables Turnover, Competitors2 | |||||||||||||||||||||||||||||
| Linde plc | 5.66 | 5.40 | 5.01 | 5.44 | 5.14 | 5.30 | 4.97 | 5.33 | 5.58 | 5.52 | 5.10 | — | — | — | — | — | — | — | — | — | — | — | |||||||
Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).
1 Q2 2022 Calculation
Payables turnover
= (Cost of goods soldQ2 2022
+ Cost of goods soldQ1 2022
+ Cost of goods soldQ4 2021
+ Cost of goods soldQ3 2021)
÷ Accounts payable
= (3,423,300 + 2,945,800 + 2,882,400 + 3,007,100)
÷ 2,992,900 = 4.10
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Payables turnover | An activity ratio calculated as cost of goods sold divided by payables. | Sherwin-Williams Co. payables turnover ratio decreased from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022. |
Working Capital Turnover
Sherwin-Williams Co., working capital turnover calculation (quarterly data)
| Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | Dec 31, 2017 | Sep 30, 2017 | Jun 30, 2017 | Mar 31, 2017 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | |||||||||||||||||||||||||||||
| Current assets | 6,259,500) | 6,086,400) | 5,053,700) | 5,378,400) | 5,185,700) | 5,109,600) | 4,591,400) | 5,175,600) | 4,883,200) | 4,928,000) | 4,631,700) | 4,907,739) | 5,089,964) | 4,815,144) | 4,344,487) | 5,038,032) | 5,037,205) | 4,886,903) | 4,465,840) | 4,683,904) | 4,854,001) | 3,876,664) | |||||||
| Less: Current liabilities | 7,198,200) | 6,953,100) | 5,719,500) | 6,478,500) | 6,190,400) | 5,651,600) | 4,594,400) | 4,358,300) | 4,459,600) | 5,220,200) | 4,521,900) | 4,865,790) | 6,342,640) | 5,000,556) | 4,297,747) | 4,842,065) | 4,190,087) | 4,327,152) | 3,987,180) | 4,371,661) | 4,151,913) | 2,939,002) | |||||||
| Working capital | (938,700) | (866,700) | (665,800) | (1,100,100) | (1,004,700) | (542,000) | (3,000) | 817,300) | 423,600) | (292,200) | 109,800) | 41,949) | (1,252,676) | (185,412) | 46,740) | 195,967) | 847,118) | 559,751) | 478,660) | 312,243) | 702,088) | 937,662) | |||||||
| Net sales | 5,872,300) | 4,998,700) | 4,762,100) | 5,146,700) | 5,379,800) | 4,656,000) | 4,488,800) | 5,122,200) | 4,604,000) | 4,146,700) | 4,114,429) | 4,867,650) | 4,877,860) | 4,040,861) | 4,064,221) | 4,731,470) | 4,773,796) | 3,965,006) | 3,979,564) | 4,507,020) | 3,735,817) | 2,761,387) | |||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||
| Working capital turnover1 | — | — | — | — | — | — | — | 22.01 | 41.86 | — | 163.03 | 425.53 | — | — | 375.15 | 89.04 | 20.33 | 28.92 | 31.30 | — | — | — | |||||||
| Benchmarks | |||||||||||||||||||||||||||||
| Working Capital Turnover, Competitors2 | |||||||||||||||||||||||||||||
| Linde plc | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).
1 Q2 2022 Calculation
Working capital turnover
= (Net salesQ2 2022
+ Net salesQ1 2022
+ Net salesQ4 2021
+ Net salesQ3 2021)
÷ Working capital
= (5,872,300 + 4,998,700 + 4,762,100 + 5,146,700)
÷ -938,700 = —
2 Click competitor name to see calculations.
Average Inventory Processing Period
Sherwin-Williams Co., average inventory processing period calculation (quarterly data)
| Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | Dec 31, 2017 | Sep 30, 2017 | Jun 30, 2017 | Mar 31, 2017 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||||||||||||||||||||||||
| Inventory turnover | 5.08 | 5.07 | 5.92 | 5.99 | 5.84 | 5.39 | 5.37 | 5.70 | 5.32 | 5.02 | 5.22 | 5.49 | 5.33 | 5.09 | 5.57 | 5.33 | 5.23 | 4.53 | 4.55 | — | — | — | |||||||
| Short-term Activity Ratio (no. days) | |||||||||||||||||||||||||||||
| Average inventory processing period1 | 72 | 72 | 62 | 61 | 62 | 68 | 68 | 64 | 69 | 73 | 70 | 66 | 68 | 72 | 65 | 69 | 70 | 81 | 80 | — | — | — | |||||||
| Benchmarks (no. days) | |||||||||||||||||||||||||||||
| Average Inventory Processing Period, Competitors2 | |||||||||||||||||||||||||||||
| Linde plc | 34 | 35 | 36 | 37 | 38 | 40 | 41 | 41 | 40 | 38 | 37 | — | — | — | — | — | — | — | — | — | — | — | |||||||
Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).
1 Q2 2022 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 5.08 = 72
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average inventory processing period | An activity ratio equal to the number of days in the period divided by inventory turnover over the period. |
Average Receivable Collection Period
Sherwin-Williams Co., average receivable collection period calculation (quarterly data)
| Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | Dec 31, 2017 | Sep 30, 2017 | Jun 30, 2017 | Mar 31, 2017 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||||||||||||||||||||||||
| Receivables turnover | 6.97 | 7.29 | 8.48 | 7.57 | 7.58 | 7.82 | 8.84 | 7.33 | 7.17 | 7.86 | 8.57 | 7.20 | 6.66 | 7.53 | 8.69 | 6.75 | 6.56 | 6.96 | 7.12 | — | — | — | |||||||
| Short-term Activity Ratio (no. days) | |||||||||||||||||||||||||||||
| Average receivable collection period1 | 52 | 50 | 43 | 48 | 48 | 47 | 41 | 50 | 51 | 46 | 43 | 51 | 55 | 48 | 42 | 54 | 56 | 52 | 51 | — | — | — | |||||||
| Benchmarks (no. days) | |||||||||||||||||||||||||||||
| Average Receivable Collection Period, Competitors2 | |||||||||||||||||||||||||||||
| Linde plc | 54 | 56 | 53 | 54 | 55 | 54 | 56 | 54 | 54 | 53 | 56 | — | — | — | — | — | — | — | — | — | — | — | |||||||
Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).
1 Q2 2022 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 6.97 = 52
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average receivable collection period | An activity ratio equal to the number of days in the period divided by receivables turnover. | Sherwin-Williams Co. number of days of receivables outstanding deteriorated from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022. |
Operating Cycle
Sherwin-Williams Co., operating cycle calculation (quarterly data)
No. days
| Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | Dec 31, 2017 | Sep 30, 2017 | Jun 30, 2017 | Mar 31, 2017 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||||||||||||||||||||||||
| Average inventory processing period | 72 | 72 | 62 | 61 | 62 | 68 | 68 | 64 | 69 | 73 | 70 | 66 | 68 | 72 | 65 | 69 | 70 | 81 | 80 | — | — | — | |||||||
| Average receivable collection period | 52 | 50 | 43 | 48 | 48 | 47 | 41 | 50 | 51 | 46 | 43 | 51 | 55 | 48 | 42 | 54 | 56 | 52 | 51 | — | — | — | |||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||
| Operating cycle1 | 124 | 122 | 105 | 109 | 110 | 115 | 109 | 114 | 120 | 119 | 113 | 117 | 123 | 120 | 107 | 123 | 126 | 133 | 131 | — | — | — | |||||||
| Benchmarks | |||||||||||||||||||||||||||||
| Operating Cycle, Competitors2 | |||||||||||||||||||||||||||||
| Linde plc | 88 | 91 | 89 | 91 | 93 | 94 | 97 | 95 | 94 | 91 | 93 | — | — | — | — | — | — | — | — | — | — | — | |||||||
Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).
1 Q2 2022 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= 72 + 52 = 124
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Operating cycle | Equal to average inventory processing period plus average receivables collection period. | Sherwin-Williams Co. operating cycle deteriorated from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022. |
Average Payables Payment Period
Sherwin-Williams Co., average payables payment period calculation (quarterly data)
| Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | Dec 31, 2017 | Sep 30, 2017 | Jun 30, 2017 | Mar 31, 2017 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||||||||||||||||||||||||
| Payables turnover | 4.10 | 4.13 | 4.74 | 4.07 | 4.21 | 4.50 | 4.57 | 4.64 | 5.15 | 5.01 | 5.26 | 4.94 | 4.89 | 5.36 | 5.62 | 4.58 | 4.78 | 4.59 | 4.58 | — | — | — | |||||||
| Short-term Activity Ratio (no. days) | |||||||||||||||||||||||||||||
| Average payables payment period1 | 89 | 88 | 77 | 90 | 87 | 81 | 80 | 79 | 71 | 73 | 69 | 74 | 75 | 68 | 65 | 80 | 76 | 80 | 80 | — | — | — | |||||||
| Benchmarks (no. days) | |||||||||||||||||||||||||||||
| Average Payables Payment Period, Competitors2 | |||||||||||||||||||||||||||||
| Linde plc | 64 | 68 | 73 | 67 | 71 | 69 | 73 | 68 | 65 | 66 | 72 | — | — | — | — | — | — | — | — | — | — | — | |||||||
Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).
1 Q2 2022 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 4.10 = 89
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average payables payment period | An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. | Sherwin-Williams Co. number of days of payables outstanding increased from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022. |
Cash Conversion Cycle
Sherwin-Williams Co., cash conversion cycle calculation (quarterly data)
No. days
| Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | Dec 31, 2017 | Sep 30, 2017 | Jun 30, 2017 | Mar 31, 2017 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||||||||||||||||||||||||
| Average inventory processing period | 72 | 72 | 62 | 61 | 62 | 68 | 68 | 64 | 69 | 73 | 70 | 66 | 68 | 72 | 65 | 69 | 70 | 81 | 80 | — | — | — | |||||||
| Average receivable collection period | 52 | 50 | 43 | 48 | 48 | 47 | 41 | 50 | 51 | 46 | 43 | 51 | 55 | 48 | 42 | 54 | 56 | 52 | 51 | — | — | — | |||||||
| Average payables payment period | 89 | 88 | 77 | 90 | 87 | 81 | 80 | 79 | 71 | 73 | 69 | 74 | 75 | 68 | 65 | 80 | 76 | 80 | 80 | — | — | — | |||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||
| Cash conversion cycle1 | 35 | 34 | 28 | 19 | 23 | 34 | 29 | 35 | 49 | 46 | 44 | 43 | 48 | 52 | 42 | 43 | 50 | 53 | 51 | — | — | — | |||||||
| Benchmarks | |||||||||||||||||||||||||||||
| Cash Conversion Cycle, Competitors2 | |||||||||||||||||||||||||||||
| Linde plc | 24 | 23 | 16 | 24 | 22 | 25 | 24 | 27 | 29 | 25 | 21 | — | — | — | — | — | — | — | — | — | — | — | |||||||
Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).
1 Q2 2022 Calculation
Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= 72 + 52 – 89 = 35
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Cash conversion cycle | A financial metric that measures the length of time required for a company to convert cash invested in its operations to cash received as a result of its operations; equal to average inventory processing period plus average receivables collection period minus average payables payment period. | Sherwin-Williams Co. cash conversion cycle deteriorated from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022. |