|
Valoración DCF de la Corporación ODP (ODP)
US | Consumer Cyclical | Specialty Retail | NASDAQ
|
- ✓ 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
The ODP Corporation (ODP) Bundle
Como inversor o analista, esta calculadora DCF (ODP) sirve como su recurso esencial para una valoración precisa. Cargados con datos reales de la Corporación ODP, puede ajustar fácilmente los pronósticos y observar los resultados en tiempo real.
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 | 10,647.0 | 9,710.0 | 8,465.0 | 8,491.0 | 7,831.0 | 7,261.5 | 6,733.5 | 6,243.8 | 5,789.7 | 5,368.7 |
| Revenue Growth, % | 0 | -8.8 | -12.82 | 0.30715 | -7.77 | -7.27 | -7.27 | -7.27 | -7.27 | -7.27 |
| EBITDA | 439.0 | 161.0 | 405.0 | 389.0 | 335.0 | 282.1 | 261.6 | 242.6 | 224.9 | 208.6 |
| EBITDA, % | 4.12 | 1.66 | 4.78 | 4.58 | 4.28 | 3.88 | 3.88 | 3.88 | 3.88 | 3.88 |
| Depreciation | 204.0 | 157.0 | 146.0 | 131.0 | 115.0 | 120.1 | 111.4 | 103.3 | 95.8 | 88.8 |
| Depreciation, % | 1.92 | 1.62 | 1.72 | 1.54 | 1.47 | 1.65 | 1.65 | 1.65 | 1.65 | 1.65 |
| EBIT | 235.0 | 4.0 | 259.0 | 258.0 | 220.0 | 162.0 | 150.2 | 139.3 | 129.2 | 119.8 |
| EBIT, % | 2.21 | 0.04119464 | 3.06 | 3.04 | 2.81 | 2.23 | 2.23 | 2.23 | 2.23 | 2.23 |
| Total Cash | 698.0 | 729.0 | 514.0 | 403.0 | 392.0 | 434.1 | 402.5 | 373.2 | 346.1 | 320.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 1,665.0 | 442.0 | 495.0 | 536.0 | 491.0 | 560.9 | 520.1 | 482.3 | 447.2 | 414.7 |
| Account Receivables, % | 15.64 | 4.55 | 5.85 | 6.31 | 6.27 | 7.72 | 7.72 | 7.72 | 7.72 | 7.72 |
| Inventories | 1,032.0 | 930.0 | 859.0 | 828.0 | 765.0 | 710.7 | 659.1 | 611.1 | 566.7 | 525.5 |
| Inventories, % | 9.69 | 9.58 | 10.15 | 9.75 | 9.77 | 9.79 | 9.79 | 9.79 | 9.79 | 9.79 |
| Accounts Payable | 1,026.0 | 857.0 | 950.0 | 821.0 | 755.0 | 711.6 | 659.8 | 611.8 | 567.3 | 526.1 |
| Accounts Payable, % | 9.64 | 8.83 | 11.22 | 9.67 | 9.64 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 |
| Capital Expenditure | -150.0 | -68.0 | -73.0 | -99.0 | -105.0 | -79.6 | -73.8 | -68.4 | -63.4 | -58.8 |
| Capital Expenditure, % | -1.41 | -0.70031 | -0.86237 | -1.17 | -1.34 | -1.1 | -1.1 | -1.1 | -1.1 | -1.1 |
| Tax Rate, % | 30.5 | 30.5 | 30.5 | 30.5 | 30.5 | 30.5 | 30.5 | 30.5 | 30.5 | 30.5 |
| EBITAT | 159.3 | 4.3 | 209.7 | 177.0 | 152.9 | 125.4 | 116.2 | 107.8 | 99.9 | 92.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -1,457.7 | 1,249.3 | 393.7 | 70.0 | 204.9 | 106.8 | 194.5 | 180.4 | 167.3 | 155.1 |
| WACC, % | 7.14 | 7.88 | 7.44 | 7.16 | 7.18 | 7.36 | 7.36 | 7.36 | 7.36 | 7.36 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 648.7 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | 160 | |||||||||
| Terminal Value | 3,663 | |||||||||
| Present Terminal Value | 2,568 | |||||||||
| Enterprise Value | 3,217 | |||||||||
| Net Debt | 571 | |||||||||
| Equity Value | 2,646 | |||||||||
| Diluted Shares Outstanding, MM | 40 | |||||||||
| Equity Value Per Share | 66.14 |
What You Will Get
- Real ODP Financial Data: Pre-filled with The ODP Corporation’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 The ODP Corporation’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 ODP Financials: Pre-filled historical and projected data for The ODP Corporation (ODP).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) such as WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate The ODP Corporation’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize The ODP Corporation’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Functions
- Download the Template: Gain immediate access to the Excel-based ODP DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional parameters.
- Instant Calculations: The model automatically refreshes ODP’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis.
Why Choose This Calculator for The ODP Corporation (ODP)?
- Accuracy: Utilizes verified ODP financials for precise data representation.
- Flexibility: Allows users to freely test and adjust inputs as needed.
- Time-Saving: Avoid the complexity of constructing a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling skills.
Who Should Use This Product?
- Investors: Evaluate The ODP Corporation's (ODP) market position before making investment decisions.
- CFOs and Financial Analysts: Enhance valuation methodologies and assess financial forecasts for The ODP Corporation.
- Startup Founders: Understand the valuation strategies of established companies like The ODP Corporation.
- Consultants: Create comprehensive valuation reports tailored for clients interested in The ODP Corporation.
- Students and Educators: Utilize real-time data from The ODP Corporation to learn and teach valuation principles.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled ODP Corporation 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 ODP Corporation (ODP).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.