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 25, 2021 Sep 26, 2020 Sep 28, 2019 Sep 29, 2018 Sep 30, 2017 Sep 24, 2016
U.S. 4.74 4.22 4.14 4.09 4.09 4.62
China (includes Hong Kong and Taiwan) 9.09 5.56 4.82 3.91 4.38 5.94
Other countries 44.04 34.53 31.70 28.38 34.12 32.98

Based on: 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), 10-K (reporting date: 2016-09-24).

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

Area Asset Turnover: U.S.

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

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

Based on: 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), 10-K (reporting date: 2016-09-24).

1 2021 Calculation
Area asset turnover = Net sales ÷ Long-lived assets
= 133,803 ÷ 28,203 = 4.74

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

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

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

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

Based on: 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), 10-K (reporting date: 2016-09-24).

1 2021 Calculation
Area asset turnover = Net sales ÷ Long-lived assets
= 68,366 ÷ 7,521 = 9.09

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 2019 to 2020 and from 2020 to 2021.

Area Asset Turnover: Other countries

Apple Inc.; Other countries; area asset turnover calculation

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

Based on: 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), 10-K (reporting date: 2016-09-24).

1 2021 Calculation
Area asset turnover = Net sales ÷ Long-lived assets
= 163,648 ÷ 3,716 = 44.04

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

Net sales

Apple Inc., net sales by geographic area

US$ in millions

Microsoft Excel
Sep 25, 2021 Sep 26, 2020 Sep 28, 2019 Sep 29, 2018 Sep 30, 2017 Sep 24, 2016
U.S. 133,803  109,197  102,266  98,061  84,339  75,667 
China (includes Hong Kong and Taiwan) 68,366  40,308  43,678  51,942  44,764  46,349 
Other countries 163,648  125,010  114,230  115,592  100,131  93,623 
Total 365,817  274,515  260,174  265,595  229,234  215,639 

Based on: 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), 10-K (reporting date: 2016-09-24).


Long-lived assets

Apple Inc., long-lived assets by geographic area

US$ in millions

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

Based on: 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), 10-K (reporting date: 2016-09-24).