DLocal Limited (DLO) DCF Valuation
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
DLocal Limited (DLO) Bundle
Looking to assess the intrinsic value of DLocal Limited? Our DLO (DLO) DCF Calculator integrates real-world data with extensive customization features, allowing you to refine your forecasts and enhance your investment choices.
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 | 55.3 | 104.1 | 244.1 | 418.9 | 650.4 | 1,162.8 | 2,079.2 | 3,717.7 | 6,647.3 | 11,885.5 |
Revenue Growth, % | 0 | 88.36 | 134.41 | 71.61 | 55.24 | 78.8 | 78.8 | 78.8 | 78.8 | 78.8 |
EBITDA | 18.3 | 32.5 | 90.8 | 153.1 | 184.2 | 386.7 | 691.4 | 1,236.3 | 2,210.6 | 3,952.5 |
EBITDA, % | 33.03 | 31.19 | 37.19 | 36.55 | 28.32 | 33.26 | 33.26 | 33.26 | 33.26 | 33.26 |
Depreciation | .4 | 1.0 | 4.7 | 8.1 | 12.2 | 17.4 | 31.0 | 55.5 | 99.2 | 177.4 |
Depreciation, % | 0.73975 | 0.95254 | 1.94 | 1.94 | 1.88 | 1.49 | 1.49 | 1.49 | 1.49 | 1.49 |
EBIT | 17.9 | 31.5 | 86.0 | 145.0 | 172.0 | 369.4 | 660.4 | 1,180.8 | 2,111.4 | 3,775.2 |
EBIT, % | 32.29 | 30.23 | 35.25 | 34.6 | 26.44 | 31.76 | 31.76 | 31.76 | 31.76 | 31.76 |
Total Cash | 22.3 | 52.0 | 337.2 | 469.4 | 638.8 | 903.4 | 1,615.4 | 2,888.3 | 5,164.4 | 9,234.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 24.4 | 67.2 | 178.9 | .0 | 319.5 | 537.6 | 961.2 | 1,718.6 | 3,072.9 | 5,494.5 |
Account Receivables, % | 44.21 | 64.54 | 73.27 | 0 | 49.12 | 46.23 | 46.23 | 46.23 | 46.23 | 46.23 |
Inventories | 30.4 | 75.2 | -1.0 | 1.2 | .0 | 295.6 | 528.6 | 945.1 | 1,689.8 | 3,021.4 |
Inventories, % | 54.98 | 72.25 | -0.41127 | 0.28788 | 0 | 25.42 | 25.42 | 25.42 | 25.42 | 25.42 |
Accounts Payable | 50.8 | 136.7 | 269.2 | 395.1 | 572.4 | 1,103.0 | 1,972.2 | 3,526.4 | 6,305.2 | 11,273.9 |
Accounts Payable, % | 91.94 | 131.29 | 110.28 | 94.32 | 88.01 | 94.85 | 94.85 | 94.85 | 94.85 | 94.85 |
Capital Expenditure | -1.7 | -3.9 | -48.0 | -12.4 | -18.2 | -75.0 | -134.0 | -239.7 | -428.5 | -766.2 |
Capital Expenditure, % | -3.09 | -3.73 | -19.67 | -2.95 | -2.8 | -6.45 | -6.45 | -6.45 | -6.45 | -6.45 |
Tax Rate, % | 16.55 | 16.55 | 16.55 | 16.55 | 16.55 | 16.55 | 16.55 | 16.55 | 16.55 | 16.55 |
EBITAT | 15.6 | 28.2 | 78.4 | 131.0 | 143.5 | 326.6 | 584.0 | 1,044.2 | 1,867.0 | 3,338.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 10.3 | 23.6 | 132.2 | 429.3 | -3.5 | 285.9 | 693.6 | 1,240.2 | 2,217.5 | 3,964.9 |
WACC, % | 10.14 | 10.19 | 10.23 | 10.21 | 10.04 | 10.16 | 10.16 | 10.16 | 10.16 | 10.16 |
PV UFCF | ||||||||||
SUM PV UFCF | 5,708.2 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 4,044 | |||||||||
Terminal Value | 49,549 | |||||||||
Present Terminal Value | 30,541 | |||||||||
Enterprise Value | 36,249 | |||||||||
Net Debt | -219 | |||||||||
Equity Value | 36,468 | |||||||||
Diluted Shares Outstanding, MM | 303 | |||||||||
Equity Value Per Share | 120.37 |
What You Will Get
- Real DLO Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed automatically.
- Scenario Analysis: Explore various scenarios to assess DLocal's future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- 🔍 Real-Life DLocal Financials: Pre-filled historical and projected data for DLocal Limited (DLO).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate DLocal’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize DLocal’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the prebuilt Excel template featuring DLocal Limited's (DLO) data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see the recalculated results, including DLocal Limited's (DLO) intrinsic value.
- Step 5: Utilize the outputs to make informed investment decisions or create detailed reports.
Why Choose This Calculator for DLocal Limited (DLO)?
- All-in-One Solution: Features DCF, WACC, and financial ratio analyses tailored for DLocal Limited.
- Flexible Inputs: Modify the highlighted cells to explore different financial scenarios.
- In-Depth Analysis: Automatically computes DLocal Limited’s intrinsic value and Net Present Value.
- Preloaded Information: Historical and projected data provide reliable starting points for analysis.
- High-Caliber Tool: Perfect for financial analysts, investors, and business consultants focusing on DLocal Limited.
Who Should Use This Product?
- Finance Students: Explore payment processing strategies and apply them to real-world scenarios using DLocal Limited (DLO) data.
- Academics: Utilize advanced models in your studies or research focused on cross-border payments.
- Investors: Evaluate your investment hypotheses and assess the performance metrics for DLocal Limited (DLO).
- Analysts: Enhance your analysis with a ready-to-use, adaptable financial model tailored for DLocal Limited (DLO).
- Small Business Owners: Understand how global payment solutions are structured and analyzed through the lens of DLocal Limited (DLO).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled DLocal Limited (DLO) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), featuring parameters such as Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models demonstrating intrinsic value with comprehensive calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to facilitate analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for DLocal Limited (DLO).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to simplify result analysis.