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

71.52
 
USD
  
0.39
  
(0.55%)
Optionable: Yes  Market Cap: 41,981 M  90-day average vol: 3,015,887

Previous close: 71.13  Open: 71.11  Bid: 67.59  Ask: 72.18
52 week range    
63.75   
   79.38
Peers   
PCG / 
NI / 
MDU / 
SWX / 
D / 
UGI / 
NEE / 
CLNE / 
HOKCY / 
Last updated: Wednesday 24th April 2024
56
MarketXLS Rank
80
Value
53
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

Financials

SRE Balance Sheet

Annual
Invalid dateDec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
"""debtc"""191 M473 M372 M136 M611 M825 M4,371 M
Accounts payable534 M594 M532 M606 M675 M730 M2,269 M
Accounts receivable371 M441 M474 M517 M716 M793 M3,320 M
Accrued expenses1,057 M1,117 M1,193 M1,355 M1,361 M1,491 M3,437 M
AccruedInterestReceivable17 M29 M
Accumulated depreciation & depletion-4,594 M-4,949 M-5,352 M-5,537 M-6,015 M-6,408 M-16,111 M
Cash and equivalents19 M18 M19 M41 M284 M44 M410 M
CashCashEquivalentsAndShortTermInvestments19 M18 M19 M41 M284 M44 M410 M
CashEquivalents19 M18 M19 M41 M284 M19 M40 M
Common par1,358 M1,338 M3,031 M3,787 M3,353 M10,798 M13,049 M
Common stock equity5,661 M5,598 M6,015 M9,227 M7,730 M8,249 M27,115 M
CommonStock1,338 M1,338 M1,338 M2,032 M1,660 M9,909 M12,160 M
Cost in excess2,364 M2,397 M1,602 M1,602 M1,602 M1,602 M1,602 M
CurrentAccruedExpenses204 M181 M181 M234 M135 M198 M547 M
CurrentCapitalLeaseObligation15 M52 M52 M-49 M-57 M
CurrentDeferredAssets234 M
CurrentDeferredTaxesAssets234 M
CurrentDeferredTaxesLiabilities3,511 M
Deferred revenues349 M544 M558 M751 M695 M680 M2,117 M
DerivativeProductLiabilities189 M316 M
DividendsPayable319 M342 M480 M515 M551 M563 M621 M
EmployeeBenefits232 M182 M212 M153 M92 M25 M410 M
Float term debt905 M1,412 M1,654 M1,501 M1,504 M
GoodwillAndOtherIntangibleAssets2,912 M2,993 M1,826 M1,815 M1,804 M1,972 M1,946 M
Gross fixed assets (Plant Property & Equipment)17,844 M19,787 M21,662 M130 M102 M46,689 M64,548 M
Intangibles548 M596 M224 M213 M202 M370 M344 M
InterestPayable40 M41 M43 M46 M50 M63 M
Inventories80 M105 M102 M94 M104 M123 M403 M
Invested capital28,285 M30,547 M40,403 M41,650 M46,658 M15,830 M51,663 M
Leases130 M102 M
LineOfCredit-749 M-1,744 M
LongTermCapitalLeaseObligation1,255 M1,263 M1,294 M1,292 M1,286 M
LongTermDebtAndCapitalLeaseObligation4,658 M5,335 M6,138 M6,306 M6,866 M7,581 M24,548 M
Minority interest37 M48 M120 M1,876 M1,561 M1,438 M2,141 M
Net fixed assets (net PP&E)13,250 M14,838 M16,310 M-5,407 M-5,913 M40,281 M48,437 M
Non-current deferred income taxes2,845 M1,548 M1,632 M1,862 M2,019 M2,275 M4,591 M
NonCurrentDeferredAssets234 M170 M141 M155 M136 M151 M135 M
NonCurrentDeferredLiabilities2,845 M1,548 M1,632 M1,862 M2,019 M2,275 M4,591 M
NonCurrentDeferredTaxesAssets234 M170 M141 M155 M136 M151 M135 M
NonCurrentPensionAndOtherPostretirementBenefitPlans232 M182 M212 M153 M92 M25 M410 M
NonCurrentPrepaidAssets363 M331 M
Other current assets544 M563 M128 M678 M335 M2,815 M541 M
Other equity adjustments-8 M-8 M-10 M-16 M-10 M
Other fixed assets46,689 M64,548 M
Other non-current assets3,661 M2,278 M5,556 M5,741 M4,660 M2,646 M5,368 M
Other non-current liabilities2,581 M3,106 M3,234 M3,307 M3,301 M3,424 M7,188 M
Other receivable4 M4 M7 M11 M22 M49 M54 M
OtherCurrentBorrowings1,779 M253 M291 M80 M885 M776 M3,352 M
OtherCurrentLiabilities1,133 M1,305 M1,669 M1,655 M7,551 M8,597 M3,072 M
OtherInventories92 M109 M95 M110 M118 M123 M403 M
Payables853 M936 M1,012 M1,121 M1,226 M1,293 M2,890 M
Preferred securities of subsidiary trust20 M50 M1,693 M1,755 M1,693 M889 M889 M
PreferredStock20 M50 M1,693 M1,755 M1,693 M889 M889 M
Prepaid expenses59 M58 M74 M512 M153 M174 M571 M
RecievablesAdjustmentsAllowances-29 M-138 M-136 M-181 M
Retained earnings4,311 M4,268 M4,687 M5,456 M6,080 M6,589 M14,066 M
Short term debt191 M473 M372 M136 M611 M825 M4,371 M
TaxesReceivable122 M110 M60 M128 M113 M9 M113 M
Total assets24,400 M25,246 M19,225 M19,220 M22,311 M24,058 M78,687 M
Total current assets1,257 M1,341 M894 M2,024 M1,600 M1,431 M6,328 M
Total current liabilities2,791 M3,439 M1,428 M3,897 M2,011 M2,111 M12,997 M
Total equity5,661 M5,598 M6,015 M9,227 M7,730 M8,249 M27,115 M
Total liabilities13,296 M13,610 M16,021 M16,577 M22,496 M24,898 M49,734 M
Total non-current assets23,143 M23,905 M37,065 M17,196 M16,103 M60,850 M72,359 M
TotalDeferredCreditsAndOtherNonCurrentLiabilities10,505 M10,171 M12,229 M12,680 M12,278 M13,305 M36,737 M
TotalEquityGrossMinority5,698 M5,646 M6,115 M11,103 M24,934 M27,419 M29,256 M
TotalEquityGrossMinorityInterest5,698 M5,646 M6,115 M11,103 M24,934 M27,419 M29,256 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest18,994 M19,256 M19,225 M27,680 M22,311 M24,058 M78,687 M
UnearnedIncome182 M83 M155 M189 M101 M422 M796 M
Working capital-1,534 M-2,098 M-534 M-1,873 M-411 M-680 M-6,669 M
ltinv2,097 M2,527 M11,972 M13,622 M13,828 M14,472 M15,677 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