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: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30).
An analysis of the operational activity ratios from 2016 to 2021 reveals a general deceleration in the collection of receivables and a tightening of the payables payment cycle, alongside significant volatility in working capital efficiency.
- Receivables Management
- A gradual decline in receivables turnover is observed, decreasing from 6.69 in 2016 to 5.50 by 2021. This trend is mirrored by the average receivable collection period, which expanded from 55 days in 2016 to 66 days in 2021. The increase in the collection period suggests a slowing efficiency in converting credit sales into cash.
- Payables Management
- Payables turnover exhibited a strong upward trajectory for most of the period, rising from 44.91 in 2016 to a peak of 82.80 in 2020, before moderating to 61.24 in 2021. Correspondingly, the average payables payment period remained consistently low, decreasing from 8 days in 2016 to 4 days in 2020, and ending at 6 days in 2021. This indicates a strategy of rapid liability settlement.
- Working Capital Utilization
- Working capital turnover showed a substantial increase over several years, climbing from 3.19 in 2016 to a peak of 10.15 in 2020. However, a sharp correction occurred in 2021, with the ratio falling to 5.67. This volatility suggests significant shifts in the relationship between net working capital and annual revenue generation.
The inverse relationship between the lengthening receivable collection period and the shortening payables payment period indicates an increasing gap in the operating cycle, which may place greater pressure on short-term liquidity management.
AI Ask an analyst for more
Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
How can I help you?
Receivables Turnover
| Jun 30, 2021 | Jun 30, 2020 | Jun 30, 2019 | Jun 30, 2018 | Jun 30, 2017 | Jun 30, 2016 | ||
|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | |||||||
| Revenues | 15,005,400) | 14,589,800) | 14,175,200) | 13,325,800) | 12,379,800) | 11,667,800) | |
| Accounts receivable, net of allowance for doubtful accounts | 2,727,400) | 2,441,300) | 2,439,300) | 1,984,200) | 1,703,600) | 1,742,800) | |
| Short-term Activity Ratio | |||||||
| Receivables turnover1 | 5.50 | 5.98 | 5.81 | 6.72 | 7.27 | 6.69 | |
| Benchmarks | |||||||
| Receivables Turnover, Competitors2 | |||||||
| Accenture PLC | 5.74 | — | — | — | — | — | |
| Adobe Inc. | 8.41 | 9.20 | — | — | — | — | |
| AppLovin Corp. | 5.43 | — | — | — | — | — | |
| Cadence Design Systems Inc. | 8.85 | — | — | — | — | — | |
| Datadog Inc. | 3.83 | — | — | — | — | — | |
| International Business Machines Corp. | 8.49 | — | — | — | — | — | |
| Intuit Inc. | 24.64 | — | — | — | — | — | |
| Microsoft Corp. | 4.42 | — | — | — | — | — | |
| Oracle Corp. | 7.48 | — | — | — | — | — | |
| Palantir Technologies Inc. | 8.08 | — | — | — | — | — | |
| Palo Alto Networks Inc. | 3.43 | — | — | — | — | — | |
| Salesforce Inc. | 2.73 | — | — | — | — | — | |
| ServiceNow Inc. | 4.24 | — | — | — | — | — | |
| Synopsys Inc. | 7.40 | 4.72 | — | — | — | — | |
| Workday Inc. | 4.18 | — | — | — | — | — | |
| Receivables Turnover, Sector | |||||||
| Software & Services | 5.23 | — | — | — | — | — | |
| Receivables Turnover, Industry | |||||||
| Information Technology | 7.51 | — | — | — | — | — | |
Based on: 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30).
1 2021 Calculation
Receivables turnover = Revenues ÷ Accounts receivable, net of allowance for doubtful accounts
= 15,005,400 ÷ 2,727,400 = 5.50
2 Click competitor name to see calculations.
A consistent growth trajectory in revenues is observed from 2016 to 2021, with annual figures increasing from approximately $11.67 billion to $15.01 billion. However, this expansion has been accompanied by a more pronounced increase in net accounts receivable, which rose from $1.74 billion in 2016 to $2.73 billion by 2021.
- Receivables Turnover Trend
- The receivables turnover ratio reached a peak of 7.27 in 2017 before entering a general decline, concluding the period at 5.50 in 2021. This downward trend indicates a reduction in the frequency with which the company converts its outstanding receivables into cash over the course of the fiscal year.
- Collection Efficiency Analysis
- A notable shift in efficiency occurred between 2018 and 2019, during which the turnover ratio dropped from 6.72 to 5.81. This decline corresponds with a substantial increase in net accounts receivable, which grew from $1.98 billion to $2.44 billion in a single year, suggesting an extension of the average collection period.
- Revenue and Receivable Correlation
- Between 2016 and 2021, revenues grew by approximately 28.6%, while net accounts receivable grew by approximately 56.7%. The disproportionate growth of receivables relative to revenue explains the compression of the turnover ratio, indicating that a larger percentage of total revenue is remaining tied up in receivables at the end of each reporting period.
AI Ask an analyst for more
Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
How can I help you?
Payables Turnover
| Jun 30, 2021 | Jun 30, 2020 | Jun 30, 2019 | Jun 30, 2018 | Jun 30, 2017 | Jun 30, 2016 | ||
|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | |||||||
| Costs of revenues | 8,640,300) | 8,445,100) | 8,086,600) | 7,842,600) | 7,269,800) | 6,840,300) | |
| Accounts payable | 141,100) | 102,000) | 125,500) | 135,400) | 149,700) | 152,300) | |
| Short-term Activity Ratio | |||||||
| Payables turnover1 | 61.24 | 82.80 | 64.44 | 57.92 | 48.56 | 44.91 | |
| Benchmarks | |||||||
| Payables Turnover, Competitors2 | |||||||
| Accenture PLC | 15.03 | — | — | — | — | — | |
| Adobe Inc. | 5.98 | 5.63 | — | — | — | — | |
| AppLovin Corp. | 3.83 | — | — | — | — | — | |
| Cadence Design Systems Inc. | — | — | — | — | — | — | |
| Datadog Inc. | 9.27 | — | — | — | — | — | |
| International Business Machines Corp. | 6.54 | — | — | — | — | — | |
| Intuit Inc. | 2.70 | — | — | — | — | — | |
| Microsoft Corp. | 3.44 | — | — | — | — | — | |
| Oracle Corp. | 10.54 | — | — | — | — | — | |
| Palantir Technologies Inc. | 4.53 | — | — | — | — | — | |
| Palo Alto Networks Inc. | 22.41 | — | — | — | — | — | |
| Salesforce Inc. | — | — | — | — | — | — | |
| ServiceNow Inc. | 15.20 | — | — | — | — | — | |
| Synopsys Inc. | 31.44 | 26.49 | — | — | — | — | |
| Workday Inc. | 15.85 | — | — | — | — | — | |
| Payables Turnover, Sector | |||||||
| Software & Services | 5.73 | — | — | — | — | — | |
| Payables Turnover, Industry | |||||||
| Information Technology | 4.63 | — | — | — | — | — | |
Based on: 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30).
1 2021 Calculation
Payables turnover = Costs of revenues ÷ Accounts payable
= 8,640,300 ÷ 141,100 = 61.24
2 Click competitor name to see calculations.
An examination of the operational activity between June 30, 2016, and June 30, 2021, reveals a consistent expansion in the costs of revenues alongside significant fluctuations in the management of accounts payable. While operating costs grew steadily, the efficiency and timing of vendor payments underwent a period of acceleration followed by a correction in the final year of the period.
- Costs of Revenues Trend
- A sustained upward trajectory is observed in the costs of revenues, which increased from 6.84 billion US dollars in 2016 to 8.64 billion US dollars in 2021. This steady growth indicates a consistent increase in the direct costs associated with service delivery over the six-year period.
- Accounts Payable Dynamics
- Accounts payable exhibited a general downward trend for the majority of the period, decreasing from 152.3 million US dollars in 2016 to a low of 102.0 million US dollars in 2020. However, this trend reversed sharply in 2021, with payables rising to 141.1 million US dollars, returning to levels closer to those seen at the start of the analysis period.
- Payables Turnover Analysis
- The payables turnover ratio experienced a significant increase from 44.91 in 2016 to a peak of 82.80 in 2020. This progression suggests that the company transitioned toward a much more rapid settlement of its short-term obligations. This efficiency peak coincided with the lowest reported accounts payable balance. In 2021, the ratio declined to 61.24, indicating a deceleration in the turnover rate and a shift back toward extending payment durations to suppliers.
AI Ask an analyst for more
Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
How can I help you?
Working Capital Turnover
| Jun 30, 2021 | Jun 30, 2020 | Jun 30, 2019 | Jun 30, 2018 | Jun 30, 2017 | Jun 30, 2016 | ||
|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | |||||||
| Current assets | 40,741,800) | 31,564,100) | 34,342,300) | 32,050,000) | 32,658,700) | 39,500,400) | |
| Less: Current liabilities | 38,094,800) | 30,126,600) | 32,627,700) | 30,413,600) | 29,815,900) | 35,847,400) | |
| Working capital | 2,647,000) | 1,437,500) | 1,714,600) | 1,636,400) | 2,842,800) | 3,653,000) | |
| Revenues | 15,005,400) | 14,589,800) | 14,175,200) | 13,325,800) | 12,379,800) | 11,667,800) | |
| Short-term Activity Ratio | |||||||
| Working capital turnover1 | 5.67 | 10.15 | 8.27 | 8.14 | 4.35 | 3.19 | |
| Benchmarks | |||||||
| Working Capital Turnover, Competitors2 | |||||||
| Accenture PLC | 12.77 | — | — | — | — | — | |
| Adobe Inc. | 9.09 | 4.89 | — | — | — | — | |
| AppLovin Corp. | 1.08 | — | — | — | — | — | |
| Cadence Design Systems Inc. | 4.01 | — | — | — | — | — | |
| Datadog Inc. | 0.77 | — | — | — | — | — | |
| International Business Machines Corp. | — | — | — | — | — | — | |
| Intuit Inc. | 3.85 | — | — | — | — | — | |
| Microsoft Corp. | 1.76 | — | — | — | — | — | |
| Oracle Corp. | 1.29 | — | — | — | — | — | |
| Palantir Technologies Inc. | 0.70 | — | — | — | — | — | |
| Palo Alto Networks Inc. | — | — | — | — | — | — | |
| Salesforce Inc. | 5.11 | — | — | — | — | — | |
| ServiceNow Inc. | 21.76 | — | — | — | — | — | |
| Synopsys Inc. | 10.65 | 9.00 | — | — | — | — | |
| Workday Inc. | 8.31 | — | — | — | — | — | |
| Working Capital Turnover, Sector | |||||||
| Software & Services | 2.73 | — | — | — | — | — | |
| Working Capital Turnover, Industry | |||||||
| Information Technology | 4.29 | — | — | — | — | — | |
Based on: 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30).
1 2021 Calculation
Working capital turnover = Revenues ÷ Working capital
= 15,005,400 ÷ 2,647,000 = 5.67
2 Click competitor name to see calculations.
The analysis of short-term operating activity indicates a period of consistent revenue expansion contrasted by significant fluctuations in working capital levels, which directly impacted the efficiency of working capital utilization between 2016 and 2021.
- Revenue Performance
- A steady upward trajectory in revenues is observed over the six-year period. Total revenues increased from 11,667,800 thousand USD in 2016 to 15,005,400 thousand USD in 2021, representing consistent year-over-year growth.
- Working Capital Trends
- Working capital exhibited a general downward trend from 2016 through 2020, decreasing from 3,653,000 thousand USD to a period low of 1,437,500 thousand USD. This contraction suggests a lean approach to managing current assets relative to current liabilities. However, this trend reversed sharply in 2021, with working capital rising to 2,647,000 thousand USD.
- Working Capital Turnover Dynamics
- The working capital turnover ratio experienced a substantial increase from 3.19 in 2016 to a peak of 10.15 in 2020. This trend was driven by the simultaneous increase in revenues and the reduction in working capital, indicating an acceleration in the efficiency of generating sales from the company's net current assets. In 2021, the ratio declined to 5.67, a shift directly attributable to the significant increase in working capital that outweighed the modest growth in revenue for that year.
AI Ask an analyst for more
Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
How can I help you?
Average Receivable Collection Period
Automatic Data Processing Inc., average receivable collection period calculation, comparison to benchmarks
| Jun 30, 2021 | Jun 30, 2020 | Jun 30, 2019 | Jun 30, 2018 | Jun 30, 2017 | Jun 30, 2016 | ||
|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||
| Receivables turnover | 5.50 | 5.98 | 5.81 | 6.72 | 7.27 | 6.69 | |
| Short-term Activity Ratio (no. days) | |||||||
| Average receivable collection period1 | 66 | 61 | 63 | 54 | 50 | 55 | |
| Benchmarks (no. days) | |||||||
| Average Receivable Collection Period, Competitors2 | |||||||
| Accenture PLC | 64 | — | — | — | — | — | |
| Adobe Inc. | 43 | 40 | — | — | — | — | |
| AppLovin Corp. | 67 | — | — | — | — | — | |
| Cadence Design Systems Inc. | 41 | — | — | — | — | — | |
| Datadog Inc. | 95 | — | — | — | — | — | |
| International Business Machines Corp. | 43 | — | — | — | — | — | |
| Intuit Inc. | 15 | — | — | — | — | — | |
| Microsoft Corp. | 83 | — | — | — | — | — | |
| Oracle Corp. | 49 | — | — | — | — | — | |
| Palantir Technologies Inc. | 45 | — | — | — | — | — | |
| Palo Alto Networks Inc. | 106 | — | — | — | — | — | |
| Salesforce Inc. | 134 | — | — | — | — | — | |
| ServiceNow Inc. | 86 | — | — | — | — | — | |
| Synopsys Inc. | 49 | 77 | — | — | — | — | |
| Workday Inc. | 87 | — | — | — | — | — | |
| Average Receivable Collection Period, Sector | |||||||
| Software & Services | 70 | — | — | — | — | — | |
| Average Receivable Collection Period, Industry | |||||||
| Information Technology | 49 | — | — | — | — | — | |
Based on: 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30).
1 2021 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 5.50 = 66
2 Click competitor name to see calculations.
An analysis of short-term operating activity reveals a general decline in receivable collection efficiency between 2017 and 2021.
- Receivables Turnover
- The receivables turnover ratio peaked at 7.27 in 2017, indicating the highest level of efficiency in converting receivables to cash during the observed period. Following this peak, a downward trend is evident, with the ratio declining to 5.81 in 2019 and further decreasing to 5.50 by June 30, 2021. This sustained decline suggests a reduction in the velocity of receivable collections.
- Average Receivable Collection Period
- The average receivable collection period mirrors the inverse movement of the turnover ratio. The shortest collection window occurred in 2017 at 50 days. This period lengthened to 63 days in 2019 and reached its maximum of 66 days in 2021. The increase of 16 days from the 2017 low indicates a slowing of the cash inflow process from customers.
The correlation between the decreasing turnover ratio and the increasing collection period suggests a systematic extension of the time required to realize payments. While the collection cycle remained relatively stable between 2016 and 2018, the period from 2019 to 2021 is characterized by a notable expansion in the number of days receivables remain outstanding, which indicates a potential shift in credit terms or a decrease in collection effectiveness.
AI Ask an analyst for more
Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
How can I help you?
Average Payables Payment Period
Automatic Data Processing Inc., average payables payment period calculation, comparison to benchmarks
| Jun 30, 2021 | Jun 30, 2020 | Jun 30, 2019 | Jun 30, 2018 | Jun 30, 2017 | Jun 30, 2016 | ||
|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||
| Payables turnover | 61.24 | 82.80 | 64.44 | 57.92 | 48.56 | 44.91 | |
| Short-term Activity Ratio (no. days) | |||||||
| Average payables payment period1 | 6 | 4 | 6 | 6 | 8 | 8 | |
| Benchmarks (no. days) | |||||||
| Average Payables Payment Period, Competitors2 | |||||||
| Accenture PLC | 24 | — | — | — | — | — | |
| Adobe Inc. | 61 | 65 | — | — | — | — | |
| AppLovin Corp. | 95 | — | — | — | — | — | |
| Cadence Design Systems Inc. | — | — | — | — | — | — | |
| Datadog Inc. | 39 | — | — | — | — | — | |
| International Business Machines Corp. | 56 | — | — | — | — | — | |
| Intuit Inc. | 135 | — | — | — | — | — | |
| Microsoft Corp. | 106 | — | — | — | — | — | |
| Oracle Corp. | 35 | — | — | — | — | — | |
| Palantir Technologies Inc. | 81 | — | — | — | — | — | |
| Palo Alto Networks Inc. | 16 | — | — | — | — | — | |
| Salesforce Inc. | — | — | — | — | — | — | |
| ServiceNow Inc. | 24 | — | — | — | — | — | |
| Synopsys Inc. | 12 | 14 | — | — | — | — | |
| Workday Inc. | 23 | — | — | — | — | — | |
| Average Payables Payment Period, Sector | |||||||
| Software & Services | 64 | — | — | — | — | — | |
| Average Payables Payment Period, Industry | |||||||
| Information Technology | 79 | — | — | — | — | — | |
Based on: 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30).
1 2021 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 61.24 = 6
2 Click competitor name to see calculations.
The analysis of short-term operating activity indicates a period of increasing efficiency in settling accounts payable from 2016 through 2020, followed by a moderate correction in 2021. The overall trend suggests a highly accelerated payment cycle.
- Payables Turnover
- A consistent upward trend is observed from 2016 to 2020, with the ratio increasing from 44.91 to a peak of 82.80. This progression indicates that obligations to suppliers were settled with increasing frequency over this five-year period. This trend reversed in 2021, as the ratio declined to 61.24, suggesting a deceleration in the turnover rate relative to the preceding year.
- Average Payables Payment Period
- The payment duration remained stable at 8 days throughout 2016 and 2017, followed by a reduction to 6 days in 2018 and 2019. The shortest payment cycle was recorded in 2020, reaching a minimum of 4 days. In 2021, the period returned to 6 days, mirroring the decline observed in the turnover ratio.
- Operational Correlation and Insights
- A clear inverse correlation exists between the payables turnover ratio and the average payment period. The peak turnover in 2020 corresponds directly with the shortest payment window of 4 days. The consistently low number of days required to settle payables indicates a highly liquid position or a strategic preference for rapid settlement of short-term liabilities, maintaining an average cycle well below 10 days across the entire period analyzed.
AI Ask an analyst for more
Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
How can I help you?