Ennis, Inc. (EBF) 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
Ennis, Inc. (EBF) Bundle
Simplify Ennis, Inc. (EBF) valuation with this customizable DCF Calculator! Featuring real Ennis, Inc. (EBF) financials and adjustable forecast inputs, you can test scenarios and uncover Ennis, Inc. (EBF) fair value in minutes.
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.