|
Centrais Elétricas Brasileiras S.A. - Eletrobrás (EBR) DCF Valuation
BR | Utilities | Regulated Electric | NYSE
|
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Centrais Elétricas Brasileiras S.A. - Eletrobrás (EBR) Bundle
Evaluate Centrais Elétricas Brasileiras S.A. - Eletrobrás's financial outlook like an expert! This (EBR) DCF Calculator provides pre-filled financial data while allowing you the freedom to modify revenue growth, WACC, margins, and other crucial assumptions to align with your projections.
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 | 4,474.5 | 4,693.1 | 6,070.7 | 5,499.0 | 5,996.9 | 6,504.7 | 7,055.6 | 7,653.1 | 8,301.3 | 9,004.3 |
| Revenue Growth, % | 0 | 4.89 | 29.35 | -9.42 | 9.05 | 8.47 | 8.47 | 8.47 | 8.47 | 8.47 |
| EBITDA | 1,708.9 | 1,828.1 | 2,272.0 | 1,463.5 | 1,906.5 | 2,250.3 | 2,440.9 | 2,647.6 | 2,871.8 | 3,115.1 |
| EBITDA, % | 38.19 | 38.95 | 37.43 | 26.61 | 31.79 | 34.6 | 34.6 | 34.6 | 34.6 | 34.6 |
| Depreciation | 291.7 | 300.6 | 232.9 | 434.2 | 584.4 | 447.6 | 485.5 | 526.6 | 571.2 | 619.5 |
| Depreciation, % | 6.52 | 6.41 | 3.84 | 7.9 | 9.75 | 6.88 | 6.88 | 6.88 | 6.88 | 6.88 |
| EBIT | 1,417.2 | 1,527.4 | 2,039.1 | 1,029.4 | 1,322.1 | 1,802.8 | 1,955.4 | 2,121.0 | 2,300.7 | 2,495.5 |
| EBIT, % | 31.67 | 32.55 | 33.59 | 18.72 | 22.05 | 27.71 | 27.71 | 27.71 | 27.71 | 27.71 |
| Total Cash | 2,693.4 | 2,312.0 | 2,667.4 | 3,812.1 | 2,577.3 | 3,456.6 | 3,749.3 | 4,066.9 | 4,411.3 | 4,784.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 852.3 | 963.7 | 822.2 | 773.8 | 840.9 | 1,056.7 | 1,146.1 | 1,243.2 | 1,348.5 | 1,462.7 |
| Account Receivables, % | 19.05 | 20.53 | 13.54 | 14.07 | 14.02 | 16.24 | 16.24 | 16.24 | 16.24 | 16.24 |
| Inventories | 163.1 | 151.4 | 180.0 | 202.8 | 68.9 | 190.9 | 207.1 | 224.6 | 243.6 | 264.3 |
| Inventories, % | 3.65 | 3.23 | 2.97 | 3.69 | 1.15 | 2.93 | 2.93 | 2.93 | 2.93 | 2.93 |
| Accounts Payable | 499.6 | 630.1 | 650.6 | 567.6 | 478.3 | 697.4 | 756.4 | 820.5 | 890.0 | 965.4 |
| Accounts Payable, % | 11.16 | 13.42 | 10.72 | 10.32 | 7.98 | 10.72 | 10.72 | 10.72 | 10.72 | 10.72 |
| Capital Expenditure | -326.0 | -386.8 | -434.5 | -5,426.4 | -665.1 | -1,723.2 | -1,869.1 | -2,027.4 | -2,199.1 | -2,385.4 |
| Capital Expenditure, % | -7.29 | -8.24 | -7.16 | -98.68 | -11.09 | -26.49 | -26.49 | -26.49 | -26.49 | -26.49 |
| Tax Rate, % | -163.24 | -163.24 | -163.24 | -163.24 | -163.24 | -163.24 | -163.24 | -163.24 | -163.24 | -163.24 |
| EBITAT | 1,659.8 | 1,403.2 | 1,047.2 | 815.4 | 3,480.2 | 1,523.1 | 1,652.1 | 1,792.0 | 1,943.8 | 2,108.4 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 1,109.6 | 1,347.8 | 979.1 | -4,234.2 | 3,377.1 | 128.8 | 221.9 | 240.7 | 261.0 | 283.2 |
| WACC, % | 8.61 | 8.24 | 6.42 | 7.67 | 8.61 | 7.91 | 7.91 | 7.91 | 7.91 | 7.91 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 887.5 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 289 | |||||||||
| Terminal Value | 4,888 | |||||||||
| Present Terminal Value | 3,341 | |||||||||
| Enterprise Value | 4,229 | |||||||||
| Net Debt | 8,086 | |||||||||
| Equity Value | -3,857 | |||||||||
| Diluted Shares Outstanding, MM | 2,271 | |||||||||
| Equity Value Per Share | -1.70 |
What You Will Get
- Editable Forecast Inputs: Easily adjust parameters (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Eletrobrás’ financial data pre-filled to kickstart your analysis.
- Automatic DCF Outputs: The template automatically computes Net Present Value (NPV) and intrinsic value for you.
- Customizable and Professional: A refined Excel model that caters to your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, validating strategies, and enhancing efficiency.
Key Features
- Comprehensive Historical Data: Eletrobrás’ past financial statements along with pre-filled forecasts.
- Customizable Parameters: Adjust WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Evaluations: Observe the intrinsic value of Eletrobrás (EBR) recalculating instantly.
- Insightful Visual Representations: Dashboard graphs illustrate valuation outcomes and essential metrics.
- Designed for Precision: A reliable tool tailored for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review Eletrobrás's pre-filled financial data and projections.
- Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you modify assumptions.
- Step 5: Evaluate the outputs and leverage the results for your investment strategies.
Why Choose the Eletrobrás Calculator?
- Accuracy: Utilizes authentic Eletrobrás financial data for precise calculations.
- Flexibility: Allows users to easily adjust and test various input scenarios.
- Time-Saving: Avoid the complexities of creating a financial model from the ground up.
- Professional-Grade: Crafted with the expertise and standards expected from CFOs.
- User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling skills.
Who Should Use This Product?
- Finance Students: Explore energy sector valuation methodologies and apply them with real market data.
- Academics: Integrate advanced financial models into your studies or research focused on the energy industry.
- Investors: Validate your investment strategies and analyze valuation scenarios for Eletrobrás (EBR) stock.
- Analysts: Enhance your analysis process with a ready-to-use, customizable DCF model tailored for utility companies.
- Small Business Owners: Understand how major energy firms like Eletrobrás (EBR) are evaluated in the market.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations tailored for Eletrobrás (EBR).
- Real-World Data: Eletrobrás’s historical and projected financials preloaded for in-depth analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into Eletrobrás (EBR).
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Visualizations including charts and tables for clear, actionable results.