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

Sempra Energy

Sector: Utilities   

Industry: Utilities - Diversified

68.44
 
USD
  
0.50
  
(0.74%)
Optionable: Yes  Market Cap: 41,981 M  90-day average vol: 3,018,653

Previous close: 67.94  Open: 68.18  Bid: 66.44  Ask: 68.44
52 week range    
63.75   
   79.44
Peers   
PCG / 
NI / 
MDU / 
SWX / 
D / 
UGI / 
NEE / 
CLNE / 
HOKCY / 
Last updated: Friday 19th April 2024
51
MarketXLS Rank
80
Value
38
Technical
36
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

Metrics

Peers

StockDividendMarket Cap (B)PEPrice ($)

CLNE

1 B-13.56.2

D

0.033365 B25.580.17

HOKCY

MDU

0.03056 B14.728.72

NEE

0.0203152 B43.275.68

NI

0.032711 B25.828.79

OKE

0.059128 B18.863.26

PCG

24 B91.412.15

SWX

0.0364 B16.666.04

UGI

0.033810 B6.640.81
Financials

SRE Income Statement

Annual
Invalid dateDec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
AccruedPreferredStockDividends2 M1000000.0126 M143 M169 M64 M45 M
AcquiredInProcessRnD-580 M
AcquisitionExpense1,067 M
Basic EPS from continuing operations2.740.511.736.819.774.0313.3
Basic EPS total2.740.511.737.412.934.0313.3
Basic weighted shares outstanding500 M503 M536 M556 M582 M624 M315 M
BasicDiscontinuousOperations1.730.593.16
Cost of sales2,433 M2,281 M1,358 M1,188 M1,187 M1,597 M2,603 M
Depreciation1,312 M1,490 M1,491 M1,569 M1,666 M1,855 M2,019 M
Depreciation unreconciled2,434 M2,675 M2,735 M2,931 M3,121 M1,855 M2,019 M
DepreciationAndAmortization1,122 M1,185 M1,244 M1,362 M1,455 M1,605 M
Diluted EPS total2.730.511.717.2912.884.0113.24
Diluted normalized net income/share2.730.511.716.719.734.0113.24
Diluted weighted shares outstanding502 M505 M540 M564 M585 M626 M316 M
DilutedDiscontinuousOperations1.710.583.15
Dividends paid per share1.511.652.092.24.58
Earnings from equity interest6 M34 M-236 M30 M294 M614 M666 M
EarningsFromEquityInterestNetOfTax6 M34 M-236 M30 M294 M614 M666 M
FuelAndPurchasePower1,464 M1,632 M
GainOnSaleOfPPE134 M3 M513 M63 M-3 M36 M
GainOnSaleOfSecurity23 M56 M-6 M61 M41 M50 M-42 M
GainsLossOnDisposalOfDiscontinuedOperations188 M363 M1,850 M
GeneralAndAdministrativeExpense124 M45 M123 M
Gross operating profit12,003 M3,409 M3,460 M3,345 M12,634 M12,857 M14,439 M
Income before tax845 M576 M849 M945 M1,014 M219 M1,343 M
Income restructuring and M&A-617 M-109 M-121 M-123 M127 M133 M141 M
Income taxes389 M1,276 M-49 M315 M249 M99 M556 M
Interest income26 M46 M85 M87 M96 M69 M75 M
InterestExpenseNonOperating553 M659 M886 M1,077 M1,081 M1,198 M1,054 M
MarketingExpense1,067 M
MinorityInterests1,701 M196 M44 M440 M-172 M-145 M-146 M
MiscOtherSpecialCharges132 M233 M58 M77 M-48 M58 M24 M
Net income from total operations565 M421 M676 M774 M824 M1,254 M2,094 M
NetIncomeCommonStockholders3,441 M-7,784 M-7,053 M-6,941 M824 M1,254 M2,094 M
NetIncomeContinuousOperations565 M421 M676 M774 M824 M1,254 M2,094 M
NetIncomeDiscontinuousOperations188 M363 M1,850 M
NetIncomeExtraordinary-148 M-94 M-76 M-164 M
NetIncomeFromOtherGainsLosses78 M76 M176 M
NetNonOperatingInterestIncomeExpense-527 M-613 M-801 M-990 M-985 M-1,129 M-979 M
NonRecurringOperationExpense307 M1,593 M259 M
Operating income3,693 M-5,689 M-5,911 M-6,369 M2,373 M6,065 M7,039 M
Operating income before depreciation (EBITDA)4,954 M5,095 M5,714 M6,315 M6,671 M3,272 M4,416 M
OperatingExpense8,310 M9,098 M9,371 M9,714 M10,261 M6,792 M7,400 M
OperationAndMaintenance2,433 M2,498 M2,671 M2,961 M3,484 M3,767 M
Other income net-119 M-164 M376 M-97 M52 M-94 M-24 M
OtherCostofRevenue2,510 M2,305 M
OtherGandA124 M45 M123 M
OtherImpairmentOfCapitalAssets153 M72 M1,122 M43 M1000000.03 M
OtherOperatingExpenses3,988 M5,578 M5,720 M5,813 M6,076 M4,341 M4,746 M
OtherTaxes821 M845 M916 M970 M1,064 M596 M635 M
OtherunderPreferredStockDividend2 M1000000.0126 M143 M169 M64 M45 M
PreferredStockDividends2 M1000000.0126 M143 M169 M64 M45 M
RestructringAndMnAIncome-617 M-109 M-121 M-123 M127 M133 M141 M
Revenue per share-11 M-18 M-16 M-11 M11 M22 M26 M
SalariesAndWages-46 M-78 M-76 M-66 M
Selling Gen & administrative expense1,067 M
SellingAndMarketingExpense1,067 M
Special income/charges-617 M351 M-121 M-580 M307 M1,593 M259 M
Total Income available for interest expense (EBIT)1,398 M1,235 M1,735 M2,022 M2,095 M1,417 M2,397 M
Total common shares outstanding501 M511 M548 M585 M605 M631 M315 M
Total net income565 M421 M676 M774 M824 M1,254 M2,094 M
Total ordinary shares632 M632 M632 M632 M632 M632 M632 M
Total revenues4,253 M11,207 M10,102 M10,829 M11,370 M12,857 M14,439 M
TotalExpenses10,743 M11,379 M10,729 M10,902 M11,448 M8,389 M10,003 M
TotalRevenue14,436 M5,907 M6,131 M6,306 M16,118 M12,857 M14,439 M
WriteOff351 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