Discounted Cash Flow

Alliant Energy Corp.

LNT · Based on 10 years of SEC filings

Average annual growth rates

Metric 10-Year 5-Year 3-Year
Sales
Free Cash Flow
Average (FCF & NI)
Net Income

Average annual growth is the mean year-over-year change across each period.

Endpoint CAGR (better for long term trend)

Metric 10-Year 5-Year 3-Year
Sales
Free Cash Flow
Average (FCF & NI)
Net Income

Endpoint CAGR is the compound annual rate from the first to last year in each period.

Projections use average year-over-year growth. Change this in Settings.

Projected growth rate

Free cash flow growth
10-year: — 5-year: — 3-year: —
Averaged growth (FCF & NI)
10-year: — 5-year: — 3-year: —
Net income growth
10-year: — 5-year: — 3-year: —
Sales growth (not added to calculations)
10-year: — 5-year: — 3-year: —

Click a greyed-out slider to switch metrics. Slide between the 10-year, 5-year, and 3-year historic growth rates for FCF, net income, or their average.

%
%

Historical inputs (10 fiscal years)

YEAR Sales Net Income Free Cash Flow Net Margin EPS (diluted)
2016 $3.3b $381.7m $-337.2m 11.5%
2017 $3.4b (1.9%) $467.5m (22.5%) $-483.5m (-43.4%) 13.8% (20.2%)
2018 $3.5b (4.5%) $522.3m (11.7%) $-1.1b (-128.8%) 14.8% (6.9%)
2019 $3.6b (3.2%) $567.4m (8.6%) $-979.7m (11.4%) 15.6% (5.3%) $2.34
2020 $3.4b (-6.4%) $624.0m (10.0%) $-865.0m (11.7%) 18.3% (17.4%) $2.47 (5.6%)
2021 $3.7b (7.4%) $674.0m (8.0%) $-587.0m (32.1%) 18.4% (0.6%) $2.63 (6.5%)
2022 $4.2b (14.6%) $686.0m (1.8%) $-998.0m (-70.0%) 16.3% (-11.2%) $2.73 (3.8%)
2023 $4.0b (-4.2%) $703.0m (2.5%) $155.0m (115.5%) 17.5% (7.0%) $2.78 (1.8%)
2024 $4.0b (-1.1%) $690.0m (-1.8%) $-57.0m (-136.8%) 17.3% (-0.7%) $2.69 (-3.2%)
2025 $4.4b (9.6%) $810.0m (17.4%) $1.2b (2150.9%) 18.6% (7.1%) $3.15 (17.1%)

Base FCF: (latest fiscal year)

Discount rate: %

Terminal growth:

Projection period: years

Alt A decline yrs:

Alt B total yrs:

Values abbreviated: b = billions, m = millions, k = thousands.

Projected cash flows

Year Projected cash flow Discount Factor Present Value

PV of projected FCF:

Terminal FCF:

Terminal value:

PV of terminal value:

Enterprise value (DCF):

DCF price per share:

Current price:

Alternative DCF Models

Model Fair Value Upside PV(FCFs) PV(Terminal) Total Years
Standard (10yr→TV) 10 + TV
Alt A (Gradual Decline)
Alt B (30yr Hard Stop) N/A

This is a simplified DCF model for illustration. It uses reported free cash flow, a single growth assumption, fixed WACC, and a Gordon Growth terminal value. It is not investment advice.

+ 10YR Financials Balance Sheet (10YR) Cash Flow (10YR) DCF Model