VTEX (VTEX) 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
VTEX (VTEX) Bundle
Gain mastery over your VTEX (VTEX) valuation analysis with our state-of-the-art DCF Calculator! Featuring up-to-date VTEX (VTEX) data, this Excel template enables you to adjust forecasts and assumptions for an accurate calculation of VTEX (VTEX) intrinsic value.
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 | 61.3 | 98.7 | 125.8 | 157.6 | 201.5 | 272.8 | 369.4 | 500.0 | 677.0 | 916.5 |
Revenue Growth, % | 0 | 60.9 | 27.46 | 25.32 | 27.85 | 35.38 | 35.38 | 35.38 | 35.38 | 35.38 |
EBITDA | 1.3 | 7.1 | -64.4 | -50.4 | -4.0 | -41.4 | -56.1 | -75.9 | -102.7 | -139.1 |
EBITDA, % | 2.17 | 7.16 | -51.22 | -31.98 | -2 | -15.18 | -15.18 | -15.18 | -15.18 | -15.18 |
Depreciation | 2.5 | 2.4 | 4.1 | 4.6 | 5.0 | 8.3 | 11.2 | 15.2 | 20.6 | 27.9 |
Depreciation, % | 4.12 | 2.43 | 3.24 | 2.93 | 2.49 | 3.04 | 3.04 | 3.04 | 3.04 | 3.04 |
EBIT | -1.2 | 4.7 | -68.5 | -55.0 | -9.0 | -49.7 | -67.3 | -91.1 | -123.3 | -167.0 |
EBIT, % | -1.95 | 4.72 | -54.46 | -34.91 | -4.49 | -18.22 | -18.22 | -18.22 | -18.22 | -18.22 |
Total Cash | 44.3 | 75.5 | 298.2 | 238.6 | 209.4 | 244.8 | 331.5 | 448.7 | 607.5 | 822.5 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 14.9 | 24.5 | 34.7 | 42.0 | 50.6 | 70.1 | 94.9 | 128.5 | 173.9 | 235.5 |
Account Receivables, % | 24.33 | 24.82 | 27.58 | 26.62 | 25.12 | 25.69 | 25.69 | 25.69 | 25.69 | 25.69 |
Inventories | 4.3 | 4.4 | 9.4 | 6.5 | .0 | 12.6 | 17.0 | 23.1 | 31.2 | 42.3 |
Inventories, % | 7.01 | 4.48 | 7.44 | 4.15 | 0 | 4.61 | 4.61 | 4.61 | 4.61 | 4.61 |
Accounts Payable | 4.1 | 10.0 | 29.5 | 34.1 | 39.7 | 44.6 | 60.3 | 81.7 | 110.6 | 149.7 |
Accounts Payable, % | 6.72 | 10.11 | 23.48 | 21.66 | 19.71 | 16.34 | 16.34 | 16.34 | 16.34 | 16.34 |
Capital Expenditure | -1.8 | -1.6 | -1.8 | -.3 | -.5 | -3.5 | -4.8 | -6.5 | -8.8 | -11.9 |
Capital Expenditure, % | -2.98 | -1.67 | -1.39 | -0.21571 | -0.23422 | -1.3 | -1.3 | -1.3 | -1.3 | -1.3 |
Tax Rate, % | -29.28 | -29.28 | -29.28 | -29.28 | -29.28 | -29.28 | -29.28 | -29.28 | -29.28 | -29.28 |
EBITAT | -1.5 | -1.1 | -59.2 | -51.1 | -11.7 | -37.7 | -51.0 | -69.1 | -93.6 | -126.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -15.9 | -4.2 | -52.5 | -46.7 | -3.7 | -60.2 | -58.1 | -78.7 | -106.5 | -144.2 |
WACC, % | 11.17 | 11.03 | 11.15 | 11.16 | 11.17 | 11.14 | 11.14 | 11.14 | 11.14 | 11.14 |
PV UFCF | ||||||||||
SUM PV UFCF | -313.3 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -147 | |||||||||
Terminal Value | -1,609 | |||||||||
Present Terminal Value | -949 | |||||||||
Enterprise Value | -1,262 | |||||||||
Net Debt | -24 | |||||||||
Equity Value | -1,238 | |||||||||
Diluted Shares Outstanding, MM | 186 | |||||||||
Equity Value Per Share | -6.64 |
What You Will Receive
- Real VTEX Financial Data: Pre-filled with VTEX’s historical and projected data for accurate analysis.
- Fully Customizable Template: Easily adjust key inputs such as revenue growth, WACC, and EBITDA %.
- Instant Calculations: Watch VTEX’s intrinsic value update in real-time as you make changes.
- Professional Valuation Tool: Tailored for investors, analysts, and consultants aiming for precise DCF outcomes.
- User-Friendly Interface: Intuitive layout and clear guidance suitable for all skill levels.
Key Features
- Comprehensive VTEX Data: Pre-loaded with VTEX’s historical performance metrics and future growth estimates.
- Customizable Assumptions: Modify key factors such as revenue growth rates, profit margins, discount rates, tax implications, and capital investments.
- Interactive Valuation Framework: Instant recalculations of Net Present Value (NPV) and intrinsic value based on your customized inputs.
- Scenario Analysis: Develop various forecasting scenarios to explore different valuation possibilities.
- Intuitive Interface: Designed to be straightforward and accessible for both seasoned professionals and newcomers.
How It Works
- 1. Access the Template: Download and open the Excel file containing VTEX’s preloaded data.
- 2. Modify Assumptions: Adjust crucial inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results Instantly: The DCF model automatically calculates intrinsic value and NPV.
- 4. Explore Scenarios: Evaluate various forecasts to assess different valuation outcomes.
- 5. Present with Confidence: Share professional valuation insights to back your decisions.
Why Choose This Calculator for VTEX (VTEX)?
- Designed for Experts: A sophisticated tool utilized by analysts, CFOs, and consultants in the industry.
- Accurate Data: VTEX’s historical and projected financials preloaded for precision.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Transparent Results: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly: Step-by-step guidance makes the process straightforward.
Who Should Use VTEX (VTEX)?
- E-commerce Entrepreneurs: Leverage a robust platform to enhance your online store's performance.
- Digital Marketers: Utilize advanced tools to optimize marketing strategies and drive sales.
- Retailers: Seamlessly integrate online and offline channels for a unified shopping experience.
- Developers: Take advantage of customizable features to build tailored solutions for clients.
- Business Analysts: Analyze data insights to make informed decisions and improve operational efficiency.
What the Template Contains
- Historical Data: Includes VTEX's past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate VTEX's intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of VTEX's financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.