Microsoft Excel LibreOffice Calc

Intel Corp. (NASDAQ:INTC)

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

Beginner level

Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.

Long-term Activity Ratios (Summary)

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

Microsoft Excel LibreOffice Calc
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 Dec 26, 2015 Sep 26, 2015 Jun 27, 2015 Mar 28, 2015
Net fixed asset turnover 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 1.67 1.67 1.72 1.74 — — —
Total asset turnover 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 0.52 0.52 0.53 0.54 — — —
Equity turnover 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 0.92 0.92 0.92 0.91 — — —

Based on: 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), 10-K (filing date: 2016-02-12), 10-Q (filing date: 2015-10-28), 10-Q (filing date: 2015-07-27), 10-Q (filing date: 2015-04-27).

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 2019 to Q3 2019 and from Q3 2019 to Q4 2019.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Intel Corp.’s total asset turnover ratio deteriorated from Q2 2019 to Q3 2019 but then slightly improved from Q3 2019 to Q4 2019.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Intel Corp.’s equity turnover ratio improved from Q2 2019 to Q3 2019 but then deteriorated significantly from Q3 2019 to Q4 2019.

Net Fixed Asset Turnover

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

Microsoft Excel LibreOffice Calc
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 Dec 26, 2015 Sep 26, 2015 Jun 27, 2015 Mar 28, 2015
Selected Financial Data (US$ in millions)
Net revenue 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  14,914  14,465  13,195  12,781 
Property, plant and equipment, net of accumulated depreciation 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  31,858  31,597  32,683  33,296 
Long-term Activity Ratio
Net fixed asset turnover1 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 1.67 1.67 1.72 1.74 — — —
Benchmarks
Net Fixed Asset Turnover, Competitors2
Advanced Micro Devices Inc. 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 25.61 22.95 21.55 21.23 — — —
Apple Inc. 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 10.40 10.61 10.53 9.80
Applied Materials Inc. 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 10.83 10.83 10.52 10.70
Broadcom Inc. 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 4.67 4.72 4.54 4.09
Cisco Systems Inc. 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 14.75 14.86 14.97 14.63
Micron Technology Inc. 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 1.53 1.71 1.84 1.85
NVIDIA Corp. 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 8.40 — — —
Qualcomm Inc. 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 9.98 10.30 10.90 10.65
Texas Instruments Inc. 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 5.17 5.04 5.03 5.01 — — —

Based on: 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), 10-K (filing date: 2016-02-12), 10-Q (filing date: 2015-10-28), 10-Q (filing date: 2015-07-27), 10-Q (filing date: 2015-04-27).

1 Q4 2019 Calculation
Net fixed asset turnover = (Net revenueQ4 2019 + Net revenueQ3 2019 + Net revenueQ2 2019 + Net revenueQ1 2019) ÷ Property, plant and equipment, net of accumulated depreciation
= (20,209 + 19,190 + 16,505 + 16,061) ÷ 55,386 = 1.30

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 2019 to Q3 2019 and from Q3 2019 to Q4 2019.

Total Asset Turnover

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

Microsoft Excel LibreOffice Calc
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 Dec 26, 2015 Sep 26, 2015 Jun 27, 2015 Mar 28, 2015
Selected Financial Data (US$ in millions)
Net revenue 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  14,914  14,465  13,195  12,781 
Total assets 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  103,065  98,552  90,492  89,566 
Long-term Activity Ratio
Total asset turnover1 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 0.52 0.52 0.53 0.54 — — —
Benchmarks
Total Asset Turnover, Competitors2
Advanced Micro Devices Inc. 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 1.14 1.17 1.27 1.28 — — —
Apple Inc. 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 0.80 0.82 0.81 0.76
Applied Materials Inc. 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 0.63 0.73 0.69 0.71
Broadcom Inc. 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 0.64 0.66 0.58 0.49
Cisco Systems Inc. 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 0.43 0.46 0.46 0.45
Micron Technology Inc. 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 0.67 0.67 0.71 0.75
NVIDIA Corp. 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 0.65 — — —
Qualcomm Inc. 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 0.50 0.51 0.58 0.56
Texas Instruments Inc. 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 0.81 0.82 0.82 0.80 — — —

Based on: 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), 10-K (filing date: 2016-02-12), 10-Q (filing date: 2015-10-28), 10-Q (filing date: 2015-07-27), 10-Q (filing date: 2015-04-27).

1 Q4 2019 Calculation
Total asset turnover = (Net revenueQ4 2019 + Net revenueQ3 2019 + Net revenueQ2 2019 + Net revenueQ1 2019) ÷ Total assets
= (20,209 + 19,190 + 16,505 + 16,061) ÷ 136,524 = 0.53

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 deteriorated from Q2 2019 to Q3 2019 but then slightly improved from Q3 2019 to Q4 2019.

Equity Turnover

Intel Corp., equity turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Dec 26, 2015 Sep 26, 2015 Jun 27, 2015 Mar 28, 2015
Selected Financial Data (US$ in millions)
Net revenue 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  14,914  14,465  13,195  12,781 
Stockholders’ equity 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  61,085  57,097  57,695  54,924 
Long-term Activity Ratio
Equity turnover1 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 0.92 0.92 0.92 0.91 — — —
Benchmarks
Equity Turnover, Competitors2
Advanced Micro Devices Inc. 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 10.71 — — — — — —
Apple Inc. 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 1.96 1.79 1.64 1.62
Applied Materials Inc. 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 1.27 1.20 1.12 1.14
Broadcom Inc. 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 1.45 1.54 1.50 1.43
Cisco Systems Inc. 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 0.82 0.83 0.83 0.83
Micron Technology Inc. 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 1.32 1.35 1.36 1.45
NVIDIA Corp. 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 1.06 — — —
Qualcomm Inc. 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 0.80 0.80 0.73 0.69
Texas Instruments Inc. 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 1.28 1.29 1.31 1.31 — — —

Based on: 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), 10-K (filing date: 2016-02-12), 10-Q (filing date: 2015-10-28), 10-Q (filing date: 2015-07-27), 10-Q (filing date: 2015-04-27).

1 Q4 2019 Calculation
Equity turnover = (Net revenueQ4 2019 + Net revenueQ3 2019 + Net revenueQ2 2019 + Net revenueQ1 2019) ÷ Stockholders’ equity
= (20,209 + 19,190 + 16,505 + 16,061) ÷ 77,504 = 0.93

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 2019 to Q3 2019 but then deteriorated significantly from Q3 2019 to Q4 2019.