Wix.com Ltd. (WIX) 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
Wix.com Ltd. (WIX) Bundle
Whether you’re an investor or analyst, this Wix.com Ltd. (WIX) DCF Calculator is your go-to tool for accurate valuation. Preloaded with Wix.com Ltd. real data, you can adjust forecasts and observe the effects in real-time.
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 | 761.1 | 988.8 | 1,269.7 | 1,387.7 | 1,561.7 | 1,874.6 | 2,250.3 | 2,701.2 | 3,242.5 | 3,892.3 |
Revenue Growth, % | 0 | 29.91 | 28.41 | 9.29 | 12.54 | 20.04 | 20.04 | 20.04 | 20.04 | 20.04 |
EBITDA | -45.6 | -104.2 | -28.1 | -439.0 | 69.1 | -172.3 | -206.8 | -248.3 | -298.0 | -357.8 |
EBITDA, % | -6 | -10.54 | -2.21 | -31.64 | 4.43 | -9.19 | -9.19 | -9.19 | -9.19 | -9.19 |
Depreciation | 16.7 | 17.2 | 18.9 | 22.9 | 26.4 | 32.9 | 39.4 | 47.3 | 56.8 | 68.2 |
Depreciation, % | 2.2 | 1.74 | 1.49 | 1.65 | 1.69 | 1.75 | 1.75 | 1.75 | 1.75 | 1.75 |
EBIT | -62.3 | -121.4 | -46.9 | -461.9 | 42.7 | -205.2 | -246.3 | -295.6 | -354.9 | -426.0 |
EBIT, % | -8.19 | -12.28 | -3.7 | -33.29 | 2.73 | -10.94 | -10.94 | -10.94 | -10.94 | -10.94 |
Total Cash | 726.5 | 1,035.9 | 1,319.6 | 1,063.5 | 962.9 | 1,626.2 | 1,952.1 | 2,343.3 | 2,812.9 | 3,376.5 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 17.0 | 23.7 | 30.4 | 42.1 | 57.4 | 51.5 | 61.8 | 74.2 | 89.0 | 106.8 |
Account Receivables, % | 2.23 | 2.39 | 2.39 | 3.03 | 3.68 | 2.75 | 2.75 | 2.75 | 2.75 | 2.75 |
Inventories | 12.7 | 22.0 | 27.2 | 13.7 | .0 | 26.3 | 31.6 | 38.0 | 45.6 | 54.7 |
Inventories, % | 1.67 | 2.22 | 2.15 | 0.98504 | 0 | 1.41 | 1.41 | 1.41 | 1.41 | 1.41 |
Accounts Payable | 37.7 | 79.9 | 114.6 | 96.1 | 38.3 | 117.8 | 141.5 | 169.8 | 203.8 | 244.7 |
Accounts Payable, % | 4.95 | 8.08 | 9.02 | 6.92 | 2.45 | 6.29 | 6.29 | 6.29 | 6.29 | 6.29 |
Capital Expenditure | -22.1 | -18.9 | -37.7 | -70.7 | -66.0 | -64.1 | -76.9 | -92.4 | -110.9 | -133.1 |
Capital Expenditure, % | -2.9 | -1.91 | -2.97 | -5.09 | -4.23 | -3.42 | -3.42 | -3.42 | -3.42 | -3.42 |
Tax Rate, % | 12.43 | 12.43 | 12.43 | 12.43 | 12.43 | 12.43 | 12.43 | 12.43 | 12.43 | 12.43 |
EBITAT | -64.3 | -121.2 | -103.8 | -419.5 | 37.4 | -196.2 | -235.5 | -282.7 | -339.4 | -407.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -61.7 | -96.6 | -99.9 | -483.9 | -61.6 | -168.3 | -265.0 | -318.1 | -381.9 | -458.4 |
WACC, % | 10.89 | 10.89 | 10.89 | 10.86 | 10.85 | 10.88 | 10.88 | 10.88 | 10.88 | 10.88 |
PV UFCF | ||||||||||
SUM PV UFCF | -1,127.1 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -468 | |||||||||
Terminal Value | -5,268 | |||||||||
Present Terminal Value | -3,144 | |||||||||
Enterprise Value | -4,271 | |||||||||
Net Debt | 387 | |||||||||
Equity Value | -4,658 | |||||||||
Diluted Shares Outstanding, MM | 58 | |||||||||
Equity Value Per Share | -79.75 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real WIX financials.
- Real-World Data: Historical data and forward-looking estimates (as indicated in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the effect of your inputs on Wix’s valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Comprehensive WIX Data: Pre-loaded with Wix’s historical performance metrics and future growth estimates.
- Flexible Input Options: Modify key parameters like revenue growth, profit margins, WACC, tax rates, and capital expenditures.
- Adaptive Valuation Model: Instantaneous updates to Net Present Value (NPV) and intrinsic value based on your adjustments.
- Scenario Analysis: Develop various forecasting scenarios to explore different valuation possibilities.
- Intuitive Interface: Clean, organized layout suitable for both experienced users and newcomers.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review Wix.com Ltd.'s pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
- Step 5: Analyze the results and leverage the outputs for informed investment decisions.
Why Choose This Calculator?
- Designed for Experts: A sophisticated tool utilized by web developers, digital marketers, and business owners.
- Up-to-Date Data: Wix’s historical and projected performance metrics preloaded for precision.
- Flexible Scenario Analysis: Easily simulate various growth strategies and market conditions.
- Comprehensive Outputs: Automatically computes website performance metrics, ROI, and other key indicators.
- User-Friendly: Step-by-step guidance helps you navigate the calculator effortlessly.
Who Should Use This Product?
- Investors: Evaluate Wix’s valuation before making stock transactions.
- CFOs and Financial Analysts: Optimize valuation workflows and assess financial forecasts.
- Startup Founders: Understand how leading public companies like Wix are appraised.
- Consultants: Provide expert valuation reports for your clients.
- Students and Educators: Utilize real-time data to practice and teach valuation methods.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Wix.com Ltd. (WIX) 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 Wix.com Ltd. (WIX).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.