|
Valoración de DCF de Zillow Group, Inc. (Z)
US | Communication Services | Internet Content & Information | NASDAQ
|
- ✓ 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
Zillow Group, Inc. (Z) Bundle
¡Simplifique la valoración de Zillow Group, Inc. (Z) con esta calculadora DCF personalizable! Con el Real Zillow Group, Inc. (Z) Financials y las entradas de pronóstico ajustables, puede probar escenarios y descubrir el valor razonable de Zillow Group, Inc. (Z) en minutos.
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 | 2,742.8 | 3,339.8 | 8,147.4 | 1,958.0 | 1,945.0 | 2,164.5 | 2,408.7 | 2,680.5 | 2,982.9 | 3,319.5 |
| Revenue Growth, % | 0 | 21.77 | 143.95 | -75.97 | -0.66394 | 11.28 | 11.28 | 11.28 | 11.28 | 11.28 |
| EBITDA | -97.2 | 120.0 | 370.0 | 123.0 | 125.0 | 74.9 | 83.3 | 92.7 | 103.2 | 114.8 |
| EBITDA, % | -3.54 | 3.59 | 4.54 | 6.28 | 6.43 | 3.46 | 3.46 | 3.46 | 3.46 | 3.46 |
| Depreciation | 110.6 | 134.4 | 141.0 | 173.0 | 243.0 | 134.7 | 149.9 | 166.8 | 185.6 | 206.6 |
| Depreciation, % | 4.03 | 4.02 | 1.73 | 8.84 | 12.49 | 6.22 | 6.22 | 6.22 | 6.22 | 6.22 |
| EBIT | -207.8 | -14.4 | 229.0 | -50.0 | -118.0 | -59.8 | -66.6 | -74.1 | -82.4 | -91.7 |
| EBIT, % | -7.58 | -0.43149 | 2.81 | -2.55 | -6.07 | -2.76 | -2.76 | -2.76 | -2.76 | -2.76 |
| Total Cash | 2,422.3 | 3,921.2 | 3,125.4 | 3,362.0 | 2,813.0 | 1,847.0 | 2,055.4 | 2,287.4 | 2,545.5 | 2,832.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 67.0 | 69.9 | 77.0 | 72.0 | 96.0 | 61.0 | 67.9 | 75.6 | 84.1 | 93.6 |
| Account Receivables, % | 2.44 | 2.09 | 0.94509 | 3.68 | 4.94 | 2.82 | 2.82 | 2.82 | 2.82 | 2.82 |
| Inventories | 836.6 | 491.3 | 3,912.7 | 43.0 | .0 | 413.1 | 459.7 | 511.6 | 569.3 | 633.6 |
| Inventories, % | 30.5 | 14.71 | 48.02 | 2.2 | 0 | 19.09 | 19.09 | 19.09 | 19.09 | 19.09 |
| Accounts Payable | 8.3 | 19.0 | 11.0 | 20.0 | 28.0 | 15.0 | 16.7 | 18.6 | 20.7 | 23.0 |
| Accounts Payable, % | 0.30417 | 0.56811 | 0.13501 | 1.02 | 1.44 | 0.69367 | 0.69367 | 0.69367 | 0.69367 | 0.69367 |
| Capital Expenditure | -86.6 | -108.5 | -104.4 | -140.0 | -165.0 | -101.0 | -112.4 | -125.0 | -139.1 | -154.8 |
| Capital Expenditure, % | -3.16 | -3.25 | -1.28 | -7.15 | -8.48 | -4.66 | -4.66 | -4.66 | -4.66 | -4.66 |
| Tax Rate, % | -2.6 | -2.6 | -2.6 | -2.6 | -2.6 | -2.6 | -2.6 | -2.6 | -2.6 | -2.6 |
| EBITAT | -205.0 | -13.8 | 229.5 | -51.8 | -121.1 | -59.1 | -65.8 | -73.2 | -81.5 | -90.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -1,076.3 | 365.1 | -3,170.3 | 3,864.9 | -16.1 | -416.5 | -80.1 | -89.1 | -99.1 | -110.3 |
| WACC, % | 13.08 | 13.06 | 13.08 | 13.08 | 13.08 | 13.08 | 13.08 | 13.08 | 13.08 | 13.08 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -612.9 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -113 | |||||||||
| Terminal Value | -1,016 | |||||||||
| Present Terminal Value | -550 | |||||||||
| Enterprise Value | -1,162 | |||||||||
| Net Debt | 340 | |||||||||
| Equity Value | -1,502 | |||||||||
| Diluted Shares Outstanding, MM | 234 | |||||||||
| Equity Value Per Share | -6.43 |
What You Will Receive
- Pre-Filled Financial Model: Zillow Group's actual data facilitates accurate DCF valuation.
- Comprehensive Forecast Control: Modify revenue growth, profit margins, WACC, and other essential drivers.
- Real-Time Calculations: Automatic updates ensure you view results instantly as adjustments are made.
- Investor-Ready Template: A polished Excel file crafted for high-quality valuation presentations.
- Customizable and Reusable: Designed for adaptability, allowing for repeated use in detailed forecasting.
Key Features
- Comprehensive Data: Zillow Group, Inc.'s historical performance metrics and pre-filled projections.
- Customizable Parameters: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Insights: Watch Zillow's intrinsic value update instantly with changes.
- Intuitive Visualizations: Dashboard graphs illustrate valuation outcomes and essential indicators.
- Designed for Precision: A robust resource for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the prebuilt Excel template featuring Zillow Group, Inc.'s (Z) data.
- Step 2: Review 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 Zillow Group, Inc.'s (Z) intrinsic value.
- Step 5: Use the outputs to make informed investment choices or create detailed reports.
Why Choose This Calculator?
- Designed for Real Estate Professionals: A sophisticated tool utilized by analysts, investors, and real estate consultants.
- Comprehensive Market Data: Zillow’s historical and projected property data preloaded for precision.
- Scenario Analysis: Effortlessly simulate various market conditions and investment strategies.
- Clear Insights: Automatically calculates property values, ROI, and critical metrics.
- User-Friendly: Step-by-step guidance makes navigation simple and intuitive.
Who Should Use This Product?
- Investors: Accurately assess Zillow Group, Inc.'s (Z) fair value before making investment decisions.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis related to Zillow Group, Inc. (Z).
- Consultants: Quickly customize the template for valuation reports tailored to Zillow Group, Inc. (Z) clients.
- Entrepreneurs: Gain insights into financial modeling practices employed by leading real estate companies like Zillow Group, Inc. (Z).
- Educators: Use it as a teaching resource to illustrate valuation methodologies relevant to Zillow Group, Inc. (Z).
What the Template Contains
- Preloaded Z 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.