Oppenheimer Holdings Inc. (OPY) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Oppenheimer Holdings Inc. (OPY) Bundle
Looking to assess Oppenheimer Holdings Inc.'s intrinsic value? Our (OPY) DCF Calculator integrates real-world data with extensive customization features, allowing you to refine your forecasts and make more informed investment choices.
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 | 1,033.4 | 1,198.7 | 1,394.0 | 1,110.9 | 1,248.8 | 1,325.0 | 1,405.8 | 1,491.6 | 1,582.5 | 1,679.1 |
| Revenue Growth, % | 0 | 15.99 | 16.3 | -20.31 | 12.41 | 6.1 | 6.1 | 6.1 | 6.1 | 6.1 |
| EBITDA | 120.6 | 184.7 | 234.5 | 69.4 | 152.6 | 165.3 | 175.3 | 186.0 | 197.4 | 209.4 |
| EBITDA, % | 11.67 | 15.41 | 16.82 | 6.25 | 12.22 | 12.47 | 12.47 | 12.47 | 12.47 | 12.47 |
| Depreciation | 912.8 | 1,013.9 | 1,159.6 | 1,041.6 | 37.2 | 935.0 | 992.0 | 1,052.5 | 1,116.7 | 1,184.8 |
| Depreciation, % | 88.33 | 84.59 | 83.18 | 93.76 | 2.98 | 70.57 | 70.57 | 70.57 | 70.57 | 70.57 |
| EBIT | -792.2 | -829.2 | -925.1 | -972.2 | 115.4 | -769.7 | -816.7 | -866.5 | -919.3 | -975.4 |
| EBIT, % | -76.66 | -69.18 | -66.36 | -87.51 | 9.24 | -58.09 | -58.09 | -58.09 | -58.09 | -58.09 |
| Total Cash | 79.6 | 35.4 | 213.8 | 112.4 | 28.8 | 101.8 | 108.0 | 114.6 | 121.6 | 129.0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 1,009.1 | 1,360.5 | 1,445.3 | 1,466.3 | 1,414.4 | 1,318.8 | 1,399.2 | 1,484.5 | 1,575.1 | 1,671.2 |
| Account Receivables, % | 97.65 | 113.5 | 103.68 | 131.99 | 113.26 | 99.53 | 99.53 | 99.53 | 99.53 | 99.53 |
| Inventories | 1,137.0 | .0 | 1,981.6 | .0 | .0 | 530.0 | 562.3 | 596.6 | 633.0 | 671.6 |
| Inventories, % | 110.03 | 0 | 142.15 | 0 | 0 | 40 | 40 | 40 | 40 | 40 |
| Accounts Payable | 44.7 | 44.8 | 76.7 | 102.2 | 82.8 | 77.9 | 82.6 | 87.7 | 93.0 | 98.7 |
| Accounts Payable, % | 4.33 | 3.74 | 5.5 | 9.2 | 6.63 | 5.88 | 5.88 | 5.88 | 5.88 | 5.88 |
| Capital Expenditure | -10.0 | -4.5 | -8.3 | -16.3 | -17.1 | -12.7 | -13.4 | -14.2 | -15.1 | -16.0 |
| Capital Expenditure, % | -0.97002 | -0.37775 | -0.5931 | -1.47 | -1.37 | -0.95497 | -0.95497 | -0.95497 | -0.95497 | -0.95497 |
| Tax Rate, % | 35.47 | 35.47 | 35.47 | 35.47 | 35.47 | 35.47 | 35.47 | 35.47 | 35.47 | 35.47 |
| EBITAT | -560.0 | -603.5 | -654.6 | -690.4 | 74.4 | -538.5 | -571.3 | -606.1 | -643.1 | -682.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -1,758.6 | 1,191.6 | -1,537.9 | 2,321.0 | 127.1 | -55.4 | 299.3 | 317.5 | 336.9 | 357.5 |
| WACC, % | 9.05 | 9.16 | 9.06 | 9.07 | 8.74 | 9.02 | 9.02 | 9.02 | 9.02 | 9.02 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 916.9 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 365 | |||||||||
| Terminal Value | 5,197 | |||||||||
| Present Terminal Value | 3,376 | |||||||||
| Enterprise Value | 4,292 | |||||||||
| Net Debt | 565 | |||||||||
| Equity Value | 3,728 | |||||||||
| Diluted Shares Outstanding, MM | 12 | |||||||||
| Equity Value Per Share | 320.09 |
What You Will Receive
- Pre-Filled Financial Model: Oppenheimer Holdings Inc.'s actual data facilitates accurate DCF valuation.
- Comprehensive Forecast Control: Modify revenue growth, profit margins, WACC, and other essential factors.
- Real-Time Calculations: Automatic updates provide immediate feedback as adjustments are made.
- Investor-Ready Template: A polished Excel file crafted for high-quality valuation presentations.
- Customizable and Reusable: Designed for adaptability, allowing for repeated application in detailed forecasts.
Key Features
- Comprehensive Data: Oppenheimer Holdings Inc.'s (OPY) historical financial statements and detailed forecasts.
- Customizable Parameters: Adjust WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Calculations: View Oppenheimer's (OPY) intrinsic value update instantly.
- Intuitive Visualizations: Dashboard graphs illustrate valuation outcomes and essential metrics.
- Designed for Precision: A professional-grade tool for analysts, investors, and finance professionals.
How It Works
- Download the Template: Gain immediate access to the Excel-based Oppenheimer Holdings Inc. (OPY) DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates Oppenheimer’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Leverage the results to inform your investment or financial analysis.
Why Choose This Calculator for Oppenheimer Holdings Inc. (OPY)?
- Accurate Data: Utilize real Oppenheimer financials for dependable valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you from starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and financial consultants.
- User-Friendly: Easy-to-navigate design and clear instructions ensure accessibility for all users.
Who Should Use This Product?
- Investors: Evaluate Oppenheimer Holdings Inc. (OPY) for informed stock trading decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts.
- Startup Founders: Understand the valuation strategies of established firms like Oppenheimer Holdings Inc. (OPY).
- Consultants: Provide comprehensive valuation analyses for client projects.
- Students and Educators: Utilize current market data to enhance learning in valuation practices.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Oppenheimer Holdings Inc. (OPY) 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 displaying intrinsic value with comprehensive calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to facilitate thorough analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Oppenheimer Holdings Inc. (OPY).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to simplify the analysis of results.