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.

Analysis of Solvency Ratios
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

Solvency Ratios (Summary)

Walgreens Boots Alliance Inc., solvency ratios (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
Debt Ratios
Debt to equity
Debt to equity (including operating lease liability)
Debt to capital
Debt to capital (including operating lease liability)
Debt to assets
Debt to assets (including operating lease liability)
Financial leverage
Coverage Ratios
Interest coverage

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 leverage ratio exhibited a gradual upward trend over the periods, starting around 2.36 and increasing to over 4.0 by the final quarter. This indicates an increasing use of debt in the capital structure relative to equity.

The debt to equity ratio initially declined from 0.7 to a low around 0.44-0.46, before rising again steadily and ending at 0.8. When including operating lease liabilities, this ratio showed a similar pattern but experienced a notable spike in the last three quarters, reaching nearly 2.0, suggesting a significant increase in lease obligations counted as debt in that timeframe.

Debt to capital ratios followed a mild U-shaped pattern, decreasing from approximately 0.41 to 0.30-0.32 and then climbing back to 0.44 by the last period. Including operating lease liabilities, this ratio remained stable before jumping substantially to 0.66 at the end, further supporting the impact of recognizing lease liabilities.

Debt to assets ratios decreased initially from 0.3 to approximately 0.19 and remained relatively stable through most periods. However, when operating lease liabilities were included, there was a marked increase from about 0.25 to nearly 0.47 in the final periods, reflecting the growing impact of lease liabilities on overall assets financing.

Interest coverage ratio showed a pronounced decreasing trend from a very strong level above 22 down to just over 2.4 by the last quarter. This decline points to reduced earnings capacity relative to interest expenses, potentially signaling increased financial risk or lower operating profitability.

Summary of trends:
The company demonstrated increasing leverage over time, with debt usage rising relative to equity and capital.
The recognition of operating lease liabilities significantly altered leverage and debt ratios in the latest periods, causing notable increases across multiple metrics.
Despite initially strong interest coverage ratios, the company's ability to cover interest expenses deteriorated substantially by the end of the observation period.
Overall, the data indicates a movement toward higher financial risk associated with greater debt and lease-related obligations, alongside weakening earnings cushion for interest payments.

Debt Ratios


Coverage Ratios


Debt to Equity

Walgreens Boots Alliance Inc., debt to equity calculation (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
Selected Financial Data (US$ in millions)
Short-term debt
Long-term debt
Total debt
 
Total Walgreens Boots Alliance, Inc. shareholders’ equity
Solvency Ratio
Debt to equity1
Benchmarks
Debt to Equity, Competitors2
Costco Wholesale Corp.
Target Corp.
Walmart 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).

1 Q3 2020 Calculation
Debt to equity = Total debt ÷ Total Walgreens Boots Alliance, Inc. shareholders’ equity
= ÷ =

2 Click competitor name to see calculations.


Total Debt
The total debt experienced fluctuations over the reported periods. Initially, it increased from approximately 14.5 billion USD to a peak near 19 billion USD by mid-2016, followed by a moderate decline and relative stabilization around 16 to 18 billion USD in subsequent quarters. A slight decreasing trend is noted toward the latest periods, ending near 16.5 billion USD.
Total Shareholders’ Equity
Shareholders' equity showed variability with an initial rise from 20.6 billion USD to over 30 billion USD between late 2014 and early 2015. After this peak, equity levels experienced a gradual downward trend, with fluctuations moving mostly in the range of 23.5 to 27.5 billion USD. The latter periods suggest a slight decline, closing near 20.7 billion USD.
Debt to Equity Ratio
The debt to equity ratio demonstrated notable variability throughout the periods. Initially, the ratio declined from 0.7 to a low around 0.44 by mid-2016, indicating a relatively stronger equity base compared to debt. However, following this, the ratio increased steadily, reaching approximately 0.8 in the latest quarter. This increasing ratio in later periods reflects a relative increase in debt compared to equity, potentially implying higher financial leverage and associated risk.
Summary Observations
Overall, the analysis indicates a pattern where the company initially reduced leverage as evidenced by a decreasing debt to equity ratio. However, post-2016, an observable reversal began, with debt levels stabilizing at a high level while equity declined, contributing to an increasing debt to equity ratio. This suggests a shift toward greater financial leverage over time. The fluctuations in both equity and debt imply active capital structure management, but the recent trend toward higher leverage could warrant scrutiny regarding risk and financial stability.

Debt to Equity (including Operating Lease Liability)

Walgreens Boots Alliance Inc., debt to equity (including operating lease liability) calculation (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
Selected Financial Data (US$ in millions)
Short-term debt
Long-term debt
Total debt
Current operating lease obligation
Non-current operating lease obligation
Total debt (including operating lease liability)
 
Total Walgreens Boots Alliance, Inc. shareholders’ equity
Solvency Ratio
Debt to equity (including operating lease liability)1
Benchmarks
Debt to Equity (including Operating Lease Liability), Competitors2
Costco Wholesale Corp.
Target Corp.
Walmart 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).

1 Q3 2020 Calculation
Debt to equity (including operating lease liability) = Total debt (including operating lease liability) ÷ Total Walgreens Boots Alliance, Inc. shareholders’ equity
= ÷ =

2 Click competitor name to see calculations.


The financial data demonstrates noteworthy trends in the company's leverage and equity positions over the analyzed quarters. A detailed examination reveals fluctuating debt levels, shareholders' equity movements, and consequent impacts on the debt-to-equity ratio.

Total Debt (including operating lease liability)
The total debt exhibits variability over the periods. Initially, it ranged between approximately $14.3 billion and $19 billion, reflecting moderate fluctuations. However, there is a marked increase beginning in the later quarters of 2019 and into 2020, with debt levels surging to over $40 billion. This sharp rise suggests a significant change in financing strategy or increased borrowing, possibly related to strategic investments, restructuring, or external factors affecting liquidity needs.
Shareholders’ Equity
Shareholders’ equity shows a generally declining trend over the same timeframe. Starting from around $20.6 billion, equity grew substantially to over $30.8 billion by the early 2015 quarters, indicating a period of equity strengthening or retained earnings accumulation. Post-2015, the equity levels gradually diminished, trending downward to approximately $20.7 billion by mid-2020. This decline may be attributable to factors such as dividend payouts, share repurchases, or losses reducing retained earnings.
Debt to Equity Ratio
The debt-to-equity ratio follows the combined effect of debt and equity trends. Early values are below 1.0, generally ranging from 0.44 to 0.73, indicative of conservative leverage levels with more equity than debt. However, from late 2019 onwards, this ratio escalates sharply, reaching values above 1.7 and nearly 2.0 by mid-2020. This reflects the substantial increase in debt relative to equity, pointing to heightened leverage and potentially increased financial risk.

In summary, the company experienced a period of stable and moderate leverage with supportive equity levels until approximately late 2019. Afterwards, total debt grew significantly while equity declined, resulting in elevated debt-to-equity ratios. This shift denotes a strategic or necessary increase in borrowing that substantially alters the capital structure, warranting attention to associated risks and potential impacts on financial flexibility.


Debt to Capital

Walgreens Boots Alliance Inc., debt to capital calculation (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
Selected Financial Data (US$ in millions)
Short-term debt
Long-term debt
Total debt
Total Walgreens Boots Alliance, Inc. shareholders’ equity
Total capital
Solvency Ratio
Debt to capital1
Benchmarks
Debt to Capital, Competitors2
Costco Wholesale Corp.
Target Corp.
Walmart 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).

1 Q3 2020 Calculation
Debt to capital = Total debt ÷ Total capital
= ÷ =

2 Click competitor name to see calculations.


The analysis of the quarterly financial data over the observed periods reveals several notable trends related to the company's debt structure and capital composition.

Total Debt
The total debt displayed fluctuations over the reporting quarters. Initially, debt increased from approximately $14.5 billion to around $17 billion between late 2014 and early 2015, followed by a general downward movement reaching as low as $13 billion toward late 2017. Thereafter, a resurgence in debt levels is evident, peaking near $18 billion by early 2019, before declining again to approximately $16.5 billion by mid-2020. This volatility indicates periodic adjustments in debt financing, possibly linked to operational or strategic factors.
Total Capital
Total capital showed considerable variation, with a substantial increase from about $35 billion in late 2014 to nearly $48 billion in early 2015. Following this peak, the capital levels trended slightly downward and stabilized mostly between $39 billion and $43 billion through most of the subsequent periods. Toward the end of the timeline, total capital breached $40 billion but ended on a lower note at roughly $37 billion by mid-2020. This pattern suggests fluctuating capital base possibly affected by equity changes, retained earnings, or other comprehensive income components.
Debt to Capital Ratio
The debt to capital ratio experienced a decline from 0.41 to a low of 0.30 by mid-2016, indicating a decrease in the proportion of debt within the capital structure. Following mid-2016, the ratio rose steadily, reaching and maintaining a level around 0.42 from late 2018 through early 2020, and finally increasing to 0.44 by mid-2020. This trend reflects increased leverage relative to the total capital, suggesting a strategic shift toward greater reliance on debt financing in the latter periods.

Overall, the company’s financial leverage exhibited increased variability with an initial lowering of debt proportion followed by a period of rising leverage. The fluctuations in total debt and capital levels, coupled with the changing debt to capital ratio, imply active management of the capital structure, possibly driven by market conditions or internal financing needs. The rising leverage in the most recent quarters could indicate a strategic initiative to optimize the cost of capital or support growth investments.


Debt to Capital (including Operating Lease Liability)

Walgreens Boots Alliance Inc., debt to capital (including operating lease liability) calculation (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
Selected Financial Data (US$ in millions)
Short-term debt
Long-term debt
Total debt
Current operating lease obligation
Non-current operating lease obligation
Total debt (including operating lease liability)
Total Walgreens Boots Alliance, Inc. shareholders’ equity
Total capital (including operating lease liability)
Solvency Ratio
Debt to capital (including operating lease liability)1
Benchmarks
Debt to Capital (including Operating Lease Liability), Competitors2
Costco Wholesale Corp.
Target Corp.
Walmart 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).

1 Q3 2020 Calculation
Debt to capital (including operating lease liability) = Total debt (including operating lease liability) ÷ Total capital (including operating lease liability)
= ÷ =

2 Click competitor name to see calculations.


The analysis of the financial data reveals distinct trends in the company's debt levels, total capital, and leverage ratios over the observed quarters.

Total Debt (including operating lease liability)
The total debt demonstrates a fluctuating pattern throughout the periods. Initially, there was a general decrease from US$14,530 million in late 2014 to a low point around US$13,525 million by mid-2016. However, beginning from the third quarter of 2016, there is an upward trajectory with debt levels rising to a peak of approximately US$19,210 million by mid-2017. Subsequently, debt decreases again, before a sharp increase occurs at the start of 2020, reaching over US$41,000 million. This significant increase in debt during the last three recorded quarters may suggest substantial new borrowing or reclassification of liabilities.
Total Capital (including operating lease liability)
Total capital follows a somewhat similar trajectory to total debt with notable fluctuations. Starting at US$35,166 million at the end of 2014, the capital base expands considerably to nearly US$47,876 million in early 2015 and subsequently fluctuates but remains relatively stable around US$40,000 to US$49,000 million through late 2019. A major jump is evident at the beginning of 2020, where total capital surges to over US$64,000 million before slightly tapering to about US$61,457 million. This increase coincides with the rise in total debt, indicating an overall expansion of the company’s capital structure, likely influenced by new lease liabilities or financing activities.
Debt to Capital Ratio (including operating lease liability)
The debt to capital ratio displays variability closely aligned with the movements in debt and capital levels. The ratio initially declines from 0.41 at the end of 2014 to a low of approximately 0.30 in mid-2016, reflecting a period of deleveraging. From late 2016 through 2019, the ratio consistently rises from 0.39 to 0.42, indicating a gradual increase in leverage. A substantial increase appears in early 2020, with the ratio escalating to as high as 0.66 by mid-2020. This sharp rise suggests a significant shift in the company's leverage, potentially driven by increased borrowing relative to its capital base, raising considerations about financial risk exposure during that period.

In summary, the company’s financial data over the analyzed quarters reflects phases of balance sheet optimization followed by increased leverage and capital expansion, culminating in a marked increase in debt and leverage ratios in early 2020. These changes may be associated with strategic financing decisions or responses to external economic conditions during that period.


Debt to Assets

Walgreens Boots Alliance Inc., debt to assets calculation (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
Selected Financial Data (US$ in millions)
Short-term debt
Long-term debt
Total debt
 
Total assets
Solvency Ratio
Debt to assets1
Benchmarks
Debt to Assets, Competitors2
Costco Wholesale Corp.
Target Corp.
Walmart 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).

1 Q3 2020 Calculation
Debt to assets = Total debt ÷ Total assets
= ÷ =

2 Click competitor name to see calculations.


The analysis of the quarterly financial data reveals several notable trends related to total debt, total assets, and the debt-to-assets ratio over the observed periods.

Total Debt
Total debt figures exhibit fluctuating behavior throughout the observed quarters. Starting at 14,530 million USD, debt initially increased, reaching a peak of 19,028 million USD by August 2016. After this peak, there is an observed decline and further fluctuations, with levels dropping below 13,000 million USD by August 2017 and subsequently rising again. In the latest periods, total debt shows a modest decrease, settling around 16,490 million USD by May 2020. Overall, the debt trend indicates periods of both increase and reduction, suggesting active debt management and possible refinancing or repayment activities.
Total Assets
Total assets remained relatively stable with some variability across the quarters. Initial values of about 48,612 million USD in November 2014 surged to over 71,000 million USD in early 2015, reflecting a significant asset increase. Subsequent quarters showed some volatility with minor declines and rises, but assets generally maintained levels between approximately 66,000 and 74,000 million USD through mid-2018. In the last few periods, there is a noticeable jump, with total assets surpassing 90,000 million USD by early 2020, indicating potential asset growth or acquisition-related activities.
Debt to Assets Ratio
The debt-to-assets ratio displays a downward trend in the initial periods, decreasing from 0.3 to around 0.2 between late 2014 and mid-2016. This decline corresponds to the increase in assets relative to debt during this time. However, from mid-2016 through 2019, the ratio increases again, reaching approximately 0.26, reflecting a rise in debt relative to assets. Notably, in the latest quarters up to May 2020, there is a significant reduction in the ratio, dropping to around 0.18–0.19. This decline implies an improved balance sheet leverage position, likely due to asset growth outpacing debt or effective debt reduction strategies.

In summary, the data indicates that while total debt has experienced fluctuations, total assets have generally increased over time, especially in recent quarters. The debt-to-assets ratio reflects these patterns, showing initial improvement, mid-period increase, and recent strong leverage reduction, highlighting dynamic financial management and potential strategic shifts in capital structure.


Debt to Assets (including Operating Lease Liability)

Walgreens Boots Alliance Inc., debt to assets (including operating lease liability) calculation (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
Selected Financial Data (US$ in millions)
Short-term debt
Long-term debt
Total debt
Current operating lease obligation
Non-current operating lease obligation
Total debt (including operating lease liability)
 
Total assets
Solvency Ratio
Debt to assets (including operating lease liability)1
Benchmarks
Debt to Assets (including Operating Lease Liability), Competitors2
Costco Wholesale Corp.
Target Corp.
Walmart 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).

1 Q3 2020 Calculation
Debt to assets (including operating lease liability) = Total debt (including operating lease liability) ÷ Total assets
= ÷ =

2 Click competitor name to see calculations.


The financial data reveals distinct trends in the company’s debt and asset positions over the observed quarterly periods. A close examination of total debt, total assets, and the debt-to-assets ratio provides insights into the evolving financial structure and leverage dynamics.

Total Debt (including operating lease liability)
The total debt exhibits fluctuations over the analyzed timeframe. Beginning at approximately 14.5 billion USD, it generally remains within the 14–19 billion USD range throughout most of the periods. There is a notable spike starting around early 2020, where total debt more than doubles to roughly 41 billion USD, maintaining this elevated level for the last few quarters. This sharp increase suggests significant new debt acquisition or accounting changes, likely associated with operational shifts or responses to external market conditions at that time.
Total Assets
The company’s total assets have shown relative stability with some volatility over the quarters. Starting near 49 billion USD, the assets generally range between 66 billion to 73 billion USD during the mid-periods. Similar to debt trends, there is a noticeable jump in total assets around early 2020, increasing to approximately 90 billion USD, which corresponds with the sharp rise in debt. This growth in assets could be linked to acquisitions, revaluations, or growth in operational scale during this timeframe.
Debt to Assets Ratio (including operating lease liability)
This ratio reflects changes in leverage over time. Initially, the ratio starts at 0.3 and decreases steadily to about 0.2 by mid-2016, indicating a lower proportion of debt relative to assets during that period. From late 2016 through early 2020, the ratio stabilizes around 0.25 to 0.26, implying a balanced leverage position maintained through those quarters. However, from early 2020 onward, there is a significant increase, with the ratio rising sharply to approximately 0.45 to 0.47. This indicates a substantial increase in financial leverage, as debt grows at a faster pace than assets.

Overall, the data suggests that while the company maintained relatively consistent total debts and assets with moderate leverage for several years, there was a marked shift in early 2020 characterized by a sharp increase in liabilities and assets, leading to substantially higher leverage. This shift may reflect strategic financial decisions or external economic factors necessitating increased debt financing.


Financial Leverage

Walgreens Boots Alliance Inc., financial leverage calculation (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
Selected Financial Data (US$ in millions)
Total assets
Total Walgreens Boots Alliance, Inc. shareholders’ equity
Solvency Ratio
Financial leverage1
Benchmarks
Financial Leverage, Competitors2
Costco Wholesale Corp.
Target Corp.
Walmart 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).

1 Q3 2020 Calculation
Financial leverage = Total assets ÷ Total Walgreens Boots Alliance, Inc. shareholders’ equity
= ÷ =

2 Click competitor name to see calculations.


The analysis of the quarterly financial data reveals notable trends in the company's assets, equity, and financial leverage over the reported periods.

Total Assets

Total assets exhibited a fluctuating pattern with an overall increase from approximately $48.6 billion at the end of November 2014 to amounts ranging between $86.4 billion and $90.8 billion during 2019 and early 2020. After reaching close to $71.4 billion in February 2015, assets generally remained within the $66 billion to $72 billion range from mid-2015 to mid-2019. A significant increase occurred starting from November 2019, peaking at $90.8 billion in that period, and slightly declining to $86.4 billion by May 2020.

Total Shareholders’ Equity

Shareholders' equity increased sharply from about $20.6 billion in November 2014 to over $30 billion by mid-2015 but then demonstrated a downward trend. From late 2015 through 2019, equity gradually declined from approximately $30.7 billion to around $23.5 billion. In the final quarters analyzed, equity remained relatively stable near $23.7 billion before dipping significantly to about $20.7 billion by May 2020, indicating a reduction in net assets attributable to shareholders during this later period.

Financial Leverage

The financial leverage ratio, defined as the ratio of total assets to shareholders’ equity, initially decreased slightly from 2.36 in November 2014 to approximately 2.18 by mid-2016, reflecting moderate leverage levels at that time. From mid-2016 onward, this ratio saw a consistent upward trend, increasing steadily to 2.88 by late 2019. A sharp escalation occurred in the first half of 2020, with leverage rising to above 4.0, culminating at 4.17 in May 2020. This escalation indicates increased reliance on debt or other liabilities relative to equity.

In summary, the company experienced growth in total assets over the reported timeframe, particularly in late 2019 and early 2020. Conversely, shareholders’ equity showed a declining trend after an early peak, leading to a rising financial leverage ratio, especially pronounced in 2020. This shift suggests increased financial risk and greater use of debt financing relative to equity in recent periods.


Interest Coverage

Walgreens Boots Alliance Inc., interest coverage calculation (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
Selected Financial Data (US$ in millions)
Net earnings (loss) attributable to Walgreens Boots Alliance, Inc.
Add: Net income attributable to noncontrolling interest
Add: Income tax expense
Add: Interest expense, net
Earnings before interest and tax (EBIT)
Solvency Ratio
Interest coverage1
Benchmarks
Interest Coverage, Competitors2
Costco Wholesale Corp.
Target Corp.
Walmart 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).

1 Q3 2020 Calculation
Interest coverage = (EBITQ3 2020 + EBITQ2 2020 + EBITQ1 2020 + EBITQ4 2019) ÷ (Interest expenseQ3 2020 + Interest expenseQ2 2020 + Interest expenseQ1 2020 + Interest expenseQ4 2019)
= ( + + + ) ÷ ( + + + ) =

2 Click competitor name to see calculations.


The analysis of the financial metrics over the quarters reveals several notable trends regarding earnings before interest and tax (EBIT), interest expense, net, and interest coverage ratio.

Earnings Before Interest and Tax (EBIT)
EBIT fluctuates significantly throughout the observed periods. Initial figures show a rise from 1253 million USD to a peak of 2595 million USD in early 2015, followed by a sharp decline to 223 million USD in the third quarter of 2015. Subsequently, the values oscillate, with intermittent recoveries reaching values near or above 1800 million USD, such as in early 2018 and mid-2018. However, the trend deteriorates in the most recent periods, notably posting a negative EBIT of -1611 million USD in the last quarter observed. This indicates substantial operational challenges or one-time charges affecting profitability near the end of the timeline.
Interest Expense, Net
Interest expense shows a relatively stable and gradual increase over the quarters. Beginning at 55 million USD, it rises steadily to a range between 150 and 190 million USD for the majority of the subsequent periods. There are no sharp spikes or decreases, suggesting consistent borrowing costs or debt servicing levels, with a slight decline back to 155 million USD in the latest quarter.
Interest Coverage Ratio
The interest coverage ratio demonstrates a downward trajectory, reflecting the relationship between EBIT and interest expense. Starting from a high of 22.45, the ratio decreases considerably to levels below 10 during most quarters, indicating tighter earnings relative to interest obligations. Towards the end of the period, the ratio dips markedly to 2.42, correlating with the negative EBIT. This low coverage suggests increased risk in meeting interest payments from operational earnings, highlighting potential financial strain or diminished profitability.

Overall, the financial data indicate volatility and a general decline in operating earnings relative to interest costs. Despite relatively steady interest expenses, the decreasing EBIT and resulting lowered interest coverage ratio suggest deteriorating operating performance and increasing leverage risks over time. The negative EBIT in the latest quarter is especially indicative of significant operational or financial issues requiring attention.