Walgreens Boots Alliance Inc. (NASDAQ:WBA)

The operational activity ratios indicate a systematic optimization of the working capital cycle between 2014 and 2019. A primary trend is the significant contraction of the time required to convert operational resources into cash, driven by both improved internal efficiencies and strategic changes in supplier payment terms.

Inventory Efficiency

A consistent upward trend in inventory turnover is observed, rising from 9.02 in 2014 to 11.44 in 2019. This improvement is mirrored in the average inventory processing period, which decreased from 40 days to 32 days over the same period, indicating a more rapid movement of goods through the supply chain.

Receivables and Payables Management

Receivables turnover experienced volatility, decreasing from 23.74 in 2014 to 18.94 in 2019, while the average collection period shifted from 15 days to a stabilized range of 18 to 20 days. Conversely, a sharp decline in payables turnover occurred between 2014 and 2015, dropping from 12.71 to 7.59 and remaining relatively stagnant thereafter. This correlates with an extension of the average payables payment period from 29 days in 2014 to 49 days in 2019, suggesting a strategic shift toward utilizing supplier credit to finance operations.

Cash Cycle Optimization

The operating cycle remained relatively stable, moving from 55 days in 2014 to 51 days in 2019, despite a temporary peak of 65 days in 2015. However, the cash conversion cycle shows a dramatic downward trajectory, falling from 26 days in 2014 to only 2 days in 2019. This reduction is the result of the combined effect of accelerating inventory turnover and significantly delaying payments to creditors.

Working Capital Utilization

Working capital turnover exhibited extreme volatility during the recorded period, rising from 22.82 in 2014 to 98.02 in 2017 before data became unavailable for the final two years. This suggests significant fluctuations in the relationship between net working capital and net sales.

An evaluation of the operating activity from 2014 to 2019 indicates a sustained improvement in inventory management efficiency. The operational capacity expanded significantly over this period, characterized by a consistent rise in the cost of sales, while inventory levels were managed with relative stability, resulting in an improved turnover rate.

Cost of Sales Growth

A strong upward trajectory is observed in the cost of sales, which increased from 54,823 million USD in 2014 to 106,790 million USD in 2019. This represents a substantial increase in the volume of goods sold over the six-year window.

Inventory Level Stability

Inventory levels experienced an initial sharp increase between 2014 and 2015, rising from 6,076 million USD to 8,678 million USD. Following this initial surge, inventory holdings remained relatively stable, fluctuating between approximately 8.6 billion and 9.6 billion USD through 2019, despite the continued expansion of sales volume.

Inventory Turnover Performance

The inventory turnover ratio demonstrates a positive trend, rising from 9.02 in 2014 to 11.44 by 2019. After a marginal decline to 8.82 in 2015, the ratio improved consistently each year. This progression indicates enhanced efficiency in stock rotation and suggests that the organization is moving inventory more rapidly relative to its investment in stock.

Between 2014 and 2019, a significant expansion in sales volume was observed, accompanied by a substantial increase in net accounts receivable. While revenue growth remained consistent throughout the period, the efficiency of receivables collection experienced a period of volatility before reaching a state of relative stability.

Sales Performance

Revenue exhibited a strong upward trajectory, increasing from US$ 76,392 million in 2014 to US$ 136,866 million by 2019. The most pronounced growth occurred between 2014 and 2016, followed by a steady climb in subsequent years.

Accounts Receivable Trends

Net accounts receivable grew sharply from US$ 3,218 million in 2014 to US$ 6,849 million in 2015. Following this initial surge, the balance remained relatively stable, fluctuating between US$ 6,260 million and US$ 7,226 million through 2019.

Receivables Turnover Analysis

The turnover ratio declined significantly from 23.74 in 2014 to a low of 15.10 in 2015, coinciding with the sharp rise in receivables. A recovery was observed in 2016, with the ratio ascending to 18.75. From 2016 to 2019, the ratio remained stable, oscillating within a narrow band between 18.11 and 20.01.

The correlation between the increase in sales and the expansion of the receivables balance suggests a shift in the company's operating scale or credit terms around 2015. Despite the initial drop in turnover efficiency, the stabilization of the ratio from 2016 onward indicates that the organization successfully aligned its collection processes with its expanded revenue base, maintaining a consistent rate of credit recovery relative to its sales growth.

An analysis of the operational activity reveals a significant expansion in the scale of expenditures and a strategic shift in the management of trade liabilities between 2014 and 2019. Cost of sales exhibited consistent growth, increasing from 54,823 million US dollars in 2014 to 106,790 million US dollars by 2019, representing a near doubling of the total volume of goods sold over the six-year period.

Trade Accounts Payable Trends

A substantial increase in trade accounts payable is observed, particularly between 2014 and 2015, during which obligations rose from 4,315 million US dollars to 10,088 million US dollars. This expansion continued at a more moderate pace thereafter, culminating in a balance of 14,341 million US dollars by August 31, 2019.

Payables Turnover Dynamics

The payables turnover ratio experienced a marked decline from 12.71 in 2014 to 7.59 in 2015. From 2015 through 2019, the ratio stabilized, maintaining a consistent range between 7.13 and 7.95, indicating the establishment of a new steady state in the payment cycle.

Working Capital Interpretation

The transition to a lower turnover ratio suggests a strategic adjustment in supplier credit terms. By extending the average duration before payments are settled, the organization has effectively increased its utilization of trade credit, which serves to preserve cash flow and optimize the overall cash conversion cycle.

Analysis of short-term operating activity reveals a divergent trend between revenue growth and working capital management from 2014 to 2019.

Revenue Growth Trends

Sales exhibited consistent and sustained growth over the analyzed period, rising from 76,392 million USD in 2014 to 136,866 million USD by 2019. This steady upward trajectory indicates a continuous expansion of the company's top-line volume.

Working Capital Dynamics

Working capital demonstrated significant volatility and a eventual structural shift. Following a period of relative stability in 2014 and 2015, a sharp increase to 8,870 million USD occurred in 2016. This was followed by a rapid contraction, with working capital falling to 1,206 million USD in 2017 and transitioning into negative territory in 2018 and 2019, reaching -7,069 million USD by the end of the period.

Working Capital Turnover Analysis

The working capital turnover ratio showed extreme fluctuations corresponding to the volatility in current assets and liabilities. The ratio rose from 22.82 in 2014 to 33.37 in 2015, dropped to 13.23 in 2016 due to the spike in working capital, and then surged to 98.02 in 2017 as working capital diminished. For the 2018 and 2019 periods, the ratio is not applicable due to the deficit in working capital. The move toward negative working capital suggests an operational model where current liabilities are used to finance the growth in sales and overall operations.

An evaluation of the operating activity ratios between 2014 and 2019 reveals a consistent improvement in inventory management efficiency and an acceleration of the operational cycle.

Inventory Turnover

The inventory turnover ratio exhibited an overall upward trajectory, rising from 9.02 in 2014 to 11.44 by 2019. Despite a marginal decrease to 8.82 in 2015, the ratio grew steadily for four consecutive years thereafter. This trend indicates an increased frequency of inventory replacement and enhanced sales velocity.

Average Inventory Processing Period

The time required to process inventory showed a corresponding downward trend, decreasing from 40 days in 2014 to 32 days in 2019. Following a slight peak of 41 days in 2015, the processing period declined annually. This reduction reflects a decrease in the duration that capital remains immobilized in the form of unsold stock.

The inverse correlation between the rising turnover ratio and the declining processing period underscores a strengthening of the operational cycle. The reduction of eight days in the processing period over the analyzed timeframe suggests optimized supply chain logistics and improved demand forecasting, contributing to higher liquidity.

The analysis of short-term operating activity indicates a period of volatility in receivables management between 2014 and 2019, followed by a trend of stabilization. The most notable fluctuation occurred during the 2015 fiscal year, which represented a temporary decrease in collection efficiency.

Receivables Turnover

A significant contraction in the turnover ratio is observed from 23.74 in 2014 to 15.10 in 2015. Subsequent years show a recovery and stabilization, with the ratio fluctuating between 18.11 and 20.01 from 2016 through 2019. This suggests a restoration of the efficiency with which credit sales are converted into cash following the 2015 decline.

Average Receivable Collection Period

The collection period experienced a sharp increase from 15 days in 2014 to a peak of 24 days in 2015. From 2016 to 2019, the collection timeframe stabilized, remaining within a narrow range of 18 to 20 days. The decrease from the 24-day peak indicates an improvement in the speed of recovering outstanding payments.

Operational Efficiency Trends

An inverse correlation between the turnover ratio and the collection period is evident throughout the observed timeframe. The maximum collection period in 2015 corresponds directly with the minimum turnover ratio, highlighting a specific period of reduced liquidity regarding receivables. The subsequent consistency in these metrics suggests the establishment of a more predictable credit collection cycle in the latter years of the analysis.

The overall operating cycle demonstrates a general trend of contraction between 2014 and 2019, despite a significant peak in 2015. This reduction indicates an improvement in the efficiency of the cash conversion process, reflecting a shorter duration between the acquisition of inventory and the collection of cash from sales.

Average Inventory Processing Period

A consistent decline is observed following a slight increase in 2015. The processing period decreased from 40 days in 2014 to 32 days by 2019. This steady downward trend suggests an increase in inventory turnover efficiency and a more streamlined approach to managing stock levels.

Average Receivable Collection Period

This metric exhibited volatility early in the period, rising sharply from 15 days in 2014 to 24 days in 2015. In the subsequent years, the collection period stabilized, fluctuating within a narrow range of 18 to 20 days. This suggests that after an initial period of instability, the credit and collection processes reached a state of equilibrium.

Operating Cycle

The total operating cycle reached a maximum of 65 days in 2015, driven by concurrent increases in both inventory processing and receivable collection times. Following this peak, the cycle contracted steadily, ending at 51 days in 2019. The overall reduction in the operating cycle is primarily attributable to the continuous improvement in inventory processing speed rather than changes in the collection of receivables.

A significant shift in the management of trade payables is evident between 2014 and 2019. The company transitioned from a rapid payment cycle to a more extended duration, which subsequently stabilized over a five-year period. This change indicates a strategic adjustment in working capital management to optimize liquidity and cash flow.

Payables Turnover

A sharp decline in the turnover ratio is observed between August 2014 (12.71) and August 2015 (7.59). From 2015 through 2019, the ratio remained relatively constant, fluctuating within a narrow range between 7.13 and 7.95. This trend signifies a reduction in the frequency with which short-term obligations to suppliers were settled.

Average Payables Payment Period

The period required to settle payables increased substantially from 29 days in 2014 to 48 days in 2015. Following this initial surge, the payment period exhibited stability, peaking at 51 days in 2017 before settling at 49 days in 2018 and 2019. The extension of the payment window by approximately 20 days suggests an increase in leverage over suppliers or the negotiation of more favorable credit terms, allowing the company to retain cash for longer durations.

The cash conversion cycle exhibits a consistent and significant downward trend over the analyzed period, decreasing from 26 days in 2014 to 2 days by 2019. This progression indicates a substantial optimization of working capital management, resulting in a near-immediate conversion of resource inputs into cash.

Average Inventory Processing Period

A gradual reduction in the time required to process inventory is observed, falling from 40 days in 2014 to 32 days in 2019. This decline suggests improved inventory turnover and more efficient supply chain management.

Average Receivable Collection Period

The collection period demonstrates moderate volatility. After an initial increase from 15 days in 2014 to 24 days in 2015, the period stabilized between 18 and 20 days for the remainder of the period. While slightly higher than the 2014 baseline, this metric remained relatively consistent.

Average Payables Payment Period

A significant shift occurred in the management of payables, with the payment period increasing from 29 days in 2014 to 48 days in 2015, subsequently stabilizing around 49 days. This suggests a strategic extension of credit terms from suppliers, effectively using accounts payable as a source of short-term financing.

Cash Conversion Cycle Synthesis

The overall compression of the cash conversion cycle is primarily driven by the synergy between faster inventory turnover and the strategic extension of the payables payment period. The increase in the time taken to pay suppliers more than offset the modest increase in receivable collection times, leading to a highly efficient liquidity position by 2019.