|
Oxford Industries, Inc. (OXM) DCF Valoración
US | Consumer Cyclical | Apparel - Manufacturers | NYSE
|
- ✓ 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
Oxford Industries, Inc. (OXM) Bundle
¡Optimice su tiempo y mejore la precisión con nuestra calculadora DCF (OXM)! Equipado con datos actuales de Oxford Industries, Inc. y supuestos personalizables, esta herramienta le permite pronosticar, analizar y valor (OXM) al igual que un inversor experimentado.
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,122.8 | 748.8 | 1,142.1 | 1,411.5 | 1,571.5 | 1,784.1 | 2,025.6 | 2,299.7 | 2,611.0 | 2,964.3 |
| Revenue Growth, % | 0 | -33.31 | 52.51 | 23.59 | 11.33 | 13.53 | 13.53 | 13.53 | 13.53 | 13.53 |
| EBITDA | 136.3 | -83.8 | 205.4 | 266.4 | 145.0 | 167.9 | 190.6 | 216.4 | 245.7 | 278.9 |
| EBITDA, % | 12.14 | -11.19 | 17.99 | 18.87 | 9.23 | 9.41 | 9.41 | 9.41 | 9.41 | 9.41 |
| Depreciation | 40.3 | 40.1 | 39.9 | 47.6 | 64.1 | 71.0 | 80.6 | 91.5 | 103.9 | 117.9 |
| Depreciation, % | 3.59 | 5.35 | 3.5 | 3.37 | 4.08 | 3.98 | 3.98 | 3.98 | 3.98 | 3.98 |
| EBIT | 96.0 | -123.8 | 165.5 | 218.8 | 81.0 | 96.9 | 110.0 | 124.9 | 141.8 | 161.0 |
| EBIT, % | 8.55 | -16.54 | 14.49 | 15.5 | 5.15 | 5.43 | 5.43 | 5.43 | 5.43 | 5.43 |
| Total Cash | 52.5 | 66.0 | 209.7 | 8.8 | 7.6 | 117.6 | 133.5 | 151.6 | 172.1 | 195.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 58.7 | 48.4 | 54.3 | 63.4 | 82.9 | 93.5 | 106.2 | 120.6 | 136.9 | 155.4 |
| Account Receivables, % | 5.23 | 6.46 | 4.75 | 4.49 | 5.28 | 5.24 | 5.24 | 5.24 | 5.24 | 5.24 |
| Inventories | 152.2 | 123.5 | 117.7 | 220.1 | 159.6 | 235.9 | 267.8 | 304.1 | 345.2 | 392.0 |
| Inventories, % | 13.56 | 16.5 | 10.31 | 15.6 | 10.15 | 13.22 | 13.22 | 13.22 | 13.22 | 13.22 |
| Accounts Payable | 65.5 | 71.1 | 80.8 | 94.6 | 85.5 | 123.3 | 140.0 | 158.9 | 180.4 | 204.8 |
| Accounts Payable, % | 5.83 | 9.5 | 7.07 | 6.7 | 5.44 | 6.91 | 6.91 | 6.91 | 6.91 | 6.91 |
| Capital Expenditure | -37.4 | -28.9 | -31.9 | -46.7 | -74.1 | -64.3 | -73.0 | -82.8 | -94.0 | -106.8 |
| Capital Expenditure, % | -3.33 | -3.86 | -2.79 | -3.31 | -4.72 | -3.6 | -3.6 | -3.6 | -3.6 | -3.6 |
| Tax Rate, % | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19 |
| EBITAT | 71.2 | -94.2 | 132.1 | 168.1 | 65.6 | 75.1 | 85.3 | 96.9 | 110.0 | 124.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -71.4 | -38.3 | 149.7 | 71.3 | 87.6 | 32.6 | 65.0 | 73.8 | 83.8 | 95.2 |
| WACC, % | 9.93 | 9.95 | 9.98 | 9.95 | 9.99 | 9.96 | 9.96 | 9.96 | 9.96 | 9.96 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 255.5 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | 96 | |||||||||
| Terminal Value | 1,011 | |||||||||
| Present Terminal Value | 629 | |||||||||
| Enterprise Value | 884 | |||||||||
| Net Debt | 330 | |||||||||
| Equity Value | 554 | |||||||||
| Diluted Shares Outstanding, MM | 16 | |||||||||
| Equity Value Per Share | 34.84 |
What You Will Receive
- Comprehensive Financial Model: Utilize Oxford Industries' actual data for accurate DCF valuation.
- Complete Forecast Flexibility: Modify revenue growth, profit margins, WACC, and other essential parameters.
- Real-Time Calculations: Automatic updates provide immediate insights as you adjust inputs.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation presentations.
- Adaptable and Reusable: Designed for versatility, enabling repeated application for in-depth forecasts.
Key Features
- Comprehensive Historical Data: Oxford Industries, Inc.'s (OXM) past financial statements and comprehensive forecasts.
- Customizable Parameters: Adjust WACC, tax rates, revenue growth, and EBITDA margins to fit your analysis.
- Real-Time Valuation: Instantly view the recalculated intrinsic value of Oxford Industries, Inc. (OXM).
- Intuitive Visualizations: Engaging dashboard charts illustrate valuation results and essential metrics.
- Designed for Precision: A reliable tool tailored for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Oxford Industries, Inc. (OXM) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Oxford Industries, Inc. (OXM)'s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Oxford Industries, Inc. (OXM)?
- All-in-One Solution: Features DCF, WACC, and financial ratio evaluations consolidated in a single tool.
- Flexible Inputs: Modify the yellow-highlighted fields to explore different financial scenarios.
- In-Depth Analysis: Automatically computes Oxford Industries’ intrinsic value and Net Present Value.
- Data Ready: Comes with historical and projected data for precise calculations.
- High-Quality Output: Perfect for financial analysts, investors, and business advisors.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Oxford Industries, Inc. (OXM) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for Oxford Industries, Inc. (OXM).
- Consultants: Deliver professional valuation insights on Oxford Industries, Inc. (OXM) to clients quickly and accurately.
- Business Owners: Understand how companies like Oxford Industries, Inc. (OXM) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios involving Oxford Industries, Inc. (OXM).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Oxford Industries historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Oxford Industries, Inc. (OXM).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.