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

NI Stock Forecast, Price Targets, Chart, Dividends & Analysis

NiSource Inc logo

NiSource Inc

Sector: Utilities   

Industry: Utilities - Regulated Gas

37.85
 
USD
  
0.55
  
(1.47%)
Previous close: 37.3  Open: 37.31  Bid: 37.32  Ask: 37.93
52 week range    
24.80   
   37.94
Mkt Cap: 17,322 M  Avg Vol (90 Days): 3,536,262
Peers   
SRE / 
DUK / 
ATO / 
CPK / 
Last updated: Friday 22nd November 2024

Stock Rankings

75
MarketXLS Rank
100
Value
69
Technical
57
Quality
How are these ranks calculated?
Ad slot not ready
Search for a stock

Metrics

Peers

StockDividendMarket Cap (B)PEPrice ($)

ATO

0.02423 B21.28150.26

CPK

0.01983 B22.24130.39

DUK

0.037388 B15.93114.86

GNE

0.0190 B112.7915.9

SRE

0.026959 B20.1394.69
Financials

NI Income Statement

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
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
BasicDiscontinuousOperations0.270.01
Cost of sales2,373 M1,644 M1,390 M1,519 M1,761 M1,355 M2,695 M2,848 M3,600 M3,028 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-0.191.271.71.48
Diluted normalized net income/share1.670.631.010.39-0.180.87-0.191.271.71.48
Diluted weighted shares outstanding320 M324 M331 M356 M376 M384 M417 M443 M448 M
DilutedDiscontinuousOperations0.270.01
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 M1,987 M2,051 M2,251 M2,477 M
ImpairmentOfCapitalAssets415 M
Income before tax2,802 M1,987 M1,898 M1,973 M1,533 M2,041 M1,899 M2,114 M956 M814 M
Income taxes167 M141 M182 M315 M-180 M124 M-17 M118 M165 M140 M
InterestExpenseNonOperating380 M380 M350 M353 M353 M379 M371 M343 M372 M501 M
MinorityInterests-227 M5,987 M-3 M-4 M-6 M40 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 M792 M674 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 M357 M481 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 M1,066 M1,798 M2,149 M2,223 M
OperatingExpense2,110 M2,208 M3,634 M3,953 M4,990 M4,318 M4,131 M3,893 M1,089 M1,179 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 M152 M-4 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 M340 M1,050 M1,329 M1,315 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 shares449 M449 M449 M449 M449 M449 M449 M449 M449 M449 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 M4,689 M4,207 M
TotalRevenue5,272 M4,652 M4,493 M4,730 M4,991 M5,053 M4,682 M4,900 M5,851 M5,505 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

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