Stock Analysis on Net
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.

Common-Size Income Statement
Quarterly Data

Walgreens Boots Alliance Inc., common-size consolidated income statement (quarterly data)

Microsoft Excel
3 months ended: 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 Aug 31, 2014 May 31, 2014 Feb 28, 2014 Nov 30, 2013
Sales 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00
Cost of sales -81.41 -79.03 -78.85 -78.71 -78.45 -77.54 -77.39 -77.35 -77.34 -75.48 -76.12 -75.65 -76.28 -74.32 -75.03 -75.01 -74.80 -73.94 -74.45 -74.53 -74.02 -74.10 -72.92 -72.05 -71.96 -71.18 -71.89
Gross profit 18.59% 20.97% 21.15% 21.29% 21.55% 22.46% 22.61% 22.65% 22.66% 24.52% 23.88% 24.35% 23.72% 25.68% 24.97% 24.99% 25.20% 26.06% 25.55% 25.47% 25.98% 25.90% 27.08% 27.95% 28.04% 28.82% 28.11%
Selling, general and administrative expenses -23.87 -17.61 -18.24 -18.87 -18.02 -18.30 -18.58 -18.28 -18.15 -19.13 -19.22 -20.62 -18.97 -20.80 -19.95 -21.12 -20.01 -19.90 -20.50 -22.54 -21.11 -21.10 -22.79 -23.58 -23.46 -23.31 -23.89
Equity earnings (loss) in AmerisourceBergen 0.70 0.08 0.03 0.17 -0.04 0.24 0.12 0.15 0.15 0.61 -0.36 -0.03 0.28 0.14 0.06 0.12 0.01 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Equity earnings in Alliance Boots 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.38 1.09 0.71 0.71 0.99 0.82
Operating income (loss) -4.57% 3.44% 2.95% 2.59% 3.48% 4.39% 4.14% 4.52% 4.66% 6.00% 4.30% 3.69% 5.04% 5.02% 5.08% 3.98% 5.20% 6.16% 5.06% 2.93% 4.87% 5.18% 5.39% 5.08% 5.29% 6.50% 5.04%
Gain on previously held equity interest 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -0.50 0.00 2.66 0.00 0.00 0.00 0.00 0.00
Other income (expense) -0.10 0.07 0.10 0.02 0.53 0.06 0.08 0.92 -0.01 0.03 -0.45 0.04 -0.03 -0.05 0.00 0.92 0.09 -1.64 -0.20 -1.68 1.60 1.90 1.02 -4.05 0.64 -0.30 1.23
Earnings (loss) before interest and income tax provision -4.67% 3.51% 3.05% 2.60% 4.00% 4.45% 4.22% 5.44% 4.65% 6.02% 3.85% 3.73% 5.01% 4.97% 5.08% 4.90% 5.29% 4.52% 4.86% 0.75% 6.47% 9.74% 6.41% 1.04% 5.93% 6.20% 6.27%
Interest expense, net -0.45 -0.45 -0.48 -0.52 -0.54 -0.52 -0.48 -0.48 -0.46 -0.46 -0.48 -0.64 -0.51 -0.58 -0.61 -0.60 -0.50 -0.46 -0.48 -0.89 -0.52 -0.54 -0.28 -0.23 -0.18 -0.19 -0.22
Earnings (loss) before income tax provision -5.12% 3.06% 2.57% 2.09% 3.46% 3.93% 3.74% 4.97% 4.19% 5.57% 3.37% 3.09% 4.50% 4.39% 4.47% 4.31% 4.79% 4.06% 4.38% -0.14% 5.94% 9.19% 6.13% 0.81% 5.75% 6.01% 6.05%
Income tax (provision) benefit 0.12 -0.45 -0.09 -0.08 -0.45 -0.65 -0.53 -0.48 -0.32 -1.52 -0.74 -0.42 -0.56 -0.84 -0.77 -0.72 -1.09 -1.00 -0.58 0.22 -1.42 -1.47 -1.64 -1.89 -1.81 -2.10 -2.20
Post tax earnings (loss) from other equity method investments 0.02 0.04 -0.02 0.01 -0.01 0.02 0.04 0.04 0.04 0.04 0.04 0.00 -0.07 0.05 0.04 0.03 0.05 0.03 0.04 0.03 0.02 0.03 0.00 0.00 0.00 0.00 0.00
Net earnings (loss) -4.98% 2.66% 2.45% 2.02% 3.00% 3.30% 3.26% 4.53% 3.92% 4.09% 2.67% 2.68% 3.87% 3.61% 3.74% 3.61% 3.75% 3.09% 3.85% 0.11% 4.55% 7.75% 4.49% -1.08% 3.94% 3.92% 3.84%
Net (earnings) loss attributable to noncontrolling interests 0.05 -0.02 0.01 -0.03 -0.03 0.05 0.07 -0.01 -0.01 0.00 0.00 -0.02 -0.01 -0.01 -0.05 -0.02 -0.01 -0.01 -0.02 -0.02 -0.03 -0.07 -0.14 -0.18 -0.22 -0.07 -0.05
Net earnings (loss) attributable to Walgreens Boots Alliance, Inc. -4.93% 2.64% 2.46% 2.00% 2.96% 3.35% 3.32% 4.52% 3.91% 4.09% 2.67% 2.66% 3.86% 3.60% 3.70% 3.60% 3.74% 3.08% 3.82% 0.09% 4.52% 7.68% 4.35% -1.25% 3.72% 3.85% 3.79%

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), 10-K (reporting date: 2014-08-31), 10-Q (reporting date: 2014-05-31), 10-Q (reporting date: 2014-02-28), 10-Q (reporting date: 2013-11-30).

The financial performance over the analyzed period is characterized by a progressive erosion of gross margins and a significant volatility in net profitability, culminating in a sharp downturn in the final quarter of the period ending May 31, 2020.

Gross Margin Performance
A consistent upward trend in the cost of sales is observed, increasing from 71.89% of sales in November 2013 to 81.41% by May 2020. This escalation directly resulted in a steady decline in gross profit margins, which contracted from 28.11% to 18.59% over the same duration. The most precipitous drop occurred in the final recorded quarter, indicating a substantial increase in the cost of goods sold relative to revenue.
Operating Expense Management
Selling, general, and administrative (SG&A) expenses showed a general pattern of optimization for much of the period. These expenses decreased from a peak of 23.89% in November 2013 to a low of 17.61% in February 2020. This suggests a period of successful operational efficiency that partially mitigated the decline in gross profits. However, this trend reversed sharply in May 2020, with SG&A expenses spiking back to 23.87% of sales.
Operating and Net Income Trends
Operating income remained relatively stable, generally fluctuating between 3% and 6% of sales from 2013 through 2019. However, a severe contraction is evident in the final quarter, where operating income shifted to a loss of 4.57% of sales. Net earnings attributable to the company mirrored this volatility, maintaining a range of approximately 2% to 4% for several years before falling to a loss of 4.93% in May 2020.
Non-Operating Factors and Interest
Interest expenses remained relatively constant as a percentage of sales, typically ranging between 0.45% and 0.64%. Other income and expenses exhibited high volatility, contributing to intermittent swings in earnings before taxes. Tax provisions also fluctuated, moving from approximately 2% of sales in the early period to a tax benefit of 0.12% in the final quarter, coinciding with the net loss.
Equity Method Investments
Contributions from equity method investments shifted over time. Earnings from Alliance Boots were present in the earliest quarters but ceased after February 2015. Subsequently, equity earnings from AmerisourceBergen became a factor, generally providing a marginal positive contribution to the common-size income statement, peaking at 0.70% of sales in the final quarter.

AI Ask an analyst for more

My previous chats

Add tokens

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?