Stock Analysis on Net

Alphabet Inc. (NASDAQ:GOOG)

Analysis of Liquidity Ratios
Quarterly Data

Microsoft Excel

Liquidity Ratios (Summary)

Alphabet Inc., liquidity ratios (quarterly data)

Microsoft Excel
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
Current ratio 1.84 1.95 2.08 2.15 2.10 2.04 2.17 2.35 2.38 2.52 2.81 2.87 2.93 2.98 3.15 3.10 3.07 3.41 3.41 3.66
Quick ratio 1.66 1.76 1.90 1.98 1.94 1.87 2.02 2.20 2.22 2.29 2.62 2.72 2.79 2.85 3.01 2.94 2.95 3.27 3.26 3.46
Cash ratio 1.07 1.15 1.29 1.40 1.36 1.39 1.52 1.67 1.64 1.76 2.04 2.16 2.17 2.30 2.44 2.44 2.41 2.75 2.77 2.92

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).

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Alphabet Inc. current ratio deteriorated from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024.
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. Alphabet Inc. quick ratio deteriorated from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024.
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Alphabet Inc. cash ratio deteriorated from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024.

Current Ratio

Alphabet Inc., current ratio calculation (quarterly data)

Microsoft Excel
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)
Current assets 163,711 157,541 161,995 165,471 171,530 176,310 168,788 161,985 164,795 166,109 172,371 177,853 188,143 184,110 175,697 172,137 174,296 164,369 149,069 147,018
Current liabilities 89,122 80,803 77,913 76,997 81,814 86,295 77,709 68,854 69,300 65,979 61,354 61,948 64,254 61,782 55,741 55,453 56,834 48,200 43,658 40,189
Liquidity Ratio
Current ratio1 1.84 1.95 2.08 2.15 2.10 2.04 2.17 2.35 2.38 2.52 2.81 2.87 2.93 2.98 3.15 3.10 3.07 3.41 3.41 3.66
Benchmarks
Current Ratio, Competitors2
Comcast Corp. 0.68 0.72 0.66 0.59 0.60 0.70 0.76 0.69 0.78 0.84 0.88 0.86 0.85 1.03 0.92 0.96 0.93 0.93 0.97 0.87
Meta Platforms Inc. 2.98 2.73 2.83 2.68 2.67 2.57 2.32 2.07 2.20 2.57 2.52 2.81 3.15 4.23 5.43 6.08 5.05 5.51 6.02 4.60
Netflix Inc. 1.22 1.13 0.95 1.07 1.12 1.29 1.33 1.26 1.17 1.14 1.05 1.05 0.95 1.17 1.23 1.27 1.25 1.24 1.12 0.82
Walt Disney Co. 0.73 0.72 0.75 0.84 1.05 1.07 1.01 0.99 1.00 1.02 1.06 1.10 1.08 1.24 1.23 1.31 1.32 1.34 0.94 0.80

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
Current ratio = Current assets ÷ Current liabilities
= 163,711 ÷ 89,122 = 1.84

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Alphabet Inc. current ratio deteriorated from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024.

Quick Ratio

Alphabet Inc., quick ratio calculation (quarterly data)

Microsoft Excel
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)
Cash, cash equivalents, and marketable securities 95,657 93,230 100,725 108,090 110,916 119,935 118,332 115,102 113,762 116,259 124,997 133,970 139,649 142,003 135,863 135,104 136,694 132,596 121,080 117,229
Accounts receivable, net 52,340 49,104 47,087 44,552 47,964 41,020 38,804 36,036 40,258 34,697 35,707 34,703 39,304 34,047 31,967 28,006 30,930 24,925 21,201 21,825
Total quick assets 147,997 142,334 147,812 152,642 158,880 160,955 157,136 151,138 154,020 150,956 160,704 168,673 178,953 176,050 167,830 163,110 167,624 157,521 142,281 139,054
 
Current liabilities 89,122 80,803 77,913 76,997 81,814 86,295 77,709 68,854 69,300 65,979 61,354 61,948 64,254 61,782 55,741 55,453 56,834 48,200 43,658 40,189
Liquidity Ratio
Quick ratio1 1.66 1.76 1.90 1.98 1.94 1.87 2.02 2.20 2.22 2.29 2.62 2.72 2.79 2.85 3.01 2.94 2.95 3.27 3.26 3.46
Benchmarks
Quick Ratio, Competitors2
Comcast Corp. 0.53 0.60 0.54 0.49 0.50 0.56 0.61 0.55 0.62 0.63 0.68 0.71 0.71 0.89 0.80 0.84 0.81 0.81 0.85 0.70
Meta Platforms Inc. 2.82 2.57 2.69 2.55 2.55 2.43 2.20 1.91 2.01 2.34 2.34 2.62 2.94 3.94 5.09 5.86 4.89 5.33 5.81 4.48
Netflix Inc. 0.89 0.86 0.66 0.76 0.81 0.94 0.99 0.94 0.76 0.79 0.78 0.78 0.71 0.94 0.99 1.06 1.05 1.06 0.94 0.66
Walt Disney Co. 0.54 0.53 0.57 0.69 0.85 0.87 0.83 0.83 0.83 0.87 0.91 0.98 0.94 1.07 1.07 1.17 1.15 1.16 0.81 0.69

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
Quick ratio = Total quick assets ÷ Current liabilities
= 147,997 ÷ 89,122 = 1.66

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. Alphabet Inc. quick ratio deteriorated from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024.

Cash Ratio

Alphabet Inc., cash ratio calculation (quarterly data)

Microsoft Excel
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)
Cash, cash equivalents, and marketable securities 95,657 93,230 100,725 108,090 110,916 119,935 118,332 115,102 113,762 116,259 124,997 133,970 139,649 142,003 135,863 135,104 136,694 132,596 121,080 117,229
Total cash assets 95,657 93,230 100,725 108,090 110,916 119,935 118,332 115,102 113,762 116,259 124,997 133,970 139,649 142,003 135,863 135,104 136,694 132,596 121,080 117,229
 
Current liabilities 89,122 80,803 77,913 76,997 81,814 86,295 77,709 68,854 69,300 65,979 61,354 61,948 64,254 61,782 55,741 55,453 56,834 48,200 43,658 40,189
Liquidity Ratio
Cash ratio1 1.07 1.15 1.29 1.40 1.36 1.39 1.52 1.67 1.64 1.76 2.04 2.16 2.17 2.30 2.44 2.44 2.41 2.75 2.77 2.92
Benchmarks
Cash Ratio, Competitors2
Comcast Corp. 0.18 0.23 0.17 0.16 0.15 0.19 0.22 0.17 0.17 0.20 0.25 0.30 0.30 0.44 0.42 0.49 0.41 0.46 0.49 0.31
Meta Platforms Inc. 2.32 2.13 2.15 2.07 2.05 2.00 1.79 1.48 1.51 1.84 1.82 2.08 2.27 3.26 4.31 5.05 4.14 4.66 5.15 4.00
Netflix Inc. 0.89 0.86 0.66 0.76 0.81 0.94 0.99 0.94 0.76 0.79 0.78 0.78 0.71 0.94 0.99 1.06 1.05 1.06 0.94 0.66
Walt Disney Co. 0.17 0.17 0.20 0.23 0.46 0.41 0.37 0.31 0.40 0.42 0.45 0.48 0.51 0.59 0.60 0.64 0.67 0.75 0.40 0.20

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
Cash ratio = Total cash assets ÷ Current liabilities
= 95,657 ÷ 89,122 = 1.07

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Alphabet Inc. cash ratio deteriorated from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024.