Alphabet Inc. (GOOG)

Liquidity Analysis Quarterly Data

Difficulty: Beginner

Liquidity ratios measure the company's ability to meet its short-term obligations.

Alphabet Inc., liquidity ratios (quarterly data)

Source: Based on data from Alphabet Inc. Quarterly and Annual Reports

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

Alphabet Inc., current ratio calculation (quarterly data)

		Mar 31, 2018	Dec 31, 2017	Sep 30, 2017	Jun 30, 2017	Mar 31, 2017	Dec 31, 2016	Sep 30, 2016	Jun 30, 2016	Mar 31, 2016	Dec 31, 2015	Sep 30, 2015	Jun 30, 2015	Mar 31, 2015	Dec 31, 2014	Sep 30, 2014	Jun 30, 2014	Mar 31, 2014	Dec 31, 2013	Sep 30, 2013	Jun 30, 2013	Mar 31, 2013
	Selected Financial Data (USD $ in millions)
	Current assets
	Current liabilities
	Ratio
	Current ratio¹

Source: Based on data from Alphabet Inc. Quarterly and Annual Reports

Q1 2018 Calculations

¹ Current ratio = Current assets ÷ Current liabilities
= ÷ =

Ratio	Description	The company
Current ratio	A liquidity ratio calculated as current assets divided by current liabilities.	Alphabet Inc.'s current ratio deteriorated from Q3 2017 to Q4 2017 and from Q4 2017 to Q1 2018.

Alphabet Inc., quick ratio calculation (quarterly data)

		Mar 31, 2018	Dec 31, 2017	Sep 30, 2017	Jun 30, 2017	Mar 31, 2017	Dec 31, 2016	Sep 30, 2016	Jun 30, 2016	Mar 31, 2016	Dec 31, 2015	Sep 30, 2015	Jun 30, 2015	Mar 31, 2015	Dec 31, 2014	Sep 30, 2014	Jun 30, 2014	Mar 31, 2014	Dec 31, 2013	Sep 30, 2013	Jun 30, 2013	Mar 31, 2013
	Selected Financial Data (USD $ in millions)
	Cash, cash equivalents, and marketable securities
	Accounts receivable, net of allowance
	Total quick assets
	Current liabilities
	Ratio
	Quick ratio¹

Source: Based on data from Alphabet Inc. Quarterly and Annual Reports

Q1 2018 Calculations

¹ Quick ratio = Total quick assets ÷ Current liabilities
= ÷ =

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.'s quick ratio deteriorated from Q3 2017 to Q4 2017 and from Q4 2017 to Q1 2018.

Alphabet Inc., cash ratio calculation (quarterly data)

		Mar 31, 2018	Dec 31, 2017	Sep 30, 2017	Jun 30, 2017	Mar 31, 2017	Dec 31, 2016	Sep 30, 2016	Jun 30, 2016	Mar 31, 2016	Dec 31, 2015	Sep 30, 2015	Jun 30, 2015	Mar 31, 2015	Dec 31, 2014	Sep 30, 2014	Jun 30, 2014	Mar 31, 2014	Dec 31, 2013	Sep 30, 2013	Jun 30, 2013	Mar 31, 2013
	Selected Financial Data (USD $ in millions)
	Cash, cash equivalents, and marketable securities
	Total cash assets
	Current liabilities
	Ratio
	Cash ratio¹

Source: Based on data from Alphabet Inc. Quarterly and Annual Reports

Q1 2018 Calculations

¹ Cash ratio = Total cash assets ÷ Current liabilities
= ÷ =

Ratio	Description	The company
Cash ratio	A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities.	Alphabet Inc.'s cash ratio deteriorated from Q3 2017 to Q4 2017 and from Q4 2017 to Q1 2018.

	Alphabet Inc.	Other companies (not purchased previously)
Long-term Trends
Financial Statements
Common-Size Financial Statements
Ratios
Relative Valuation
Discounted Cash Flow (DCF) Valuation
Analysis
Financial Reporting Quality

	All companies
Long-term Trends
Financial Statements
Common-Size Financial Statements
Ratios
Relative Valuation
Discounted Cash Flow (DCF) Valuation
Analysis
Financial Reporting Quality