|
Ennis, Inc. (EBF) DCF Valoración
US | Industrials | Business Equipment & Supplies | NYSE
|
- ✓ 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
Ennis, Inc. (EBF) Bundle
¡Simplifique la valoración de Ennis, Inc. (EBF) con esta calculadora DCF personalizable! Con Real Ennis, Inc. (EBF) financieras y entradas de pronóstico ajustables, puede probar escenarios y descubrir el valor razonable de Ennis, Inc. (EBF) en minutos.
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 | 438.4 | 358.0 | 400.0 | 431.8 | 420.1 | 418.7 | 417.2 | 415.8 | 414.4 | 413.0 |
Revenue Growth, % | 0 | -18.35 | 11.74 | 7.96 | -2.72 | -0.341 | -0.341 | -0.341 | -0.341 | -0.341 |
EBITDA | 70.1 | 51.3 | 60.7 | 82.3 | 72.8 | 68.6 | 68.3 | 68.1 | 67.9 | 67.6 |
EBITDA, % | 15.98 | 14.34 | 15.18 | 19.05 | 17.32 | 16.38 | 16.38 | 16.38 | 16.38 | 16.38 |
Depreciation | 18.2 | 18.0 | 18.8 | 17.4 | 17.5 | 18.5 | 18.4 | 18.4 | 18.3 | 18.2 |
Depreciation, % | 4.15 | 5.04 | 4.69 | 4.02 | 4.17 | 4.41 | 4.41 | 4.41 | 4.41 | 4.41 |
EBIT | 51.9 | 33.3 | 42.0 | 64.9 | 55.3 | 50.1 | 49.9 | 49.7 | 49.6 | 49.4 |
EBIT, % | 11.83 | 9.3 | 10.49 | 15.04 | 13.15 | 11.96 | 11.96 | 11.96 | 11.96 | 11.96 |
Total Cash | 68.3 | 75.2 | 85.6 | 94.0 | 110.9 | 88.9 | 88.6 | 88.3 | 88.0 | 87.7 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 43.1 | 37.9 | 39.0 | 53.5 | 47.2 | 45.0 | 44.9 | 44.7 | 44.6 | 44.4 |
Account Receivables, % | 9.83 | 10.58 | 9.76 | 12.39 | 11.24 | 10.76 | 10.76 | 10.76 | 10.76 | 10.76 |
Inventories | 34.8 | 32.9 | 38.5 | 46.8 | 40.0 | 39.5 | 39.3 | 39.2 | 39.1 | 38.9 |
Inventories, % | 7.95 | 9.19 | 9.63 | 10.85 | 9.53 | 9.43 | 9.43 | 9.43 | 9.43 | 9.43 |
Accounts Payable | 17.2 | 14.8 | 16.7 | 18.3 | 11.8 | 16.2 | 16.1 | 16.0 | 16.0 | 15.9 |
Accounts Payable, % | 3.93 | 4.12 | 4.17 | 4.25 | 2.82 | 3.86 | 3.86 | 3.86 | 3.86 | 3.86 |
Capital Expenditure | -3.4 | -3.7 | -6.5 | -4.3 | -6.5 | -5.0 | -5.0 | -5.0 | -5.0 | -4.9 |
Capital Expenditure, % | -0.77416 | -1.03 | -1.63 | -1 | -1.55 | -1.2 | -1.2 | -1.2 | -1.2 | -1.2 |
Tax Rate, % | 27.95 | 27.95 | 27.95 | 27.95 | 27.95 | 27.95 | 27.95 | 27.95 | 27.95 | 27.95 |
EBITAT | 38.7 | 24.1 | 29.0 | 47.3 | 39.8 | 36.2 | 36.0 | 35.9 | 35.8 | 35.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -7.1 | 43.1 | 36.4 | 39.2 | 57.4 | 56.7 | 49.7 | 49.5 | 49.4 | 49.2 |
WACC, % | 6.36 | 6.36 | 6.36 | 6.36 | 6.36 | 6.36 | 6.36 | 6.36 | 6.36 | 6.36 |
PV UFCF | ||||||||||
SUM PV UFCF | 213.1 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 49 | |||||||||
Terminal Value | 843 | |||||||||
Present Terminal Value | 619 | |||||||||
Enterprise Value | 832 | |||||||||
Net Debt | -72 | |||||||||
Equity Value | 904 | |||||||||
Diluted Shares Outstanding, MM | 26 | |||||||||
Equity Value Per Share | 34.87 |
What You Will Get
- Real EBF Financial Data: Pre-filled with Ennis, Inc.'s historical and projected data for accurate analysis.
- Fully Editable Template: Easily adjust key inputs such as revenue growth, WACC, and EBITDA %.
- Automatic Calculations: Watch Ennis, Inc.'s intrinsic value update in real-time based on your modifications.
- Professional Valuation Tool: Tailored for investors, analysts, and consultants aiming for precise DCF results.
- User-Friendly Design: Intuitive layout and straightforward instructions suitable for all skill levels.
Key Features
- Comprehensive Financial Data: Gain access to precise pre-loaded historical figures and future forecasts for Ennis, Inc. (EBF).
- Adjustable Forecast Parameters: Modify highlighted cells for metrics such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Instant updates to DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Clear charts and summaries to effectively illustrate your valuation insights.
- Designed for All Skill Levels: An intuitive layout tailored for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the Excel file for Ennis, Inc. (EBF).
- Step 2: Review the pre-filled financial data and forecasts for Ennis, Inc. (EBF).
- Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you modify assumptions.
- Step 5: Evaluate the outputs and leverage the results for your investment choices.
Why Choose This Calculator for Ennis, Inc. (EBF)?
- User-Friendly Interface: Perfectly crafted for both novice and experienced users.
- Customizable Inputs: Effortlessly adjust parameters to suit your financial analysis.
- Real-Time Adjustments: Witness immediate updates to Ennis, Inc.'s (EBF) valuation as you tweak inputs.
- Pre-Loaded Data: Comes with Ennis, Inc.'s (EBF) actual financial information for swift evaluations.
- Relied Upon by Experts: A go-to tool for investors and analysts aiming for data-driven decisions.
Who Should Use This Product?
- Investors: Evaluate Ennis, Inc.’s (EBF) financial health before making investment decisions.
- CFOs and Financial Analysts: Enhance valuation methodologies and assess future forecasts.
- Startup Founders: Discover how established companies like Ennis, Inc. (EBF) are valued in the market.
- Consultants: Provide comprehensive valuation analyses and reports for clients.
- Students and Educators: Utilize current data to learn and teach valuation principles effectively.
What the Template Contains
- Historical Data: Includes Ennis, Inc.'s (EBF) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Ennis, Inc.'s (EBF) intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Ennis, Inc.'s (EBF) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.