Stock Analysis on Net
Stock Analysis on Net
Microsoft Excel LibreOffice Calc

AT&T Inc. (NYSE:T)

Analysis of Liquidity Ratios

Beginner level

Liquidity Ratios (Summary)

AT&T Inc., liquidity ratios

Microsoft Excel LibreOffice Calc
Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016
Current ratio 0.82 0.79 0.80 0.97 0.76
Quick ratio 0.47 0.50 0.49 0.82 0.45
Cash ratio 0.15 0.18 0.08 0.62 0.11

Based on: 10-K (filing date: 2021-02-25), 10-K (filing date: 2020-02-20), 10-K (filing date: 2019-02-20), 10-K (filing date: 2018-02-20), 10-K (filing date: 2017-02-17).

Liquidity 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 2018 to 2019 but then improved from 2019 to 2020 exceeding 2018 level.
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 improved from 2018 to 2019 but then deteriorated significantly from 2019 to 2020.
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 2018 to 2019 but then slightly deteriorated from 2019 to 2020.

Current Ratio

AT&T Inc., current ratio calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016
Selected Financial Data (US$ in millions)
Current assets 52,008  54,761  51,427  79,146  38,369 
Current liabilities 63,438  68,911  64,420  81,389  50,576 
Liquidity Ratio
Current ratio1 0.82 0.79 0.80 0.97 0.76
Benchmarks
Current Ratio, Competitors2
T-Mobile US Inc. 1.10 0.74 0.81 0.77 1.58
Verizon Communications Inc. 1.38 0.84 0.91 0.91 0.87
Current Ratio, Sector
Telecommunication Services 1.05 0.80 0.84 0.94 0.88
Current Ratio, Industry
Communication Services 1.71 1.46 1.53 1.58 1.61

Based on: 10-K (filing date: 2021-02-25), 10-K (filing date: 2020-02-20), 10-K (filing date: 2019-02-20), 10-K (filing date: 2018-02-20), 10-K (filing date: 2017-02-17).

1 2020 Calculation
Current ratio = Current assets ÷ Current liabilities
= 52,008 ÷ 63,438 = 0.82

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. AT&T Inc.’s current ratio deteriorated from 2018 to 2019 but then improved from 2019 to 2020 exceeding 2018 level.

Quick Ratio

AT&T Inc., quick ratio calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016
Selected Financial Data (US$ in millions)
Cash and cash equivalents 9,740  12,130  5,204  50,498  5,788 
Accounts receivable, net of related allowance for credit loss 20,215  22,636  26,472  16,522  16,794 
Total quick assets 29,955  34,766  31,676  67,020  22,582 
 
Current liabilities 63,438  68,911  64,420  81,389  50,576 
Liquidity Ratio
Quick ratio1 0.47 0.50 0.49 0.82 0.45
Benchmarks
Quick Ratio, Competitors2
T-Mobile US Inc. 0.84 0.48 0.54 0.47 1.04
Verizon Communications Inc. 1.16 0.62 0.73 0.77 0.67
Quick Ratio, Sector
Telecommunication Services 0.76 0.54 0.58 0.78 0.58
Quick Ratio, Industry
Communication Services 1.51 1.24 1.29 1.40 1.33

Based on: 10-K (filing date: 2021-02-25), 10-K (filing date: 2020-02-20), 10-K (filing date: 2019-02-20), 10-K (filing date: 2018-02-20), 10-K (filing date: 2017-02-17).

1 2020 Calculation
Quick ratio = Total quick assets ÷ Current liabilities
= 29,955 ÷ 63,438 = 0.47

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. AT&T Inc.’s quick ratio improved from 2018 to 2019 but then deteriorated significantly from 2019 to 2020.

Cash Ratio

AT&T Inc., cash ratio calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016
Selected Financial Data (US$ in millions)
Cash and cash equivalents 9,740  12,130  5,204  50,498  5,788 
Total cash assets 9,740  12,130  5,204  50,498  5,788 
 
Current liabilities 63,438  68,911  64,420  81,389  50,576 
Liquidity Ratio
Cash ratio1 0.15 0.18 0.08 0.62 0.11
Benchmarks
Cash Ratio, Competitors2
T-Mobile US Inc. 0.48 0.12 0.12 0.11 0.61
Verizon Communications Inc. 0.56 0.06 0.07 0.06 0.09
Cash Ratio, Sector
Telecommunication Services 0.34 0.13 0.08 0.43 0.16
Cash Ratio, Industry
Communication Services 1.06 0.80 0.80 0.99 0.88

Based on: 10-K (filing date: 2021-02-25), 10-K (filing date: 2020-02-20), 10-K (filing date: 2019-02-20), 10-K (filing date: 2018-02-20), 10-K (filing date: 2017-02-17).

1 2020 Calculation
Cash ratio = Total cash assets ÷ Current liabilities
= 9,740 ÷ 63,438 = 0.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. AT&T Inc.’s cash ratio improved from 2018 to 2019 but then slightly deteriorated from 2019 to 2020.