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

PSX Stock Annual Balance Sheet. Download in Excel

Phillips 66 logo

Phillips 66

Sector: Energy   

Industry: Oil & Gas Refining & Marketing

131.41
 
USD
  
-0.04
  
(-0.03%)
Previous close: 131.45  Open: 131.62  Bid: 131.01  Ask: 131.4
52 week range    
117.32   
   174.08
Mkt Cap: 54,077 M  Avg Vol (90 Days): 2,664,817
Peers   
MPC / 
HFC / 
VLO / 
XOM / 
CVX / 
Last updated: Friday 22nd November 2024

Stock Rankings

67
MarketXLS Rank
100
Value
53
Technical
50
Quality
How are these ranks calculated?
Ad slot not ready
Search for a stock

Financials

PSX Balance Sheet

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
Accounts payable8,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 M10,985 M11,730 M
Accrued expenses8,942 M6,533 M7,866 M9,029 M7,702 M9,554 M6,900 M9,715 M1,397 M1,200 M
Accumulated depreciation & depletion-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-19,480 M
Additional paid in capital19,040 M19,145 M19,559 M19,768 M19,873 M20,301 M20,383 M20,504 M19,791 M19,650 M
Cash and equivalents5,207 M3,074 M2,711 M3,119 M3,019 M1,614 M2,514 M3,147 M6,133 M3,323 M
CashCashEquivalentsAndShortTermInvestments5,207 M3,074 M2,711 M3,119 M3,019 M1,614 M2,514 M3,147 M6,133 M3,323 M
CashEquivalents5,207 M3,074 M2,711 M3,119 M3,019 M1,614 M2,514 M
Common par6 M6 M6 M6 M6 M6 M6 M7 M7 M7 M
Common stock equity21,590 M23,100 M22,390 M25,085 M24,653 M24,910 M18,984 M19,166 M29,494 M30,583 M
CommonStock6 M6 M6 M6 M6 M6 M6 M7 M7 M7 M
Cost in excess3,274 M3,275 M3,270 M3,270 M3,270 M3,270 M1,425 M1,484 M1,486 M1,550 M
CurrentCapitalLeaseObligation210 M208 M188 M192 M184 M455 M369 M343 M282 M362 M
CurrentDeferredTaxesAssets1,029 M1,209 M1,292 M560 M571 M986 M1,083 M994 M793 M895 M
CurrentDeferredTaxesLiabilities6,426 M7,089 M7,943 M5,477 M5,797 M6,491 M6,673 M6,436 M7,375 M8,195 M
EmployeeBenefits1,767 M1,861 M1,743 M1,466 M1,591 M1,754 M1,914 M1,693 M1,701 M1,493 M
Float term debt7,793 M8,843 M9,588 M10,069 M11,093 M11,216 M14,906 M12,959 M16,661 M17,877 M
GoodwillAndOtherIntangibleAssets4,174 M4,181 M4,158 M4,146 M4,139 M4,139 M2,268 M2,297 M2,317 M2,470 M
Gross fixed assets (Plant Property & Equipment)27,145 M30,310 M31,989 M33,742 M35,197 M38,071 M40,223 M39,797 M52,990 M55,192 M
IncomeTaxPayable878 M878 M805 M1,002 M1,116 M979 M1,351 M
Intangibles900 M906 M888 M876 M869 M869 M843 M813 M831 M920 M
Inventories3,397 M3,477 M3,150 M3,395 M3,543 M3,776 M3,893 M3,394 M3,276 M3,750 M
Invested capital37,176 M40,786 M41,566 M45,223 M46,839 M47,342 M48,796 M45,084 M62,816 M66,337 M
Leases284 M264 M259 M259 M298 M
LongTermCapitalLeaseObligation8,684 M8,887 M10,138 M10,110 M11,160 M1,261 M1,222 M1,068 M1,027 M1,152 M
LongTermDebtAndCapitalLeaseObligation7,793 M8,843 M9,588 M10,069 M11,093 M11,216 M14,906 M12,959 M16,661 M17,877 M
LongTermProvisions683 M665 M655 M641 M624 M638 M657 M727 M879 M864 M
Minority interest447 M838 M1,335 M2,343 M2,500 M2,259 M2,539 M2,471 M4,612 M1,067 M
Net fixed assets (net PP&E)17,346 M19,721 M20,855 M21,460 M22,018 M23,786 M23,716 M22,435 M35,163 M35,712 M
Non-current deferred income taxes5,491 M6,041 M6,743 M5,008 M5,275 M5,553 M5,644 M5,475 M6,671 M7,424 M
NonCurrentAccountsReceivable76 M84 M334 M94 M97 M157 M442 M959 M329 M379 M
NonCurrentDeferredLiabilities5,780 M6,318 M7,006 M5,242 M5,630 M7,007 M6,776 M6,415 M7,970 M8,624 M
NonCurrentDeferredTaxesAssets1,136 M1,369 M1,330 M588 M579 M1,008 M1,123 M1,068 M890 M1,016 M
NonCurrentPensionAndOtherPostretirementBenefitPlans1,305 M1,285 M1,216 M884 M867 M1,044 M1,341 M1,055 M937 M630 M
NotesReceivable6,306 M4,411 M5,485 M
Other current assets142 M82 M70 M34 M23 M40 M56 M54 M54 M116 M
Other equity adjustments-531 M-653 M-995 M-617 M-692 M-788 M-789 M
Other fixed assets17,346 M19,721 M20,855 M21,460 M22,018 M23,786 M23,716 M22,435 M35,163 M35,712 M
Other non-current assets10,480 M12,422 M13,960 M14,375 M14,936 M16,400 M15,461 M16,165 M17,040 M17,378 M
Other non-current liabilities9,736 M11,493 M13,709 M13,743 M10,695 M280 M309 M395 M565 M537 M
Other receivable949 M762 M912 M1,082 M759 M1,134 M834 M1,332 M1,488 M
OtherCurrentBorrowings842 M44 M550 M41 M67 M547 M987 M1,489 M529 M1,482 M
OtherCurrentLiabilities848 M378 M520 M455 M442 M835 M1,058 M959 M1,876 M1,410 M
OtherInventories3,141 M3,214 M2,883 M3,106 M3,238 M3,452 M3,536 M3,024 M2,914 M3,330 M
OtherPayable7,488 M5,155 M6,395 M7,242 M6,113 M8,043 M5,171 M
Payables8,942 M6,533 M7,866 M9,029 M7,702 M9,554 M6,900 M9,715 M1,397 M1,200 M
Preferred securities of subsidiary trust500 M500 M500 M500 M500 M500 M500 M
PreferredStock500 M500 M500 M500 M500 M500 M500 M
Prepaid expenses833 M532 M422 M370 M474 M495 M347 M686 M1,528 M1,138 M
RecievablesAdjustmentsAllowances-71 M-55 M-34 M-29 M-22 M-41 M-37 M-44 M-67 M-71 M
Restricted cash2,711 M3,119 M3,019 M
Retained earnings8,778 M11,695 M11,613 M15,689 M19,797 M21,276 M15,711 M15,771 M24,972 M30,268 M
Short term debt842 M44 M550 M41 M67 M547 M987 M1,489 M529 M1,482 M
TaxesReceivable1,500 M400 M
Total assets48,692 M48,580 M51,653 M54,371 M54,302 M58,720 M54,721 M55,594 M76,442 M75,501 M
Total current assets16,692 M12,256 M12,680 M14,390 M13,209 M14,395 M13,276 M14,697 M21,922 M19,941 M
Total current liabilities10,632 M6,955 M8,936 M9,525 M8,211 M10,936 M8,945 M12,801 M15,889 M15,856 M
Total equity21,590 M23,100 M22,390 M25,085 M24,653 M24,910 M18,984 M19,166 M29,494 M30,583 M
Total liabilities26,655 M24,642 M27,928 M26,943 M27,149 M31,551 M33,198 M33,957 M42,336 M43,851 M
Total non-current assets32,000 M36,324 M38,973 M39,981 M41,093 M44,325 M41,445 M40,897 M54,520 M55,560 M
Total non-current liabilities16,023 M17,687 M18,992 M17,418 M18,938 M20,615 M24,253 M21,794 M27,211 M28,858 M
TotalEquityGrossMinority22,037 M23,938 M23,725 M27,428 M27,153 M27,169 M21,523 M21,637 M34,106 M31,650 M
TotalEquityGrossMinorityInterest22,037 M23,938 M23,725 M27,428 M27,153 M27,169 M21,523 M21,637 M34,106 M31,650 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest48,692 M48,580 M51,653 M54,371 M54,302 M58,720 M54,721 M55,594 M76,442 M75,501 M
TotalNonCurrentLiabilitiesNetMinorityInteres16,023 M17,687 M18,992 M17,418 M18,938 M20,615 M24,253 M21,794 M27,211 M28,858 M
TotalTaxPayable878 M878 M805 M1,002 M1,116 M979 M1,351 M1,254 M1,397 M1,200 M
Treasury stock-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-19,342 M
UnearnedIncome23,786 M
UnearnedPremiums45 M-96 M-104 M-108 M-100 M-100 M-106 M-109 M-245 M-167 M
Working capital6,060 M5,301 M3,744 M4,865 M4,998 M3,459 M4,331 M1,896 M6,033 M4,085 M
debtc842 M44 M550 M41 M67 M547 M987 M1,489 M529 M1,482 M
ltinv10,035 M11,977 M13,102 M13,733 M14,218 M14,284 M13,037 M12,832 M14,425 M14,736 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