|
Greenbrier Companies, Inc. (GBX) Valoración de DCF
US | Industrials | Railroads | 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
The Greenbrier Companies, Inc. (GBX) Bundle
¡Explore el potencial financiero de Greenbrier Companies, Inc. (GBX) con nuestra calculadora DCF fácil de usar! Ingrese sus proyecciones para el crecimiento, los márgenes y los gastos para calcular el valor intrínseco de Greenbrier Companies, Inc. (GBX) y dar forma a su enfoque de inversión.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 2,792.2 | 1,748.0 | 2,977.7 | 3,944.0 | 3,539.7 | 4,027.8 | 4,583.1 | 5,215.1 | 5,934.1 | 6,752.4 |
| Revenue Growth, % | 0 | -37.4 | 70.35 | 32.45 | -10.25 | 13.79 | 13.79 | 13.79 | 13.79 | 13.79 |
| EBITDA | 273.8 | 131.5 | 182.8 | 312.1 | 450.3 | 355.3 | 404.2 | 460.0 | 523.4 | 595.6 |
| EBITDA, % | 9.81 | 7.52 | 6.14 | 7.91 | 12.72 | 8.82 | 8.82 | 8.82 | 8.82 | 8.82 |
| Depreciation | 109.2 | 100.7 | 102.0 | 106.3 | 115.6 | 153.5 | 174.7 | 198.8 | 226.2 | 257.4 |
| Depreciation, % | 3.91 | 5.76 | 3.43 | 2.7 | 3.27 | 3.81 | 3.81 | 3.81 | 3.81 | 3.81 |
| EBIT | 164.6 | 30.7 | 80.8 | 205.8 | 334.7 | 201.7 | 229.5 | 261.2 | 297.2 | 338.2 |
| EBIT, % | 5.9 | 1.76 | 2.71 | 5.22 | 9.46 | 5.01 | 5.01 | 5.01 | 5.01 | 5.01 |
| Total Cash | 833.7 | 646.8 | 543.0 | 281.7 | 368.6 | 826.9 | 940.9 | 1,070.7 | 1,218.3 | 1,386.3 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 221.6 | 418.5 | 541.0 | 572.1 | 568.9 | 649.5 | 739.0 | 840.9 | 956.9 | 1,088.8 |
| Account Receivables, % | 7.94 | 23.94 | 18.17 | 14.51 | 16.07 | 16.12 | 16.12 | 16.12 | 16.12 | 16.12 |
| Inventories | 529.5 | 573.6 | 815.3 | 823.6 | 770.9 | 981.3 | 1,116.6 | 1,270.6 | 1,445.8 | 1,645.2 |
| Inventories, % | 18.96 | 32.81 | 27.38 | 20.88 | 21.78 | 24.36 | 24.36 | 24.36 | 24.36 | 24.36 |
| Accounts Payable | 149.0 | 265.1 | 401.5 | 396.8 | 370.7 | 439.2 | 499.7 | 568.6 | 647.0 | 736.3 |
| Accounts Payable, % | 5.34 | 15.17 | 13.48 | 10.06 | 10.47 | 10.9 | 10.9 | 10.9 | 10.9 | 10.9 |
| Capital Expenditure | -66.9 | -139.0 | -380.7 | -362.1 | -398.3 | -350.9 | -399.3 | -454.4 | -517.1 | -588.4 |
| Capital Expenditure, % | -2.4 | -7.95 | -12.79 | -9.18 | -11.25 | -8.71 | -8.71 | -8.71 | -8.71 | -8.71 |
| Tax Rate, % | 28.43 | 28.43 | 28.43 | 28.43 | 28.43 | 28.43 | 28.43 | 28.43 | 28.43 | 28.43 |
| EBITAT | 111.6 | -116.1 | 62.5 | 141.3 | 239.5 | 115.2 | 131.0 | 149.1 | 169.7 | 193.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -448.2 | -279.2 | -444.0 | -158.6 | -13.4 | -304.8 | -257.9 | -293.5 | -333.9 | -380.0 |
| WACC, % | 7.66 | 5.99 | 7.89 | 7.68 | 7.75 | 7.39 | 7.39 | 7.39 | 7.39 | 7.39 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -1,261.4 | |||||||||
| Long Term Growth Rate, % | 3.50 | |||||||||
| Free cash flow (T + 1) | -393 | |||||||||
| Terminal Value | -10,103 | |||||||||
| Present Terminal Value | -7,073 | |||||||||
| Enterprise Value | -8,334 | |||||||||
| Net Debt | 1,470 | |||||||||
| Equity Value | -9,804 | |||||||||
| Diluted Shares Outstanding, MM | 32 | |||||||||
| Equity Value Per Share | -302.94 |
What You Will Get
- Real GBX Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed automatically.
- Scenario Analysis: Evaluate various scenarios to assess The Greenbrier Companies' future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- 🔍 Real-Life GBX Financials: Pre-filled historical and projected data for The Greenbrier Companies, Inc.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate The Greenbrier Companies' intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize The Greenbrier Companies' valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- 1. Access the Template: Download and open the Excel file containing The Greenbrier Companies, Inc. (GBX) preloaded data.
- 2. Adjust Assumptions: Modify key inputs such as growth rates, WACC, and capital expenditures.
- 3. Analyze Results Instantly: The DCF model automatically calculates intrinsic value and NPV.
- 4. Explore Scenarios: Evaluate multiple forecasts to assess various valuation outcomes.
- 5. Present with Confidence: Deliver professional valuation insights to enhance your decision-making.
Why Choose This Calculator for The Greenbrier Companies, Inc. (GBX)?
- Comprehensive Tool: Incorporates DCF, WACC, and financial ratio analyses all in one solution.
- Customizable Inputs: Modify yellow-highlighted cells to explore different scenarios.
- Detailed Insights: Automatically computes The Greenbrier Companies' intrinsic value and Net Present Value.
- Preloaded Data: Historical and projected data provide reliable starting points for analysis.
- Professional Quality: Perfect for financial analysts, investors, and business consultants focusing on GBX.
Who Should Use The Greenbrier Companies, Inc. (GBX)?
- Investors: Make informed decisions with insights from a leading player in the railcar manufacturing industry.
- Financial Analysts: Streamline your analysis with comprehensive data on market trends and company performance.
- Consultants: Easily tailor information for client presentations or strategic reports on transportation solutions.
- Industry Enthusiasts: Enhance your knowledge of railcar production and logistics through real-world case studies.
- Educators and Students: Utilize it as a valuable resource in finance and business-related educational programs.
What the Template Contains
- Pre-Filled Data: Includes The Greenbrier Companies, Inc.'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 The Greenbrier Companies, Inc.'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.