Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Phillips 66 logo

Phillips 66

Sector: Energy   

Industry: Oil & Gas Refining & Marketing

157.79
 
USD
  
-1.05
  
(-0.66%)
Optionable: Yes  Market Cap: 67,956 M  90-day average vol: 2,987,755

Previous close: 158.84  Open: 157.96  Bid: 157.78  Ask: 157.79
52 week range    
89.74   
   174.08
Peers   
MPC / 
HFC / 
VLO / 
XOM / 
CVX / 
Last updated: Thursday 25th April 2024
57
MarketXLS Rank
80
Value
46
Technical
47
Quality

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
Search for a stock

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord

Financials

PSX Cash Flow

Annual
Dec-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
(Increase) Decrease in inventories38 M-85 M-144 M216 M-176 M-202 M-204 M-71 M511 M74 M
(Increase) Decrease in other current assets318 M
(Increase) Decrease in payables360 M-3,323 M-2,300 M1,579 M1,153 M-1,546 M1,941 M-2,887 M2,925 M1,736 M
(Increase) Decrease in receivables481 M2,226 M2,129 M-1,258 M-1,182 M1,320 M-2,308 M2,023 M-922 M-2,073 M
AssetImpairmentCharge29 M150 M7 M5 M24 M8 M861 M4,252 M1,498 M60 M
CapitalExpenditureReported1,779 M3,773 M5,764 M2,844 M1,832 M2,639 M
Cash at beginning of period3,474 M5,400 M5,207 M3,074 M2,711 M3,119 M3,019 M1,614 M2,514 M3,147 M
Cash at end of period1,657 M412 M-1,206 M2,711 M3,119 M3,019 M1,614 M2,514 M3,147 M6,146 M
Cash flow2,260 M-564 M1,433 M2,963 M3,966 M7,573 M4,808 M2,111 M6,017 M10,813 M
Cash from disc. investing activities-27 M-2 M
CashFlowFromContinuingInvestingActivities-417 M-2,294 M-5,738 M-3,158 M-1,464 M-2,471 M-3,688 M-3,079 M-1,872 M-1,488 M
CashFromDiscontinuedOperatingActivities24 M-704 M
ChangeInAccountPayable360 M-3,323 M-2,300 M1,579 M1,153 M-1,546 M1,941 M-2,887 M2,925 M1,736 M
ChangeInPayablesAndAccruedExpense360 M-3,323 M-2,300 M1,579 M1,153 M-1,546 M1,941 M-2,887 M2,925 M1,736 M
ChangeInPrepaidAssets20 M-316 M324 M-147 M104 M-113 M-14 M92 M-339 M-249 M
ChangeInWorkingCapital899 M-1,498 M9 M390 M217 M-541 M-585 M-843 M2,119 M68 M
CommonStockDividendPaid-807 M-1,062 M-1,172 M-1,282 M-1,395 M-1,436 M-1,811 M-1,864 M-1,585 M-1,793 M
CommonStockPayments-2,240 M-2,281 M-1,531 M-1,008 M-1,555 M-4,645 M-1,650 M-443 M-1,513 M
Current deferred income taxes594 M-488 M529 M612 M-1,886 M252 M183 M126 M-272 M1,320 M
Deferred income taxes594 M-488 M529 M612 M-1,886 M252 M183 M126 M-272 M1,320 M
Depreciation947 M995 M1,078 M1,168 M1,318 M1,356 M1,341 M1,395 M1,605 M1,629 M
Depreciation unreconciled947 M995 M1,078 M1,168 M1,318 M1,356 M1,341 M1,395 M1,605 M1,629 M
DepreciationAndAmortization947 M995 M1,078 M1,168 M1,318 M1,356 M1,341 M1,395 M1,605 M1,629 M
EarningsLossesFromEquityInvestments-354 M197 M185 M-815 M-516 M221 M-143 M334 M-128 M-1,308 M
Effect of exchange rate changes22 M-64 M9 M10 M17 M-35 M-14 M77 M-42 M49 M
FinancingCashFlow-3,679 M-1,362 M-2,117 M-178 M-2,111 M-5,167 M-2,511 M1,791 M-3,470 M-6,388 M
Free cash flow505 M-5,041 M-4,331 M119 M2,134 M7,573 M4,894 M2,162 M6,044 M10,817 M
GainLossOnSaleOfBusiness-3,013 M
GainLossOnSaleOfPPE-108 M-7 M-7 M
Issuance of capital stock404 M384 M972 M1,205 M167 M205 M10 M26 M103 M
IssuanceOfCapitalStock404 M384 M972 M1,205 M167 M205 M10 M26 M103 M
IssuanceOfDebt-1,020 M2,438 M243 M1,257 M-170 M1,040 M476 M4,127 M-1,511 M-2,430 M
Net cash from financing activities-3,679 M-1,362 M-2,117 M-178 M-2,111 M-5,167 M-2,511 M1,791 M-3,470 M-6,388 M
Net cash from investing activities-444 M-2,294 M-5,738 M-3,158 M-1,464 M-2,471 M-3,688 M-3,079 M-1,872 M-1,488 M
Net cash from operating activities2,284 M-1,268 M1,433 M2,963 M3,966 M7,573 M4,808 M2,111 M6,017 M10,813 M
Net change in cash & cash equivalents-1,817 M-4,988 M-6,413 M-363 M408 M-100 M-1,405 M900 M675 M2,950 M
Net income from continuing operations1,745 M4,973 M6,122 M3,112 M-3,197 M1,594 M11,391 M
NetBusinessPurchaseAndSale267 M125 M
NetCommonStockIssuance-1,836 M-2,281 M-1,147 M-36 M-350 M-4,478 M-1,445 M-433 M26 M-1,410 M
NetIntangiblesPurchaseAndSale-1,779 M-3,773 M-5,764 M-2,844 M-1,832 M-2,639 M
NetInvestmentPropertiesPurchaseAndSale1,362 M1,479 M26 M-314 M368 M111 M99 M-210 M-39 M702 M
NetInvestmentPurchaseAndSale1,362 M1,479 M26 M-314 M368 M111 M99 M-210 M-39 M702 M
NetIssuancePaymentsOfDebt-1,020 M2,438 M243 M1,257 M-170 M1,040 M476 M4,127 M-1,511 M-2,430 M
NetLongTermDebtIssuance-1,020 M2,438 M243 M1,257 M-170 M1,040 M476 M4,127 M-1,511 M-2,430 M
NetPPEPurchaseAndSale86 M51 M27 M4 M
Operating (gains) losses-354 M197 M185 M-815 M-516 M221 M-143 M226 M-135 M-1,315 M
Other financing charges net-16 M-457 M-41 M-117 M-196 M-293 M269 M-39 M-76 M-570 M
Other investing changes net1,427 M1,482 M76 M118 M378 M111 M99 M-210 M-279 M581 M
Other non-cash items174 M230 M-368 M-137 M-140 M163 M900 M4,404 M-27 M-2,773 M
Payment of cash dividends807 M1,062 M1,172 M1,282 M1,395 M1,436 M1,811 M1,864 M1,585 M1,793 M
Purchase of Float term investments-65 M-3 M-50 M-432 M-10 M-1000000.0
Purchase of property plant & equipment-1,779 M-3,773 M-5,764 M-2,844 M-1,832 M-2,639 M86 M51 M-1,860 M-2,194 M
Purchase of short term investments2,487 M1,169 M2,090 M3,508 M2,184 M1,783 M5,178 M1,443 M453 M
PurchaseOfIntangibles-1,779 M-3,773 M-5,764 M-2,844 M-1,832 M-2,639 M
PurchaseOfInvestment-65 M-3 M-50 M-432 M-10 M-1000000.0
Repayment of debt-1,020 M-49 M-926 M-833 M-3,678 M-1,144 M-1,307 M-1,051 M-2,954 M-2,883 M
RepaymentOfDebt-1,020 M-49 M-926 M-833 M-3,678 M-1,144 M-1,307 M-1,051 M-2,954 M-2,883 M
Repurchase of capital stock-2,240 M-2,281 M-1,531 M-1,008 M-1,555 M-4,645 M-1,650 M-443 M-1,513 M
SaleOfBusiness267 M125 M
SaleOfPPE86 M51 M27 M4 M
UnrealizedGainLossOnInvestmentSecurities-365 M433 M
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

MarketXLS is a complete Excel stock solution

Kevin Hsu

StockKevin.com

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.

Dave

Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University