Cohen & Company Inc. (COHN) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Cohen & Company Inc. (COHN) Bundle
Streamline Cohen & Company Inc. (COHN) valuation with this customizable DCF Calculator! Equipped with accurate Cohen & Company Inc. (COHN) financials and flexible forecast inputs, you can explore scenarios and reveal Cohen & Company Inc. (COHN) fair value in just 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 | 49.7 | 130.1 | 146.4 | 44.4 | 83.0 | 109.9 | 145.6 | 192.8 | 255.3 | 338.2 |
| Revenue Growth, % | 0 | 161.97 | 12.5 | -69.67 | 86.95 | 32.44 | 32.44 | 32.44 | 32.44 | 32.44 |
| EBITDA | 172.5 | 116.7 | 80.4 | -58.3 | 23.0 | 37.9 | 50.2 | 66.5 | 88.1 | 116.6 |
| EBITDA, % | 347.28 | 89.73 | 54.95 | -131.35 | 27.76 | 34.49 | 34.49 | 34.49 | 34.49 | 34.49 |
| Depreciation | 39.1 | 73.8 | 63.8 | 93.8 | .6 | 61.5 | 81.4 | 107.8 | 142.8 | 189.2 |
| Depreciation, % | 78.72 | 56.74 | 43.56 | 211.38 | 0.67847 | 55.94 | 55.94 | 55.94 | 55.94 | 55.94 |
| EBIT | 133.4 | 42.9 | 16.7 | -152.1 | 22.5 | 15.7 | 20.8 | 27.6 | 36.5 | 48.3 |
| EBIT, % | 268.55 | 32.99 | 11.39 | -342.73 | 27.08 | 14.29 | 14.29 | 14.29 | 14.29 | 14.29 |
| Total Cash | 316.2 | 285.0 | 274.4 | 240.9 | 10.7 | 90.7 | 120.2 | 159.2 | 210.8 | 279.2 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 7,643.9 | 5,776.4 | 3,251.0 | 592.9 | 490.6 | 109.9 | 145.6 | 192.8 | 255.3 | 338.2 |
| Account Receivables, % | 15390.57 | 4439.63 | 2221.14 | 1335.72 | 591.27 | 100 | 100 | 100 | 100 | 100 |
| Inventories | -307.0 | -242.9 | -223.7 | -6.3 | .0 | -69.1 | -91.5 | -121.2 | -160.5 | -212.5 |
| Inventories, % | -618.15 | -186.68 | -152.83 | -14.25 | 0 | -62.85 | -62.85 | -62.85 | -62.85 | -62.85 |
| Accounts Payable | .4 | .2 | .1 | 4.1 | 1.2 | 2.6 | 3.4 | 4.5 | 6.0 | 7.9 |
| Accounts Payable, % | 0.72887 | 0.12451 | 0.08335155 | 9.3 | 1.42 | 2.33 | 2.33 | 2.33 | 2.33 | 2.33 |
| Capital Expenditure | -.1 | -.2 | -1.0 | -.6 | -.4 | -.6 | -.8 | -1.1 | -1.4 | -1.9 |
| Capital Expenditure, % | -0.20336 | -0.16678 | -0.70234 | -1.29 | -0.4495 | -0.56258 | -0.56258 | -0.56258 | -0.56258 | -0.56258 |
| Tax Rate, % | 132.07 | 132.07 | 132.07 | 132.07 | 132.07 | 132.07 | 132.07 | 132.07 | 132.07 | 132.07 |
| EBITAT | 116.3 | 55.4 | 17.1 | -165.7 | -7.2 | 12.2 | 16.1 | 21.3 | 28.3 | 37.4 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -7,181.2 | 1,932.2 | 2,585.9 | 2,372.4 | 85.9 | 524.2 | 84.3 | 111.7 | 147.9 | 195.9 |
| WACC, % | 4.09 | 4.64 | 4.64 | 4.64 | 0.33559 | 3.67 | 3.67 | 3.67 | 3.67 | 3.67 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 976.0 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 200 | |||||||||
| Terminal Value | 11,983 | |||||||||
| Present Terminal Value | 10,009 | |||||||||
| Enterprise Value | 10,984 | |||||||||
| Net Debt | 443 | |||||||||
| Equity Value | 10,541 | |||||||||
| Diluted Shares Outstanding, MM | 2 | |||||||||
| Equity Value Per Share | 6,964.87 |
What You Will Get
- Real COHN Financial Data: Pre-filled with Cohen & Company Inc.’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Cohen & Company Inc.’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- 🔍 Real-Life COHN Financials: Pre-filled historical and projected data for Cohen & Company Inc.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Cohen’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Cohen’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download the Template: Gain immediate access to the Excel-based COHN DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates Cohen & Company Inc.'s intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis.
Why Choose Cohen & Company Inc. (COHN)?
- Save Time: Access pre-built financial models without the hassle of starting from scratch.
- Enhance Accuracy: Utilize trusted financial data and formulas to minimize valuation errors.
- Completely Customizable: Adjust the models 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 both precision and functionality.
Who Should Use This Product?
- Investors: Accurately assess the fair value of Cohen & Company Inc. (COHN) prior to making investment choices.
- CFOs: Utilize a high-quality DCF model for thorough financial reporting and analysis.
- Consultants: Efficiently customize the template for client valuation reports.
- Entrepreneurs: Acquire knowledge on financial modeling practices employed by leading firms.
- Educators: Implement it as a resource to illustrate valuation techniques in the classroom.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Cohen & Company Inc. (COHN) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), featuring parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models illustrating intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis for Cohen & Company Inc. (COHN).
- Key Ratios: Includes profitability, leverage, and efficiency ratios specific to Cohen & Company Inc. (COHN).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to facilitate easy analysis of results.