Analysis of Long-term (Investment) Activity Ratios
Quarterly Data
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)
Alphabet Inc., long-term (investment) activity ratios (quarterly data)
Based on: 10-K (reporting date: 2024-12-31), 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).
| 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 Q2 2024 to Q3 2024 and from Q3 2024 to Q4 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 Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024. |
| Total asset turnover | An activity ratio calculated as total revenue divided by total assets. | Alphabet Inc. total asset turnover ratio deteriorated from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024. |
| Equity turnover | An activity ratio calculated as total revenue divided by shareholders’ equity. | Alphabet Inc. equity turnover ratio deteriorated from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024. |
Net Fixed Asset Turnover
Alphabet Inc., net fixed asset turnover calculation (quarterly data)
| Dec 31, 2024 | 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 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||||||||||||||||||||||
| Revenues | 96,469) | 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) | ||||||
| Property and equipment, net | 171,036) | 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) | ||||||
| Long-term Activity Ratio | ||||||||||||||||||||||||||
| Net fixed asset turnover1 | 2.05 | 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 | — | — | — | ||||||
| Benchmarks | ||||||||||||||||||||||||||
| Net Fixed Asset Turnover, Competitors2 | ||||||||||||||||||||||||||
| Comcast Corp. | 1.98 | 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 | — | — | — | ||||||
| Meta Platforms Inc. | 1.36 | 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 | — | — | — | ||||||
| Netflix Inc. | 24.47 | 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 | — | — | — | ||||||
| Walt Disney Co. | 2.47 | 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 | ||||||
Based on: 10-K (reporting date: 2024-12-31), 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).
1 Q4 2024 Calculation
Net fixed asset turnover
= (RevenuesQ4 2024
+ RevenuesQ3 2024
+ RevenuesQ2 2024
+ RevenuesQ1 2024)
÷ Property and equipment, net
= (96,469 + 88,268 + 84,742 + 80,539)
÷ 171,036 = 2.05
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 Q2 2024 to Q3 2024 and from Q3 2024 to Q4 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)
| Dec 31, 2024 | 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 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||||||||||||||||||||||
| Revenues | 96,469) | 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) | ||||||
| Property and equipment, net | 171,036) | 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) | ||||||
| Operating lease assets | 13,588) | 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) | ||||||
| Property and equipment, net (including operating lease, right-of-use asset) | 184,624) | 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) | ||||||
| Long-term Activity Ratio | ||||||||||||||||||||||||||
| Net fixed asset turnover (including operating lease, right-of-use asset)1 | 1.90 | 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 | — | — | — | ||||||
| Benchmarks | ||||||||||||||||||||||||||
| Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Competitors2 | ||||||||||||||||||||||||||
| Meta Platforms Inc. | 1.21 | 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 | — | — | — | ||||||
Based on: 10-K (reporting date: 2024-12-31), 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).
1 Q4 2024 Calculation
Net fixed asset turnover (including operating lease, right-of-use asset)
= (RevenuesQ4 2024
+ RevenuesQ3 2024
+ RevenuesQ2 2024
+ RevenuesQ1 2024)
÷ Property and equipment, net (including operating lease, right-of-use asset)
= (96,469 + 88,268 + 84,742 + 80,539)
÷ 184,624 = 1.90
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 Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024. |
Total Asset Turnover
Alphabet Inc., total asset turnover calculation (quarterly data)
| Dec 31, 2024 | 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 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||||||||||||||||||||||
| Revenues | 96,469) | 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) | ||||||
| Total assets | 450,256) | 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) | ||||||
| Long-term Activity Ratio | ||||||||||||||||||||||||||
| Total asset turnover1 | 0.78 | 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 | — | — | — | ||||||
| Benchmarks | ||||||||||||||||||||||||||
| Total Asset Turnover, Competitors2 | ||||||||||||||||||||||||||
| Comcast Corp. | 0.46 | 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 | — | — | — | ||||||
| Meta Platforms Inc. | 0.60 | 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 | — | — | — | ||||||
| Netflix Inc. | 0.73 | 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 | — | — | — | ||||||
| Walt Disney Co. | 0.47 | 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 | ||||||
Based on: 10-K (reporting date: 2024-12-31), 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).
1 Q4 2024 Calculation
Total asset turnover
= (RevenuesQ4 2024
+ RevenuesQ3 2024
+ RevenuesQ2 2024
+ RevenuesQ1 2024)
÷ Total assets
= (96,469 + 88,268 + 84,742 + 80,539)
÷ 450,256 = 0.78
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 deteriorated from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024. |
Equity Turnover
Alphabet Inc., equity turnover calculation (quarterly data)
| Dec 31, 2024 | 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 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||||||||||||||||||||||
| Revenues | 96,469) | 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) | ||||||
| Stockholders’ equity | 325,084) | 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) | ||||||
| Long-term Activity Ratio | ||||||||||||||||||||||||||
| Equity turnover1 | 1.08 | 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 | — | — | — | ||||||
| Benchmarks | ||||||||||||||||||||||||||
| Equity Turnover, Competitors2 | ||||||||||||||||||||||||||
| Comcast Corp. | 1.45 | 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 | — | — | — | ||||||
| Meta Platforms Inc. | 0.90 | 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 | — | — | — | ||||||
| Netflix Inc. | 1.58 | 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 | — | — | — | ||||||
| Walt Disney Co. | 0.91 | 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 | ||||||
Based on: 10-K (reporting date: 2024-12-31), 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).
1 Q4 2024 Calculation
Equity turnover
= (RevenuesQ4 2024
+ RevenuesQ3 2024
+ RevenuesQ2 2024
+ RevenuesQ1 2024)
÷ Stockholders’ equity
= (96,469 + 88,268 + 84,742 + 80,539)
÷ 325,084 = 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 deteriorated from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024. |