AI Tokens
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.

DuPont Analysis: Disaggregation of ROE, ROA, and Net Profit Margin

Microsoft Excel

Two-Component Disaggregation of ROE

Walgreens Boots Alliance Inc., decomposition of ROE

Microsoft Excel
ROE = ROA × Financial Leverage
Aug 31, 2019 16.94% = 5.89% × 2.88
Aug 31, 2018 19.32% = 7.37% × 2.62
Aug 31, 2017 14.85% = 6.18% × 2.40
Aug 31, 2016 13.97% = 5.74% × 2.43
Aug 31, 2015 13.67% = 6.14% × 2.23
Aug 31, 2014 9.44% = 5.20% × 1.82

Based on: 10-K (reporting date: 2019-08-31), 10-K (reporting date: 2018-08-31), 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31).


The Return on Equity (ROE) exhibited a general upward trajectory between 2014 and 2019, rising from 9.44% to 16.94%, with a peak of 19.32% in 2018. This growth reflects a combined effect of asset utilization and an increasing reliance on financial leverage.

Return on Assets (ROA)
ROA demonstrated volatility throughout the period, beginning at 5.20% in 2014 and reaching a peak of 7.37% in 2018 before declining to 5.89% in 2019. While there was an overall improvement in the ability to generate earnings from assets compared to the 2014 baseline, the performance remained inconsistent, characterized by periodic fluctuations.
Financial Leverage
A consistent and steady increase in financial leverage is observed, moving from a ratio of 1.82 in 2014 to 2.88 in 2019. This indicates a strategic increase in the use of debt relative to equity to fund assets over the six-year window.
ROE Decomposition Analysis
The disaggregation of ROE reveals that the expansion of equity returns was driven more aggressively by financial leverage than by operational efficiency. Notably, in 2019, although ROA declined from 7.37% to 5.89%, the ROE only moderately decreased from 19.32% to 16.94%. This attenuation of the ROA decline was primarily due to the continued rise in the financial leverage ratio, which reached its period high of 2.88, thereby amplifying the returns to shareholders despite the weakening in asset performance.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
Without a user account, I tend to respond rather slowly.

How can I help you?


Three-Component Disaggregation of ROE

Walgreens Boots Alliance Inc., decomposition of ROE

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Aug 31, 2019 16.94% = 2.91% × 2.02 × 2.88
Aug 31, 2018 19.32% = 3.82% × 1.93 × 2.62
Aug 31, 2017 14.85% = 3.45% × 1.79 × 2.40
Aug 31, 2016 13.97% = 3.56% × 1.61 × 2.43
Aug 31, 2015 13.67% = 4.08% × 1.50 × 2.23
Aug 31, 2014 9.44% = 2.53% × 2.05 × 1.82

Based on: 10-K (reporting date: 2019-08-31), 10-K (reporting date: 2018-08-31), 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31).


The Return on Equity (ROE) exhibited a general upward trajectory from 2014 to 2018, rising from 9.44% to a peak of 19.32%, before experiencing a contraction to 16.94% in 2019. This overall movement suggests a period of expanding shareholder returns followed by a recent decline, driven by the varying contributions of profitability, efficiency, and solvency.

Net Profit Margin
Profitability demonstrated significant volatility over the six-year period. After an initial increase from 2.53% in 2014 to 4.08% in 2015, the margin entered a period of fluctuation, dipping to 3.45% by 2017 before a brief recovery to 3.82% in 2018. A notable decline occurred in 2019, with the margin falling to 2.91%, indicating a compression in bottom-line efficiency.
Asset Turnover
Operational efficiency saw a sharp decline in 2015, dropping from 2.05 to 1.50. However, a consistent recovery followed, with the ratio improving annually to reach 2.02 by 2019. This trend indicates a successful restoration of the company's ability to generate sales from its asset base, effectively returning to 2014 levels of efficiency.
Financial Leverage
A sustained and aggressive increase in financial leverage is observed, rising steadily from 1.82 in 2014 to 2.88 in 2019. This consistent upward trend indicates an increasing reliance on debt to finance assets, which served as a primary amplifier for the Return on Equity throughout the period.

The DuPont disaggregation reveals that the growth in ROE through 2018 was not primarily driven by margin expansion or asset efficiency, but rather by the systematic increase in financial leverage. While asset turnover recovered steadily, the 2019 decline in ROE is attributable to the contraction in Net Profit Margin, which offset the gains provided by improved asset turnover and continued leverage expansion.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
Without a user account, I tend to respond rather slowly.

How can I help you?


Five-Component Disaggregation of ROE

Walgreens Boots Alliance Inc., decomposition of ROE

Microsoft Excel
ROE = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Financial Leverage
Aug 31, 2019 16.94% = 0.87 × 0.87 × 3.85% × 2.02 × 2.88
Aug 31, 2018 19.32% = 0.83 × 0.91 × 5.05% × 1.93 × 2.62
Aug 31, 2017 14.85% = 0.84 × 0.87 × 4.68% × 1.79 × 2.40
Aug 31, 2016 13.97% = 0.81 × 0.90 × 4.91% × 1.61 × 2.43
Aug 31, 2015 13.67% = 0.80 × 0.90 × 5.69% × 1.50 × 2.23
Aug 31, 2014 9.44% = 0.56 × 0.96 × 4.73% × 2.05 × 1.82

Based on: 10-K (reporting date: 2019-08-31), 10-K (reporting date: 2018-08-31), 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31).


The Return on Equity (ROE) exhibited a general upward trajectory from 2014 to 2019, increasing from 9.44% to 16.94%, with a peak of 19.32% in 2018. This expansion in shareholder returns was primarily driven by aggressive increases in financial leverage and a significantly improved tax burden, which effectively offset a deterioration in operating margins.

Tax Burden
A consistent and substantial increase in the tax burden ratio is observed, rising from 0.56 in 2014 to 0.87 in 2019. This trend indicates a decrease in the effective tax rate over the period, allowing a greater proportion of operating earnings to be retained as net income.
Interest Burden
The interest burden remained relatively stable, though a slight downward trend is evident, moving from 0.96 in 2014 to 0.87 in 2019. This suggests a marginal increase in the proportion of operating income dedicated to servicing debt obligations.
EBIT Margin
Operating profitability experienced a decline, with the EBIT margin falling from 4.73% in 2014 to 3.85% in 2019. While a peak of 5.69% was reached in 2015, the overall trend points to a contraction in operational efficiency regarding the conversion of revenue into operating profit.
Asset Turnover
Asset utilization showed volatility but remained stable over the long term, beginning at 2.05 in 2014 and ending at 2.02 in 2019. A notable dip to 1.50 occurred in 2015, followed by a steady recovery, indicating that the efficiency of generating sales from the asset base was maintained.
Financial Leverage
A strong upward trend in financial leverage is noted, increasing from 1.82 in 2014 to 2.88 in 2019. This indicates a significant increase in the use of debt to finance assets, which served as a primary driver for the growth in ROE despite the decline in EBIT margins.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
Without a user account, I tend to respond rather slowly.

How can I help you?


Two-Component Disaggregation of ROA

Walgreens Boots Alliance Inc., decomposition of ROA

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Aug 31, 2019 5.89% = 2.91% × 2.02
Aug 31, 2018 7.37% = 3.82% × 1.93
Aug 31, 2017 6.18% = 3.45% × 1.79
Aug 31, 2016 5.74% = 3.56% × 1.61
Aug 31, 2015 6.14% = 4.08% × 1.50
Aug 31, 2014 5.20% = 2.53% × 2.05

Based on: 10-K (reporting date: 2019-08-31), 10-K (reporting date: 2018-08-31), 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31).


The Return on Assets (ROA) exhibited overall volatility between 2014 and 2019, reaching a peak of 7.37% in 2018 before declining to 5.89% in 2019. This trajectory reflects a shifting balance between operational profitability and asset utilization efficiency.

Net Profit Margin
Profitability experienced significant variance over the period, starting at 2.53% in 2014 and peaking at 4.08% in 2015. After this initial surge, the margin fluctuated within a range of 3.45% to 3.82% between 2016 and 2018, before contracting to 2.91% in 2019.
Asset Turnover
Asset utilization efficiency saw a sharp decline from 2.05 in 2014 to a low of 1.50 in 2015. This was followed by a consistent and steady recovery trend, with the ratio increasing every year thereafter to reach 2.02 by 2019, essentially returning to the baseline level observed in 2014.
Component Interaction and ROA Drivers
The disaggregation reveals that the ROA increase in 2015 was driven primarily by the expansion of the net profit margin, which more than compensated for the decline in asset turnover. The peak ROA observed in 2018 was the result of a synergistic effect, where both a strong profit margin (3.82%) and an improving asset turnover ratio (1.93) converged. In 2019, the high asset turnover of 2.02 served as a critical buffer, mitigating the impact of the falling net profit margin and preventing a sharper decline in the overall return on assets.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
Without a user account, I tend to respond rather slowly.

How can I help you?


Four-Component Disaggregation of ROA

Walgreens Boots Alliance Inc., decomposition of ROA

Microsoft Excel
ROA = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover
Aug 31, 2019 5.89% = 0.87 × 0.87 × 3.85% × 2.02
Aug 31, 2018 7.37% = 0.83 × 0.91 × 5.05% × 1.93
Aug 31, 2017 6.18% = 0.84 × 0.87 × 4.68% × 1.79
Aug 31, 2016 5.74% = 0.81 × 0.90 × 4.91% × 1.61
Aug 31, 2015 6.14% = 0.80 × 0.90 × 5.69% × 1.50
Aug 31, 2014 5.20% = 0.56 × 0.96 × 4.73% × 2.05

Based on: 10-K (reporting date: 2019-08-31), 10-K (reporting date: 2018-08-31), 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31).


The Return on Assets (ROA) exhibited a fluctuating trend between 2014 and 2019, peaking at 7.37% in 2018 before declining to 5.89% in 2019. This performance is the result of interacting dynamics between tax efficiency, interest obligations, operating profitability, and asset utilization.

Tax Burden
A consistent upward trend is observed in the tax burden ratio, which rose from 0.56 in 2014 to 0.87 in 2019. This progression indicates a significant improvement in the proportion of pre-tax income retained after taxes, suggesting a lower effective tax rate over the analyzed period.
Interest Burden
The interest burden remained relatively stable, although it shifted slightly downward from 0.96 in 2014 to 0.87 in 2019. This marginal decline suggests that a larger portion of operating profit was allocated to interest expenses toward the end of the period compared to the start.
EBIT Margin
Operating profitability showed volatility, reaching a peak of 5.69% in 2015 before entering a general decline. By 2019, the EBIT margin fell to 3.85%, the lowest point in the series, indicating compression in operating margins.
Asset Turnover
Asset efficiency experienced a sharp decline in 2015, dropping to 1.50. However, a steady recovery followed, with the ratio climbing back to 2.02 by 2019, demonstrating an improved ability to generate revenue from the asset base.

The overall trajectory of the ROA was primarily supported by the marked improvement in the tax burden and the recovery of asset turnover. These positive drivers largely offset the declining EBIT margin until 2018. The contraction in ROA observed in 2019 is directly attributable to the significant drop in the EBIT margin, which outweighed the gains in asset turnover and tax efficiency.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
Without a user account, I tend to respond rather slowly.

How can I help you?


Disaggregation of Net Profit Margin

Walgreens Boots Alliance Inc., decomposition of net profit margin ratio

Microsoft Excel
Net Profit Margin = Tax Burden × Interest Burden × EBIT Margin
Aug 31, 2019 2.91% = 0.87 × 0.87 × 3.85%
Aug 31, 2018 3.82% = 0.83 × 0.91 × 5.05%
Aug 31, 2017 3.45% = 0.84 × 0.87 × 4.68%
Aug 31, 2016 3.56% = 0.81 × 0.90 × 4.91%
Aug 31, 2015 4.08% = 0.80 × 0.90 × 5.69%
Aug 31, 2014 2.53% = 0.56 × 0.96 × 4.73%

Based on: 10-K (reporting date: 2019-08-31), 10-K (reporting date: 2018-08-31), 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31).


The net profit margin exhibited significant volatility between 2014 and 2019, peaking at 4.08% in 2015 before declining to 2.91% by 2019. This fluctuation is the result of varying contributions from operational efficiency, tax obligations, and financing costs.

EBIT Margin
Operational profitability showed a non-linear trend, reaching a peak of 5.69% in 2015. After a period of relative stability between 4.68% and 5.05% from 2016 to 2018, a notable contraction occurred in 2019, where the margin fell to 3.85%. This decline indicates a weakening in core operating profitability toward the end of the analyzed period.
Tax Burden
The tax burden ratio demonstrated a consistent upward trajectory, rising from 0.56 in 2014 to 0.87 in 2019. The sharp increase between 2014 and 2015 suggests a substantial reduction in the effective tax rate or a change in tax positioning, which significantly bolstered the net profit margin during that interval. This ratio remained the most consistently improving component of the profit margin disaggregation.
Interest Burden
The interest burden remained relatively stable but experienced a slight overall decline, moving from 0.96 in 2014 to 0.87 in 2019. The marginal decrease suggests that interest expenses consumed a slightly larger portion of operating income over time, though the impact was less pronounced than the changes observed in the tax burden or EBIT margin.

The disaggregation reveals that the initial expansion of the net profit margin from 2014 to 2015 was primarily driven by a combined improvement in operational margins and a significant easing of the tax burden. Conversely, the erosion of the net profit margin in 2019 was primarily attributable to the decline in the EBIT margin, which offset the benefits of a favorable tax burden ratio.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
Without a user account, I tend to respond rather slowly.

How can I help you?