Analysis of Short-term (Operating) 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.
Short-term Activity Ratios (Summary)
Axon Enterprise Inc., short-term (operating) activity ratios (quarterly data)
Based on: 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 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).
| Short-term activity ratio | Description | The company |
|---|---|---|
| Inventory turnover | An activity ratio calculated as cost of goods sold divided by inventory. | Axon Enterprise Inc. inventory turnover ratio deteriorated from Q3 2022 to Q4 2022 and from Q4 2022 to Q1 2023. |
| Receivables turnover | An activity ratio equal to revenue divided by receivables. | Axon Enterprise Inc. receivables turnover ratio improved from Q3 2022 to Q4 2022 and from Q4 2022 to Q1 2023. |
| Payables turnover | An activity ratio calculated as cost of goods sold divided by payables. | Axon Enterprise Inc. payables turnover ratio decreased from Q3 2022 to Q4 2022 and from Q4 2022 to Q1 2023. |
| Working capital turnover | An activity ratio calculated as revenue divided by working capital. | Axon Enterprise Inc. working capital turnover ratio deteriorated from Q3 2022 to Q4 2022 and from Q4 2022 to Q1 2023. |
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average inventory processing period | An activity ratio equal to the number of days in the period divided by inventory turnover over the period. | Axon Enterprise Inc. number of days of inventory outstanding deteriorated from Q3 2022 to Q4 2022 and from Q4 2022 to Q1 2023. |
| Average receivable collection period | An activity ratio equal to the number of days in the period divided by receivables turnover. | Axon Enterprise Inc. number of days of receivables outstanding improved from Q3 2022 to Q4 2022 and from Q4 2022 to Q1 2023. |
| Operating cycle | Equal to average inventory processing period plus average receivables collection period. | |
| 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. | Axon Enterprise Inc. number of days of payables outstanding increased from Q3 2022 to Q4 2022 and from Q4 2022 to Q1 2023. |
| Cash conversion cycle | A financial metric that measures the length of time required for a company to convert cash invested in its operations to cash received as a result of its operations; equal to average inventory processing period plus average receivables collection period minus average payables payment period. | Axon Enterprise Inc. cash conversion cycle improved from Q3 2022 to Q4 2022 and from Q4 2022 to Q1 2023. |
Inventory Turnover
Axon Enterprise Inc., inventory turnover calculation (quarterly data)
| Mar 31, 2023 | Dec 31, 2022 | 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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | ||||||||||||||||||||||||||||
| Cost of sales | 138,941) | 130,463) | 118,497) | 111,650) | 100,687) | 82,517) | 87,422) | 80,866) | 71,666) | 84,834) | 68,202) | 53,082) | 58,554) | 79,211) | 50,668) | 46,802) | 46,893) | 49,445) | 39,203) | 36,083) | 36,754) | |||||||
| Inventory | 220,268) | 202,471) | 173,046) | 154,297) | 122,150) | 108,688) | 93,279) | 91,739) | 89,657) | 89,958) | 97,610) | 81,010) | 46,922) | 38,845) | 40,666) | 40,999) | 37,587) | 33,763) | 39,221) | 43,967) | 43,104) | |||||||
| Short-term Activity Ratio | ||||||||||||||||||||||||||||
| Inventory turnover1 | 2.27 | 2.28 | 2.39 | 2.48 | 2.88 | 2.97 | 3.48 | 3.33 | 3.10 | 2.94 | 2.65 | 2.98 | 5.01 | 5.76 | 4.77 | 4.45 | 4.57 | 4.78 | — | — | — | |||||||
| Benchmarks | ||||||||||||||||||||||||||||
| Inventory Turnover, Competitors2 | ||||||||||||||||||||||||||||
| Boeing Co. | 0.83 | 0.81 | 0.78 | 0.74 | 0.74 | 0.75 | 0.77 | 0.76 | 0.74 | 0.78 | 0.71 | 0.78 | 0.88 | 0.94 | — | — | — | — | — | — | — | |||||||
| Caterpillar Inc. | 2.38 | 2.54 | 2.36 | 2.40 | 2.46 | 2.53 | 2.44 | 2.49 | 2.46 | 2.55 | 2.66 | 2.82 | 2.97 | 3.25 | — | — | — | — | — | — | — | |||||||
| Eaton Corp. plc | 3.94 | 4.04 | 3.95 | 3.87 | 4.03 | 4.48 | 4.73 | 4.86 | 5.12 | 5.88 | 6.10 | 6.20 | 6.00 | 5.11 | — | — | — | — | — | — | — | |||||||
| GE Aerospace | 3.32 | 3.19 | 3.10 | 3.04 | 3.25 | 3.40 | 3.21 | 3.28 | 3.46 | 3.80 | 4.36 | 4.41 | 4.50 | 4.97 | — | — | — | — | — | — | — | |||||||
| Honeywell International Inc. | 3.90 | 4.04 | 4.09 | 4.06 | 4.20 | 4.55 | 4.72 | 4.88 | 4.85 | 4.94 | 4.79 | 4.88 | 5.23 | 5.51 | — | — | — | — | — | — | — | |||||||
| Lockheed Martin Corp. | 16.63 | 18.68 | 18.09 | 16.20 | 18.12 | 19.45 | 19.81 | 18.64 | 17.58 | 16.01 | — | — | — | — | — | — | — | — | — | — | — | |||||||
| RTX Corp. | 4.81 | 5.03 | 5.03 | 5.14 | 5.33 | 5.65 | 5.57 | 5.49 | 5.48 | 5.11 | 4.93 | 4.85 | 4.51 | 5.21 | — | — | — | — | — | — | — | |||||||
Based on: 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 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).
1 Q1 2023 Calculation
Inventory turnover
= (Cost of salesQ1 2023
+ Cost of salesQ4 2022
+ Cost of salesQ3 2022
+ Cost of salesQ2 2022)
÷ Inventory
= (138,941 + 130,463 + 118,497 + 111,650)
÷ 220,268 = 2.27
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Inventory turnover | An activity ratio calculated as cost of goods sold divided by inventory. | Axon Enterprise Inc. inventory turnover ratio deteriorated from Q3 2022 to Q4 2022 and from Q4 2022 to Q1 2023. |
Receivables Turnover
Axon Enterprise Inc., receivables turnover calculation (quarterly data)
| Mar 31, 2023 | Dec 31, 2022 | 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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | ||||||||||||||||||||||||||||
| Net sales | 343,043) | 336,142) | 311,754) | 285,613) | 256,426) | 217,578) | 231,989) | 218,795) | 195,019) | 226,140) | 166,442) | 141,259) | 147,162) | 171,851) | 130,837) | 112,362) | 115,810) | 114,791) | 104,836) | 99,226) | 101,215) | |||||||
| Accounts and notes receivable, net of allowance | 379,887) | 358,190) | 418,308) | 379,672) | 344,907) | 320,819) | 265,267) | 201,907) | 185,373) | 229,201) | 172,803) | 154,253) | 147,945) | 146,878) | 149,013) | 134,630) | 149,096) | 130,579) | 116,518) | 94,296) | 87,849) | |||||||
| Short-term Activity Ratio | ||||||||||||||||||||||||||||
| Receivables turnover1 | 3.36 | 3.32 | 2.56 | 2.61 | 2.68 | 2.69 | 3.29 | 3.99 | 3.93 | 2.97 | 3.63 | 3.83 | 3.80 | 3.61 | 3.18 | 3.33 | 2.92 | 3.22 | — | — | — | |||||||
| Benchmarks | ||||||||||||||||||||||||||||
| Receivables Turnover, Competitors2 | ||||||||||||||||||||||||||||
| Boeing Co. | 24.65 | 26.46 | 22.98 | 20.27 | 25.37 | 23.58 | 27.95 | 24.76 | 23.97 | 29.75 | 22.00 | 23.85 | 21.97 | 23.44 | — | — | — | — | — | — | — | |||||||
| Caterpillar Inc. | 6.37 | 6.39 | 6.59 | 6.10 | 5.46 | 5.68 | 5.97 | 5.51 | 5.07 | 5.33 | 5.86 | 6.11 | 6.12 | 5.92 | — | — | — | — | — | — | — | |||||||
| Eaton Corp. plc | 5.05 | 5.09 | 5.28 | 5.15 | 5.39 | 5.95 | 5.75 | 5.72 | 5.79 | 6.15 | 6.40 | 7.25 | 7.07 | 6.22 | — | — | — | — | — | — | — | |||||||
| GE Aerospace | 5.00 | 4.09 | 4.19 | 4.39 | 4.43 | 4.55 | 4.83 | 4.74 | 4.59 | 4.37 | 4.46 | 5.03 | 5.08 | 5.22 | — | — | — | — | — | — | — | |||||||
| Honeywell International Inc. | 4.57 | 4.77 | 4.74 | 4.45 | 4.82 | 5.04 | 4.78 | 4.89 | 4.89 | 4.78 | 4.83 | 5.14 | 4.87 | 4.90 | — | — | — | — | — | — | — | |||||||
| Lockheed Martin Corp. | 25.61 | 26.34 | 26.06 | 18.87 | 26.02 | 34.15 | 29.27 | 25.59 | 29.81 | 33.06 | — | — | — | — | — | — | — | — | — | — | — | |||||||
| RTX Corp. | 6.81 | 7.36 | 7.15 | 6.28 | 7.15 | 6.66 | 6.69 | 6.99 | 6.03 | 6.11 | 5.90 | 6.79 | 5.35 | 5.70 | — | — | — | — | — | — | — | |||||||
Based on: 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 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).
1 Q1 2023 Calculation
Receivables turnover
= (Net salesQ1 2023
+ Net salesQ4 2022
+ Net salesQ3 2022
+ Net salesQ2 2022)
÷ Accounts and notes receivable, net of allowance
= (343,043 + 336,142 + 311,754 + 285,613)
÷ 379,887 = 3.36
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. | Axon Enterprise Inc. receivables turnover ratio improved from Q3 2022 to Q4 2022 and from Q4 2022 to Q1 2023. |
Payables Turnover
Axon Enterprise Inc., payables turnover calculation (quarterly data)
| Mar 31, 2023 | Dec 31, 2022 | 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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | ||||||||||||||||||||||||||||
| Cost of sales | 138,941) | 130,463) | 118,497) | 111,650) | 100,687) | 82,517) | 87,422) | 80,866) | 71,666) | 84,834) | 68,202) | 53,082) | 58,554) | 79,211) | 50,668) | 46,802) | 46,893) | 49,445) | 39,203) | 36,083) | 36,754) | |||||||
| Accounts payable | 65,988) | 59,918) | 50,193) | 60,689) | 49,348) | 32,220) | 27,418) | 7,778) | 19,791) | 24,142) | 22,441) | 40,105) | 31,568) | 25,874) | 14,638) | 9,064) | 9,865) | 15,164) | 8,998) | 9,213) | 11,692) | |||||||
| Short-term Activity Ratio | ||||||||||||||||||||||||||||
| Payables turnover1 | 7.57 | 7.70 | 8.24 | 6.30 | 7.12 | 10.01 | 11.85 | 39.29 | 14.04 | 10.96 | 11.54 | 6.02 | 7.45 | 8.64 | 13.24 | 20.12 | 17.40 | 10.65 | — | — | — | |||||||
| Benchmarks | ||||||||||||||||||||||||||||
| Payables Turnover, Competitors2 | ||||||||||||||||||||||||||||
| Boeing Co. | 6.37 | 6.18 | 6.36 | 6.17 | 6.73 | 6.40 | 6.20 | 5.45 | 4.90 | 4.94 | 4.25 | 4.77 | 4.69 | 4.63 | — | — | — | — | — | — | — | |||||||
| Caterpillar Inc. | 4.68 | 4.76 | 4.81 | 4.72 | 4.43 | 4.36 | 4.61 | 4.57 | 4.46 | 4.75 | 5.86 | 6.31 | 6.05 | 6.15 | — | — | — | — | — | — | — | |||||||
| Eaton Corp. plc | 4.55 | 4.51 | 4.61 | 4.43 | 4.67 | 4.75 | 5.11 | 5.22 | 5.66 | 6.24 | 7.15 | 8.18 | 7.88 | 6.78 | — | — | — | — | — | — | — | |||||||
| GE Aerospace | 3.57 | 2.98 | 3.14 | 3.14 | 3.32 | 3.32 | 3.33 | 3.35 | 3.56 | 3.67 | 4.67 | 4.99 | 4.57 | 4.40 | — | — | — | — | — | — | — | |||||||
| Honeywell International Inc. | 3.50 | 3.53 | 3.68 | 3.63 | 3.66 | 3.61 | 3.83 | 3.76 | 3.86 | 3.86 | 4.27 | 4.32 | 4.23 | 4.25 | — | — | — | — | — | — | — | |||||||
| Lockheed Martin Corp. | 17.65 | 27.25 | 21.48 | 24.07 | 21.92 | 74.34 | 37.83 | 36.15 | 30.31 | 64.48 | — | — | — | — | — | — | — | — | — | — | — | |||||||
| RTX Corp. | 5.42 | 5.40 | 5.82 | 5.36 | 6.28 | 5.93 | 6.06 | 6.52 | 5.67 | 5.56 | 5.96 | 6.92 | 4.73 | 5.28 | — | — | — | — | — | — | — | |||||||
Based on: 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 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).
1 Q1 2023 Calculation
Payables turnover
= (Cost of salesQ1 2023
+ Cost of salesQ4 2022
+ Cost of salesQ3 2022
+ Cost of salesQ2 2022)
÷ Accounts payable
= (138,941 + 130,463 + 118,497 + 111,650)
÷ 65,988 = 7.57
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. | Axon Enterprise Inc. payables turnover ratio decreased from Q3 2022 to Q4 2022 and from Q4 2022 to Q1 2023. |
Working Capital Turnover
Axon Enterprise Inc., working capital turnover calculation (quarterly data)
| Mar 31, 2023 | Dec 31, 2022 | 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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | ||||||||||||||||||||||||||||
| Current assets | 2,052,696) | 1,805,278) | 1,205,699) | 1,169,791) | 1,146,117) | 1,109,490) | 1,123,820) | 1,080,930) | 986,229) | 981,952) | 875,853) | 885,724) | 618,741) | 619,091) | 576,022) | 575,055) | 566,922) | 558,155) | 524,387) | 486,966) | 258,970) | |||||||
| Less: Current liabilities | 616,127) | 602,646) | 431,523) | 432,971) | 470,679) | 418,521) | 379,890) | 272,871) | 239,775) | 256,331) | 258,555) | 242,830) | 195,015) | 195,566) | 183,834) | 163,673) | 163,794) | 166,011) | 141,505) | 120,898) | 128,710) | |||||||
| Working capital | 1,436,569) | 1,202,632) | 774,176) | 736,820) | 675,438) | 690,969) | 743,930) | 808,059) | 746,454) | 725,621) | 617,298) | 642,894) | 423,726) | 423,525) | 392,188) | 411,382) | 403,128) | 392,144) | 382,882) | 366,068) | 130,260) | |||||||
| Net sales | 343,043) | 336,142) | 311,754) | 285,613) | 256,426) | 217,578) | 231,989) | 218,795) | 195,019) | 226,140) | 166,442) | 141,259) | 147,162) | 171,851) | 130,837) | 112,362) | 115,810) | 114,791) | 104,836) | 99,226) | 101,215) | |||||||
| Short-term Activity Ratio | ||||||||||||||||||||||||||||
| Working capital turnover1 | 0.89 | 0.99 | 1.38 | 1.35 | 1.37 | 1.25 | 1.17 | 1.00 | 0.98 | 0.94 | 1.02 | 0.92 | 1.33 | 1.25 | 1.21 | 1.09 | 1.08 | 1.07 | — | — | — | |||||||
| Benchmarks | ||||||||||||||||||||||||||||
| Working Capital Turnover, Competitors2 | ||||||||||||||||||||||||||||
| Boeing Co. | 4.61 | 3.42 | 3.13 | 2.87 | 2.51 | 2.34 | 2.02 | 2.00 | 1.88 | 1.69 | 1.57 | 1.76 | 4.27 | 15.57 | — | — | — | — | — | — | — | |||||||
| Caterpillar Inc. | 4.25 | 4.62 | 4.35 | 3.93 | 3.83 | 3.54 | 2.87 | 2.80 | 2.52 | 2.84 | 3.01 | 3.45 | 4.33 | 4.04 | — | — | — | — | — | — | — | |||||||
| Eaton Corp. plc | 7.01 | 8.70 | 10.69 | — | — | 65.65 | 12.41 | 21.65 | 5.34 | 5.42 | 6.42 | 7.05 | 5.60 | 5.95 | — | — | — | — | — | — | — | |||||||
| GE Aerospace | 5.87 | 7.93 | 13.29 | 10.55 | 7.14 | 4.94 | 1.57 | 1.57 | 1.27 | 2.26 | 5.06 | 6.05 | 8.72 | — | — | — | — | — | — | — | — | |||||||
| Honeywell International Inc. | 7.79 | 7.03 | 7.91 | 8.84 | 8.07 | 5.86 | 5.94 | 4.52 | 4.27 | 3.64 | 3.02 | 3.14 | 6.93 | 5.92 | — | — | — | — | — | — | — | |||||||
| Lockheed Martin Corp. | 12.81 | 12.93 | 14.03 | 14.28 | 15.14 | 11.52 | 10.48 | 12.30 | 11.93 | 12.01 | — | — | — | — | — | — | — | — | — | — | — | |||||||
| RTX Corp. | 12.76 | 20.15 | 19.15 | 17.77 | 11.41 | 9.75 | 8.11 | 10.24 | 9.77 | 7.52 | 7.51 | 9.23 | 9.50 | 26.47 | — | — | — | — | — | — | — | |||||||
Based on: 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 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).
1 Q1 2023 Calculation
Working capital turnover
= (Net salesQ1 2023
+ Net salesQ4 2022
+ Net salesQ3 2022
+ Net salesQ2 2022)
÷ Working capital
= (343,043 + 336,142 + 311,754 + 285,613)
÷ 1,436,569 = 0.89
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. | Axon Enterprise Inc. working capital turnover ratio deteriorated from Q3 2022 to Q4 2022 and from Q4 2022 to Q1 2023. |
Average Inventory Processing Period
Axon Enterprise Inc., average inventory processing period calculation (quarterly data)
| Mar 31, 2023 | Dec 31, 2022 | 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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | ||||||||||||||||||||||||||||
| Inventory turnover | 2.27 | 2.28 | 2.39 | 2.48 | 2.88 | 2.97 | 3.48 | 3.33 | 3.10 | 2.94 | 2.65 | 2.98 | 5.01 | 5.76 | 4.77 | 4.45 | 4.57 | 4.78 | — | — | — | |||||||
| Short-term Activity Ratio (no. days) | ||||||||||||||||||||||||||||
| Average inventory processing period1 | 161 | 160 | 153 | 147 | 127 | 123 | 105 | 110 | 118 | 124 | 138 | 122 | 73 | 63 | 77 | 82 | 80 | 76 | — | — | — | |||||||
| Benchmarks (no. days) | ||||||||||||||||||||||||||||
| Average Inventory Processing Period, Competitors2 | ||||||||||||||||||||||||||||
| Boeing Co. | 438 | 452 | 468 | 494 | 493 | 486 | 475 | 478 | 496 | 467 | 516 | 468 | 416 | 388 | — | — | — | — | — | — | — | |||||||
| Caterpillar Inc. | 154 | 144 | 155 | 152 | 148 | 144 | 150 | 146 | 149 | 143 | 137 | 129 | 123 | 112 | — | — | — | — | — | — | — | |||||||
| Eaton Corp. plc | 93 | 90 | 92 | 94 | 90 | 82 | 77 | 75 | 71 | 62 | 60 | 59 | 61 | 71 | — | — | — | — | — | — | — | |||||||
| GE Aerospace | 110 | 114 | 118 | 120 | 112 | 107 | 114 | 111 | 105 | 96 | 84 | 83 | 81 | 74 | — | — | — | — | — | — | — | |||||||
| Honeywell International Inc. | 94 | 90 | 89 | 90 | 87 | 80 | 77 | 75 | 75 | 74 | 76 | 75 | 70 | 66 | — | — | — | — | — | — | — | |||||||
| Lockheed Martin Corp. | 22 | 20 | 20 | 23 | 20 | 19 | 18 | 20 | 21 | 23 | — | — | — | — | — | — | — | — | — | — | — | |||||||
| RTX Corp. | 76 | 73 | 73 | 71 | 69 | 65 | 65 | 66 | 67 | 71 | 74 | 75 | 81 | 70 | — | — | — | — | — | — | — | |||||||
Based on: 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 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).
1 Q1 2023 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 2.27 = 161
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average inventory processing period | An activity ratio equal to the number of days in the period divided by inventory turnover over the period. | Axon Enterprise Inc. number of days of inventory outstanding deteriorated from Q3 2022 to Q4 2022 and from Q4 2022 to Q1 2023. |
Average Receivable Collection Period
Axon Enterprise Inc., average receivable collection period calculation (quarterly data)
| Mar 31, 2023 | Dec 31, 2022 | 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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | ||||||||||||||||||||||||||||
| Receivables turnover | 3.36 | 3.32 | 2.56 | 2.61 | 2.68 | 2.69 | 3.29 | 3.99 | 3.93 | 2.97 | 3.63 | 3.83 | 3.80 | 3.61 | 3.18 | 3.33 | 2.92 | 3.22 | — | — | — | |||||||
| Short-term Activity Ratio (no. days) | ||||||||||||||||||||||||||||
| Average receivable collection period1 | 109 | 110 | 143 | 140 | 136 | 136 | 111 | 91 | 93 | 123 | 101 | 95 | 96 | 101 | 115 | 110 | 125 | 113 | — | — | — | |||||||
| Benchmarks (no. days) | ||||||||||||||||||||||||||||
| Average Receivable Collection Period, Competitors2 | ||||||||||||||||||||||||||||
| Boeing Co. | 15 | 14 | 16 | 18 | 14 | 15 | 13 | 15 | 15 | 12 | 17 | 15 | 17 | 16 | — | — | — | — | — | — | — | |||||||
| Caterpillar Inc. | 57 | 57 | 55 | 60 | 67 | 64 | 61 | 66 | 72 | 68 | 62 | 60 | 60 | 62 | — | — | — | — | — | — | — | |||||||
| Eaton Corp. plc | 72 | 72 | 69 | 71 | 68 | 61 | 63 | 64 | 63 | 59 | 57 | 50 | 52 | 59 | — | — | — | — | — | — | — | |||||||
| GE Aerospace | 73 | 89 | 87 | 83 | 82 | 80 | 76 | 77 | 80 | 83 | 82 | 73 | 72 | 70 | — | — | — | — | — | — | — | |||||||
| Honeywell International Inc. | 80 | 77 | 77 | 82 | 76 | 72 | 76 | 75 | 75 | 76 | 76 | 71 | 75 | 75 | — | — | — | — | — | — | — | |||||||
| Lockheed Martin Corp. | 14 | 14 | 14 | 19 | 14 | 11 | 12 | 14 | 12 | 11 | — | — | — | — | — | — | — | — | — | — | — | |||||||
| RTX Corp. | 54 | 50 | 51 | 58 | 51 | 55 | 55 | 52 | 61 | 60 | 62 | 54 | 68 | 64 | — | — | — | — | — | — | — | |||||||
Based on: 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 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).
1 Q1 2023 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 3.36 = 109
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. | Axon Enterprise Inc. number of days of receivables outstanding improved from Q3 2022 to Q4 2022 and from Q4 2022 to Q1 2023. |
Operating Cycle
Axon Enterprise Inc., operating cycle calculation (quarterly data)
No. days
| Mar 31, 2023 | Dec 31, 2022 | 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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | ||||||||||||||||||||||||||||
| Average inventory processing period | 161 | 160 | 153 | 147 | 127 | 123 | 105 | 110 | 118 | 124 | 138 | 122 | 73 | 63 | 77 | 82 | 80 | 76 | — | — | — | |||||||
| Average receivable collection period | 109 | 110 | 143 | 140 | 136 | 136 | 111 | 91 | 93 | 123 | 101 | 95 | 96 | 101 | 115 | 110 | 125 | 113 | — | — | — | |||||||
| Short-term Activity Ratio | ||||||||||||||||||||||||||||
| Operating cycle1 | 270 | 270 | 296 | 287 | 263 | 259 | 216 | 201 | 211 | 247 | 239 | 217 | 169 | 164 | 192 | 192 | 205 | 189 | — | — | — | |||||||
| Benchmarks | ||||||||||||||||||||||||||||
| Operating Cycle, Competitors2 | ||||||||||||||||||||||||||||
| Boeing Co. | 453 | 466 | 484 | 512 | 507 | 501 | 488 | 493 | 511 | 479 | 533 | 483 | 433 | 404 | — | — | — | — | — | — | — | |||||||
| Caterpillar Inc. | 211 | 201 | 210 | 212 | 215 | 208 | 211 | 212 | 221 | 211 | 199 | 189 | 183 | 174 | — | — | — | — | — | — | — | |||||||
| Eaton Corp. plc | 165 | 162 | 161 | 165 | 158 | 143 | 140 | 139 | 134 | 121 | 117 | 109 | 113 | 130 | — | — | — | — | — | — | — | |||||||
| GE Aerospace | 183 | 203 | 205 | 203 | 194 | 187 | 190 | 188 | 185 | 179 | 166 | 156 | 153 | 144 | — | — | — | — | — | — | — | |||||||
| Honeywell International Inc. | 174 | 167 | 166 | 172 | 163 | 152 | 153 | 150 | 150 | 150 | 152 | 146 | 145 | 141 | — | — | — | — | — | — | — | |||||||
| Lockheed Martin Corp. | 36 | 34 | 34 | 42 | 34 | 30 | 30 | 34 | 33 | 34 | — | — | — | — | — | — | — | — | — | — | — | |||||||
| RTX Corp. | 130 | 123 | 124 | 129 | 120 | 120 | 120 | 118 | 128 | 131 | 136 | 129 | 149 | 134 | — | — | — | — | — | — | — | |||||||
Based on: 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 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).
1 Q1 2023 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= 161 + 109 = 270
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Operating cycle | Equal to average inventory processing period plus average receivables collection period. |
Average Payables Payment Period
Axon Enterprise Inc., average payables payment period calculation (quarterly data)
| Mar 31, 2023 | Dec 31, 2022 | 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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | ||||||||||||||||||||||||||||
| Payables turnover | 7.57 | 7.70 | 8.24 | 6.30 | 7.12 | 10.01 | 11.85 | 39.29 | 14.04 | 10.96 | 11.54 | 6.02 | 7.45 | 8.64 | 13.24 | 20.12 | 17.40 | 10.65 | — | — | — | |||||||
| Short-term Activity Ratio (no. days) | ||||||||||||||||||||||||||||
| Average payables payment period1 | 48 | 47 | 44 | 58 | 51 | 36 | 31 | 9 | 26 | 33 | 32 | 61 | 49 | 42 | 28 | 18 | 21 | 34 | — | — | — | |||||||
| Benchmarks (no. days) | ||||||||||||||||||||||||||||
| Average Payables Payment Period, Competitors2 | ||||||||||||||||||||||||||||
| Boeing Co. | 57 | 59 | 57 | 59 | 54 | 57 | 59 | 67 | 74 | 74 | 86 | 77 | 78 | 79 | — | — | — | — | — | — | — | |||||||
| Caterpillar Inc. | 78 | 77 | 76 | 77 | 82 | 84 | 79 | 80 | 82 | 77 | 62 | 58 | 60 | 59 | — | — | — | — | — | — | — | |||||||
| Eaton Corp. plc | 80 | 81 | 79 | 82 | 78 | 77 | 71 | 70 | 65 | 58 | 51 | 45 | 46 | 54 | — | — | — | — | — | — | — | |||||||
| GE Aerospace | 102 | 123 | 116 | 116 | 110 | 110 | 109 | 109 | 103 | 100 | 78 | 73 | 80 | 83 | — | — | — | — | — | — | — | |||||||
| Honeywell International Inc. | 104 | 103 | 99 | 101 | 100 | 101 | 95 | 97 | 95 | 95 | 85 | 85 | 86 | 86 | — | — | — | — | — | — | — | |||||||
| Lockheed Martin Corp. | 21 | 13 | 17 | 15 | 17 | 5 | 10 | 10 | 12 | 6 | — | — | — | — | — | — | — | — | — | — | — | |||||||
| RTX Corp. | 67 | 68 | 63 | 68 | 58 | 62 | 60 | 56 | 64 | 66 | 61 | 53 | 77 | 69 | — | — | — | — | — | — | — | |||||||
Based on: 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 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).
1 Q1 2023 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 7.57 = 48
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. | Axon Enterprise Inc. number of days of payables outstanding increased from Q3 2022 to Q4 2022 and from Q4 2022 to Q1 2023. |
Cash Conversion Cycle
Axon Enterprise Inc., cash conversion cycle calculation (quarterly data)
No. days
| Mar 31, 2023 | Dec 31, 2022 | 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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | ||||||||||||||||||||||||||||
| Average inventory processing period | 161 | 160 | 153 | 147 | 127 | 123 | 105 | 110 | 118 | 124 | 138 | 122 | 73 | 63 | 77 | 82 | 80 | 76 | — | — | — | |||||||
| Average receivable collection period | 109 | 110 | 143 | 140 | 136 | 136 | 111 | 91 | 93 | 123 | 101 | 95 | 96 | 101 | 115 | 110 | 125 | 113 | — | — | — | |||||||
| Average payables payment period | 48 | 47 | 44 | 58 | 51 | 36 | 31 | 9 | 26 | 33 | 32 | 61 | 49 | 42 | 28 | 18 | 21 | 34 | — | — | — | |||||||
| Short-term Activity Ratio | ||||||||||||||||||||||||||||
| Cash conversion cycle1 | 222 | 223 | 252 | 229 | 212 | 223 | 185 | 192 | 185 | 214 | 207 | 156 | 120 | 122 | 164 | 174 | 184 | 155 | — | — | — | |||||||
| Benchmarks | ||||||||||||||||||||||||||||
| Cash Conversion Cycle, Competitors2 | ||||||||||||||||||||||||||||
| Boeing Co. | 396 | 407 | 427 | 453 | 453 | 444 | 429 | 426 | 437 | 405 | 447 | 406 | 355 | 325 | — | — | — | — | — | — | — | |||||||
| Caterpillar Inc. | 133 | 124 | 134 | 135 | 133 | 124 | 132 | 132 | 139 | 134 | 137 | 131 | 123 | 115 | — | — | — | — | — | — | — | |||||||
| Eaton Corp. plc | 85 | 81 | 82 | 83 | 80 | 66 | 69 | 69 | 69 | 63 | 66 | 64 | 67 | 76 | — | — | — | — | — | — | — | |||||||
| GE Aerospace | 81 | 80 | 89 | 87 | 84 | 77 | 81 | 79 | 82 | 79 | 88 | 83 | 73 | 61 | — | — | — | — | — | — | — | |||||||
| Honeywell International Inc. | 70 | 64 | 67 | 71 | 63 | 51 | 58 | 53 | 55 | 55 | 67 | 61 | 59 | 55 | — | — | — | — | — | — | — | |||||||
| Lockheed Martin Corp. | 15 | 21 | 17 | 27 | 17 | 25 | 20 | 24 | 21 | 28 | — | — | — | — | — | — | — | — | — | — | — | |||||||
| RTX Corp. | 63 | 55 | 61 | 61 | 62 | 58 | 60 | 62 | 64 | 65 | 75 | 76 | 72 | 65 | — | — | — | — | — | — | — | |||||||
Based on: 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 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).
1 Q1 2023 Calculation
Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= 161 + 109 – 48 = 222
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Cash conversion cycle | A financial metric that measures the length of time required for a company to convert cash invested in its operations to cash received as a result of its operations; equal to average inventory processing period plus average receivables collection period minus average payables payment period. | Axon Enterprise Inc. cash conversion cycle improved from Q3 2022 to Q4 2022 and from Q4 2022 to Q1 2023. |