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

NiSource Inc

Sector: Utilities   

Industry: Utilities - Regulated Gas

Optionable: Yes  Market Cap: 12,499 M  90-day average vol: 4,342,443

Previous close: 27.93  Open: 27.72  Bid: 27.7  Ask: 28.35
52 week range    
SRE / 
DUK / 
ATO / 
CPK / 
Last updated: Thursday 25th April 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.025714 B20.9105.94


0.01452 B28.7132.13


0.037880 B27.1104.34


0 B-83.85.12


0.032143 B37.7137

NI Income Statement

AccruedPreferredStockDividends15 M55 M55 M55 M55 M53 M
Basic EPS from continuing operations1.680.631.020.39-0.180.88-0.191.351.841.59
Basic EPS total1.680.91.030.39-0.180.88-0.191.351.841.59
Basic weighted shares outstanding318 M322 M329 M356 M375 M384 M394 M407 M416 M
Cost of sales2,373 M1,644 M1,390 M1,519 M1,761 M1,355 M1,586 M1,456 M1,489 M1,495 M
Depreciation487 M524 M547 M570 M600 M717 M726 M748 M821 M908 M
Depreciation unreconciled487 M524 M547 M570 M600 M717 M726 M748 M821 M908 M
Diluted EPS total1.670.91.020.39-0.180.87-
Diluted normalized net income/share1.670.631.010.39-0.180.87-
Diluted weighted shares outstanding320 M324 M331 M356 M376 M384 M417 M443 M448 M
Dividends paid per share0.830.640.70.780.80.840.880.941.0
Earnings from equity interest47 M
EarningsFromEquityInterestNetOfTax47 M
ExciseTaxes4 M
GainOnSaleOfPPE32 M
GainOnSaleOfSecurity46 M
GainsLossOnDisposalOfDiscontinuedOperations274 M-103 M-3 M100000.0
Gross operating profit2,900 M3,008 M3,102 M3,212 M3,230 M3,699 M2,887 M3,275 M4,249 M3,853 M
ImpairmentOfCapitalAssets415 M
Income before tax2,802 M1,987 M1,898 M1,973 M1,533 M2,041 M1,899 M2,114 M2,859 M2,353 M
Income taxes167 M141 M182 M315 M-180 M124 M-17 M118 M165 M140 M
InterestExpenseNonOperating380 M380 M350 M353 M353 M379 M371 M341 M362 M490 M
MinorityInterests-227 M5,987 M-3 M-4 M-6 M-14 M
MiscOtherSpecialCharges13 M-80 M2 M-125 M-2 M-5 M-211 M41 M52 M8 M
Net income from total operations530 M287 M332 M129 M-66 M383 M-18 M585 M804 M714 M
NetIncomeCommonStockholders3,439 M2,044 M2,044 M129 M-66 M328 M-73 M530 M749 M662 M
NetIncomeContinuousOperations530 M287 M332 M129 M-66 M383 M-18 M585 M804 M714 M
NetIncomeDiscontinuousOperations274 M-103 M-3 M100000.0
NetIncomeExtraordinary530 M302 M332 M129 M
NetNonOperatingInterestIncomeExpense-379 M-380 M-349 M-353 M-353 M-379 M-371 M-341 M-362 M-490 M
NonRecurringOperationExpense-135 M-665 M
Normalized income1,821 M1,291 M1,234 M1,282 M1,353 M2,027 M2,295 M1,859 M
Operating income789 M800 M858 M921 M125 M891 M551 M1,007 M1,266 M1,296 M
Operating income before depreciation (EBITDA)3,678 M2,900 M2,803 M2,904 M2,494 M3,146 M2,996 M3,204 M4,041 M3,751 M
OperatingExpense2,110 M2,208 M3,634 M3,953 M4,990 M4,318 M4,131 M3,893 M4,585 M4,210 M
OperationAndMaintenance1,367 M1,426 M1,454 M1,602 M2,353 M1,355 M1,586 M1,456 M1,489 M1,495 M
Other income net-13 M80 M-1 M125 M2 M5 M211 M-41 M-52 M-8 M
OtherCostofRevenue1,535 M1,109 M1,392 M2,111 M1,533 M
OtherOperatingExpenses-3 M-2 M1000000.0-5 M-1 M299 M-411 M-8 M104 M-3 M
OtherTaxes253 M256 M244 M257 M275 M297 M299 M288 M268 M271 M
OtherunderPreferredStockDividend15 M55 M55 M55 M55 M53 M
PreferredStockDividends15 M55 M55 M55 M55 M53 M
Revenue per share11 M11 M11 M11 M11 M11 M
Special income/charges-135 M415 M412 M
Total Income available for interest expense (EBIT)3,181 M2,367 M2,248 M2,326 M1,886 M2,420 M2,270 M2,455 M3,220 M2,843 M
Total common shares outstanding316 M320 M323 M337 M372 M382 M392 M405 M413 M448 M
Total net income530 M287 M332 M129 M-66 M383 M-18 M585 M804 M714 M
Total ordinary shares448 M448 M448 M448 M448 M448 M448 M448 M448 M448 M
Total revenues5,272 M4,652 M4,493 M4,730 M4,991 M5,053 M4,473 M4,731 M5,739 M5,348 M
TotalExpenses4,483 M3,852 M5,025 M5,472 M6,751 M5,673 M5,717 M5,349 M6,074 M5,705 M
TotalRevenue5,272 M4,652 M4,493 M4,730 M4,991 M5,053 M4,473 M4,731 M5,739 M5,348 M
WriteDown412 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