Microsoft Excel LibreOffice Calc

Walgreens Boots Alliance Inc. (WBA)

Analysis of Long-term (Investment) Activity Ratios
Quarterly Data

Difficulty: Beginner

Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.

Long-term Activity Ratios (Summary)

Walgreens Boots Alliance Inc., long-term (investment) activity ratios (quarterly data)

Microsoft Excel LibreOffice Calc
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 Aug 31, 2013 May 31, 2013 Feb 28, 2013 Nov 30, 2012
Net fixed asset turnover 9.94 9.84 9.74 9.46 9.20 8.83 8.80 8.67 8.62 8.58 8.52 8.19 8.09 8.01 7.59 6.87 6.17 5.41 6.41 6.23 6.23 6.11 5.93 5.95 — — —
Total asset turnover 1.99 1.93 1.92 1.93 1.83 1.75 1.81 1.79 1.57 1.60 1.62 1.61 1.74 1.76 1.64 1.50 1.33 1.19 1.60 2.05 2.01 2.00 2.01 2.04 — — —
Equity turnover 5.65 5.49 5.26 5.06 4.62 4.53 4.65 4.30 3.81 3.86 3.98 3.93 3.80 3.95 3.68 3.35 2.98 2.75 3.76 3.73 3.51 3.57 3.66 3.71 — — —

Based on: 10-Q (filing date: 2019-06-27), 10-Q (filing date: 2019-04-02), 10-Q (filing date: 2018-12-20), 10-K (filing date: 2018-10-11), 10-Q (filing date: 2018-06-28), 10-Q (filing date: 2018-03-28), 10-Q (filing date: 2018-01-04), 10-K (filing date: 2017-10-25), 10-Q (filing date: 2017-06-29), 10-Q (filing date: 2017-04-05), 10-Q (filing date: 2017-01-05), 10-K (filing date: 2016-10-20), 10-Q (filing date: 2016-07-06), 10-Q (filing date: 2016-04-05), 10-Q (filing date: 2016-01-07), 10-K (filing date: 2015-10-28), 10-Q (filing date: 2015-07-09), 10-Q (filing date: 2015-04-09), 10-Q (filing date: 2014-12-30), 10-K (filing date: 2014-10-20), 10-Q (filing date: 2014-07-01), 10-Q (filing date: 2014-03-27), 10-Q (filing date: 2013-12-27), 10-K (filing date: 2013-10-21), 10-Q (filing date: 2013-06-28), 10-Q (filing date: 2013-03-25), 10-Q (filing date: 2012-12-28).

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets.
Total asset turnover An activity ratio calculated as total revenue divided by total assets.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity.

Net Fixed Asset Turnover

Walgreens Boots Alliance Inc., net fixed asset turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Aug 31, 2013 May 31, 2013 Feb 28, 2013 Nov 30, 2012
Selected Financial Data (US$ in millions)
Sales 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  17,941  18,313  18,647  17,316 
Property, plant and equipment, net 13,717  13,828  13,821  13,911  13,938  14,045  13,693  13,642  13,535  13,528  13,709  14,335  14,493  14,552  14,878  15,068  15,241  15,646  12,103  12,257  12,088  12,136  12,351  12,138  12,075  12,048  12,110 
Long-term Activity Ratio
Net fixed asset turnover1 9.94 9.84 9.74 9.46 9.20 8.83 8.80 8.67 8.62 8.58 8.52 8.19 8.09 8.01 7.59 6.87 6.17 5.41 6.41 6.23 6.23 6.11 5.93 5.95 — — —
Benchmarks
Net Fixed Asset Turnover, Competitors2
CVS Health Corp. — 19.69 18.47 17.09 18.05 18.24 18.33 17.95 18.39 17.95 17.78 17.45 17.44 16.70 16.24 15.55 15.72 16.14 16.12 15.76 — — — — — — —

Based on: 10-Q (filing date: 2019-06-27), 10-Q (filing date: 2019-04-02), 10-Q (filing date: 2018-12-20), 10-K (filing date: 2018-10-11), 10-Q (filing date: 2018-06-28), 10-Q (filing date: 2018-03-28), 10-Q (filing date: 2018-01-04), 10-K (filing date: 2017-10-25), 10-Q (filing date: 2017-06-29), 10-Q (filing date: 2017-04-05), 10-Q (filing date: 2017-01-05), 10-K (filing date: 2016-10-20), 10-Q (filing date: 2016-07-06), 10-Q (filing date: 2016-04-05), 10-Q (filing date: 2016-01-07), 10-K (filing date: 2015-10-28), 10-Q (filing date: 2015-07-09), 10-Q (filing date: 2015-04-09), 10-Q (filing date: 2014-12-30), 10-K (filing date: 2014-10-20), 10-Q (filing date: 2014-07-01), 10-Q (filing date: 2014-03-27), 10-Q (filing date: 2013-12-27), 10-K (filing date: 2013-10-21), 10-Q (filing date: 2013-06-28), 10-Q (filing date: 2013-03-25), 10-Q (filing date: 2012-12-28).

1 Q3 2019 Calculation
Net fixed asset turnover = (SalesQ3 2019 + SalesQ2 2019 + SalesQ1 2019 + SalesQ4 2018) ÷ Property, plant and equipment, net
= (34,591 + 34,528 + 33,793 + 33,442) ÷ 13,717 = 9.94

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets.

Total Asset Turnover

Walgreens Boots Alliance Inc., total asset turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Aug 31, 2013 May 31, 2013 Feb 28, 2013 Nov 30, 2012
Selected Financial Data (US$ in millions)
Sales 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  17,941  18,313  18,647  17,316 
Total assets 68,586  70,434  69,941  68,124  70,152  70,816  66,618  66,009  74,173  72,505  71,912  72,688  67,333  66,385  68,657  68,782  70,644  71,357  48,612  37,182  37,391  37,081  36,481  35,481  35,841  35,564  35,259 
Long-term Activity Ratio
Total asset turnover1 1.99 1.93 1.92 1.93 1.83 1.75 1.81 1.79 1.57 1.60 1.62 1.61 1.74 1.76 1.64 1.50 1.33 1.19 1.60 2.05 2.01 2.00 2.01 2.04 — — —
Benchmarks
Total Asset Turnover, Competitors2
CVS Health Corp. — 1.03 0.95 0.99 1.43 1.40 1.38 1.94 1.96 1.95 1.93 1.88 1.83 1.80 1.73 1.64 1.62 1.95 1.93 1.88 — — — — — — —

Based on: 10-Q (filing date: 2019-06-27), 10-Q (filing date: 2019-04-02), 10-Q (filing date: 2018-12-20), 10-K (filing date: 2018-10-11), 10-Q (filing date: 2018-06-28), 10-Q (filing date: 2018-03-28), 10-Q (filing date: 2018-01-04), 10-K (filing date: 2017-10-25), 10-Q (filing date: 2017-06-29), 10-Q (filing date: 2017-04-05), 10-Q (filing date: 2017-01-05), 10-K (filing date: 2016-10-20), 10-Q (filing date: 2016-07-06), 10-Q (filing date: 2016-04-05), 10-Q (filing date: 2016-01-07), 10-K (filing date: 2015-10-28), 10-Q (filing date: 2015-07-09), 10-Q (filing date: 2015-04-09), 10-Q (filing date: 2014-12-30), 10-K (filing date: 2014-10-20), 10-Q (filing date: 2014-07-01), 10-Q (filing date: 2014-03-27), 10-Q (filing date: 2013-12-27), 10-K (filing date: 2013-10-21), 10-Q (filing date: 2013-06-28), 10-Q (filing date: 2013-03-25), 10-Q (filing date: 2012-12-28).

1 Q3 2019 Calculation
Total asset turnover = (SalesQ3 2019 + SalesQ2 2019 + SalesQ1 2019 + SalesQ4 2018) ÷ Total assets
= (34,591 + 34,528 + 33,793 + 33,442) ÷ 68,586 = 1.99

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets.

Equity Turnover

Walgreens Boots Alliance Inc., equity turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Aug 31, 2013 May 31, 2013 Feb 28, 2013 Nov 30, 2012
Selected Financial Data (US$ in millions)
Sales 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  17,941  18,313  18,647  17,316 
Total Walgreens Boots Alliance, Inc. shareholders’ equity 24,133  24,770  25,609  26,007  27,736  27,355  25,929  27,466  30,600  30,067  29,325  29,880  30,881  29,506  30,709  30,861  31,563  30,814  20,636  20,457  21,417  20,784  20,021  19,454  18,980  18,973  18,379 
Long-term Activity Ratio
Equity turnover1 5.65 5.49 5.26 5.06 4.62 4.53 4.65 4.30 3.81 3.86 3.98 3.93 3.80 3.95 3.68 3.35 2.98 2.75 3.76 3.73 3.51 3.57 3.66 3.71 — — —
Benchmarks
Equity Turnover, Competitors2
CVS Health Corp. — 3.69 3.51 3.33 5.14 5.25 4.81 4.90 5.23 5.30 5.28 4.82 4.80 4.80 4.45 4.12 4.01 3.92 3.87 3.67 — — — — — — —

Based on: 10-Q (filing date: 2019-06-27), 10-Q (filing date: 2019-04-02), 10-Q (filing date: 2018-12-20), 10-K (filing date: 2018-10-11), 10-Q (filing date: 2018-06-28), 10-Q (filing date: 2018-03-28), 10-Q (filing date: 2018-01-04), 10-K (filing date: 2017-10-25), 10-Q (filing date: 2017-06-29), 10-Q (filing date: 2017-04-05), 10-Q (filing date: 2017-01-05), 10-K (filing date: 2016-10-20), 10-Q (filing date: 2016-07-06), 10-Q (filing date: 2016-04-05), 10-Q (filing date: 2016-01-07), 10-K (filing date: 2015-10-28), 10-Q (filing date: 2015-07-09), 10-Q (filing date: 2015-04-09), 10-Q (filing date: 2014-12-30), 10-K (filing date: 2014-10-20), 10-Q (filing date: 2014-07-01), 10-Q (filing date: 2014-03-27), 10-Q (filing date: 2013-12-27), 10-K (filing date: 2013-10-21), 10-Q (filing date: 2013-06-28), 10-Q (filing date: 2013-03-25), 10-Q (filing date: 2012-12-28).

1 Q3 2019 Calculation
Equity turnover = (SalesQ3 2019 + SalesQ2 2019 + SalesQ1 2019 + SalesQ4 2018) ÷ Total Walgreens Boots Alliance, Inc. shareholders’ equity
= (34,591 + 34,528 + 33,793 + 33,442) ÷ 24,133 = 5.65

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity.