Dynatrace, Inc. (DT) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Dynatrace, Inc. (DT) Bundle
Designed for accuracy, our Dynatrace (DT) DCF Calculator enables you to evaluate Dynatrace, Inc. valuation using real-world financial data while providing complete flexibility to modify all essential parameters for improved 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 | 545.8 | 703.5 | 929.4 | 1,158.5 | 1,430.5 | 1,820.8 | 2,317.6 | 2,950.0 | 3,754.8 | 4,779.3 |
Revenue Growth, % | 0 | 28.89 | 32.12 | 24.65 | 23.48 | 27.28 | 27.28 | 27.28 | 27.28 | 27.28 |
EBITDA | -109.5 | 153.0 | 138.2 | 147.4 | 183.3 | 153.3 | 195.1 | 248.4 | 316.1 | 402.4 |
EBITDA, % | -20.06 | 21.75 | 14.87 | 12.72 | 12.82 | 8.42 | 8.42 | 8.42 | 8.42 | 8.42 |
Depreciation | 66.3 | 61.0 | 56.9 | 54.6 | 54.9 | 129.2 | 164.5 | 209.4 | 266.5 | 339.2 |
Depreciation, % | 12.15 | 8.67 | 6.12 | 4.71 | 3.84 | 7.1 | 7.1 | 7.1 | 7.1 | 7.1 |
EBIT | -175.8 | 92.1 | 81.3 | 92.8 | 128.4 | 24.1 | 30.6 | 39.0 | 49.6 | 63.1 |
EBIT, % | -32.22 | 13.09 | 8.75 | 8.01 | 8.98 | 1.32 | 1.32 | 1.32 | 1.32 | 1.32 |
Total Cash | 213.2 | 325.0 | 463.0 | 555.3 | 836.9 | 879.4 | 1,119.4 | 1,424.8 | 1,813.5 | 2,308.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 157.1 | 242.1 | 350.7 | 442.5 | 613.6 | 662.8 | 843.6 | 1,073.8 | 1,366.8 | 1,739.7 |
Account Receivables, % | 28.78 | 34.41 | 37.73 | 38.2 | 42.89 | 36.4 | 36.4 | 36.4 | 36.4 | 36.4 |
Inventories | 38.5 | 49.0 | 62.6 | 83.0 | .0 | 101.7 | 129.4 | 164.7 | 209.7 | 266.9 |
Inventories, % | 7.06 | 6.96 | 6.74 | 7.17 | 0 | 5.58 | 5.58 | 5.58 | 5.58 | 5.58 |
Accounts Payable | 11.1 | 9.6 | 22.7 | 22.0 | 21.4 | 33.6 | 42.8 | 54.5 | 69.4 | 88.3 |
Accounts Payable, % | 2.04 | 1.37 | 2.44 | 1.89 | 1.5 | 1.85 | 1.85 | 1.85 | 1.85 | 1.85 |
Capital Expenditure | -20.6 | -14.1 | -17.7 | -21.5 | -31.7 | -42.8 | -54.5 | -69.4 | -88.3 | -112.4 |
Capital Expenditure, % | -3.78 | -2 | -1.9 | -1.86 | -2.22 | -2.35 | -2.35 | -2.35 | -2.35 | -2.35 |
Tax Rate, % | 0.18268 | 0.18268 | 0.18268 | 0.18268 | 0.18268 | 0.18268 | 0.18268 | 0.18268 | 0.18268 | 0.18268 |
EBITAT | -336.4 | 89.5 | 59.5 | 111.4 | 128.2 | 22.6 | 28.8 | 36.6 | 46.6 | 59.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -475.1 | 39.4 | -10.4 | 31.4 | 62.8 | -29.6 | -60.6 | -77.1 | -98.2 | -125.0 |
WACC, % | 9.4 | 9.4 | 9.39 | 9.4 | 9.4 | 9.4 | 9.4 | 9.4 | 9.4 | 9.4 |
PV UFCF | ||||||||||
SUM PV UFCF | -284.9 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | -130 | |||||||||
Terminal Value | -2,408 | |||||||||
Present Terminal Value | -1,537 | |||||||||
Enterprise Value | -1,821 | |||||||||
Net Debt | -709 | |||||||||
Equity Value | -1,112 | |||||||||
Diluted Shares Outstanding, MM | 299 | |||||||||
Equity Value Per Share | -3.72 |
What You Will Get
- Real DT Financial Data: Pre-filled with Dynatrace’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Dynatrace’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Comprehensive Performance Monitoring: Offers real-time insights into application performance and user experience.
- AI-Powered Analytics: Leverages artificial intelligence to provide predictive analytics and automated root cause analysis.
- Customizable Dashboards: Tailor dashboards to display key metrics and data visualizations relevant to your business needs.
- Seamless Integration: Easily integrates with various cloud platforms and DevOps tools for streamlined operations.
- Robust Security Features: Ensures data protection and compliance with built-in security protocols.
How It Works
- Step 1: Download the prebuilt Excel template featuring Dynatrace’s data included.
- Step 2: Explore the pre-filled sheets to familiarize yourself with the key performance indicators.
- Step 3: Update forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view recalculated results, including Dynatrace’s intrinsic value.
- Step 5: Make informed investment decisions or create reports based on the outputs.
Why Choose This Tool?
- Designed for Experts: A sophisticated solution utilized by IT professionals, analysts, and DevOps teams.
- Comprehensive Data: Dynatrace’s historical and projected performance metrics preloaded for precision.
- Performance Testing: Easily simulate various scenarios and configurations.
- Insightful Outputs: Automatically generates key performance indicators, metrics, and insights.
- User-Friendly: Step-by-step guidance makes navigation straightforward.
Who Should Use Dynatrace, Inc. (DT)?
- IT Professionals: Enhance your skills in application performance monitoring with real-time data.
- DevOps Teams: Integrate advanced monitoring solutions into your development and deployment processes.
- Business Analysts: Analyze user experience and operational metrics to optimize performance.
- Software Developers: Utilize Dynatrace’s tools to streamline debugging and improve code quality.
- Enterprise Leaders: Gain insights into how top organizations leverage monitoring for strategic decision-making.
What the Template Contains
- Preloaded DT 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.