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

39.28
 
USD
  
0.29
  
(0.74%)
Previous close: 38.99  Open: 39.1  Bid: 37.0  Ask: 40.98
52 week range    
27.83   
   41.45
Mkt Cap: 18,560 M  Avg Vol (90 Days): 4,723,069
Last updated: Monday 9th June 2025

Stock Rankings

79
MarketXLS Rank
100
Value
80
Technical
57
Quality
How are these ranks calculated?
Financials

NI Balance Sheet

Annual
Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23Dec-24
Accounts payable433 M539 M626 M884 M666 M589 M698 M900 M749 M863 M
Accounts receivable660 M847 M899 M1,059 M876 M844 M849 M1,066 M885 M988 M
Accrued expenses887 M1,017 M1,141 M1,347 M1,153 M1,080 M1,263 M1,452 M1,279 M1,462 M
Accumulated depreciation & depletion-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-8,699 M
Additional paid in capital5,078 M5,154 M5,529 M6,404 M6,666 M6,890 M7,204 M7,375 M8,880 M9,522 M
Cash and equivalents16 M26 M29 M113 M139 M117 M84 M41 M2,245 M157 M
CashCashEquivalentsAndShortTermInvestments16 M26 M29 M113 M139 M117 M84 M41 M2,245 M157 M
CashEquivalents45 M36 M38 M121 M148 M126 M
CommercialPaper321 M1,178 M869 M978 M570 M503 M560 M
Common par3 M3 M3 M884 M884 M884 M1,551 M1,551 M491 M5 M
Common stock equity3,881 M4,109 M4,352 M5,770 M5,987 M5,752 M6,947 M7,575 M8,270 M8,684 M
CommonStock3 M3 M3 M4 M4 M4 M4 M4 M5 M5 M
CommonUtilityPlant18,965 M19,682 M21,313 M22,800 M24,542 M24,180 M25,171 M27,551 M30,482 M34,153 M
Cost in excess1,691 M1,691 M1,691 M1,691 M1,486 M1,486 M1,486 M1,486 M1,486 M1,486 M
CurrentAccruedExpenses270 M282 M308 M240 M256 M247 M288 M306 M364 M425 M
CurrentCapitalLeaseObligation13 M23 M28 M
CurrentDeferredRevenue155 M
CurrentDeferredTaxesLiabilities3,935 M3,799 M2,570 M2,833 M2,898 M2,671 M2,763 M
CurrentProvisions417 M496 M512 M
Deferred revenues155 M256 M243 M238 M325 M294 M269 M
DeferredCosts35 M80 M86 M91 M
DerivativeProductLiabilities23 M45 M29 M47 M134 M145 M
EmployeeBenefits760 M713 M337 M389 M373 M336 M293 M246 M250 M208 M
Float term debt5,949 M6,058 M7,512 M7,105 M7,856 M9,220 M9,183 M9,524 M11,056 M12,075 M
GoodwillAndOtherIntangibleAssets1,944 M1,933 M1,922 M1,911 M1,486 M1,486 M1,486 M1,486 M1,486 M1,486 M
Gross fixed assets (Plant Property & Equipment)18,965 M19,682 M21,313 M22,800 M24,542 M24,180 M25,171 M27,551 M30,482 M34,153 M
IncomeTaxPayable184 M195 M208 M223 M232 M244 M
Intangibles254 M243 M232 M221 M
InterestPayable129 M120 M112 M91 M99 M105 M106 M138 M136 M157 M
Inventories537 M494 M471 M423 M425 M401 M499 M752 M503 M389 M
Invested capital15,778 M16,225 M19,377 M19,981 M21,699 M24,192 M25,314 M26,623 M30,381 M32,833 M
Leases64 M40 M
LongTermCapitalLeaseObligation188 M172 M158 M
LongTermDebtAndCapitalLeaseObligation5,949 M6,058 M7,512 M7,105 M7,856 M9,220 M9,183 M9,524 M11,056 M12,075 M
LongTermProvisions254 M263 M269 M352 M417 M477 M470 M478 M481 M699 M
MaterialsAndSupplies87 M102 M106 M101 M120 M142 M139 M151 M172 M173 M
Minority interest5,987 M86 M326 M326 M1,867 M1,984 M
Net fixed assets (net PP&E)12,112 M13,068 M14,360 M15,543 M16,912 M16,620 M17,882 M19,843 M22,275 M25,454 M
NetUtilityPlant18,965 M19,682 M21,313 M22,800 M24,542 M24,180 M25,171 M27,551 M30,482 M34,153 M
Non-current deferred income taxes2,380 M2,541 M1,305 M1,342 M1,485 M1,471 M1,659 M1,855 M2,080 M2,282 M
NonCurrentAccruedExpenses87 M83 M80 M84 M82 M85 M
NonCurrentDeferredAssets35 M80 M86 M91 M
NonCurrentDeferredLiabilities2,380 M2,541 M1,305 M1,342 M1,485 M1,471 M1,659 M1,855 M2,080 M2,282 M
NonCurrentDeferredTaxesAssets-1,570 M1,271 M1,277 M1,503 M1,413 M1,207 M1,111 M
NonCurrentPensionAndOtherPostretirementBenefitPlans760 M713 M337 M389 M373 M336 M293 M246 M250 M208 M
Other current assets314 M379 M355 M365 M344 M222 M502 M571 M293 M822 M
Other equity adjustments38 M37 M32 M19 M20 M-157 M
Other fixed assets18,988 M20,050 M21,650 M22,820 M24,542 M24,180 M25,171 M
Other non-current assets1,686 M1,734 M1,707 M2,177 M2,178 M2,058 M2,609 M2,743 M3,024 M2,157 M
Other non-current liabilities1,602 M1,466 M2,991 M2,812 M2,580 M2,420 M2,533 M2,567 M1,860 M1,744 M
Other receivable237 M330 M359 M324 M351 M338 M
OtherCurrentBorrowings567 M1,488 M1,206 M1,977 M1,773 M503 M560 M1,762 M3,049 M605 M
OtherCurrentLiabilities669 M530 M412 M529 M537 M430 M627 M598 M569 M497 M
OtherDeferredCosts35 M80 M86 M91 M
OtherInventories450 M393 M365 M322 M305 M260 M360 M601 M331 M216 M
Payables617 M735 M834 M1,107 M898 M833 M975 M1,146 M916 M1,037 M
Preferred securities of subsidiary trust20 M880 M880 M880 M1,547 M1,547 M486 M
PreferredStock20 M880 M880 M880 M1,547 M1,547 M486 M
Prepaid expenses106 M139 M
RecievablesAdjustmentsAllowances-20 M-23 M-18 M-21 M-19 M-52 M-23 M-24 M-23 M-24 M
Restricted cash30 M10 M9 M8 M9 M9 M11 M35 M36 M42 M
Retained earnings-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-742 M
Short term debt1,001 M1,851 M1,490 M2,027 M1,787 M526 M618 M1,792 M3,072 M1,886 M
Total assets17,493 M18,692 M19,962 M21,804 M22,660 M22,041 M24,157 M26,737 M31,077 M31,788 M
Total current assets1,556 M1,757 M1,763 M1,967 M1,774 M1,540 M1,921 M2,584 M4,499 M2,080 M
Total current liabilities2,558 M3,415 M3,087 M3,903 M3,746 M2,279 M2,746 M4,661 M5,265 M4,113 M
Total equity3,881 M4,109 M4,352 M5,770 M5,987 M5,752 M6,947 M7,575 M8,270 M8,684 M
Total liabilities13,611 M14,583 M15,610 M16,034 M16,673 M16,203 M16,884 M18,835 M20,941 M21,120 M
Total non-current assets15,936 M16,935 M18,198 M19,837 M20,885 M20,501 M22,236 M24,296 M27,032 M29,276 M
Total non-current liabilities4,704 M4,954 M4,651 M4,620 M4,932 M
TotalDeferredCreditsAndOtherNonCurrentLiabilities11,054 M11,169 M12,523 M12,131 M12,927 M13,923 M14,138 M14,669 M15,726 M17,006 M
TotalEquityGrossMinority3,881 M4,109 M4,352 M5,770 M5,987 M5,838 M7,273 M7,902 M10,136 M10,668 M
TotalEquityGrossMinorityInterest3,881 M4,109 M4,352 M5,770 M5,987 M5,838 M7,273 M7,902 M10,136 M10,668 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest17,493 M18,692 M19,962 M21,804 M22,660 M22,041 M24,157 M26,737 M31,077 M31,788 M
TotalNonCurrentLiabilitiesNetMinorityInteres4,704 M4,954 M4,651 M4,620 M4,932 M
TotalTaxPayable184 M195 M208 M223 M232 M244 M277 M246 M166 M173 M
Treasury stock-79 M-89 M-96 M-100 M-100 M-100 M-100 M-100 M-100 M-100 M
UnrealizedGainLoss38 M37 M32 M19 M20 M
Working capital-1,001 M-1,658 M-1,323 M-1,936 M-1,971 M-740 M-825 M-2,076 M-766 M-2,033 M
debtc1,001 M1,851 M1,490 M2,027 M1,787 M526 M618 M1,792 M3,072 M1,886 M
ltinv195 M200 M210 M206 M230 M252 M260 M224 M247 M179 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 provides all the tools I need for in-depth stock analysis. It's user-friendly and constantly improving. A must-have for serious investors.

John D.

Financial Analyst

I have been using MarketXLS for the last 6+ years and they really enhanced the product every year and now in the journey of bringing in AI...

Kirubakaran K.

Investment Professional

MarketXLS is a powerful tool for financial modeling. It integrates seamlessly with Excel and provides real-time data.

David L.

Financial Analyst

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel.

Lloyd L.

Professional Trader