Enerpac Tool Group Corp. (EPAC) DCF Valuation
- ✓ 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
Enerpac Tool Group Corp. (EPAC) Bundle
Looking to assess the intrinsic value of Enerpac Tool Group Corp.? Our (EPAC) DCF Calculator integrates real-world data with extensive customization features, enabling you to refine your forecasts and enhance your investment strategies.
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 | 493.3 | 528.7 | 571.2 | 598.2 | 589.5 | 616.8 | 645.3 | 675.1 | 706.3 | 739.0 |
Revenue Growth, % | 0 | 7.17 | 8.05 | 4.72 | -1.45 | 4.62 | 4.62 | 4.62 | 4.62 | 4.62 |
EBITDA | 48.6 | 70.9 | 48.0 | 97.6 | 132.3 | 86.9 | 90.9 | 95.1 | 99.5 | 104.1 |
EBITDA, % | 9.85 | 13.4 | 8.4 | 16.32 | 22.45 | 14.08 | 14.08 | 14.08 | 14.08 | 14.08 |
Depreciation | 20.7 | 21.6 | 19.6 | 16.3 | 13.3 | 20.6 | 21.5 | 22.5 | 23.6 | 24.7 |
Depreciation, % | 4.2 | 4.09 | 3.43 | 2.73 | 2.25 | 3.34 | 3.34 | 3.34 | 3.34 | 3.34 |
EBIT | 27.9 | 49.2 | 28.4 | 81.3 | 119.0 | 66.3 | 69.3 | 72.5 | 75.9 | 79.4 |
EBIT, % | 5.65 | 9.31 | 4.97 | 13.59 | 20.19 | 10.74 | 10.74 | 10.74 | 10.74 | 10.74 |
Total Cash | 152.2 | 140.4 | 120.7 | 154.4 | 167.1 | 163.7 | 171.2 | 179.2 | 187.4 | 196.1 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 84.2 | 103.2 | 106.7 | 97.6 | 104.3 | 110.2 | 115.2 | 120.6 | 126.1 | 132.0 |
Account Receivables, % | 17.06 | 19.53 | 18.69 | 16.32 | 17.7 | 17.86 | 17.86 | 17.86 | 17.86 | 17.86 |
Inventories | 69.2 | 75.3 | 83.7 | 74.8 | 72.9 | 83.6 | 87.5 | 91.5 | 95.8 | 100.2 |
Inventories, % | 14.02 | 14.25 | 14.65 | 12.5 | 12.36 | 13.56 | 13.56 | 13.56 | 13.56 | 13.56 |
Accounts Payable | 45.1 | 62.0 | 72.5 | 50.5 | 43.4 | 60.9 | 63.7 | 66.6 | 69.7 | 72.9 |
Accounts Payable, % | 9.14 | 11.72 | 12.7 | 8.44 | 7.36 | 9.87 | 9.87 | 9.87 | 9.87 | 9.87 |
Capital Expenditure | -13.5 | -12.0 | -8.4 | -9.4 | -11.4 | -12.3 | -12.9 | -13.5 | -14.1 | -14.8 |
Capital Expenditure, % | -2.73 | -2.27 | -1.47 | -1.57 | -1.94 | -2 | -2 | -2 | -2 | -2 |
Tax Rate, % | 18.74 | 18.74 | 18.74 | 18.74 | 18.74 | 18.74 | 18.74 | 18.74 | 18.74 | 18.74 |
EBITAT | 19.7 | 42.6 | 17.4 | 54.9 | 96.7 | 48.7 | 51.0 | 53.3 | 55.8 | 58.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -81.3 | 43.9 | 27.3 | 57.8 | 86.7 | 58.0 | 53.5 | 56.0 | 58.6 | 61.3 |
WACC, % | 9.45 | 9.53 | 9.4 | 9.43 | 9.51 | 9.46 | 9.46 | 9.46 | 9.46 | 9.46 |
PV UFCF | ||||||||||
SUM PV UFCF | 220.0 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | 64 | |||||||||
Terminal Value | 1,166 | |||||||||
Present Terminal Value | 742 | |||||||||
Enterprise Value | 962 | |||||||||
Net Debt | 27 | |||||||||
Equity Value | 935 | |||||||||
Diluted Shares Outstanding, MM | 55 | |||||||||
Equity Value Per Share | 17.04 |
What You Will Get
- Real EPAC Financials: Access historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Explore various scenarios to assess Enerpac Tool Group Corp.'s future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- Comprehensive Historical Data: Enerpac Tool Group Corp.'s (EPAC) historical financial statements and pre-filled forecasts.
- Customizable Parameters: Modify WACC, tax rates, revenue growth, and EBITDA margins to fit your analysis.
- Real-Time Valuation: Watch the intrinsic value of Enerpac Tool Group Corp. (EPAC) update instantly.
- Informative Visual Representations: Dashboard charts illustrate valuation results and essential metrics clearly.
- Designed for Precision: A reliable tool tailored for analysts, investors, and finance professionals.
How It Works
- Download the Template: Gain immediate access to the Excel-based EPAC DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other key metrics.
- Instant Calculations: The model will automatically refresh Enerpac Tool Group's intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Leverage the outcomes to inform your investment or financial analysis.
Why Choose This Calculator for Enerpac Tool Group Corp. (EPAC)?
- All-in-One Solution: Integrates DCF, WACC, and financial ratio evaluations tailored for Enerpac.
- Flexible Inputs: Modify the highlighted cells to explore different financial scenarios.
- In-Depth Analysis: Automatically computes Enerpac’s intrinsic value and Net Present Value.
- Preloaded Information: Access historical and projected data for precise analysis.
- High-Quality Standards: Perfect for financial analysts, investors, and business advisors focusing on Enerpac.
Who Should Use Enerpac Tool Group Corp. (EPAC)?
- Investors: Make informed investment choices with comprehensive insights into Enerpac's market performance.
- Financial Analysts: Utilize detailed financial reports and analysis tools for precise evaluations of Enerpac's financial health.
- Consultants: Tailor analysis and presentations using Enerpac's data to meet client needs effectively.
- Industry Enthusiasts: Enhance your knowledge of the tool and equipment sector with Enerpac's innovative solutions.
- Educators and Students: Leverage Enerpac's case studies for practical applications in engineering and business courses.
What the Template Contains
- Pre-Filled Data: Includes Enerpac Tool Group Corp.’s historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze Enerpac Tool Group Corp.’s profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.