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 Balance Sheet: Liabilities and Stockholders’ Equity
Quarterly Data

Walgreens Boots Alliance Inc., common-size consolidated balance sheet: liabilities and stockholders’ equity (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 Aug 31, 2014 May 31, 2014 Feb 28, 2014 Nov 30, 2013
Short-term debt 5.07 6.65 6.86 8.49 7.99 7.60 6.21 2.89 3.69 4.43 1.90 0.38 6.52 1.59 1.52 0.44 0.56 1.58 1.58 1.55 1.69 1.49 1.59 2.08 2.09 1.56 1.57
Trade accounts payable 16.23 16.63 16.96 21.21 20.60 20.37 20.96 19.91 18.66 18.78 20.37 18.93 15.54 15.54 15.81 15.13 15.35 14.87 15.50 14.67 14.06 14.42 10.67 11.61 11.33 12.10 13.05
Current operating lease obligation 2.65 2.53 2.52 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.00 0.00 0.00
Accrued expenses and other liabilities 6.78 6.01 5.91 8.10 7.56 7.72 7.84 8.60 7.75 8.01 7.78 8.29 6.83 6.81 6.79 7.54 7.21 7.61 7.12 7.60 6.86 7.20 7.40 9.95 9.01 8.85 8.80
Income taxes 0.10 0.03 0.23 0.32 0.38 0.23 0.87 0.40 0.53 0.63 0.74 0.50 0.38 0.45 0.53 0.28 0.37 0.45 0.38 0.26 0.26 0.27 0.65 0.28 0.06 0.42 0.76
Current liabilities 30.83% 31.85% 32.48% 38.12% 36.54% 35.92% 35.89% 31.81% 30.62% 31.86% 30.80% 28.10% 29.27% 24.38% 24.65% 23.41% 23.48% 24.51% 24.58% 24.07% 22.87% 23.39% 20.32% 23.92% 22.49% 22.92% 24.18%
Long-term debt 14.01 11.81 11.70 16.42 17.68 18.01 16.65 18.25 17.76 17.70 19.12 19.22 19.38 24.49 24.72 25.73 19.53 19.54 19.22 19.36 21.31 22.42 28.30 10.05 10.02 12.11 12.34
Non-current operating lease obligation 25.38 24.40 24.11 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.00 0.00 0.00
Deferred income taxes 1.78 1.82 1.78 2.64 2.71 2.81 2.56 2.66 2.81 2.75 3.48 3.46 3.24 3.23 3.50 3.64 4.54 4.68 4.83 5.14 5.00 5.17 2.33 2.82 2.70 2.37 2.13
Other non-current liabilities 3.33 3.10 3.15 7.09 6.95 7.17 7.35 8.11 8.23 7.91 6.44 6.40 5.66 5.94 5.84 5.56 5.94 6.20 6.00 5.92 5.62 5.54 6.34 7.91 7.33 6.42 6.37
Non-current liabilities 44.51% 41.12% 40.75% 26.15% 27.34% 28.00% 26.56% 29.02% 28.79% 28.35% 29.04% 29.07% 28.28% 33.66% 34.06% 34.94% 30.01% 30.42% 30.05% 30.42% 31.93% 33.13% 36.96% 20.78% 20.05% 20.90% 20.84%
Total liabilities 75.33% 72.96% 73.22% 64.27% 63.88% 63.92% 62.45% 60.82% 59.42% 60.21% 59.84% 57.17% 57.55% 58.04% 58.71% 58.34% 53.49% 54.93% 54.62% 54.49% 54.80% 56.52% 57.28% 44.70% 42.54% 43.82% 45.02%
Preferred stock $.01 par value; none issued 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.00 0.00 0.00 0.00 0.00 0.00
Common stock $.01 par value 0.01 0.01 0.01 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.16 0.22 0.21 0.22 0.22
Paid-in capital 12.41 11.88 11.73 15.74 15.46 15.01 15.04 15.40 14.89 14.70 15.55 15.66 14.01 14.02 14.09 13.91 14.94 15.13 14.56 14.47 14.00 13.79 2.43 3.15 3.02 2.93 2.89
Employee stock loan receivable 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.00 -0.01 -0.01 -0.02 -0.02 -0.03
Retained earnings 39.61 40.39 39.43 52.98 51.83 49.59 48.85 49.25 46.27 44.50 45.87 45.66 40.10 39.98 39.40 38.09 40.19 39.69 37.59 36.48 36.04 34.37 46.73 59.78 60.95 60.33 60.08
Accumulated other comprehensive income (loss) -4.48 -3.79 -3.65 -5.76 -4.95 -3.84 -4.62 -4.41 -3.98 -3.05 -3.82 -4.62 -4.45 -5.25 -5.30 -4.12 -1.90 -2.81 -0.96 -0.31 -0.20 -0.10 0.46 0.48 0.54 0.34 0.06
Treasury stock, at cost -23.57 -22.14 -21.47 -28.19 -27.18 -25.61 -22.68 -22.09 -17.66 -17.53 -18.70 -15.11 -8.42 -7.29 -7.43 -6.79 -7.39 -7.57 -6.48 -5.78 -5.17 -4.89 -7.32 -8.60 -7.42 -7.74 -8.34
Total Walgreens Boots Alliance, Inc. shareholders’ equity 23.99% 26.35% 26.06% 34.78% 35.19% 35.17% 36.62% 38.18% 39.54% 38.63% 38.92% 41.61% 41.25% 41.47% 40.78% 41.11% 45.86% 44.45% 44.73% 44.87% 44.68% 43.18% 42.45% 55.02% 57.28% 56.05% 54.88%
Noncontrolling interests 0.68 0.68 0.72 0.95 0.93 0.91 0.94 1.00 1.05 1.16 1.24 1.22 1.19 0.49 0.51 0.55 0.64 0.62 0.65 0.64 0.52 0.30 0.27 0.28 0.18 0.13 0.10
Total equity 24.67% 27.04% 26.78% 35.73% 36.12% 36.08% 37.55% 39.18% 40.58% 39.79% 40.16% 42.83% 42.45% 41.96% 41.29% 41.66% 46.51% 45.07% 45.38% 45.51% 45.20% 43.48% 42.72% 55.30% 57.46% 56.18% 54.98%
Total liabilities and equity 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%

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

An analysis of the capital structure reveals a significant structural shift between November 2013 and May 2020, characterized by a transition from an equity-heavy position to a liability-driven balance sheet. Total liabilities rose from 45.02% to 75.33% of total liabilities and equity, while total equity experienced a corresponding contraction, falling from 54.98% to 24.67% over the same period.

Liability Composition and Debt Trends
Non-current liabilities exhibited a marked increase, particularly starting in November 2014, when they rose from approximately 20% to 36.96%. Long-term debt showed significant volatility; after a sharp increase in late 2014, it generally trended downward. A notable accounting transition is observed in November 2019, where the emergence of non-current operating lease obligations at 24.11% and current operating lease obligations at 2.52% coincided with a decrease in reported long-term debt, suggesting a reclassification of lease commitments on the balance sheet.
Current Liabilities and Working Capital
Current liabilities demonstrated a steady upward trend, moving from 24.18% to 30.83%. This increase was largely propelled by trade accounts payable, which grew from 13.05% in November 2013 to a peak of 21.21% in August 2019. Short-term debt remained minimal, generally under 2%, until May 2017, after which it became more prominent, peaking at 8.49% in August 2019 before moderating to 5.07% by May 2020.
Equity Erosion and Capital Management
The decline in total equity is primarily driven by a substantial reduction in retained earnings, which dropped from 60.08% in November 2013 to 39.61% in May 2020. This erosion was further compounded by an aggressive increase in treasury stock, which moved from -8.34% to -23.57%, indicating significant capital outflows through share repurchases. While paid-in capital increased sharply between 2014 and 2015—rising from approximately 3% to over 14%—this was insufficient to offset the combined impact of declining retained earnings and treasury stock acquisitions.

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?