Stock Analysis on Net

Walgreens Boots Alliance Inc. (NASDAQ:WBA)

$22.49

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

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

Microsoft Excel

Paying user area

The data is hidden behind: . Unhide it.

This is a one-time payment. There is no automatic renewal.


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Google Pay
Visa Secure Mastercard Identity Check American Express SafeKey

Long-term Activity Ratios (Summary)

Walgreens Boots Alliance Inc., long-term (investment) 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
Net fixed asset turnover
Net fixed asset turnover (including operating lease, right-of-use asset)
Total asset turnover
Equity turnover

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).


The financial ratios demonstrate notable trends over the examined periods. The Net Fixed Asset Turnover ratio shows a consistent upward trajectory from 6.41 to a peak above 10.00 by the end of 2019, indicating increasingly efficient use of fixed assets to generate sales. However, when including operating lease right-of-use assets, the ratio experiences a sharp decline starting in early 2020, dropping from above 10.00 to around 4.00, which may reflect accounting changes or asset reclassification related to lease accounting standards.

The Total Asset Turnover ratio exhibits moderate fluctuations but generally trends upwards from approximately 1.60 to slightly above 2.00 during most of the periods observed. A noticeable dip occurs in early 2020, reducing the ratio to around 1.50, which suggests a decline in overall asset utilization efficiency during that time frame.

Equity Turnover steadily increases across the timeline, moving from near 3.76 to nearly 6.70 at the latest date. This consistent rise suggests improved efficiency in using shareholders' equity to generate revenue, reflecting positive operational or financial management trends.

Net Fixed Asset Turnover
Displays a robust increasing trend until the end of 2019, implying enhanced efficiency in generating sales from fixed assets.
The inclusion of right-of-use assets under new lease accounting significantly decreases this ratio in 2020, indicating changes in asset base or reporting standards rather than operational decline.
Total Asset Turnover
Shows moderate growth over time but reveals a downturn in early 2020, potentially reflecting lower asset use effectiveness during that period.
Equity Turnover
Consistently rises over the reported periods, indicating efficient utilization of equity to produce revenue and a strengthening in financial performance metrics related to equity usage.

Net Fixed Asset Turnover

Walgreens Boots Alliance Inc., net fixed asset 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
Selected Financial Data (US$ in millions)
Sales
Property, plant and equipment, net
Long-term Activity Ratio
Net fixed asset turnover1
Benchmarks
Net Fixed Asset Turnover, Competitors2
Costco Wholesale Corp.
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).

1 Q3 2020 Calculation
Net fixed asset turnover = (SalesQ3 2020 + SalesQ2 2020 + SalesQ1 2020 + SalesQ4 2019) ÷ Property, plant and equipment, net
= ( + + + ) ÷ =

2 Click competitor name to see calculations.


The analysis of financial metrics over the reported periods reveals several notable trends. Sales demonstrate a general upward trajectory from late 2014 through early 2020, despite minor fluctuations in some quarters. Starting at approximately 19.6 billion USD, sales increased substantially, peaking near 35.8 billion USD in early 2020, indicating consistent growth in revenue generation over the analyzed time span.

In contrast, net property, plant, and equipment (PP&E) exhibits a declining trend over the same timeframe. The net value of fixed assets decreased from around 12.1 billion USD in late 2014 to approximately 13 billion USD by mid-2020, with some periods showing incremental decreases. This downward progression suggests ongoing depreciation or asset disposals without commensurate capital expenditures to increase net asset base materially.

The net fixed asset turnover ratio, which measures efficiency by comparing sales to net PP&E, showed a steady increase during the analyzed periods. Initially recorded at 6.41, this ratio rose progressively to exceed 10 by mid-2020. This improvement indicates enhanced utilization of fixed assets in generating sales revenue, reflecting improved operational efficiency or better asset management strategies over time.

Sales
Consistent growth with minor quarterly fluctuations, increasing from about 19.6 billion USD to nearly 35.8 billion USD, suggesting expanding business activities and revenue.
Property, Plant, and Equipment, Net
Gradual decline from approximately 12.1 billion USD to near 13 billion USD, indicating depreciation and reduced net fixed asset investment.
Net Fixed Asset Turnover
Steady increase from 6.41 to over 10, reflecting improved efficiency in using fixed assets to generate revenue.

Overall, the data points toward a company enhancing its sales performance significantly while managing to improve asset efficiency despite a declining net fixed asset base. The rising fixed asset turnover ratio is a positive indicator of operational effectiveness, potentially implying effective cost control or asset divestment strategies aligned with revenue growth.


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
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
Selected Financial Data (US$ in millions)
Sales
 
Property, plant and equipment, net
Operating lease right-of-use assets
Property, plant and equipment, net (including operating lease, right-of-use asset)
Long-term Activity Ratio
Net fixed asset turnover (including operating lease, right-of-use asset)1
Benchmarks
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Competitors2
Costco Wholesale Corp.
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).

1 Q3 2020 Calculation
Net fixed asset turnover (including operating lease, right-of-use asset) = (SalesQ3 2020 + SalesQ2 2020 + SalesQ1 2020 + SalesQ4 2019) ÷ Property, plant and equipment, net (including operating lease, right-of-use asset)
= ( + + + ) ÷ =

2 Click competitor name to see calculations.


The financial data demonstrates several notable trends across the analyzed periods for the company.

Sales
Sales figures exhibit an overall upward trend with fluctuations. Starting at approximately $19.6 billion, sales increased steadily reaching a peak around $35.8 billion in February 2020. Occasional minor declines are observed but the general trajectory shows growth in sales revenue over the periods.
Property, Plant and Equipment, Net (including operating lease, right-of-use asset)
The net value of property, plant, and equipment shows a notable downward trend from roughly $12.1 billion to about $13.5 billion throughout most quarters until February 2020. However, there is a significant and abrupt increase in this asset category in the later periods, rising sharply above $35 billion and then slightly declining again. This likely reflects an accounting adjustment or acquisition impacting asset base in the last quarters analyzed.
Net Fixed Asset Turnover (including operating lease, right-of-use asset)
The net fixed asset turnover ratio, which measures sales generated per dollar of net fixed assets, shows an increasing trend from 6.41 to over 10 up to November 2019, indicating improved efficiency in asset utilization. However, this ratio drops sharply to values near 4 in the final three periods, likely correlated to the aforementioned sudden increase in asset base without a proportional rise in sales, signaling a temporary dip in asset turnover efficiency.

Overall, the company experienced steady growth in sales alongside improvements in asset turnover efficiency for most of the time frame. The late-period surge in asset values combined with declining turnover ratios suggests a significant shift in asset composition or accounting treatment, which warrants further analysis to understand its implications on operational performance.


Total Asset Turnover

Walgreens Boots Alliance Inc., total asset 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
Selected Financial Data (US$ in millions)
Sales
Total assets
Long-term Activity Ratio
Total asset turnover1
Benchmarks
Total Asset Turnover, Competitors2
Costco Wholesale Corp.
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).

1 Q3 2020 Calculation
Total asset turnover = (SalesQ3 2020 + SalesQ2 2020 + SalesQ1 2020 + SalesQ4 2019) ÷ Total assets
= ( + + + ) ÷ =

2 Click competitor name to see calculations.


Sales Trend
The sales figures exhibit a generally increasing trend over the analyzed timeframe, starting from approximately $19.6 billion and reaching over $34.6 billion by the latest quarter. This growth is fairly consistent, with periodic fluctuations but no significant declines. The most notable rise occurs between early 2018 and early 2019, where sales increased from roughly $33 billion to $34.5 billion. After a mild dip in late 2019, sales rebounded and remained robust through mid-2020.
Total Assets Movement
Total assets show substantial variability throughout the periods. Initially, there is a considerable jump from approximately $48.6 billion to over $71 billion. Following this peak, asset levels fluctuate but generally maintain a range between $66 billion and $72 billion until early 2020, at which point there is a marked spike exceeding $90 billion, before slightly decreasing towards mid-2020. These shifts suggest notable asset acquisitions or disposals, with the substantial increase early in 2020 indicating a significant change in the asset base.
Total Asset Turnover Analysis
The total asset turnover ratio experiences some volatility but generally trends upward from around 1.6 to a peak of approximately 2.02 between 2018 and 2019, indicating improved efficiency in generating sales relative to asset size during that period. However, in the most recent quarters, the ratio declines noticeably to values near 1.5 to 1.6, which may reflect the large increase in assets diluting turnover efficiency or a relative slowing of sales growth against asset expansion.
Combined Insights
The data demonstrate a company expanding its asset base significantly while achieving steady sales growth. The increasing asset turnover ratio until 2019 suggests effective utilization of assets to drive sales growth. The sharp asset increase in early 2020, coupled with stable sales, results in decreased asset turnover, which could signal an adjustment period following asset acquisitions or investments. Monitoring future periods will be critical to assess whether sales will grow proportionately to recent asset expansions to restore efficiency metrics.

Equity Turnover

Walgreens Boots Alliance Inc., equity 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
Selected Financial Data (US$ in millions)
Sales
Total Walgreens Boots Alliance, Inc. shareholders’ equity
Long-term Activity Ratio
Equity turnover1
Benchmarks
Equity Turnover, Competitors2
Costco Wholesale Corp.
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).

1 Q3 2020 Calculation
Equity turnover = (SalesQ3 2020 + SalesQ2 2020 + SalesQ1 2020 + SalesQ4 2019) ÷ Total Walgreens Boots Alliance, Inc. shareholders’ equity
= ( + + + ) ÷ =

2 Click competitor name to see calculations.


The financial data reveals distinct trends in sales, shareholders’ equity, and equity turnover ratios over the observed periods.

Sales
Sales figures demonstrate an overall upward trajectory with fluctuations across the quarters. Initial values range from approximately 19,554 million US dollars to peaks surpassing 34,000 million US dollars in later quarters. There is notable growth particularly from early 2018 to early 2020, where sales increased from around 33,000 million to as high as 35,820 million US dollars. Despite some volatility, sales maintain a generally increasing pattern, signifying expansion in revenue generation.
Total Shareholders’ Equity
Shareholders' equity displays a declining trend over most of the period reviewed. Starting from about 30,814 million US dollars in early 2015, the equity consistently decreases to approximately 20,736 million US dollars by mid-2020. This reduction in equity suggests potential increases in liabilities, share repurchases, dividend payments, or losses impacting retained earnings. The decline is steady and pronounced, indicating a contraction in the net asset base supporting the company over time.
Equity Turnover Ratio
The equity turnover ratio shows a strong increasing trend. Early periods register values around 2.75 to 3.95, rising progressively to 6.69 by mid-2020. This increase signifies improved efficiency in utilizing shareholders' equity to generate sales, with the ratio nearly doubling over the timeline. As sales grow while shareholders’ equity declines, the company becomes more leveraged or efficient in deploying its equity base.

In summary, the data indicates robust sales growth accompanied by a steady decline in shareholders’ equity, resulting in a significant increase in equity turnover. This combination suggests that the company is generating higher revenue with a smaller equity base, which could reflect strategic financial management, increased financial leverage, or operational enhancements. Careful attention should be given to the declining equity to understand underlying causes and potential risks.