Analysis of Long-term (Investment) Activity Ratios
Quarterly Data
Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.
Long-term Activity Ratios (Summary)
Etsy Inc., long-term (investment) activity ratios (quarterly data)
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).
| Long-term activity ratio | Description | The company |
|---|---|---|
| Net fixed asset turnover | An activity ratio calculated as total revenue divided by net fixed assets. | Etsy Inc. net fixed asset turnover ratio improved from Q1 2022 to Q2 2022 and from Q2 2022 to Q3 2022. |
| Total asset turnover | An activity ratio calculated as total revenue divided by total assets. | Etsy Inc. total asset turnover ratio improved from Q1 2022 to Q2 2022 and from Q2 2022 to Q3 2022. |
Net Fixed Asset Turnover
Etsy Inc., net fixed asset turnover calculation (quarterly data)
| 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) | |||||||
| Property and equipment, net of accumulated depreciation and amortization | 249,905) | 261,697) | 271,333) | 275,062) | 198,902) | 105,814) | 107,960) | 112,495) | 118,141) | 126,187) | 134,519) | 144,864) | 153,262) | 128,409) | 131,650) | 120,179) | 119,243) | 117,024) | 116,385) | 117,617) | 124,543) | 129,074) | 127,168) | |||||||
| Long-term Activity Ratio | ||||||||||||||||||||||||||||||
| Net fixed asset turnover1 | 9.91 | 9.22 | 8.69 | 8.47 | 11.21 | 20.30 | 18.97 | 15.34 | 11.67 | 8.91 | 6.52 | 5.65 | 4.88 | 5.46 | 4.95 | 5.02 | 4.53 | 4.24 | 4.00 | 3.75 | — | — | — | |||||||
| Benchmarks | ||||||||||||||||||||||||||||||
| Net Fixed Asset Turnover, Competitors2 | ||||||||||||||||||||||||||||||
| Amazon.com Inc. | 2.83 | 2.80 | 2.84 | 2.93 | 3.11 | 3.32 | 3.45 | 3.41 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Home Depot Inc. | 5.92 | 5.83 | 5.73 | 5.35 | 5.27 | 5.10 | 4.94 | 4.84 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Lowe’s Cos. Inc. | 5.03 | 4.97 | 4.95 | 4.68 | 4.57 | 4.32 | 4.00 | 3.86 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| TJX Cos. Inc. | 8.84 | 8.46 | 7.46 | 6.38 | 6.67 | 6.61 | 7.08 | 7.83 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
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
Net fixed asset turnover
= (RevenueQ3 2022
+ RevenueQ2 2022
+ RevenueQ1 2022
+ RevenueQ4 2021)
÷ Property and equipment, net of accumulated depreciation and amortization
= (594,469 + 585,135 + 579,266 + 717,139)
÷ 249,905 = 9.91
2 Click competitor name to see calculations.
| Long-term activity ratio | Description | The company |
|---|---|---|
| Net fixed asset turnover | An activity ratio calculated as total revenue divided by net fixed assets. | Etsy Inc. net fixed asset turnover ratio improved from Q1 2022 to Q2 2022 and from Q2 2022 to Q3 2022. |
Total Asset Turnover
Etsy Inc., total asset turnover calculation (quarterly data)
| 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) | |||||||
| Total assets | 2,450,311) | 3,607,100) | 3,745,175) | 3,831,809) | 3,502,138) | 3,290,416) | 2,497,411) | 2,404,489) | 2,214,505) | 1,762,031) | 1,517,642) | 1,542,352) | 1,499,198) | 1,021,775) | 981,168) | 901,851) | 907,368) | 865,310) | 870,165) | 605,583) | 574,062) | 554,317) | 530,739) | |||||||
| Long-term Activity Ratio | ||||||||||||||||||||||||||||||
| Total asset turnover1 | 1.01 | 0.67 | 0.63 | 0.61 | 0.64 | 0.65 | 0.82 | 0.72 | 0.62 | 0.64 | 0.58 | 0.53 | 0.50 | 0.69 | 0.66 | 0.67 | 0.60 | 0.57 | 0.53 | 0.73 | — | — | — | |||||||
| Benchmarks | ||||||||||||||||||||||||||||||
| Total Asset Turnover, Competitors2 | ||||||||||||||||||||||||||||||
| Amazon.com Inc. | 1.17 | 1.16 | 1.16 | 1.12 | 1.20 | 1.23 | 1.30 | 1.20 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Home Depot Inc. | 2.02 | 2.04 | 1.95 | 1.87 | 1.88 | 1.88 | 1.91 | 2.15 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Lowe’s Cos. Inc. | 1.93 | 1.92 | 1.84 | 1.92 | 1.68 | 1.55 | 1.62 | 1.83 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| TJX Cos. Inc. | 1.52 | 1.50 | 1.25 | 1.04 | 1.06 | 1.27 | 1.45 | 1.73 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
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
Total asset turnover
= (RevenueQ3 2022
+ RevenueQ2 2022
+ RevenueQ1 2022
+ RevenueQ4 2021)
÷ Total assets
= (594,469 + 585,135 + 579,266 + 717,139)
÷ 2,450,311 = 1.01
2 Click competitor name to see calculations.
| Long-term activity ratio | Description | The company |
|---|---|---|
| Total asset turnover | An activity ratio calculated as total revenue divided by total assets. | Etsy Inc. total asset turnover ratio improved from Q1 2022 to Q2 2022 and from Q2 2022 to Q3 2022. |
Equity Turnover
Etsy Inc., equity turnover calculation (quarterly data)
| 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) | |||||||
| Stockholders’ equity (deficit) | (606,242) | 581,295) | 676,867) | 628,619) | 533,622) | 530,753) | 683,774) | 742,424) | 666,667) | 524,175) | 406,847) | 406,634) | 389,262) | 442,301) | 420,013) | 400,898) | 394,619) | 370,091) | 384,487) | 396,894) | 348,215) | 308,279) | 295,048) | |||||||
| Long-term Activity Ratio | ||||||||||||||||||||||||||||||
| Equity turnover1 | — | 4.15 | 3.48 | 3.71 | 4.18 | 4.05 | 3.00 | 2.32 | 2.07 | 2.15 | 2.16 | 2.01 | 1.92 | 1.58 | 1.55 | 1.51 | 1.37 | 1.34 | 1.21 | 1.11 | — | — | — | |||||||
| Benchmarks | ||||||||||||||||||||||||||||||
| Equity Turnover, Competitors2 | ||||||||||||||||||||||||||||||
| Amazon.com Inc. | 3.65 | 3.70 | 3.57 | 3.40 | 3.80 | 3.86 | 4.06 | 4.13 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Home Depot Inc. | 142.70 | 69.80 | 80.86 | 40.05 | 81.84 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Lowe’s Cos. Inc. | — | — | 212.01 | 62.35 | 20.95 | 18.46 | 43.17 | 36.59 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| TJX Cos. Inc. | 7.08 | 6.75 | 6.16 | 5.51 | 6.00 | 7.24 | 7.78 | 7.01 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
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
Equity turnover
= (RevenueQ3 2022
+ RevenueQ2 2022
+ RevenueQ1 2022
+ RevenueQ4 2021)
÷ Stockholders’ equity (deficit)
= (594,469 + 585,135 + 579,266 + 717,139)
÷ -606,242 = —
2 Click competitor name to see calculations.