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

Sector:    

Industry: 

 
USD
  
  
()
Optionable:   Market Cap:   90-day average vol:

Previous close:   Open:   Bid:   Ask:
52 week range    
   
   

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

Metrics

Valuation

Returns

Risk

Ranks

Dividends

Analyst Estimates

Financial Health

Technicals

Growth

Profitability

Peers

StockDividendMarket Cap (B)PEPrice ($)
Financials

PSX Income Statement

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
AccruedPreferredStockDividends7 M
AllowancesForConstruction-15,335 M-14,360 M-13,698 M
Amortization of intangibles18 M21 M14 M17 M27 M26 M27 M33 M
Basic EPS from continuing operations15.557.782.949.911.876.8-9.062.9723.3615.56
Basic EPS total16.87.782.949.911.876.8-9.062.9723.3615.56
Basic weighted shares outstanding566 M542 M528 M515 M471 M451 M440 M440 M471 M450 M
BasicDiscontinuousOperations1.25
Cost of sales79,409 M97,930 M95,529 M57,707 M103,707 M151,561 M130,063 M
Depreciation995 M1,078 M1,168 M1,318 M1,356 M1,341 M1,395 M1,605 M1,629 M1,977 M
Depreciation unreconciled995 M1,078 M1,168 M1,318 M1,356 M1,341 M1,395 M1,605 M1,629 M1,977 M
Diluted EPS total16.667.732.929.8511.86.77-9.062.9723.2715.48
Diluted normalized net income/share15.437.732.929.8511.86.77-9.062.9723.2715.48
Diluted weighted shares outstanding572 M547 M530 M519 M474 M454 M440 M440 M474 M453 M
DilutedDiscontinuousOperations1.23
Dividends paid per share3.13.53.63.623.834.2
Earnings from equity interest2,466 M1,573 M1,414 M1,732 M2,676 M2,127 M1,191 M2,904 M2,968 M2,017 M
EarningsFromEquityInterestNetOfTax2,466 M1,573 M1,414 M1,732 M2,676 M2,127 M1,191 M2,904 M2,968 M2,017 M
ExciseTaxes14,698 M13,780 M13,381 M13,054 M
GainOnSaleOfBusiness3,013 M
GainsLossOnDisposalOfDiscontinuedOperations706 M
GeneralAndAdministrativeExpense443 M511 M580 M613 M603 M
Gross operating profit161,212 M98,975 M84,279 M22,945 M13,531 M11,764 M6,422 M7,769 M18,429 M17,336 M
ImpairmentOfCapitalAssets150 M7 M5 M24 M8 M861 M4,252 M1,498 M60 M24 M
Income before tax5,745 M6,044 M78,337 M96,411 M105,781 M99,687 M52,635 M103,824 M164,564 M137,440 M
Income restructuring and M&A160 M177 M
Income taxes1,654 M1,764 M547 M-1,693 M1,572 M801 M-1,250 M146 M3,248 M2,230 M
Interest income21 M27 M18 M31 M45 M43 M14 M11 M82 M269 M
InterestExpenseNonOperating267 M310 M338 M438 M504 M458 M499 M605 M642 M926 M
MinorityInterests-35 M-53 M13,609 M13,335 M166 M-281 M-153 M-279 M-367 M-224 M
MiscOtherSpecialCharges96 M97 M53 M499 M38 M96 M44 M430 M2,714 M330 M
Net income from total operations4,762 M4,227 M1,555 M5,106 M5,595 M3,076 M-3,975 M1,315 M11,024 M7,015 M
NetIncomeCommonStockholders170,590 M105,780 M91,399 M111,439 M104,375 M98,605 M53,732 M1,306 M11,014 M7,004 M
NetIncomeContinuousOperations4,762 M4,227 M1,555 M5,106 M5,595 M3,076 M-3,975 M1,317 M11,024 M7,015 M
NetIncomeDiscontinuousOperations706 M
NetNonOperatingInterestIncomeExpense-267 M-310 M-338 M-438 M-504 M-458 M-499 M-581 M-619 M-897 M
Normalized income4,015 M3,936 M50,924 M94,742 M83,575 M79,614 M55,637 M
Operating income154,119 M91,933 M77,198 M94,642 M103,548 M98,788 M56,163 M102,570 M159,552 M136,036 M
Operating income before depreciation (EBITDA)7,007 M7,432 M79,843 M98,167 M107,641 M101,486 M54,529 M3,950 M16,910 M12,372 M
OperatingExpense7,093 M7,042 M7,081 M7,712 M7,913 M8,505 M7,966 M8,906 M10,438 M11,363 M
Other income net-17,897 M-16,030 M-1,467 M-2,231 M-2,714 M-2,223 M-1,235 M-3,334 M-5,682 M-2,347 M
OtherGandA443 M511 M580 M613 M603 M
OtherImpairmentOfCapitalAssets131 M
OtherOperatingExpenses4,435 M4,294 M4,275 M4,699 M4,880 M5,074 M4,563 M5,147 M6,111 M6,154 M
OtherTaxes68 M17 M17 M5 M2 M409 M464 M410 M530 M707 M
OtherunderPreferredStockDividend7 M
PreferredStockDividends7 M
PromotionAndAdvertising70 M73 M80 M76 M68 M63 M51 M52 M56 M54 M
RentAndLandingFees443 M511 M580 M613 M603 M
Research & development expense62 M65 M60 M60 M55 M54 M48 M47 M42 M27 M
ResearchExpense62 M65 M60 M60 M55 M54 M48 M47 M42 M27 M
RestructringAndMnAIncome160 M177 M
Selling Gen & administrative expense1,663 M1,670 M1,638 M1,695 M1,677 M1,681 M1,544 M1,744 M2,168 M2,525 M
SellingAndMarketingExpense1,663 M1,670 M1,638 M1,695 M1,677 M1,681 M1,544 M1,744 M2,168 M2,525 M
Special income/charges150 M7 M5 M24 M8 M861 M4,252 M1,498 M60 M24 M
Total Income available for interest expense (EBIT)6,012 M6,354 M78,675 M96,849 M106,285 M100,145 M53,134 M2,345 M15,281 M10,395 M
Total common shares outstanding543 M527 M518 M501 M455 M439 M437 M438 M464 M428 M
Total net income4,762 M4,227 M1,555 M5,106 M5,595 M3,076 M-3,975 M1,315 M11,024 M7,015 M
Total ordinary shares424 M424 M424 M424 M424 M424 M424 M424 M424 M424 M
Total revenues161,212 M98,975 M84,279 M102,354 M111,461 M107,293 M64,129 M111,476 M169,990 M147,399 M
TotalExpenses7,093 M7,042 M7,081 M87,121 M105,843 M104,034 M65,673 M111,008 M160,370 M139,449 M
TotalRevenue161,212 M98,975 M84,279 M102,354 M111,461 M107,293 M64,129 M111,476 M169,990 M147,399 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