|
The Greenbrier Companies, Inc. (GBX) DCF Valuation
US | Industrials | Railroads | NYSE
|
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
The Greenbrier Companies, Inc. (GBX) Bundle
Explore The Greenbrier Companies, Inc. (GBX) financial potential with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to calculate The Greenbrier Companies, Inc. (GBX) intrinsic value and shape your investment approach.
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.