Stock Analysis on Net
Stock Analysis on Net

Intel Corp. (NASDAQ:INTC)

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

Beginner level

Long-term Activity Ratios (Summary)

Intel Corp., long-term (investment) activity ratios (quarterly data)

Microsoft Excel LibreOffice Calc
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 Sep 30, 2017 Jul 1, 2017 Apr 1, 2017 Dec 31, 2016 Oct 1, 2016 Jul 2, 2016 Apr 2, 2016
Net fixed asset turnover 1.38 1.32 1.36 1.33 1.30 1.31 1.37 1.42 1.45 1.47 1.44 1.46 1.53 1.57 1.62 1.64 1.64
Total asset turnover 0.51 0.54 0.52 0.51 0.53 0.53 0.54 0.55 0.55 0.54 0.53 0.50 0.51 0.49 0.51 0.52 0.52
Equity turnover 0.96 1.05 0.96 0.99 0.93 0.95 0.94 0.96 0.95 0.97 0.95 0.91 0.91 0.88 0.90 0.90 0.90

Based on: 10-K (filing date: 2021-01-22), 10-Q (filing date: 2020-10-23), 10-Q (filing date: 2020-07-24), 10-Q (filing date: 2020-04-24), 10-K (filing date: 2020-01-24), 10-Q (filing date: 2019-10-25), 10-Q (filing date: 2019-07-26), 10-Q (filing date: 2019-04-26), 10-K (filing date: 2019-02-01), 10-Q (filing date: 2018-10-26), 10-Q (filing date: 2018-07-27), 10-Q (filing date: 2018-04-27), 10-K (filing date: 2018-02-16), 10-Q (filing date: 2017-10-26), 10-Q (filing date: 2017-07-27), 10-Q (filing date: 2017-04-27), 10-K (filing date: 2017-02-17), 10-Q (filing date: 2016-10-31), 10-Q (filing date: 2016-08-01), 10-Q (filing date: 2016-05-02).

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Intel Corp.’s net fixed asset turnover ratio deteriorated from Q2 2020 to Q3 2020 but then improved from Q3 2020 to Q4 2020 exceeding Q2 2020 level.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Intel Corp.’s total asset turnover ratio improved from Q2 2020 to Q3 2020 but then deteriorated significantly from Q3 2020 to Q4 2020.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Intel Corp.’s equity turnover ratio improved from Q2 2020 to Q3 2020 but then deteriorated significantly from Q3 2020 to Q4 2020.

Net Fixed Asset Turnover

Intel Corp., net fixed asset turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Sep 30, 2017 Jul 1, 2017 Apr 1, 2017 Dec 31, 2016 Oct 1, 2016 Jul 2, 2016 Apr 2, 2016
Selected Financial Data (US$ in millions)
Net revenue 19,978  18,333  19,728  19,828  20,209  19,190  16,505  16,061  18,657  19,163  16,962  16,066  17,053  16,149  14,763  14,796  16,374  15,778  13,533  13,702 
Property, plant and equipment, net of accumulated depreciation 56,584  59,205  58,036  56,770  55,386  53,563  51,377  50,040  48,976  47,071  45,914  43,735  41,109  39,472  38,130  36,911  36,171  34,707  33,804  32,644 
Long-term Activity Ratio
Net fixed asset turnover1 1.38 1.32 1.36 1.33 1.30 1.31 1.37 1.42 1.45 1.47 1.44 1.46 1.53 1.57 1.62 1.64 1.64
Benchmarks
Net Fixed Asset Turnover, Competitors2
Advanced Micro Devices Inc. 15.23 14.53 13.07 13.42 13.46 13.30 12.83 16.18 18.61 20.55 22.12 20.66 20.42 21.00 23.10 24.58 26.05
Analog Devices Inc. 5.00 4.87 4.66 4.77 4.91 5.03 5.15 5.27 5.37 5.55 5.39 5.06 4.61 4.16 3.68 5.78 5.38 5.40 5.41 5.42
Apple Inc. 7.47 7.67 7.47 7.23 6.96 6.88 6.67 6.61 6.43 6.70 7.05 7.10 6.79 7.63 8.12 8.23 7.98 8.66 9.81 10.54
Applied Materials Inc. 10.72 10.63 10.06 9.66 9.55 9.83 10.56 11.54 12.26 13.03 13.11 12.94 13.64 13.92 13.36 12.48 11.55 10.93 10.58 10.53
Broadcom Inc. 9.52 9.04 8.74 8.66 8.81 8.53 8.22 7.94 7.91 7.51 7.22 6.85 6.79 5.82 5.89 5.90 5.28 4.25 3.57 4.62
Cisco Systems Inc. 20.10 19.95 19.67 19.48 18.61 18.11 17.34 17.00 16.41 15.78 15.45 14.92 14.45 14.29 14.19 13.98 14.05 14.01 14.65 14.82
Lam Research Corp. 9.37 9.17 9.12 9.21 9.12 10.01 10.73 11.49 12.27 12.46 11.84 11.88 11.69 10.68 9.48 9.11 9.20 8.76 9.17 8.96
Micron Technology Inc. 0.69 0.67 0.66 0.70 0.83 0.99 1.14 1.27 1.28 1.24 1.18 1.12 1.05 0.92 0.77 0.85 0.84 0.97 1.16 1.35
NVIDIA Corp. 6.52 6.60 6.86 7.28 8.34 9.61 10.22 10.30 9.74 14.96 14.44 13.99 13.26 12.20 11.21 10.78 10.75 10.19 9.62 8.65
Qualcomm Inc. 6.34 5.74 7.37 7.73 7.88 8.32 7.21 7.33 7.64 7.43 7.01 6.94 6.93 7.13 7.58 10.47 10.21 9.75 9.46 9.64
Texas Instruments Inc. 4.42 4.31 4.28 4.37 4.35 4.45 4.53 4.70 4.96 5.18 5.49 5.61 5.62 5.70 5.64 5.50 5.32

Based on: 10-K (filing date: 2021-01-22), 10-Q (filing date: 2020-10-23), 10-Q (filing date: 2020-07-24), 10-Q (filing date: 2020-04-24), 10-K (filing date: 2020-01-24), 10-Q (filing date: 2019-10-25), 10-Q (filing date: 2019-07-26), 10-Q (filing date: 2019-04-26), 10-K (filing date: 2019-02-01), 10-Q (filing date: 2018-10-26), 10-Q (filing date: 2018-07-27), 10-Q (filing date: 2018-04-27), 10-K (filing date: 2018-02-16), 10-Q (filing date: 2017-10-26), 10-Q (filing date: 2017-07-27), 10-Q (filing date: 2017-04-27), 10-K (filing date: 2017-02-17), 10-Q (filing date: 2016-10-31), 10-Q (filing date: 2016-08-01), 10-Q (filing date: 2016-05-02).

1 Q4 2020 Calculation
Net fixed asset turnover = (Net revenueQ4 2020 + Net revenueQ3 2020 + Net revenueQ2 2020 + Net revenueQ1 2020) ÷ Property, plant and equipment, net of accumulated depreciation
= (19,978 + 18,333 + 19,728 + 19,828) ÷ 56,584 = 1.38

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. Intel Corp.’s net fixed asset turnover ratio deteriorated from Q2 2020 to Q3 2020 but then improved from Q3 2020 to Q4 2020 exceeding Q2 2020 level.

Total Asset Turnover

Intel Corp., total asset turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Sep 30, 2017 Jul 1, 2017 Apr 1, 2017 Dec 31, 2016 Oct 1, 2016 Jul 2, 2016 Apr 2, 2016
Selected Financial Data (US$ in millions)
Net revenue 19,978  18,333  19,728  19,828  20,209  19,190  16,505  16,061  18,657  19,163  16,962  16,066  17,053  16,149  14,763  14,796  16,374  15,778  13,533  13,702 
Total assets 153,091  145,261  152,539  147,710  136,524  133,768  130,759  129,458  127,963  128,242  125,972  128,596  123,249  127,088  122,107  115,648  113,327  112,217  109,831  105,467 
Long-term Activity Ratio
Total asset turnover1 0.51 0.54 0.52 0.51 0.53 0.53 0.54 0.55 0.55 0.54 0.53 0.50 0.51 0.49 0.51 0.52 0.52
Benchmarks
Total Asset Turnover, Competitors2
Advanced Micro Devices Inc. 1.09 1.23 1.16 1.24 1.12 1.15 1.15 1.24 1.42 1.50 1.59 1.59 1.51 1.38 1.37 1.34 1.29
Analog Devices Inc. 0.26 0.26 0.26 0.27 0.28 0.28 0.29 0.29 0.30 0.30 0.29 0.27 0.24 0.22 0.15 0.36 0.43 0.44 0.45 0.45
Apple Inc. 0.85 0.86 0.84 0.79 0.77 0.80 0.76 0.70 0.73 0.73 0.67 0.59 0.61 0.65 0.66 0.66 0.67 0.72 0.75 0.80
Applied Materials Inc. 0.77 0.77 0.71 0.76 0.77 0.79 0.84 0.89 0.97 0.96 0.89 0.79 0.75 0.73 0.71 0.78 0.74 0.72 0.73 0.72
Broadcom Inc. 0.31 0.29 0.28 0.28 0.33 0.32 0.31 0.30 0.42 0.40 0.36 0.35 0.32 0.34 0.33 0.31 0.26 0.22 0.17 0.65
Cisco Systems Inc. 0.52 0.55 0.57 0.56 0.53 0.53 0.50 0.48 0.45 0.43 0.37 0.37 0.37 0.39 0.38 0.39 0.40 0.42 0.44 0.44
Lam Research Corp. 0.69 0.74 0.80 0.77 0.80 0.81 1.01 1.00 0.89 0.75 0.74 0.71 0.66 0.61 0.55 0.47 0.48 0.58 0.61 0.59
Micron Technology Inc. 0.40 0.39 0.39 0.42 0.48 0.58 0.63 0.71 0.70 0.67 0.63 0.62 0.58 0.52 0.46 0.47 0.45 0.47 0.55 0.61
NVIDIA Corp. 0.63 0.63 0.69 0.77 0.88 0.91 0.92 0.96 0.86 0.91 0.89 0.80 0.70 0.64 0.73 0.73 0.68 0.68 0.68 0.65
Qualcomm Inc. 0.66 0.62 0.77 0.74 0.74 0.74 0.62 0.63 0.70 0.37 0.35 0.35 0.34 0.35 0.41 0.45 0.45 0.45 0.45 0.48
Texas Instruments Inc. 0.75 0.75 0.78 0.82 0.80 0.82 0.88 0.89 0.92 0.85 0.85 0.88 0.85 0.86 0.86 0.86 0.81

Based on: 10-K (filing date: 2021-01-22), 10-Q (filing date: 2020-10-23), 10-Q (filing date: 2020-07-24), 10-Q (filing date: 2020-04-24), 10-K (filing date: 2020-01-24), 10-Q (filing date: 2019-10-25), 10-Q (filing date: 2019-07-26), 10-Q (filing date: 2019-04-26), 10-K (filing date: 2019-02-01), 10-Q (filing date: 2018-10-26), 10-Q (filing date: 2018-07-27), 10-Q (filing date: 2018-04-27), 10-K (filing date: 2018-02-16), 10-Q (filing date: 2017-10-26), 10-Q (filing date: 2017-07-27), 10-Q (filing date: 2017-04-27), 10-K (filing date: 2017-02-17), 10-Q (filing date: 2016-10-31), 10-Q (filing date: 2016-08-01), 10-Q (filing date: 2016-05-02).

1 Q4 2020 Calculation
Total asset turnover = (Net revenueQ4 2020 + Net revenueQ3 2020 + Net revenueQ2 2020 + Net revenueQ1 2020) ÷ Total assets
= (19,978 + 18,333 + 19,728 + 19,828) ÷ 153,091 = 0.51

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. Intel Corp.’s total asset turnover ratio improved from Q2 2020 to Q3 2020 but then deteriorated significantly from Q3 2020 to Q4 2020.

Equity Turnover

Intel Corp., equity turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Sep 30, 2017 Jul 1, 2017 Apr 1, 2017 Dec 31, 2016 Oct 1, 2016 Jul 2, 2016 Apr 2, 2016
Selected Financial Data (US$ in millions)
Net revenue 19,978  18,333  19,728  19,828  20,209  19,190  16,505  16,061  18,657  19,163  16,962  16,066  17,053  16,149  14,763  14,796  16,374  15,778  13,533  13,702 
Stockholders’ equity 81,038  74,554  82,010  76,354  77,504  74,242  74,947  73,661  74,563  71,483  70,047  70,165  69,019  70,936  68,625  66,844  66,226  63,115  61,367  61,174 
Long-term Activity Ratio
Equity turnover1 0.96 1.05 0.96 0.99 0.93 0.95 0.94 0.96 0.95 0.97 0.95 0.91 0.91 0.88 0.90 0.90 0.90
Benchmarks
Equity Turnover, Competitors2
Advanced Micro Devices Inc. 1.67 2.24 2.31 2.39 2.38 2.77 3.09 3.41 5.11 5.81 7.42 8.38 8.72 9.53 11.08 10.82 10.27
Analog Devices Inc. 0.47 0.47 0.48 0.49 0.51 0.52 0.53 0.54 0.56 0.57 0.57 0.55 0.50 0.46 0.40 0.69 0.66 0.68 0.70 0.69
Apple Inc. 4.20 3.79 3.42 2.99 2.88 2.69 2.44 2.22 2.48 2.22 1.95 1.71 1.71 1.69 1.64 1.65 1.68 1.74 1.74 1.83
Applied Materials Inc. 1.63 1.70 1.71 1.73 1.78 1.83 1.92 2.05 2.52 2.52 2.34 1.82 1.55 1.59 1.58 1.54 1.50 1.45 1.46 1.33
Broadcom Inc. 1.00 0.98 0.96 0.93 0.91 1.04 0.98 0.92 0.78 0.74 0.61 0.73 0.87 0.85 0.84 0.82 0.70 0.56 0.45 1.36
Cisco Systems Inc. 1.30 1.42 1.45 1.51 1.55 1.39 1.25 1.15 1.14 1.04 0.93 0.73 0.73 0.74 0.76 0.77 0.77 0.79 0.81 0.83
Lam Research Corp. 1.94 2.12 2.18 1.92 2.07 1.97 1.88 2.05 1.70 1.51 1.56 1.22 1.18 1.07 1.00 0.96 1.00 1.02 1.06 1.07
Micron Technology Inc. 0.55 0.54 0.53 0.57 0.65 0.76 0.87 0.93 0.94 0.98 1.01 1.03 1.09 1.08 1.03 1.06 1.03 1.05 1.12 1.22
NVIDIA Corp. 0.89 0.89 0.99 1.11 1.25 1.31 1.35 1.42 1.30 1.41 1.40 1.23 1.20 1.15 1.21 1.23 1.12 1.09 1.14 1.04
Qualcomm Inc. 3.87 6.05 8.13 5.43 4.94 4.62 5.49 5.95 24.50 0.99 0.95 0.93 0.73 0.72 0.74 0.76 0.74 0.74 0.76 0.79
Texas Instruments Inc. 1.57 1.65 1.79 1.83 1.61 1.64 1.80 1.83 1.75 1.50 1.47 1.44 1.45 1.33 1.32 1.29 1.28

Based on: 10-K (filing date: 2021-01-22), 10-Q (filing date: 2020-10-23), 10-Q (filing date: 2020-07-24), 10-Q (filing date: 2020-04-24), 10-K (filing date: 2020-01-24), 10-Q (filing date: 2019-10-25), 10-Q (filing date: 2019-07-26), 10-Q (filing date: 2019-04-26), 10-K (filing date: 2019-02-01), 10-Q (filing date: 2018-10-26), 10-Q (filing date: 2018-07-27), 10-Q (filing date: 2018-04-27), 10-K (filing date: 2018-02-16), 10-Q (filing date: 2017-10-26), 10-Q (filing date: 2017-07-27), 10-Q (filing date: 2017-04-27), 10-K (filing date: 2017-02-17), 10-Q (filing date: 2016-10-31), 10-Q (filing date: 2016-08-01), 10-Q (filing date: 2016-05-02).

1 Q4 2020 Calculation
Equity turnover = (Net revenueQ4 2020 + Net revenueQ3 2020 + Net revenueQ2 2020 + Net revenueQ1 2020) ÷ Stockholders’ equity
= (19,978 + 18,333 + 19,728 + 19,828) ÷ 81,038 = 0.96

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. Intel Corp.’s equity turnover ratio improved from Q2 2020 to Q3 2020 but then deteriorated significantly from Q3 2020 to Q4 2020.