Duke Energy Corporation (DUK) 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
Duke Energy Corporation (DUK) Bundle
Looking to assess the intrinsic value of Duke Energy Corporation? Our DCF Calculator for (DUK) integrates real-world data with extensive customization features, enabling you to refine your forecasts and enhance your investment choices.
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 | 25,079.0 | 23,366.0 | 24,621.0 | 28,768.0 | 29,060.0 | 30,251.4 | 31,491.6 | 32,782.7 | 34,126.7 | 35,525.8 |
| Revenue Growth, % | 0 | -6.83 | 5.37 | 16.84 | 1.02 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 |
| EBITDA | 10,849.0 | 10,939.0 | 11,632.0 | 12,403.0 | 13,289.0 | 13,683.5 | 14,244.5 | 14,828.5 | 15,436.4 | 16,069.2 |
| EBITDA, % | 43.26 | 46.82 | 47.24 | 43.11 | 45.73 | 45.23 | 45.23 | 45.23 | 45.23 | 45.23 |
| Depreciation | 4,548.0 | 5,486.0 | 5,663.0 | 5,843.0 | 6,084.0 | 6,404.9 | 6,667.4 | 6,940.8 | 7,225.4 | 7,521.6 |
| Depreciation, % | 18.13 | 23.48 | 23 | 20.31 | 20.94 | 21.17 | 21.17 | 21.17 | 21.17 | 21.17 |
| EBIT | 6,301.0 | 5,453.0 | 5,969.0 | 6,560.0 | 7,205.0 | 7,278.6 | 7,577.0 | 7,887.7 | 8,211.0 | 8,547.7 |
| EBIT, % | 25.12 | 23.34 | 24.24 | 22.8 | 24.79 | 24.06 | 24.06 | 24.06 | 24.06 | 24.06 |
| Total Cash | 311.0 | 259.0 | 343.0 | 409.0 | 253.0 | 365.1 | 380.0 | 395.6 | 411.8 | 428.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 3,060.0 | 3,153.0 | 3,522.0 | 4,415.0 | 4,131.0 | 4,208.7 | 4,381.3 | 4,560.9 | 4,747.9 | 4,942.5 |
| Account Receivables, % | 12.2 | 13.49 | 14.3 | 15.35 | 14.22 | 13.91 | 13.91 | 13.91 | 13.91 | 13.91 |
| Inventories | 3,232.0 | 3,167.0 | 3,199.0 | 3,584.0 | 4,292.0 | 4,033.2 | 4,198.6 | 4,370.7 | 4,549.9 | 4,736.4 |
| Inventories, % | 12.89 | 13.55 | 12.99 | 12.46 | 14.77 | 13.33 | 13.33 | 13.33 | 13.33 | 13.33 |
| Accounts Payable | 3,487.0 | 3,144.0 | 3,531.0 | 4,754.0 | 4,228.0 | 4,403.1 | 4,583.6 | 4,771.6 | 4,967.2 | 5,170.8 |
| Accounts Payable, % | 13.9 | 13.46 | 14.34 | 16.53 | 14.55 | 14.56 | 14.56 | 14.56 | 14.56 | 14.56 |
| Capital Expenditure | -11,122.0 | -9,907.0 | -9,715.0 | -11,367.0 | -12,604.0 | -12,650.5 | -13,169.2 | -13,709.1 | -14,271.1 | -14,856.2 |
| Capital Expenditure, % | -44.35 | -42.4 | -39.46 | -39.51 | -43.37 | -41.82 | -41.82 | -41.82 | -41.82 | -41.82 |
| Tax Rate, % | 40.4 | 40.4 | 40.4 | 40.4 | 40.4 | 40.4 | 40.4 | 40.4 | 40.4 | 40.4 |
| EBITAT | 5,764.3 | 8,161.7 | 5,844.9 | 4,102.0 | 4,294.0 | 5,990.7 | 6,236.3 | 6,492.0 | 6,758.2 | 7,035.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -3,614.7 | 3,369.7 | 1,778.9 | -1,477.0 | -3,176.0 | 101.2 | -422.8 | -440.1 | -458.2 | -476.9 |
| WACC, % | 5.36 | 5.55 | 5.5 | 4.73 | 4.67 | 5.16 | 5.16 | 5.16 | 5.16 | 5.16 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -1,409.9 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | -491 | |||||||||
| Terminal Value | -22,717 | |||||||||
| Present Terminal Value | -17,663 | |||||||||
| Enterprise Value | -19,073 | |||||||||
| Net Debt | 80,204 | |||||||||
| Equity Value | -99,277 | |||||||||
| Diluted Shares Outstanding, MM | 771 | |||||||||
| Equity Value Per Share | -128.76 |
What You Will Get
- Real DUK Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed automatically.
- Scenario Analysis: Explore various scenarios to assess Duke Energy's future performance.
- User-Friendly Design: Designed for professionals, yet easy for beginners to navigate.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Duke Energy Corporation (DUK).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs specific to the energy sector.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit Duke Energy's financial outlook.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios pertinent to Duke Energy Corporation (DUK).
- Interactive Dashboard and Charts: Visual representations present key valuation metrics for straightforward analysis.
How It Works
- Download the Template: Get instant access to the Excel-based DUK DCF Calculator.
- Input Your Assumptions: Adjust yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically updates Duke Energy Corporation’s intrinsic value.
- Test Scenarios: Simulate different assumptions to evaluate potential valuation changes.
- Analyze and Decide: Use the results to guide your investment or financial analysis.
Why Choose This Calculator?
- Designed for Experts: A sophisticated tool utilized by energy analysts, CFOs, and industry consultants.
- Accurate Data: Duke Energy’s historical and projected financials are preloaded for precision.
- Forecast Simulation: Easily test various scenarios and assumptions.
- Comprehensive Outputs: Automatically calculates intrinsic value, NPV, and essential metrics.
- User-Friendly: Step-by-step guidance ensures a smooth experience.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Duke Energy Corporation (DUK) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for Duke Energy Corporation (DUK).
- Consultants: Deliver professional valuation insights on Duke Energy Corporation (DUK) to clients quickly and accurately.
- Business Owners: Understand how large utilities like Duke Energy Corporation (DUK) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Duke Energy Corporation (DUK).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Duke Energy Corporation (DUK) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Duke Energy Corporation (DUK).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.