Stock Analysis on Net

Alphabet Inc. (NASDAQ:GOOG)

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

Microsoft Excel

Long-term Activity Ratios (Summary)

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

Microsoft Excel
Sep 30, 2024 Jun 30, 2024 Mar 31, 2024 Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Net fixed asset turnover 2.11 2.17 2.22 2.29 2.36 2.39 2.42 2.51 2.60 2.62 2.59 2.64 2.53 2.40 2.25 2.15 2.10 2.11 2.17 2.20
Net fixed asset turnover (including operating lease, right-of-use asset) 1.94 1.99 2.03 2.07 2.12 2.13 2.16 2.23 2.31 2.33 2.31 2.33 2.22 2.10 1.96 1.88 1.83 1.84 1.89 1.91
Total asset turnover 0.79 0.79 0.78 0.76 0.75 0.76 0.77 0.77 0.79 0.78 0.76 0.72 0.69 0.66 0.60 0.57 0.57 0.60 0.61 0.59
Equity turnover 1.08 1.09 1.09 1.08 1.09 1.08 1.09 1.10 1.11 1.09 1.06 1.02 0.98 0.93 0.86 0.82 0.81 0.80 0.82 0.80

Based on: 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Alphabet Inc. net fixed asset turnover ratio deteriorated from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.
Net fixed asset turnover (including operating lease, right-of-use asset) An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). Alphabet Inc. net fixed asset turnover ratio (with operating lease, right-of-use asset) deteriorated from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Alphabet Inc. total asset turnover ratio improved from Q1 2024 to Q2 2024 but then slightly deteriorated from Q2 2024 to Q3 2024.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Alphabet Inc. equity turnover ratio improved from Q1 2024 to Q2 2024 but then deteriorated significantly from Q2 2024 to Q3 2024.

Net Fixed Asset Turnover

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

Microsoft Excel
Sep 30, 2024 Jun 30, 2024 Mar 31, 2024 Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data (US$ in millions)
Revenues 88,268 84,742 80,539 86,310 76,693 74,604 69,787 76,048 69,092 69,685 68,011 75,325 65,118 61,880 55,314 56,898 46,173 38,297 41,159 46,075 40,499 38,944 36,339
Property and equipment, net 161,270 151,155 143,182 134,345 125,705 121,208 117,560 112,668 108,363 106,223 104,218 97,599 94,631 91,697 87,606 84,749 81,636 78,748 76,747 73,646 69,252 64,891 60,528
Long-term Activity Ratio
Net fixed asset turnover1 2.11 2.17 2.22 2.29 2.36 2.39 2.42 2.51 2.60 2.62 2.59 2.64 2.53 2.40 2.25 2.15 2.10 2.11 2.17 2.20
Benchmarks
Net Fixed Asset Turnover, Competitors2
Comcast Corp. 1.99 2.00 2.04 2.04 2.08 2.12 2.13 2.19 2.26 2.27 2.23 2.15 2.15 2.07 1.99 1.99 2.07 2.15 2.24 2.25
Meta Platforms Inc. 1.39 1.45 1.44 1.40 1.38 1.37 1.39 1.47 1.60 1.77 1.94 2.04 2.09 2.06 1.98 1.88 1.87 1.93 1.98 2.00
Netflix Inc. 23.97 24.03 23.27 22.61 21.85 21.83 22.58 22.61 22.93 22.78 21.97 22.44 23.47 24.91 25.99 26.03 28.76 30.09 32.90 35.66
Walt Disney Co. 2.50 2.51 2.52 2.54 2.54 2.52 2.47 2.46 2.42 2.33 2.23 2.07 1.96 1.82 1.88 2.04 2.19 2.43 2.36 2.20

Based on: 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

1 Q3 2024 Calculation
Net fixed asset turnover = (RevenuesQ3 2024 + RevenuesQ2 2024 + RevenuesQ1 2024 + RevenuesQ4 2023) ÷ Property and equipment, net
= (88,268 + 84,742 + 80,539 + 86,310) ÷ 161,270 = 2.11

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. Alphabet Inc. net fixed asset turnover ratio deteriorated from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.

Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset)

Alphabet Inc., net fixed asset turnover (including operating lease, right-of-use asset) calculation (quarterly data)

Microsoft Excel
Sep 30, 2024 Jun 30, 2024 Mar 31, 2024 Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data (US$ in millions)
Revenues 88,268 84,742 80,539 86,310 76,693 74,604 69,787 76,048 69,092 69,685 68,011 75,325 65,118 61,880 55,314 56,898 46,173 38,297 41,159 46,075 40,499 38,944 36,339
 
Property and equipment, net 161,270 151,155 143,182 134,345 125,705 121,208 117,560 112,668 108,363 106,223 104,218 97,599 94,631 91,697 87,606 84,749 81,636 78,748 76,747 73,646 69,252 64,891 60,528
Operating lease assets 13,561 13,606 13,768 14,091 14,199 14,469 14,447 14,381 13,677 13,398 12,992 12,959 12,918 12,978 12,598 12,211 11,946 11,567 11,219 10,941 10,341 9,713 8,837
Property and equipment, net (including operating lease, right-of-use asset) 174,831 164,761 156,950 148,436 139,904 135,677 132,007 127,049 122,040 119,621 117,210 110,558 107,549 104,675 100,204 96,960 93,582 90,315 87,966 84,587 79,593 74,604 69,365
Long-term Activity Ratio
Net fixed asset turnover (including operating lease, right-of-use asset)1 1.94 1.99 2.03 2.07 2.12 2.13 2.16 2.23 2.31 2.33 2.31 2.33 2.22 2.10 1.96 1.88 1.83 1.84 1.89 1.91
Benchmarks
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Competitors2
Meta Platforms Inc. 1.23 1.28 1.27 1.23 1.21 1.19 1.21 1.26 1.35 1.46 1.62 1.69 1.73 1.71 1.63 1.56 1.53 1.55 1.58 1.58

Based on: 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

1 Q3 2024 Calculation
Net fixed asset turnover (including operating lease, right-of-use asset) = (RevenuesQ3 2024 + RevenuesQ2 2024 + RevenuesQ1 2024 + RevenuesQ4 2023) ÷ Property and equipment, net (including operating lease, right-of-use asset)
= (88,268 + 84,742 + 80,539 + 86,310) ÷ 174,831 = 1.94

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover (including operating lease, right-of-use asset) An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). Alphabet Inc. net fixed asset turnover ratio (with operating lease, right-of-use asset) deteriorated from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.

Total Asset Turnover

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

Microsoft Excel
Sep 30, 2024 Jun 30, 2024 Mar 31, 2024 Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data (US$ in millions)
Revenues 88,268 84,742 80,539 86,310 76,693 74,604 69,787 76,048 69,092 69,685 68,011 75,325 65,118 61,880 55,314 56,898 46,173 38,297 41,159 46,075 40,499 38,944 36,339
Total assets 430,266 414,770 407,350 402,392 396,711 383,044 369,491 365,264 358,255 355,185 357,096 359,268 347,403 335,387 327,095 319,616 299,243 278,492 273,403 275,909 263,044 257,101 245,349
Long-term Activity Ratio
Total asset turnover1 0.79 0.79 0.78 0.76 0.75 0.76 0.77 0.77 0.79 0.78 0.76 0.72 0.69 0.66 0.60 0.57 0.57 0.60 0.61 0.59
Benchmarks
Total Asset Turnover, Competitors2
Comcast Corp. 0.46 0.46 0.46 0.46 0.46 0.46 0.46 0.47 0.48 0.46 0.44 0.42 0.41 0.39 0.37 0.38 0.39 0.40 0.41 0.41
Meta Platforms Inc. 0.61 0.65 0.64 0.59 0.59 0.58 0.64 0.63 0.66 0.70 0.73 0.71 0.66 0.61 0.58 0.54 0.54 0.54 0.53 0.53
Netflix Inc. 0.72 0.74 0.72 0.69 0.66 0.63 0.64 0.65 0.66 0.67 0.67 0.67 0.67 0.67 0.66 0.64 0.62 0.61 0.61 0.59
Walt Disney Co. 0.46 0.46 0.45 0.43 0.43 0.42 0.42 0.41 0.40 0.38 0.36 0.33 0.31 0.29 0.30 0.32 0.34 0.38 0.37 0.36

Based on: 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

1 Q3 2024 Calculation
Total asset turnover = (RevenuesQ3 2024 + RevenuesQ2 2024 + RevenuesQ1 2024 + RevenuesQ4 2023) ÷ Total assets
= (88,268 + 84,742 + 80,539 + 86,310) ÷ 430,266 = 0.79

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. Alphabet Inc. total asset turnover ratio improved from Q1 2024 to Q2 2024 but then slightly deteriorated from Q2 2024 to Q3 2024.

Equity Turnover

Alphabet Inc., equity turnover calculation (quarterly data)

Microsoft Excel
Sep 30, 2024 Jun 30, 2024 Mar 31, 2024 Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data (US$ in millions)
Revenues 88,268 84,742 80,539 86,310 76,693 74,604 69,787 76,048 69,092 69,685 68,011 75,325 65,118 61,880 55,314 56,898 46,173 38,297 41,159 46,075 40,499 38,944 36,339
Stockholders’ equity 314,119 300,753 292,844 283,379 273,202 267,141 260,894 256,144 253,626 255,419 254,004 251,635 244,567 237,565 230,013 222,544 212,920 207,322 203,659 201,442 194,969 192,192 183,472
Long-term Activity Ratio
Equity turnover1 1.08 1.09 1.09 1.08 1.09 1.08 1.09 1.10 1.11 1.09 1.06 1.02 0.98 0.93 0.86 0.82 0.81 0.80 0.82 0.80
Benchmarks
Equity Turnover, Competitors2
Comcast Corp. 1.43 1.46 1.48 1.47 1.46 1.43 1.46 1.50 1.51 1.33 1.27 1.21 1.19 1.15 1.13 1.15 1.21 1.26 1.33 1.32
Meta Platforms Inc. 0.95 0.96 0.95 0.88 0.89 0.90 0.94 0.93 0.95 0.95 0.97 0.94 0.84 0.76 0.71 0.67 0.67 0.68 0.70 0.70
Netflix Inc. 1.65 1.64 1.63 1.64 1.48 1.41 1.46 1.52 1.53 1.63 1.73 1.87 1.87 1.99 2.05 2.26 2.31 2.42 2.55 2.66
Walt Disney Co. 0.89 0.90 0.88 0.90 0.90 0.89 0.88 0.87 0.88 0.85 0.81 0.76 0.73 0.68 0.72 0.78 0.81 0.87 0.84 0.78

Based on: 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

1 Q3 2024 Calculation
Equity turnover = (RevenuesQ3 2024 + RevenuesQ2 2024 + RevenuesQ1 2024 + RevenuesQ4 2023) ÷ Stockholders’ equity
= (88,268 + 84,742 + 80,539 + 86,310) ÷ 314,119 = 1.08

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. Alphabet Inc. equity turnover ratio improved from Q1 2024 to Q2 2024 but then deteriorated significantly from Q2 2024 to Q3 2024.