Yext, Inc. (YEXT) 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
Yext, Inc. (YEXT) Bundle
Evaluate Yext, Inc.'s (YEXT) financial outlook like an expert! This (YEXT) DCF Calculator provides pre-filled financial data and the flexibility to modify revenue growth, WACC, margins, and other critical assumptions to align with your predictions.
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 | 298.8 | 354.7 | 390.6 | 400.9 | 404.3 | 437.0 | 472.3 | 510.4 | 551.6 | 596.2 |
Revenue Growth, % | 0 | 18.68 | 10.13 | 2.63 | 0.86616 | 8.08 | 8.08 | 8.08 | 8.08 | 8.08 |
EBITDA | -77.8 | -71.2 | -65.4 | -36.9 | 24.7 | -57.6 | -62.3 | -67.3 | -72.7 | -78.6 |
EBITDA, % | -26.05 | -20.07 | -16.73 | -9.2 | 6.12 | -13.19 | -13.19 | -13.19 | -13.19 | -13.19 |
Depreciation | 42.3 | 22.8 | 26.1 | 26.4 | 24.6 | 34.9 | 37.7 | 40.8 | 44.1 | 47.6 |
Depreciation, % | 14.15 | 6.43 | 6.68 | 6.58 | 6.09 | 7.99 | 7.99 | 7.99 | 7.99 | 7.99 |
EBIT | -120.1 | -94.0 | -91.4 | -63.3 | .1 | -92.5 | -100.0 | -108.1 | -116.8 | -126.2 |
EBIT, % | -40.2 | -26.5 | -23.41 | -15.78 | 0.03264725 | -21.17 | -21.17 | -21.17 | -21.17 | -21.17 |
Total Cash | 256.1 | 230.4 | 261.2 | 190.2 | 210.2 | 277.0 | 299.4 | 323.6 | 349.7 | 378.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 80.6 | 97.5 | 101.6 | 109.7 | 108.2 | 117.6 | 127.1 | 137.4 | 148.5 | 160.5 |
Account Receivables, % | 26.97 | 27.48 | 26.01 | 27.37 | 26.76 | 26.92 | 26.92 | 26.92 | 26.92 | 26.92 |
Inventories | 28.4 | 30.3 | 34.0 | 31.0 | .0 | 30.2 | 32.6 | 35.2 | 38.1 | 41.1 |
Inventories, % | 9.51 | 8.55 | 8.7 | 7.74 | 0 | 6.9 | 6.9 | 6.9 | 6.9 | 6.9 |
Accounts Payable | 7.4 | 11.5 | 9.2 | 7.3 | 7.4 | 10.2 | 11.1 | 12.0 | 12.9 | 14.0 |
Accounts Payable, % | 2.48 | 3.24 | 2.36 | 1.81 | 1.84 | 2.34 | 2.34 | 2.34 | 2.34 | 2.34 |
Capital Expenditure | -11.9 | -65.1 | -13.4 | -6.2 | -2.7 | -24.5 | -26.4 | -28.6 | -30.9 | -33.4 |
Capital Expenditure, % | -3.98 | -18.36 | -3.44 | -1.54 | -0.67471 | -5.6 | -5.6 | -5.6 | -5.6 | -5.6 |
Tax Rate, % | -678.11 | -678.11 | -678.11 | -678.11 | -678.11 | -678.11 | -678.11 | -678.11 | -678.11 | -678.11 |
EBITAT | -121.2 | -94.1 | -92.7 | -65.3 | 1.0 | -92.5 | -100.0 | -108.1 | -116.8 | -126.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -192.4 | -151.1 | -90.1 | -52.2 | 55.6 | -118.9 | -99.8 | -107.9 | -116.6 | -126.0 |
WACC, % | 9.33 | 9.33 | 9.33 | 9.33 | 9.33 | 9.33 | 9.33 | 9.33 | 9.33 | 9.33 |
PV UFCF | ||||||||||
SUM PV UFCF | -437.1 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -129 | |||||||||
Terminal Value | -1,755 | |||||||||
Present Terminal Value | -1,123 | |||||||||
Enterprise Value | -1,561 | |||||||||
Net Debt | -104 | |||||||||
Equity Value | -1,457 | |||||||||
Diluted Shares Outstanding, MM | 124 | |||||||||
Equity Value Per Share | -11.74 |
What You Will Get
- Comprehensive YEXT Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Real-Time Calculations: Intrinsic value and NPV are computed automatically.
- Scenario Analysis: Evaluate various scenarios to assess Yext’s future performance.
- User-Friendly Interface: Designed for professionals while remaining accessible to newcomers.
Key Features
- Comprehensive Yext Data: Gain access to accurate pre-loaded historical performance metrics and future expectations.
- Adjustable Forecast Parameters: Modify highlighted cells for key variables such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Instant updates to DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: User-friendly graphs and summaries to help visualize your valuation outcomes.
- Designed for All Levels: An intuitive layout tailored for investors, CFOs, and consultants alike.
How It Works
- 1. Access the Template: Download and open the Excel file containing Yext, Inc.'s (YEXT) preloaded data.
- 2. Modify Key Inputs: Adjust essential parameters such as growth projections, WACC, and capital expenditures.
- 3. See Results Immediately: The DCF model automatically computes intrinsic value and NPV in real-time.
- 4. Explore Different Scenarios: Evaluate various forecasts to investigate alternative valuation results.
- 5. Present with Assurance: Deliver professional valuation analysis to reinforce your decision-making process.
Why Choose This Calculator for Yext, Inc. (YEXT)?
- All-in-One Solution: Features DCF, WACC, and financial ratio analyses tailored for Yext, Inc. (YEXT).
- Flexible Inputs: Modify the highlighted cells to explore different financial scenarios for Yext, Inc. (YEXT).
- In-Depth Analysis: Automatically computes Yext, Inc. (YEXT)'s intrinsic value and Net Present Value.
- Preloaded Information: Access historical and forecasted data for precise calculations related to Yext, Inc. (YEXT).
- High-Quality Standards: Perfect for financial analysts, investors, and consultants focused on Yext, Inc. (YEXT).
Who Should Use Yext, Inc. (YEXT)?
- Business Owners: Enhance your online presence and manage business information effortlessly.
- Marketing Professionals: Streamline local SEO efforts with an intuitive platform designed for optimization.
- Agencies: Deliver comprehensive solutions to clients looking to improve their digital footprint.
- Brand Managers: Gain insights into customer interactions and brand visibility across various platforms.
- Students and Educators: Explore real-world applications of digital marketing strategies in academic settings.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations tailored for Yext, Inc. (YEXT).
- Real-World Data: Yext’s historical and projected financials preloaded for thorough analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into Yext’s performance.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage specific to Yext, Inc. (YEXT).
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable insights on Yext’s financial health.