Endava plc (DAVA) 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
Endava plc (DAVA) Bundle
Evaluate Endava plc's financial future with expertise! This (DAVA) DCF Calculator provides pre-filled financial data and full flexibility to modify revenue growth, WACC, margins, and other crucial assumptions to align with your projections.
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 | 441.6 | 561.6 | 823.9 | 1,000.1 | 932.1 | 1,138.3 | 1,390.0 | 1,697.4 | 2,072.8 | 2,531.3 |
Revenue Growth, % | 0 | 27.17 | 46.71 | 21.38 | -6.79 | 22.12 | 22.12 | 22.12 | 22.12 | 22.12 |
EBITDA | 24.7 | 102.3 | 121.9 | 189.7 | 90.8 | 153.3 | 187.2 | 228.5 | 279.1 | 340.8 |
EBITDA, % | 5.6 | 18.21 | 14.79 | 18.97 | 9.75 | 13.46 | 13.46 | 13.46 | 13.46 | 13.46 |
Depreciation | 23.0 | 30.8 | 36.5 | 41.4 | 49.0 | 55.8 | 68.1 | 83.2 | 101.6 | 124.0 |
Depreciation, % | 5.2 | 5.48 | 4.42 | 4.14 | 5.26 | 4.9 | 4.9 | 4.9 | 4.9 | 4.9 |
EBIT | 1.8 | 71.5 | 85.4 | 148.3 | 41.8 | 97.5 | 119.0 | 145.4 | 177.5 | 216.8 |
EBIT, % | 0.40063 | 12.73 | 10.37 | 14.83 | 4.49 | 8.56 | 8.56 | 8.56 | 8.56 | 8.56 |
Total Cash | 128.2 | 88.6 | 205.4 | 207.3 | 78.7 | 225.2 | 275.0 | 335.8 | 410.1 | 500.8 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 104.7 | 142.3 | 166.2 | 216.9 | 243.6 | 266.4 | 325.3 | 397.3 | 485.2 | 592.5 |
Account Receivables, % | 23.71 | 25.34 | 20.17 | 21.68 | 26.13 | 23.41 | 23.41 | 23.41 | 23.41 | 23.41 |
Inventories | -3.7 | .0 | .0 | .0 | .0 | -1.9 | -2.3 | -2.8 | -3.5 | -4.2 |
Inventories, % | -0.8326 | 0.000000224 | 0.000000153 | 0.000000126 | 0 | -0.16652 | -0.16652 | -0.16652 | -0.16652 | -0.16652 |
Accounts Payable | 73.7 | 8.8 | 10.3 | 6.9 | 13.8 | 49.4 | 60.3 | 73.6 | 89.9 | 109.8 |
Accounts Payable, % | 16.7 | 1.57 | 1.25 | 0.68954 | 1.48 | 4.34 | 4.34 | 4.34 | 4.34 | 4.34 |
Capital Expenditure | -12.4 | -7.7 | -17.6 | -17.2 | -6.9 | -20.0 | -24.4 | -29.8 | -36.4 | -44.4 |
Capital Expenditure, % | -2.82 | -1.37 | -2.13 | -1.72 | -0.74059 | -1.76 | -1.76 | -1.76 | -1.76 | -1.76 |
Tax Rate, % | 36.54 | 36.54 | 36.54 | 36.54 | 36.54 | 36.54 | 36.54 | 36.54 | 36.54 | 36.54 |
EBITAT | 1.4 | 57.2 | 69.3 | 122.3 | 26.6 | 75.3 | 91.9 | 112.3 | 137.1 | 167.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -15.3 | -26.0 | 65.9 | 92.4 | 48.8 | 125.7 | 88.1 | 107.6 | 131.3 | 160.4 |
WACC, % | 9.35 | 9.36 | 9.37 | 9.37 | 9.27 | 9.34 | 9.34 | 9.34 | 9.34 | 9.34 |
PV UFCF | ||||||||||
SUM PV UFCF | 465.4 | |||||||||
Long Term Growth Rate, % | 3.00 | |||||||||
Free cash flow (T + 1) | 165 | |||||||||
Terminal Value | 2,604 | |||||||||
Present Terminal Value | 1,666 | |||||||||
Enterprise Value | 2,131 | |||||||||
Net Debt | 177 | |||||||||
Equity Value | 1,955 | |||||||||
Diluted Shares Outstanding, MM | 59 | |||||||||
Equity Value Per Share | 33.24 |
What You Will Receive
- Pre-Filled Financial Model: Endava plc’s actual data provides accurate DCF valuation.
- Comprehensive Forecast Control: Modify revenue growth, profit margins, WACC, and other essential drivers.
- Real-Time Calculations: Instant updates allow you to view results as you adjust inputs.
- Professional-Grade Template: An expertly crafted Excel file suitable for high-level valuation.
- Customizable and Reusable: Designed for adaptability, facilitating repeated use for in-depth forecasts.
Key Features
- Comprehensive DAVA Data: Pre-filled with Endava’s historical financials and future growth projections.
- Customizable Financial Inputs: Modify revenue growth rates, profit margins, WACC, tax rates, and capital expenditures as needed.
- Interactive Valuation Model: Automatic recalculations of Net Present Value (NPV) and intrinsic value based on your adjustments.
- Scenario Analysis: Develop various forecast scenarios to evaluate different valuation possibilities.
- User-Centric Interface: Intuitive, organized, and suitable for both professionals and novices.
How It Works
- Step 1: Download the prebuilt Excel template with Endava plc’s (DAVA) data included.
- Step 2: Explore the pre-filled sheets and understand the key metrics.
- Step 3: Update forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view recalculated results, including Endava plc’s (DAVA) intrinsic value.
- Step 5: Make informed investment decisions or generate reports using the outputs.
Why Choose This Calculator?
- User-Friendly Interface: Perfect for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters easily to suit your analysis needs.
- Real-Time Feedback: Observe immediate changes to Endava plc’s (DAVA) valuation as you tweak inputs.
- Preloaded Data: Comes with Endava plc’s (DAVA) actual financial information for swift evaluations.
- Preferred by Experts: Utilized by investors and analysts for making well-informed decisions.
Who Should Use This Product?
- Finance Students: Master valuation methods and practice with actual data related to Endava plc (DAVA).
- Academics: Utilize industry-standard models in your teaching or research focused on Endava plc (DAVA).
- Investors: Validate your investment hypotheses and evaluate valuation results for Endava plc (DAVA) stock.
- Analysts: Enhance your efficiency with a ready-to-use, customizable DCF model tailored for Endava plc (DAVA).
- Small Business Owners: Discover how major public companies like Endava plc (DAVA) are evaluated in the market.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Endava plc 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 Endava plc (DAVA).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.