Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.
Short-term Activity Ratios (Summary)
Turnover Ratios
Average No. Days
Based on: 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31).
The analysis of short-term operating activity ratios reveals a stable operational framework characterized by consistent inventory and receivable management, complemented by a strategic extension of the payables payment period.
- Inventory and Receivables Efficiency
- Inventory turnover exhibited minor fluctuations, peaking at 7.11 in 2018 before declining to 6.47 by 2020. This is mirrored in the average inventory processing period, which remained within a tight range of 51 to 56 days. Similarly, the receivables turnover remained steady, fluctuating between 7.89 and 8.56, with the average collection period consistently maintained between 43 and 46 days. These patterns indicate a predictable and stable cycle for converting inventory into sales and sales into cash.
- Payables Management Trends
- A consistent downward trend is observed in the payables turnover ratio, which decreased from 4.43 in 2016 to 3.69 in 2020. This trend is further evidenced by the average payables payment period, which rose steadily from 82 days to 99 days. The extension of this period suggests an increased utilization of supplier credit to support working capital requirements.
- Operating and Cash Conversion Cycles
- The operating cycle showed minimal volatility, fluctuating between 94 and 102 days throughout the period. In contrast, the cash conversion cycle experienced a significant contraction, falling from 15 days in 2016 to a low of 4 days in 2018, before settling at 8 days in 2019. This improvement in the cash conversion cycle was primarily driven by the increasing gap between the operating cycle and the payables payment period, effectively reducing the net time the company's capital is tied up in operations.
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?
Inventory Turnover
| Dec 31, 2020 | Dec 31, 2019 | Dec 31, 2018 | Dec 31, 2017 | Dec 31, 2016 | ||
|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||
| Cost of products sold | 12,318) | 12,415) | 12,889) | 11,706) | 11,551) | |
| Inventories | 1,903) | 1,790) | 1,813) | 1,790) | 1,679) | |
| Short-term Activity Ratio | ||||||
| Inventory turnover1 | 6.47 | 6.94 | 7.11 | 6.54 | 6.88 | |
| Benchmarks | ||||||
| Inventory Turnover, Competitors2 | ||||||
| Procter & Gamble Co. | — | — | — | — | — | |
Based on: 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31).
1 2020 Calculation
Inventory turnover = Cost of products sold ÷ Inventories
= 12,318 ÷ 1,903 = 6.47
2 Click competitor name to see calculations.
The cost of products sold exhibited a general upward trajectory from 2016 through 2018, peaking at 12,889 million US dollars before declining to 12,318 million US dollars by 2020. Concurrently, inventory levels increased from 1,679 million US dollars in 2016 to 1,903 million US dollars in 2020, reflecting a overall growth in the volume of stock held.
- Inventory Turnover Ratio Volatility
- The inventory turnover ratio fluctuated over the five-year period, reaching a peak of 7.11 in 2018 and a low of 6.47 in 2020. The peak in 2018 indicates the highest level of efficiency in converting inventory into sales relative to the cost of products sold during the observed window.
- Analysis of Efficiency Decline
- A downward trend in turnover efficiency is observed between 2018 and 2020. This contraction is driven by a combination of decreasing costs of products sold and increasing inventory levels, which resulted in a slower inventory replacement rate by the end of the 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?
Receivables Turnover
| Dec 31, 2020 | Dec 31, 2019 | Dec 31, 2018 | Dec 31, 2017 | Dec 31, 2016 | ||
|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||
| Net sales | 19,140) | 18,450) | 18,486) | 18,259) | 18,202) | |
| Accounts receivable, net | 2,235) | 2,263) | 2,164) | 2,315) | 2,176) | |
| Short-term Activity Ratio | ||||||
| Receivables turnover1 | 8.56 | 8.15 | 8.54 | 7.89 | 8.36 | |
| Benchmarks | ||||||
| Receivables Turnover, Competitors2 | ||||||
| Procter & Gamble Co. | — | — | — | — | — | |
Based on: 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31).
1 2020 Calculation
Receivables turnover = Net sales ÷ Accounts receivable, net
= 19,140 ÷ 2,235 = 8.56
2 Click competitor name to see calculations.
The relationship between net sales and accounts receivable from 2016 to 2020 indicates a stable and consistent operating cycle. While net sales grew moderately, the balance of outstanding receivables remained controlled, resulting in a steady rate of collection.
- Net Sales and Receivables Volume
- Net sales demonstrated a gradual increase, rising from US$ 18,202 million in 2016 to US$ 19,140 million in 2020. During this same interval, net accounts receivable fluctuated within a narrow range, starting at US$ 2,176 million and ending at US$ 2,235 million. This suggests that the company managed to increase its revenue stream without a corresponding expansion in the credit extended to customers.
- Receivables Turnover Trends
- The receivables turnover ratio remained relatively stable, oscillating between a low of 7.89 in 2017 and a high of 8.56 in 2020. After a slight dip in 2017, the ratio recovered to 8.54 in 2018, experienced a minor decrease to 8.15 in 2019, and concluded the period at its peak efficiency of 8.56.
- Collection Efficiency Insights
- The lack of significant variance in the turnover ratio points to a disciplined credit policy and an efficient collection process. The peak turnover ratio achieved in 2020, coinciding with the highest reported net sales of the period, indicates that the company successfully scaled its sales volume while optimizing the conversion of receivables into cash.
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?
Payables Turnover
| Dec 31, 2020 | Dec 31, 2019 | Dec 31, 2018 | Dec 31, 2017 | Dec 31, 2016 | ||
|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||
| Cost of products sold | 12,318) | 12,415) | 12,889) | 11,706) | 11,551) | |
| Trade accounts payable | 3,336) | 3,055) | 3,190) | 2,834) | 2,609) | |
| Short-term Activity Ratio | ||||||
| Payables turnover1 | 3.69 | 4.06 | 4.04 | 4.13 | 4.43 | |
| Benchmarks | ||||||
| Payables Turnover, Competitors2 | ||||||
| Procter & Gamble Co. | — | — | — | — | — | |
Based on: 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31).
1 2020 Calculation
Payables turnover = Cost of products sold ÷ Trade accounts payable
= 12,318 ÷ 3,336 = 3.69
2 Click competitor name to see calculations.
The analysis of short-term operating activity reveals a general decline in the payables turnover ratio over the five-year period from 2016 to 2020. This trend indicates a slowing rate at which trade obligations are settled, suggesting a shift in working capital management strategies.
- Payables Turnover Performance
- The payables turnover ratio decreased from 4.43 in 2016 to 3.69 by the end of 2020. While there was a marginal stabilization in 2019 at 4.06, the overall trajectory points toward an increase in the average time required to pay suppliers. This reduction suggests that the company is extending its payment cycles, which effectively increases the amount of interest-free financing obtained from vendors.
- Cost of Products Sold Dynamics
- Cost of products sold exhibited a period of growth between 2016 and 2018, rising from 11,551 million US$ to a peak of 12,889 million US$. Following this peak, a slight contraction occurred, with values settling at 12,318 million US$ in 2020. The lack of proportional growth in product costs relative to the increase in payables contributed to the decline in the turnover ratio.
- Trade Accounts Payable Trends
- Trade accounts payable demonstrated a steady upward trend, increasing from 2,609 million US$ in 2016 to 3,336 million US$ in 2020. This growth represents a significant increase in the company's short-term liabilities to suppliers. The expansion of payables remained consistent even during the slight dip in costs of products sold observed in 2019, further depressing the turnover ratio in the final year of the analyzed period.
- Working Capital Implications
- The divergence between the stabilizing cost of products sold and the rising trade accounts payable indicates a deliberate or systemic extension of payment terms. By slowing the turnover of payables, the company retains cash for longer durations, which may be used to support other operational needs or improve liquidity positions, provided that such extensions do not strain supplier relationships.
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?
Working Capital Turnover
| Dec 31, 2020 | Dec 31, 2019 | Dec 31, 2018 | Dec 31, 2017 | Dec 31, 2016 | ||
|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||
| Current assets | 5,174) | 5,057) | 5,041) | 5,211) | 5,115) | |
| Less: Current liabilities | 6,443) | 6,919) | 6,536) | 5,858) | 5,846) | |
| Working capital | (1,269) | (1,862) | (1,495) | (647) | (731) | |
| Net sales | 19,140) | 18,450) | 18,486) | 18,259) | 18,202) | |
| Short-term Activity Ratio | ||||||
| Working capital turnover1 | — | — | — | — | — | |
| Benchmarks | ||||||
| Working Capital Turnover, Competitors2 | ||||||
| Procter & Gamble Co. | — | — | — | — | — | |
Based on: 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31).
1 2020 Calculation
Working capital turnover = Net sales ÷ Working capital
= 19,140 ÷ -1,269 = —
2 Click competitor name to see calculations.
An analysis of the short-term operating activity reveals a consistent pattern of negative working capital maintained throughout the five-year period from 2016 to 2020. This structural positioning indicates that current liabilities exceeded current assets consistently, a strategy often associated with high operational efficiency or the utilization of supplier credit to fund business activities.
- Working Capital Trends
- The working capital deficit experienced significant fluctuations, starting at -731 million USD in 2016 and improving slightly to -647 million USD in 2017. However, a substantial increase in the deficit occurred in 2018 and 2019, reaching a peak negative value of -1,862 million USD. By 2020, the deficit moderated to -1,269 million USD, though it remained significantly higher than 2016 and 2017 levels.
- Net Sales Performance
- Net sales demonstrated a steady upward trajectory, growing from 18,202 million USD in 2016 to 19,140 million USD in 2020. This growth remained stable and incremental, showing a low degree of volatility despite the significant shifts in the underlying working capital structure.
- Working Capital Turnover Interpretation
- The working capital turnover ratio is mathematically negative due to the persistent deficit in working capital. The widening of the working capital deficit between 2018 and 2019 coincided with stable sales, suggesting an intensification of the company's reliance on negative working capital to support its operations. The subsequent reduction of the deficit in 2020, paired with the highest recorded net sales in the period, indicates a slight rebalancing of current assets and liabilities while maintaining an aggressive operational liquidity posture.
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?
Average Inventory Processing Period
| Dec 31, 2020 | Dec 31, 2019 | Dec 31, 2018 | Dec 31, 2017 | Dec 31, 2016 | ||
|---|---|---|---|---|---|---|
| Selected Financial Data | ||||||
| Inventory turnover | 6.47 | 6.94 | 7.11 | 6.54 | 6.88 | |
| Short-term Activity Ratio (no. days) | ||||||
| Average inventory processing period1 | 56 | 53 | 51 | 56 | 53 | |
| Benchmarks (no. days) | ||||||
| Average Inventory Processing Period, Competitors2 | ||||||
| Procter & Gamble Co. | — | — | — | — | — | |
Based on: 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31).
1 2020 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 6.47 = 56
2 Click competitor name to see calculations.
The inventory management metrics exhibit a pattern of fluctuation between 2016 and 2020, indicating variability in the efficiency of stock turnover and processing times.
- Inventory Turnover Ratio
- The inventory turnover ratio demonstrates a non-linear trend, starting at 6.88 in 2016 and reaching a peak of 7.11 in 2018. Following this peak, a steady decline is observed, with the ratio falling to 6.94 in 2019 and further decreasing to 6.47 in 2020. This final value represents the lowest turnover rate within the analyzed five-year period, suggesting a reduction in the frequency of inventory replacement.
- Average Inventory Processing Period
- The average inventory processing period moves in inverse correlation with the turnover ratio, fluctuating within a range of 51 to 56 days. The most efficient processing cycle was recorded in 2018 at 51 days, aligning with the peak turnover ratio. However, the processing period lengthened to 56 days in 2017 and again in 2020. The increase to 56 days by the end of 2020 indicates a deceleration in the movement of goods through the operating cycle compared to the efficiency levels seen in 2018.
Overall, the analysis reveals a cyclical movement in operating activity. The gains in efficiency achieved in 2018 were not sustained, as both the turnover ratio and the processing period returned to, or exceeded, the less efficient levels observed in 2017 by the conclusion of 2020.
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?
Average Receivable Collection Period
| Dec 31, 2020 | Dec 31, 2019 | Dec 31, 2018 | Dec 31, 2017 | Dec 31, 2016 | ||
|---|---|---|---|---|---|---|
| Selected Financial Data | ||||||
| Receivables turnover | 8.56 | 8.15 | 8.54 | 7.89 | 8.36 | |
| Short-term Activity Ratio (no. days) | ||||||
| Average receivable collection period1 | 43 | 45 | 43 | 46 | 44 | |
| Benchmarks (no. days) | ||||||
| Average Receivable Collection Period, Competitors2 | ||||||
| Procter & Gamble Co. | — | — | — | — | — | |
Based on: 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31).
1 2020 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 8.56 = 43
2 Click competitor name to see calculations.
The analysis of short-term activity ratios from 2016 to 2020 indicates a high degree of stability in the management of accounts receivable. The relationship between turnover rates and the collection cycle remains consistent, suggesting a disciplined and predictable approach to credit terms and collections over the five-year period.
- Receivables Turnover
- The receivables turnover ratio exhibited minor fluctuations, ranging from a minimum of 7.89 in 2017 to a maximum of 8.56 in 2020. Although temporary declines were noted in 2017 and 2019, the ratio recovered in subsequent years, ending the period at its highest point. This pattern suggests a consistent ability to convert receivables into cash without significant volatility.
- Average Receivable Collection Period
- The average collection period remained stable, oscillating within a narrow window of 43 to 46 days. The peak collection time of 46 days occurred in 2017, which corresponds directly with the lowest observed turnover ratio. The subsequent reduction to 43 days in 2018 and again in 2020 demonstrates a maintained efficiency in the credit-to-cash cycle, with no evidence of deteriorating credit quality or collection delays.
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?
Operating Cycle
| Dec 31, 2020 | Dec 31, 2019 | Dec 31, 2018 | Dec 31, 2017 | Dec 31, 2016 | ||
|---|---|---|---|---|---|---|
| Selected Financial Data | ||||||
| Average inventory processing period | 56 | 53 | 51 | 56 | 53 | |
| Average receivable collection period | 43 | 45 | 43 | 46 | 44 | |
| Short-term Activity Ratio | ||||||
| Operating cycle1 | 99 | 98 | 94 | 102 | 97 | |
| Benchmarks | ||||||
| Operating Cycle, Competitors2 | ||||||
| Procter & Gamble Co. | — | — | — | — | — | |
Based on: 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31).
1 2020 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= 56 + 43 = 99
2 Click competitor name to see calculations.
The operating cycle exhibits a consistent pattern of stability between 2016 and 2020, with the total duration for converting resources into cash fluctuating within a narrow range of 94 to 102 days. This stability indicates a predictable and well-managed short-term operational flow.
- Average Inventory Processing Period
- The inventory processing period shows moderate variance, oscillating between a minimum of 51 days in 2018 and a maximum of 56 days in 2017 and 2020. These fluctuations suggest slight variations in inventory turnover efficiency over the five-year period, though the metric generally centers around an average of 53 days.
- Average Receivable Collection Period
- The collection period demonstrates a high level of consistency, remaining between 43 and 46 days. A slight tightening of the collection window is observed by 2020, returning to 43 days, which indicates a stable and effective credit management policy regarding customer payments.
- Operating Cycle Synthesis
- The overall operating cycle peaked at 102 days in 2017 and reached a low of 94 days in 2018. A comparative analysis of the components reveals that the variability in the total operating cycle is primarily driven by changes in the inventory processing period rather than the receivable collection period, as the latter remained relatively flat across the observed timeframe.
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?
Average Payables Payment Period
| Dec 31, 2020 | Dec 31, 2019 | Dec 31, 2018 | Dec 31, 2017 | Dec 31, 2016 | ||
|---|---|---|---|---|---|---|
| Selected Financial Data | ||||||
| Payables turnover | 3.69 | 4.06 | 4.04 | 4.13 | 4.43 | |
| Short-term Activity Ratio (no. days) | ||||||
| Average payables payment period1 | 99 | 90 | 90 | 88 | 82 | |
| Benchmarks (no. days) | ||||||
| Average Payables Payment Period, Competitors2 | ||||||
| Procter & Gamble Co. | — | — | — | — | — | |
Based on: 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31).
1 2020 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 3.69 = 99
2 Click competitor name to see calculations.
An analysis of the operating activity ratios reveals a consistent trend toward extending the duration of accounts payable obligations over the five-year period ending December 31, 2020.
- Payables Turnover
- The payables turnover ratio experienced a general decline, decreasing from 4.43 in 2016 to 3.69 in 2020. Although a marginal stabilization was observed in 2019 with a ratio of 4.06, the overall trajectory indicates a reduction in the frequency with which supplier obligations are settled.
- Average Payables Payment Period
- The average payables payment period exhibited a steady upward trend, increasing from 82 days in 2016 to 99 days by December 31, 2020. The period remained stable at 90 days during 2018 and 2019 before experiencing a notable increase of nine days in the final year of the analyzed period.
- Working Capital Implications
- The inverse relationship between the declining turnover ratio and the rising payment period suggests a strategic extension of credit terms. By increasing the average payment duration to 99 days, the organization has effectively retained cash for longer periods, thereby enhancing short-term liquidity and optimizing the cash conversion cycle through the utilization of supplier financing.
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?
Cash Conversion Cycle
| Dec 31, 2020 | Dec 31, 2019 | Dec 31, 2018 | Dec 31, 2017 | Dec 31, 2016 | ||
|---|---|---|---|---|---|---|
| Selected Financial Data | ||||||
| Average inventory processing period | 56 | 53 | 51 | 56 | 53 | |
| Average receivable collection period | 43 | 45 | 43 | 46 | 44 | |
| Average payables payment period | 99 | 90 | 90 | 88 | 82 | |
| Short-term Activity Ratio | ||||||
| Cash conversion cycle1 | 0 | 8 | 4 | 14 | 15 | |
| Benchmarks | ||||||
| Cash Conversion Cycle, Competitors2 | ||||||
| Procter & Gamble Co. | — | — | — | — | — | |
Based on: 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31).
1 2020 Calculation
Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= 56 + 43 – 99 = 0
2 Click competitor name to see calculations.
The analysis of operating activity ratios from 2016 to 2020 reveals a strategic optimization of working capital, characterized by a significant extension of payment terms to suppliers and stable operational efficiency in inventory and receivables.
- Inventory and Receivables Management
- The average inventory processing period demonstrated relative stability, fluctuating between a minimum of 51 days in 2018 and a maximum of 56 days in 2017 and 2020. Parallel to this, the average receivable collection period remained consistent, oscillating within a narrow range of 43 to 46 days. These patterns indicate a steady state in production turnover and a disciplined approach to credit collection.
- Payables Payment Period
- A consistent upward trend is observed in the average payables payment period, which rose from 82 days in 2016 to 99 days by 2020. This progression suggests a deliberate increase in the duration the organization takes to settle its obligations, effectively utilizing supplier credit as a source of short-term financing to enhance liquidity.
- Cash Conversion Cycle (CCC)
- The cash conversion cycle underwent a notable compression, decreasing from 15 days in 2016 to 8 days in 2019. A significant low was reached in 2018 at 4 days. This reduction in the CCC is primarily driven by the widening gap between the payables payment period and the combined duration of the inventory and receivables cycles, thereby accelerating the recovery of cash invested in operations.
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?