Liquidity Analysis
Quarterly Data

Difficulty: Beginner


Ratios (Summary)

ConocoPhillips, liquidity ratios (quarterly data)

Microsoft Excel LibreOffice Calc
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 1.75 1.85 1.76 2.38 2.00 1.43 1.25 1.28 1.26 1.24 0.95 1.17 1.37 1.13 1.31 1.15 1.16 1.19 1.26 1.38 1.35 1.32
Quick ratio 1.50 1.58 1.53 2.11 1.51 0.89 1.02 1.01 1.02 1.03 0.74 0.83 1.03 0.84 1.03 0.94 0.90 0.96 0.99 0.75 0.74 0.78
Cash ratio 0.90 0.99 1.07 1.64 1.19 0.45 0.53 0.57 0.57 0.59 0.26 0.29 0.44 0.28 0.44 0.41 0.40 0.45 0.43 0.24 0.24 0.30
Source: Based on data from ConocoPhillips Quarterly and Annual Reports
Ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. ConocoPhillips's current ratio improved from Q4 2017 to Q1 2018 but then deteriorated significantly from Q1 2018 to Q2 2018.
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. ConocoPhillips's quick ratio improved from Q4 2017 to Q1 2018 but then deteriorated significantly from Q1 2018 to Q2 2018.
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. ConocoPhillips's cash ratio deteriorated from Q4 2017 to Q1 2018 and from Q1 2018 to Q2 2018.

Current Ratio

ConocoPhillips, current ratio calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 11,608  13,187  16,512  16,954  19,879  10,728  8,609  9,641  9,259  10,934  8,789  9,664  11,944  10,840  15,068  16,253  18,836  20,400  19,023  22,557  22,602  24,235 
Current liabilities 6,638  7,109  9,397  7,131  9,926  7,526  6,909  7,537  7,348  8,825  9,256  8,287  8,734  9,563  11,537  14,141  16,191  17,117  15,129  16,335  16,715  18,315 
Ratio
Current ratio1 1.75 1.85 1.76 2.38 2.00 1.43 1.25 1.28 1.26 1.24 0.95 1.17 1.37 1.13 1.31 1.15 1.16 1.19 1.26 1.38 1.35 1.32
Source: Based on data from ConocoPhillips Quarterly and Annual Reports

Q2 2018 Calculations

1 Current ratio = Current assets ÷ Current liabilities
= 11,608 ÷ 6,638 = 1.75

Ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. ConocoPhillips's current ratio improved from Q4 2017 to Q1 2018 but then deteriorated significantly from Q1 2018 to Q2 2018.

Quick Ratio

ConocoPhillips, quick ratio calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 3,234  4,984  6,325  6,911  7,534  3,109  3,610  4,090  2,863  4,866  2,368  2,413  3,813  2,664  5,062  5,408  6,142  7,520  6,246  3,883  3,909  5,422 
Short-term investments 612  288  1,873  2,696  2,733  252  50  234  1,289  307  374  288  210  272  75  23 
Accounts and notes receivable, net of allowance 3,750  4,032  4,179  3,222  3,020  3,105  3,249  3,163  3,144  3,753  4,314  4,332  5,044  5,246  6,675  7,255  7,983  8,438  8,273  8,191  8,214  8,703 
Accounts and notes receivable, related parties 180  160  141  142  143  254  165  157  172  201  200  132  135  133  132  198  221  213  214  214  206  195 
Investment in Cenovus Energy 2,159  1,776  1,899  2,084  1,533 
Total quick assets 9,935  11,240  14,417  15,055  14,963  6,720  7,074  7,644  7,468  9,127  6,882  6,877  8,992  8,043  11,869  13,235  14,634  16,381  15,005  12,288  12,404  14,343 
Current liabilities 6,638  7,109  9,397  7,131  9,926  7,526  6,909  7,537  7,348  8,825  9,256  8,287  8,734  9,563  11,537  14,141  16,191  17,117  15,129  16,335  16,715  18,315 
Ratio
Quick ratio1 1.50 1.58 1.53 2.11 1.51 0.89 1.02 1.01 1.02 1.03 0.74 0.83 1.03 0.84 1.03 0.94 0.90 0.96 0.99 0.75 0.74 0.78
Source: Based on data from ConocoPhillips Quarterly and Annual Reports

Q2 2018 Calculations

1 Quick ratio = Total quick assets ÷ Current liabilities
= 9,935 ÷ 6,638 = 1.50

Ratio Description The company
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. ConocoPhillips's quick ratio improved from Q4 2017 to Q1 2018 but then deteriorated significantly from Q1 2018 to Q2 2018.

Cash Ratio

ConocoPhillips, cash ratio calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 3,234  4,984  6,325  6,911  7,534  3,109  3,610  4,090  2,863  4,866  2,368  2,413  3,813  2,664  5,062  5,408  6,142  7,520  6,246  3,883  3,909  5,422 
Short-term investments 612  288  1,873  2,696  2,733  252  50  234  1,289  307  374  288  210  272  75  23 
Investment in Cenovus Energy 2,159  1,776  1,899  2,084  1,533 
Total cash assets 6,005  7,048  10,097  11,691  11,800  3,361  3,660  4,324  4,152  5,173  2,368  2,413  3,813  2,664  5,062  5,782  6,430  7,730  6,518  3,883  3,984  5,445 
Current liabilities 6,638  7,109  9,397  7,131  9,926  7,526  6,909  7,537  7,348  8,825  9,256  8,287  8,734  9,563  11,537  14,141  16,191  17,117  15,129  16,335  16,715  18,315 
Ratio
Cash ratio1 0.90 0.99 1.07 1.64 1.19 0.45 0.53 0.57 0.57 0.59 0.26 0.29 0.44 0.28 0.44 0.41 0.40 0.45 0.43 0.24 0.24 0.30
Source: Based on data from ConocoPhillips Quarterly and Annual Reports

Q2 2018 Calculations

1 Cash ratio = Total cash assets ÷ Current liabilities
= 6,005 ÷ 6,638 = 0.90

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