Associated Capital Group, Inc. (AC) 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
Associated Capital Group, Inc. (AC) Bundle
Looking to determine the intrinsic value of Associated Capital Group, Inc.? Our (AC) 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 2019 |
AY2 2020 |
AY3 2021 |
AY4 2022 |
AY5 2023 |
FY1 2024 |
FY2 2025 |
FY3 2026 |
FY4 2027 |
FY5 2028 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 31.3 | 19.0 | 20.9 | 15.2 | 12.7 | 10.4 | 8.5 | 6.9 | 5.7 | 4.6 |
| Revenue Growth, % | 0 | -39.28 | 10.22 | -27.22 | -16.71 | -18.25 | -18.25 | -18.25 | -18.25 | -18.25 |
| EBITDA | -13.2 | -12.4 | -18.7 | -67.4 | 26.4 | -4.1 | -3.3 | -2.7 | -2.2 | -1.8 |
| EBITDA, % | -42.35 | -65.41 | -89.36 | -442.83 | 208.52 | -39.42 | -39.42 | -39.42 | -39.42 | -39.42 |
| Depreciation | 37.3 | 31.8 | 40.0 | 26.5 | .4 | 8.4 | 6.8 | 5.6 | 4.6 | 3.7 |
| Depreciation, % | 119.26 | 167.72 | 191.17 | 173.96 | 2.84 | 80.57 | 80.57 | 80.57 | 80.57 | 80.57 |
| EBIT | -50.5 | -44.3 | -58.7 | -93.9 | 26.1 | -6.2 | -5.1 | -4.2 | -3.4 | -2.8 |
| EBIT, % | -161.62 | -233.13 | -280.52 | -616.78 | 205.68 | -60 | -60 | -60 | -60 | -60 |
| Total Cash | 348.6 | 384.0 | 380.0 | 404.5 | 406.6 | 10.4 | 8.5 | 6.9 | 5.7 | 4.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 37.1 | 36.8 | 60.9 | 15.6 | 36.5 | 10.4 | 8.5 | 6.9 | 5.7 | 4.6 |
| Account Receivables, % | 118.54 | 193.68 | 290.99 | 102.37 | 287.5 | 100 | 100 | 100 | 100 | 100 |
| Inventories | -29.0 | -344.5 | -61.0 | -186.0 | .0 | -8.1 | -6.7 | -5.4 | -4.5 | -3.6 |
| Inventories, % | -92.87 | -1814.53 | -291.51 | -1221.44 | 0 | -78.57 | -78.57 | -78.57 | -78.57 | -78.57 |
| Accounts Payable | 14.9 | 6.5 | 9.3 | 7.8 | 4.5 | 4.4 | 3.6 | 2.9 | 2.4 | 2.0 |
| Accounts Payable, % | 47.62 | 34.22 | 44.63 | 51.12 | 35.16 | 42.55 | 42.55 | 42.55 | 42.55 | 42.55 |
| Capital Expenditure | -6.5 | -11.1 | .0 | -5.1 | .0 | -2.3 | -1.9 | -1.6 | -1.3 | -1.0 |
| Capital Expenditure, % | -20.85 | -58.39 | 0 | -33.27 | 0 | -22.5 | -22.5 | -22.5 | -22.5 | -22.5 |
| Tax Rate, % | 20.09 | 20.09 | 20.09 | 20.09 | 20.09 | 20.09 | 20.09 | 20.09 | 20.09 | 20.09 |
| EBITAT | -35.4 | -27.9 | -42.7 | -70.7 | 20.8 | -4.5 | -3.7 | -3.0 | -2.5 | -2.0 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 2.2 | 300.2 | -307.5 | 119.5 | -189.0 | 35.7 | .9 | .7 | .6 | .5 |
| WACC, % | 8.53 | 8.52 | 8.53 | 8.53 | 8.53 | 8.53 | 8.53 | 8.53 | 8.53 | 8.53 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 34.9 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 0 | |||||||||
| Terminal Value | 7 | |||||||||
| Present Terminal Value | 5 | |||||||||
| Enterprise Value | 40 | |||||||||
| Net Debt | -317 | |||||||||
| Equity Value | 357 | |||||||||
| Diluted Shares Outstanding, MM | 22 | |||||||||
| Equity Value Per Share | 16.41 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real AC financials.
- Real-World Data: Access to historical data and forward-looking estimates (highlighted in the yellow cells).
- Forecast Flexibility: Modify forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe how your inputs affect the valuation of Associated Capital Group, Inc. (AC).
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Associated Capital Group, Inc. (AC).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs specific to AC.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit your analysis needs.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios pertinent to Associated Capital Group, Inc. (AC).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for streamlined analysis.
How It Works
- Download: Obtain the pre-configured Excel file containing Associated Capital Group, Inc. (AC)'s financial data.
- Customize: Modify projections such as revenue growth, EBITDA %, and WACC to fit your analysis.
- Update Automatically: Watch as intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various forecasts and instantly compare their results.
- Make Decisions: Leverage the valuation outputs to inform your investment choices.
Why Choose This Calculator for Associated Capital Group, Inc. (AC)?
- Designed for Experts: A sophisticated tool favored by financial analysts, CFOs, and industry consultants.
- Accurate Financial Data: Associated Capital Group’s historical and projected financials are preloaded for precise calculations.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Instantly calculates intrinsic value, NPV, and essential financial metrics.
- User-Friendly Interface: Step-by-step guidance ensures a smooth experience throughout the process.
Who Should Use Associated Capital Group, Inc. (AC)?
- Investors: Gain insights and make informed decisions with our expert investment strategies.
- Financial Analysts: Streamline your analysis process with our comprehensive financial tools and resources.
- Consultants: Effortlessly tailor our solutions for impactful client presentations and reports.
- Finance Enthusiasts: Enhance your knowledge of investment strategies and market trends with our educational materials.
- Educators and Students: Utilize our resources as a hands-on learning tool in finance and investment courses.
What the Template Contains
- Preloaded AC Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.