Stock Analysis on Net

Apple Inc. (NASDAQ:AAPL)

Analysis of Long-term (Investment) Activity Ratios
Quarterly Data

Microsoft Excel

Long-term Activity Ratios (Summary)

Apple Inc., long-term (investment) 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
Net fixed asset turnover 8.83 8.77 8.82 8.87 9.02 9.36 9.61 9.82 9.64 9.28 8.99 8.61 7.75 7.47 7.67 7.47 7.23 6.96 6.88 6.67 6.61 6.43
Total asset turnover 1.09 1.09 1.15 1.16 1.12 1.12 1.15 1.10 0.99 1.04 1.05 0.97 0.83 0.85 0.86 0.84 0.79 0.77 0.80 0.76 0.70 0.73
Equity turnover 5.21 6.17 6.37 6.20 6.83 7.78 6.67 5.73 5.26 5.80 5.40 4.70 4.44 4.20 3.79 3.42 2.99 2.88 2.69 2.44 2.22 2.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).

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Apple Inc. net fixed asset turnover ratio deteriorated from Q3 2023 to Q4 2023 but then improved from Q4 2023 to Q1 2024 exceeding Q3 2023 level.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Apple Inc. total asset turnover ratio deteriorated from Q3 2023 to Q4 2023 but then slightly improved from Q4 2023 to Q1 2024.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Apple Inc. equity turnover ratio deteriorated from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024.

Net Fixed Asset Turnover

Apple Inc., net fixed asset 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
Property, plant and equipment, net 43,666 43,715 43,550 43,398 42,951 42,117 40,335 39,304 39,245 39,440 38,615 37,815 37,933 36,766 35,687 35,889 37,031 37,378 37,636 38,746 39,597 41,304 38,117 35,077 33,679
Long-term Activity Ratio
Net fixed asset turnover1 8.83 8.77 8.82 8.87 9.02 9.36 9.61 9.82 9.64 9.28 8.99 8.61 7.75 7.47 7.67 7.47 7.23 6.96 6.88 6.67 6.61 6.43
Benchmarks
Net Fixed Asset Turnover, Competitors2
Arista Networks Inc. 57.69 54.54 51.74 49.98 46.11 40.75 38.14 36.13 37.49 36.78 81.23 75.84 71.90 68.00 64.39 61.85 61.38
Cisco Systems Inc. 28.96 27.34 26.82 27.07 26.52 25.82 25.21 24.09 22.69 21.31 20.64 20.13 19.93 20.10 19.95 19.67 19.48 18.61 18.11 17.34 17.00 16.41
Super Micro Computer Inc. 25.34 24.54 22.67 22.98 20.69 18.17 16.40 14.88 13.47 12.95 12.74 12.77 13.65 14.28 14.31 14.82 15.67 16.88

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
Net fixed asset turnover = (Net salesQ1 2024 + Net salesQ4 2023 + Net salesQ3 2023 + Net salesQ2 2023) ÷ Property, plant and equipment, net
= (119,575 + 89,498 + 81,797 + 94,836) ÷ 43,666 = 8.83

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. Apple Inc. net fixed asset turnover ratio deteriorated from Q3 2023 to Q4 2023 but then improved from Q4 2023 to Q1 2024 exceeding Q3 2023 level.

Total Asset Turnover

Apple Inc., total asset 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
Total assets 353,514 352,583 335,038 332,160 346,747 352,755 336,309 350,662 381,191 351,002 329,840 337,158 354,054 323,888 317,344 320,400 340,618 338,516 322,239 341,998 373,719 365,725 349,197 367,502 406,794
Long-term Activity Ratio
Total asset turnover1 1.09 1.09 1.15 1.16 1.12 1.12 1.15 1.10 0.99 1.04 1.05 0.97 0.83 0.85 0.86 0.84 0.79 0.77 0.80 0.76 0.70 0.73
Benchmarks
Total Asset Turnover, Competitors2
Arista Networks Inc. 0.59 0.62 0.64 0.64 0.65 0.64 0.60 0.52 0.51 0.51 0.50 0.50 0.49 0.50 0.52 0.57 0.58
Cisco Systems Inc. 0.59 0.56 0.56 0.55 0.56 0.55 0.56 0.55 0.53 0.51 0.52 0.50 0.51 0.52 0.55 0.57 0.56 0.53 0.53 0.50 0.48 0.45
Super Micro Computer Inc. 1.80 1.94 2.06 2.16 1.82 1.62 1.51 1.56 1.58 1.59 1.69 1.72 1.82 1.74 1.68 1.81 1.96 2.08

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
Total asset turnover = (Net salesQ1 2024 + Net salesQ4 2023 + Net salesQ3 2023 + Net salesQ2 2023) ÷ Total assets
= (119,575 + 89,498 + 81,797 + 94,836) ÷ 353,514 = 1.09

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

Equity Turnover

Apple Inc., equity 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
Shareholders’ equity 74,100 62,146 60,274 62,158 56,727 50,672 58,107 67,399 71,932 63,090 64,280 69,178 66,224 65,339 72,282 78,425 89,531 90,488 96,456 105,860 117,892 107,147 114,949 126,878 140,199
Long-term Activity Ratio
Equity turnover1 5.21 6.17 6.37 6.20 6.83 7.78 6.67 5.73 5.26 5.80 5.40 4.70 4.44 4.20 3.79 3.42 2.99 2.88 2.69 2.44 2.22 2.48
Benchmarks
Equity Turnover, Competitors2
Arista Networks Inc. 0.81 0.86 0.90 0.91 0.90 0.90 0.87 0.76 0.74 0.72 0.71 0.71 0.70 0.72 0.75 0.82 0.83
Cisco Systems Inc. 1.28 1.29 1.30 1.28 1.30 1.30 1.28 1.31 1.19 1.21 1.21 1.23 1.26 1.30 1.42 1.45 1.51 1.55 1.39 1.25 1.15 1.14
Super Micro Computer Inc. 3.41 3.61 3.72 3.65 3.70 3.64 3.63 3.51 3.38 3.25 3.21 3.06 3.08 3.13 3.18 3.26 3.43 3.72

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
Equity turnover = (Net salesQ1 2024 + Net salesQ4 2023 + Net salesQ3 2023 + Net salesQ2 2023) ÷ Shareholders’ equity
= (119,575 + 89,498 + 81,797 + 94,836) ÷ 74,100 = 5.21

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Apple Inc. equity turnover ratio deteriorated from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024.