Discounted Cash Flow (DCF) Analysis Levered

Southern Company (The) 2019 Ser (SOLN)

$56.16

+0.72 (+1.30%)
All numbers are in Millions, Currency in USD

Free Cash Flow

Year
A/P
2017
Actual
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Projected
2023
Projected
2024
Projected
2025
Projected
2026
Projected
Revenue 23,03123,49521,41920,37523,11323,213.6923,314.8223,416.4023,518.4123,620.87
Revenue (%)
Operating Cash Flow 6,3956,9455,7816,6966,1696,679.556,708.656,737.876,767.236,796.71
Operating Cash Flow (%)
Capital Expenditure -7,423-8,001-7,555-7,441-7,240-7,864.87-7,899.13-7,933.55-7,968.11-8,002.82
Capital Expenditure (%)
Free Cash Flow -1,028-1,056-1,774-745-1,071-1,185.32-1,190.49-1,195.67-1,200.88-1,206.11

Weighted Average Cost Of Capital

Share price $ 56.16
Beta 0.000
Diluted Shares Outstanding -
Cost of Debt
Tax Rate 6.52
After-tax Cost of Debt 3.09%
Risk-Free Rate
Market Risk Premium
Cost of Equity 3.804
Total Debt 55,470
Total Equity -
Total Capital -
Debt Weighting -
Equity Weighting -
Wacc

Build Up Free Cash Flow

Year
A/P
2017
Actual
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Projected
2023
Projected
2024
Projected
2025
Projected
2026
Projected
Revenue 23,03123,49521,41920,37523,11323,213.6923,314.8223,416.4023,518.4123,620.87
Operating Cash Flow 6,3956,9455,7816,6966,1696,679.556,708.656,737.876,767.236,796.71
Capital Expenditure -7,423-8,001-7,555-7,441-7,240-7,864.87-7,899.13-7,933.55-7,968.11-8,002.82
Free Cash Flow -1,028-1,056-1,774-745-1,071-1,185.32-1,190.49-1,195.67-1,200.88-1,206.11
WACC
PV LFCF -----
SUM PV LFCF -

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) -
Free cash flow (t + 1) -1,230.24
Terminal Value -
Present Value of Terminal Value -

Intrinsic Value

Enterprise Value -
Net Debt 53,672
Equity Value -
Shares Outstanding -
Equity Value Per Share -