VEON Ltd. (VEON) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
VEON Ltd. (VEON) Bundle
Whether you’re an investor or analyst, this (VEON) DCF Calculator is your go-to resource for accurate valuation. Equipped with real data from VEON Ltd., you can adjust forecasts and observe the effects in real-time.
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 | 8,863.0 | 7,980.0 | 7,788.0 | 3,755.0 | 3,698.0 | 3,090.9 | 2,583.4 | 2,159.3 | 1,804.8 | 1,508.5 |
Revenue Growth, % | 0 | -9.96 | -2.41 | -51.78 | -1.52 | -16.42 | -16.42 | -16.42 | -16.42 | -16.42 |
EBITDA | 4,119.0 | 2,333.0 | 1,854.0 | 2,163.0 | 1,825.0 | 1,276.3 | 1,066.8 | 891.6 | 745.3 | 622.9 |
EBITDA, % | 46.47 | 29.24 | 23.81 | 57.6 | 49.35 | 41.29 | 41.29 | 41.29 | 41.29 | 41.29 |
Depreciation | 2,046.0 | 1,742.0 | 799.0 | 778.0 | 735.0 | 592.0 | 494.8 | 413.6 | 345.7 | 288.9 |
Depreciation, % | 23.08 | 21.83 | 10.26 | 20.72 | 19.88 | 19.15 | 19.15 | 19.15 | 19.15 | 19.15 |
EBIT | 2,073.0 | 591.0 | 1,055.0 | 1,385.0 | 1,090.0 | 684.3 | 572.0 | 478.1 | 399.6 | 334.0 |
EBIT, % | 23.39 | 7.41 | 13.55 | 36.88 | 29.48 | 22.14 | 22.14 | 22.14 | 22.14 | 22.14 |
Total Cash | 1,332.0 | 1,759.0 | 2,338.0 | 4,010.0 | 2,335.0 | 1,423.2 | 1,189.6 | 994.3 | 831.0 | 694.6 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 644.0 | 544.0 | 920.0 | 577.0 | 645.0 | 362.9 | 303.3 | 253.5 | 211.9 | 177.1 |
Account Receivables, % | 7.27 | 6.82 | 11.81 | 15.37 | 17.44 | 11.74 | 11.74 | 11.74 | 11.74 | 11.74 |
Inventories | 169.0 | 111.0 | 111.0 | 18.0 | 23.0 | 36.0 | 30.1 | 25.2 | 21.0 | 17.6 |
Inventories, % | 1.91 | 1.39 | 1.43 | 0.47936 | 0.62196 | 1.16 | 1.16 | 1.16 | 1.16 | 1.16 |
Accounts Payable | 1,847.0 | 1,946.0 | 2,031.0 | 1,087.0 | 1,200.0 | 820.3 | 685.6 | 573.1 | 479.0 | 400.4 |
Accounts Payable, % | 20.84 | 24.39 | 26.08 | 28.95 | 32.45 | 26.54 | 26.54 | 26.54 | 26.54 | 26.54 |
Capital Expenditure | -1,683.0 | -1,778.0 | -1,796.0 | -1,010.0 | -531.0 | -652.7 | -545.6 | -456.0 | -381.1 | -318.5 |
Capital Expenditure, % | -18.99 | -22.28 | -23.06 | -26.9 | -14.36 | -21.12 | -21.12 | -21.12 | -21.12 | -21.12 |
Tax Rate, % | 552.24 | 552.24 | 552.24 | 552.24 | 552.24 | 552.24 | 552.24 | 552.24 | 552.24 | 552.24 |
EBITAT | 1,090.0 | -7,182.9 | 783.1 | 1,510.0 | -4,929.4 | 310.4 | 259.5 | 216.9 | 181.3 | 151.5 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 2,487.0 | -6,961.9 | -504.9 | 770.0 | -4,685.4 | 139.2 | 139.5 | 116.6 | 97.5 | 81.5 |
WACC, % | 8.1 | 4.4 | 9.63 | 11.44 | 4.4 | 7.6 | 7.6 | 7.6 | 7.6 | 7.6 |
PV UFCF | ||||||||||
SUM PV UFCF | 472.7 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 83 | |||||||||
Terminal Value | 1,485 | |||||||||
Present Terminal Value | 1,030 | |||||||||
Enterprise Value | 1,503 | |||||||||
Net Debt | 3,024 | |||||||||
Equity Value | -1,521 | |||||||||
Diluted Shares Outstanding, MM | 71 | |||||||||
Equity Value Per Share | -21.34 |
What You Will Get
- Real VEON Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on VEON’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections.
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility.
Key Features
- Comprehensive VEON Financials: Gain access to precise pre-loaded historical data and future forecasts.
- Adjustable Forecast Parameters: Modify the highlighted cells such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Intuitive charts and summaries to help you visualize your valuation outcomes.
- Designed for All Experience Levels: A straightforward, user-friendly layout tailored for investors, CFOs, and consultants.
How It Works
- Step 1: Download the prebuilt Excel template with VEON Ltd.’s (VEON) data included.
- Step 2: Explore the pre-filled sheets and familiarize yourself with the key metrics.
- Step 3: Update forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view recalculated results, including VEON Ltd.’s (VEON) intrinsic value.
- Step 5: Make informed investment decisions or generate reports using the outputs.
Why Choose VEON Ltd. (VEON)?
- Save Time: Quickly access comprehensive analytics without the hassle of building from the ground up.
- Enhance Accuracy: Utilize dependable data and methodologies to minimize valuation errors.
- Fully Customizable: Adjust the tools to align with your specific assumptions and forecasts.
- Easy to Understand: Intuitive visuals and outputs simplify the analysis of results.
- Endorsed by Professionals: Created for industry experts who prioritize both accuracy and functionality.
Who Should Use This Product?
- Investors: Accurately assess VEON’s fair value before making investment choices.
- CFOs: Utilize a professional-grade DCF model for VEON’s financial reporting and analysis.
- Consultants: Efficiently customize the template for valuation reports tailored to VEON clients.
- Entrepreneurs: Acquire insights into financial modeling practices employed by leading telecom companies.
- Educators: Implement it as a teaching resource to illustrate valuation techniques.
What the Template Contains
- Preloaded VEON 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.