|
Espey Mfg. & Electronics Corp. (ESP) DCF Valuation
US | Industrials | Electrical Equipment & Parts | AMEX
|
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Espey Mfg. & Electronics Corp. (ESP) Bundle
Explore the financial future of Espey Mfg. & Electronics Corp. (ESP) using our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to calculate the intrinsic value of Espey Mfg. & Electronics Corp. (ESP) and inform your investment decisions.
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 | 31.5 | 27.7 | 32.1 | 35.6 | 38.7 | 41.0 | 43.4 | 45.9 | 48.6 | 51.5 |
Revenue Growth, % | 0 | -12.03 | 15.76 | 10.86 | 8.83 | 5.86 | 5.86 | 5.86 | 5.86 | 5.86 |
EBITDA | 1.7 | .1 | 2.0 | 4.8 | 7.0 | 3.6 | 3.8 | 4.0 | 4.2 | 4.5 |
EBITDA, % | 5.52 | 0.33775 | 6.3 | 13.44 | 18.05 | 8.73 | 8.73 | 8.73 | 8.73 | 8.73 |
Depreciation | .6 | .5 | .5 | .5 | .5 | .6 | .7 | .7 | .8 | .8 |
Depreciation, % | 1.8 | 1.87 | 1.54 | 1.36 | 1.17 | 1.55 | 1.55 | 1.55 | 1.55 | 1.55 |
EBIT | 1.2 | -.4 | 1.5 | 4.3 | 6.5 | 2.9 | 3.1 | 3.3 | 3.5 | 3.7 |
EBIT, % | 3.72 | -1.54 | 4.76 | 12.08 | 16.88 | 7.18 | 7.18 | 7.18 | 7.18 | 7.18 |
Total Cash | 10.5 | 9.9 | 11.8 | 14.7 | 23.2 | 17.0 | 18.0 | 19.0 | 20.2 | 21.3 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 9.0 | 5.6 | 5.7 | 5.8 | 6.6 | 8.2 | 8.7 | 9.2 | 9.7 | 10.3 |
Account Receivables, % | 28.59 | 20.2 | 17.86 | 16.27 | 17.13 | 20.01 | 20.01 | 20.01 | 20.01 | 20.01 |
Inventories | 14.8 | 18.8 | 18.6 | 19.9 | 19.2 | 22.8 | 24.1 | 25.6 | 27.0 | 28.6 |
Inventories, % | 46.91 | 67.76 | 57.81 | 55.88 | 49.68 | 55.61 | 55.61 | 55.61 | 55.61 | 55.61 |
Accounts Payable | 2.9 | 2.7 | 2.1 | 1.2 | 3.8 | 3.2 | 3.3 | 3.5 | 3.7 | 4.0 |
Accounts Payable, % | 9.08 | 9.8 | 6.48 | 3.41 | 9.68 | 7.69 | 7.69 | 7.69 | 7.69 | 7.69 |
Capital Expenditure | -.2 | .0 | -.3 | -.5 | -5.2 | -1.4 | -1.4 | -1.5 | -1.6 | -1.7 |
Capital Expenditure, % | -0.68014 | -0.15704 | -0.94553 | -1.44 | -13.33 | -3.31 | -3.31 | -3.31 | -3.31 | -3.31 |
Tax Rate, % | 20.29 | 20.29 | 20.29 | 20.29 | 20.29 | 20.29 | 20.29 | 20.29 | 20.29 | 20.29 |
EBITAT | 1.0 | -.2 | 1.2 | 3.4 | 5.2 | 2.2 | 2.3 | 2.5 | 2.6 | 2.8 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -19.5 | -.5 | .9 | 1.1 | 2.8 | -4.2 | -.1 | -.1 | -.1 | -.1 |
WACC, % | 5.39 | 5.39 | 5.39 | 5.39 | 5.39 | 5.39 | 5.39 | 5.39 | 5.39 | 5.39 |
PV UFCF | ||||||||||
SUM PV UFCF | -4.2 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 0 | |||||||||
Terminal Value | -1 | |||||||||
Present Terminal Value | -1 | |||||||||
Enterprise Value | -5 | |||||||||
Net Debt | -4 | |||||||||
Equity Value | -1 | |||||||||
Diluted Shares Outstanding, MM | 3 | |||||||||
Equity Value Per Share | -0.35 |
What You Will Get
- Editable Forecast Inputs: Effortlessly modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Espey Mfg. & Electronics Corp. (ESP) financial data pre-filled to kickstart your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A sleek Excel model that adjusts to your valuation requirements.
- Built for Analysts and Investors: Perfect for testing projections, validating strategies, and enhancing efficiency.
Key Features
- Accurate Financial Data: Gain access to reliable historical data and future forecasts for Espey Mfg. & Electronics Corp. (ESP).
- Tailored Forecast Inputs: Modify highlighted cells for parameters such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Enjoy automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: View easy-to-understand charts and summaries to interpret your valuation findings.
- Designed for All Users: A user-friendly layout suitable for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the Excel file for Espey Mfg. & Electronics Corp. (ESP).
- Step 2: Review the pre-filled financial data and forecasts for Espey Mfg. & Electronics Corp. (ESP).
- 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 your assumptions.
- Step 5: Evaluate the outputs and leverage the results for your investment strategies.
Why Choose This Calculator for Espey Mfg. & Electronics Corp. (ESP)?
- Designed for Industry Experts: A specialized tool utilized by engineers, financial analysts, and project managers.
- Comprehensive Data: Espey’s historical and projected financials are preloaded for precise analysis.
- Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions.
- Insightful Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly: Step-by-step guidance simplifies the calculation process.
Who Should Use This Product?
- Engineering Students: Explore manufacturing processes and apply theoretical knowledge to real-world scenarios.
- Researchers: Utilize advanced models in studies related to electronics manufacturing and innovation.
- Investors: Evaluate your investment strategies and assess the performance of Espey Mfg. & Electronics Corp. (ESP).
- Industry Analysts: Enhance your analysis with a comprehensive, customizable financial model specific to the electronics sector.
- Entrepreneurs: Understand how established companies like Espey Mfg. & Electronics Corp. (ESP) navigate market challenges.
What the Template Contains
- Pre-Filled DCF Model: Espey Mfg. & Electronics Corp.'s (ESP) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Espey Mfg. & Electronics Corp.'s (ESP) profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.