Cimpress plc (CMPR) 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
Cimpress plc (CMPR) Bundle
Evaluate Cimpress plc's (CMPR) financial outlook like an expert! This (CMPR) DCF Calculator provides pre-filled financial data and allows you the flexibility to modify revenue growth, WACC, margins, and other essential 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 | 2,481.4 | 2,592.5 | 2,887.6 | 3,079.6 | 3,291.9 | 3,533.8 | 3,793.6 | 4,072.5 | 4,371.8 | 4,693.2 |
Revenue Growth, % | 0 | 4.48 | 11.38 | 6.65 | 6.89 | 7.35 | 7.35 | 7.35 | 7.35 | 7.35 |
EBITDA | 246.8 | 229.0 | 284.4 | 245.0 | 400.0 | 344.5 | 369.8 | 397.0 | 426.1 | 457.5 |
EBITDA, % | 9.95 | 8.83 | 9.85 | 7.96 | 12.15 | 9.75 | 9.75 | 9.75 | 9.75 | 9.75 |
Depreciation | 167.9 | 173.2 | 175.7 | 162.4 | 151.8 | 207.9 | 223.2 | 239.6 | 257.2 | 276.1 |
Depreciation, % | 6.77 | 6.68 | 6.08 | 5.27 | 4.61 | 5.88 | 5.88 | 5.88 | 5.88 | 5.88 |
EBIT | 78.8 | 55.8 | 108.8 | 82.6 | 248.3 | 136.5 | 146.6 | 157.4 | 168.9 | 181.3 |
EBIT, % | 3.18 | 2.15 | 3.77 | 2.68 | 7.54 | 3.86 | 3.86 | 3.86 | 3.86 | 3.86 |
Total Cash | 45.0 | 335.3 | 327.0 | 168.9 | 208.3 | 267.7 | 287.4 | 308.5 | 331.2 | 355.6 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 34.6 | 50.7 | 63.9 | 67.4 | 64.6 | 68.6 | 73.7 | 79.1 | 84.9 | 91.1 |
Account Receivables, % | 1.39 | 1.95 | 2.21 | 2.19 | 1.96 | 1.94 | 1.94 | 1.94 | 1.94 | 1.94 |
Inventories | 80.2 | 70.0 | 126.7 | 107.8 | 97.0 | 118.5 | 127.2 | 136.6 | 146.6 | 157.4 |
Inventories, % | 3.23 | 2.7 | 4.39 | 3.5 | 2.95 | 3.35 | 3.35 | 3.35 | 3.35 | 3.35 |
Accounts Payable | 163.9 | 199.8 | 313.7 | 285.8 | 326.7 | 313.7 | 336.7 | 361.5 | 388.0 | 416.6 |
Accounts Payable, % | 6.6 | 7.71 | 10.86 | 9.28 | 9.92 | 8.88 | 8.88 | 8.88 | 8.88 | 8.88 |
Capital Expenditure | -94.5 | -99.5 | -119.3 | -111.6 | -54.9 | -120.6 | -129.5 | -139.0 | -149.2 | -160.2 |
Capital Expenditure, % | -3.81 | -3.84 | -4.13 | -3.62 | -1.67 | -3.41 | -3.41 | -3.41 | -3.41 | -3.41 |
Tax Rate, % | -35.22 | -35.22 | -35.22 | -35.22 | -35.22 | -35.22 | -35.22 | -35.22 | -35.22 | -35.22 |
EBITAT | 2,188.7 | 74.6 | -589.4 | 508.1 | 335.7 | 109.2 | 117.3 | 125.9 | 135.1 | 145.1 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 2,311.3 | 178.4 | -489.1 | 546.5 | 487.0 | 158.0 | 220.3 | 236.5 | 253.9 | 272.5 |
WACC, % | 10.76 | 10.76 | 7.5 | 10.76 | 10.76 | 10.11 | 10.11 | 10.11 | 10.11 | 10.11 |
PV UFCF | ||||||||||
SUM PV UFCF | 843.3 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 278 | |||||||||
Terminal Value | 3,427 | |||||||||
Present Terminal Value | 2,117 | |||||||||
Enterprise Value | 2,961 | |||||||||
Net Debt | 1,518 | |||||||||
Equity Value | 1,442 | |||||||||
Diluted Shares Outstanding, MM | 27 | |||||||||
Equity Value Per Share | 53.41 |
What You Will Get
- Real Cimpress Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Cimpress plc (CMPR).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specific to Cimpress plc (CMPR).
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Cimpress plc (CMPR)’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections for Cimpress plc (CMPR).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for Cimpress plc (CMPR).
Key Features
- Comprehensive Financial Data: Access Cimpress plc’s historical financial reports and pre-populated forecasts.
- Customizable Parameters: Adjust WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Valuation: Watch Cimpress plc’s intrinsic value update instantly.
- Intuitive Visual Representations: Dashboard charts showcase valuation outcomes and essential metrics.
- Designed for Precision: A reliable tool tailored for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Cimpress plc (CMPR) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Cimpress plc (CMPR)’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator?
- User-Friendly Interface: Perfectly crafted for both novices and seasoned users.
- Customizable Inputs: Adjust parameters effortlessly to suit your analysis needs.
- Real-Time Adjustments: Witness immediate updates to Cimpress plc’s (CMPR) valuation as you modify inputs.
- Preconfigured Data: Comes with Cimpress plc’s (CMPR) actual financial information for swift evaluations.
- Relied Upon by Experts: A go-to tool for investors and analysts aiming for well-informed decisions.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for portfolio assessment related to Cimpress plc (CMPR).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in Cimpress plc (CMPR).
- Students and Educators: Utilize real-world data for practicing and teaching financial modeling techniques.
- Tech Enthusiasts: Gain insights into how companies like Cimpress plc (CMPR) are valued in the tech market.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring in-depth valuation calculations.
- Real-World Data: Cimpress plc’s (CMPR) historical and projected financials preloaded for analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Visualizations and tables for clear, actionable insights.