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: 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 Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023. |
| 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 2023 to Q3 2023 and from Q3 2023 to Q4 2023. |
| Total asset turnover | An activity ratio calculated as total revenue divided by total assets. | Alphabet Inc. total asset turnover ratio deteriorated from Q2 2023 to Q3 2023 but then improved from Q3 2023 to Q4 2023 exceeding Q2 2023 level. |
| Equity turnover | An activity ratio calculated as total revenue divided by shareholders’ equity. | Alphabet Inc. equity turnover ratio improved from Q2 2023 to Q3 2023 but then slightly deteriorated from Q3 2023 to Q4 2023 not reaching Q2 2023 level. |
Net Fixed Asset Turnover
Alphabet Inc., net fixed asset turnover calculation (quarterly data)
| 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 | 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 | 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.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. | 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.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. | 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.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 | 2.06 | 1.93 | 1.99 | ||||||
Based on: 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 Q4 2023 Calculation
Net fixed asset turnover
= (RevenuesQ4 2023
+ RevenuesQ3 2023
+ RevenuesQ2 2023
+ RevenuesQ1 2023)
÷ Property and equipment, net
= (86,310 + 76,693 + 74,604 + 69,787)
÷ 134,345 = 2.29
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 2023 to Q3 2023 and from Q3 2023 to Q4 2023. |
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, 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 | 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 | 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 | 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) | 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 | 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.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-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 Q4 2023 Calculation
Net fixed asset turnover (including operating lease, right-of-use asset)
= (RevenuesQ4 2023
+ RevenuesQ3 2023
+ RevenuesQ2 2023
+ RevenuesQ1 2023)
÷ Property and equipment, net (including operating lease, right-of-use asset)
= (86,310 + 76,693 + 74,604 + 69,787)
÷ 148,436 = 2.07
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 2023 to Q3 2023 and from Q3 2023 to Q4 2023. |
Total Asset Turnover
Alphabet Inc., total asset turnover calculation (quarterly data)
| 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 | 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 | 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.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.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.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.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.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 | 0.31 | 0.28 | 0.59 | ||||||
Based on: 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 Q4 2023 Calculation
Total asset turnover
= (RevenuesQ4 2023
+ RevenuesQ3 2023
+ RevenuesQ2 2023
+ RevenuesQ1 2023)
÷ Total assets
= (86,310 + 76,693 + 74,604 + 69,787)
÷ 402,392 = 0.76
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 2023 to Q3 2023 but then improved from Q3 2023 to Q4 2023 exceeding Q2 2023 level. |
Equity Turnover
Alphabet Inc., equity turnover calculation (quarterly data)
| 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 | 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 | 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.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.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.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.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.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 | 0.72 | 0.66 | 1.18 | ||||||
Based on: 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 Q4 2023 Calculation
Equity turnover
= (RevenuesQ4 2023
+ RevenuesQ3 2023
+ RevenuesQ2 2023
+ RevenuesQ1 2023)
÷ Stockholders’ equity
= (86,310 + 76,693 + 74,604 + 69,787)
÷ 283,379 = 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 Q2 2023 to Q3 2023 but then slightly deteriorated from Q3 2023 to Q4 2023 not reaching Q2 2023 level. |