Domo, Inc. (DOMO) 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
Domo, Inc. (DOMO) Bundle
Explore Domo, Inc.'s (DOMO) financial prospects with our user-friendly DCF Calculator! Enter your assumptions regarding growth, margins, and expenses to calculate Domo, Inc.'s (DOMO) intrinsic value and enhance your investment approach.
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue | 173.4 | 210.2 | 258.0 | 308.6 | 319.0 | 372.4 | 434.7 | 507.5 | 592.4 | 691.5 |
Revenue Growth, % | 0 | 21.21 | 22.73 | 19.65 | 3.35 | 16.74 | 16.74 | 16.74 | 16.74 | 16.74 |
EBITDA | -108.4 | -73.1 | -79.0 | -88.9 | -48.3 | -127.9 | -149.4 | -174.4 | -203.5 | -237.6 |
EBITDA, % | -62.49 | -34.77 | -30.61 | -28.79 | -15.13 | -34.36 | -34.36 | -34.36 | -34.36 | -34.36 |
Depreciation | 18.7 | 8.7 | 10.2 | 10.0 | 6.6 | 18.0 | 21.1 | 24.6 | 28.7 | 33.5 |
Depreciation, % | 10.78 | 4.16 | 3.95 | 3.25 | 2.08 | 4.84 | 4.84 | 4.84 | 4.84 | 4.84 |
EBIT | -127.0 | -81.8 | -89.2 | -98.9 | -54.9 | -146.0 | -170.4 | -198.9 | -232.2 | -271.1 |
EBIT, % | -73.27 | -38.93 | -34.57 | -32.04 | -17.2 | -39.2 | -39.2 | -39.2 | -39.2 | -39.2 |
Total Cash | 98.8 | 90.8 | 83.6 | 66.5 | 60.9 | 129.0 | 150.6 | 175.8 | 205.2 | 239.6 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 48.0 | 48.3 | 64.1 | 79.0 | 67.2 | 91.0 | 106.2 | 124.0 | 144.7 | 168.9 |
Account Receivables, % | 27.66 | 22.97 | 24.87 | 25.58 | 21.07 | 24.43 | 24.43 | 24.43 | 24.43 | 24.43 |
Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Inventories, % | 0 | 0.000000476 | 0.000000388 | 0.000000324 | 0 | 0.000000237 | 0.000000237 | 0.000000237 | 0.000000237 | 0.000000237 |
Accounts Payable | 2.3 | 1.1 | 4.8 | 12.1 | 4.3 | 6.7 | 7.8 | 9.1 | 10.6 | 12.4 |
Accounts Payable, % | 1.33 | 0.51622 | 1.85 | 3.93 | 1.35 | 1.79 | 1.79 | 1.79 | 1.79 | 1.79 |
Capital Expenditure | -6.5 | -5.8 | -6.5 | -8.0 | -11.8 | -11.4 | -13.3 | -15.6 | -18.2 | -21.2 |
Capital Expenditure, % | -3.77 | -2.76 | -2.53 | -2.59 | -3.69 | -3.07 | -3.07 | -3.07 | -3.07 | -3.07 |
Tax Rate, % | -1.69 | -1.69 | -1.69 | -1.69 | -1.69 | -1.69 | -1.69 | -1.69 | -1.69 | -1.69 |
EBITAT | -127.8 | -82.2 | -88.8 | -100.0 | -55.8 | -145.8 | -170.3 | -198.8 | -232.0 | -270.9 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -161.3 | -80.8 | -97.3 | -105.4 | -57.0 | -160.6 | -176.6 | -206.2 | -240.7 | -281.0 |
WACC, % | 12.2 | 12.2 | 12.2 | 12.2 | 12.2 | 12.2 | 12.2 | 12.2 | 12.2 | 12.2 |
PV UFCF | ||||||||||
SUM PV UFCF | -739.4 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -287 | |||||||||
Terminal Value | -2,810 | |||||||||
Present Terminal Value | -1,580 | |||||||||
Enterprise Value | -2,319 | |||||||||
Net Debt | 69 | |||||||||
Equity Value | -2,388 | |||||||||
Diluted Shares Outstanding, MM | 36 | |||||||||
Equity Value Per Share | -66.24 |
What You Will Get
- Real DOMO Financial Data: Pre-filled with Domo, Inc.'s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Domo, Inc.'s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- 🔍 Real-Life DOMO Financials: Pre-filled historical and projected data for Domo, Inc. (DOMO).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Domo’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Domo’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- 1. Access the Template: Download and open the Excel file featuring Domo, Inc.'s (DOMO) preloaded data.
- 2. Adjust Assumptions: Modify key inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results Immediately: The DCF model automatically calculates intrinsic value and NPV in real-time.
- 4. Explore Scenarios: Evaluate various forecasts to investigate different valuation results.
- 5. Present with Assurance: Share professional valuation insights to back your strategic decisions.
Why Choose This Calculator for Domo, Inc. (DOMO)?
- Accurate Data: Utilize real Domo financials to ensure dependable valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Pre-configured calculations save you from starting from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the tech sector.
- User-Friendly: An intuitive design and clear instructions make it accessible for all users.
Who Should Use This Product?
- Investors: Accurately assess Domo, Inc.'s (DOMO) fair value before making investment choices.
- CFOs: Utilize a professional-grade DCF model for comprehensive financial reporting and analysis.
- Consultants: Easily customize the template for client valuation reports.
- Entrepreneurs: Acquire insights into financial modeling practices employed by leading tech companies.
- Educators: Employ it as a teaching resource to illustrate various valuation methodologies.
What the Template Contains
- Pre-Filled Data: Contains Domo, Inc.'s historical financials and future projections.
- Discounted Cash Flow Model: An editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on user-defined inputs.
- Key Financial Ratios: Evaluate Domo, Inc.'s profitability, efficiency, and leverage.
- Customizable Inputs: Easily modify revenue growth, margins, and tax rates.
- Clear Dashboard: Visuals and tables summarizing essential valuation outcomes.