Stock Analysis on Net

Apple Inc. (NASDAQ:AAPL)

Analysis of Short-term (Operating) Activity Ratios
Quarterly Data

Microsoft Excel

Short-term Activity Ratios (Summary)

Apple Inc., short-term (operating) activity ratios (quarterly data)

Microsoft Excel
Dec 30, 2023 Sep 30, 2023 Jul 1, 2023 Apr 1, 2023 Dec 31, 2022 Sep 24, 2022 Jun 25, 2022 Mar 26, 2022 Dec 25, 2021 Sep 25, 2021 Jun 26, 2021 Mar 27, 2021 Dec 26, 2020 Sep 26, 2020 Jun 27, 2020 Mar 28, 2020 Dec 28, 2019 Sep 28, 2019 Jun 29, 2019 Mar 30, 2019 Dec 29, 2018 Sep 29, 2018 Jun 30, 2018 Mar 31, 2018 Dec 30, 2017
Turnover Ratios
Inventory turnover 32.57 33.82 29.54 29.24 32.36 45.20 40.43 40.07 36.69 32.37 39.55 37.48 36.21 41.75 42.55 49.75 40.54 39.40 47.95 32.79 32.41 41.39
Receivables turnover 16.63 12.99 19.64 21.47 16.32 13.99 17.77 18.55 12.52 13.92 19.87 17.59 10.85 17.03 15.31 17.04 12.77 11.35 18.31 17.14 14.47 11.45
Payables turnover 3.65 3.42 4.65 5.10 3.81 3.49 4.54 4.15 2.90 3.89 5.07 4.88 2.82 4.01 4.79 5.12 3.68 3.50 5.53 5.26 3.65 2.93
Working capital turnover 39.69 67.80 39.10 52.06 21.58 13.62 7.16 6.12 5.62 4.38 4.56 5.72 8.74 8.04 18.35
Average No. Days
Average inventory processing period 11 11 12 12 11 8 9 9 10 11 9 10 10 9 9 7 9 9 8 11 11 9
Add: Average receivable collection period 22 28 19 17 22 26 21 20 29 26 18 21 34 21 24 21 29 32 20 21 25 32
Operating cycle 33 39 31 29 33 34 30 29 39 37 27 31 44 30 33 28 38 41 28 32 36 41
Less: Average payables payment period 100 107 79 72 96 105 80 88 126 94 72 75 129 91 76 71 99 104 66 69 100 125
Cash conversion cycle -67 -68 -48 -43 -63 -71 -50 -59 -87 -57 -45 -44 -85 -61 -43 -43 -61 -63 -38 -37 -64 -84

Based on: 10-Q (reporting date: 2023-12-30), 10-K (reporting date: 2023-09-30), 10-Q (reporting date: 2023-07-01), 10-Q (reporting date: 2023-04-01), 10-Q (reporting date: 2022-12-31), 10-K (reporting date: 2022-09-24), 10-Q (reporting date: 2022-06-25), 10-Q (reporting date: 2022-03-26), 10-Q (reporting date: 2021-12-25), 10-K (reporting date: 2021-09-25), 10-Q (reporting date: 2021-06-26), 10-Q (reporting date: 2021-03-27), 10-Q (reporting date: 2020-12-26), 10-K (reporting date: 2020-09-26), 10-Q (reporting date: 2020-06-27), 10-Q (reporting date: 2020-03-28), 10-Q (reporting date: 2019-12-28), 10-K (reporting date: 2019-09-28), 10-Q (reporting date: 2019-06-29), 10-Q (reporting date: 2019-03-30), 10-Q (reporting date: 2018-12-29), 10-K (reporting date: 2018-09-29), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-30).

Short-term activity ratio Description The company
Inventory turnover An activity ratio calculated as cost of goods sold divided by inventory. Apple Inc. inventory turnover ratio improved from Q3 2023 to Q4 2023 but then slightly deteriorated from Q4 2023 to Q1 2024.
Receivables turnover An activity ratio equal to revenue divided by receivables. Apple Inc. receivables turnover ratio deteriorated from Q3 2023 to Q4 2023 but then improved from Q4 2023 to Q1 2024 not reaching Q3 2023 level.
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Apple Inc. payables turnover ratio decreased from Q3 2023 to Q4 2023 but then slightly increased from Q4 2023 to Q1 2024.

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.
Average receivable collection period An activity ratio equal to the number of days in the period divided by receivables turnover. Apple Inc. number of days of receivables outstanding deteriorated from Q3 2023 to Q4 2023 but then improved from Q4 2023 to Q1 2024 not reaching Q3 2023 level.
Operating cycle Equal to average inventory processing period plus average receivables collection period. Apple Inc. operating cycle deteriorated from Q3 2023 to Q4 2023 but then improved from Q4 2023 to Q1 2024 not reaching Q3 2023 level.
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. Apple Inc. number of days of payables outstanding increased from Q3 2023 to Q4 2023 but then slightly decreased from Q4 2023 to Q1 2024.
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. Apple Inc. cash conversion cycle improved from Q3 2023 to Q4 2023 but then slightly deteriorated from Q4 2023 to Q1 2024.

Inventory Turnover

Apple Inc., inventory turnover calculation (quarterly data)

Microsoft Excel
Dec 30, 2023 Sep 30, 2023 Jul 1, 2023 Apr 1, 2023 Dec 31, 2022 Sep 24, 2022 Jun 25, 2022 Mar 26, 2022 Dec 25, 2021 Sep 25, 2021 Jun 26, 2021 Mar 27, 2021 Dec 26, 2020 Sep 26, 2020 Jun 27, 2020 Mar 28, 2020 Dec 28, 2019 Sep 28, 2019 Jun 29, 2019 Mar 30, 2019 Dec 29, 2018 Sep 29, 2018 Jun 30, 2018 Mar 31, 2018 Dec 30, 2017
Selected Financial Data (US$ in millions)
Cost of sales 64,720 49,071 45,384 52,860 66,822 52,051 47,074 54,719 69,702 48,186 46,179 51,505 67,111 40,009 37,005 35,943 56,602 39,727 33,582 36,194 52,279 38,816 32,844 37,715 54,381
Inventories 6,511 6,331 7,351 7,482 6,820 4,946 5,433 5,460 5,876 6,580 5,178 5,219 4,973 4,061 3,978 3,334 4,097 4,106 3,355 4,884 4,988 3,956 5,936 7,662 4,421
Short-term Activity Ratio
Inventory turnover1 32.57 33.82 29.54 29.24 32.36 45.20 40.43 40.07 36.69 32.37 39.55 37.48 36.21 41.75 42.55 49.75 40.54 39.40 47.95 32.79 32.41 41.39
Benchmarks
Inventory Turnover, Competitors2
Arista Networks Inc. 1.15 1.16 1.12 1.15 1.32 1.36 1.53 1.65 1.64 1.74 1.75 1.85 1.74 1.82 2.49 3.19 3.55
Cisco Systems Inc. 6.30 5.83 6.01 6.45 7.41 7.52 8.52 9.19 10.06 11.50 11.15 11.98 13.25 13.74 14.85 13.73 14.14 13.91 12.76 11.30 12.05 10.14
Super Micro Computer Inc. 2.97 4.04 3.49 3.84 2.88 2.84 2.50 2.58 2.77 2.90 3.18 3.39 3.59 3.30 3.19 3.91 4.12 4.48

Based on: 10-Q (reporting date: 2023-12-30), 10-K (reporting date: 2023-09-30), 10-Q (reporting date: 2023-07-01), 10-Q (reporting date: 2023-04-01), 10-Q (reporting date: 2022-12-31), 10-K (reporting date: 2022-09-24), 10-Q (reporting date: 2022-06-25), 10-Q (reporting date: 2022-03-26), 10-Q (reporting date: 2021-12-25), 10-K (reporting date: 2021-09-25), 10-Q (reporting date: 2021-06-26), 10-Q (reporting date: 2021-03-27), 10-Q (reporting date: 2020-12-26), 10-K (reporting date: 2020-09-26), 10-Q (reporting date: 2020-06-27), 10-Q (reporting date: 2020-03-28), 10-Q (reporting date: 2019-12-28), 10-K (reporting date: 2019-09-28), 10-Q (reporting date: 2019-06-29), 10-Q (reporting date: 2019-03-30), 10-Q (reporting date: 2018-12-29), 10-K (reporting date: 2018-09-29), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-30).

1 Q1 2024 Calculation
Inventory turnover = (Cost of salesQ1 2024 + Cost of salesQ4 2023 + Cost of salesQ3 2023 + Cost of salesQ2 2023) ÷ Inventories
= (64,720 + 49,071 + 45,384 + 52,860) ÷ 6,511 = 32.57

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. Apple Inc. inventory turnover ratio improved from Q3 2023 to Q4 2023 but then slightly deteriorated from Q4 2023 to Q1 2024.

Receivables Turnover

Apple Inc., receivables turnover calculation (quarterly data)

Microsoft Excel
Dec 30, 2023 Sep 30, 2023 Jul 1, 2023 Apr 1, 2023 Dec 31, 2022 Sep 24, 2022 Jun 25, 2022 Mar 26, 2022 Dec 25, 2021 Sep 25, 2021 Jun 26, 2021 Mar 27, 2021 Dec 26, 2020 Sep 26, 2020 Jun 27, 2020 Mar 28, 2020 Dec 28, 2019 Sep 28, 2019 Jun 29, 2019 Mar 30, 2019 Dec 29, 2018 Sep 29, 2018 Jun 30, 2018 Mar 31, 2018 Dec 30, 2017
Selected Financial Data (US$ in millions)
Net sales 119,575 89,498 81,797 94,836 117,154 90,146 82,959 97,278 123,945 83,360 81,434 89,584 111,439 64,698 59,685 58,313 91,819 64,040 53,809 58,015 84,310 62,900 53,265 61,137 88,293
Accounts receivable, net 23,194 29,508 19,549 17,936 23,752 28,184 21,803 20,815 30,213 26,278 17,475 18,503 27,101 16,120 17,882 15,722 20,970 22,926 14,148 15,085 18,077 23,186 14,104 14,324 23,440
Short-term Activity Ratio
Receivables turnover1 16.63 12.99 19.64 21.47 16.32 13.99 17.77 18.55 12.52 13.92 19.87 17.59 10.85 17.03 15.31 17.04 12.77 11.35 18.31 17.14 14.47 11.45
Benchmarks
Receivables Turnover, Competitors2
Arista Networks Inc. 5.72 6.71 6.75 5.63 4.75 6.03 5.98 4.87 5.71 7.01 7.22 6.47 5.95 7.40 5.92 6.64 6.15
Cisco Systems Inc. 12.01 9.74 10.76 10.15 9.61 7.79 8.92 8.59 9.57 8.64 11.04 11.15 12.08 9.01 11.07 11.91 10.66 9.45 13.52 13.57 11.08 8.88
Super Micro Computer Inc. 8.74 6.20 9.78 8.65 8.17 6.23 6.81 8.38 8.36 7.67 8.31 10.10 10.23 8.27 9.90 9.07 9.35 8.89

Based on: 10-Q (reporting date: 2023-12-30), 10-K (reporting date: 2023-09-30), 10-Q (reporting date: 2023-07-01), 10-Q (reporting date: 2023-04-01), 10-Q (reporting date: 2022-12-31), 10-K (reporting date: 2022-09-24), 10-Q (reporting date: 2022-06-25), 10-Q (reporting date: 2022-03-26), 10-Q (reporting date: 2021-12-25), 10-K (reporting date: 2021-09-25), 10-Q (reporting date: 2021-06-26), 10-Q (reporting date: 2021-03-27), 10-Q (reporting date: 2020-12-26), 10-K (reporting date: 2020-09-26), 10-Q (reporting date: 2020-06-27), 10-Q (reporting date: 2020-03-28), 10-Q (reporting date: 2019-12-28), 10-K (reporting date: 2019-09-28), 10-Q (reporting date: 2019-06-29), 10-Q (reporting date: 2019-03-30), 10-Q (reporting date: 2018-12-29), 10-K (reporting date: 2018-09-29), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-30).

1 Q1 2024 Calculation
Receivables turnover = (Net salesQ1 2024 + Net salesQ4 2023 + Net salesQ3 2023 + Net salesQ2 2023) ÷ Accounts receivable, net
= (119,575 + 89,498 + 81,797 + 94,836) ÷ 23,194 = 16.63

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. Apple Inc. receivables turnover ratio deteriorated from Q3 2023 to Q4 2023 but then improved from Q4 2023 to Q1 2024 not reaching Q3 2023 level.

Payables Turnover

Apple Inc., payables turnover calculation (quarterly data)

Microsoft Excel
Dec 30, 2023 Sep 30, 2023 Jul 1, 2023 Apr 1, 2023 Dec 31, 2022 Sep 24, 2022 Jun 25, 2022 Mar 26, 2022 Dec 25, 2021 Sep 25, 2021 Jun 26, 2021 Mar 27, 2021 Dec 26, 2020 Sep 26, 2020 Jun 27, 2020 Mar 28, 2020 Dec 28, 2019 Sep 28, 2019 Jun 29, 2019 Mar 30, 2019 Dec 29, 2018 Sep 29, 2018 Jun 30, 2018 Mar 31, 2018 Dec 30, 2017
Selected Financial Data (US$ in millions)
Cost of sales 64,720 49,071 45,384 52,860 66,822 52,051 47,074 54,719 69,702 48,186 46,179 51,505 67,111 40,009 37,005 35,943 56,602 39,727 33,582 36,194 52,279 38,816 32,844 37,715 54,381
Accounts payable 58,146 62,611 46,699 42,945 57,918 64,115 48,343 52,682 74,362 54,763 40,409 40,127 63,846 42,296 35,325 32,421 45,111 46,236 29,115 30,443 44,293 55,888 38,489 34,311 62,985
Short-term Activity Ratio
Payables turnover1 3.65 3.42 4.65 5.10 3.81 3.49 4.54 4.15 2.90 3.89 5.07 4.88 2.82 4.01 4.79 5.12 3.68 3.50 5.53 5.26 3.65 2.93
Benchmarks
Payables Turnover, Competitors2
Arista Networks Inc. 5.13 8.16 5.95 5.84 7.33 5.39 4.74 5.61 5.27 7.39 6.54 6.52 6.23 4.89 6.63 9.86 9.41
Cisco Systems Inc. 10.11 9.19 8.55 8.69 8.53 8.47 8.31 9.00 8.15 7.59 7.22 9.22 7.53 7.94 7.52 9.60 9.43 9.34 9.55 11.62 10.49 9.83
Super Micro Computer Inc. 5.63 7.52 8.38 9.76 6.38 6.71 5.09 5.18 5.82 4.94 6.18 6.91 8.33 6.74 5.97 7.02 8.51 8.34

Based on: 10-Q (reporting date: 2023-12-30), 10-K (reporting date: 2023-09-30), 10-Q (reporting date: 2023-07-01), 10-Q (reporting date: 2023-04-01), 10-Q (reporting date: 2022-12-31), 10-K (reporting date: 2022-09-24), 10-Q (reporting date: 2022-06-25), 10-Q (reporting date: 2022-03-26), 10-Q (reporting date: 2021-12-25), 10-K (reporting date: 2021-09-25), 10-Q (reporting date: 2021-06-26), 10-Q (reporting date: 2021-03-27), 10-Q (reporting date: 2020-12-26), 10-K (reporting date: 2020-09-26), 10-Q (reporting date: 2020-06-27), 10-Q (reporting date: 2020-03-28), 10-Q (reporting date: 2019-12-28), 10-K (reporting date: 2019-09-28), 10-Q (reporting date: 2019-06-29), 10-Q (reporting date: 2019-03-30), 10-Q (reporting date: 2018-12-29), 10-K (reporting date: 2018-09-29), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-30).

1 Q1 2024 Calculation
Payables turnover = (Cost of salesQ1 2024 + Cost of salesQ4 2023 + Cost of salesQ3 2023 + Cost of salesQ2 2023) ÷ Accounts payable
= (64,720 + 49,071 + 45,384 + 52,860) ÷ 58,146 = 3.65

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. Apple Inc. payables turnover ratio decreased from Q3 2023 to Q4 2023 but then slightly increased from Q4 2023 to Q1 2024.

Working Capital Turnover

Apple Inc., working capital turnover calculation (quarterly data)

Microsoft Excel
Dec 30, 2023 Sep 30, 2023 Jul 1, 2023 Apr 1, 2023 Dec 31, 2022 Sep 24, 2022 Jun 25, 2022 Mar 26, 2022 Dec 25, 2021 Sep 25, 2021 Jun 26, 2021 Mar 27, 2021 Dec 26, 2020 Sep 26, 2020 Jun 27, 2020 Mar 28, 2020 Dec 28, 2019 Sep 28, 2019 Jun 29, 2019 Mar 30, 2019 Dec 29, 2018 Sep 29, 2018 Jun 30, 2018 Mar 31, 2018 Dec 30, 2017
Selected Financial Data (US$ in millions)
Current assets 143,692 143,566 122,659 112,913 128,777 135,405 112,292 118,180 153,154 134,836 114,423 121,465 154,106 143,713 140,065 143,753 163,231 162,819 134,973 123,346 140,828 131,339 115,761 130,053 143,810
Less: Current liabilities 133,973 145,308 124,963 120,075 137,286 153,982 129,873 127,508 147,574 125,481 107,754 106,385 132,507 105,392 95,318 96,094 102,161 105,718 89,704 93,772 108,283 116,866 88,548 89,320 115,788
Working capital 9,719 (1,742) (2,304) (7,162) (8,509) (18,577) (17,581) (9,328) 5,580 9,355 6,669 15,080 21,599 38,321 44,747 47,659 61,070 57,101 45,269 29,574 32,545 14,473 27,213 40,733 28,022
 
Net sales 119,575 89,498 81,797 94,836 117,154 90,146 82,959 97,278 123,945 83,360 81,434 89,584 111,439 64,698 59,685 58,313 91,819 64,040 53,809 58,015 84,310 62,900 53,265 61,137 88,293
Short-term Activity Ratio
Working capital turnover1 39.69 67.80 39.10 52.06 21.58 13.62 7.16 6.12 5.62 4.38 4.56 5.72 8.74 8.04 18.35
Benchmarks
Working Capital Turnover, Competitors2
Arista Networks Inc. 0.90 0.96 1.01 1.04 1.03 1.04 1.01 0.85 0.80 0.76 0.76 0.77 0.76 0.74 0.77 0.85 0.84
Cisco Systems Inc. 4.60 4.73 4.89 4.72 4.65 4.65 4.36 4.74 3.54 3.88 3.82 2.89 3.00 2.70 3.29 2.87 3.04 3.24 2.65 2.15 1.72 1.42
Super Micro Computer Inc. 3.76 3.95 4.05 3.84 3.94 3.89 3.91 3.81 4.09 3.96 3.95 3.74 3.71 3.77 3.82 3.85 4.00 4.29

Based on: 10-Q (reporting date: 2023-12-30), 10-K (reporting date: 2023-09-30), 10-Q (reporting date: 2023-07-01), 10-Q (reporting date: 2023-04-01), 10-Q (reporting date: 2022-12-31), 10-K (reporting date: 2022-09-24), 10-Q (reporting date: 2022-06-25), 10-Q (reporting date: 2022-03-26), 10-Q (reporting date: 2021-12-25), 10-K (reporting date: 2021-09-25), 10-Q (reporting date: 2021-06-26), 10-Q (reporting date: 2021-03-27), 10-Q (reporting date: 2020-12-26), 10-K (reporting date: 2020-09-26), 10-Q (reporting date: 2020-06-27), 10-Q (reporting date: 2020-03-28), 10-Q (reporting date: 2019-12-28), 10-K (reporting date: 2019-09-28), 10-Q (reporting date: 2019-06-29), 10-Q (reporting date: 2019-03-30), 10-Q (reporting date: 2018-12-29), 10-K (reporting date: 2018-09-29), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-30).

1 Q1 2024 Calculation
Working capital turnover = (Net salesQ1 2024 + Net salesQ4 2023 + Net salesQ3 2023 + Net salesQ2 2023) ÷ Working capital
= (119,575 + 89,498 + 81,797 + 94,836) ÷ 9,719 = 39.69

2 Click competitor name to see calculations.


Average Inventory Processing Period

Apple Inc., average inventory processing period calculation (quarterly data)

Microsoft Excel
Dec 30, 2023 Sep 30, 2023 Jul 1, 2023 Apr 1, 2023 Dec 31, 2022 Sep 24, 2022 Jun 25, 2022 Mar 26, 2022 Dec 25, 2021 Sep 25, 2021 Jun 26, 2021 Mar 27, 2021 Dec 26, 2020 Sep 26, 2020 Jun 27, 2020 Mar 28, 2020 Dec 28, 2019 Sep 28, 2019 Jun 29, 2019 Mar 30, 2019 Dec 29, 2018 Sep 29, 2018 Jun 30, 2018 Mar 31, 2018 Dec 30, 2017
Selected Financial Data
Inventory turnover 32.57 33.82 29.54 29.24 32.36 45.20 40.43 40.07 36.69 32.37 39.55 37.48 36.21 41.75 42.55 49.75 40.54 39.40 47.95 32.79 32.41 41.39
Short-term Activity Ratio (no. days)
Average inventory processing period1 11 11 12 12 11 8 9 9 10 11 9 10 10 9 9 7 9 9 8 11 11 9
Benchmarks (no. days)
Average Inventory Processing Period, Competitors2
Arista Networks Inc. 318 315 325 318 276 268 239 221 222 210 209 197 210 200 147 114 103
Cisco Systems Inc. 58 63 61 57 49 49 43 40 36 32 33 30 28 27 25 27 26 26 29 32 30 36
Super Micro Computer Inc. 123 90 105 95 127 128 146 141 132 126 115 108 102 110 114 93 89 81

Based on: 10-Q (reporting date: 2023-12-30), 10-K (reporting date: 2023-09-30), 10-Q (reporting date: 2023-07-01), 10-Q (reporting date: 2023-04-01), 10-Q (reporting date: 2022-12-31), 10-K (reporting date: 2022-09-24), 10-Q (reporting date: 2022-06-25), 10-Q (reporting date: 2022-03-26), 10-Q (reporting date: 2021-12-25), 10-K (reporting date: 2021-09-25), 10-Q (reporting date: 2021-06-26), 10-Q (reporting date: 2021-03-27), 10-Q (reporting date: 2020-12-26), 10-K (reporting date: 2020-09-26), 10-Q (reporting date: 2020-06-27), 10-Q (reporting date: 2020-03-28), 10-Q (reporting date: 2019-12-28), 10-K (reporting date: 2019-09-28), 10-Q (reporting date: 2019-06-29), 10-Q (reporting date: 2019-03-30), 10-Q (reporting date: 2018-12-29), 10-K (reporting date: 2018-09-29), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-30).

1 Q1 2024 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 32.57 = 11

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.

Average Receivable Collection Period

Apple Inc., average receivable collection period calculation (quarterly data)

Microsoft Excel
Dec 30, 2023 Sep 30, 2023 Jul 1, 2023 Apr 1, 2023 Dec 31, 2022 Sep 24, 2022 Jun 25, 2022 Mar 26, 2022 Dec 25, 2021 Sep 25, 2021 Jun 26, 2021 Mar 27, 2021 Dec 26, 2020 Sep 26, 2020 Jun 27, 2020 Mar 28, 2020 Dec 28, 2019 Sep 28, 2019 Jun 29, 2019 Mar 30, 2019 Dec 29, 2018 Sep 29, 2018 Jun 30, 2018 Mar 31, 2018 Dec 30, 2017
Selected Financial Data
Receivables turnover 16.63 12.99 19.64 21.47 16.32 13.99 17.77 18.55 12.52 13.92 19.87 17.59 10.85 17.03 15.31 17.04 12.77 11.35 18.31 17.14 14.47 11.45
Short-term Activity Ratio (no. days)
Average receivable collection period1 22 28 19 17 22 26 21 20 29 26 18 21 34 21 24 21 29 32 20 21 25 32
Benchmarks (no. days)
Average Receivable Collection Period, Competitors2
Arista Networks Inc. 64 54 54 65 77 61 61 75 64 52 51 56 61 49 62 55 59
Cisco Systems Inc. 30 37 34 36 38 47 41 43 38 42 33 33 30 41 33 31 34 39 27 27 33 41
Super Micro Computer Inc. 42 59 37 42 45 59 54 44 44 48 44 36 36 44 37 40 39 41

Based on: 10-Q (reporting date: 2023-12-30), 10-K (reporting date: 2023-09-30), 10-Q (reporting date: 2023-07-01), 10-Q (reporting date: 2023-04-01), 10-Q (reporting date: 2022-12-31), 10-K (reporting date: 2022-09-24), 10-Q (reporting date: 2022-06-25), 10-Q (reporting date: 2022-03-26), 10-Q (reporting date: 2021-12-25), 10-K (reporting date: 2021-09-25), 10-Q (reporting date: 2021-06-26), 10-Q (reporting date: 2021-03-27), 10-Q (reporting date: 2020-12-26), 10-K (reporting date: 2020-09-26), 10-Q (reporting date: 2020-06-27), 10-Q (reporting date: 2020-03-28), 10-Q (reporting date: 2019-12-28), 10-K (reporting date: 2019-09-28), 10-Q (reporting date: 2019-06-29), 10-Q (reporting date: 2019-03-30), 10-Q (reporting date: 2018-12-29), 10-K (reporting date: 2018-09-29), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-30).

1 Q1 2024 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 16.63 = 22

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. Apple Inc. number of days of receivables outstanding deteriorated from Q3 2023 to Q4 2023 but then improved from Q4 2023 to Q1 2024 not reaching Q3 2023 level.

Operating Cycle

Apple Inc., operating cycle calculation (quarterly data)

No. days

Microsoft Excel
Dec 30, 2023 Sep 30, 2023 Jul 1, 2023 Apr 1, 2023 Dec 31, 2022 Sep 24, 2022 Jun 25, 2022 Mar 26, 2022 Dec 25, 2021 Sep 25, 2021 Jun 26, 2021 Mar 27, 2021 Dec 26, 2020 Sep 26, 2020 Jun 27, 2020 Mar 28, 2020 Dec 28, 2019 Sep 28, 2019 Jun 29, 2019 Mar 30, 2019 Dec 29, 2018 Sep 29, 2018 Jun 30, 2018 Mar 31, 2018 Dec 30, 2017
Selected Financial Data
Average inventory processing period 11 11 12 12 11 8 9 9 10 11 9 10 10 9 9 7 9 9 8 11 11 9
Average receivable collection period 22 28 19 17 22 26 21 20 29 26 18 21 34 21 24 21 29 32 20 21 25 32
Short-term Activity Ratio
Operating cycle1 33 39 31 29 33 34 30 29 39 37 27 31 44 30 33 28 38 41 28 32 36 41
Benchmarks
Operating Cycle, Competitors2
Arista Networks Inc. 382 369 379 383 353 329 300 296 286 262 260 253 271 249 209 169 162
Cisco Systems Inc. 88 100 95 93 87 96 84 83 74 74 66 63 58 68 58 58 60 65 56 59 63 77
Super Micro Computer Inc. 165 149 142 137 172 187 200 185 176 174 159 144 138 154 151 133 128 122

Based on: 10-Q (reporting date: 2023-12-30), 10-K (reporting date: 2023-09-30), 10-Q (reporting date: 2023-07-01), 10-Q (reporting date: 2023-04-01), 10-Q (reporting date: 2022-12-31), 10-K (reporting date: 2022-09-24), 10-Q (reporting date: 2022-06-25), 10-Q (reporting date: 2022-03-26), 10-Q (reporting date: 2021-12-25), 10-K (reporting date: 2021-09-25), 10-Q (reporting date: 2021-06-26), 10-Q (reporting date: 2021-03-27), 10-Q (reporting date: 2020-12-26), 10-K (reporting date: 2020-09-26), 10-Q (reporting date: 2020-06-27), 10-Q (reporting date: 2020-03-28), 10-Q (reporting date: 2019-12-28), 10-K (reporting date: 2019-09-28), 10-Q (reporting date: 2019-06-29), 10-Q (reporting date: 2019-03-30), 10-Q (reporting date: 2018-12-29), 10-K (reporting date: 2018-09-29), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-30).

1 Q1 2024 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= 11 + 22 = 33

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. Apple Inc. operating cycle deteriorated from Q3 2023 to Q4 2023 but then improved from Q4 2023 to Q1 2024 not reaching Q3 2023 level.

Average Payables Payment Period

Apple Inc., average payables payment period calculation (quarterly data)

Microsoft Excel
Dec 30, 2023 Sep 30, 2023 Jul 1, 2023 Apr 1, 2023 Dec 31, 2022 Sep 24, 2022 Jun 25, 2022 Mar 26, 2022 Dec 25, 2021 Sep 25, 2021 Jun 26, 2021 Mar 27, 2021 Dec 26, 2020 Sep 26, 2020 Jun 27, 2020 Mar 28, 2020 Dec 28, 2019 Sep 28, 2019 Jun 29, 2019 Mar 30, 2019 Dec 29, 2018 Sep 29, 2018 Jun 30, 2018 Mar 31, 2018 Dec 30, 2017
Selected Financial Data
Payables turnover 3.65 3.42 4.65 5.10 3.81 3.49 4.54 4.15 2.90 3.89 5.07 4.88 2.82 4.01 4.79 5.12 3.68 3.50 5.53 5.26 3.65 2.93
Short-term Activity Ratio (no. days)
Average payables payment period1 100 107 79 72 96 105 80 88 126 94 72 75 129 91 76 71 99 104 66 69 100 125
Benchmarks (no. days)
Average Payables Payment Period, Competitors2
Arista Networks Inc. 71 45 61 62 50 68 77 65 69 49 56 56 59 75 55 37 39
Cisco Systems Inc. 36 40 43 42 43 43 44 41 45 48 51 40 48 46 49 38 39 39 38 31 35 37
Super Micro Computer Inc. 65 49 44 37 57 54 72 70 63 74 59 53 44 54 61 52 43 44

Based on: 10-Q (reporting date: 2023-12-30), 10-K (reporting date: 2023-09-30), 10-Q (reporting date: 2023-07-01), 10-Q (reporting date: 2023-04-01), 10-Q (reporting date: 2022-12-31), 10-K (reporting date: 2022-09-24), 10-Q (reporting date: 2022-06-25), 10-Q (reporting date: 2022-03-26), 10-Q (reporting date: 2021-12-25), 10-K (reporting date: 2021-09-25), 10-Q (reporting date: 2021-06-26), 10-Q (reporting date: 2021-03-27), 10-Q (reporting date: 2020-12-26), 10-K (reporting date: 2020-09-26), 10-Q (reporting date: 2020-06-27), 10-Q (reporting date: 2020-03-28), 10-Q (reporting date: 2019-12-28), 10-K (reporting date: 2019-09-28), 10-Q (reporting date: 2019-06-29), 10-Q (reporting date: 2019-03-30), 10-Q (reporting date: 2018-12-29), 10-K (reporting date: 2018-09-29), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-30).

1 Q1 2024 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 3.65 = 100

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. Apple Inc. number of days of payables outstanding increased from Q3 2023 to Q4 2023 but then slightly decreased from Q4 2023 to Q1 2024.

Cash Conversion Cycle

Apple Inc., cash conversion cycle calculation (quarterly data)

No. days

Microsoft Excel
Dec 30, 2023 Sep 30, 2023 Jul 1, 2023 Apr 1, 2023 Dec 31, 2022 Sep 24, 2022 Jun 25, 2022 Mar 26, 2022 Dec 25, 2021 Sep 25, 2021 Jun 26, 2021 Mar 27, 2021 Dec 26, 2020 Sep 26, 2020 Jun 27, 2020 Mar 28, 2020 Dec 28, 2019 Sep 28, 2019 Jun 29, 2019 Mar 30, 2019 Dec 29, 2018 Sep 29, 2018 Jun 30, 2018 Mar 31, 2018 Dec 30, 2017
Selected Financial Data
Average inventory processing period 11 11 12 12 11 8 9 9 10 11 9 10 10 9 9 7 9 9 8 11 11 9
Average receivable collection period 22 28 19 17 22 26 21 20 29 26 18 21 34 21 24 21 29 32 20 21 25 32
Average payables payment period 100 107 79 72 96 105 80 88 126 94 72 75 129 91 76 71 99 104 66 69 100 125
Short-term Activity Ratio
Cash conversion cycle1 -67 -68 -48 -43 -63 -71 -50 -59 -87 -57 -45 -44 -85 -61 -43 -43 -61 -63 -38 -37 -64 -84
Benchmarks
Cash Conversion Cycle, Competitors2
Arista Networks Inc. 311 324 318 321 303 261 223 231 217 213 204 197 212 174 154 132 123
Cisco Systems Inc. 52 60 52 51 44 53 40 42 29 26 15 23 10 22 9 20 21 26 18 28 28 40
Super Micro Computer Inc. 100 100 98 100 115 133 128 115 113 100 100 91 94 100 90 81 85 78

Based on: 10-Q (reporting date: 2023-12-30), 10-K (reporting date: 2023-09-30), 10-Q (reporting date: 2023-07-01), 10-Q (reporting date: 2023-04-01), 10-Q (reporting date: 2022-12-31), 10-K (reporting date: 2022-09-24), 10-Q (reporting date: 2022-06-25), 10-Q (reporting date: 2022-03-26), 10-Q (reporting date: 2021-12-25), 10-K (reporting date: 2021-09-25), 10-Q (reporting date: 2021-06-26), 10-Q (reporting date: 2021-03-27), 10-Q (reporting date: 2020-12-26), 10-K (reporting date: 2020-09-26), 10-Q (reporting date: 2020-06-27), 10-Q (reporting date: 2020-03-28), 10-Q (reporting date: 2019-12-28), 10-K (reporting date: 2019-09-28), 10-Q (reporting date: 2019-06-29), 10-Q (reporting date: 2019-03-30), 10-Q (reporting date: 2018-12-29), 10-K (reporting date: 2018-09-29), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-30).

1 Q1 2024 Calculation
Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= 11 + 22100 = -67

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. Apple Inc. cash conversion cycle improved from Q3 2023 to Q4 2023 but then slightly deteriorated from Q4 2023 to Q1 2024.