Zeta Global Holdings Corp. (ZETA) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Zeta Global Holdings Corp. (ZETA) Bundle
Streamline your analysis and improve precision with our (ZETA) DCF Calculator! Equipped with up-to-date Zeta Global Holdings Corp. data and customizable assumptions, this tool enables you to forecast, evaluate, and assess (ZETA) like a seasoned investor.
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 | 306.1 | 368.1 | 458.3 | 591.0 | 728.7 | 905.5 | 1,125.2 | 1,398.1 | 1,737.3 | 2,158.7 |
| Revenue Growth, % | 0 | 20.28 | 24.51 | 28.94 | 23.31 | 24.26 | 24.26 | 24.26 | 24.26 | 24.26 |
| EBITDA | 12.4 | 4.0 | -197.2 | -221.5 | -124.4 | -167.4 | -208.0 | -258.5 | -321.2 | -399.1 |
| EBITDA, % | 4.04 | 1.09 | -43.03 | -37.49 | -17.06 | -18.49 | -18.49 | -18.49 | -18.49 | -18.49 |
| Depreciation | 34.3 | 40.1 | 45.9 | 51.9 | 51.1 | 86.8 | 107.8 | 134.0 | 166.5 | 206.9 |
| Depreciation, % | 11.22 | 10.88 | 10.02 | 8.78 | 7.02 | 9.58 | 9.58 | 9.58 | 9.58 | 9.58 |
| EBIT | -22.0 | -36.0 | -243.1 | -273.4 | -175.5 | -254.2 | -315.9 | -392.5 | -487.7 | -606.0 |
| EBIT, % | -7.18 | -9.79 | -53.05 | -46.27 | -24.08 | -28.07 | -28.07 | -28.07 | -28.07 | -28.07 |
| Total Cash | 37.5 | 50.7 | 103.9 | 121.1 | 131.7 | 158.0 | 196.4 | 244.0 | 303.2 | 376.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 102.4 | 79.4 | 83.6 | 106.3 | 170.1 | 207.5 | 257.9 | 320.4 | 398.2 | 494.7 |
| Account Receivables, % | 33.46 | 21.56 | 18.24 | 17.99 | 23.35 | 22.92 | 22.92 | 22.92 | 22.92 | 22.92 |
| Inventories | 3.4 | 3.9 | 7.0 | 7.2 | .0 | 8.8 | 11.0 | 13.7 | 17.0 | 21.1 |
| Inventories, % | 1.1 | 1.06 | 1.52 | 1.21 | 0 | 0.97729 | 0.97729 | 0.97729 | 0.97729 | 0.97729 |
| Accounts Payable | 36.5 | 41.0 | 21.7 | 33.7 | 63.6 | 76.5 | 95.0 | 118.1 | 146.7 | 182.3 |
| Accounts Payable, % | 11.94 | 11.13 | 4.74 | 5.7 | 8.72 | 8.45 | 8.45 | 8.45 | 8.45 | 8.45 |
| Capital Expenditure | -22.7 | -25.2 | -26.8 | -39.2 | -36.0 | -57.4 | -71.3 | -88.6 | -110.0 | -136.7 |
| Capital Expenditure, % | -7.41 | -6.85 | -5.84 | -6.64 | -4.94 | -6.33 | -6.33 | -6.33 | -6.33 | -6.33 |
| Tax Rate, % | -0.5562 | -0.5562 | -0.5562 | -0.5562 | -0.5562 | -0.5562 | -0.5562 | -0.5562 | -0.5562 | -0.5562 |
| EBITAT | -22.6 | -36.7 | -242.5 | -272.0 | -176.5 | -253.8 | -315.4 | -391.9 | -487.0 | -605.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -80.1 | 5.1 | -249.9 | -270.3 | -188.1 | -257.7 | -312.8 | -388.6 | -482.9 | -600.0 |
| WACC, % | 10.27 | 10.27 | 10.27 | 10.27 | 10.27 | 10.27 | 10.27 | 10.27 | 10.27 | 10.27 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -1,475.5 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -612 | |||||||||
| Terminal Value | -7,402 | |||||||||
| Present Terminal Value | -4,540 | |||||||||
| Enterprise Value | -6,015 | |||||||||
| Net Debt | 52 | |||||||||
| Equity Value | -6,068 | |||||||||
| Diluted Shares Outstanding, MM | 157 | |||||||||
| Equity Value Per Share | -38.72 |
What You Will Get
- Real Zeta Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Zeta Global Holdings Corp. (ZETA).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specific to Zeta Global Holdings Corp. (ZETA).
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Zeta Global Holdings Corp. (ZETA)’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections for Zeta Global Holdings Corp. (ZETA).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for Zeta Global Holdings Corp. (ZETA).
Key Features
- Comprehensive Historical Data: Zeta Global's financial statements and pre-filled projections.
- Customizable Parameters: Adjust WACC, tax rates, revenue growth, and EBITDA margins to fit your analysis.
- Real-Time Valuation: Observe Zeta Global's intrinsic value update instantly.
- Intuitive Visualizations: Dashboard graphs illustrate valuation outcomes and essential metrics.
- Designed for Precision: A reliable tool tailored for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review Zeta Global Holdings Corp.'s pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Watch the DCF model update in real-time as you adjust your assumptions.
- Step 5: Analyze the outputs and leverage the results for your investment decisions.
Why Choose This Calculator for Zeta Global Holdings Corp. (ZETA)?
- User-Friendly Interface: Tailored for both novice and seasoned users.
- Customizable Inputs: Adjust parameters easily to suit your analysis needs.
- Real-Time Feedback: Observe immediate changes in Zeta's valuation as you tweak inputs.
- Preloaded Financial Data: Comes equipped with Zeta’s actual financial metrics for swift evaluations.
- Relied Upon by Experts: Favored by investors and analysts for making well-informed choices.
Who Should Use This Product?
- Finance Students: Understand advanced marketing analytics and apply them using real-world data.
- Academics: Integrate cutting-edge marketing models into your research or teaching materials.
- Investors: Evaluate your investment strategies and analyze the market performance of Zeta Global Holdings Corp. (ZETA).
- Analysts: Enhance your analysis process with a customizable framework tailored for marketing insights.
- Marketing Professionals: Discover how major companies like Zeta Global are leveraging data for strategic decisions.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Zeta Global Holdings Corp. (ZETA) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Zeta Global Holdings Corp. (ZETA).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.