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.

DuPont Analysis: Disaggregation of ROE, ROA, and Net Profit Margin
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

Two-Component Disaggregation of ROE

Walgreens Boots Alliance Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = ROA × Financial Leverage
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 = ×

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 analysis of the financial performance indicators over the observed quarters reveals several notable trends.

Return on Assets (ROA)
The ROA demonstrated an overall upward trajectory from November 2014 through August 2018, peaking at 7.37% in August 2018. Following this peak, the ratio maintained a generally stable range around 7% up to November 2019. However, a sharp decline is evident starting February 2020, falling to 0.88% by May 2020, indicating a significant reduction in asset profitability during that period.
Financial Leverage
Financial leverage ratios showed moderate fluctuations over the periods. Initially, it remained in the range of approximately 2.2 to 2.6 from late 2014 through late 2018, indicating relatively stable use of debt financing. From early 2019 onwards, there is a marked increase in leverage, reaching 3.84 by February 2020 and further increasing to 4.17 by May 2020. This suggests a growing reliance on debt or other liabilities in the capital structure during this later timeframe.
Return on Equity (ROE)
ROE experienced a strong upward movement from 10.11% in November 2014 to a peak of 20.80% in February 2019. This rise indicates improving profitability for shareholders over this period. After peaking, ROE declined moderately, reaching 14.73% by February 2020. Subsequently, a significant drop occurred to 3.67% by May 2020, reflecting a severe contraction in equity returns.

In summary, the company exhibited improving profitability and efficient asset use from 2014 through early 2019, as shown by increasing ROA and ROE. During this time, financial leverage remained relatively stable. Starting in 2019, leverage increased notably, coinciding with a sharp downturn in both ROA and ROE in early 2020, indicative of rising financial risk coupled with a substantial decline in profitability and returns to equity holders.


Three-Component Disaggregation of ROE

Walgreens Boots Alliance Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
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 = × ×

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 analysis of the quarterly financial ratios reveals various trends in profitability, efficiency, leverage, and overall shareholder returns over the specified periods.

Net Profit Margin
The net profit margin demonstrates some volatility but generally remains within the range of approximately 2.5% to 4.2% for most quarters. The margin peaks early in the timeline, reaching around 4.21% in mid-2015, followed by a gradual decline and fluctuation around 3.5% to 3.8% in the years that follow. Notably, there is a sharp decrease in the final quarter reported, dropping significantly to 0.55%, indicating a substantial reduction in profitability for that period.
Asset Turnover
The asset turnover ratio shows improvements over the years, starting from a high of 1.6 in late 2014, dipping to lower levels near 1.19 in early 2015, and then trending upward steadily. From 2017 onward, the ratio consistently holds above 1.5 and gradually increases to around 2.02 by late 2019, reflecting an enhancement in asset utilization efficiency. A temporary dip occurs in early 2020, but it quickly recovers toward the end of the period, indicating a resilient operational efficiency.
Financial Leverage
Financial leverage remains relatively stable between 2.2 and 2.9 for much of the timeframe but shows a marked increase starting in early 2020, peaking at 4.17 in the last reported quarter. This increasing trend suggests a rising reliance on debt financing or greater use of borrowed funds, potentially elevating the company’s financial risk profile during the most recent quarters.
Return on Equity (ROE)
The return on equity exhibits a strong upward trajectory from around 10% at the beginning of the period to a peak exceeding 20% in 2018 and early 2019. This indicates a period of improved profitability and efficient use of equity capital. However, after mid-2019, ROE declines noticeably, dropping sharply to 3.67% in the final quarter. This significant reduction points to deteriorating profitability and/or increased equity base impact, aligning with the observed fall in net profit margin and rise in financial leverage during this period.

In summary, the company showed improved efficiency and profitability from 2014 through 2018, with asset turnover and ROE both increasing. The subsequent decline in net profit margin and ROE coupled with increased financial leverage in the latest quarters highlights potential challenges in profitability and increased financial risk. These patterns suggest that while operational efficiency remained relatively solid, recent periods reflect stresses possibly linked to external or internal factors impacting profitability and capital structure.


Five-Component Disaggregation of ROE

Walgreens Boots Alliance Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Financial Leverage
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 = × × × ×

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 over the analyzed quarters exhibit distinct trends with implications for the company's operational efficiency, profitability, and risk profile.

Tax Burden
The tax burden ratio generally shows an upward trend from 0.59 to a peak of 0.90 before dropping slightly to 0.81 in the last quarter. This indicates an increasing proportion of income retained after taxes for most of the period, with a slight decrease toward the end, suggesting some fluctuation or potential changes in tax policy or tax planning effectiveness.
Interest Burden
The interest burden ratio remains relatively stable around 0.85 to 0.95 for most of the quarters, indicating consistent management of interest expenses relative to earnings before interest and taxes. The sharp decline to 0.59 in the final quarter indicates a significant increase in interest expenses or a decrease in EBIT, signaling potential financial stress or higher leverage costs during that period.
EBIT Margin
The EBIT margin shows variability, starting at 4.77% and reaching a high around 6.2%, but then generally trending downward to a low of 1.15% in the final quarter. This downward movement suggests decreasing operating profitability, possibly due to increased costs, pricing pressures, or other operational challenges affecting earnings before interest and taxes.
Asset Turnover
Asset turnover maintains a fluctuating but generally strong level around 1.5 to nearly 2.0, indicating relatively efficient use of assets to generate sales. A temporary dip occurs in the latter part of the timeline, but values rebound toward the end. This suggests periods of improved sales relative to asset base with some volatility.
Financial Leverage
Financial leverage exhibits a gradual increase over the quarters, moving from about 2.36 to over 4.17 in the last observed trend. This rising leverage indicates growing reliance on borrowed funds or higher debt levels, which could amplify returns but also increase financial risk, as suggested by the concurrent drop in interest burden and return on equity in the final quarter.
Return on Equity (ROE)
ROE shows initial growth from 10.11% to peaks exceeding 20%, reflecting improved profitability and/or financial leverage effects. However, the ratio declines sharply in the final quarters, reaching as low as 3.67%. This suggests that despite earlier gains, recent quarters faced challenges impacting net income or equity, resulting in reduced returns to shareholders.

Overall, the company demonstrated periods of operational strength and efficiency, but faced increasing financial leverage and declining profitability in the latest quarters. The significant drops in EBIT margin, interest burden, and ROE in the final reported period highlight emerging risks and challenges that could affect future financial performance and stability.


Two-Component Disaggregation of ROA

Walgreens Boots Alliance Inc., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
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 = ×

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 analysis of the quarterly financial indicators over the presented period reveals distinct trends in profitability, efficiency, and asset utilization.

Net Profit Margin (%)
The net profit margin shows moderate fluctuations through most of the periods, generally oscillating between approximately 2.5% and 4%. It experienced a peak early in the data at about 4.21% (May 2015) before a gradual decline with occasional recoveries up until late 2018. From 2019 onwards, the margin displays a downward trend, notably declining sharply to 0.55% by May 2020. This suggests a significant weakening in profitability towards the end of the timeline, indicating increasing pressure on cost management or revenue generation relative to expenses.
Asset Turnover (ratio)
The asset turnover ratio, reflecting the company's efficiency in using assets to generate revenue, exhibits some volatility but an overall upward trend from the early periods through late 2019. Beginning near 1.6, it dips below 1.2 at one point (February 2015), then rises gradually, reaching above 2.0 in late 2019. However, during the last two quarters, there is a noticeable decline to approximately 1.61 by May 2020. This pattern indicates improving asset utilization efficiency over several years, but a possible deterioration more recently, which may correspond with broader operational challenges or asset base changes.
Return on Assets (ROA) (%)
The return on assets parallels the trends observed in profitability and efficiency metrics. It increased from about 4.3% initially to a peak exceeding 7.6% around late 2018, signifying strong asset profitability during that interval. Following this peak, ROA experiences a marked decline coinciding with the downturn in net profit margin and asset turnover, dropping to just 0.88% by May 2020. The sharp decline in ROA at the end of the period highlights significant challenges in generating earnings from the company's asset base during that time frame.

Overall, the data indicates a phase of growth and improved operational efficiency spanning roughly mid-2015 to late-2018, followed by a period of weakening profitability and asset use effectiveness culminating in early 2020. The downturn in all key ratios in the latest quarters warrants attention as it could reflect external market pressures or internal operational issues affecting financial performance adversely.


Four-Component Disaggregation of ROA

Walgreens Boots Alliance Inc., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover
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 = × × ×

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 quarterly financial data reveals notable fluctuations and trends across key performance ratios over the observed periods.

Tax Burden
The tax burden ratio shows a general upward trend from 0.59 in late 2014 to a peak around 0.90 in early 2020, indicating an increasing proportion of earnings retained after taxes. However, there is a decline to 0.81 in the last recorded period, suggesting some variability towards the end of the timeline.
Interest Burden
Interest burden remains relatively stable in the mid to high 0.8 to 0.9 range for most periods, reflecting consistent interest expenses relative to operating income. Notably, there is a sharp decrease to 0.59 in the final quarter, implying a significant change in interest costs or financial structure in that period.
EBIT Margin
The EBIT margin percentage experiences a gradual decline over time, starting near 6% in early 2015 and decreasing to approximately 1.15% by the final quarter. This decline signals diminishing profitability from operations as a percentage of revenue, with a sharp reduction in the last periods underscoring potential challenges in cost control or revenue generation.
Asset Turnover
Asset turnover demonstrates a generally positive trajectory, rising from around 1.6 in late 2014 to above 2.0 in late 2019, before a steep drop to around 1.6 again in the final quarters. This indicates improving efficiency in using assets to generate sales for most of the period, followed by a sudden reduction in asset utilization efficiency towards the end.
Return on Assets (ROA)
ROA mirrors the trends seen in EBIT margin and asset turnover, initially improving from about 4.3% in late 2014 to a peak exceeding 7.6% in early 2019. Subsequently, the ROA declines sharply to below 1% by the final quarter, reflecting overall weakening in generating returns from assets, likely due to decreased profitability and asset utilization.

In summary, the data indicates a period of improving operational efficiency and profitability up to around early 2019, followed by a marked deterioration in financial performance and efficiency metrics in the latest quarters. The decline in EBIT margin and ROA alongside sudden changes in interest burden suggest potential financial and operational challenges in the most recent period.


Disaggregation of Net Profit Margin

Walgreens Boots Alliance Inc., decomposition of net profit margin ratio (quarterly data)

Microsoft Excel
Net Profit Margin = Tax Burden × Interest Burden × EBIT Margin
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 = × ×

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 reveal several notable trends over the examined periods. The Tax Burden ratio exhibited a steady increase, rising from 0.59 to a peak of 0.9 before a subsequent decline to 0.81. This suggests an overall increase in the proportion of income retained after taxes, followed by a recent drop, indicating changes in tax efficiency or tax rates impacting the net income.

The Interest Burden ratio showed a generally declining tendency from 0.95 down to 0.59, with a steady decrease especially pronounced in the latest quarters. This decline indicates increasing interest expenses relative to earnings before interest and taxes, reflecting potentially higher interest obligations or lower operating profit before interest.

The EBIT Margin percentage reveals a downward trend over the periods, falling from 6.2% near the beginning to a low of 1.15% in the final recorded quarter. This represents a significant decline in operating profitability before interest and taxes, suggesting pressures on operational efficiency or increased operating costs.

The Net Profit Margin followed a similar declining pattern, decreasing from around 4.21% to 0.55%. This indicates a considerable reduction in overall profitability available to shareholders, signaling challenges in cost management, revenue generation, or impacts from increased interest and tax burdens.

Tax Burden
Overall upward movement with a peak approaching the final quarters, implying improved retained income after taxes before a slight decrease.
Interest Burden
Consistent downward trend indicating rising interest expenses or lower earnings before interest and taxes.
EBIT Margin
Marked decline over the periods, signaling considerable pressure on operational profitability.
Net Profit Margin
Substantial fall from early high points to low levels at the end, reflecting decreased net profitability.

In summary, the company appears to have faced increasing operational and financial pressures, with profitability margins shrinking alongside rising interest costs. These trends could underline challenges in managing operational efficiency and financial expenses, leading to reduced net earnings. The recent partial recovery in the Tax Burden ratio may indicate some tax management improvements, but the overall profitability metrics remain subdued.