Stock Analysis on Net

Walgreens Boots Alliance Inc. (NASDAQ:WBA)

This company has been moved to the archive! The financial data has not been updated since July 9, 2020.

Analysis of Short-term (Operating) Activity Ratios
Quarterly Data

Microsoft Excel

Short-term Activity Ratios (Summary)

Walgreens Boots Alliance Inc., short-term (operating) activity ratios (quarterly data)

Microsoft Excel
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
Turnover Ratios
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
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
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
Working capital turnover 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
Average No. Days
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
Add: 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
Operating cycle 50 52 56 51 53 56 58 53 57 61 61 56 56 57 61 56 57 59 65 65 73 86 60 55
Less: 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
Cash conversion cycle 4 2 4 2 4 6 6 4 8 9 7 5 8 10 13 10 14 17 19 17 20 25 26 26

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)

Microsoft Excel
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 11.52 11.28 10.34 11.16
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)

Microsoft Excel
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 85.87 72.17 78.90 82.94
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)

Microsoft Excel
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 11.49 11.96 9.61 10.96
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)

Microsoft Excel
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 294.44 381.36
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)

Microsoft Excel
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 32 32 35 33
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)

Microsoft Excel
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 4 5 5 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

Microsoft Excel
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 36 37 40 37
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)

Microsoft Excel
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 32 31 38 33
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

Microsoft Excel
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 4 6 2 4
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 + 1846 = 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.