Walgreens Boots Alliance Inc. (NASDAQ:WBA)

Inventory levels exhibited a marked overall increase between August 31, 2014, and August 31, 2019, characterized by a sharp initial expansion followed by a period of relative stabilization.

Initial Expansion Phase

A significant surge in inventory is observed between 2014 and 2015, where values rose from $6,076 million to $8,678 million. This represents the most substantial growth interval in the analyzed period, indicating a rapid increase in held assets.

Stabilization and Plateau

Following the initial surge, inventory levels entered a phase of consolidation from 2016 to 2019. During this period, values fluctuated moderately, maintaining a range between $8,899 million and $9,565 million. A peak was reached on August 31, 2018, at $9,565 million, followed by a slight contraction to $9,333 million by August 31, 2019.

Long-term Trend Analysis

The trajectory indicates that while the rapid growth observed in the first year did not persist, the baseline for inventory holdings shifted upward permanently. The final value of $9,333 million in 2019 remains substantially higher than the $6,076 million reported in 2014.

The financial data demonstrates a consistent and widening divergence between reported figures, based on the Last-In, First-Out (LIFO) method, and adjusted figures, based on the First-In, First-Out (FIFO) method. This discrepancy is attributed to the LIFO reserve, which grew steadily from 2,300 million US dollars in 2014 to 3,200 million US dollars by 2019. This upward trend indicates a sustained increase in the replacement cost of inventory over the analyzed period.

Inventory Valuation and Reserve Trends

Reported inventories grew from 6,076 million US dollars in 2014 to 9,333 million US dollars in 2019. However, when adjusted to FIFO, the valuation starts significantly higher at 8,376 million US dollars and reaches 12,533 million US dollars in 2019. The gap between these two valuations expanded monotonically, reflecting cumulative inflationary pressures on inventory costs.

Impact on Asset Composition and Equity

The adjustment to FIFO results in a proportional increase in both total assets and shareholders' equity. In 2014, the adjustment increased total assets by 2,300 million US dollars; by 2019, this adjustment increased total assets by 3,200 million US dollars. A mirroring effect is observed in shareholders' equity, where adjusted equity consistently exceeds reported equity by the exact value of the LIFO reserve, ending at a 3,200 million US dollar difference in 2019.

Analysis of Net Earnings

Adjusted net earnings are generally higher than reported net earnings, as the LIFO method recognizes more recent, higher costs in the cost of goods sold during inflationary periods. The annual difference in earnings corresponds directly to the annual increase in the LIFO reserve. For instance, the 200 million US dollar increase in the reserve between 2018 and 2019 matches the 200 million US dollar difference between reported (3,982 million) and adjusted (4,182 million) net earnings for 2019. Notably, in 2018, reported and adjusted net earnings were identical, coinciding with a period where the LIFO reserve remained stagnant at 3,000 million US dollars.

Current Asset Concentration

Inventory represents a substantial portion of current assets under both accounting methods. Under the reported LIFO valuation, inventory constituted approximately 49.6% of current assets in 2014 and 50% in 2019. Under the adjusted FIFO valuation, the concentration is higher, representing 57.5% of current assets in 2014 and 57.3% in 2019, showing that the relative composition of current assets remained stable despite the increase in total valuation.

The financial performance between 2014 and 2019 is characterized by a declining liquidity position and increasing financial leverage, alongside a period of growth in return on equity that peaked in 2018. The adjustments from LIFO to FIFO consistently alter the perception of the company's balance sheet strength and operational efficiency.

Liquidity Ratios

A significant downward trend is observed in the current ratio, which fell from a reported 1.38 in 2014 to 0.73 in 2019. Throughout this period, the adjusted current ratio remained consistently higher than the reported ratio. This indicates that the LIFO reserve represents a substantial value in inventory that, when adjusted to FIFO, improves the apparent ability of the company to cover short-term obligations.

Profitability Margins

Net profit margins showed fluctuations, reaching a peak in 2015 before settling at 2.91% by 2019. The adjusted net profit margins are marginally higher than the reported figures for nearly every year. This suggest that the FIFO adjustment reduces the cost of goods sold, thereby increasing the reported net income.

Asset Efficiency

Total asset turnover experienced an initial drop in 2015 but recovered steadily to reach 2.02 by 2019. In contrast to the liquidity ratios, the adjusted total asset turnover is consistently lower than the reported turnover. This is a direct result of the adjusted asset base being larger due to the inclusion of the LIFO reserve, which reduces the overall turnover efficiency ratio.

Solvency and Leverage

Financial leverage demonstrates a clear and continuous upward trend, increasing from 1.82 in 2014 to 2.88 in 2019. The adjusted financial leverage is consistently lower than the reported leverage. This discrepancy occurs because the LIFO-to-FIFO adjustment increases the total equity, which effectively lowers the leverage ratio.

Returns on Investment

Reported Return on Equity (ROE) grew from 9.44% in 2014 to a peak of 19.32% in 2018, before declining to 16.94% in 2019. Adjusted ROE is consistently lower than reported ROE, as the expanded equity base in the denominator reduces the percentage return. Return on Assets (ROA) remained more stable across the period, with adjusted and reported figures tracking closely, both peaking in 2018.

The financial liquidity position from 2014 to 2019 demonstrates a period of initial asset growth followed by a steady decline in the capacity to cover short-term obligations. While a significant peak in assets occurred in 2016, both reported and adjusted metrics entered a sustained downward trajectory in the subsequent three years.

Asset Trend Analysis

Reported current assets grew from US$ 12,242 million in 2014 to a peak of US$ 25,883 million in 2016. This was followed by a contraction to US$ 17,846 million in 2018, with a marginal recovery to US$ 18,700 million by 2019. Adjusted current assets followed an identical pattern, reaching a high of US$ 28,683 million in 2016 before settling at US$ 21,900 million in 2019.

Reported Current Ratio Performance

The reported current ratio exhibited volatility between 2014 and 2016, peaking at 1.52. A consistent decline was observed thereafter, with the ratio falling to 1.07 in 2017 and dropping significantly below the unity threshold to 0.82 in 2018 and 0.73 in 2019. This trend indicates that by the end of the period, current liabilities exceeded reported current assets.

Adjusted Current Ratio Interpretation

The adjusted current ratio remained consistently higher than the reported ratio throughout the analyzed period, peaking at 1.69 in 2016. Despite this baseline advantage, the adjusted ratio mirrored the overall downward trend, crossing below the critical 1.0 threshold in 2018 at 0.96 and ending at 0.85 in 2019. The persistent gap between the reported and adjusted ratios suggests that while specific adjustments provide a more favorable view of liquidity, they did not offset the fundamental deterioration in the short-term financial position.

An analysis of profitability from 2014 to 2019 reveals a period of significant growth followed by moderate volatility and a subsequent decline. The trajectory of net earnings and profit margins suggests a peak in operational efficiency around 2015 and 2018, with a notable contraction occurring in the final year of the observed period.

Adjusted Net Profit Margin Trends

The adjusted net profit margin experienced a sharp increase from 2.79% in 2014 to a peak of 4.27% in 2015. This was followed by a gradual decline over the next two years, reaching 3.62% by 2017. A recovery occurred in 2018, with the margin rising to 3.82%, before dropping significantly to 3.06% in 2019. This pattern indicates a struggle to maintain the high profitability levels achieved in 2015.

Reported vs. Adjusted Performance

A consistent variance is observed between reported and adjusted net profit margins, with adjusted figures remaining higher in almost every year. This discrepancy indicates that non-recurring expenses or accounting adjustments frequently impacted the reported bottom line. However, in 2018, the reported and adjusted net earnings converged exactly at 5,024 million US dollars, and the margins aligned at 3.82%, suggesting an absence of significant one-time adjustments during that fiscal year.

Net Earnings Volatility

Reported net earnings showed substantial growth between 2014 and 2015, increasing from 1,932 million US dollars to 4,220 million US dollars. Earnings remained relatively stable between 2015 and 2017, followed by a peak of 5,024 million US dollars in 2018. The 2019 fiscal year saw a marked decline to 3,982 million US dollars, representing a decrease of approximately 20.6% from the previous year's peak.

The adjusted total asset turnover exhibits a significant fluctuation followed by a consistent recovery trend between August 2014 and August 2019. The ratio experienced a sharp decline in 2015, which was subsequently offset by steady annual improvements over the following four years, ultimately returning to its initial 2014 level by the end of the period.

Asset Base Expansion and Efficiency Impact

A substantial increase in adjusted total assets occurred between 2014 and 2015, rising from US$ 39,482 million to US$ 71,282 million. This rapid expansion of the asset base coincided with a notable decrease in the adjusted total asset turnover ratio, which fell from 1.93 to 1.45. This suggests that the growth in assets initially outpaced the growth in generated revenue, leading to a temporary reduction in asset utilization efficiency.

Recovery Phase of Asset Turnover

From 2016 through 2019, a consistent upward trajectory in adjusted total asset turnover is observed. The ratio improved incrementally from 1.55 in 2016 to 1.71 in 2017, 1.85 in 2018, and finally 1.93 in 2019. This progression indicates a systematic recovery in the ability to generate revenue from the expanded asset base.

Long-term Asset Utilization Stabilization

Despite fluctuations in the asset base—which peaked at US$ 75,488 million in 2016 before stabilizing at US$ 70,798 million by 2019—the adjusted total asset turnover was successfully restored to 1.93. The convergence of the 2019 ratio with the 2014 baseline demonstrates that the company regained its prior level of operational efficiency despite maintaining a significantly larger asset footprint.

A comprehensive review of the financial position from 2014 to 2019 reveals a marked increase in the organization's reliance on debt relative to equity. While the total asset base expanded rapidly in the early part of the period, shareholders' equity has experienced a consistent decline over the final four years of the analysis, leading to a steady rise in financial leverage.

Total Asset Evolution

Reported total assets rose sharply from US$ 37,182 million in 2014 to US$ 68,782 million in 2015. Following this initial surge, assets remained relatively stable, fluctuating between US$ 66,009 million and US$ 72,688 million through 2019. Adjusted total assets mirrored this trajectory, peaking in 2016 at US$ 75,488 million before stabilizing near US$ 70,798 million by 2019.

Shareholders' Equity Trends

Equity reached a peak in 2015 at US$ 30,861 million on a reported basis and US$ 33,361 million on an adjusted basis. From 2016 through 2019, a persistent downward trend is observed, with reported equity declining to US$ 23,512 million. This contraction in equity occurred despite the relative stability of the total asset base, contributing directly to the increase in leverage ratios.

Financial Leverage Analysis

A consistent upward trajectory is evident in both leverage metrics. Reported financial leverage increased from 1.82 in 2014 to 2.88 in 2019. Adjusted financial leverage followed a nearly identical pattern, rising from 1.73 in 2014 to 2.65 in 2019. The steady year-over-year increase suggests a strategic or operational shift toward a more leveraged capital structure.

Comparative Leverage Insights

Adjusted financial leverage remains consistently lower than reported financial leverage across the entire six-year period. Although the adjusted figures provide a slightly more favorable view of the capital structure, the delta between reported and adjusted ratios remains narrow, confirming that the fundamental trend of increasing financial risk is present regardless of the accounting adjustment used.

Adjusted Return on Equity (ROE) exhibited a consistent upward trajectory from 2014 through 2018, followed by a contraction in 2019. The Adjusted ROE increased from 9.37% in 2014 to a peak of 17.32% in 2018, indicating a significant improvement in the efficiency of generating profits relative to the adjusted equity base over the majority of the analyzed period.

Adjusted Net Earnings Trends

Adjusted net earnings demonstrated substantial growth between 2014 and 2018, rising from 2,132 million US$ to a peak of 5,024 million US$. This growth was characterized by a sharp increase between 2014 and 2015, followed by a period of relative stability and a subsequent peak in 2018. However, a decline occurred in 2019, with earnings falling to 4,182 million US$.

Adjusted Shareholders' Equity Trends

Adjusted total shareholders' equity peaked in 2015 at 33,361 million US$. Following this peak, a consistent year-over-year downward trend is observed, with equity decreasing to 26,712 million US$ by 2019. This sustained reduction in the equity base contributed to the inflation of the ROE percentage during the growth years.

Analysis of Adjusted ROE Dynamics

The expansion of the Adjusted ROE from 2014 to 2018 was driven by a dual mechanism: the growth of adjusted net earnings and the simultaneous contraction of adjusted shareholders' equity. The peak ROE of 17.32% in 2018 reflects the point of maximum divergence between increasing profitability and a shrinking equity base. The decline to 15.66% in 2019 indicates that the drop in adjusted net earnings was more impactful than the continued reduction in shareholders' equity.

The financial trajectory from 2014 to 2019 is characterized by a significant expansion of the asset base and corresponding fluctuations in earnings efficiency. Analysis of the adjusted metrics reveals a period of aggressive growth followed by a phase of stabilization and a eventual decline in profitability relative to assets in the final year of the period.

Adjusted Net Earnings Trends

Adjusted net earnings demonstrated a sharp increase between 2014 and 2015, rising from US$ 2,132 million to US$ 4,420 million. After maintaining a stable range through 2017, earnings peaked in 2018 at US$ 5,024 million. A subsequent contraction occurred in 2019, with adjusted net earnings falling to US$ 4,182 million.

Adjusted Total Asset Base

A substantial increase in adjusted total assets is observed between 2014 and 2015, with the value climbing from US$ 39,482 million to US$ 71,282 million. Assets reached a peak of US$ 75,488 million in 2016 before stabilizing. For the remaining three years, the asset base remained relatively constant, fluctuating between US$ 69,009 million and US$ 71,124 million.

Adjusted Return on Assets (ROA) Performance

The Adjusted ROA exhibited an overall upward trend for the majority of the period, moving from 5.40% in 2014 to a peak of 7.06% in 2018. The ratio remained consistently above 5.9% from 2015 through 2018, indicating a period of improved asset utilization. However, a decline to 5.91% was recorded in 2019, which is attributable to the decrease in adjusted net earnings while the asset base remained largely unchanged.