Stock Analysis on Net

Phillips 66 (NYSE:PSX)

This company has been moved to the archive! The financial data has not been updated since February 21, 2020.

Analysis of Liquidity Ratios 
Quarterly Data

Microsoft Excel

Liquidity Ratios (Summary)

Phillips 66, liquidity ratios (quarterly data)

Microsoft Excel
Dec 31, 2019 Sep 30, 2019 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
Current ratio 1.24 1.29 1.28 1.31 1.48 1.28 1.24 1.31 1.42 1.31 1.40 1.39 1.34 1.18 1.22 1.51 1.63 1.70 1.64 1.64
Quick ratio 0.87 0.77 0.77 0.76 1.03 0.74 0.77 0.75 1.05 0.80 0.87 0.83 0.96 0.73 0.75 0.87 1.10 1.13 1.16 1.13
Cash ratio 0.14 0.19 0.16 0.11 0.34 0.08 0.16 0.09 0.31 0.16 0.24 0.17 0.29 0.23 0.21 0.23 0.41 0.54 0.51 0.55

Based on: 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-K (reporting date: 2016-12-31), 10-Q (reporting date: 2016-09-30), 10-Q (reporting date: 2016-06-30), 10-Q (reporting date: 2016-03-31), 10-K (reporting date: 2015-12-31), 10-Q (reporting date: 2015-09-30), 10-Q (reporting date: 2015-06-30), 10-Q (reporting date: 2015-03-31).

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Phillips 66 current ratio improved from Q2 2019 to Q3 2019 but then deteriorated significantly from Q3 2019 to Q4 2019.
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. Phillips 66 quick ratio improved from Q2 2019 to Q3 2019 and from Q3 2019 to Q4 2019.
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Phillips 66 cash ratio improved from Q2 2019 to Q3 2019 but then deteriorated significantly from Q3 2019 to Q4 2019.

Current Ratio

Phillips 66, current ratio calculation (quarterly data)

Microsoft Excel
Dec 31, 2019 Sep 30, 2019 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
Selected Financial Data (US$ in millions)
Current assets 14,395 15,617 14,295 14,815 13,209 15,314 14,579 12,125 14,390 12,935 12,456 12,170 12,680 11,964 12,643 11,216 12,256 15,049 16,534 16,144
Current liabilities 11,646 12,083 11,171 11,328 8,935 11,974 11,732 9,236 10,107 9,905 8,874 8,730 9,463 10,100 10,400 7,419 7,531 8,875 10,075 9,864
Liquidity Ratio
Current ratio1 1.24 1.29 1.28 1.31 1.48 1.28 1.24 1.31 1.42 1.31 1.40 1.39 1.34 1.18 1.22 1.51 1.63 1.70 1.64 1.64
Benchmarks
Current Ratio, Competitors2
Chevron Corp. 1.07 1.12 1.15 1.12
ConocoPhillips 2.40 2.56 1.76 1.86
Exxon Mobil Corp. 0.78 0.78 0.74 0.77
Marathon Petroleum Corp. 1.25 1.25 1.24 1.20
Occidental Petroleum Corp. 1.25 1.33 1.20 1.23
Valero Energy Corp. 1.44 1.40 1.42 1.43

Based on: 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-K (reporting date: 2016-12-31), 10-Q (reporting date: 2016-09-30), 10-Q (reporting date: 2016-06-30), 10-Q (reporting date: 2016-03-31), 10-K (reporting date: 2015-12-31), 10-Q (reporting date: 2015-09-30), 10-Q (reporting date: 2015-06-30), 10-Q (reporting date: 2015-03-31).

1 Q4 2019 Calculation
Current ratio = Current assets ÷ Current liabilities
= 14,395 ÷ 11,646 = 1.24

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. Phillips 66 current ratio improved from Q2 2019 to Q3 2019 but then deteriorated significantly from Q3 2019 to Q4 2019.

Quick Ratio

Phillips 66, quick ratio calculation (quarterly data)

Microsoft Excel
Dec 31, 2019 Sep 30, 2019 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
Selected Financial Data (US$ in millions)
Cash and cash equivalents 1,614 2,268 1,819 1,253 3,019 924 1,884 842 3,119 1,547 2,161 1,513 2,711 2,337 2,232 1,723 3,074 4,822 5,089 5,390
Accounts and notes receivable, net of allowances 7,376 6,097 5,748 6,476 5,414 6,840 6,006 5,399 6,424 5,421 4,750 4,979 5,485 4,101 4,610 3,991 4,411 4,315 5,377 4,717
Accounts and notes receivable, related parties 1,134 989 979 827 759 1,131 1,167 725 1,082 934 844 711 912 900 987 746 762 883 1,190 1,020
Total quick assets 10,124 9,354 8,546 8,556 9,192 8,895 9,057 6,966 10,625 7,902 7,755 7,203 9,108 7,338 7,829 6,460 8,247 10,020 11,656 11,127
 
Current liabilities 11,646 12,083 11,171 11,328 8,935 11,974 11,732 9,236 10,107 9,905 8,874 8,730 9,463 10,100 10,400 7,419 7,531 8,875 10,075 9,864
Liquidity Ratio
Quick ratio1 0.87 0.77 0.77 0.76 1.03 0.74 0.77 0.75 1.05 0.80 0.87 0.83 0.96 0.73 0.75 0.87 1.10 1.13 1.16 1.13
Benchmarks
Quick Ratio, Competitors2
Chevron Corp. 0.72 0.82 0.80 0.79
ConocoPhillips 1.93 2.30 1.35 1.65
Exxon Mobil Corp. 0.47 0.48 0.45 0.48
Marathon Petroleum Corp. 0.58 0.59 0.59 0.51
Occidental Petroleum Corp. 0.63 0.68 0.89 0.94
Valero Energy Corp. 0.87 0.84 0.88 0.86

Based on: 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-K (reporting date: 2016-12-31), 10-Q (reporting date: 2016-09-30), 10-Q (reporting date: 2016-06-30), 10-Q (reporting date: 2016-03-31), 10-K (reporting date: 2015-12-31), 10-Q (reporting date: 2015-09-30), 10-Q (reporting date: 2015-06-30), 10-Q (reporting date: 2015-03-31).

1 Q4 2019 Calculation
Quick ratio = Total quick assets ÷ Current liabilities
= 10,124 ÷ 11,646 = 0.87

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. Phillips 66 quick ratio improved from Q2 2019 to Q3 2019 and from Q3 2019 to Q4 2019.

Cash Ratio

Phillips 66, cash ratio calculation (quarterly data)

Microsoft Excel
Dec 31, 2019 Sep 30, 2019 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
Selected Financial Data (US$ in millions)
Cash and cash equivalents 1,614 2,268 1,819 1,253 3,019 924 1,884 842 3,119 1,547 2,161 1,513 2,711 2,337 2,232 1,723 3,074 4,822 5,089 5,390
Total cash assets 1,614 2,268 1,819 1,253 3,019 924 1,884 842 3,119 1,547 2,161 1,513 2,711 2,337 2,232 1,723 3,074 4,822 5,089 5,390
 
Current liabilities 11,646 12,083 11,171 11,328 8,935 11,974 11,732 9,236 10,107 9,905 8,874 8,730 9,463 10,100 10,400 7,419 7,531 8,875 10,075 9,864
Liquidity Ratio
Cash ratio1 0.14 0.19 0.16 0.11 0.34 0.08 0.16 0.09 0.31 0.16 0.24 0.17 0.29 0.23 0.21 0.23 0.41 0.54 0.51 0.55
Benchmarks
Cash Ratio, Competitors2
Chevron Corp. 0.22 0.39 0.30 0.29
ConocoPhillips 1.45 1.69 0.95 1.12
Exxon Mobil Corp. 0.05 0.08 0.06 0.07
Marathon Petroleum Corp. 0.09 0.10 0.08 0.06
Occidental Petroleum Corp. 0.20 0.31 0.22 0.23
Valero Energy Corp. 0.20 0.18 0.16 0.22

Based on: 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-K (reporting date: 2016-12-31), 10-Q (reporting date: 2016-09-30), 10-Q (reporting date: 2016-06-30), 10-Q (reporting date: 2016-03-31), 10-K (reporting date: 2015-12-31), 10-Q (reporting date: 2015-09-30), 10-Q (reporting date: 2015-06-30), 10-Q (reporting date: 2015-03-31).

1 Q4 2019 Calculation
Cash ratio = Total cash assets ÷ Current liabilities
= 1,614 ÷ 11,646 = 0.14

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. Phillips 66 cash ratio improved from Q2 2019 to Q3 2019 but then deteriorated significantly from Q3 2019 to Q4 2019.