Eni S.p.A. (E) 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
Eni S.p.A. (E) Bundle
Engineered for accuracy, our Eni S.p.A. (E) DCF Calculator empowers you to evaluate Eni S.p.A. valuation using real-world financial data, offering complete flexibility to modify all key parameters for improved 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 | 72,845.8 | 45,853.2 | 79,823.8 | 138,134.1 | 97,693.1 | 117,427.9 | 141,149.2 | 169,662.5 | 203,935.7 | 245,132.3 |
Revenue Growth, % | 0 | -37.05 | 74.09 | 73.05 | -29.28 | 20.2 | 20.2 | 20.2 | 20.2 | 20.2 |
EBITDA | 16,197.2 | 3,748.6 | 20,698.4 | 29,734.2 | 18,512.5 | 22,737.7 | 27,330.8 | 32,851.9 | 39,488.2 | 47,465.2 |
EBITDA, % | 22.23 | 8.18 | 25.93 | 21.53 | 18.95 | 19.36 | 19.36 | 19.36 | 19.36 | 19.36 |
Depreciation | 8,939.9 | 7,239.7 | 7,512.8 | 7,718.1 | 8,151.8 | 12,072.6 | 14,511.4 | 17,442.8 | 20,966.4 | 25,201.8 |
Depreciation, % | 12.27 | 15.79 | 9.41 | 5.59 | 8.34 | 10.28 | 10.28 | 10.28 | 10.28 | 10.28 |
EBIT | 7,257.4 | -3,491.1 | 13,185.7 | 22,016.1 | 10,360.7 | 10,665.0 | 12,819.5 | 15,409.1 | 18,521.8 | 22,263.4 |
EBIT, % | 9.96 | -7.61 | 16.52 | 15.94 | 10.61 | 9.08 | 9.08 | 9.08 | 9.08 | 9.08 |
Total Cash | 13,695.4 | 15,812.6 | 19,663.3 | 20,754.7 | 17,695.2 | 26,082.4 | 31,351.3 | 37,684.5 | 45,297.0 | 54,447.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 11,629.3 | 9,778.0 | 18,150.7 | 18,973.2 | 18,666.7 | 21,811.1 | 26,217.1 | 31,513.2 | 37,879.1 | 45,530.9 |
Account Receivables, % | 15.96 | 21.32 | 22.74 | 13.74 | 19.11 | 18.57 | 18.57 | 18.57 | 18.57 | 18.57 |
Inventories | 4,934.8 | 4,058.2 | 6,329.6 | 8,036.1 | 6,448.5 | 8,448.4 | 10,155.0 | 12,206.4 | 14,672.2 | 17,636.0 |
Inventories, % | 6.77 | 8.85 | 7.93 | 5.82 | 6.6 | 7.19 | 7.19 | 7.19 | 7.19 | 7.19 |
Accounts Payable | 10,924.6 | 9,047.2 | 17,507.6 | 20,355.5 | 14,834.8 | 20,334.2 | 24,441.9 | 29,379.3 | 35,314.2 | 42,447.9 |
Accounts Payable, % | 15 | 19.73 | 21.93 | 14.74 | 15.19 | 17.32 | 17.32 | 17.32 | 17.32 | 17.32 |
Capital Expenditure | -8,731.4 | -4,828.5 | -5,458.1 | -816.2 | -9,606.0 | -9,342.1 | -11,229.2 | -13,497.6 | -16,224.3 | -19,501.7 |
Capital Expenditure, % | -11.99 | -10.53 | -6.84 | -0.59089 | -9.83 | -7.96 | -7.96 | -7.96 | -7.96 | -7.96 |
Tax Rate, % | 53.35 | 53.35 | 53.35 | 53.35 | 53.35 | 53.35 | 53.35 | 53.35 | 53.35 | 53.35 |
EBITAT | 186.9 | -5,042.7 | 7,183.3 | 13,866.2 | 4,832.9 | 5,688.4 | 6,837.5 | 8,218.7 | 9,878.9 | 11,874.5 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -5,244.1 | -1,781.0 | 7,054.1 | 21,087.1 | -247.9 | 8,774.1 | 8,114.6 | 9,753.8 | 11,724.2 | 14,092.6 |
WACC, % | 6.63 | 7.84 | 7.27 | 7.38 | 7.18 | 7.26 | 7.26 | 7.26 | 7.26 | 7.26 |
PV UFCF | ||||||||||
SUM PV UFCF | 41,921.7 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 14,374 | |||||||||
Terminal Value | 273,248 | |||||||||
Present Terminal Value | 192,467 | |||||||||
Enterprise Value | 234,389 | |||||||||
Net Debt | 30,179 | |||||||||
Equity Value | 204,210 | |||||||||
Diluted Shares Outstanding, MM | 3,327 | |||||||||
Equity Value Per Share | 61.38 |
What You Will Get
- Editable Forecast Inputs: Easily modify key assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Eni S.p.A.'s financial data pre-loaded to facilitate your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A refined Excel model that can be tailored to your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- 🔍 Real-Life Eni Financials: Pre-filled historical and projected data for Eni S.p.A. (E).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Eni’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Eni’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download: Get the pre-formatted Excel file containing Eni S.p.A.'s (E) financial data.
- Customize: Modify projections, such as revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various forecasts and evaluate results immediately.
- Make Decisions: Leverage the valuation outcomes to inform your investment strategy.
Why Choose This Calculator for Eni S.p.A. (E)?
- All-in-One Tool: Features DCF, WACC, and financial ratio analyses tailored for Eni S.p.A. (E).
- Adjustable Parameters: Modify yellow-highlighted cells to explore different financial scenarios.
- In-Depth Analysis: Automatically computes Eni S.p.A.'s intrinsic value and Net Present Value.
- Preloaded Information: Historical and projected data provide reliable starting points for analysis.
- High Professional Standards: Perfect for financial analysts, investors, and business consultants focusing on Eni S.p.A. (E).
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Eni S.p.A. (E) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for Eni S.p.A. (E).
- Consultants: Deliver professional valuation insights on Eni S.p.A. (E) to clients quickly and accurately.
- Business Owners: Understand how major companies like Eni S.p.A. (E) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Eni S.p.A. (E).
What the Template Contains
- Preloaded Eni S.p.A. Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.