The Descartes Systems Group Inc. (DSGX) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
The Descartes Systems Group Inc. (DSGX) Bundle
Evaluate the financial outlook of The Descartes Systems Group Inc. (DSGX) like an expert! This (DSGX) DCF Calculator comes with pre-filled financial data and offers full flexibility to modify revenue growth, WACC, margins, and various key 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 | 325.8 | 348.7 | 424.7 | 486.0 | 572.9 | 660.5 | 761.5 | 877.9 | 1,012.1 | 1,166.8 |
Revenue Growth, % | 0 | 7.02 | 21.8 | 14.44 | 17.88 | 15.29 | 15.29 | 15.29 | 15.29 | 15.29 |
EBITDA | 114.2 | 135.4 | 165.5 | 196.8 | 219.4 | 253.2 | 291.9 | 336.5 | 387.9 | 447.2 |
EBITDA, % | 35.05 | 38.83 | 38.98 | 40.5 | 38.29 | 38.33 | 38.33 | 38.33 | 38.33 | 38.33 |
Depreciation | 61.6 | 64.6 | 63.3 | 64.3 | 66.0 | 101.9 | 117.4 | 135.4 | 156.1 | 179.9 |
Depreciation, % | 18.92 | 18.53 | 14.91 | 13.22 | 11.52 | 15.42 | 15.42 | 15.42 | 15.42 | 15.42 |
EBIT | 52.6 | 70.8 | 102.2 | 132.6 | 153.4 | 151.3 | 174.5 | 201.1 | 231.9 | 267.3 |
EBIT, % | 16.13 | 20.3 | 24.07 | 27.28 | 26.77 | 22.91 | 22.91 | 22.91 | 22.91 | 22.91 |
Total Cash | 44.4 | 133.7 | 213.4 | 276.4 | 321.0 | 284.2 | 327.6 | 377.7 | 435.4 | 502.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 42.4 | 52.0 | 41.7 | 45.2 | 63.8 | 76.9 | 88.6 | 102.2 | 117.8 | 135.8 |
Account Receivables, % | 13.02 | 14.92 | 9.82 | 9.29 | 11.13 | 11.64 | 11.64 | 11.64 | 11.64 | 11.64 |
Inventories | .4 | .4 | .9 | .8 | .0 | .8 | .9 | 1.1 | 1.2 | 1.4 |
Inventories, % | 0.12615 | 0.12304 | 0.20438 | 0.15617 | 0 | 0.12195 | 0.12195 | 0.12195 | 0.12195 | 0.12195 |
Accounts Payable | 7.7 | 8.0 | 10.6 | 10.6 | 17.5 | 16.3 | 18.8 | 21.7 | 25.0 | 28.8 |
Accounts Payable, % | 2.35 | 2.28 | 2.49 | 2.17 | 3.05 | 2.47 | 2.47 | 2.47 | 2.47 | 2.47 |
Capital Expenditure | -4.9 | -3.8 | -4.8 | -6.1 | -5.6 | -7.8 | -9.0 | -10.4 | -12.0 | -13.9 |
Capital Expenditure, % | -1.5 | -1.08 | -1.14 | -1.25 | -0.97097 | -1.19 | -1.19 | -1.19 | -1.19 | -1.19 |
Tax Rate, % | 23.32 | 23.32 | 23.32 | 23.32 | 23.32 | 23.32 | 23.32 | 23.32 | 23.32 | 23.32 |
EBITAT | 40.5 | 52.4 | 86.0 | 101.3 | 117.6 | 117.5 | 135.5 | 156.2 | 180.1 | 207.6 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 62.1 | 103.9 | 156.9 | 156.2 | 167.1 | 196.4 | 234.5 | 270.3 | 311.6 | 359.3 |
WACC, % | 7.93 | 7.93 | 7.93 | 7.93 | 7.93 | 7.93 | 7.93 | 7.93 | 7.93 | 7.93 |
PV UFCF | ||||||||||
SUM PV UFCF | 1,073.3 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 366 | |||||||||
Terminal Value | 6,181 | |||||||||
Present Terminal Value | 4,220 | |||||||||
Enterprise Value | 5,294 | |||||||||
Net Debt | -314 | |||||||||
Equity Value | 5,608 | |||||||||
Diluted Shares Outstanding, MM | 87 | |||||||||
Equity Value Per Share | 64.59 |
What You Will Get
- Real Descartes Data: Preloaded financials – encompassing revenue to EBIT – based on actual and projected figures.
- Full Customization: Modify all key parameters (yellow cells) such as WACC, growth %, and tax rates.
- Instant Valuation Updates: Automatic recalculations to assess the impact of changes on Descartes’ fair value.
- Versatile Excel Template: Designed for quick edits, scenario testing, and comprehensive projections.
- Time-Saving and Accurate: Avoid building models from the ground up while ensuring precision and flexibility.
Key Features
- Accurate Financial Data: Gain access to reliable historical figures and future estimates for The Descartes Systems Group Inc. (DSGX).
- Adjustable Forecast Parameters: Modify highlighted fields such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic recalculations for DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: User-friendly charts and summaries to effectively present your valuation findings.
- Designed for All Skill Levels: A straightforward, user-friendly layout tailored for investors, CFOs, and consultants.
How It Works
- Step 1: Download the prebuilt Excel template featuring The Descartes Systems Group Inc. (DSGX) 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 The Descartes Systems Group Inc.'s (DSGX) intrinsic value.
- Step 5: Use the outputs to make informed investment decisions or create detailed reports.
Why Choose This Calculator for The Descartes Systems Group Inc. (DSGX)?
- Accurate Data: Up-to-date financials from Descartes ensure trustworthy valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you the hassle of starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the logistics and technology sectors.
- User-Friendly: Simple design and clear instructions make it accessible for all users.
Who Should Use This Product?
- Logistics Professionals: Enhance your understanding of supply chain optimization using real-time data.
- Researchers: Integrate advanced logistics models into academic studies or projects.
- Investors: Validate your investment strategies and evaluate the performance of Descartes Systems Group Inc. (DSGX).
- Business Analysts: Improve your analysis with a customizable framework for logistics and transportation metrics.
- Small to Medium Enterprises: Discover how large logistics companies like Descartes are analyzed and benchmarked.
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations tailored for The Descartes Systems Group Inc. (DSGX).
- Real-World Data: The Descartes Systems Group’s historical and projected financials preloaded for analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Full annual and quarterly breakdowns for enhanced insights into The Descartes Systems Group Inc. (DSGX).
- Key Ratios: Built-in analysis for profitability, efficiency, and leverage specific to The Descartes Systems Group Inc. (DSGX).
- Dashboard with Visual Outputs: Charts and tables providing clear, actionable results for The Descartes Systems Group Inc. (DSGX).