Microsoft Excel LibreOffice Calc

AT&T Inc. (T)


Liquidity Analysis
Quarterly Data

Difficulty: Beginner

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


Ratios (Summary)

AT&T Inc., liquidity ratios (quarterly data)

Microsoft Excel LibreOffice Calc
Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 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
Current ratio 0.71 0.72 0.80 0.81 0.81 1.11 0.97 1.60 1.12 0.90 0.76 0.79 0.77 0.85 0.75 0.73 1.07 0.73 0.86 0.65 0.76 0.60
Quick ratio 0.46 0.47 0.49 0.53 0.57 0.92 0.82 1.35 0.85 0.59 0.45 0.48 0.50 0.59 0.45 0.47 0.86 0.48 0.62 0.40 0.56 0.42
Cash ratio 0.13 0.10 0.08 0.13 0.20 0.69 0.62 1.02 0.53 0.29 0.11 0.13 0.16 0.22 0.11 0.13 0.52 0.12 0.23 0.06 0.26 0.09

Based on: 10-Q (filing date: 2019-08-05), 10-Q (filing date: 2019-05-06), 10-K (filing date: 2019-02-20), 10-Q (filing date: 2018-11-02), 10-Q (filing date: 2018-08-02), 10-Q (filing date: 2018-05-03), 10-K (filing date: 2018-02-20), 10-Q (filing date: 2017-11-03), 10-Q (filing date: 2017-08-03), 10-Q (filing date: 2017-05-04), 10-K (filing date: 2017-02-17), 10-Q (filing date: 2016-11-03), 10-Q (filing date: 2016-08-04), 10-Q (filing date: 2016-05-05), 10-K (filing date: 2016-02-18), 10-Q (filing date: 2015-11-06), 10-Q (filing date: 2015-08-07), 10-Q (filing date: 2015-05-05), 10-K (filing date: 2015-02-20), 10-Q (filing date: 2014-11-10), 10-Q (filing date: 2014-08-01), 10-Q (filing date: 2014-05-02).

Ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. AT&T Inc.’s current ratio deteriorated from Q4 2018 to Q1 2019 and from Q1 2019 to Q2 2019.
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. AT&T Inc.’s quick ratio deteriorated from Q4 2018 to Q1 2019 and from Q1 2019 to Q2 2019.
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. AT&T Inc.’s cash ratio improved from Q4 2018 to Q1 2019 and from Q1 2019 to Q2 2019.

Current Ratio

AT&T Inc., current ratio calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 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
Selected Financial Data (USD $ in millions)
Current assets 47,218  46,472  51,427  53,107  55,286  78,505  79,146  76,357  53,547  45,727  38,369  37,374  36,005  38,001  35,992  34,951  43,163  27,410  32,028  25,835  33,112  24,089 
Current liabilities 66,376  64,652  64,420  65,420  68,593  70,580  81,389  47,693  48,012  50,690  50,576  47,102  46,465  44,528  47,816  47,938  40,527  37,651  37,282  39,979  43,788  39,830 
Ratio
Current ratio1 0.71 0.72 0.80 0.81 0.81 1.11 0.97 1.60 1.12 0.90 0.76 0.79 0.77 0.85 0.75 0.73 1.07 0.73 0.86 0.65 0.76 0.60
Benchmarks
Current Ratio, Competitors2
Verizon Communications Inc. 0.87 0.87 0.91 0.97 0.96 0.98 0.91 1.07 1.04 1.02 0.87 0.85 0.61 0.71 0.64 0.63 0.70 0.80 1.06 0.92 0.86 0.92

Based on: 10-Q (filing date: 2019-08-05), 10-Q (filing date: 2019-05-06), 10-K (filing date: 2019-02-20), 10-Q (filing date: 2018-11-02), 10-Q (filing date: 2018-08-02), 10-Q (filing date: 2018-05-03), 10-K (filing date: 2018-02-20), 10-Q (filing date: 2017-11-03), 10-Q (filing date: 2017-08-03), 10-Q (filing date: 2017-05-04), 10-K (filing date: 2017-02-17), 10-Q (filing date: 2016-11-03), 10-Q (filing date: 2016-08-04), 10-Q (filing date: 2016-05-05), 10-K (filing date: 2016-02-18), 10-Q (filing date: 2015-11-06), 10-Q (filing date: 2015-08-07), 10-Q (filing date: 2015-05-05), 10-K (filing date: 2015-02-20), 10-Q (filing date: 2014-11-10), 10-Q (filing date: 2014-08-01), 10-Q (filing date: 2014-05-02).

1 Q2 2019 Calculation
Current ratio = Current assets ÷ Current liabilities
= 47,218 ÷ 66,376 = 0.71

2 Click competitor name to see calculations.

Ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. AT&T Inc.’s current ratio deteriorated from Q4 2018 to Q1 2019 and from Q1 2019 to Q2 2019.

Quick Ratio

AT&T Inc., quick ratio calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 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
Selected Financial Data (USD $ in millions)
Cash and cash equivalents 8,423  6,516  5,204  8,657  13,523  48,872  50,498  48,499  25,617  14,884  5,788  5,895  7,208  10,008  5,121  6,202  20,956  4,444  8,603  2,458  11,305  3,611 
Accounts receivable, net of allowances for doubtful accounts 22,381  23,863  26,472  26,312  25,492  16,290  16,522  15,876  14,997  15,078  16,794  16,855  15,830  16,070  16,532  16,329  13,821  13,592  14,527  13,445  13,001  13,120 
Total quick assets 30,804  30,379  31,676  34,969  39,015  65,162  67,020  64,375  40,614  29,962  22,582  22,750  23,038  26,078  21,653  22,531  34,777  18,036  23,130  15,903  24,306  16,731 
 
Current liabilities 66,376  64,652  64,420  65,420  68,593  70,580  81,389  47,693  48,012  50,690  50,576  47,102  46,465  44,528  47,816  47,938  40,527  37,651  37,282  39,979  43,788  39,830 
Ratio
Quick ratio1 0.46 0.47 0.49 0.53 0.57 0.92 0.82 1.35 0.85 0.59 0.45 0.48 0.50 0.59 0.45 0.47 0.86 0.48 0.62 0.40 0.56 0.42
Benchmarks
Quick Ratio, Competitors2
Verizon Communications Inc. 0.70 0.69 0.73 0.78 0.77 0.78 0.77 0.90 0.88 0.79 0.67 0.70 0.47 0.55 0.52 0.50 0.55 0.61 0.90 0.79 0.73 0.62

Based on: 10-Q (filing date: 2019-08-05), 10-Q (filing date: 2019-05-06), 10-K (filing date: 2019-02-20), 10-Q (filing date: 2018-11-02), 10-Q (filing date: 2018-08-02), 10-Q (filing date: 2018-05-03), 10-K (filing date: 2018-02-20), 10-Q (filing date: 2017-11-03), 10-Q (filing date: 2017-08-03), 10-Q (filing date: 2017-05-04), 10-K (filing date: 2017-02-17), 10-Q (filing date: 2016-11-03), 10-Q (filing date: 2016-08-04), 10-Q (filing date: 2016-05-05), 10-K (filing date: 2016-02-18), 10-Q (filing date: 2015-11-06), 10-Q (filing date: 2015-08-07), 10-Q (filing date: 2015-05-05), 10-K (filing date: 2015-02-20), 10-Q (filing date: 2014-11-10), 10-Q (filing date: 2014-08-01), 10-Q (filing date: 2014-05-02).

1 Q2 2019 Calculation
Quick ratio = Total quick assets ÷ Current liabilities
= 30,804 ÷ 66,376 = 0.46

2 Click competitor name to see calculations.

Ratio Description The company
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. AT&T Inc.’s quick ratio deteriorated from Q4 2018 to Q1 2019 and from Q1 2019 to Q2 2019.

Cash Ratio

AT&T Inc., cash ratio calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 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
Selected Financial Data (USD $ in millions)
Cash and cash equivalents 8,423  6,516  5,204  8,657  13,523  48,872  50,498  48,499  25,617  14,884  5,788  5,895  7,208  10,008  5,121  6,202  20,956  4,444  8,603  2,458  11,305  3,611 
Total cash assets 8,423  6,516  5,204  8,657  13,523  48,872  50,498  48,499  25,617  14,884  5,788  5,895  7,208  10,008  5,121  6,202  20,956  4,444  8,603  2,458  11,305  3,611 
 
Current liabilities 66,376  64,652  64,420  65,420  68,593  70,580  81,389  47,693  48,012  50,690  50,576  47,102  46,465  44,528  47,816  47,938  40,527  37,651  37,282  39,979  43,788  39,830 
Ratio
Cash ratio1 0.13 0.10 0.08 0.13 0.20 0.69 0.62 1.02 0.53 0.29 0.11 0.13 0.16 0.22 0.11 0.13 0.52 0.12 0.23 0.06 0.26 0.09
Benchmarks
Cash Ratio, Competitors2
Verizon Communications Inc. 0.05 0.06 0.07 0.07 0.05 0.06 0.06 0.16 0.17 0.16 0.09 0.21 0.08 0.18 0.14 0.12 0.11 0.17 0.40 0.29 0.24 0.14

Based on: 10-Q (filing date: 2019-08-05), 10-Q (filing date: 2019-05-06), 10-K (filing date: 2019-02-20), 10-Q (filing date: 2018-11-02), 10-Q (filing date: 2018-08-02), 10-Q (filing date: 2018-05-03), 10-K (filing date: 2018-02-20), 10-Q (filing date: 2017-11-03), 10-Q (filing date: 2017-08-03), 10-Q (filing date: 2017-05-04), 10-K (filing date: 2017-02-17), 10-Q (filing date: 2016-11-03), 10-Q (filing date: 2016-08-04), 10-Q (filing date: 2016-05-05), 10-K (filing date: 2016-02-18), 10-Q (filing date: 2015-11-06), 10-Q (filing date: 2015-08-07), 10-Q (filing date: 2015-05-05), 10-K (filing date: 2015-02-20), 10-Q (filing date: 2014-11-10), 10-Q (filing date: 2014-08-01), 10-Q (filing date: 2014-05-02).

1 Q2 2019 Calculation
Cash ratio = Total cash assets ÷ Current liabilities
= 8,423 ÷ 66,376 = 0.13

2 Click competitor name to see calculations.

Ratio Description The company
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. AT&T Inc.’s cash ratio improved from Q4 2018 to Q1 2019 and from Q1 2019 to Q2 2019.