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 Long-term (Investment) Activity Ratios
Quarterly Data

Microsoft Excel

Long-term Activity Ratios (Summary)

Phillips 66, long-term (investment) activity 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
Net fixed asset turnover 4.51 4.67 4.88 4.98 5.06 5.18 5.03 4.79 4.77 4.51 4.32 4.23 4.04 4.05 4.29 4.66 5.02
Total asset turnover 1.83 1.83 1.90 1.92 2.05 2.01 1.97 1.98 1.88 1.82 1.78 1.75 1.63 1.65 1.73 1.94 2.04
Equity turnover 4.31 4.32 4.44 4.58 4.52 4.81 4.79 4.70 4.08 4.26 4.11 4.01 3.76 3.61 3.81 4.11 4.28

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).

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Phillips 66 net fixed asset turnover ratio deteriorated from Q2 2019 to Q3 2019 and from Q3 2019 to Q4 2019.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Phillips 66 total asset turnover ratio deteriorated from Q2 2019 to Q3 2019 but then slightly improved from Q3 2019 to Q4 2019.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Phillips 66 equity turnover ratio deteriorated from Q2 2019 to Q3 2019 and from Q3 2019 to Q4 2019.

Net Fixed Asset Turnover

Phillips 66, net fixed asset turnover 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)
Sales and other operating revenues 29,125 27,218 27,847 23,103 29,098 29,788 28,980 23,595 29,746 25,627 24,087 22,894 23,397 21,624 21,849 17,409 21,893 25,792 28,512 22,778
Net properties, plants and equipment 23,786 22,954 22,503 22,263 22,018 21,625 21,465 21,500 21,460 21,303 21,293 21,240 20,855 20,447 20,247 20,075 19,721 19,257 18,765 17,918
Long-term Activity Ratio
Net fixed asset turnover1 4.51 4.67 4.88 4.98 5.06 5.18 5.03 4.79 4.77 4.51 4.32 4.23 4.04 4.05 4.29 4.66 5.02
Benchmarks
Net Fixed Asset Turnover, Competitors2
Chevron Corp. 0.93
ConocoPhillips 0.77
Exxon Mobil Corp. 1.01
Marathon Petroleum Corp. 2.72
Occidental Petroleum Corp. 0.25
Valero Energy Corp. 3.70

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
Net fixed asset turnover = (Sales and other operating revenuesQ4 2019 + Sales and other operating revenuesQ3 2019 + Sales and other operating revenuesQ2 2019 + Sales and other operating revenuesQ1 2019) ÷ Net properties, plants and equipment
= (29,125 + 27,218 + 27,847 + 23,103) ÷ 23,786 = 4.51

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Phillips 66 net fixed asset turnover ratio deteriorated from Q2 2019 to Q3 2019 and from Q3 2019 to Q4 2019.

Total Asset Turnover

Phillips 66, total asset turnover 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)
Sales and other operating revenues 29,125 27,218 27,847 23,103 29,098 29,788 28,980 23,595 29,746 25,627 24,087 22,894 23,397 21,624 21,849 17,409 21,893 25,792 28,512 22,778
Total assets 58,720 58,741 57,781 57,855 54,302 55,884 54,826 52,132 54,371 52,712 51,828 51,405 51,653 50,254 50,361 48,246 48,580 49,415 49,874 49,077
Long-term Activity Ratio
Total asset turnover1 1.83 1.83 1.90 1.92 2.05 2.01 1.97 1.98 1.88 1.82 1.78 1.75 1.63 1.65 1.73 1.94 2.04
Benchmarks
Total Asset Turnover, Competitors2
Chevron Corp. 0.59
ConocoPhillips 0.46
Exxon Mobil Corp. 0.70
Marathon Petroleum Corp. 1.26
Occidental Petroleum Corp. 0.19
Valero Energy Corp. 2.01

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
Total asset turnover = (Sales and other operating revenuesQ4 2019 + Sales and other operating revenuesQ3 2019 + Sales and other operating revenuesQ2 2019 + Sales and other operating revenuesQ1 2019) ÷ Total assets
= (29,125 + 27,218 + 27,847 + 23,103) ÷ 58,720 = 1.83

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Phillips 66 total asset turnover ratio deteriorated from Q2 2019 to Q3 2019 but then slightly improved from Q3 2019 to Q4 2019.

Equity Turnover

Phillips 66, equity turnover 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)
Sales and other operating revenues 29,125 27,218 27,847 23,103 29,098 29,788 28,980 23,595 29,746 25,627 24,087 22,894 23,397 21,624 21,849 17,409 21,893 25,792 28,512 22,778
Stockholders’ equity 24,910 24,857 24,752 24,217 24,653 23,319 22,536 21,923 25,085 22,523 22,368 22,364 22,390 22,905 22,842 22,788 23,100 23,194 22,389 21,760
Long-term Activity Ratio
Equity turnover1 4.31 4.32 4.44 4.58 4.52 4.81 4.79 4.70 4.08 4.26 4.11 4.01 3.76 3.61 3.81 4.11 4.28
Benchmarks
Equity Turnover, Competitors2
Chevron Corp. 0.97
ConocoPhillips 0.93
Exxon Mobil Corp. 1.33
Marathon Petroleum Corp. 3.68
Occidental Petroleum Corp. 0.60
Valero Energy Corp. 4.97

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
Equity turnover = (Sales and other operating revenuesQ4 2019 + Sales and other operating revenuesQ3 2019 + Sales and other operating revenuesQ2 2019 + Sales and other operating revenuesQ1 2019) ÷ Stockholders’ equity
= (29,125 + 27,218 + 27,847 + 23,103) ÷ 24,910 = 4.31

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Phillips 66 equity turnover ratio deteriorated from Q2 2019 to Q3 2019 and from Q3 2019 to Q4 2019.