Adjusted Financial Ratios (Summary)
Walgreens Boots Alliance Inc., Financial Ratios: Reported vs. Adjusted
Based on: 10-K (reporting date: 2019-08-31), 10-K (reporting date: 2018-08-31), 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31).
The financial profile between 2014 and 2019 is characterized by a strategic shift toward higher financial leverage and a corresponding decline in short-term liquidity, contrasted by a general improvement in asset utilization efficiency.
- Asset Efficiency
- A positive trajectory is observed in asset turnover. Reported total asset turnover, after an initial decline in 2015, grew steadily from 1.50 to 2.02 by 2019. Adjusted total asset turnover mirrored this recovery, increasing from a low of 1.02 in 2015 to 1.40 in 2019, indicating improved efficiency in generating revenue from the asset base.
- Liquidity and Solvency
- A significant deterioration in liquidity is evident. Both reported and adjusted current ratios peaked in 2016 (1.52 and 1.70, respectively) before declining sharply to 0.73 and 0.85 by 2019, suggesting a reduced capacity to meet short-term obligations. This decline coincides with a marked increase in leverage. Reported debt to equity rose from 0.22 in 2014 to 0.72 in 2019, while reported financial leverage increased from 1.82 to 2.88 over the same period. Adjusted debt to capital remained relatively stable but trended slightly upward from 0.57 to 0.59.
- Profitability and Returns
- Profitability metrics exhibit volatility, particularly in adjusted figures. Reported net profit margins fluctuated, peaking at 3.82% in 2018 before retreating to 2.91% in 2019. A notable anomaly occurred in 2016, where adjusted net profit margin, ROE, and ROA experienced sharp declines (0.99%, 3.25%, and 1.13%, respectively), though these recovered in subsequent years. Reported ROE showed strong growth from 9.44% in 2014 to a peak of 19.32% in 2018, though it moderated to 16.94% by 2019. Similarly, reported ROA peaked at 7.37% in 2018 before falling to 5.89% in 2019.
In summary, the period was marked by an expansion of the balance sheet through increased debt, which likely contributed to the elevated ROE observed toward the end of the period, despite the resulting pressure on liquidity ratios and a late-period dip in overall profitability margins.
AI Ask an analyst for more
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?
Adjusted Total Asset Turnover
Based on: 10-K (reporting date: 2019-08-31), 10-K (reporting date: 2018-08-31), 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31).
1 2019 Calculation
Total asset turnover = Sales ÷ Total assets
= 136,866 ÷ 67,598 = 2.02
2 Adjusted total assets. See details »
3 2019 Calculation
Adjusted total asset turnover = Sales ÷ Adjusted total assets
= 136,866 ÷ 97,521 = 1.40
Between 2014 and 2019, a consistent growth trajectory in sales is observed, rising from US$ 76,392 million to US$ 136,866 million. This expansion in top-line revenue occurred alongside a significant increase in the asset base, though the rate of asset growth stabilized in the later years of the period.
- Sales Growth and Asset Utilization
- Revenue increased steadily every year, contributing to a general improvement in asset efficiency. While total assets experienced a sharp increase between 2014 and 2015, the subsequent years showed a more plateaued asset base, which allowed the increase in sales to drive higher turnover ratios.
- Adjusted Total Asset Trends
- Adjusted total assets remained substantially higher than reported total assets throughout the entire period, indicating significant adjustments to the balance sheet. These adjusted assets grew from US$ 67,054 million in 2014 to a peak of US$ 97,823 million in 2018, before slightly declining to US$ 97,521 million in 2019.
- Adjusted Total Asset Turnover Performance
- The adjusted total asset turnover ratio exhibited a dip in 2015, falling to 1.02. However, from 2016 through 2019, a consistent upward trend is observed, with the ratio improving from 1.14 to 1.40. This suggests an increasing ability to generate revenue from the adjusted asset base over time.
- Comparison Between Reported and Adjusted Metrics
- A notable divergence exists between reported and adjusted asset turnover. The reported ratio is consistently higher and showed more volatility, whereas the adjusted ratio provides a more conservative view of efficiency due to the larger asset denominator. Despite this difference, both metrics trended upward between 2016 and 2019, confirming a period of improved operational efficiency.
AI Ask an analyst for more
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?
Adjusted Current Ratio
Based on: 10-K (reporting date: 2019-08-31), 10-K (reporting date: 2018-08-31), 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31).
1 2019 Calculation
Current ratio = Current assets ÷ Current liabilities
= 18,700 ÷ 25,769 = 0.73
2 Adjusted current assets. See details »
3 2019 Calculation
Adjusted current ratio = Adjusted current assets ÷ Current liabilities
= 21,995 ÷ 25,769 = 0.85
An analysis of the liquidity position from August 31, 2014, to August 31, 2019, reveals a consistent deterioration in short-term solvency. While liquidity peaked in 2016, a subsequent decline is evident as current liabilities grew at a rate that significantly outpaced current assets.
- Current Liabilities Growth
- Current liabilities exhibited a steady and substantial upward trajectory over the observed period, increasing from 8,895 million US$ in 2014 to 25,769 million US$ in 2019. This persistent increase indicates a significant expansion of short-term obligations.
- Current Assets Volatility
- Current assets demonstrated initial growth, reaching a peak of 25,883 million US$ in 2016, before contracting to 18,700 million US$ by 2019. The failure of current assets to maintain pace with the growth of liabilities directly contributed to the erosion of liquidity margins.
- Adjusted Current Ratio Trends
- The adjusted current ratio experienced a peak of 1.70 in 2016, followed by a continuous decline. A critical threshold was crossed between 2017 and 2018, where the ratio fell below 1.0, ending at 0.85 in 2019. This transition indicates a shift to a position where adjusted current assets are insufficient to cover current liabilities.
- Comparison of Reported and Adjusted Metrics
- The adjusted current ratio remained consistently higher than the reported current ratio across all years. While these adjustments provided a more optimistic view of liquidity, both metrics followed a mirrored downward trajectory after 2016, confirming a systemic decline in the short-term financial position regardless of the accounting adjustment applied.
AI Ask an analyst for more
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?
Adjusted Debt to Equity
Based on: 10-K (reporting date: 2019-08-31), 10-K (reporting date: 2018-08-31), 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31).
1 2019 Calculation
Debt to equity = Total debt ÷ Total Walgreens Boots Alliance, Inc. shareholders’ equity
= 16,836 ÷ 23,512 = 0.72
2 Adjusted total debt. See details »
3 Adjusted total equity. See details »
4 2019 Calculation
Adjusted debt to equity = Adjusted total debt ÷ Adjusted total equity
= 43,464 ÷ 30,068 = 1.45
An analysis of the capital structure between August 31, 2014, and August 31, 2019, reveals a consistent disparity between reported and adjusted leverage metrics. While reported debt to equity suggests a moderate leverage profile, the adjusted figures indicate a significantly higher reliance on debt relative to equity throughout the period.
- Comparison of Reported and Adjusted Leverage
- The reported debt to equity ratio increased from 0.22 in 2014 to 0.72 in 2019. In contrast, the adjusted debt to equity ratio remained substantially higher, fluctuating between a low of 1.14 and a high of 1.45. This indicates that adjusted liabilities consistently exceed adjusted equity, a condition that is not reflected in the reported metrics.
- Adjusted Debt and Equity Trends
- Adjusted total debt grew from 31,909 million US$ in 2014 to 43,464 million US$ in 2019. While adjusted total equity increased from 24,157 million US$ in 2014 to 30,068 million US$ in 2019, it experienced a steady decline after reaching a peak of 37,513 million US$ in 2015.
- Leverage Trajectory and Volatility
- The adjusted debt to equity ratio exhibited a volatile pattern with an overall upward trend toward the end of the period. After a decrease to 1.18 in 2015, the ratio rose to 1.30 in 2016, dropped to 1.14 in 2017, and subsequently climbed to 1.45 by August 31, 2019. The 2017 decrease correlates with a reduction in adjusted total debt to 39,129 million US$.
The divergence between reported and adjusted ratios suggests that significant obligations are incorporated into the adjusted calculations that are absent from the reported total debt. By the conclusion of the analyzed period in 2019, both reporting methods indicate a trend of increasing financial leverage.
AI Ask an analyst for more
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?
Adjusted Debt to Capital
Based on: 10-K (reporting date: 2019-08-31), 10-K (reporting date: 2018-08-31), 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31).
1 2019 Calculation
Debt to capital = Total debt ÷ Total capital
= 16,836 ÷ 40,348 = 0.42
2 Adjusted total debt. See details »
3 Adjusted total capital. See details »
4 2019 Calculation
Adjusted debt to capital = Adjusted total debt ÷ Adjusted total capital
= 43,464 ÷ 73,532 = 0.59
The analysis of the capital structure from August 31, 2014, to August 31, 2019, reveals a consistent reliance on leverage, characterized by a significant variance between reported and adjusted financial metrics.
- Adjusted Debt to Capital Ratio Stability
- The adjusted debt to capital ratio remained relatively stable over the six-year period, fluctuating within a narrow range between 0.53 and 0.59. After a slight decline from 0.57 in 2014 to a period low of 0.53 in 2017, the ratio trended upward, reaching its highest point of 0.59 by August 31, 2019.
- Comparison of Reported and Adjusted Leverage
- A substantial discrepancy exists between reported and adjusted leverage ratios throughout the analyzed timeframe. While the reported debt to capital ratio increased from 0.18 in 2014 to 0.42 in 2019, the adjusted ratio consistently maintained a higher baseline. This gap suggests that the adjusted metrics account for significant additional liabilities or capital adjustments that elevate the perceived debt burden relative to total capital compared to standard reporting.
- Evolution of Adjusted Debt and Capital Components
- Adjusted total debt experienced an overall increase, rising from US$ 31,909 million in 2014 to US$ 43,464 million in 2019. Simultaneously, adjusted total capital grew from US$ 56,066 million to US$ 73,532 million. The proportional growth of both debt and capital components accounts for the relative stability of the adjusted ratio despite the absolute increase in debt obligations.
AI Ask an analyst for more
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?
Adjusted Financial Leverage
Based on: 10-K (reporting date: 2019-08-31), 10-K (reporting date: 2018-08-31), 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31).
1 2019 Calculation
Financial leverage = Total assets ÷ Total Walgreens Boots Alliance, Inc. shareholders’ equity
= 67,598 ÷ 23,512 = 2.88
2 Adjusted total assets. See details »
3 Adjusted total equity. See details »
4 2019 Calculation
Adjusted financial leverage = Adjusted total assets ÷ Adjusted total equity
= 97,521 ÷ 30,068 = 3.24
Between August 31, 2014, and August 31, 2019, an overall increase in financial leverage is observed. The reported financial leverage ratio rose from 1.82 to 2.88, while the adjusted financial leverage ratio increased from 2.78 to 3.24. This trend reflects a shift in the capital structure, characterized by a growing disparity between the asset base and the equity position.
- Asset and Equity Trends
- A substantial expansion of the balance sheet occurred between 2014 and 2015, with total assets increasing from 37,182 million to 68,782 million. Adjusted total assets peaked in 2016 at 103,134 million before experiencing a slight decline and stabilization. In contrast, shareholders' equity peaked in 2015 and declined consistently through 2019, with reported equity falling from 30,861 million to 23,512 million, and adjusted equity decreasing from 37,513 million to 30,068 million.
- Analysis of Adjusted Financial Leverage
- The adjusted financial leverage ratio exhibited relative stability from 2014 to 2017, ranging between 2.70 and 2.87. A distinct upward trend emerged after 2017, with the ratio climbing to 3.03 in 2018 and 3.24 in 2019. The adjusted leverage ratios consistently exceed the reported ratios throughout the period, indicating that the adjustments to total assets and equity result in a higher calculated leverage profile than the reported figures suggest.
AI Ask an analyst for more
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?
Adjusted Net Profit Margin
Based on: 10-K (reporting date: 2019-08-31), 10-K (reporting date: 2018-08-31), 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31).
1 2019 Calculation
Net profit margin = 100 × Net earnings attributable to Walgreens Boots Alliance, Inc. ÷ Sales
= 100 × 3,982 ÷ 136,866 = 2.91%
2 Adjusted net earnings. See details »
3 2019 Calculation
Adjusted net profit margin = 100 × Adjusted net earnings ÷ Sales
= 100 × 3,507 ÷ 136,866 = 2.56%
Revenue experienced consistent growth over the analyzed period, increasing from 76,392 million USD in 2014 to 136,866 million USD by 2019. However, this growth in sales was not accompanied by a steady increase in profitability, as evidenced by the volatility in both reported and adjusted net profit margins.
- Adjusted Net Profit Margin Trends
- The adjusted net profit margin exhibited significant fluctuation, beginning at 3.54% in 2014 and peaking at 3.94% in 2015. A substantial contraction occurred in 2016, where the margin fell to 0.99%, marking the lowest point in the period. A recovery followed in 2017 and 2018, with margins returning to 3.43% and 3.67%, respectively, before declining again to 2.56% in 2019.
- Comparison Between Reported and Adjusted Margins
- In most years, the adjusted net profit margin aligned closely with the reported net profit margin. A notable divergence occurred in 2016, where the reported margin was 3.56% while the adjusted margin dropped to 0.99%. This indicates that specific non-recurring or adjusting items significantly reduced the adjusted earnings relative to the reported figures for that fiscal year.
- Profitability Relative to Revenue Growth
- Despite the continuous expansion of sales, the adjusted net profit margin in 2019 (2.56%) was lower than it was in 2014 (3.54%). This pattern suggests a trend of margin compression, where the cost of generating additional revenue increased disproportionately to the earnings growth.
AI Ask an analyst for more
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?
Adjusted Return on Equity (ROE)
Based on: 10-K (reporting date: 2019-08-31), 10-K (reporting date: 2018-08-31), 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31).
1 2019 Calculation
ROE = 100 × Net earnings attributable to Walgreens Boots Alliance, Inc. ÷ Total Walgreens Boots Alliance, Inc. shareholders’ equity
= 100 × 3,982 ÷ 23,512 = 16.94%
2 Adjusted net earnings. See details »
3 Adjusted total equity. See details »
4 2019 Calculation
Adjusted ROE = 100 × Adjusted net earnings ÷ Adjusted total equity
= 100 × 3,507 ÷ 30,068 = 11.66%
The analysis of return on equity (ROE) from 2014 to 2019 reveals a significant divergence between reported and adjusted performance metrics, characterized by a notable period of volatility in the adjusted figures.
- Adjusted Return on Equity Trends
- Adjusted ROE exhibited substantial fluctuation over the six-year period, starting at 11.18% in 2014 and peaking at 14.95% in 2018. A severe contraction occurred in 2016, where the ratio plummeted to 3.25%, driven primarily by a sharp decline in adjusted net earnings to 1,165 million USD. Following this trough, the ratio recovered to 11.81% in 2017 and 14.95% in 2018, before receding to 11.66% in 2019.
- Equity Base Dynamics
- A consistent downward trend in the equity base is observed following a peak in 2015. Adjusted total equity reached a maximum of 37,513 million USD in 2015 and declined steadily to 30,068 million USD by 2019. This systemic reduction in total shareholders' equity acted as a catalyst for the expansion of reported ROE, which reached 19.32% in 2018 despite the fluctuations in net earnings.
- Comparison of Reported and Adjusted Performance
- A pronounced disparity between reported and adjusted ROE is evident, most notably in 2016. During that fiscal year, reported ROE remained stable at 13.97%, while adjusted ROE fell to 3.25%. This divergence indicates that reported net earnings were likely influenced by significant non-recurring gains or accounting adjustments that were excluded from the adjusted earnings calculation. While reported ROE generally followed an upward trajectory until 2018, adjusted ROE remained more volatile and consistently lower than the reported figure in the final three years of the period analyzed.
AI Ask an analyst for more
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?
Adjusted Return on Assets (ROA)
Based on: 10-K (reporting date: 2019-08-31), 10-K (reporting date: 2018-08-31), 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31).
1 2019 Calculation
ROA = 100 × Net earnings attributable to Walgreens Boots Alliance, Inc. ÷ Total assets
= 100 × 3,982 ÷ 67,598 = 5.89%
2 Adjusted net earnings. See details »
3 Adjusted total assets. See details »
4 2019 Calculation
Adjusted ROA = 100 × Adjusted net earnings ÷ Adjusted total assets
= 100 × 3,507 ÷ 97,521 = 3.60%
The financial performance analysis from 2014 to 2019 reveals a consistent discrepancy between reported and adjusted return on assets (ROA) metrics. Adjusted figures consistently reflect a lower efficiency in asset utilization compared to reported figures, primarily driven by a substantially larger adjusted asset base.
- Adjusted Return on Assets Trends
- The Adjusted ROA exhibited significant volatility, starting at 4.03% in 2014 and remaining stable through 2015. A sharp contraction occurred in 2016, where the ratio plummeted to 1.13%, the lowest point in the observed period. This was followed by a recovery phase, peaking at 4.93% in 2018, before declining again to 3.60% in 2019.
- Adjusted Net Earnings Volatility
- The volatility in Adjusted ROA is closely linked to fluctuations in adjusted net earnings. A notable anomaly is observed in 2016, where adjusted net earnings dropped to 1,165 million US$, a significant decrease from the 4,077 million US$ recorded in 2015. This outlier heavily impacted the return metrics for that fiscal year.
- Asset Base Comparison
- A persistent gap exists between reported and adjusted total assets. Adjusted total assets remained significantly higher throughout the period, ranging from approximately 67 billion US$ in 2014 to a peak of 103 billion US$ in 2016. This expanded denominator consistently suppresses the Adjusted ROA relative to the Reported ROA, which fluctuated between 5.20% and 7.37%.
- Comparative Performance Analysis
- While Reported ROA showed a general upward trend peaking in 2018 at 7.37%, the Adjusted ROA followed a similar trajectory but at a lower magnitude. Both metrics experienced a downturn in 2019, indicating a synchronized decline in asset efficiency toward the end of the analyzed period.
AI Ask an analyst for more
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?