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)
Walgreens Boots Alliance Inc., short-term (operating) activity ratios (quarterly data)
Based on: 10-Q (reporting date: 2020-05-31), 10-Q (reporting date: 2020-02-29), 10-Q (reporting date: 2019-11-30), 10-K (reporting date: 2019-08-31), 10-Q (reporting date: 2019-05-31), 10-Q (reporting date: 2019-02-28), 10-Q (reporting date: 2018-11-30), 10-K (reporting date: 2018-08-31), 10-Q (reporting date: 2018-05-31), 10-Q (reporting date: 2018-02-28), 10-Q (reporting date: 2017-11-30), 10-K (reporting date: 2017-08-31), 10-Q (reporting date: 2017-05-31), 10-Q (reporting date: 2017-02-28), 10-Q (reporting date: 2016-11-30), 10-K (reporting date: 2016-08-31), 10-Q (reporting date: 2016-05-31), 10-Q (reporting date: 2016-02-29), 10-Q (reporting date: 2015-11-30), 10-K (reporting date: 2015-08-31), 10-Q (reporting date: 2015-05-31), 10-Q (reporting date: 2015-02-28), 10-Q (reporting date: 2014-11-30), 10-K (reporting date: 2014-08-31), 10-Q (reporting date: 2014-05-31), 10-Q (reporting date: 2014-02-28), 10-Q (reporting date: 2013-11-30).
| Short-term activity ratio | Description | The company |
|---|---|---|
| Inventory turnover | An activity ratio calculated as cost of goods sold divided by inventory. | Walgreens Boots Alliance Inc. inventory turnover ratio improved from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020. |
| Receivables turnover | An activity ratio equal to revenue divided by receivables. | Walgreens Boots Alliance Inc. receivables turnover ratio deteriorated from Q1 2020 to Q2 2020 but then improved from Q2 2020 to Q3 2020 exceeding Q1 2020 level. |
| Payables turnover | An activity ratio calculated as cost of goods sold divided by payables. | Walgreens Boots Alliance Inc. payables turnover ratio increased from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020. |
| 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. | |
| Operating cycle | Equal to average inventory processing period plus average receivables collection period. | Walgreens Boots Alliance Inc. operating cycle improved from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020. |
| 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. | Walgreens Boots Alliance Inc. number of days of payables outstanding decreased from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020. |
| 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. |
Inventory Turnover
Walgreens Boots Alliance Inc., inventory turnover calculation (quarterly data)
| May 31, 2020 | Feb 29, 2020 | Nov 30, 2019 | Aug 31, 2019 | May 31, 2019 | Feb 28, 2019 | Nov 30, 2018 | Aug 31, 2018 | May 31, 2018 | Feb 28, 2018 | Nov 30, 2017 | Aug 31, 2017 | May 31, 2017 | Feb 28, 2017 | Nov 30, 2016 | Aug 31, 2016 | May 31, 2016 | Feb 29, 2016 | Nov 30, 2015 | Aug 31, 2015 | May 31, 2015 | Feb 28, 2015 | Nov 30, 2014 | Aug 31, 2014 | May 31, 2014 | Feb 28, 2014 | Nov 30, 2013 | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||||||||||||||||||||||||||||||
| Cost of sales | 28,193) | 28,307) | 27,076) | 26,726) | 27,138) | 26,774) | 26,152) | 25,867) | 26,554) | 24,925) | 23,399) | 22,809) | 22,973) | 21,885) | 21,385) | 21,481) | 22,065) | 22,317) | 21,614) | 21,257) | 21,314) | 19,691) | 14,258) | 13,730) | 13,961) | 13,955) | 13,177) | ||||||||
| Inventories | 9,563) | 9,652) | 10,536) | 9,333) | 9,874) | 10,188) | 10,976) | 9,565) | 9,889) | 10,316) | 10,010) | 8,899) | 8,681) | 9,230) | 10,039) | 8,956) | 8,931) | 9,025) | 9,884) | 8,678) | 8,764) | 9,379) | 6,518) | 6,076) | 6,439) | 7,213) | 7,729) | ||||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||||||||
| Inventory turnover1 | 11.53 | 11.32 | 10.22 | 11.44 | 10.73 | 10.34 | 9.43 | 10.53 | 9.88 | 9.12 | 9.10 | 10.01 | 10.11 | 9.41 | 8.69 | 9.77 | 9.77 | 9.58 | 8.49 | 8.82 | 7.87 | 6.57 | 8.58 | 9.02 | — | — | — | ||||||||
| Benchmarks | |||||||||||||||||||||||||||||||||||
| Inventory Turnover, Competitors2 | |||||||||||||||||||||||||||||||||||
| Costco Wholesale Corp. | 12.70 | 11.63 | 9.73 | 11.66 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Dollar General Corp. | 4.22 | 4.20 | 4.43 | 4.35 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Target Corp. | 4.80 | 5.95 | 5.95 | 5.61 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Walmart Inc. | 7.60 | 8.81 | 8.64 | 8.70 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Based on: 10-Q (reporting date: 2020-05-31), 10-Q (reporting date: 2020-02-29), 10-Q (reporting date: 2019-11-30), 10-K (reporting date: 2019-08-31), 10-Q (reporting date: 2019-05-31), 10-Q (reporting date: 2019-02-28), 10-Q (reporting date: 2018-11-30), 10-K (reporting date: 2018-08-31), 10-Q (reporting date: 2018-05-31), 10-Q (reporting date: 2018-02-28), 10-Q (reporting date: 2017-11-30), 10-K (reporting date: 2017-08-31), 10-Q (reporting date: 2017-05-31), 10-Q (reporting date: 2017-02-28), 10-Q (reporting date: 2016-11-30), 10-K (reporting date: 2016-08-31), 10-Q (reporting date: 2016-05-31), 10-Q (reporting date: 2016-02-29), 10-Q (reporting date: 2015-11-30), 10-K (reporting date: 2015-08-31), 10-Q (reporting date: 2015-05-31), 10-Q (reporting date: 2015-02-28), 10-Q (reporting date: 2014-11-30), 10-K (reporting date: 2014-08-31), 10-Q (reporting date: 2014-05-31), 10-Q (reporting date: 2014-02-28), 10-Q (reporting date: 2013-11-30).
1 Q3 2020 Calculation
Inventory turnover
= (Cost of salesQ3 2020
+ Cost of salesQ2 2020
+ Cost of salesQ1 2020
+ Cost of salesQ4 2019)
÷ Inventories
= (28,193 + 28,307 + 27,076 + 26,726)
÷ 9,563 = 11.53
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. | Walgreens Boots Alliance Inc. inventory turnover ratio improved from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020. |
Receivables Turnover
Walgreens Boots Alliance Inc., receivables turnover calculation (quarterly data)
| May 31, 2020 | Feb 29, 2020 | Nov 30, 2019 | Aug 31, 2019 | May 31, 2019 | Feb 28, 2019 | Nov 30, 2018 | Aug 31, 2018 | May 31, 2018 | Feb 28, 2018 | Nov 30, 2017 | Aug 31, 2017 | May 31, 2017 | Feb 28, 2017 | Nov 30, 2016 | Aug 31, 2016 | May 31, 2016 | Feb 29, 2016 | Nov 30, 2015 | Aug 31, 2015 | May 31, 2015 | Feb 28, 2015 | Nov 30, 2014 | Aug 31, 2014 | May 31, 2014 | Feb 28, 2014 | Nov 30, 2013 | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||||||||||||||||||||||||||||||
| Sales | 34,631) | 35,820) | 34,339) | 33,954) | 34,591) | 34,528) | 33,793) | 33,442) | 34,334) | 33,021) | 30,740) | 30,149) | 30,118) | 29,446) | 28,501) | 28,636) | 29,498) | 30,184) | 29,033) | 28,522) | 28,795) | 26,573) | 19,554) | 19,057) | 19,401) | 19,605) | 18,329) | ||||||||
| Accounts receivable, net | 6,982) | 7,572) | 7,435) | 7,226) | 7,239) | 7,828) | 7,144) | 6,573) | 7,159) | 7,281) | 6,858) | 6,528) | 6,339) | 5,674) | 6,138) | 6,260) | 6,508) | 6,733) | 6,821) | 6,849) | 6,899) | 7,017) | 3,579) | 3,218) | 3,029) | 2,774) | 2,727) | ||||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||||||||
| Receivables turnover1 | 19.87 | 18.32 | 18.48 | 18.94 | 18.84 | 17.39 | 18.84 | 20.01 | 17.91 | 17.03 | 17.56 | 18.11 | 18.41 | 20.46 | 19.03 | 18.75 | 18.01 | 17.31 | 16.56 | 15.10 | 13.62 | 12.05 | 21.69 | 23.74 | — | — | — | ||||||||
| Benchmarks | |||||||||||||||||||||||||||||||||||
| Receivables Turnover, Competitors2 | |||||||||||||||||||||||||||||||||||
| Costco Wholesale Corp. | 104.44 | 77.92 | 88.41 | 97.30 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Walmart Inc. | 92.13 | 95.50 | 95.78 | 81.22 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Based on: 10-Q (reporting date: 2020-05-31), 10-Q (reporting date: 2020-02-29), 10-Q (reporting date: 2019-11-30), 10-K (reporting date: 2019-08-31), 10-Q (reporting date: 2019-05-31), 10-Q (reporting date: 2019-02-28), 10-Q (reporting date: 2018-11-30), 10-K (reporting date: 2018-08-31), 10-Q (reporting date: 2018-05-31), 10-Q (reporting date: 2018-02-28), 10-Q (reporting date: 2017-11-30), 10-K (reporting date: 2017-08-31), 10-Q (reporting date: 2017-05-31), 10-Q (reporting date: 2017-02-28), 10-Q (reporting date: 2016-11-30), 10-K (reporting date: 2016-08-31), 10-Q (reporting date: 2016-05-31), 10-Q (reporting date: 2016-02-29), 10-Q (reporting date: 2015-11-30), 10-K (reporting date: 2015-08-31), 10-Q (reporting date: 2015-05-31), 10-Q (reporting date: 2015-02-28), 10-Q (reporting date: 2014-11-30), 10-K (reporting date: 2014-08-31), 10-Q (reporting date: 2014-05-31), 10-Q (reporting date: 2014-02-28), 10-Q (reporting date: 2013-11-30).
1 Q3 2020 Calculation
Receivables turnover
= (SalesQ3 2020
+ SalesQ2 2020
+ SalesQ1 2020
+ SalesQ4 2019)
÷ Accounts receivable, net
= (34,631 + 35,820 + 34,339 + 33,954)
÷ 6,982 = 19.87
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. | Walgreens Boots Alliance Inc. receivables turnover ratio deteriorated from Q1 2020 to Q2 2020 but then improved from Q2 2020 to Q3 2020 exceeding Q1 2020 level. |
Payables Turnover
Walgreens Boots Alliance Inc., payables turnover calculation (quarterly data)
| May 31, 2020 | Feb 29, 2020 | Nov 30, 2019 | Aug 31, 2019 | May 31, 2019 | Feb 28, 2019 | Nov 30, 2018 | Aug 31, 2018 | May 31, 2018 | Feb 28, 2018 | Nov 30, 2017 | Aug 31, 2017 | May 31, 2017 | Feb 28, 2017 | Nov 30, 2016 | Aug 31, 2016 | May 31, 2016 | Feb 29, 2016 | Nov 30, 2015 | Aug 31, 2015 | May 31, 2015 | Feb 28, 2015 | Nov 30, 2014 | Aug 31, 2014 | May 31, 2014 | Feb 28, 2014 | Nov 30, 2013 | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||||||||||||||||||||||||||||||
| Cost of sales | 28,193) | 28,307) | 27,076) | 26,726) | 27,138) | 26,774) | 26,152) | 25,867) | 26,554) | 24,925) | 23,399) | 22,809) | 22,973) | 21,885) | 21,385) | 21,481) | 22,065) | 22,317) | 21,614) | 21,257) | 21,314) | 19,691) | 14,258) | 13,730) | 13,961) | 13,955) | 13,177) | ||||||||
| Trade accounts payable | 14,033) | 14,968) | 15,401) | 14,341) | 14,130) | 14,348) | 14,660) | 13,566) | 13,089) | 13,301) | 13,570) | 12,494) | 11,528) | 11,264) | 11,372) | 11,000) | 10,337) | 9,873) | 10,643) | 10,088) | 9,932) | 10,293) | 5,189) | 4,315) | 4,235) | 4,488) | 4,762) | ||||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||||||||
| Payables turnover1 | 7.86 | 7.30 | 6.99 | 7.45 | 7.50 | 7.34 | 7.06 | 7.43 | 7.46 | 7.08 | 6.71 | 7.13 | 7.61 | 7.71 | 7.67 | 7.95 | 8.44 | 8.76 | 7.88 | 7.59 | 6.95 | 5.99 | 10.77 | 12.71 | — | — | — | ||||||||
| Benchmarks | |||||||||||||||||||||||||||||||||||
| Payables Turnover, Competitors2 | |||||||||||||||||||||||||||||||||||
| Costco Wholesale Corp. | 12.93 | 12.45 | 9.31 | 11.38 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Dollar General Corp. | 6.67 | 6.80 | 7.42 | 7.47 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Target Corp. | 4.86 | 5.93 | 6.45 | 5.46 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Walmart Inc. | 7.87 | 8.48 | 8.57 | 8.19 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Based on: 10-Q (reporting date: 2020-05-31), 10-Q (reporting date: 2020-02-29), 10-Q (reporting date: 2019-11-30), 10-K (reporting date: 2019-08-31), 10-Q (reporting date: 2019-05-31), 10-Q (reporting date: 2019-02-28), 10-Q (reporting date: 2018-11-30), 10-K (reporting date: 2018-08-31), 10-Q (reporting date: 2018-05-31), 10-Q (reporting date: 2018-02-28), 10-Q (reporting date: 2017-11-30), 10-K (reporting date: 2017-08-31), 10-Q (reporting date: 2017-05-31), 10-Q (reporting date: 2017-02-28), 10-Q (reporting date: 2016-11-30), 10-K (reporting date: 2016-08-31), 10-Q (reporting date: 2016-05-31), 10-Q (reporting date: 2016-02-29), 10-Q (reporting date: 2015-11-30), 10-K (reporting date: 2015-08-31), 10-Q (reporting date: 2015-05-31), 10-Q (reporting date: 2015-02-28), 10-Q (reporting date: 2014-11-30), 10-K (reporting date: 2014-08-31), 10-Q (reporting date: 2014-05-31), 10-Q (reporting date: 2014-02-28), 10-Q (reporting date: 2013-11-30).
1 Q3 2020 Calculation
Payables turnover
= (Cost of salesQ3 2020
+ Cost of salesQ2 2020
+ Cost of salesQ1 2020
+ Cost of salesQ4 2019)
÷ Trade accounts payable
= (28,193 + 28,307 + 27,076 + 26,726)
÷ 14,033 = 7.86
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. | Walgreens Boots Alliance Inc. payables turnover ratio increased from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020. |
Working Capital Turnover
Walgreens Boots Alliance Inc., working capital turnover calculation (quarterly data)
| May 31, 2020 | Feb 29, 2020 | Nov 30, 2019 | Aug 31, 2019 | May 31, 2019 | Feb 28, 2019 | Nov 30, 2018 | Aug 31, 2018 | May 31, 2018 | Feb 28, 2018 | Nov 30, 2017 | Aug 31, 2017 | May 31, 2017 | Feb 28, 2017 | Nov 30, 2016 | Aug 31, 2016 | May 31, 2016 | Feb 29, 2016 | Nov 30, 2015 | Aug 31, 2015 | May 31, 2015 | Feb 28, 2015 | Nov 30, 2014 | Aug 31, 2014 | May 31, 2014 | Feb 28, 2014 | Nov 30, 2013 | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||||||||||||||||||||||||||||||
| Current assets | 18,326) | 18,909) | 19,604) | 18,700) | 19,021) | 19,851) | 20,083) | 17,846) | 19,988) | 20,358) | 19,681) | 19,753) | 28,152) | 27,509) | 26,668) | 25,883) | 19,713) | 20,378) | 20,231) | 19,657) | 21,029) | 20,715) | 23,280) | 12,242) | 11,928) | 12,036) | 11,722) | ||||||||
| Less: Current liabilities | 26,649) | 28,662) | 29,494) | 25,769) | 25,060) | 25,303) | 25,099) | 21,667) | 21,482) | 22,559) | 20,517) | 18,547) | 21,713) | 17,678) | 17,729) | 17,013) | 15,811) | 16,272) | 16,874) | 16,557) | 16,157) | 16,690) | 9,877) | 8,895) | 8,409) | 8,499) | 8,821) | ||||||||
| Working capital | (8,323) | (9,753) | (9,890) | (7,069) | (6,039) | (5,452) | (5,016) | (3,821) | (1,494) | (2,201) | (836) | 1,206) | 6,439) | 9,831) | 8,939) | 8,870) | 3,902) | 4,106) | 3,357) | 3,100) | 4,872) | 4,025) | 13,403) | 3,347) | 3,519) | 3,537) | 2,901) | ||||||||
| Sales | 34,631) | 35,820) | 34,339) | 33,954) | 34,591) | 34,528) | 33,793) | 33,442) | 34,334) | 33,021) | 30,740) | 30,149) | 30,118) | 29,446) | 28,501) | 28,636) | 29,498) | 30,184) | 29,033) | 28,522) | 28,795) | 26,573) | 19,554) | 19,057) | 19,401) | 19,605) | 18,329) | ||||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||||||||
| Working capital turnover1 | — | — | — | — | — | — | — | — | — | — | — | 98.02 | 18.12 | 11.81 | 13.07 | 13.23 | 30.05 | 28.38 | 33.64 | 33.37 | 19.29 | 21.01 | 5.79 | 22.82 | — | — | — | ||||||||
| Benchmarks | |||||||||||||||||||||||||||||||||||
| Working Capital Turnover, Competitors2 | |||||||||||||||||||||||||||||||||||
| Costco Wholesale Corp. | 63.59 | 153.67 | 400.20 | 602.22 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Dollar General Corp. | 48.44 | 43.95 | 41.68 | 15.56 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Target Corp. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Walmart Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Based on: 10-Q (reporting date: 2020-05-31), 10-Q (reporting date: 2020-02-29), 10-Q (reporting date: 2019-11-30), 10-K (reporting date: 2019-08-31), 10-Q (reporting date: 2019-05-31), 10-Q (reporting date: 2019-02-28), 10-Q (reporting date: 2018-11-30), 10-K (reporting date: 2018-08-31), 10-Q (reporting date: 2018-05-31), 10-Q (reporting date: 2018-02-28), 10-Q (reporting date: 2017-11-30), 10-K (reporting date: 2017-08-31), 10-Q (reporting date: 2017-05-31), 10-Q (reporting date: 2017-02-28), 10-Q (reporting date: 2016-11-30), 10-K (reporting date: 2016-08-31), 10-Q (reporting date: 2016-05-31), 10-Q (reporting date: 2016-02-29), 10-Q (reporting date: 2015-11-30), 10-K (reporting date: 2015-08-31), 10-Q (reporting date: 2015-05-31), 10-Q (reporting date: 2015-02-28), 10-Q (reporting date: 2014-11-30), 10-K (reporting date: 2014-08-31), 10-Q (reporting date: 2014-05-31), 10-Q (reporting date: 2014-02-28), 10-Q (reporting date: 2013-11-30).
1 Q3 2020 Calculation
Working capital turnover
= (SalesQ3 2020
+ SalesQ2 2020
+ SalesQ1 2020
+ SalesQ4 2019)
÷ Working capital
= (34,631 + 35,820 + 34,339 + 33,954)
÷ -8,323 = —
2 Click competitor name to see calculations.
Average Inventory Processing Period
Walgreens Boots Alliance Inc., average inventory processing period calculation (quarterly data)
| May 31, 2020 | Feb 29, 2020 | Nov 30, 2019 | Aug 31, 2019 | May 31, 2019 | Feb 28, 2019 | Nov 30, 2018 | Aug 31, 2018 | May 31, 2018 | Feb 28, 2018 | Nov 30, 2017 | Aug 31, 2017 | May 31, 2017 | Feb 28, 2017 | Nov 30, 2016 | Aug 31, 2016 | May 31, 2016 | Feb 29, 2016 | Nov 30, 2015 | Aug 31, 2015 | May 31, 2015 | Feb 28, 2015 | Nov 30, 2014 | Aug 31, 2014 | May 31, 2014 | Feb 28, 2014 | Nov 30, 2013 | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||||||||||||||||||||||||||||||
| Inventory turnover | 11.53 | 11.32 | 10.22 | 11.44 | 10.73 | 10.34 | 9.43 | 10.53 | 9.88 | 9.12 | 9.10 | 10.01 | 10.11 | 9.41 | 8.69 | 9.77 | 9.77 | 9.58 | 8.49 | 8.82 | 7.87 | 6.57 | 8.58 | 9.02 | — | — | — | ||||||||
| Short-term Activity Ratio (no. days) | |||||||||||||||||||||||||||||||||||
| Average inventory processing period1 | 32 | 32 | 36 | 32 | 34 | 35 | 39 | 35 | 37 | 40 | 40 | 36 | 36 | 39 | 42 | 37 | 37 | 38 | 43 | 41 | 46 | 56 | 43 | 40 | — | — | — | ||||||||
| Benchmarks (no. days) | |||||||||||||||||||||||||||||||||||
| Average Inventory Processing Period, Competitors2 | |||||||||||||||||||||||||||||||||||
| Costco Wholesale Corp. | 29 | 31 | 37 | 31 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Dollar General Corp. | 87 | 87 | 82 | 84 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Target Corp. | 76 | 61 | 61 | 65 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Walmart Inc. | 48 | 41 | 42 | 42 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Based on: 10-Q (reporting date: 2020-05-31), 10-Q (reporting date: 2020-02-29), 10-Q (reporting date: 2019-11-30), 10-K (reporting date: 2019-08-31), 10-Q (reporting date: 2019-05-31), 10-Q (reporting date: 2019-02-28), 10-Q (reporting date: 2018-11-30), 10-K (reporting date: 2018-08-31), 10-Q (reporting date: 2018-05-31), 10-Q (reporting date: 2018-02-28), 10-Q (reporting date: 2017-11-30), 10-K (reporting date: 2017-08-31), 10-Q (reporting date: 2017-05-31), 10-Q (reporting date: 2017-02-28), 10-Q (reporting date: 2016-11-30), 10-K (reporting date: 2016-08-31), 10-Q (reporting date: 2016-05-31), 10-Q (reporting date: 2016-02-29), 10-Q (reporting date: 2015-11-30), 10-K (reporting date: 2015-08-31), 10-Q (reporting date: 2015-05-31), 10-Q (reporting date: 2015-02-28), 10-Q (reporting date: 2014-11-30), 10-K (reporting date: 2014-08-31), 10-Q (reporting date: 2014-05-31), 10-Q (reporting date: 2014-02-28), 10-Q (reporting date: 2013-11-30).
1 Q3 2020 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 11.53 = 32
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
Walgreens Boots Alliance Inc., average receivable collection period calculation (quarterly data)
| May 31, 2020 | Feb 29, 2020 | Nov 30, 2019 | Aug 31, 2019 | May 31, 2019 | Feb 28, 2019 | Nov 30, 2018 | Aug 31, 2018 | May 31, 2018 | Feb 28, 2018 | Nov 30, 2017 | Aug 31, 2017 | May 31, 2017 | Feb 28, 2017 | Nov 30, 2016 | Aug 31, 2016 | May 31, 2016 | Feb 29, 2016 | Nov 30, 2015 | Aug 31, 2015 | May 31, 2015 | Feb 28, 2015 | Nov 30, 2014 | Aug 31, 2014 | May 31, 2014 | Feb 28, 2014 | Nov 30, 2013 | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||||||||||||||||||||||||||||||
| Receivables turnover | 19.87 | 18.32 | 18.48 | 18.94 | 18.84 | 17.39 | 18.84 | 20.01 | 17.91 | 17.03 | 17.56 | 18.11 | 18.41 | 20.46 | 19.03 | 18.75 | 18.01 | 17.31 | 16.56 | 15.10 | 13.62 | 12.05 | 21.69 | 23.74 | — | — | — | ||||||||
| Short-term Activity Ratio (no. days) | |||||||||||||||||||||||||||||||||||
| Average receivable collection period1 | 18 | 20 | 20 | 19 | 19 | 21 | 19 | 18 | 20 | 21 | 21 | 20 | 20 | 18 | 19 | 19 | 20 | 21 | 22 | 24 | 27 | 30 | 17 | 15 | — | — | — | ||||||||
| Benchmarks (no. days) | |||||||||||||||||||||||||||||||||||
| Average Receivable Collection Period, Competitors2 | |||||||||||||||||||||||||||||||||||
| Costco Wholesale Corp. | 3 | 5 | 4 | 4 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Walmart Inc. | 4 | 4 | 4 | 4 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Based on: 10-Q (reporting date: 2020-05-31), 10-Q (reporting date: 2020-02-29), 10-Q (reporting date: 2019-11-30), 10-K (reporting date: 2019-08-31), 10-Q (reporting date: 2019-05-31), 10-Q (reporting date: 2019-02-28), 10-Q (reporting date: 2018-11-30), 10-K (reporting date: 2018-08-31), 10-Q (reporting date: 2018-05-31), 10-Q (reporting date: 2018-02-28), 10-Q (reporting date: 2017-11-30), 10-K (reporting date: 2017-08-31), 10-Q (reporting date: 2017-05-31), 10-Q (reporting date: 2017-02-28), 10-Q (reporting date: 2016-11-30), 10-K (reporting date: 2016-08-31), 10-Q (reporting date: 2016-05-31), 10-Q (reporting date: 2016-02-29), 10-Q (reporting date: 2015-11-30), 10-K (reporting date: 2015-08-31), 10-Q (reporting date: 2015-05-31), 10-Q (reporting date: 2015-02-28), 10-Q (reporting date: 2014-11-30), 10-K (reporting date: 2014-08-31), 10-Q (reporting date: 2014-05-31), 10-Q (reporting date: 2014-02-28), 10-Q (reporting date: 2013-11-30).
1 Q3 2020 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 19.87 = 18
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. |
Operating Cycle
Walgreens Boots Alliance Inc., operating cycle calculation (quarterly data)
No. days
| May 31, 2020 | Feb 29, 2020 | Nov 30, 2019 | Aug 31, 2019 | May 31, 2019 | Feb 28, 2019 | Nov 30, 2018 | Aug 31, 2018 | May 31, 2018 | Feb 28, 2018 | Nov 30, 2017 | Aug 31, 2017 | May 31, 2017 | Feb 28, 2017 | Nov 30, 2016 | Aug 31, 2016 | May 31, 2016 | Feb 29, 2016 | Nov 30, 2015 | Aug 31, 2015 | May 31, 2015 | Feb 28, 2015 | Nov 30, 2014 | Aug 31, 2014 | May 31, 2014 | Feb 28, 2014 | Nov 30, 2013 | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||||||||||||||||||||||||||||||
| Average inventory processing period | 32 | 32 | 36 | 32 | 34 | 35 | 39 | 35 | 37 | 40 | 40 | 36 | 36 | 39 | 42 | 37 | 37 | 38 | 43 | 41 | 46 | 56 | 43 | 40 | — | — | — | ||||||||
| Average receivable collection period | 18 | 20 | 20 | 19 | 19 | 21 | 19 | 18 | 20 | 21 | 21 | 20 | 20 | 18 | 19 | 19 | 20 | 21 | 22 | 24 | 27 | 30 | 17 | 15 | — | — | — | ||||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||||||||
| Operating cycle1 | 50 | 52 | 56 | 51 | 53 | 56 | 58 | 53 | 57 | 61 | 61 | 56 | 56 | 57 | 61 | 56 | 57 | 59 | 65 | 65 | 73 | 86 | 60 | 55 | — | — | — | ||||||||
| Benchmarks | |||||||||||||||||||||||||||||||||||
| Operating Cycle, Competitors2 | |||||||||||||||||||||||||||||||||||
| Costco Wholesale Corp. | 32 | 36 | 41 | 35 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Walmart Inc. | 52 | 45 | 46 | 46 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Based on: 10-Q (reporting date: 2020-05-31), 10-Q (reporting date: 2020-02-29), 10-Q (reporting date: 2019-11-30), 10-K (reporting date: 2019-08-31), 10-Q (reporting date: 2019-05-31), 10-Q (reporting date: 2019-02-28), 10-Q (reporting date: 2018-11-30), 10-K (reporting date: 2018-08-31), 10-Q (reporting date: 2018-05-31), 10-Q (reporting date: 2018-02-28), 10-Q (reporting date: 2017-11-30), 10-K (reporting date: 2017-08-31), 10-Q (reporting date: 2017-05-31), 10-Q (reporting date: 2017-02-28), 10-Q (reporting date: 2016-11-30), 10-K (reporting date: 2016-08-31), 10-Q (reporting date: 2016-05-31), 10-Q (reporting date: 2016-02-29), 10-Q (reporting date: 2015-11-30), 10-K (reporting date: 2015-08-31), 10-Q (reporting date: 2015-05-31), 10-Q (reporting date: 2015-02-28), 10-Q (reporting date: 2014-11-30), 10-K (reporting date: 2014-08-31), 10-Q (reporting date: 2014-05-31), 10-Q (reporting date: 2014-02-28), 10-Q (reporting date: 2013-11-30).
1 Q3 2020 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= 32 + 18 = 50
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. | Walgreens Boots Alliance Inc. operating cycle improved from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020. |
Average Payables Payment Period
Walgreens Boots Alliance Inc., average payables payment period calculation (quarterly data)
| May 31, 2020 | Feb 29, 2020 | Nov 30, 2019 | Aug 31, 2019 | May 31, 2019 | Feb 28, 2019 | Nov 30, 2018 | Aug 31, 2018 | May 31, 2018 | Feb 28, 2018 | Nov 30, 2017 | Aug 31, 2017 | May 31, 2017 | Feb 28, 2017 | Nov 30, 2016 | Aug 31, 2016 | May 31, 2016 | Feb 29, 2016 | Nov 30, 2015 | Aug 31, 2015 | May 31, 2015 | Feb 28, 2015 | Nov 30, 2014 | Aug 31, 2014 | May 31, 2014 | Feb 28, 2014 | Nov 30, 2013 | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||||||||||||||||||||||||||||||
| Payables turnover | 7.86 | 7.30 | 6.99 | 7.45 | 7.50 | 7.34 | 7.06 | 7.43 | 7.46 | 7.08 | 6.71 | 7.13 | 7.61 | 7.71 | 7.67 | 7.95 | 8.44 | 8.76 | 7.88 | 7.59 | 6.95 | 5.99 | 10.77 | 12.71 | — | — | — | ||||||||
| Short-term Activity Ratio (no. days) | |||||||||||||||||||||||||||||||||||
| Average payables payment period1 | 46 | 50 | 52 | 49 | 49 | 50 | 52 | 49 | 49 | 52 | 54 | 51 | 48 | 47 | 48 | 46 | 43 | 42 | 46 | 48 | 53 | 61 | 34 | 29 | — | — | — | ||||||||
| Benchmarks (no. days) | |||||||||||||||||||||||||||||||||||
| Average Payables Payment Period, Competitors2 | |||||||||||||||||||||||||||||||||||
| Costco Wholesale Corp. | 28 | 29 | 39 | 32 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Dollar General Corp. | 55 | 54 | 49 | 49 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Target Corp. | 75 | 62 | 57 | 67 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Walmart Inc. | 46 | 43 | 43 | 45 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Based on: 10-Q (reporting date: 2020-05-31), 10-Q (reporting date: 2020-02-29), 10-Q (reporting date: 2019-11-30), 10-K (reporting date: 2019-08-31), 10-Q (reporting date: 2019-05-31), 10-Q (reporting date: 2019-02-28), 10-Q (reporting date: 2018-11-30), 10-K (reporting date: 2018-08-31), 10-Q (reporting date: 2018-05-31), 10-Q (reporting date: 2018-02-28), 10-Q (reporting date: 2017-11-30), 10-K (reporting date: 2017-08-31), 10-Q (reporting date: 2017-05-31), 10-Q (reporting date: 2017-02-28), 10-Q (reporting date: 2016-11-30), 10-K (reporting date: 2016-08-31), 10-Q (reporting date: 2016-05-31), 10-Q (reporting date: 2016-02-29), 10-Q (reporting date: 2015-11-30), 10-K (reporting date: 2015-08-31), 10-Q (reporting date: 2015-05-31), 10-Q (reporting date: 2015-02-28), 10-Q (reporting date: 2014-11-30), 10-K (reporting date: 2014-08-31), 10-Q (reporting date: 2014-05-31), 10-Q (reporting date: 2014-02-28), 10-Q (reporting date: 2013-11-30).
1 Q3 2020 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 7.86 = 46
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. | Walgreens Boots Alliance Inc. number of days of payables outstanding decreased from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020. |
Cash Conversion Cycle
Walgreens Boots Alliance Inc., cash conversion cycle calculation (quarterly data)
No. days
| May 31, 2020 | Feb 29, 2020 | Nov 30, 2019 | Aug 31, 2019 | May 31, 2019 | Feb 28, 2019 | Nov 30, 2018 | Aug 31, 2018 | May 31, 2018 | Feb 28, 2018 | Nov 30, 2017 | Aug 31, 2017 | May 31, 2017 | Feb 28, 2017 | Nov 30, 2016 | Aug 31, 2016 | May 31, 2016 | Feb 29, 2016 | Nov 30, 2015 | Aug 31, 2015 | May 31, 2015 | Feb 28, 2015 | Nov 30, 2014 | Aug 31, 2014 | May 31, 2014 | Feb 28, 2014 | Nov 30, 2013 | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||||||||||||||||||||||||||||||
| Average inventory processing period | 32 | 32 | 36 | 32 | 34 | 35 | 39 | 35 | 37 | 40 | 40 | 36 | 36 | 39 | 42 | 37 | 37 | 38 | 43 | 41 | 46 | 56 | 43 | 40 | — | — | — | ||||||||
| Average receivable collection period | 18 | 20 | 20 | 19 | 19 | 21 | 19 | 18 | 20 | 21 | 21 | 20 | 20 | 18 | 19 | 19 | 20 | 21 | 22 | 24 | 27 | 30 | 17 | 15 | — | — | — | ||||||||
| Average payables payment period | 46 | 50 | 52 | 49 | 49 | 50 | 52 | 49 | 49 | 52 | 54 | 51 | 48 | 47 | 48 | 46 | 43 | 42 | 46 | 48 | 53 | 61 | 34 | 29 | — | — | — | ||||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||||||||
| Cash conversion cycle1 | 4 | 2 | 4 | 2 | 4 | 6 | 6 | 4 | 8 | 9 | 7 | 5 | 8 | 10 | 13 | 10 | 14 | 17 | 19 | 17 | 20 | 25 | 26 | 26 | — | — | — | ||||||||
| Benchmarks | |||||||||||||||||||||||||||||||||||
| Cash Conversion Cycle, Competitors2 | |||||||||||||||||||||||||||||||||||
| Costco Wholesale Corp. | 4 | 7 | 2 | 3 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Walmart Inc. | 6 | 2 | 3 | 1 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Based on: 10-Q (reporting date: 2020-05-31), 10-Q (reporting date: 2020-02-29), 10-Q (reporting date: 2019-11-30), 10-K (reporting date: 2019-08-31), 10-Q (reporting date: 2019-05-31), 10-Q (reporting date: 2019-02-28), 10-Q (reporting date: 2018-11-30), 10-K (reporting date: 2018-08-31), 10-Q (reporting date: 2018-05-31), 10-Q (reporting date: 2018-02-28), 10-Q (reporting date: 2017-11-30), 10-K (reporting date: 2017-08-31), 10-Q (reporting date: 2017-05-31), 10-Q (reporting date: 2017-02-28), 10-Q (reporting date: 2016-11-30), 10-K (reporting date: 2016-08-31), 10-Q (reporting date: 2016-05-31), 10-Q (reporting date: 2016-02-29), 10-Q (reporting date: 2015-11-30), 10-K (reporting date: 2015-08-31), 10-Q (reporting date: 2015-05-31), 10-Q (reporting date: 2015-02-28), 10-Q (reporting date: 2014-11-30), 10-K (reporting date: 2014-08-31), 10-Q (reporting date: 2014-05-31), 10-Q (reporting date: 2014-02-28), 10-Q (reporting date: 2013-11-30).
1 Q3 2020 Calculation
Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= 32 + 18 – 46 = 4
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. |