Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Public Service Enterprise Group Incorporated logo

Public Service Enterprise Group Incorporated

Sector: Utilities   

Industry: Utilities - Diversified

Optionable: Yes  Market Cap: 37,431 M  90-day average vol: 2,920,365

Previous close: 73.55  Open: 73.9  Bid: 74.78  Ask: 75.5
52 week range    
EXC / 
FE / 
ED / 
DUK / 
XEL / 
SO / 
PPL / 
NRG / 
AEE / 
Last updated: Sunday 26th May 2024
MarketXLS Rank

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



StockDividendMarket Cap (B)PEPrice ($)


0.025223 B23.287.36


0.037880 B27.1104.34


0.036730 B25.986.6


0.035157 B33.943.64


0.037624 B20.741.44


0.03519 B439.9


0.056722 B-17.429.29


0.038472 B24.867.65


0.03061 B20.151.03


0.026637 B23.568.75

PEG Income Statement

Basic EPS from continuing operations4.923.03.321.763.122.853.353.78-1.292.07
Basic EPS total4.923.03.321.763.122.853.353.78-1.292.07
Basic weighted shares outstanding506 M506 M505 M505 M505 M504 M504 M504 M504 M498 M
Cost of sales2,887 M3,150 M2,978 M3,008 M2,778 M3,225 M3,372 M3,115 M-6,725 M3,178 M
Depletion1,248 M1,285 M
Depreciation1,986 M1,158 M
Depreciation unreconciled1,214 M1,986 M1,158 M1,248 M1,285 M-1,216 M
DepreciationAndAmortization-1,216 M
Diluted EPS total4.92.993.31.753.12.833.333.76-1.292.06
Diluted normalized net income/share4.92.993.31.753.12.833.333.76-1.292.06
Diluted weighted shares outstanding508 M508 M508 M508 M507 M507 M507 M507 M504 M501 M
Dividends paid per share1.441.481.561.641.721.81.881.962.042.16
Earnings from equity interest11 M13 M12 M11 M14 M15 M14 M14 M16 M14 M
EarningsFromEquityInterestNetOfTax11 M13 M12 M11 M14 M15 M14 M14 M16 M14 M
ExciseTaxes68 M1,227 M
FuelAndPurchasePower-3,499 M
GainOnSaleOfPPE54 M-402 M123 M-2,637 M-123 M
GainOnSaleOfSecurity-12 M-20 M-53 M-28 M134 M-143 M260 M253 M194 M-265 M
GeneralAndAdministrativeExpense-28 M1,248 M
Gross operating profit7,081 M7,736 M7,437 M6,053 M6,316 M6,471 M6,704 M6,488 M2,997 M6,622 M
ImpairmentOfCapitalAssets12 M
Income before tax5,591 M6,342 M5,941 M1,404 M1,536 M1,855 M1,950 M2,301 M-1,089 M1,832 M
Income restructuring and M&A1,178 M1,227 M50 M
Income taxes812 M938 M1,001 M411 M-306 M417 M257 M396 M-441 M-29 M
InsuranceAndClaims-28 M
Interest income30 M31 M30 M30 M29 M26 M25 M72 M31 M
InterestExpenseNonOperating402 M389 M393 M385 M391 M476 M569 M600 M-500 M628 M
MarketingExpense1,100 M
MinorityInterests11,609 M12,186 M13,067 M13,130 M13,847 M14,377 M15,089 M15,984 M
MiscOtherSpecialCharges159 M229 M152 M124 M82 M161 M302 M364 M128 M500 M
Net income from total operations1,243 M1,518 M1,679 M889 M1,574 M1,438 M1,693 M1,905 M1,446 M1,031 M
NetIncomeCommonStockholders4,779 M5,404 M4,940 M3,888 M4,352 M4,663 M5,065 M4,961 M-648 M1,031 M
NetIncomeContinuousOperations1,243 M1,518 M1,679 M889 M1,574 M1,438 M1,693 M1,905 M1,446 M1,031 M
NetNonOperatingInterestIncomeExpense-402 M-389 M-393 M-385 M-391 M-476 M-569 M-600 M-428 M-628 M
Normalized income4,812 M5,349 M3,862 M2,389 M1,230 M1,411 M1,943 M1,695 M5,183 M1,976 M
Operating income2,299 M2,623 M2,962 M1,614 M1,760 M2,298 M1,943 M2,270 M1,762 M5,522 M
Operating income before depreciation (EBITDA)9,461 M10,354 M10,226 M6,484 M8,128 M6,028 M6,519 M6,111 M4,623 M4,550 M
OperatingExpense3,993 M4,225 M3,498 M4,010 M4,227 M3,550 M3,937 M1,285 M-1,235 M1,100 M
OperationAndMaintenance2,887 M3,150 M2,978 M3,008 M2,901 M3,069 M3,111 M3,115 M3,178 M
Other income net-158 M-222 M-111 M1,369 M-230 M-87 M-174 M-754 M2,423 M-126 M
Other special charges-320 M
OtherCostofRevenue3,536 M3,886 M3,261 M3,001 M2,800 M3,056 M3,499 M4,018 M
OtherGandA-28 M1,248 M
OtherImpairmentOfCapitalAssets1,214 M
OtherOperatingExpenses-24 M-31 M-48 M-49 M-56 M-54 M-59 M-87 M-65 M
OtherTaxes-19 M
OtherWriteDown1,178 M1,476 M
RestructringAndMnAIncome1,178 M1,227 M50 M
SalariesAndWages1,158 M
Selling Gen & administrative expense1,248 M1,100 M
SellingAndMarketingExpense1,100 M
Special income/charges1,178 M1,227 M1,476 M1,986 M2,957 M50 M
Total Income available for interest expense (EBIT)5,993 M6,731 M6,334 M1,789 M1,927 M2,331 M2,519 M2,901 M2,341 M2,460 M
Total common shares outstanding639 M639 M639 M639 M637 M637 M638 M638 M635 M631 M
Total net income1,243 M1,518 M1,679 M889 M1,574 M1,438 M1,693 M1,905 M1,446 M1,031 M
Total ordinary shares498 M498 M498 M498 M498 M498 M498 M498 M498 M498 M
Total revenues9,968 M10,886 M10,415 M9,061 M9,094 M9,696 M10,076 M9,603 M9,722 M9,800 M
TotalExpenses6,880 M7,375 M6,476 M7,018 M7,005 M6,775 M7,309 M4,400 M3,155 M4,278 M
TotalRevenue9,968 M10,886 M10,415 M9,061 M9,094 M9,696 M10,076 M9,603 M9,722 M7,935 M
WriteDown1,476 M
WriteOff1,986 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


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.


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