Microsoft Excel LibreOffice Calc

Walgreens Boots Alliance Inc. (WBA)


Analysis of Long-term (Investment) Activity Ratios

Beginner level

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

Microsoft Excel LibreOffice Calc
Aug 31, 2019 Aug 31, 2018 Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014
Net fixed asset turnover 10.15 9.46 8.67 8.19 6.87 6.23
Total asset turnover 2.02 1.93 1.79 1.61 1.50 2.05
Equity turnover 5.82 5.06 4.30 3.93 3.35 3.73

Based on: 10-K (filing date: 2019-10-28), 10-K (filing date: 2018-10-11), 10-K (filing date: 2017-10-25), 10-K (filing date: 2016-10-20), 10-K (filing date: 2015-10-28), 10-K (filing date: 2014-10-20).

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 improved from 2017 to 2018 and from 2018 to 2019.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Walgreens Boots Alliance Inc.’s total asset turnover ratio improved from 2017 to 2018 and from 2018 to 2019.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Walgreens Boots Alliance Inc.’s equity turnover ratio improved from 2017 to 2018 and from 2018 to 2019.

Net Fixed Asset Turnover

Walgreens Boots Alliance Inc., net fixed asset turnover calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Aug 31, 2019 Aug 31, 2018 Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014
Selected Financial Data (US$ in millions)
Sales 136,866  131,537  118,214  117,351  103,444  76,392 
Property, plant and equipment, net 13,478  13,911  13,642  14,335  15,068  12,257 
Long-term Activity Ratio
Net fixed asset turnover1 10.15 9.46 8.67 8.19 6.87 6.23
Benchmarks
Net Fixed Asset Turnover, Competitors2
CVS Health Corp. 17.09 17.95 17.45 15.55 15.76
Net Fixed Asset Turnover, Sector
Food & Drug Retailers 12.88 12.66 12.03 10.30
Net Fixed Asset Turnover, Industry
Consumer Services 3.91 3.84 3.84 3.92

Based on: 10-K (filing date: 2019-10-28), 10-K (filing date: 2018-10-11), 10-K (filing date: 2017-10-25), 10-K (filing date: 2016-10-20), 10-K (filing date: 2015-10-28), 10-K (filing date: 2014-10-20).

1 2019 Calculation
Net fixed asset turnover = Sales ÷ Property, plant and equipment, net
= 136,866 ÷ 13,478 = 10.15

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 improved from 2017 to 2018 and from 2018 to 2019.

Total Asset Turnover

Walgreens Boots Alliance Inc., total asset turnover calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Aug 31, 2019 Aug 31, 2018 Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014
Selected Financial Data (US$ in millions)
Sales 136,866  131,537  118,214  117,351  103,444  76,392 
Total assets 67,598  68,124  66,009  72,688  68,782  37,182 
Long-term Activity Ratio
Total asset turnover1 2.02 1.93 1.79 1.61 1.50 2.05
Benchmarks
Total Asset Turnover, Competitors2
CVS Health Corp. 0.99 1.94 1.88 1.64 1.88
Total Asset Turnover, Sector
Food & Drug Retailers 1.23 1.88 1.76 1.58
Total Asset Turnover, Industry
Consumer Services 1.21 1.33 1.32 1.42

Based on: 10-K (filing date: 2019-10-28), 10-K (filing date: 2018-10-11), 10-K (filing date: 2017-10-25), 10-K (filing date: 2016-10-20), 10-K (filing date: 2015-10-28), 10-K (filing date: 2014-10-20).

1 2019 Calculation
Total asset turnover = Sales ÷ Total assets
= 136,866 ÷ 67,598 = 2.02

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 improved from 2017 to 2018 and from 2018 to 2019.

Equity Turnover

Walgreens Boots Alliance Inc., equity turnover calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Aug 31, 2019 Aug 31, 2018 Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014
Selected Financial Data (US$ in millions)
Sales 136,866  131,537  118,214  117,351  103,444  76,392 
Total Walgreens Boots Alliance, Inc. shareholders’ equity 23,512  26,007  27,466  29,880  30,861  20,457 
Long-term Activity Ratio
Equity turnover1 5.82 5.06 4.30 3.93 3.35 3.73
Benchmarks
Equity Turnover, Competitors2
CVS Health Corp. 3.33 4.90 4.82 4.12 3.67
Equity Turnover, Sector
Food & Drug Retailers 3.86 4.65 4.42 3.77
Equity Turnover, Industry
Consumer Services 4.26 4.26 4.11 4.29

Based on: 10-K (filing date: 2019-10-28), 10-K (filing date: 2018-10-11), 10-K (filing date: 2017-10-25), 10-K (filing date: 2016-10-20), 10-K (filing date: 2015-10-28), 10-K (filing date: 2014-10-20).

1 2019 Calculation
Equity turnover = Sales ÷ Total Walgreens Boots Alliance, Inc. shareholders’ equity
= 136,866 ÷ 23,512 = 5.82

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 improved from 2017 to 2018 and from 2018 to 2019.