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.

Common-Size Income Statement
Quarterly Data

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 Apple Pay Google Pay
Visa Secure Mastercard Identity Check American Express SafeKey

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
Cost of sales
Gross profit
Selling, general and administrative expenses
Equity earnings (loss) in AmerisourceBergen
Equity earnings in Alliance Boots
Operating income (loss)
Gain on previously held equity interest
Other income (expense)
Earnings (loss) before interest and income tax provision
Interest expense, net
Earnings (loss) before income tax provision
Income tax (provision) benefit
Post tax earnings (loss) from other equity method investments
Net earnings (loss)
Net (earnings) loss attributable to noncontrolling interests
Net earnings (loss) attributable to Walgreens Boots Alliance, 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), 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 analysis of quarterly financial percentages relative to sales reveals distinct patterns in cost management, profitability, and earnings over the observed periods.

Cost of Sales
This expense as a percentage of sales exhibits a generally increasing trend, rising from approximately 71.89% in late 2013 to 81.41% by mid-2020. This gradual increase suggests a compression of gross margin, potentially indicating rising product costs or pricing pressures.
Gross Profit
Corresponding to the rise in cost of sales, gross profit margin shows a declining trend. Starting from about 28.11% in 2013, gross profit fell to 18.59% by mid-2020. This consistent reduction underscores challenges in maintaining profitability at the gross level.
Selling, General and Administrative Expenses (SG&A)
SG&A expenses as a percentage of sales fluctuate but generally trend downward from a high of 23.89% to around 17.61% in early 2020, before a sharp spike to 23.87% in the latest quarter of the dataset. This decline through most periods indicates efforts to control operating expenses despite pressures on gross profit, though the recent increase may point to one-off costs or strategic investments.
Equity Earnings (Loss) in Affiliates
Equity earnings in AmerisourceBergen appear starting in 2016 with modest but fluctuating contributions, peaking at 0.7% of sales in mid-2020. Equity earnings in Alliance Boots were only reported in early 2014, showing a decline from 0.82% to 0.38% before ceasing to appear. These variations reflect changes in earnings from allied businesses and ownership structures.
Operating Income
Operating income displays volatility, typically ranging between 2.95% and 6.5%, but with a notable negative outlier of -4.57% at mid-2020. This suggests episodic operational challenges or unusual expenses affecting profitability at the operating level.
Other Income (Expense)
Other income and expenses as a percentage of sales are generally contained within a ±2% range, with intermittent positive and negative swings. The net effect appears limited relative to core operations but may contribute to quarterly variations.
Earnings Before Interest and Tax (EBIT)
EBIT margins mirror operating income trends, with typical values mostly between 3% and 6%, but with sharp dips close to zero and a negative value (-4.67%) in the most recent period, aligning with observed operating income declines.
Interest Expense, Net
Interest expense remains relatively stable over time, consistently small at roughly 0.2% to 0.9% of sales, with a slight tendency to increase mid-period before stabilizing around 0.45% towards the end. This suggests consistent financing costs.
Earnings Before Income Tax
Pre-tax earnings largely correspond with EBIT figures, generally ranging from about 2% to 6%, but again showing a sharp downturn in the latest period to -5.12%, indicating significant earnings pressure prior to taxation.
Income Tax Provision
Income tax provisions fluctuate but hover mostly between -0.5% to -2.2% of sales, with occasional positive benefits noted, reflecting variable effective tax rates or temporary tax reliefs.
Net Earnings
Net earnings attributable to the company demonstrate considerable volatility, with highs near 7.68% (Feb 2015) and lows plunging to -4.93% (mid-2020). Overall, there is a downward trajectory in profitability ratios over the period, signaling challenges in sustaining net income margins amid rising costs and operational pressures.

In summary, the data reveals gradually increasing costs and declining gross profits, partially offset by efforts to reduce operating expenses until recent quarters. Earnings before interest and taxes have weakened, culminating in losses in the latest periods. The net effect is a deterioration in net earnings margins that may merit strategic review of cost structures and operational efficiency.