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)
Based on: 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).
Short-term activity ratio | Description | The company |
---|---|---|
Receivables turnover | An activity ratio equal to revenue divided by receivables. | Etsy Inc. receivables turnover ratio improved from Q1 2022 to Q2 2022 but then deteriorated significantly from Q2 2022 to Q3 2022. |
Payables turnover | An activity ratio calculated as cost of goods sold divided by payables. | Etsy Inc. payables turnover ratio decreased from Q1 2022 to Q2 2022 but then increased from Q2 2022 to Q3 2022 not reaching Q1 2022 level. |
Working capital turnover | An activity ratio calculated as revenue divided by working capital. | Etsy Inc. working capital turnover ratio deteriorated from Q1 2022 to Q2 2022 but then improved from Q2 2022 to Q3 2022 not reaching Q1 2022 level. |
Short-term activity ratio | Description | The company |
---|---|---|
Average receivable collection period | An activity ratio equal to the number of days in the period divided by receivables turnover. | |
Average payables payment period | An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. |
Receivables Turnover
Sep 30, 2022 | Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | Dec 31, 2017 | Sep 30, 2017 | Jun 30, 2017 | Mar 31, 2017 | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Selected Financial Data (US$ in thousands) | ||||||||||||||||||||||||||||||
Revenue | 594,469) | 585,135) | 579,266) | 717,139) | 532,429) | 528,900) | 550,646) | 617,355) | 451,478) | 428,737) | 228,055) | 269,998) | 197,947) | 181,095) | 169,339) | 200,028) | 150,366) | 132,387) | 120,912) | 136,268) | 106,380) | 101,692) | 96,891) | |||||||
Accounts receivable, net of expected credit losses | 21,765) | 20,133) | 20,645) | 27,266) | 23,884) | 20,283) | 22,991) | 22,605) | 16,311) | 16,527) | 11,712) | 15,386) | 12,494) | 10,585) | 10,789) | 12,244) | 36,385) | 30,615) | 31,292) | 33,677) | 27,172) | 24,990) | 25,085) | |||||||
Short-term Activity Ratio | ||||||||||||||||||||||||||||||
Receivables turnover1 | 113.76 | 119.90 | 114.20 | 85.42 | 93.34 | 105.92 | 89.09 | 76.34 | 84.50 | 68.05 | 74.89 | 53.19 | 59.90 | 66.21 | 60.44 | 49.31 | 14.84 | 16.20 | 14.87 | 13.10 | — | — | — | |||||||
Benchmarks | ||||||||||||||||||||||||||||||
Receivables Turnover, Competitors2 | ||||||||||||||||||||||||||||||
Home Depot Inc. | 41.81 | 43.47 | 39.00 | 44.15 | 47.12 | 46.57 | 42.95 | 52.34 | 49.72 | 48.38 | 47.32 | 55.89 | — | — | — | — | — | — | — | — | — | — | — | |||||||
TJX Cos. Inc. | 74.20 | 70.21 | 60.88 | 69.69 | 72.02 | 75.94 | 213.66 | 108.00 | 91.76 | 106.12 | 100.60 | 112.54 | — | — | — | — | — | — | — | — | — | — | — |
Based on: 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).
1 Q3 2022 Calculation
Receivables turnover
= (RevenueQ3 2022
+ RevenueQ2 2022
+ RevenueQ1 2022
+ RevenueQ4 2021)
÷ Accounts receivable, net of expected credit losses
= (594,469 + 585,135 + 579,266 + 717,139)
÷ 21,765 = 113.76
2 Click competitor name to see calculations.
Short-term activity ratio | Description | The company |
---|---|---|
Receivables turnover | An activity ratio equal to revenue divided by receivables. | Etsy Inc. receivables turnover ratio improved from Q1 2022 to Q2 2022 but then deteriorated significantly from Q2 2022 to Q3 2022. |
Payables Turnover
Sep 30, 2022 | Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | Dec 31, 2017 | Sep 30, 2017 | Jun 30, 2017 | Mar 31, 2017 | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Selected Financial Data (US$ in thousands) | ||||||||||||||||||||||||||||||
Cost of revenue | 174,401) | 171,421) | 172,995) | 208,966) | 153,660) | 148,969) | 142,917) | 150,780) | 120,168) | 111,381) | 82,416) | 90,824) | 68,949) | 58,605) | 52,658) | 57,111) | 46,947) | 45,409) | 41,295) | 44,220) | 36,383) | 35,724) | 34,659) | |||||||
Accounts payable | 16,841) | 17,929) | 15,734) | 28,007) | 13,367) | 26,752) | 16,386) | 40,883) | 22,130) | 15,978) | 10,557) | 26,324) | 23,416) | 20,504) | 17,325) | 26,545) | 14,130) | 14,760) | 8,094) | 13,622) | 7,241) | 7,595) | 6,371) | |||||||
Short-term Activity Ratio | ||||||||||||||||||||||||||||||
Payables turnover1 | 43.21 | 39.44 | 43.51 | 23.37 | 44.61 | 21.04 | 32.05 | 11.37 | 18.29 | 22.13 | 28.49 | 10.30 | 10.14 | 10.50 | 11.67 | 7.19 | 12.59 | 11.34 | 19.47 | 11.08 | — | — | — | |||||||
Benchmarks | ||||||||||||||||||||||||||||||
Payables Turnover, Competitors2 | ||||||||||||||||||||||||||||||
Amazon.com Inc. | 4.22 | 3.91 | 4.03 | 3.46 | 3.76 | 3.98 | 3.93 | 3.22 | 3.57 | 3.77 | 4.39 | 3.51 | — | — | — | — | — | — | — | — | — | — | — | |||||||
Home Depot Inc. | 7.32 | 7.47 | 6.44 | 7.52 | 6.42 | 6.73 | 7.35 | 9.33 | 7.91 | 7.62 | 6.99 | 9.16 | — | — | — | — | — | — | — | — | — | — | — | |||||||
Lowe’s Cos. Inc. | 5.62 | 5.28 | 4.52 | 5.51 | 4.48 | 4.18 | 4.63 | 6.42 | 5.54 | 5.18 | 4.26 | 5.85 | — | — | — | — | — | — | — | — | — | — | — | |||||||
TJX Cos. Inc. | 5.97 | 6.96 | 6.17 | 5.09 | 4.13 | 10.64 | 25.79 | 11.17 | 8.45 | 11.00 | 10.97 | 10.53 | — | — | — | — | — | — | — | — | — | — | — |
Based on: 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).
1 Q3 2022 Calculation
Payables turnover
= (Cost of revenueQ3 2022
+ Cost of revenueQ2 2022
+ Cost of revenueQ1 2022
+ Cost of revenueQ4 2021)
÷ Accounts payable
= (174,401 + 171,421 + 172,995 + 208,966)
÷ 16,841 = 43.21
2 Click competitor name to see calculations.
Short-term activity ratio | Description | The company |
---|---|---|
Payables turnover | An activity ratio calculated as cost of goods sold divided by payables. | Etsy Inc. payables turnover ratio decreased from Q1 2022 to Q2 2022 but then increased from Q2 2022 to Q3 2022 not reaching Q1 2022 level. |
Working Capital Turnover
Sep 30, 2022 | Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | Dec 31, 2017 | Sep 30, 2017 | Jun 30, 2017 | Mar 31, 2017 | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Selected Financial Data (US$ in thousands) | ||||||||||||||||||||||||||||||
Current assets | 1,352,113) | 1,320,222) | 1,295,137) | 1,341,501) | 1,077,334) | 2,690,980) | 1,893,619) | 1,894,781) | 1,697,831) | 1,194,335) | 906,952) | 921,038) | 945,840) | 743,653) | 724,001) | 680,289) | 707,949) | 666,233) | 704,997) | 439,264) | 400,383) | 376,228) | 355,240) | |||||||
Less: Current liabilities | 497,246) | 449,902) | 483,205) | 615,588) | 471,007) | 407,000) | 427,045) | 454,664) | 340,942) | 279,579) | 158,849) | 188,528) | 154,707) | 166,510) | 148,675) | 112,062) | 128,931) | 113,499) | 106,556) | 102,477) | 94,089) | 88,324) | 81,153) | |||||||
Working capital | 854,867) | 870,320) | 811,932) | 725,913) | 606,327) | 2,283,980) | 1,466,574) | 1,440,117) | 1,356,889) | 914,756) | 748,103) | 732,510) | 791,133) | 577,143) | 575,326) | 568,227) | 579,018) | 552,734) | 598,441) | 336,787) | 306,294) | 287,904) | 274,087) | |||||||
Revenue | 594,469) | 585,135) | 579,266) | 717,139) | 532,429) | 528,900) | 550,646) | 617,355) | 451,478) | 428,737) | 228,055) | 269,998) | 197,947) | 181,095) | 169,339) | 200,028) | 150,366) | 132,387) | 120,912) | 136,268) | 106,380) | 101,692) | 96,891) | |||||||
Short-term Activity Ratio | ||||||||||||||||||||||||||||||
Working capital turnover1 | 2.90 | 2.77 | 2.90 | 3.21 | 3.68 | 0.94 | 1.40 | 1.20 | 1.02 | 1.23 | 1.17 | 1.12 | 0.95 | 1.21 | 1.13 | 1.06 | 0.93 | 0.90 | 0.78 | 1.31 | — | — | — | |||||||
Benchmarks | ||||||||||||||||||||||||||||||
Working Capital Turnover, Competitors2 | ||||||||||||||||||||||||||||||
Amazon.com Inc. | — | — | — | 24.33 | 31.50 | 19.23 | 69.81 | 60.82 | 31.47 | 18.92 | 47.22 | 32.92 | — | — | — | — | — | — | — | — | — | — | — | |||||||
Home Depot Inc. | 41.45 | 90.49 | 48.51 | 24.87 | 13.79 | 16.66 | 28.53 | 76.81 | 68.95 | 57.87 | 124.59 | 59.68 | — | — | — | — | — | — | — | — | — | — | — | |||||||
Lowe’s Cos. Inc. | 23.72 | 27.67 | 24.04 | 24.92 | 11.60 | 12.67 | 20.57 | 530.50 | 119.81 | 74.71 | 46.13 | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
TJX Cos. Inc. | 14.05 | 12.91 | 7.40 | 6.51 | 6.91 | 8.72 | 6.55 | 23.97 | 24.08 | 23.99 | 26.62 | 13.27 | — | — | — | — | — | — | — | — | — | — | — |
Based on: 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).
1 Q3 2022 Calculation
Working capital turnover
= (RevenueQ3 2022
+ RevenueQ2 2022
+ RevenueQ1 2022
+ RevenueQ4 2021)
÷ Working capital
= (594,469 + 585,135 + 579,266 + 717,139)
÷ 854,867 = 2.90
2 Click competitor name to see calculations.
Short-term activity ratio | Description | The company |
---|---|---|
Working capital turnover | An activity ratio calculated as revenue divided by working capital. | Etsy Inc. working capital turnover ratio deteriorated from Q1 2022 to Q2 2022 but then improved from Q2 2022 to Q3 2022 not reaching Q1 2022 level. |
Average Receivable Collection Period
Sep 30, 2022 | Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | Dec 31, 2017 | Sep 30, 2017 | Jun 30, 2017 | Mar 31, 2017 | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Selected Financial Data | ||||||||||||||||||||||||||||||
Receivables turnover | 113.76 | 119.90 | 114.20 | 85.42 | 93.34 | 105.92 | 89.09 | 76.34 | 84.50 | 68.05 | 74.89 | 53.19 | 59.90 | 66.21 | 60.44 | 49.31 | 14.84 | 16.20 | 14.87 | 13.10 | — | — | — | |||||||
Short-term Activity Ratio (no. days) | ||||||||||||||||||||||||||||||
Average receivable collection period1 | 3 | 3 | 3 | 4 | 4 | 3 | 4 | 5 | 4 | 5 | 5 | 7 | 6 | 6 | 6 | 7 | 25 | 23 | 25 | 28 | — | — | — | |||||||
Benchmarks (no. days) | ||||||||||||||||||||||||||||||
Average Receivable Collection Period, Competitors2 | ||||||||||||||||||||||||||||||
Home Depot Inc. | 9 | 8 | 9 | 8 | 8 | 8 | 8 | 7 | 7 | 8 | 8 | 7 | — | — | — | — | — | — | — | — | — | — | — | |||||||
TJX Cos. Inc. | 5 | 5 | 6 | 5 | 5 | 5 | 2 | 3 | 4 | 3 | 4 | 3 | — | — | — | — | — | — | — | — | — | — | — |
Based on: 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).
1 Q3 2022 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 113.76 = 3
2 Click competitor name to see calculations.
Short-term activity ratio | Description | The company |
---|---|---|
Average receivable collection period | An activity ratio equal to the number of days in the period divided by receivables turnover. |
Average Payables Payment Period
Sep 30, 2022 | Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | Dec 31, 2017 | Sep 30, 2017 | Jun 30, 2017 | Mar 31, 2017 | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Selected Financial Data | ||||||||||||||||||||||||||||||
Payables turnover | 43.21 | 39.44 | 43.51 | 23.37 | 44.61 | 21.04 | 32.05 | 11.37 | 18.29 | 22.13 | 28.49 | 10.30 | 10.14 | 10.50 | 11.67 | 7.19 | 12.59 | 11.34 | 19.47 | 11.08 | — | — | — | |||||||
Short-term Activity Ratio (no. days) | ||||||||||||||||||||||||||||||
Average payables payment period1 | 8 | 9 | 8 | 16 | 8 | 17 | 11 | 32 | 20 | 16 | 13 | 35 | 36 | 35 | 31 | 51 | 29 | 32 | 19 | 33 | — | — | — | |||||||
Benchmarks (no. days) | ||||||||||||||||||||||||||||||
Average Payables Payment Period, Competitors2 | ||||||||||||||||||||||||||||||
Amazon.com Inc. | 86 | 93 | 91 | 105 | 97 | 92 | 93 | 113 | 102 | 97 | 83 | 104 | — | — | — | — | — | — | — | — | — | — | — | |||||||
Home Depot Inc. | 50 | 49 | 57 | 49 | 57 | 54 | 50 | 39 | 46 | 48 | 52 | 40 | — | — | — | — | — | — | — | — | — | — | — | |||||||
Lowe’s Cos. Inc. | 65 | 69 | 81 | 66 | 81 | 87 | 79 | 57 | 66 | 70 | 86 | 62 | — | — | — | — | — | — | — | — | — | — | — | |||||||
TJX Cos. Inc. | 61 | 52 | 59 | 72 | 88 | 34 | 14 | 33 | 43 | 33 | 33 | 35 | — | — | — | — | — | — | — | — | — | — | — |
Based on: 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).
1 Q3 2022 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 43.21 = 8
2 Click competitor name to see calculations.
Short-term activity ratio | Description | The company |
---|---|---|
Average payables payment period | An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. |