Stock Analysis on Net

Apple Inc. (NASDAQ:AAPL)

Analysis of Geographic Areas 

Microsoft Excel

Area Asset Turnover

Apple Inc., asset turnover by geographic area

Microsoft Excel
Sep 24, 2022 Sep 25, 2021 Sep 26, 2020 Sep 28, 2019 Sep 29, 2018 Sep 30, 2017
U.S. 4.75 4.74 4.22 4.14 4.09 4.09
China (includes Hong Kong and Taiwan) 10.22 9.09 5.56 4.82 3.91 4.38
Other countries 46.09 44.04 34.53 31.70 28.38 34.12

Based on: 10-K (reporting date: 2022-09-24), 10-K (reporting date: 2021-09-25), 10-K (reporting date: 2020-09-26), 10-K (reporting date: 2019-09-28), 10-K (reporting date: 2018-09-29), 10-K (reporting date: 2017-09-30).

Area activity ratio Geographic area The company
Area asset turnover U.S. U.S. area asset turnover ratio improved from 2020 to 2021 and from 2021 to 2022.
China (includes Hong Kong and Taiwan) China (includes Hong Kong and Taiwan) area asset turnover ratio improved from 2020 to 2021 and from 2021 to 2022.
Other countries Other countries area asset turnover ratio improved from 2020 to 2021 and from 2021 to 2022.

Area Asset Turnover: U.S.

Apple Inc.; U.S.; area asset turnover calculation

Microsoft Excel
Sep 24, 2022 Sep 25, 2021 Sep 26, 2020 Sep 28, 2019 Sep 29, 2018 Sep 30, 2017
Selected Financial Data (US$ in millions)
Net sales 147,859 133,803 109,197 102,266 98,061 84,339
Long-lived assets 31,119 28,203 25,890 24,711 23,963 20,637
Area Activity Ratio
Area asset turnover1 4.75 4.74 4.22 4.14 4.09 4.09

Based on: 10-K (reporting date: 2022-09-24), 10-K (reporting date: 2021-09-25), 10-K (reporting date: 2020-09-26), 10-K (reporting date: 2019-09-28), 10-K (reporting date: 2018-09-29), 10-K (reporting date: 2017-09-30).

1 2022 Calculation
Area asset turnover = Net sales ÷ Long-lived assets
= 147,859 ÷ 31,119 = 4.75

Area activity ratio Geographic area The company
Area asset turnover U.S. U.S. area asset turnover ratio improved from 2020 to 2021 and from 2021 to 2022.

Area Asset Turnover: China (includes Hong Kong and Taiwan)

Apple Inc.; China (includes Hong Kong and Taiwan); area asset turnover calculation

Microsoft Excel
Sep 24, 2022 Sep 25, 2021 Sep 26, 2020 Sep 28, 2019 Sep 29, 2018 Sep 30, 2017
Selected Financial Data (US$ in millions)
Net sales 74,200 68,366 40,308 43,678 51,942 44,764
Long-lived assets 7,260 7,521 7,256 9,064 13,268 10,211
Area Activity Ratio
Area asset turnover1 10.22 9.09 5.56 4.82 3.91 4.38

Based on: 10-K (reporting date: 2022-09-24), 10-K (reporting date: 2021-09-25), 10-K (reporting date: 2020-09-26), 10-K (reporting date: 2019-09-28), 10-K (reporting date: 2018-09-29), 10-K (reporting date: 2017-09-30).

1 2022 Calculation
Area asset turnover = Net sales ÷ Long-lived assets
= 74,200 ÷ 7,260 = 10.22

Area activity ratio Geographic area The company
Area asset turnover China (includes Hong Kong and Taiwan) China (includes Hong Kong and Taiwan) area asset turnover ratio improved from 2020 to 2021 and from 2021 to 2022.

Area Asset Turnover: Other countries

Apple Inc.; Other countries; area asset turnover calculation

Microsoft Excel
Sep 24, 2022 Sep 25, 2021 Sep 26, 2020 Sep 28, 2019 Sep 29, 2018 Sep 30, 2017
Selected Financial Data (US$ in millions)
Net sales 172,269 163,648 125,010 114,230 115,592 100,131
Long-lived assets 3,738 3,716 3,620 3,603 4,073 2,935
Area Activity Ratio
Area asset turnover1 46.09 44.04 34.53 31.70 28.38 34.12

Based on: 10-K (reporting date: 2022-09-24), 10-K (reporting date: 2021-09-25), 10-K (reporting date: 2020-09-26), 10-K (reporting date: 2019-09-28), 10-K (reporting date: 2018-09-29), 10-K (reporting date: 2017-09-30).

1 2022 Calculation
Area asset turnover = Net sales ÷ Long-lived assets
= 172,269 ÷ 3,738 = 46.09

Area activity ratio Geographic area The company
Area asset turnover Other countries Other countries area asset turnover ratio improved from 2020 to 2021 and from 2021 to 2022.

Net sales

Apple Inc., net sales by geographic area

US$ in millions

Microsoft Excel
Sep 24, 2022 Sep 25, 2021 Sep 26, 2020 Sep 28, 2019 Sep 29, 2018 Sep 30, 2017
U.S. 147,859 133,803 109,197 102,266 98,061 84,339
China (includes Hong Kong and Taiwan) 74,200 68,366 40,308 43,678 51,942 44,764
Other countries 172,269 163,648 125,010 114,230 115,592 100,131
Total 394,328 365,817 274,515 260,174 265,595 229,234

Based on: 10-K (reporting date: 2022-09-24), 10-K (reporting date: 2021-09-25), 10-K (reporting date: 2020-09-26), 10-K (reporting date: 2019-09-28), 10-K (reporting date: 2018-09-29), 10-K (reporting date: 2017-09-30).


Long-lived assets

Apple Inc., long-lived assets by geographic area

US$ in millions

Microsoft Excel
Sep 24, 2022 Sep 25, 2021 Sep 26, 2020 Sep 28, 2019 Sep 29, 2018 Sep 30, 2017
U.S. 31,119 28,203 25,890 24,711 23,963 20,637
China (includes Hong Kong and Taiwan) 7,260 7,521 7,256 9,064 13,268 10,211
Other countries 3,738 3,716 3,620 3,603 4,073 2,935
Total 42,117 39,440 36,766 37,378 41,304 33,783

Based on: 10-K (reporting date: 2022-09-24), 10-K (reporting date: 2021-09-25), 10-K (reporting date: 2020-09-26), 10-K (reporting date: 2019-09-28), 10-K (reporting date: 2018-09-29), 10-K (reporting date: 2017-09-30).