Stock Analysis on Net

Broadcom Inc. (NASDAQ:AVGO)

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

Microsoft Excel

Long-term Activity Ratios (Summary)

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

Microsoft Excel
Feb 4, 2024 Oct 29, 2023 Jul 30, 2023 Apr 30, 2023 Jan 29, 2023 Oct 30, 2022 Jul 31, 2022 May 1, 2022 Jan 30, 2022 Oct 31, 2021 Aug 1, 2021 May 2, 2021 Jan 31, 2021 Nov 1, 2020 Aug 2, 2020 May 3, 2020 Feb 2, 2020 Nov 3, 2019 Aug 4, 2019 May 5, 2019 Feb 3, 2019 Nov 4, 2018 Aug 5, 2018 May 6, 2018 Feb 4, 2018
Net fixed asset turnover 14.60 16.63 16.26 15.86 15.63 14.94 14.08 13.26 12.38 11.69 11.19 10.58 9.89 9.52 9.04 8.74 8.66 8.81 8.53 8.22 7.94 7.91
Total asset turnover 0.22 0.49 0.50 0.49 0.47 0.45 0.44 0.42 0.39 0.36 0.35 0.34 0.32 0.31 0.29 0.28 0.28 0.33 0.32 0.31 0.30 0.42
Equity turnover 0.55 1.49 1.61 1.59 1.48 1.46 1.52 1.43 1.24 1.10 1.09 1.07 1.03 1.00 0.98 0.96 0.93 0.91 1.04 0.98 0.92 0.78

Based on: 10-Q (reporting date: 2024-02-04), 10-K (reporting date: 2023-10-29), 10-Q (reporting date: 2023-07-30), 10-Q (reporting date: 2023-04-30), 10-Q (reporting date: 2023-01-29), 10-K (reporting date: 2022-10-30), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-05-01), 10-Q (reporting date: 2022-01-30), 10-K (reporting date: 2021-10-31), 10-Q (reporting date: 2021-08-01), 10-Q (reporting date: 2021-05-02), 10-Q (reporting date: 2021-01-31), 10-K (reporting date: 2020-11-01), 10-Q (reporting date: 2020-08-02), 10-Q (reporting date: 2020-05-03), 10-Q (reporting date: 2020-02-02), 10-K (reporting date: 2019-11-03), 10-Q (reporting date: 2019-08-04), 10-Q (reporting date: 2019-05-05), 10-Q (reporting date: 2019-02-03), 10-K (reporting date: 2018-11-04), 10-Q (reporting date: 2018-08-05), 10-Q (reporting date: 2018-05-06), 10-Q (reporting date: 2018-02-04).

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Broadcom Inc. net fixed asset turnover ratio improved from Q3 2023 to Q4 2023 but then deteriorated significantly from Q4 2023 to Q1 2024.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Broadcom Inc. total asset turnover ratio deteriorated from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Broadcom Inc. equity turnover ratio deteriorated from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024.

Net Fixed Asset Turnover

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

Microsoft Excel
Feb 4, 2024 Oct 29, 2023 Jul 30, 2023 Apr 30, 2023 Jan 29, 2023 Oct 30, 2022 Jul 31, 2022 May 1, 2022 Jan 30, 2022 Oct 31, 2021 Aug 1, 2021 May 2, 2021 Jan 31, 2021 Nov 1, 2020 Aug 2, 2020 May 3, 2020 Feb 2, 2020 Nov 3, 2019 Aug 4, 2019 May 5, 2019 Feb 3, 2019 Nov 4, 2018 Aug 5, 2018 May 6, 2018 Feb 4, 2018
Selected Financial Data (US$ in millions)
Net revenue 11,961 9,295 8,876 8,733 8,915 8,930 8,464 8,103 7,706 7,407 6,778 6,610 6,655 6,467 5,821 5,742 5,858 5,776 5,515 5,517 5,789 5,444 5,063 5,014 5,327
Property, plant and equipment, net 2,662 2,154 2,180 2,209 2,201 2,223 2,250 2,262 2,303 2,348 2,370 2,416 2,496 2,509 2,567 2,618 2,616 2,565 2,611 2,654 2,684 2,635 2,695 2,720 2,747
Long-term Activity Ratio
Net fixed asset turnover1 14.60 16.63 16.26 15.86 15.63 14.94 14.08 13.26 12.38 11.69 11.19 10.58 9.89 9.52 9.04 8.74 8.66 8.81 8.53 8.22 7.94 7.91
Benchmarks
Net Fixed Asset Turnover, Competitors2
Advanced Micro Devices Inc. 14.27 14.12 14.20 15.38 15.60 15.36 14.97 13.43 23.41 20.71 19.88 16.77 15.23 14.53 13.07 13.42 13.46
Analog Devices Inc. 3.52 3.82 4.39 4.69 4.98 5.00 5.09 4.66 4.14 3.70 5.54 5.34 5.19 5.00 4.87 4.66 4.77 4.91 5.03 5.15 5.27 5.37
Applied Materials Inc. 9.37 9.74 10.19 10.41 10.53 11.18 11.47 11.99 12.25 11.93 11.92 11.21 11.11 10.72 10.63 10.06 9.66 9.55 9.83 10.56 11.54 12.26
Intel Corp. 0.56 0.57 0.59 0.66 0.78 0.92 1.02 1.16 1.25 1.31 1.33 1.36 1.38 1.32 1.36 1.33 1.30
KLA Corp. 9.59 10.17 10.80 10.87 10.79 10.84 10.69 11.39 10.68 10.44 10.27 10.22 10.56 11.17 11.26 10.77 10.29 10.18 10.64 14.05 14.29 14.10
Lam Research Corp. 7.50 9.39 10.16 10.22 10.47 10.46 10.72 10.99 11.48 11.22 10.37 9.87 9.75 9.37 9.17 9.12 9.21 9.12 10.01 10.73 11.49 12.27
Micron Technology Inc. 0.43 0.41 0.47 0.59 0.69 0.80 0.88 0.86 0.84 0.83 0.79 0.74 0.68 0.69 0.67 0.66 0.70 0.83 0.99 1.14 1.27 1.28
NVIDIA Corp. 6.92 7.09 7.57 9.20 10.13 9.69 9.67 9.26 8.49 7.76 7.18 6.65 6.87 6.52 6.60 6.86 7.28 8.34
ON Semiconductor Corp. 1.86 1.91 2.07 2.23 2.38 2.92 2.81 2.81 2.67 2.61 2.41 2.19 2.09 2.07 2.06 2.10 2.13
Qualcomm Inc. 7.40 7.10 7.40 7.78 8.24 8.55 8.36 8.02 7.63 7.36 7.36 7.03 6.62 6.34 5.74 7.37 7.73 7.88 8.32 7.21 7.33 7.64
Texas Instruments Inc. 1.75 1.94 2.21 2.54 2.91 3.11 3.30 3.49 3.57 4.37 4.56 4.49 4.42 4.31 4.28 4.37 4.35

Based on: 10-Q (reporting date: 2024-02-04), 10-K (reporting date: 2023-10-29), 10-Q (reporting date: 2023-07-30), 10-Q (reporting date: 2023-04-30), 10-Q (reporting date: 2023-01-29), 10-K (reporting date: 2022-10-30), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-05-01), 10-Q (reporting date: 2022-01-30), 10-K (reporting date: 2021-10-31), 10-Q (reporting date: 2021-08-01), 10-Q (reporting date: 2021-05-02), 10-Q (reporting date: 2021-01-31), 10-K (reporting date: 2020-11-01), 10-Q (reporting date: 2020-08-02), 10-Q (reporting date: 2020-05-03), 10-Q (reporting date: 2020-02-02), 10-K (reporting date: 2019-11-03), 10-Q (reporting date: 2019-08-04), 10-Q (reporting date: 2019-05-05), 10-Q (reporting date: 2019-02-03), 10-K (reporting date: 2018-11-04), 10-Q (reporting date: 2018-08-05), 10-Q (reporting date: 2018-05-06), 10-Q (reporting date: 2018-02-04).

1 Q1 2024 Calculation
Net fixed asset turnover = (Net revenueQ1 2024 + Net revenueQ4 2023 + Net revenueQ3 2023 + Net revenueQ2 2023) ÷ Property, plant and equipment, net
= (11,961 + 9,295 + 8,876 + 8,733) ÷ 2,662 = 14.60

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. Broadcom Inc. net fixed asset turnover ratio improved from Q3 2023 to Q4 2023 but then deteriorated significantly from Q4 2023 to Q1 2024.

Total Asset Turnover

Broadcom Inc., total asset turnover calculation (quarterly data)

Microsoft Excel
Feb 4, 2024 Oct 29, 2023 Jul 30, 2023 Apr 30, 2023 Jan 29, 2023 Oct 30, 2022 Jul 31, 2022 May 1, 2022 Jan 30, 2022 Oct 31, 2021 Aug 1, 2021 May 2, 2021 Jan 31, 2021 Nov 1, 2020 Aug 2, 2020 May 3, 2020 Feb 2, 2020 Nov 3, 2019 Aug 4, 2019 May 5, 2019 Feb 3, 2019 Nov 4, 2018 Aug 5, 2018 May 6, 2018 Feb 4, 2018
Selected Financial Data (US$ in millions)
Net revenue 11,961 9,295 8,876 8,733 8,915 8,930 8,464 8,103 7,706 7,407 6,778 6,610 6,655 6,467 5,821 5,742 5,858 5,776 5,515 5,517 5,789 5,444 5,063 5,014 5,327
Total assets 177,870 72,861 71,595 71,667 72,976 73,249 71,326 71,719 73,224 75,570 75,880 75,524 76,972 75,933 79,298 81,548 81,006 67,493 69,767 70,916 72,110 50,124 50,372 54,936 54,544
Long-term Activity Ratio
Total asset turnover1 0.22 0.49 0.50 0.49 0.47 0.45 0.44 0.42 0.39 0.36 0.35 0.34 0.32 0.31 0.29 0.28 0.28 0.33 0.32 0.31 0.30 0.42
Benchmarks
Total Asset Turnover, Competitors2
Advanced Micro Devices Inc. 0.33 0.33 0.32 0.34 0.35 0.34 0.32 0.28 1.32 1.33 1.25 1.14 1.09 1.23 1.16 1.24 1.12
Analog Devices Inc. 0.24 0.25 0.26 0.26 0.25 0.24 0.22 0.19 0.16 0.14 0.30 0.29 0.27 0.26 0.26 0.26 0.27 0.28 0.28 0.29 0.29 0.30
Applied Materials Inc. 0.84 0.86 0.87 0.92 0.94 0.96 0.96 0.98 0.95 0.89 0.88 0.82 0.78 0.77 0.77 0.71 0.76 0.77 0.79 0.84 0.89 0.97
Intel Corp. 0.28 0.28 0.29 0.30 0.35 0.40 0.43 0.44 0.47 0.47 0.50 0.52 0.51 0.54 0.52 0.51 0.53
KLA Corp. 0.72 0.75 0.78 0.76 0.75 0.73 0.72 0.70 0.67 0.67 0.65 0.62 0.64 0.63 0.63 0.57 0.53 0.51 0.48 0.77 0.74 0.72
Lam Research Corp. 0.85 0.93 0.98 0.99 0.96 1.00 1.01 0.99 1.01 0.92 0.87 0.78 0.73 0.69 0.74 0.80 0.77 0.80 0.81 1.01 1.00 0.89
Micron Technology Inc. 0.25 0.24 0.28 0.35 0.40 0.46 0.50 0.49 0.48 0.47 0.46 0.43 0.41 0.40 0.39 0.39 0.42 0.48 0.58 0.63 0.71 0.70
NVIDIA Corp. 0.58 0.65 0.71 0.68 0.65 0.61 0.60 0.57 0.63 0.58 0.55 0.52 0.51 0.63 0.63 0.69 0.77 0.88
ON Semiconductor Corp. 0.62 0.63 0.65 0.68 0.70 0.73 0.71 0.71 0.70 0.71 0.69 0.63 0.61 0.56 0.55 0.57 0.65
Qualcomm Inc. 0.70 0.70 0.79 0.85 0.86 0.90 0.90 0.89 0.84 0.81 0.84 0.79 0.71 0.66 0.62 0.77 0.74 0.74 0.74 0.62 0.63 0.70
Texas Instruments Inc. 0.54 0.57 0.61 0.67 0.74 0.77 0.79 0.75 0.74 0.76 0.81 0.79 0.75 0.75 0.78 0.82 0.80

Based on: 10-Q (reporting date: 2024-02-04), 10-K (reporting date: 2023-10-29), 10-Q (reporting date: 2023-07-30), 10-Q (reporting date: 2023-04-30), 10-Q (reporting date: 2023-01-29), 10-K (reporting date: 2022-10-30), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-05-01), 10-Q (reporting date: 2022-01-30), 10-K (reporting date: 2021-10-31), 10-Q (reporting date: 2021-08-01), 10-Q (reporting date: 2021-05-02), 10-Q (reporting date: 2021-01-31), 10-K (reporting date: 2020-11-01), 10-Q (reporting date: 2020-08-02), 10-Q (reporting date: 2020-05-03), 10-Q (reporting date: 2020-02-02), 10-K (reporting date: 2019-11-03), 10-Q (reporting date: 2019-08-04), 10-Q (reporting date: 2019-05-05), 10-Q (reporting date: 2019-02-03), 10-K (reporting date: 2018-11-04), 10-Q (reporting date: 2018-08-05), 10-Q (reporting date: 2018-05-06), 10-Q (reporting date: 2018-02-04).

1 Q1 2024 Calculation
Total asset turnover = (Net revenueQ1 2024 + Net revenueQ4 2023 + Net revenueQ3 2023 + Net revenueQ2 2023) ÷ Total assets
= (11,961 + 9,295 + 8,876 + 8,733) ÷ 177,870 = 0.22

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. Broadcom Inc. total asset turnover ratio deteriorated from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024.

Equity Turnover

Broadcom Inc., equity turnover calculation (quarterly data)

Microsoft Excel
Feb 4, 2024 Oct 29, 2023 Jul 30, 2023 Apr 30, 2023 Jan 29, 2023 Oct 30, 2022 Jul 31, 2022 May 1, 2022 Jan 30, 2022 Oct 31, 2021 Aug 1, 2021 May 2, 2021 Jan 31, 2021 Nov 1, 2020 Aug 2, 2020 May 3, 2020 Feb 2, 2020 Nov 3, 2019 Aug 4, 2019 May 5, 2019 Feb 3, 2019 Nov 4, 2018 Aug 5, 2018 May 6, 2018 Feb 4, 2018
Selected Financial Data (US$ in millions)
Net revenue 11,961 9,295 8,876 8,733 8,915 8,930 8,464 8,103 7,706 7,407 6,778 6,610 6,655 6,467 5,821 5,742 5,858 5,776 5,515 5,517 5,789 5,444 5,063 5,014 5,327
Total Broadcom Inc. stockholders’ equity 70,284 23,988 22,079 22,007 23,310 22,709 20,876 20,963 22,968 24,962 24,340 23,939 23,973 23,874 23,557 23,942 24,368 24,941 21,503 22,172 23,224 26,657 27,452 32,067 25,901
Long-term Activity Ratio
Equity turnover1 0.55 1.49 1.61 1.59 1.48 1.46 1.52 1.43 1.24 1.10 1.09 1.07 1.03 1.00 0.98 0.96 0.93 0.91 1.04 0.98 0.92 0.78
Benchmarks
Equity Turnover, Competitors2
Advanced Micro Devices Inc. 0.41 0.40 0.40 0.42 0.43 0.42 0.39 0.34 2.19 2.08 1.89 1.76 1.67 2.24 2.31 2.39 2.38
Analog Devices Inc. 0.33 0.35 0.36 0.36 0.34 0.33 0.30 0.26 0.23 0.19 0.53 0.51 0.48 0.47 0.47 0.48 0.49 0.51 0.52 0.53 0.54 0.56
Applied Materials Inc. 1.52 1.62 1.76 1.89 1.96 2.11 2.08 2.14 2.03 1.88 1.79 1.65 1.59 1.63 1.70 1.71 1.73 1.78 1.83 1.92 2.05 2.52
Intel Corp. 0.51 0.52 0.53 0.58 0.62 0.70 0.73 0.75 0.83 0.87 0.91 0.97 0.96 1.05 0.96 0.99 0.93
KLA Corp. 3.40 3.59 3.96 4.03 4.69 6.57 2.12 2.02 1.93 2.05 2.07 2.07 2.16 2.18 2.43 1.98 1.84 1.72 1.54 2.69 2.65 2.49
Lam Research Corp. 1.97 2.12 2.24 2.29 2.43 2.74 2.78 2.55 2.71 2.43 2.47 2.17 2.04 1.94 2.12 2.18 1.92 2.07 1.97 1.88 2.05 1.70
Micron Technology Inc. 0.38 0.35 0.40 0.49 0.55 0.62 0.66 0.65 0.65 0.63 0.60 0.58 0.55 0.55 0.54 0.53 0.57 0.65 0.76 0.87 0.93 0.94
NVIDIA Corp. 1.06 1.22 1.34 1.25 1.12 1.01 1.02 1.04 1.03 0.99 0.96 0.94 0.90 0.89 0.89 0.99 1.11 1.25
ON Semiconductor Corp. 1.06 1.11 1.20 1.29 1.35 1.43 1.41 1.44 1.47 1.54 1.56 1.50 1.49 1.52 1.63 1.68 1.67
Qualcomm Inc. 1.57 1.66 1.87 2.08 2.28 2.45 2.63 2.95 3.18 3.37 3.98 3.96 3.62 3.87 6.05 8.13 5.43 4.94 4.62 5.49 5.95 24.50
Texas Instruments Inc. 1.04 1.09 1.18 1.28 1.37 1.39 1.39 1.35 1.38 1.45 1.50 1.52 1.57 1.65 1.79 1.83 1.61

Based on: 10-Q (reporting date: 2024-02-04), 10-K (reporting date: 2023-10-29), 10-Q (reporting date: 2023-07-30), 10-Q (reporting date: 2023-04-30), 10-Q (reporting date: 2023-01-29), 10-K (reporting date: 2022-10-30), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-05-01), 10-Q (reporting date: 2022-01-30), 10-K (reporting date: 2021-10-31), 10-Q (reporting date: 2021-08-01), 10-Q (reporting date: 2021-05-02), 10-Q (reporting date: 2021-01-31), 10-K (reporting date: 2020-11-01), 10-Q (reporting date: 2020-08-02), 10-Q (reporting date: 2020-05-03), 10-Q (reporting date: 2020-02-02), 10-K (reporting date: 2019-11-03), 10-Q (reporting date: 2019-08-04), 10-Q (reporting date: 2019-05-05), 10-Q (reporting date: 2019-02-03), 10-K (reporting date: 2018-11-04), 10-Q (reporting date: 2018-08-05), 10-Q (reporting date: 2018-05-06), 10-Q (reporting date: 2018-02-04).

1 Q1 2024 Calculation
Equity turnover = (Net revenueQ1 2024 + Net revenueQ4 2023 + Net revenueQ3 2023 + Net revenueQ2 2023) ÷ Total Broadcom Inc. stockholders’ equity
= (11,961 + 9,295 + 8,876 + 8,733) ÷ 70,284 = 0.55

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. Broadcom Inc. equity turnover ratio deteriorated from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024.