|
Viant Technology Inc. (DSP) DCF Valuation
US | Technology | Software - Application | NASDAQ
|
- ✓ 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
Viant Technology Inc. (DSP) Bundle
Looking to assess the intrinsic value of Viant Technology Inc.? Our (DSP) DCF Calculator integrates real-world data with comprehensive 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 | 164.9 | 165.3 | 224.1 | 197.2 | 222.9 | 243.5 | 265.9 | 290.5 | 317.3 | 346.5 |
| Revenue Growth, % | 0 | 0.21772 | 35.63 | -12.03 | 13.07 | 9.22 | 9.22 | 9.22 | 9.22 | 9.22 |
| EBITDA | 24.0 | 31.9 | -31.7 | -36.1 | -3.6 | -.1 | -.1 | -.1 | -.1 | -.1 |
| EBITDA, % | 14.57 | 19.29 | -14.12 | -18.32 | -1.6 | -0.03747062 | -0.03747062 | -0.03747062 | -0.03747062 | -0.03747062 |
| Depreciation | 10.2 | 10.1 | 11.1 | 13.1 | 14.7 | 14.9 | 16.2 | 17.7 | 19.4 | 21.1 |
| Depreciation, % | 6.16 | 6.12 | 4.97 | 6.66 | 6.61 | 6.1 | 6.1 | 6.1 | 6.1 | 6.1 |
| EBIT | 13.9 | 21.8 | -42.8 | -49.3 | -18.3 | -15.0 | -16.3 | -17.8 | -19.5 | -21.3 |
| EBIT, % | 8.41 | 13.17 | -19.09 | -24.98 | -8.21 | -6.14 | -6.14 | -6.14 | -6.14 | -6.14 |
| Total Cash | 4.8 | 9.6 | 238.5 | 206.6 | 216.5 | 148.9 | 162.7 | 177.7 | 194.1 | 212.0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 68.1 | 89.8 | 110.7 | 101.7 | 117.5 | 121.4 | 132.6 | 144.8 | 158.2 | 172.8 |
| Account Receivables, % | 41.29 | 54.32 | 49.41 | 51.56 | 52.69 | 49.85 | 49.85 | 49.85 | 49.85 | 49.85 |
| Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Inventories, % | 0 | 0.000000605 | 0.000000446 | 0 | 0 | 0.00000021 | 0.00000021 | 0.00000021 | 0.00000021 | 0.00000021 |
| Accounts Payable | 20.5 | 29.8 | 32.9 | 37.1 | 47.3 | 41.5 | 45.3 | 49.5 | 54.0 | 59.0 |
| Accounts Payable, % | 12.42 | 18.01 | 14.67 | 18.8 | 21.24 | 17.03 | 17.03 | 17.03 | 17.03 | 17.03 |
| Capital Expenditure | -7.8 | -7.8 | -7.4 | -8.8 | -13.5 | -11.3 | -12.4 | -13.5 | -14.8 | -16.1 |
| Capital Expenditure, % | -4.74 | -4.74 | -3.29 | -4.48 | -6.04 | -4.66 | -4.66 | -4.66 | -4.66 | -4.66 |
| Tax Rate, % | 64.84 | 64.84 | 64.84 | 64.84 | 64.84 | 64.84 | 64.84 | 64.84 | 64.84 | 64.84 |
| EBITAT | 6.8 | 21.8 | -9.7 | -9.5 | -6.4 | -6.8 | -7.4 | -8.1 | -8.8 | -9.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -38.4 | 11.6 | -23.8 | 8.1 | -10.7 | -13.1 | -10.9 | -11.9 | -13.0 | -14.2 |
| WACC, % | 7.38 | 7.56 | 7.28 | 7.27 | 7.33 | 7.36 | 7.36 | 7.36 | 7.36 | 7.36 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -51.1 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -15 | |||||||||
| Terminal Value | -271 | |||||||||
| Present Terminal Value | -190 | |||||||||
| Enterprise Value | -241 | |||||||||
| Net Debt | -191 | |||||||||
| Equity Value | -50 | |||||||||
| Diluted Shares Outstanding, MM | 15 | |||||||||
| Equity Value Per Share | -3.27 |
What You Will Get
- Real DSP Financial Data: Pre-filled with Viant Technology 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 Viant Technology 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
- Comprehensive DCF Calculator: Features both unlevered and levered DCF valuation models tailored for Viant Technology Inc. (DSP).
- WACC Calculator: Ready-to-use Weighted Average Cost of Capital sheet with adjustable parameters.
- Customizable Forecast Assumptions: Easily change growth projections, capital expenditures, and discount rates.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for Viant Technology Inc. (DSP).
- Interactive Dashboard and Charts: Visual representations of key valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Viant Technology Inc. (DSP) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Viant Technology Inc. (DSP)’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Viant Technology Inc. (DSP)?
- Designed for Industry Experts: A sophisticated tool favored by analysts, CFOs, and industry consultants.
- Up-to-Date Financial Data: Viant’s historical and projected financials are preloaded for precision.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly Interface: Step-by-step guidance ensures a smooth experience throughout the process.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Viant Technology Inc. (DSP) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models specific to Viant Technology Inc. (DSP).
- Consultants: Deliver professional valuation insights on Viant Technology Inc. (DSP) to clients quickly and accurately.
- Business Owners: Understand how companies like Viant Technology Inc. (DSP) are valued to guide your own business strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Viant Technology Inc. (DSP).
What the Template Contains
- Preloaded DSP 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.