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
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
Current ratio 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 3.37 3.78 3.98 3.96
Quick ratio 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 3.21 3.62 3.84 3.80
Cash ratio 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 2.65 3.09 3.27 3.25

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

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Alphabet Inc. current ratio deteriorated from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 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 Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Alphabet Inc. cash ratio deteriorated from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.

Current Ratio

Alphabet Inc., current ratio 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)
Current assets 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 152,578 148,358 147,437 138,207
Current liabilities 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 45,221 39,224 37,000 34,910
Liquidity Ratio
Current ratio1 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 3.37 3.78 3.98 3.96
Benchmarks
Current Ratio, Competitors2
Comcast Corp. 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 0.84 0.86 0.69 0.73
Meta Platforms Inc. 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 4.40 4.66 4.47 5.38
Netflix Inc. 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 0.90 0.73 0.85 0.61
Walt Disney Co. 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 0.90 0.70 0.77 1.00

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
Current ratio = Current assets ÷ Current liabilities
= 157,541 ÷ 80,803 = 1.95

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 Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.

Quick Ratio

Alphabet Inc., quick ratio 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)
Cash, cash equivalents, and marketable securities 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 119,675 121,177 121,056 113,488
Accounts receivable, net 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 25,326 20,889 20,965 19,149
Total quick assets 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 145,001 142,066 142,021 132,637
 
Current liabilities 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 45,221 39,224 37,000 34,910
Liquidity Ratio
Quick ratio1 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 3.21 3.62 3.84 3.80
Benchmarks
Quick Ratio, Competitors2
Comcast Corp. 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 0.55 0.55 0.48 0.51
Meta Platforms Inc. 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 4.28 4.50 4.32 5.22
Netflix Inc. 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 0.73 0.61 0.72 0.49
Walt Disney Co. 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 0.67 0.50 0.56 0.83

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
Quick ratio = Total quick assets ÷ Current liabilities
= 142,334 ÷ 80,803 = 1.76

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 Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.

Cash Ratio

Alphabet Inc., cash ratio 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)
Cash, cash equivalents, and marketable securities 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 119,675 121,177 121,056 113,488
Total cash assets 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 119,675 121,177 121,056 113,488
 
Current liabilities 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 45,221 39,224 37,000 34,910
Liquidity Ratio
Cash ratio1 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 2.65 3.09 3.27 3.25
Benchmarks
Cash Ratio, Competitors2
Comcast Corp. 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 0.18 0.13 0.13 0.13
Meta Platforms Inc. 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 3.64 3.92 3.74 4.57
Netflix Inc. 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 0.73 0.61 0.72 0.49
Walt Disney Co. 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 0.17 0.15 0.23 0.25

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
Cash ratio = Total cash assets ÷ Current liabilities
= 93,230 ÷ 80,803 = 1.15

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 Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.