Stock Analysis on Net
Stock Analysis on Net

Analog Devices Inc. (NASDAQ:ADI)

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

Beginner level

Long-term Activity Ratios (Summary)

Analog Devices Inc., long-term (investment) activity ratios (quarterly data)

Microsoft Excel LibreOffice Calc
Oct 31, 2020 Aug 1, 2020 May 2, 2020 Feb 1, 2020 Nov 2, 2019 Aug 3, 2019 May 4, 2019 Feb 2, 2019 Nov 3, 2018 Aug 4, 2018 May 5, 2018 Feb 3, 2018 Oct 28, 2017 Jul 29, 2017 Apr 29, 2017 Jan 28, 2017 Oct 29, 2016 Jul 30, 2016 Apr 30, 2016 Jan 30, 2016 Oct 31, 2015 Aug 1, 2015 May 2, 2015 Jan 31, 2015
Net fixed asset turnover 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 5.33
Total asset turnover 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 0.49
Equity turnover 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 0.68

Based on: 10-K (filing date: 2020-11-24), 10-Q (filing date: 2020-08-19), 10-Q (filing date: 2020-05-20), 10-Q (filing date: 2020-02-19), 10-K (filing date: 2019-11-26), 10-Q (filing date: 2019-08-21), 10-Q (filing date: 2019-05-22), 10-Q (filing date: 2019-02-20), 10-K (filing date: 2018-11-27), 10-Q (filing date: 2018-08-22), 10-Q (filing date: 2018-05-30), 10-Q (filing date: 2018-02-28), 10-K (filing date: 2017-11-22), 10-Q (filing date: 2017-08-30), 10-Q (filing date: 2017-05-31), 10-Q (filing date: 2017-02-15), 10-K (filing date: 2016-11-22), 10-Q (filing date: 2016-08-17), 10-Q (filing date: 2016-05-18), 10-Q (filing date: 2016-02-17), 10-K (filing date: 2015-11-24), 10-Q (filing date: 2015-08-18), 10-Q (filing date: 2015-05-19), 10-Q (filing date: 2015-02-17).

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

Net Fixed Asset Turnover

Analog Devices Inc., net fixed asset turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Oct 31, 2020 Aug 1, 2020 May 2, 2020 Feb 1, 2020 Nov 2, 2019 Aug 3, 2019 May 4, 2019 Feb 2, 2019 Nov 3, 2018 Aug 4, 2018 May 5, 2018 Feb 3, 2018 Oct 28, 2017 Jul 29, 2017 Apr 29, 2017 Jan 28, 2017 Oct 29, 2016 Jul 30, 2016 Apr 30, 2016 Jan 30, 2016 Oct 31, 2015 Aug 1, 2015 May 2, 2015 Jan 31, 2015
Selected Financial Data (US$ in thousands)
Revenue 1,526,295  1,456,136  1,317,060  1,303,565  1,443,219  1,480,143  1,526,602  1,541,101  1,596,586  1,572,679  1,513,053  1,518,624  1,541,170  1,433,902  1,147,982  984,449  1,003,623  869,591  778,766  769,429  978,722  863,365  821,019  771,986 
Net property, plant and equipment 1,120,561  1,134,236  1,189,332  1,206,769  1,219,989  1,221,192  1,211,467  1,181,735  1,154,328  1,107,991  1,114,579  1,115,417  1,107,304  1,098,848  1,089,319  628,924  636,116  629,094  626,162  633,362  644,110  631,269  629,665  612,472 
Long-term Activity Ratio
Net fixed asset turnover1 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 5.33
Benchmarks
Net Fixed Asset Turnover, Competitors2
Advanced Micro Devices Inc. 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 25.61 22.95 21.55 21.23
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 10.40
Applied Materials Inc. 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 10.83 10.83 10.52 10.70
Broadcom Inc. 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 4.67 4.72 4.54 4.09
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 14.75
Intel Corp. 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 1.67 1.67 1.72 1.74
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 8.46
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 1.53
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 8.40
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 9.98
Texas Instruments Inc. 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 5.17 5.04 5.03 5.01

Based on: 10-K (filing date: 2020-11-24), 10-Q (filing date: 2020-08-19), 10-Q (filing date: 2020-05-20), 10-Q (filing date: 2020-02-19), 10-K (filing date: 2019-11-26), 10-Q (filing date: 2019-08-21), 10-Q (filing date: 2019-05-22), 10-Q (filing date: 2019-02-20), 10-K (filing date: 2018-11-27), 10-Q (filing date: 2018-08-22), 10-Q (filing date: 2018-05-30), 10-Q (filing date: 2018-02-28), 10-K (filing date: 2017-11-22), 10-Q (filing date: 2017-08-30), 10-Q (filing date: 2017-05-31), 10-Q (filing date: 2017-02-15), 10-K (filing date: 2016-11-22), 10-Q (filing date: 2016-08-17), 10-Q (filing date: 2016-05-18), 10-Q (filing date: 2016-02-17), 10-K (filing date: 2015-11-24), 10-Q (filing date: 2015-08-18), 10-Q (filing date: 2015-05-19), 10-Q (filing date: 2015-02-17).

1 Q4 2020 Calculation
Net fixed asset turnover = (RevenueQ4 2020 + RevenueQ3 2020 + RevenueQ2 2020 + RevenueQ1 2020) ÷ Net property, plant and equipment
= (1,526,295 + 1,456,136 + 1,317,060 + 1,303,565) ÷ 1,120,561 = 5.00

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. Analog Devices Inc.’s net fixed asset turnover ratio improved from Q2 2020 to Q3 2020 and from Q3 2020 to Q4 2020.

Total Asset Turnover

Analog Devices Inc., total asset turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Oct 31, 2020 Aug 1, 2020 May 2, 2020 Feb 1, 2020 Nov 2, 2019 Aug 3, 2019 May 4, 2019 Feb 2, 2019 Nov 3, 2018 Aug 4, 2018 May 5, 2018 Feb 3, 2018 Oct 28, 2017 Jul 29, 2017 Apr 29, 2017 Jan 28, 2017 Oct 29, 2016 Jul 30, 2016 Apr 30, 2016 Jan 30, 2016 Oct 31, 2015 Aug 1, 2015 May 2, 2015 Jan 31, 2015
Selected Financial Data (US$ in thousands)
Revenue 1,526,295  1,456,136  1,317,060  1,303,565  1,443,219  1,480,143  1,526,602  1,541,101  1,596,586  1,572,679  1,513,053  1,518,624  1,541,170  1,433,902  1,147,982  984,449  1,003,623  869,591  778,766  769,429  978,722  863,365  821,019  771,986 
Total assets 21,468,603  21,599,568  21,350,938  21,376,827  21,392,641  21,566,650  21,776,325  21,828,278  20,449,779  20,548,616  20,776,454  20,853,315  21,141,294  21,114,995  26,622,683  10,203,371  7,970,278  7,685,053  7,570,292  7,598,081  7,062,178  7,134,701  7,048,475  6,821,156 
Long-term Activity Ratio
Total asset turnover1 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 0.49
Benchmarks
Total Asset Turnover, Competitors2
Advanced Micro Devices Inc. 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 1.14 1.17 1.27 1.28
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 0.80
Applied Materials Inc. 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 0.63 0.73 0.69 0.71
Broadcom Inc. 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 0.64 0.66 0.58 0.49
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 0.43
Intel Corp. 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 0.52 0.52 0.53 0.54
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 0.56
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 0.67
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 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 0.50
Texas Instruments Inc. 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 0.81 0.82 0.82 0.80

Based on: 10-K (filing date: 2020-11-24), 10-Q (filing date: 2020-08-19), 10-Q (filing date: 2020-05-20), 10-Q (filing date: 2020-02-19), 10-K (filing date: 2019-11-26), 10-Q (filing date: 2019-08-21), 10-Q (filing date: 2019-05-22), 10-Q (filing date: 2019-02-20), 10-K (filing date: 2018-11-27), 10-Q (filing date: 2018-08-22), 10-Q (filing date: 2018-05-30), 10-Q (filing date: 2018-02-28), 10-K (filing date: 2017-11-22), 10-Q (filing date: 2017-08-30), 10-Q (filing date: 2017-05-31), 10-Q (filing date: 2017-02-15), 10-K (filing date: 2016-11-22), 10-Q (filing date: 2016-08-17), 10-Q (filing date: 2016-05-18), 10-Q (filing date: 2016-02-17), 10-K (filing date: 2015-11-24), 10-Q (filing date: 2015-08-18), 10-Q (filing date: 2015-05-19), 10-Q (filing date: 2015-02-17).

1 Q4 2020 Calculation
Total asset turnover = (RevenueQ4 2020 + RevenueQ3 2020 + RevenueQ2 2020 + RevenueQ1 2020) ÷ Total assets
= (1,526,295 + 1,456,136 + 1,317,060 + 1,303,565) ÷ 21,468,603 = 0.26

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. Analog Devices Inc.’s total asset turnover ratio deteriorated from Q2 2020 to Q3 2020 but then improved from Q3 2020 to Q4 2020 exceeding Q2 2020 level.

Equity Turnover

Analog Devices Inc., equity turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Oct 31, 2020 Aug 1, 2020 May 2, 2020 Feb 1, 2020 Nov 2, 2019 Aug 3, 2019 May 4, 2019 Feb 2, 2019 Nov 3, 2018 Aug 4, 2018 May 5, 2018 Feb 3, 2018 Oct 28, 2017 Jul 29, 2017 Apr 29, 2017 Jan 28, 2017 Oct 29, 2016 Jul 30, 2016 Apr 30, 2016 Jan 30, 2016 Oct 31, 2015 Aug 1, 2015 May 2, 2015 Jan 31, 2015
Selected Financial Data (US$ in thousands)
Revenue 1,526,295  1,456,136  1,317,060  1,303,565  1,443,219  1,480,143  1,526,602  1,541,101  1,596,586  1,572,679  1,513,053  1,518,624  1,541,170  1,433,902  1,147,982  984,449  1,003,623  869,591  778,766  769,429  978,722  863,365  821,019  771,986 
Shareholders’ equity 11,997,945  11,777,560  11,590,858  11,689,517  11,709,188  11,790,237  11,742,258  11,585,437  10,988,540  10,856,217  10,585,355  10,347,779  10,161,540  9,922,900  9,966,595  5,306,431  5,165,618  4,983,333  4,873,701  4,994,862  5,072,959  5,065,161  4,964,208  4,806,210 
Long-term Activity Ratio
Equity turnover1 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 0.68
Benchmarks
Equity Turnover, Competitors2
Advanced Micro Devices Inc. 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 10.71
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 1.96
Applied Materials Inc. 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 1.27 1.20 1.12 1.14
Broadcom Inc. 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 1.45 1.54 1.50 1.43
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 0.82
Intel Corp. 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 0.92 0.92 0.92 0.91
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 1.03
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 1.32
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 1.06
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 0.80
Texas Instruments Inc. 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 1.28 1.29 1.31 1.31

Based on: 10-K (filing date: 2020-11-24), 10-Q (filing date: 2020-08-19), 10-Q (filing date: 2020-05-20), 10-Q (filing date: 2020-02-19), 10-K (filing date: 2019-11-26), 10-Q (filing date: 2019-08-21), 10-Q (filing date: 2019-05-22), 10-Q (filing date: 2019-02-20), 10-K (filing date: 2018-11-27), 10-Q (filing date: 2018-08-22), 10-Q (filing date: 2018-05-30), 10-Q (filing date: 2018-02-28), 10-K (filing date: 2017-11-22), 10-Q (filing date: 2017-08-30), 10-Q (filing date: 2017-05-31), 10-Q (filing date: 2017-02-15), 10-K (filing date: 2016-11-22), 10-Q (filing date: 2016-08-17), 10-Q (filing date: 2016-05-18), 10-Q (filing date: 2016-02-17), 10-K (filing date: 2015-11-24), 10-Q (filing date: 2015-08-18), 10-Q (filing date: 2015-05-19), 10-Q (filing date: 2015-02-17).

1 Q4 2020 Calculation
Equity turnover = (RevenueQ4 2020 + RevenueQ3 2020 + RevenueQ2 2020 + RevenueQ1 2020) ÷ Shareholders’ equity
= (1,526,295 + 1,456,136 + 1,317,060 + 1,303,565) ÷ 11,997,945 = 0.47

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. Analog Devices Inc.’s equity turnover ratio deteriorated from Q2 2020 to Q3 2020 and from Q3 2020 to Q4 2020.