Microsoft Excel LibreOffice Calc

Walgreens Boots Alliance Inc. (NASDAQ:WBA)


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

Beginner level


Long-term Activity Ratios (Summary)

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

Microsoft Excel LibreOffice Calc
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
Net fixed asset turnover 10.29 10.09 10.15 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
Net fixed asset turnover (including operating lease, right-of-use asset) 3.94 3.89 10.15 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
Total asset turnover 1.54 1.51 2.02 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
Equity turnover 5.85 5.81 5.82 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

Based on: 10-Q (filing date: 2020-04-02), 10-Q (filing date: 2020-01-08), 10-K (filing date: 2019-10-28), 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).

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Walgreens Boots Alliance Inc.’s net fixed asset turnover ratio deteriorated from Q4 2019 to Q1 2020 but then improved from Q1 2020 to Q2 2020 exceeding Q4 2019 level.
Net fixed asset turnover (including operating lease, right-of-use asset) An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). Walgreens Boots Alliance Inc.’s net fixed asset turnover ratio (with operating lease, right-of-use asset) deteriorated from Q4 2019 to Q1 2020 but then slightly improved from Q1 2020 to Q2 2020.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Walgreens Boots Alliance Inc.’s total asset turnover ratio deteriorated from Q4 2019 to Q1 2020 but then slightly improved from Q1 2020 to Q2 2020.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Walgreens Boots Alliance Inc.’s equity turnover ratio deteriorated from Q4 2019 to Q1 2020 but then improved from Q1 2020 to Q2 2020 exceeding Q4 2019 level.

Net Fixed Asset Turnover

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

Microsoft Excel LibreOffice Calc
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 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 
Property, plant and equipment, net 13,482  13,620  13,478  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 
Long-term Activity Ratio
Net fixed asset turnover1 10.29 10.09 10.15 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
Benchmarks
Net Fixed Asset Turnover, Competitors2
CVS Health Corp. 21.49 21.24 20.88 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

Based on: 10-Q (filing date: 2020-04-02), 10-Q (filing date: 2020-01-08), 10-K (filing date: 2019-10-28), 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).

1 Q2 2020 Calculation
Net fixed asset turnover = (SalesQ2 2020 + SalesQ1 2020 + SalesQ4 2019 + SalesQ3 2019) ÷ Property, plant and equipment, net
= (35,820 + 34,339 + 33,954 + 34,591) ÷ 13,482 = 10.29

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. Walgreens Boots Alliance Inc.’s net fixed asset turnover ratio deteriorated from Q4 2019 to Q1 2020 but then improved from Q1 2020 to Q2 2020 exceeding Q4 2019 level.

Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset)

Walgreens Boots Alliance Inc., net fixed asset turnover (including operating lease, right-of-use asset) calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 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 
 
Property, plant and equipment, net 13,482  13,620  13,478  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 
Operating lease right-of-use assets 21,755  21,674  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  — 
Property, plant and equipment, net (including operating lease, right-of-use asset) 35,237  35,294  13,478  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 
Long-term Activity Ratio
Net fixed asset turnover (including operating lease, right-of-use asset)1 3.94 3.89 10.15 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
Benchmarks
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Competitors2
CVS Health Corp. 7.95 7.77 7.51 6.99 6.48 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

Based on: 10-Q (filing date: 2020-04-02), 10-Q (filing date: 2020-01-08), 10-K (filing date: 2019-10-28), 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).

1 Q2 2020 Calculation
Net fixed asset turnover (including operating lease, right-of-use asset) = (SalesQ2 2020 + SalesQ1 2020 + SalesQ4 2019 + SalesQ3 2019) ÷ Property, plant and equipment, net (including operating lease, right-of-use asset)
= (35,820 + 34,339 + 33,954 + 34,591) ÷ 35,237 = 3.94

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover (including operating lease, right-of-use asset) An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). Walgreens Boots Alliance Inc.’s net fixed asset turnover ratio (with operating lease, right-of-use asset) deteriorated from Q4 2019 to Q1 2020 but then slightly improved from Q1 2020 to Q2 2020.

Total Asset Turnover

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

Microsoft Excel LibreOffice Calc
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 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 
Total assets 90,003  90,807  67,598  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 
Long-term Activity Ratio
Total asset turnover1 1.54 1.51 2.02 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
Benchmarks
Total Asset Turnover, Competitors2
CVS Health Corp. 1.13 1.15 1.11 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

Based on: 10-Q (filing date: 2020-04-02), 10-Q (filing date: 2020-01-08), 10-K (filing date: 2019-10-28), 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).

1 Q2 2020 Calculation
Total asset turnover = (SalesQ2 2020 + SalesQ1 2020 + SalesQ4 2019 + SalesQ3 2019) ÷ Total assets
= (35,820 + 34,339 + 33,954 + 34,591) ÷ 90,003 = 1.54

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. Walgreens Boots Alliance Inc.’s total asset turnover ratio deteriorated from Q4 2019 to Q1 2020 but then slightly improved from Q1 2020 to Q2 2020.

Equity Turnover

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

Microsoft Excel LibreOffice Calc
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 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 
Total Walgreens Boots Alliance, Inc. shareholders’ equity 23,720  23,661  23,512  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 
Long-term Activity Ratio
Equity turnover1 5.85 5.81 5.82 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
Benchmarks
Equity Turnover, Competitors2
CVS Health Corp. 4.01 4.00 3.89 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

Based on: 10-Q (filing date: 2020-04-02), 10-Q (filing date: 2020-01-08), 10-K (filing date: 2019-10-28), 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).

1 Q2 2020 Calculation
Equity turnover = (SalesQ2 2020 + SalesQ1 2020 + SalesQ4 2019 + SalesQ3 2019) ÷ Total Walgreens Boots Alliance, Inc. shareholders’ equity
= (35,820 + 34,339 + 33,954 + 34,591) ÷ 23,720 = 5.85

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. Walgreens Boots Alliance Inc.’s equity turnover ratio deteriorated from Q4 2019 to Q1 2020 but then improved from Q1 2020 to Q2 2020 exceeding Q4 2019 level.