The Southern Company (SO) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
The Southern Company (SO) Bundle
Looking to assess The Southern Company's intrinsic value? Our (SO) DCF Calculator integrates real-world data with extensive customization features, enabling you to refine your forecasts and enhance your investment strategies.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2019 |
AY2 2020 |
AY3 2021 |
AY4 2022 |
AY5 2023 |
FY1 2024 |
FY2 2025 |
FY3 2026 |
FY4 2027 |
FY5 2028 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 21,419.0 | 20,375.0 | 23,113.0 | 29,279.0 | 25,253.0 | 26,609.8 | 28,039.5 | 29,546.0 | 31,133.4 | 32,806.1 |
| Revenue Growth, % | 0 | -4.87 | 13.44 | 26.68 | -13.75 | 5.37 | 5.37 | 5.37 | 5.37 | 5.37 |
| EBITDA | 11,610.0 | 9,197.0 | 8,314.0 | 9,969.0 | 11,745.0 | 11,488.6 | 12,105.8 | 12,756.3 | 13,441.6 | 14,163.8 |
| EBITDA, % | 54.2 | 45.14 | 35.97 | 34.05 | 46.51 | 43.17 | 43.17 | 43.17 | 43.17 | 43.17 |
| Depreciation | 3,325.0 | 3,902.0 | 3,982.0 | 4,059.0 | 4,963.0 | 4,546.0 | 4,790.2 | 5,047.6 | 5,318.8 | 5,604.5 |
| Depreciation, % | 15.52 | 19.15 | 17.23 | 13.86 | 19.65 | 17.08 | 17.08 | 17.08 | 17.08 | 17.08 |
| EBIT | 8,285.0 | 5,295.0 | 4,332.0 | 5,910.0 | 6,782.0 | 6,942.6 | 7,315.6 | 7,708.7 | 8,122.8 | 8,559.3 |
| EBIT, % | 38.68 | 25.99 | 18.74 | 20.19 | 26.86 | 26.09 | 26.09 | 26.09 | 26.09 | 26.09 |
| Total Cash | 1,975.0 | 1,065.0 | 1,798.0 | 1,917.0 | 748.0 | 1,689.0 | 1,779.7 | 1,875.4 | 1,976.1 | 2,082.3 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 3,409.0 | 3,335.0 | 2,962.0 | 3,716.0 | 3,963.0 | 3,910.8 | 4,120.9 | 4,342.3 | 4,575.6 | 4,821.5 |
| Account Receivables, % | 15.92 | 16.37 | 12.82 | 12.69 | 15.69 | 14.7 | 14.7 | 14.7 | 14.7 | 14.7 |
| Inventories | 2,388.0 | 2,488.0 | 2,355.0 | 2,677.0 | 3,352.0 | 2,978.5 | 3,138.5 | 3,307.1 | 3,484.8 | 3,672.0 |
| Inventories, % | 11.15 | 12.21 | 10.19 | 9.14 | 13.27 | 11.19 | 11.19 | 11.19 | 11.19 | 11.19 |
| Accounts Payable | 2,557.0 | 2,806.0 | 2,169.0 | 3,525.0 | 2,898.0 | 3,119.2 | 3,286.7 | 3,463.3 | 3,649.4 | 3,845.5 |
| Accounts Payable, % | 11.94 | 13.77 | 9.38 | 12.04 | 11.48 | 11.72 | 11.72 | 11.72 | 11.72 | 11.72 |
| Capital Expenditure | -7,555.0 | -7,441.0 | -7,240.0 | -7,923.0 | -9,095.0 | -8,844.7 | -9,319.9 | -9,820.7 | -10,348.3 | -10,904.3 |
| Capital Expenditure, % | -35.27 | -36.52 | -31.32 | -27.06 | -36.02 | -33.24 | -33.24 | -33.24 | -33.24 | -33.24 |
| Tax Rate, % | 8.49 | 8.49 | 8.49 | 8.49 | 8.49 | 8.49 | 8.49 | 8.49 | 8.49 | 8.49 |
| EBITAT | 6,020.6 | 4,746.7 | 4,049.5 | 4,947.2 | 6,206.0 | 5,984.7 | 6,306.2 | 6,645.0 | 7,002.0 | 7,378.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -1,449.4 | 1,430.7 | 660.5 | 1,363.2 | 525.0 | 2,332.8 | 1,573.9 | 1,658.5 | 1,747.6 | 1,841.5 |
| WACC, % | 5.37 | 5.68 | 5.75 | 5.57 | 5.71 | 5.62 | 5.62 | 5.62 | 5.62 | 5.62 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 7,833.5 | |||||||||
| Long Term Growth Rate, % | 3.50 | |||||||||
| Free cash flow (T + 1) | 1,906 | |||||||||
| Terminal Value | 90,111 | |||||||||
| Present Terminal Value | 68,572 | |||||||||
| Enterprise Value | 76,406 | |||||||||
| Net Debt | 62,742 | |||||||||
| Equity Value | 13,664 | |||||||||
| Diluted Shares Outstanding, MM | 1,098 | |||||||||
| Equity Value Per Share | 12.44 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: The Southern Company’s (SO) financial data pre-filled to kickstart your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you.
- Customizable and Professional: A refined Excel model that adjusts to your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, validating strategies, and saving time.
Key Features
- Customizable Forecast Inputs: Adjust essential metrics such as revenue growth, EBITDA %, and capital expenditures.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and other financial metrics.
- High-Precision Accuracy: Leverages The Southern Company's real-world financial data for dependable valuation results.
- Effortless Scenario Analysis: Easily evaluate various assumptions and analyze the resulting impacts.
- Efficiency Booster: Remove the hassle of constructing intricate valuation models from the ground up.
How It Works
- Step 1: Download the prebuilt Excel template featuring The Southern Company’s (SO) data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see the recalculated results, including The Southern Company’s (SO) intrinsic value.
- Step 5: Utilize the outputs to make informed investment decisions or create detailed reports.
Why Choose This Calculator?
- Designed for Experts: A sophisticated tool tailored for analysts, CFOs, and financial consultants.
- Accurate Historical Data: The Southern Company's (SO) past and projected financials are preloaded for precision.
- Comprehensive Scenario Analysis: Effortlessly test various forecasts and assumptions.
- Transparent Outputs: Instantly calculates intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Detailed step-by-step guidance to navigate the process with ease.
Who Should Use The Southern Company (SO)?
- Investors: Make informed choices with a reliable resource for evaluating The Southern Company (SO).
- Financial Analysts: Streamline your analysis with pre-built models tailored for The Southern Company (SO).
- Consultants: Easily modify reports and presentations to meet client needs focusing on The Southern Company (SO).
- Energy Sector Enthusiasts: Enhance your knowledge of the utility industry through real-life case studies of The Southern Company (SO).
- Educators and Students: Utilize it as a hands-on educational tool in energy finance courses.
What the Template Contains
- Pre-Filled DCF Model: The Southern Company's (SO) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate The Southern Company's (SO) profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.