Microsoft Excel LibreOffice Calc

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
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 Dec 31, 2013 Sep 30, 2013 Jun 30, 2013 Mar 31, 2013
Current ratio 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 0.66 0.51 0.69 0.68
Quick ratio 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 0.46 0.38 0.55 0.54
Cash ratio 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 0.10 0.04 0.15 0.13

Based on: 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), 10-K (filing date: 2014-02-21), 10-Q (filing date: 2013-11-01), 10-Q (filing date: 2013-08-02), 10-Q (filing date: 2013-05-03).

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 Q1 2018 to Q2 2018 but then slightly improved from Q2 2018 to Q3 2018.
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 Q1 2018 to Q2 2018 and from Q2 2018 to Q3 2018.
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. AT&T Inc.'s cash ratio deteriorated from Q1 2018 to Q2 2018 and from Q2 2018 to Q3 2018.

Current Ratio

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

Microsoft Excel LibreOffice Calc
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 Dec 31, 2013 Sep 30, 2013 Jun 30, 2013 Mar 31, 2013
Selected Financial Data (USD $ in millions)
Current assets 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  23,196  18,435  21,428  20,372 
Current liabilities 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  34,995  36,183  31,189  29,786 
Ratio
Current ratio1 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 0.66 0.51 0.69 0.68

Based on: 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), 10-K (filing date: 2014-02-21), 10-Q (filing date: 2013-11-01), 10-Q (filing date: 2013-08-02), 10-Q (filing date: 2013-05-03).

Q3 2018 Calculations

1 Current ratio = Current assets ÷ Current liabilities
= 53,107 ÷ 65,420 = 0.81

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 Q1 2018 to Q2 2018 but then slightly improved from Q2 2018 to Q3 2018.

Quick Ratio

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

Microsoft Excel LibreOffice Calc
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 Dec 31, 2013 Sep 30, 2013 Jun 30, 2013 Mar 31, 2013
Selected Financial Data (USD $ in millions)
Cash and cash equivalents 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  3,339  1,371  4,548  3,875 
Accounts receivable, net of allowances for doubtful accounts 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  12,918  12,444  12,508  12,100 
Total quick assets 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  16,257  13,815  17,056  15,975 
Current liabilities 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  34,995  36,183  31,189  29,786 
Ratio
Quick ratio1 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 0.46 0.38 0.55 0.54

Based on: 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), 10-K (filing date: 2014-02-21), 10-Q (filing date: 2013-11-01), 10-Q (filing date: 2013-08-02), 10-Q (filing date: 2013-05-03).

Q3 2018 Calculations

1 Quick ratio = Total quick assets ÷ Current liabilities
= 34,969 ÷ 65,420 = 0.53

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

Cash Ratio

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

Microsoft Excel LibreOffice Calc
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 Dec 31, 2013 Sep 30, 2013 Jun 30, 2013 Mar 31, 2013
Selected Financial Data (USD $ in millions)
Cash and cash equivalents 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  3,339  1,371  4,548  3,875 
Total cash assets 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  3,339  1,371  4,548  3,875 
Current liabilities 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  34,995  36,183  31,189  29,786 
Ratio
Cash ratio1 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 0.10 0.04 0.15 0.13

Based on: 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), 10-K (filing date: 2014-02-21), 10-Q (filing date: 2013-11-01), 10-Q (filing date: 2013-08-02), 10-Q (filing date: 2013-05-03).

Q3 2018 Calculations

1 Cash ratio = Total cash assets ÷ Current liabilities
= 8,657 ÷ 65,420 = 0.13

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