All companies
NiSource logo
UtilitiesNI

NiSource (NI) Financial Forecast Calculator

Interactive 5-year forecast and DCF for NiSource. Adjust revenue growth, gross margin, capex intensity, WACC, and terminal growth - see revenue, free cash flow, and enterprise value update in real time. Seeded from NiSource’s most recent SEC filings.

Revenue FY30
$5.74B
from $5.35B
FCF FY30
$722.1M
Margin 12.6%
Enterprise value
$14.02B
2.6× LTM revenue
Equity value
$3.59B
Net debt $10.43B
Revenue & free cash flow - history and 5-year forecast
Line (area)
Bars
Historicals from SEC EDGAR (grey). Forecast years (color) update live as you move the sliders.

Assumptions

Revenue growth (annual)
1.4%
-10.0%baseline 1.4%40.0%
Gross margin
70.0%
5.0%baseline 70.0%90.0%
Capex % of revenue
40.0%
0.0%baseline 40.0%30.0%
WACC (discount rate)
9.00%
4.0%baseline 9.0%18.0%
Terminal growth
2.50%
0.0%baseline 2.5%5.0%

Need this as an Excel model?

Keep iterating on the NiSource forecast in Excel. The downloadable sample has every assumption you see here plus a fully integrated income statement, balance sheet, cash flow, and debt schedule - five years of SEC historicals and live formulas in a fully editable workbook.

income_statement.xlsx
Income statement, brown brand palette
income_statement.xlsx
Income statement, green brand palette
income_statement.xlsx
Income statement, red brand palette

Frequently asked

What kind of company is NiSource and what services does it provide?+

NiSource is a regulated utility holding company that delivers natural gas and electricity to approximately 3.3 million customers. It operates through its Columbia Operations for natural gas distribution and NIPSCO Operations for electric and natural gas services in northern Indiana.

How does NiSource generate its revenue and what drives its earnings?+

NiSource's business model is that of an asset-heavy, rate-regulated utility, where earnings are primarily driven by its capital investments, known as the rate base. Revenue and earnings are also influenced by allowed returns set by state utility commissions.

What is NiSource's capital expenditure strategy and how does it impact the business?+

NiSource has a massive $28.0 billion capital expenditure program planned from FY2026 to FY2030, with a significant portion dedicated to renewable generation and new data center infrastructure. This high capex, often exceeding 70-80% of revenue, is crucial for driving rate base growth and supporting its targeted 8-9% EPS CAGR.

What is the primary purpose of a financial model for NiSource?+

A financial model for NiSource aims to evaluate its equity valuation and credit profile. It specifically assesses whether its substantial capital expenditure program will generate sufficient rate base growth to support its targeted EPS CAGR without jeopardizing its investment-grade credit rating.

Where can I find a downloadable financial model for NiSource (NI)?+

A downloadable Excel financial model for NiSource (NI) is available, covering a forecast horizon from FY2026 to FY2030. This model provides detailed assumptions for revenue growth, margins, and capital expenditures to analyze the company's future performance.

How does NiSource's partnership with Amazon and Blackstone impact its growth strategy?+

NiSource formed NIPSCO Generation LLC (GenCo) to support a landmark data center agreement with Amazon, selling a 19.9% minority interest to Blackstone Infrastructure Partners. This partnership helps fund the associated infrastructure build-out, contributing to the company's overall capital expenditure program and growth objectives.

Have more financial modelling questions? Contact us

Go further

Build the financial model you need with Fina

Browse templates, examples, and downloadable Excel models for the analysis you are trying to build. If you can't find your model, ask Fina to build a model for your specific needs.

Start for free
Excel financial model spreadsheet preview showing Customer Rollforward
Fina interactive chat interface preview