|
Old Dominion Freight Line, Inc. (ODFL) Valoración de DCF
US | Industrials | Trucking | 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
Old Dominion Freight Line, Inc. (ODFL) Bundle
¡Optimice su tiempo y mejore la precisión con nuestra calculadora DCF (ODFL)! Equipados con datos reales de Old Dominion Freight Line, Inc. y suposiciones personalizables, esta herramienta le permite pronosticar, analizar y evaluar (ODFL) al igual que un inversor profesional.
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 | 4,109.1 | 4,015.1 | 5,256.3 | 6,260.1 | 5,866.2 | 6,473.7 | 7,144.2 | 7,884.2 | 8,700.8 | 9,601.9 |
| Revenue Growth, % | 0 | -2.29 | 30.91 | 19.1 | -6.29 | 10.36 | 10.36 | 10.36 | 10.36 | 10.36 |
| EBITDA | 1,078.0 | 1,168.1 | 1,651.5 | 2,119.0 | 1,972.7 | 1,996.8 | 2,203.6 | 2,431.9 | 2,683.7 | 2,961.7 |
| EBITDA, % | 26.23 | 29.09 | 31.42 | 33.85 | 33.63 | 30.84 | 30.84 | 30.84 | 30.84 | 30.84 |
| Depreciation | 253.7 | 261.3 | 259.9 | 276.1 | 324.4 | 356.9 | 393.9 | 434.7 | 479.7 | 529.4 |
| Depreciation, % | 6.17 | 6.51 | 4.94 | 4.41 | 5.53 | 5.51 | 5.51 | 5.51 | 5.51 | 5.51 |
| EBIT | 824.3 | 906.9 | 1,391.6 | 1,842.9 | 1,648.2 | 1,639.9 | 1,809.8 | 1,997.2 | 2,204.1 | 2,432.3 |
| EBIT, % | 20.06 | 22.59 | 26.47 | 29.44 | 28.1 | 25.33 | 25.33 | 25.33 | 25.33 | 25.33 |
| Total Cash | 731.7 | 717.0 | 235.7 | 235.7 | 433.8 | 664.3 | 733.1 | 809.0 | 892.8 | 985.3 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 10.6 | 9.6 | 12.4 | 605.1 | 615.3 | 270.4 | 298.5 | 329.4 | 363.5 | 401.1 |
| Account Receivables, % | 0.25762 | 0.23832 | 0.2361 | 9.67 | 10.49 | 4.18 | 4.18 | 4.18 | 4.18 | 4.18 |
| Inventories | -454.2 | -599.1 | -605.1 | -605.1 | .0 | -610.5 | -673.8 | -743.5 | -820.6 | -905.5 |
| Inventories, % | -11.05 | -14.92 | -11.51 | -9.67 | 0 | -9.43 | -9.43 | -9.43 | -9.43 | -9.43 |
| Accounts Payable | 70.3 | 68.5 | 82.5 | 106.3 | 112.8 | 111.4 | 123.0 | 135.7 | 149.8 | 165.3 |
| Accounts Payable, % | 1.71 | 1.71 | 1.57 | 1.7 | 1.92 | 1.72 | 1.72 | 1.72 | 1.72 | 1.72 |
| Capital Expenditure | -479.3 | -225.1 | -550.1 | -775.1 | -757.3 | -686.6 | -757.7 | -836.2 | -922.8 | -1,018.3 |
| Capital Expenditure, % | -11.66 | -5.61 | -10.47 | -12.38 | -12.91 | -10.61 | -10.61 | -10.61 | -10.61 | -10.61 |
| Tax Rate, % | 24.78 | 24.78 | 24.78 | 24.78 | 24.78 | 24.78 | 24.78 | 24.78 | 24.78 | 24.78 |
| EBITAT | 615.8 | 676.8 | 1,036.7 | 1,378.3 | 1,239.9 | 1,226.1 | 1,353.1 | 1,493.3 | 1,648.0 | 1,818.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 904.0 | 857.1 | 763.8 | 310.3 | 198.2 | 1,850.5 | 1,036.1 | 1,143.4 | 1,261.8 | 1,392.5 |
| WACC, % | 9.09 | 9.09 | 9.09 | 9.09 | 9.09 | 9.09 | 9.09 | 9.09 | 9.09 | 9.09 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 5,240.1 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | 1,448 | |||||||||
| Terminal Value | 28,458 | |||||||||
| Present Terminal Value | 18,420 | |||||||||
| Enterprise Value | 23,661 | |||||||||
| Net Debt | -233 | |||||||||
| Equity Value | 23,894 | |||||||||
| Diluted Shares Outstanding, MM | 220 | |||||||||
| Equity Value Per Share | 108.52 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real ODFL financials.
- Real-World Data: Historical data and forward-looking estimates (as highlighted in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the effects of your inputs on Old Dominion Freight Line’s valuation.
- 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 Financial Data: Old Dominion Freight Line, Inc.'s (ODFL) historical financial reports and pre-filled projections.
- 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 Old Dominion Freight Line, Inc. (ODFL).
- Insightful Visualizations: Interactive dashboard charts present valuation outcomes and essential metrics.
- Designed for Precision: A reliable tool tailored for analysts, investors, and finance professionals.
How It Works
- 1. Download the Template: Get the Excel file containing Old Dominion Freight Line, Inc.'s (ODFL) preloaded data.
- 2. Adjust Key Inputs: Modify essential variables such as growth rates, WACC, and capital expenditures.
- 3. Instant Results: The DCF model automatically computes intrinsic value and NPV in real-time.
- 4. Explore Scenarios: Analyze various forecasts to evaluate different valuation scenarios.
- 5. Make Informed Decisions: Provide professional valuation insights to enhance your decision-making process.
Why Choose Old Dominion Freight Line, Inc. (ODFL)?
- Save Time: Instantly access comprehensive freight solutions without the hassle of setup.
- Enhance Reliability: Dependable logistics data ensures accuracy in shipping and delivery.
- Fully Adaptable: Customize services to meet your unique shipping needs and requirements.
- User-Friendly Interface: Intuitive tools and resources simplify the shipping process.
- Preferred by Professionals: Trusted by industry leaders for efficiency and effectiveness in freight management.
Who Should Use This Product?
- Logistics Professionals: Develop comprehensive and accurate logistics models for operational analysis.
- Corporate Finance Teams: Evaluate financial scenarios to inform strategic decisions within the company.
- Consultants and Advisors: Offer clients precise valuation insights for Old Dominion Freight Line, Inc. (ODFL) stock.
- Students and Educators: Utilize real-world case studies to learn and teach transportation finance concepts.
- Industry Analysts: Gain insights into how freight and logistics companies like Old Dominion are assessed in the market.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Old Dominion Freight Line, Inc. (ODFL) 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 Old Dominion Freight Line, Inc. (ODFL).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.