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

NI Stock Annual Balance Sheet. Download in Excel

NiSource Inc logo

NiSource Inc

Sector: Utilities   

Industry: Utilities - Regulated Gas

36.17
 
USD
  
0.30
  
(0.84%)
Previous close: 35.87  Open: 35.8  Bid: 35.59  Ask: 36.88
52 week range    
24.80   
   38.56
Mkt Cap: 16,902 M  Avg Vol (90 Days): 3,236,058
Peers   
SRE / 
DUK / 
ATO / 
CPK / 
Last updated: Monday 23rd December 2024

Stock Rankings

72
MarketXLS Rank
100
Value
61
Technical
57
Quality
How are these ranks calculated?
Search for a stock

Financials

NI Balance Sheet

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
Accounts payable610 M433 M539 M626 M884 M666 M589 M698 M900 M749 M
Accounts receivable921 M660 M847 M899 M1,059 M876 M844 M849 M1,066 M885 M
Accrued expenses1,087 M887 M1,017 M1,141 M1,347 M1,153 M1,080 M1,263 M1,452 M1,279 M
Accumulated depreciation & depletion-6,629 M-6,853 M-6,614 M-6,954 M-7,258 M-7,630 M-7,560 M-7,289 M-7,709 M-8,207 M
Additional paid in capital4,788 M5,078 M5,154 M5,529 M6,404 M6,666 M6,890 M7,204 M7,375 M8,880 M
Cash and equivalents25 M16 M26 M29 M113 M139 M117 M84 M41 M2,245 M
CashCashEquivalentsAndShortTermInvestments25 M16 M26 M29 M113 M139 M117 M84 M41 M2,245 M
CashEquivalents50 M45 M36 M38 M121 M148 M126 M
CommercialPaper793 M321 M1,178 M869 M978 M570 M503 M560 M415 M1,061 M
Common par3 M3 M3 M3 M884 M884 M884 M1,551 M1,551 M491 M
Common stock equity6,198 M3,881 M4,109 M4,352 M5,770 M5,987 M5,752 M6,947 M7,575 M8,270 M
CommonStock3 M3 M3 M3 M4 M4 M4 M4 M4 M5 M
CommonUtilityPlant17,687 M18,965 M19,682 M21,313 M22,800 M24,542 M24,180 M25,171 M27,551 M30,482 M
Cost in excess1,691 M1,691 M1,691 M1,691 M1,691 M1,486 M1,486 M1,486 M1,486 M1,486 M
CurrentAccruedExpenses308 M270 M282 M308 M240 M256 M247 M288 M306 M364 M
CurrentCapitalLeaseObligation13 M23 M28 M30 M24 M
CurrentDeferredRevenue49 M155 M
CurrentDeferredTaxesLiabilities3,599 M3,935 M3,799 M2,570 M2,833 M2,898 M2,671 M2,763 M2,876 M2,839 M
CurrentProvisions417 M496 M512 M514 M553 M
Deferred revenues49 M155 M256 M243 M238 M325 M294 M
DeferredCosts32 M35 M80 M86 M91 M
DerivativeProductLiabilities23 M45 M29 M47 M134 M145 M
EmployeeBenefits734 M760 M713 M337 M389 M373 M336 M293 M246 M250 M
Float term debt8,152 M5,949 M6,058 M7,512 M7,105 M7,856 M9,220 M9,183 M9,524 M11,056 M
GoodwillAndOtherIntangibleAssets1,955 M1,944 M1,933 M1,922 M1,911 M1,486 M1,486 M1,486 M1,486 M1,486 M
Gross fixed assets (Plant Property & Equipment)17,687 M18,965 M19,682 M21,313 M22,800 M24,542 M24,180 M25,171 M27,551 M30,482 M
IncomeTaxPayable267 M184 M195 M208 M223 M232 M244 M
Intangibles265 M254 M243 M232 M221 M
InterestPayable141 M129 M120 M112 M91 M99 M105 M106 M138 M136 M
Inventories586 M537 M494 M471 M423 M425 M401 M499 M752 M503 M
Invested capital22,501 M15,778 M16,225 M19,377 M19,981 M21,699 M24,192 M25,314 M26,623 M30,381 M
Leases64 M40 M
LineOfCredit500 M
LongTermCapitalLeaseObligation188 M172 M158 M145 M182 M
LongTermDebtAndCapitalLeaseObligation8,152 M5,949 M6,058 M7,512 M7,105 M7,856 M9,220 M9,183 M9,524 M11,056 M
LongTermProvisions136 M254 M263 M269 M352 M417 M477 M470 M478 M481 M
MaterialsAndSupplies81 M87 M102 M106 M101 M120 M142 M139 M151 M172 M
Minority interest5,987 M86 M326 M326 M1,867 M
Net fixed assets (net PP&E)11,057 M12,112 M13,068 M14,360 M15,543 M16,912 M16,620 M17,882 M19,843 M22,275 M
NetUtilityPlant17,687 M18,965 M19,682 M21,313 M22,800 M24,542 M24,180 M25,171 M27,551 M30,482 M
Non-current deferred income taxes2,183 M2,380 M2,541 M1,305 M1,342 M1,485 M1,471 M1,659 M1,855 M2,080 M
NonCurrentAccruedExpenses87 M83 M80 M84 M82 M85 M
NonCurrentDeferredAssets32 M35 M80 M86 M91 M
NonCurrentDeferredLiabilities2,284 M2,380 M2,541 M1,305 M1,342 M1,485 M1,471 M1,659 M1,855 M2,080 M
NonCurrentDeferredTaxesAssets-1,433 M-1,570 M1,271 M1,277 M1,503 M1,413 M1,207 M1,111 M1,030 M765 M
NonCurrentPensionAndOtherPostretirementBenefitPlans734 M760 M713 M337 M389 M373 M336 M293 M246 M250 M
Other current assets606 M314 M379 M355 M365 M344 M222 M502 M571 M399 M
Other equity adjustments23 M38 M37 M32 M19 M20 M-157 M
Other fixed assets17,712 M18,988 M20,050 M21,650 M22,820 M24,542 M24,180 M25,171 M27,551 M30,482 M
Other non-current assets9,170 M1,686 M1,734 M1,707 M2,177 M2,178 M2,058 M2,609 M2,743 M3,024 M
Other non-current liabilities1,693 M1,602 M1,466 M2,991 M2,812 M2,580 M2,420 M2,533 M2,220 M1,860 M
Other receivable341 M237 M330 M359 M324 M351 M338 M
OtherCurrentBorrowings1,577 M567 M1,488 M1,206 M1,977 M1,773 M503 M560 M1,762 M3,049 M
OtherCurrentLiabilities487 M669 M530 M412 M529 M537 M430 M627 M945 M569 M
OtherDeferredCosts32 M35 M80 M86 M91 M
OtherInventories505 M450 M393 M365 M322 M305 M260 M360 M601 M331 M
Payables779 M617 M735 M834 M1,107 M898 M833 M975 M1,146 M916 M
Preferred securities of subsidiary trust20 M20 M880 M880 M880 M1,547 M1,547 M486 M
PreferredStock20 M20 M880 M880 M880 M1,547 M1,547 M486 M
RecievablesAdjustmentsAllowances-25 M-20 M-23 M-18 M-21 M-19 M-52 M-23 M-24 M-23 M
Restricted cash25 M30 M10 M9 M8 M9 M9 M11 M35 M36 M
Retained earnings1,443 M-1,158 M-997 M-1,116 M-1,436 M-1,463 M-1,922 M-1,708 M-1,251 M-1,001 M
Short term debt1,844 M1,001 M1,851 M1,490 M2,027 M1,787 M526 M618 M1,792 M3,072 M
TaxesReceivable6 M
Total assets24,590 M17,493 M18,692 M19,962 M21,804 M22,660 M22,041 M24,157 M26,737 M31,077 M
Total current assets2,162 M1,556 M1,757 M1,763 M1,967 M1,774 M1,540 M1,921 M2,584 M4,499 M
Total current liabilities3,466 M2,558 M3,415 M3,087 M3,903 M3,746 M2,279 M2,746 M4,661 M5,265 M
Total equity6,198 M3,881 M4,109 M4,352 M5,770 M5,987 M5,752 M6,947 M7,575 M8,270 M
Total liabilities18,392 M13,611 M14,583 M15,610 M16,034 M16,673 M16,203 M16,884 M18,835 M20,941 M
Total non-current assets22,427 M15,936 M16,935 M18,198 M19,837 M20,885 M20,501 M22,236 M24,296 M27,032 M
Total non-current liabilities4,704 M4,954 M4,651 M4,620 M
TotalDeferredCreditsAndOtherNonCurrentLiabilities14,926 M11,054 M11,169 M12,523 M12,131 M12,927 M13,923 M14,138 M14,322 M15,726 M
TotalEquityGrossMinority6,198 M3,881 M4,109 M4,352 M5,770 M5,987 M5,838 M7,273 M7,902 M10,136 M
TotalEquityGrossMinorityInterest6,198 M3,881 M4,109 M4,352 M5,770 M5,987 M5,838 M7,273 M7,902 M10,136 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest24,590 M17,493 M18,692 M19,962 M21,804 M22,660 M22,041 M24,157 M26,737 M31,077 M
TotalNonCurrentLiabilitiesNetMinorityInteres4,704 M4,954 M4,651 M4,620 M
TotalTaxPayable169 M184 M195 M208 M223 M232 M244 M277 M246 M166 M
Treasury stock-59 M-79 M-89 M-96 M-100 M-100 M-100 M-100 M-100 M-100 M
UnrealizedGainLoss23 M38 M37 M32 M19 M20 M
Working capital-1,303 M-1,001 M-1,658 M-1,323 M-1,936 M-1,971 M-740 M-825 M-2,076 M-766 M
debtc1,844 M1,001 M1,851 M1,490 M2,027 M1,787 M526 M618 M1,792 M3,072 M
ltinv213 M195 M200 M210 M206 M230 M252 M260 M224 M247 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