|
GXO Logistics, Inc. (GXO) Valoración de DCF
US | Industrials | Integrated Freight & Logistics | 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
GXO Logistics, Inc. (GXO) Bundle
¡Aumente la eficiencia y mejore la precisión con nuestra calculadora DCF (GXO)! Utilizando datos reales de GXO Logistics, Inc. y suposiciones personalizables, esta herramienta le permite pronosticar, analizar y valorar GXO como 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 | 6,094.0 | 6,195.0 | 7,940.0 | 8,993.0 | 9,778.0 | 11,044.6 | 12,475.4 | 14,091.4 | 15,916.9 | 17,978.7 |
Revenue Growth, % | 0 | 1.66 | 28.17 | 13.26 | 8.73 | 12.95 | 12.95 | 12.95 | 12.95 | 12.95 |
EBITDA | 468.0 | 415.0 | 589.0 | 697.0 | 680.0 | 806.3 | 910.7 | 1,028.7 | 1,162.0 | 1,312.5 |
EBITDA, % | 7.68 | 6.7 | 7.42 | 7.75 | 6.95 | 7.3 | 7.3 | 7.3 | 7.3 | 7.3 |
Depreciation | 302.0 | 323.0 | 335.0 | 329.0 | 361.0 | 480.2 | 542.4 | 612.7 | 692.0 | 781.7 |
Depreciation, % | 4.96 | 5.21 | 4.22 | 3.66 | 3.69 | 4.35 | 4.35 | 4.35 | 4.35 | 4.35 |
EBIT | 166.0 | 92.0 | 254.0 | 368.0 | 319.0 | 326.1 | 368.3 | 416.1 | 469.9 | 530.8 |
EBIT, % | 2.72 | 1.49 | 3.2 | 4.09 | 3.26 | 2.95 | 2.95 | 2.95 | 2.95 | 2.95 |
Total Cash | 200.0 | 328.0 | 333.0 | 495.0 | 468.0 | 509.4 | 575.4 | 649.9 | 734.1 | 829.2 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 1,069.0 | 1,224.0 | 1,507.0 | 1,647.0 | 1,774.0 | 2,048.5 | 2,313.8 | 2,613.6 | 2,952.1 | 3,334.6 |
Account Receivables, % | 17.54 | 19.76 | 18.98 | 18.31 | 18.14 | 18.55 | 18.55 | 18.55 | 18.55 | 18.55 |
Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Inventories, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Accounts Payable | 413.0 | 415.0 | 624.0 | 717.0 | 709.0 | 807.6 | 912.2 | 1,030.3 | 1,163.8 | 1,314.6 |
Accounts Payable, % | 6.78 | 6.7 | 7.86 | 7.97 | 7.25 | 7.31 | 7.31 | 7.31 | 7.31 | 7.31 |
Capital Expenditure | -222.0 | -222.0 | -250.0 | -342.0 | -274.0 | -375.1 | -423.7 | -478.6 | -540.5 | -610.6 |
Capital Expenditure, % | -3.64 | -3.58 | -3.15 | -3.8 | -2.8 | -3.4 | -3.4 | -3.4 | -3.4 | -3.4 |
Tax Rate, % | 13.91 | 13.91 | 13.91 | 13.91 | 13.91 | 13.91 | 13.91 | 13.91 | 13.91 | 13.91 |
EBITAT | 113.9 | 337.3 | 254.0 | 274.6 | 274.6 | 280.0 | 316.3 | 357.3 | 403.5 | 455.8 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -462.1 | 285.3 | 265.0 | 214.6 | 226.6 | 209.2 | 274.3 | 309.8 | 349.9 | 395.3 |
WACC, % | 8.13 | 8.75 | 8.75 | 8.25 | 8.48 | 8.47 | 8.47 | 8.47 | 8.47 | 8.47 |
PV UFCF | ||||||||||
SUM PV UFCF | 1,184.7 | |||||||||
Long Term Growth Rate, % | 3.50 | |||||||||
Free cash flow (T + 1) | 409 | |||||||||
Terminal Value | 8,230 | |||||||||
Present Terminal Value | 5,481 | |||||||||
Enterprise Value | 6,665 | |||||||||
Net Debt | 3,618 | |||||||||
Equity Value | 3,047 | |||||||||
Diluted Shares Outstanding, MM | 119 | |||||||||
Equity Value Per Share | 25.50 |
What You Will Get
- Real GXO Financial Data: Pre-filled with GXO Logistics’ historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See GXO’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
- Comprehensive GXO Financials: Gain access to precise historical data and future forecasts tailored for GXO Logistics, Inc. (GXO).
- Adjustable Forecast Parameters: Modify highlighted cells for key metrics such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Instant updates for DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Clear and concise charts and summaries to effectively visualize your valuation outcomes.
- Designed for All Levels: An intuitive layout suitable for investors, CFOs, and consultants, whether experienced or new to the field.
How It Works
- Download: Obtain the comprehensive Excel file featuring GXO Logistics, Inc. (GXO) financial data.
- Customize: Modify projections, including revenue growth, EBITDA %, and WACC to suit your analysis.
- Update Automatically: Watch as the intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various forecasts and evaluate outcomes instantly.
- Make Decisions: Leverage the valuation insights to inform your investment choices.
Why Choose This Calculator for GXO Logistics, Inc. (GXO)?
- Accurate Data: Access to real GXO financials guarantees dependable valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Built-in calculations remove the hassle of starting from the beginning.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the logistics sector.
- User-Friendly: Easy-to-navigate design and clear instructions simplify usage for everyone.
Who Should Use This Product?
- Investors: Assess GXO’s valuation before making stock transactions.
- CFOs and Financial Analysts: Enhance valuation methodologies and evaluate forecasts.
- Startup Founders: Understand how leading logistics companies like GXO are valued.
- Consultants: Provide expert valuation reports for clients in the logistics sector.
- Students and Educators: Utilize real-world data to practice and teach valuation strategies.
What the Template Contains
- Pre-Filled Data: Includes GXO Logistics, Inc. (GXO)'s historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze GXO Logistics, Inc. (GXO)'s profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.