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

163.34
 
USD
  
4.38
  
(2.76%)
Optionable: Yes  Market Cap: 66,997 M  90-day average vol: 3,177,267

Previous close: 158.96  Open: 159.34  Bid: 162.6  Ask: 163.34
52 week range    
89.74   
   163.79
Peers   
MPC / 
HFC / 
VLO / 
XOM / 
CVX / 
Last updated: Friday 29th March 2024
70
MarketXLS Rank
80
Value
84
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 Balance Sheet

Annual
Dec-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
"""debtc"""24 M842 M44 M550 M41 M67 M547 M987 M1,489 M529 M
Accounts payable11,090 M8,064 M5,655 M7,061 M8,027 M6,586 M8,575 M5,549 M8,461 M11,323 M
Accounts receivable5,485 M6,424 M5,414 M7,376 M5,688 M6,138 M9,497 M
Accrued expenses11,962 M8,942 M6,533 M7,866 M9,029 M7,702 M9,554 M6,900 M9,715 M12,720 M
Accumulated depreciation & depletion-9,028 M-9,799 M-10,589 M-11,134 M-12,282 M-13,179 M-14,285 M-16,507 M-17,362 M-17,827 M
Additional paid in capital18,887 M19,040 M19,145 M19,559 M19,768 M19,873 M20,301 M20,383 M20,504 M19,791 M
Cash and equivalents5,400 M5,207 M3,074 M2,711 M3,119 M3,019 M1,614 M2,514 M3,147 M6,133 M
CashCashEquivalentsAndShortTermInvestments5,400 M5,207 M3,074 M2,711 M3,119 M3,019 M1,614 M2,514 M3,147 M6,133 M
CashEquivalents5,400 M5,207 M3,074 M2,711 M3,119 M3,019 M1,614 M2,514 M3,147 M
Common par6 M6 M6 M6 M6 M6 M6 M6 M7 M7 M
Common stock equity21,950 M21,590 M23,100 M22,390 M25,085 M24,653 M24,910 M18,984 M19,166 M29,494 M
CommonStock6 M6 M6 M6 M6 M6 M6 M6 M7 M7 M
Cost in excess3,096 M3,274 M3,275 M3,270 M3,270 M3,270 M3,270 M1,425 M1,484 M1,486 M
CurrentCapitalLeaseObligation199 M210 M208 M188 M192 M184 M455 M369 M343 M282 M
CurrentDeferredTaxesAssets1,010 M1,029 M1,209 M1,292 M560 M571 M986 M1,083 M994 M793 M
CurrentDeferredTaxesLiabilities6,844 M6,426 M7,089 M7,943 M5,477 M5,797 M6,491 M6,673 M6,436 M7,375 M
EmployeeBenefits1,397 M1,767 M1,861 M1,743 M1,466 M1,591 M1,754 M1,914 M1,693 M1,701 M
Float term debt6,131 M7,793 M8,843 M9,588 M10,069 M11,093 M11,216 M14,906 M12,959 M16,661 M
GoodwillAndOtherIntangibleAssets3,794 M4,174 M4,181 M4,158 M4,146 M4,139 M4,139 M2,268 M2,297 M2,317 M
Gross fixed assets (Plant Property & Equipment)24,426 M27,145 M30,310 M31,989 M33,742 M35,197 M38,071 M40,223 M39,797 M52,990 M
IncomeTaxPayable872 M878 M878 M805 M1,002 M1,116 M979 M1,351 M1,254 M
Intangibles698 M900 M906 M888 M876 M869 M869 M843 M813 M831 M
Inventories3,354 M3,397 M3,477 M3,150 M3,395 M3,543 M3,776 M3,893 M3,394 M3,276 M
Invested capital34,212 M37,176 M40,786 M41,566 M45,223 M46,839 M47,342 M48,796 M45,084 M62,816 M
Leases284 M264 M259 M259 M
LongTermCapitalLeaseObligation6,155 M8,684 M8,887 M10,138 M10,110 M11,160 M1,261 M1,222 M1,068 M1,027 M
LongTermDebtAndCapitalLeaseObligation6,131 M7,793 M8,843 M9,588 M10,069 M11,093 M11,216 M14,906 M12,959 M16,661 M
LongTermProvisions700 M683 M665 M655 M641 M624 M638 M657 M727 M879 M
Minority interest442 M447 M838 M1,335 M2,343 M2,500 M2,259 M2,539 M2,471 M4,612 M
Net fixed assets (net PP&E)15,398 M17,346 M19,721 M20,855 M21,460 M22,018 M23,786 M23,716 M22,435 M35,163 M
Non-current deferred income taxes6,125 M5,491 M6,041 M6,743 M5,008 M5,275 M5,553 M5,644 M5,475 M6,671 M
NonCurrentAccountsReceivable74 M76 M84 M334 M94 M97 M157 M442 M959 M329 M
NonCurrentDeferredLiabilities6,723 M5,780 M6,318 M7,006 M5,242 M5,630 M7,007 M6,776 M6,415 M7,970 M
NonCurrentDeferredTaxesAssets1,137 M1,136 M1,369 M1,330 M588 M579 M1,008 M1,123 M1,068 M890 M
NonCurrentPensionAndOtherPostretirementBenefitPlans921 M1,305 M1,285 M1,216 M884 M867 M1,044 M1,341 M1,055 M937 M
NotesReceivable7,900 M6,306 M4,411 M5,485 M
Number of employees13000.013000.013000.013000.013000.013000.013000.013000.013000.013000.0
Other current assets202 M142 M82 M70 M34 M23 M40 M56 M54 M54 M
Other equity adjustments37 M-531 M-653 M-995 M-617 M-692 M-788 M-789 M-445 M
Other fixed assets15,398 M17,346 M19,721 M20,855 M21,460 M22,018 M23,786 M23,716 M22,435 M35,163 M
Other non-current assets11,369 M10,480 M12,422 M13,960 M14,375 M14,936 M16,400 M15,461 M16,165 M17,040 M
Other non-current liabilities9,959 M9,736 M11,493 M13,709 M13,743 M10,695 M280 M309 M395 M565 M
Other receivable1,732 M949 M762 M912 M1,082 M759 M1,134 M834 M1,332 M1,488 M
OtherCurrentBorrowings24 M842 M44 M550 M41 M67 M547 M987 M1,489 M529 M
OtherCurrentLiabilities469 M848 M378 M520 M455 M442 M835 M1,058 M959 M1,876 M
OtherInventories3,093 M3,141 M3,214 M2,883 M3,106 M3,238 M3,452 M3,536 M3,024 M2,914 M
OtherPayable7,488 M5,155 M6,395 M7,242 M6,113 M8,043 M5,171 M7,629 M
Payables11,962 M8,942 M6,533 M7,866 M9,029 M7,702 M9,554 M6,900 M9,715 M12,720 M
Preferred securities of subsidiary trust500 M500 M500 M500 M500 M500 M500 M500 M500 M
PreferredStock500 M500 M500 M500 M500 M500 M500 M500 M500 M
Prepaid expenses851 M833 M532 M422 M370 M474 M495 M347 M686 M1,528 M
RecievablesAdjustmentsAllowances-47 M-71 M-55 M-34 M-29 M-22 M-41 M-37 M-44 M-67 M
Restricted cash2,711 M3,119 M3,019 M
Retained earnings5,659 M8,778 M11,695 M11,613 M15,689 M19,797 M21,276 M15,711 M15,771 M24,972 M
Short term debt24 M842 M44 M550 M41 M67 M547 M987 M1,489 M529 M
TaxesReceivable1,500 M400 M
Total assets49,798 M48,692 M48,580 M51,653 M54,371 M54,302 M58,720 M54,721 M55,594 M76,442 M
Total current assets19,237 M16,692 M12,256 M12,680 M14,390 M13,209 M14,395 M13,276 M14,697 M21,922 M
Total current liabilities12,455 M10,632 M6,955 M8,936 M9,525 M8,211 M10,936 M8,945 M12,163 M15,125 M
Total equity21,950 M21,590 M23,100 M22,390 M25,085 M24,653 M24,910 M18,984 M19,166 M29,494 M
Total liabilities27,406 M26,655 M24,642 M27,928 M26,943 M27,149 M31,551 M33,198 M33,957 M42,336 M
Total non-current assets30,561 M32,000 M36,324 M38,973 M39,981 M41,093 M44,325 M41,445 M40,897 M54,520 M
Total non-current liabilities14,951 M16,023 M17,687 M18,992 M17,418 M18,938 M20,615 M24,253 M21,794 M27,211 M
TotalEquityGrossMinority22,392 M22,037 M23,938 M23,725 M27,428 M27,153 M27,169 M21,523 M21,637 M34,106 M
TotalEquityGrossMinorityInterest22,392 M22,037 M23,938 M23,725 M27,428 M27,153 M27,169 M21,523 M21,637 M34,106 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest49,798 M48,692 M48,580 M51,653 M54,371 M54,302 M58,720 M54,721 M55,594 M76,442 M
TotalNonCurrentLiabilitiesNetMinorityInteres14,951 M16,023 M17,687 M18,992 M17,418 M18,938 M20,615 M24,253 M21,794 M27,211 M
TotalTaxPayable872 M878 M878 M805 M1,002 M1,116 M979 M1,351 M1,254 M1,397 M
Treasury stock-2,602 M-6,234 M-7,746 M-8,788 M-10,378 M-15,023 M-16,673 M-17,116 M-17,116 M-15,276 M
UnearnedIncome23,786 M
UnearnedPremiums5 M45 M-96 M-104 M-108 M-100 M-100 M-106 M-109 M-245 M
Working capital6,782 M6,060 M5,301 M3,744 M4,865 M4,998 M3,459 M4,331 M2,534 M6,797 M
ltinv11,080 M10,035 M11,977 M13,102 M13,733 M14,218 M14,284 M13,037 M12,832 M14,414 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.

We respect your privacy and will never share your email.
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