NiSource Inc.: DCF model
A discounted-cash-flow model filled in from NiSource Inc.'s filings as reported. Change any assumption; the values follow at once.
A tool for your own analysis, not investment advice. It does arithmetic on the figures the company filed and on assumptions you choose; it does not forecast, and the result is only as good as those assumptions. Every formula is on the methodology page.
Market price USD 43.69 on Oct 23, 2026: Closing price the SEC publishes with its fails-to-deliver data (NI).
Assumptions: Base case
Change any figure; the values follow at once.
Revenue and margins
From the filings10-K filed Feb 11, 2026
The years between change on a straight line.
From the filingsThe first year starts at Revenue growth a year from FY2022 to FY2025 (3 years): 4.36% a year; the years after are your assumption.
The years between change on a straight line.
From the filingsAverage operating margin, FY2023–FY2025: 26.64%; the years ahead are your assumption.
Tax and reinvestment
Your assumptionThe effective rate cannot be worked out (losses or no tax line): 25% to start with.
From the filingsAverage share of revenue, FY2023–FY2025
From the filingsAverage share of revenue, FY2023–FY2025
From the filingsAverage operating working capital (current assets less cash and short-term investments, less current liabilities other than debt) as a share of revenue, FY2023–FY2025
Discount rate
Your assumption1.0 to start with
Your assumption5% to start with
From the filingsInterest expense of FY2025 over its average debt, held between the risk-free rate and 8 points above it
From the filingsDebt over debt plus market value on Oct 23, 2026
After the last year
Your assumptionImplies -4.1× the last year's EBITDA.
From value to shares (every case)
Balance sheet of Q3FY2026, Sep 30, 2026 · 10-Q filed Oct 28, 2026
From the filings
From the filings
From the filings
From the filings
Your assumption
From the filingsdiluted, weighted average, Q3FY2026 · 10-Q filed Oct 28, 2026
The three cases
Base case: value per share
Discount rate 7.09%; long-run growth 2.50%. Values as at the end of FY2025.
| Present value of the 5 projected years | −USD 2.4 B |
|---|---|
| Present value after the last year | −USD 10.1 B |
| Enterprise value (the whole business) | −USD 12.5 B |
| Less debt | USD 17.5 B |
| Plus cash and short-term investments | USD 58 M |
| Less minority interests | USD 2.4 B |
| Equity value (the shareholders') | −USD 32.3 B |
| Divided by shares (millions) | 481.1 |
| Value per share | USD -67.17 |
Value per share
USD -67.17
Below zero: with these figures the debt is worth more than the business.
Price USD 43.69 on Oct 23, 2026
Base case: year by year
Millions of USD. The FY2025 column is as reported; the years after are projected. Tax, capital spending and working capital are signed as they add to (+) or take from (−) free cash flow.
| USD millions | FY2025reported | FY2026projected | FY2027projected | FY2028projected | FY2029projected | FY2030projected |
|---|---|---|---|---|---|---|
| Revenue | 6,523 | 6,807 | 7,073 | 7,315 | 7,533 | 7,721 |
| Growth | 23.5% | 4.4% | 3.9% | 3.4% | 3.0% | 2.5% |
| Operating income (EBIT) | 1,835 | 1,813 | 1,884 | 1,949 | 2,007 | 2,057 |
| Operating margin | 28.1% | 26.6% | 26.6% | 26.6% | 26.6% | 26.6% |
| Tax on operating income | −453 | −471 | −487 | −502 | −514 | |
| Depreciation and amortisation | 1,168 | 1,240 | 1,288 | 1,332 | 1,372 | 1,406 |
| Capital spending | −2,782 | −3,213 | −3,338 | −3,453 | −3,555 | −3,644 |
| Change in working capital | 86 | 81 | 74 | 66 | 57 | |
| Free cash flow to the firm | 24 | −527 | −557 | −586 | −613 | −639 |
| Discount factor | 0.9338 | 0.8720 | 0.8143 | 0.7604 | 0.7101 | |
| Present value | −492 | −485 | −477 | −466 | −453 |
Base case: sensitivity
How the value per share moves when one pair of figures changes and the rest stay as they are.
Discount rate and long-run growth
Value per share in USD; your figures in the outlined middle; green at or above the market price, red below it.
| Discount rate ↓ · Long-run growth → | 1.5% | 2.0% | 2.5% | 3.0% | 3.5% |
|---|---|---|---|---|---|
| 5.09% | -75.7 | -80.61 | -87.43 | -97.51 | -113.95 |
| 6.09% | -68.1 | -70.9 | -74.47 | -79.21 | -85.77 |
| 7.09% | -63.23 | -65.01 | -67.17 | -69.86 | -73.3 |
| 8.09% | -59.84 | -61.05 | -62.48 | -64.19 | -66.27 |
| 9.09% | -57.34 | -58.21 | -59.22 | -60.38 | -61.76 |
Revenue growth and operating margin
Value per share in USD; your figures in the outlined middle; green at or above the market price, red below it.
| Growth, every year ↓ · Margin, every year → | −4 pt | −2 pt | ±0 pt | +2 pt | +4 pt |
|---|---|---|---|---|---|
| −4 pt | -73.95 | -69.99 | -66.03 | -62.06 | -58.1 |
| −2 pt | -75.31 | -70.97 | -66.63 | -62.29 | -57.95 |
| ±0 pt | -76.66 | -71.91 | -67.17 | -62.42 | -57.68 |
| +2 pt | -77.99 | -72.81 | -67.62 | -62.44 | -57.26 |
| +4 pt | -79.29 | -73.64 | -67.98 | -62.33 | -56.68 |
Where the figures come from
The statements as reported, in millions of USD; hover a figure for its filing.
| USD millions | FY2025to Dec 31, 2025 | FY2024to Dec 31, 2024 | FY2023to Dec 31, 2023 | FY2022to Dec 31, 2022 | FY2021to Dec 31, 2021 | FY2020to Dec 31, 2020 |
|---|---|---|---|---|---|---|
| Revenue | 6,523 | 5,283 | 5,348 | 5,739 | 4,731 | 4,473 |
| Growth | 23.5% | -1.2% | -6.8% | 21.3% | 5.8% | — |
| Operating income | 1,835 | 1,456 | 1,296 | 1,266 | 1,007 | 551 |
| Operating margin | 28.1% | 27.6% | 24.2% | 22.1% | 21.3% | 12.3% |
| Effective tax rate | — | — | — | — | — | — |
| D&A, % of revenue | 17.9% | 19.7% | 17.0% | 14.3% | 15.8% | 16.2% |
| Capital spending, % of revenue | 42.7% | 49.5% | 49.5% | 38.4% | 38.8% | 39.3% |
| Working capital, % of revenue | -17.9% | -17.2% | -55.9% | -36.4% | -18.0% | -15.9% |
| Free cash flow to the firm | 24 | −2,558 | 134 | 803 | −196 | — |
| Filing | 10-K | 10-K | 10-K | 10-K | 10-K | 10-K |
- From the filings: revenue, margins, tax rate, depreciation, capital spending and working capital (fiscal years above), debt, cash, leases and minority interests (balance sheet of Q3FY2026), and the share count (Q3FY2026).
- Market data: US Treasury daily par yield curve, 10-year (Nov 20, 2026); Market price USD 43.69 on Oct 23, 2026: Closing price the SEC publishes with its fails-to-deliver data (NI).
- Your assumptions: the growth path and margins ahead, beta, the equity risk premium, long-run growth or the exit multiple, and the weights of the cases. How each figure is worked out: methodology.