Empresa Distribuidora y Comercializadora Norte Sociedad Anónima (EDN) 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
Empresa Distribuidora y Comercializadora Norte Sociedad Anónima (EDN) Bundle
Enhance your investment choices with the (EDN) DCF Calculator! Explore authentic financial data for Empresa Distribuidora y Comercializadora Norte Sociedad Anónima, adjust growth projections and expenses, and observe how these modifications instantly affect the intrinsic value of (EDN).
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 | 87.9 | 89.2 | 110.9 | 201.1 | 685.0 | 1,039.7 | 1,578.3 | 2,395.7 | 3,636.5 | 5,519.9 |
| Revenue Growth, % | 0 | 1.53 | 24.29 | 81.35 | 240.61 | 51.79 | 51.79 | 51.79 | 51.79 | 51.79 |
| EBITDA | 10.7 | -14.9 | 4.0 | -19.3 | -35.7 | -32.7 | -49.6 | -75.3 | -114.3 | -173.6 |
| EBITDA, % | 12.14 | -16.66 | 3.62 | -9.6 | -5.21 | -3.14 | -3.14 | -3.14 | -3.14 | -3.14 |
| Depreciation | 5.8 | 7.9 | 10.5 | 27.3 | 83.6 | 105.5 | 160.2 | 243.2 | 369.1 | 560.3 |
| Depreciation, % | 6.6 | 8.89 | 9.47 | 13.58 | 12.21 | 10.15 | 10.15 | 10.15 | 10.15 | 10.15 |
| EBIT | 4.9 | -22.8 | -6.5 | -46.6 | -119.3 | -138.2 | -209.8 | -318.5 | -483.5 | -733.9 |
| EBIT, % | 5.54 | -25.55 | -5.85 | -23.18 | -17.42 | -13.29 | -13.29 | -13.29 | -13.29 | -13.29 |
| Total Cash | 4.3 | 9.8 | 35.9 | 92.3 | 89.6 | 222.9 | 338.4 | 513.7 | 779.7 | 1,183.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 17.2 | 21.4 | 36.7 | 139.0 | 95.4 | 332.2 | 504.2 | 765.4 | 1,161.8 | 1,763.6 |
| Account Receivables, % | 19.53 | 24.03 | 33.13 | 69.13 | 13.93 | 31.95 | 31.95 | 31.95 | 31.95 | 31.95 |
| Inventories | 2.5 | 2.7 | 6.5 | 19.6 | 38.9 | 56.5 | 85.7 | 130.2 | 197.6 | 299.9 |
| Inventories, % | 2.81 | 3.04 | 5.9 | 9.74 | 5.68 | 5.43 | 5.43 | 5.43 | 5.43 | 5.43 |
| Accounts Payable | 16.9 | 48.7 | 126.0 | 474.0 | 191.4 | 627.4 | 952.4 | 1,445.7 | 2,194.5 | 3,331.0 |
| Accounts Payable, % | 19.22 | 54.56 | 113.61 | 235.72 | 27.95 | 60.35 | 60.35 | 60.35 | 60.35 | 60.35 |
| Capital Expenditure | -9.2 | -9.6 | -14.4 | -31.0 | -117.0 | -138.6 | -210.5 | -319.5 | -484.9 | -736.1 |
| Capital Expenditure, % | -10.42 | -10.78 | -12.97 | -15.41 | -17.08 | -13.33 | -13.33 | -13.33 | -13.33 | -13.33 |
| Tax Rate, % | 73.45 | 73.45 | 73.45 | 73.45 | 73.45 | 73.45 | 73.45 | 73.45 | 73.45 | 73.45 |
| EBITAT | 2.6 | -19.0 | -24.3 | -309.2 | -31.7 | -100.4 | -152.3 | -231.2 | -351.0 | -532.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -3.5 | 6.6 | 30.0 | -80.1 | -323.4 | 48.1 | -78.9 | -119.8 | -181.8 | -276.0 |
| WACC, % | 10.18 | 10.42 | 10.56 | 10.56 | 9.97 | 10.34 | 10.34 | 10.34 | 10.34 | 10.34 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -401.8 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -282 | |||||||||
| Terminal Value | -3,376 | |||||||||
| Present Terminal Value | -2,064 | |||||||||
| Enterprise Value | -2,466 | |||||||||
| Net Debt | 87 | |||||||||
| Equity Value | -2,553 | |||||||||
| Diluted Shares Outstanding, MM | 875 | |||||||||
| Equity Value Per Share | -2.92 |
What You Will Get
- Pre-Filled Financial Model: EDN’s actual data allows for accurate DCF valuation.
- Full Forecast Control: Modify revenue growth, profit margins, WACC, and other essential parameters.
- Instant Calculations: Real-time updates ensure you see the impact of your adjustments immediately.
- Investor-Ready Template: A polished Excel file crafted for high-quality valuation presentations.
- Customizable and Reusable: Designed for adaptability, enabling repeated use for comprehensive forecasts.
Key Features
- Customizable Forecast Inputs: Adjust essential metrics such as revenue growth, EBITDA %, and capital investments.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and additional outputs.
- High-Precision Accuracy: Utilizes EDN’s actual financial data for credible valuation results.
- Effortless Scenario Analysis: Easily explore various assumptions and assess outcomes side by side.
- 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 data for Empresa Distribuidora y Comercializadora Norte Sociedad Anónima (EDN).
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Adjust forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see the recalculated results, including the intrinsic value of Empresa Distribuidora y Comercializadora Norte Sociedad Anónima (EDN).
- Step 5: Use the outputs to make informed investment decisions or create detailed reports.
Why Choose EDN (EDN)?
- Save Time: No need to start from scratch – our solutions are ready for immediate use.
- Enhance Accuracy: Dependable data and calculations minimize errors in your assessments.
- Completely Customizable: Adjust our tools to align with your specific needs and forecasts.
- Simple to Understand: Intuitive visuals and outputs make results straightforward to interpret.
- Endorsed by Professionals: Crafted for experts who prioritize accuracy and ease of use.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for portfolio management of EDN (EDN).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the company.
- Consultants and Advisors: Deliver precise valuation insights to clients regarding EDN (EDN) stock.
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Industry Analysts: Gain insights into how distribution and commercial companies like EDN (EDN) are valued in the marketplace.
What the Template Contains
- Pre-Filled Data: Includes EDN's historical financials and projections.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze EDN's profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.