|
Acme United Corporation (ACU) DCF Valuation
US | Consumer Defensive | Household & Personal Products | 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
Acme United Corporation (ACU) Bundle
Simplify Acme United Corporation (ACU) valuation with this customizable DCF Calculator! Featuring real Acme United Corporation (ACU) financials and adjustable forecast inputs, you can test scenarios and uncover Acme United Corporation (ACU) fair value in minutes.
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 | 142.5 | 164.0 | 182.1 | 194.0 | 191.5 | 206.5 | 222.8 | 240.2 | 259.1 | 279.4 |
Revenue Growth, % | 0 | 15.12 | 11.03 | 6.52 | -1.27 | 7.85 | 7.85 | 7.85 | 7.85 | 7.85 |
EBITDA | 11.8 | 14.6 | 20.3 | 10.6 | 30.9 | 20.6 | 22.3 | 24.0 | 25.9 | 27.9 |
EBITDA, % | 8.3 | 8.91 | 11.15 | 5.46 | 16.13 | 9.99 | 9.99 | 9.99 | 9.99 | 9.99 |
Depreciation | 3.5 | 3.8 | 4.2 | 4.5 | 5.1 | 5.0 | 5.4 | 5.8 | 6.2 | 6.7 |
Depreciation, % | 2.42 | 2.34 | 2.31 | 2.34 | 2.65 | 2.41 | 2.41 | 2.41 | 2.41 | 2.41 |
EBIT | 8.4 | 10.8 | 16.1 | 6.1 | 25.8 | 15.7 | 16.9 | 18.2 | 19.6 | 21.2 |
EBIT, % | 5.88 | 6.57 | 8.84 | 3.12 | 13.49 | 7.58 | 7.58 | 7.58 | 7.58 | 7.58 |
Total Cash | 6.8 | 4.2 | 4.8 | 6.1 | 4.8 | 6.5 | 7.0 | 7.5 | 8.1 | 8.7 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 25.5 | 27.2 | 34.2 | 32.6 | 26.2 | 34.6 | 37.3 | 40.2 | 43.4 | 46.8 |
Account Receivables, % | 17.89 | 16.57 | 18.79 | 16.81 | 13.7 | 16.75 | 16.75 | 16.75 | 16.75 | 16.75 |
Inventories | 39.3 | 50.7 | 53.6 | 63.3 | 55.5 | 61.8 | 66.6 | 71.8 | 77.5 | 83.6 |
Inventories, % | 27.56 | 30.92 | 29.41 | 32.65 | 28.97 | 29.9 | 29.9 | 29.9 | 29.9 | 29.9 |
Accounts Payable | 6.7 | 7.6 | 9.0 | 10.5 | 12.1 | 10.7 | 11.6 | 12.5 | 13.5 | 14.5 |
Accounts Payable, % | 4.7 | 4.63 | 4.93 | 5.42 | 6.32 | 5.2 | 5.2 | 5.2 | 5.2 | 5.2 |
Capital Expenditure | -1.7 | -2.6 | -6.4 | -4.6 | -5.0 | -4.6 | -5.0 | -5.4 | -5.8 | -6.3 |
Capital Expenditure, % | -1.18 | -1.57 | -3.5 | -2.37 | -2.6 | -2.24 | -2.24 | -2.24 | -2.24 | -2.24 |
Tax Rate, % | 21.74 | 21.74 | 21.74 | 21.74 | 21.74 | 21.74 | 21.74 | 21.74 | 21.74 | 21.74 |
EBITAT | 7.1 | 8.9 | 14.5 | 5.0 | 20.2 | 13.1 | 14.1 | 15.2 | 16.4 | 17.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -49.2 | -2.1 | 3.8 | -1.7 | 36.1 | -2.6 | 7.8 | 8.4 | 9.0 | 9.7 |
WACC, % | 7.98 | 7.94 | 8.09 | 7.95 | 7.86 | 7.96 | 7.96 | 7.96 | 7.96 | 7.96 |
PV UFCF | ||||||||||
SUM PV UFCF | 24.2 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 10 | |||||||||
Terminal Value | 167 | |||||||||
Present Terminal Value | 114 | |||||||||
Enterprise Value | 138 | |||||||||
Net Debt | 20 | |||||||||
Equity Value | 117 | |||||||||
Diluted Shares Outstanding, MM | 4 | |||||||||
Equity Value Per Share | 32.08 |
What You Will Get
- Real ACU Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Instant Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Explore various scenarios to assess Acme United's future performance.
- User-Friendly Design: Designed for professionals while remaining easy to use for newcomers.
Key Features
- Customizable Financial Inputs: Adjust essential metrics such as revenue growth, operating margin, and capital investments.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and additional financial metrics.
- High Precision Results: Leverages Acme United Corporation’s (ACU) actual financial data for accurate valuation results.
- Simplified Scenario Analysis: Effortlessly evaluate various assumptions and analyze different outcomes.
- Efficiency Booster: Remove the hassle of constructing intricate valuation models from the ground up.
How It Works
- Download: Obtain the pre-built Excel file containing Acme United Corporation’s (ACU) financial data.
- Customize: Modify projections, such as revenue growth, EBITDA %, and WACC to fit your analysis.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time as you make adjustments.
- Test Scenarios: Generate various projections and instantly evaluate different outcomes.
- Make Decisions: Leverage the valuation insights to inform your investment approach.
Why Choose Acme United Corporation (ACU)?
- Time Efficient: Skip the hassle of building a model from the ground up – it’s ready for immediate use.
- Enhanced Precision: Dependable financial data and calculations minimize valuation errors.
- Completely Customizable: Adjust the model to align with your specific assumptions and forecasts.
- User-Friendly: Intuitive charts and outputs simplify the analysis of results.
- Endorsed by Professionals: Crafted for experts who prioritize accuracy and ease of use.
Who Should Use Acme United Corporation (ACU) Products?
- Finance Students: Understand the fundamentals of financial analysis and apply them using real-world data.
- Academics: Utilize industry-standard models for research or educational purposes.
- Investors: Evaluate your investment strategies and assess valuation metrics for Acme United Corporation (ACU).
- Analysts: Enhance your analysis with a user-friendly, customizable financial model.
- Small Business Owners: Discover how larger public companies like Acme United Corporation (ACU) conduct financial assessments.
What the Template Contains
- Pre-Filled DCF Model: Acme United Corporation’s (ACU) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Acme United Corporation’s (ACU) 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.