The Eastern Company (EML) 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
The Eastern Company (EML) Bundle
Explore The Eastern Company's (EML) financial prospects with our user-friendly DCF Calculator! Simply enter your projections for growth, profit margins, and expenses to calculate The Eastern Company's (EML) intrinsic value and enhance your investment approach.
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2019 |
AY2 2020 |
AY3 2021 |
AY4 2022 |
AY5 2023 |
FY1 2024 |
FY2 2025 |
FY3 2026 |
FY4 2027 |
FY5 2028 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue | 251.7 | 240.4 | 246.5 | 279.3 | 273.5 | 279.8 | 286.2 | 292.9 | 299.6 | 306.5 |
Revenue Growth, % | 0 | -4.5 | 2.55 | 13.28 | -2.08 | 2.31 | 2.31 | 2.31 | 2.31 | 2.31 |
EBITDA | 24.5 | 23.2 | 26.6 | 23.9 | 22.0 | 26.2 | 26.8 | 27.4 | 28.0 | 28.7 |
EBITDA, % | 9.74 | 9.64 | 10.8 | 8.55 | 8.03 | 9.35 | 9.35 | 9.35 | 9.35 | 9.35 |
Depreciation | 6.4 | 6.8 | 7.2 | 7.2 | 7.5 | 7.6 | 7.8 | 8.0 | 8.2 | 8.4 |
Depreciation, % | 2.56 | 2.84 | 2.94 | 2.58 | 2.73 | 2.73 | 2.73 | 2.73 | 2.73 | 2.73 |
EBIT | 18.1 | 16.3 | 19.4 | 16.7 | 14.5 | 18.5 | 19.0 | 19.4 | 19.8 | 20.3 |
EBIT, % | 7.18 | 6.8 | 7.87 | 5.97 | 5.3 | 6.62 | 6.62 | 6.62 | 6.62 | 6.62 |
Total Cash | 18.0 | 16.1 | 6.2 | 10.2 | 9.3 | 13.1 | 13.4 | 13.7 | 14.0 | 14.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 37.9 | 31.8 | 44.2 | 43.9 | 37.6 | 42.4 | 43.3 | 44.3 | 45.4 | 46.4 |
Account Receivables, % | 15.07 | 13.23 | 17.92 | 15.72 | 13.76 | 15.14 | 15.14 | 15.14 | 15.14 | 15.14 |
Inventories | 54.6 | 53.1 | 62.9 | 64.6 | 59.3 | 63.8 | 65.3 | 66.8 | 68.4 | 70.0 |
Inventories, % | 21.69 | 22.09 | 25.5 | 23.15 | 21.68 | 22.82 | 22.82 | 22.82 | 22.82 | 22.82 |
Accounts Payable | 20.0 | 21.3 | 29.6 | 27.6 | 25.3 | 26.8 | 27.5 | 28.1 | 28.7 | 29.4 |
Accounts Payable, % | 7.93 | 8.86 | 12.02 | 9.9 | 9.26 | 9.59 | 9.59 | 9.59 | 9.59 | 9.59 |
Capital Expenditure | -5.4 | -3.1 | -3.7 | -3.4 | -6.4 | -4.8 | -4.9 | -5.0 | -5.1 | -5.2 |
Capital Expenditure, % | -2.16 | -1.29 | -1.51 | -1.21 | -2.35 | -1.7 | -1.7 | -1.7 | -1.7 | -1.7 |
Tax Rate, % | 21.9 | 21.9 | 21.9 | 21.9 | 21.9 | 21.9 | 21.9 | 21.9 | 21.9 | 21.9 |
EBITAT | 14.8 | 14.7 | 16.5 | 14.2 | 11.3 | 15.6 | 15.9 | 16.3 | 16.7 | 17.1 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -56.8 | 27.4 | 6.2 | 14.6 | 21.7 | 10.7 | 17.0 | 17.4 | 17.8 | 18.2 |
WACC, % | 7.98 | 8.1 | 8.02 | 8.03 | 7.92 | 8.01 | 8.01 | 8.01 | 8.01 | 8.01 |
PV UFCF | ||||||||||
SUM PV UFCF | 63.8 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 18 | |||||||||
Terminal Value | 244 | |||||||||
Present Terminal Value | 166 | |||||||||
Enterprise Value | 230 | |||||||||
Net Debt | 54 | |||||||||
Equity Value | 176 | |||||||||
Diluted Shares Outstanding, MM | 6 | |||||||||
Equity Value Per Share | 28.07 |
What You Will Receive
- Customizable Excel Template: A fully editable Excel-based DCF Calculator featuring pre-filled financial data for The Eastern Company (EML).
- Accurate Historical Data: Access to past performance data and future estimates (highlighted in the yellow cells).
- Adjustable Forecasts: Modify key assumptions such as revenue growth, EBITDA %, and WACC to fit your analysis.
- Instant Calculations: View the immediate effects of your inputs on The Eastern Company’s (EML) valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts alike.
- Intuitive Layout: Organized for easy navigation and understanding, complete with step-by-step guidance.
Key Features
- Comprehensive Financial Data: Gain access to accurate historical performance and future forecasts for The Eastern Company (EML).
- Adjustable Forecast Parameters: Modify highlighted fields such as WACC, growth rates, and profit margins to tailor your analysis.
- Automated Financial Calculations: Enjoy real-time updates to DCF, Net Present Value (NPV), and cash flow metrics.
- User-Friendly Dashboard: Intuitive charts and summaries to help you easily interpret your valuation findings.
- Designed for All Skill Levels: A straightforward, accessible layout suitable for investors, CFOs, and financial consultants.
How It Works
- Step 1: Download the prebuilt Excel template featuring The Eastern Company's (EML) data.
- Step 2: Navigate through the pre-filled sheets to grasp 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 Eastern Company's (EML) intrinsic value.
- Step 5: Make informed investment choices or create reports based on the outputs.
Why Choose This Calculator for The Eastern Company (EML)?
- User-Friendly Interface: Tailored for both novices and seasoned professionals.
- Customizable Parameters: Adjust inputs effortlessly to suit your financial analysis.
- Real-Time Feedback: Observe immediate changes in The Eastern Company’s valuation as you modify inputs.
- Preloaded Financials: Comes equipped with The Eastern Company’s actual financial data for swift evaluations.
- Relied Upon by Experts: Favored by investors and analysts for making well-informed choices.
Who Should Use This Product?
- Investors: Accurately assess The Eastern Company’s (EML) fair value before making investment choices.
- CFOs: Utilize a professional-grade DCF model for comprehensive financial reporting and analysis.
- Consultants: Easily modify the template for valuation reports tailored to clients’ needs.
- Entrepreneurs: Acquire insights into financial modeling practices employed by leading corporations.
- Educators: Implement it as a teaching resource to illustrate various valuation methodologies.
What the Template Contains
- Historical Data: Includes The Eastern Company’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate The Eastern Company’s 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 The Eastern Company’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.