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, 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 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.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.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-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 Q2 2023 to Q3 2023 but then slightly improved from Q3 2023 to Q4 2023.
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 2023 to Q3 2023 but then slightly improved from Q3 2023 to Q4 2023.
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Alphabet Inc. cash ratio deteriorated from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Current Ratio

Alphabet Inc., current ratio calculation (quarterly data)

Microsoft Excel
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 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 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 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.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.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.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. 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-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
Current ratio = Current assets ÷ Current liabilities
= 171,530 ÷ 81,814 = 2.10

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 2023 to Q3 2023 but then slightly improved from Q3 2023 to Q4 2023.

Quick Ratio

Alphabet Inc., quick ratio calculation (quarterly data)

Microsoft Excel
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 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 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 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 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.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.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.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.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.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-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
Quick ratio = Total quick assets ÷ Current liabilities
= 158,880 ÷ 81,814 = 1.94

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 2023 to Q3 2023 but then slightly improved from Q3 2023 to Q4 2023.

Cash Ratio

Alphabet Inc., cash ratio calculation (quarterly data)

Microsoft Excel
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 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 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 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.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.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.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.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.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-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
Cash ratio = Total cash assets ÷ Current liabilities
= 110,916 ÷ 81,814 = 1.36

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 2023 to Q3 2023 and from Q3 2023 to Q4 2023.