GATX Corporation (GATX) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
GATX Corporation (GATX) Bundle
As an investor or analyst, the GATX Corporation (GATX) DCF Calculator is your go-to resource for accurate valuation. Loaded with real data from GATX Corporation, you can adjust forecasts and observe the effects in real-time.
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 | 1,202.1 | 1,209.2 | 1,257.4 | 1,273.0 | 1,410.9 | 1,469.6 | 1,530.8 | 1,594.5 | 1,660.9 | 1,730.0 |
| Revenue Growth, % | 0 | 0.59063 | 3.99 | 1.24 | 10.83 | 4.16 | 4.16 | 4.16 | 4.16 | 4.16 |
| EBITDA | 659.7 | 657.8 | 776.3 | 701.4 | 916.2 | 855.5 | 891.1 | 928.2 | 966.8 | 1,007.1 |
| EBITDA, % | 54.88 | 54.4 | 61.74 | 55.1 | 64.94 | 58.21 | 58.21 | 58.21 | 58.21 | 58.21 |
| Depreciation | 332.7 | 342.8 | 378.4 | 371.3 | 392.1 | 420.5 | 438.0 | 456.3 | 475.3 | 495.1 |
| Depreciation, % | 27.68 | 28.35 | 30.09 | 29.17 | 27.79 | 28.62 | 28.62 | 28.62 | 28.62 | 28.62 |
| EBIT | 327.0 | 315.0 | 397.9 | 330.1 | 524.1 | 434.9 | 453.0 | 471.9 | 491.5 | 512.0 |
| EBIT, % | 27.2 | 26.05 | 31.64 | 25.93 | 37.15 | 29.59 | 29.59 | 29.59 | 29.59 | 29.59 |
| Total Cash | 151.0 | 292.2 | 344.3 | 452.2 | 450.7 | 386.7 | 402.8 | 419.6 | 437.1 | 455.3 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 150.0 | 142.2 | 163.8 | 162.0 | 218.4 | 192.4 | 200.4 | 208.8 | 217.5 | 226.5 |
| Account Receivables, % | 12.48 | 11.76 | 13.03 | 12.73 | 15.48 | 13.09 | 13.09 | 13.09 | 13.09 | 13.09 |
| Inventories | 59.4 | 64.3 | 52.0 | 60.2 | 74.0 | 71.6 | 74.6 | 77.7 | 80.9 | 84.3 |
| Inventories, % | 4.94 | 5.32 | 4.14 | 4.73 | 5.24 | 4.87 | 4.87 | 4.87 | 4.87 | 4.87 |
| Accounts Payable | 119.4 | 147.3 | 215.8 | 202.2 | 239.6 | 212.0 | 220.9 | 230.1 | 239.6 | 249.6 |
| Accounts Payable, % | 9.93 | 12.18 | 17.16 | 15.88 | 16.98 | 14.43 | 14.43 | 14.43 | 14.43 | 14.43 |
| Capital Expenditure | -723.8 | -860.8 | -1,130.1 | -1,255.8 | -1,665.0 | -1,234.3 | -1,285.6 | -1,339.2 | -1,394.9 | -1,453.0 |
| Capital Expenditure, % | -60.21 | -71.19 | -89.88 | -98.65 | -118.01 | -83.98 | -83.98 | -83.98 | -83.98 | -83.98 |
| Tax Rate, % | -5.58 | -5.58 | -5.58 | -5.58 | -5.58 | -5.58 | -5.58 | -5.58 | -5.58 | -5.58 |
| EBITAT | 234.9 | 221.2 | 291.8 | 228.0 | 553.3 | 334.4 | 348.4 | 362.9 | 378.0 | 393.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -246.2 | -266.0 | -400.7 | -676.5 | -752.4 | -478.5 | -501.4 | -522.3 | -544.0 | -566.7 |
| WACC, % | 5.63 | 5.59 | 5.67 | 5.56 | 6.36 | 5.76 | 5.76 | 5.76 | 5.76 | 5.76 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -2,205.2 | |||||||||
| Long Term Growth Rate, % | 3.90 | |||||||||
| Free cash flow (T + 1) | -589 | |||||||||
| Terminal Value | -31,632 | |||||||||
| Present Terminal Value | -23,905 | |||||||||
| Enterprise Value | -26,111 | |||||||||
| Net Debt | 7,175 | |||||||||
| Equity Value | -33,286 | |||||||||
| Diluted Shares Outstanding, MM | 36 | |||||||||
| Equity Value Per Share | -932.37 |
What You Will Receive
- Customizable Excel Template: A fully editable Excel-based DCF Calculator featuring pre-loaded real GATX financials.
- Authentic Data: Access to historical figures and forward-looking projections (highlighted in the yellow cells).
- Adjustable Forecasts: Modify key assumptions such as revenue growth, EBITDA margin, and WACC.
- Instant Calculations: Quickly observe how your inputs affect GATX’s valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- Intuitive Layout: Organized for clarity and simplicity, complete with step-by-step guidance.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for GATX Corporation (GATX).
- WACC Calculator: Pre-designed Weighted Average Cost of Capital sheet with adjustable inputs specific to GATX Corporation (GATX).
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit GATX Corporation (GATX) projections.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios pertinent to GATX Corporation (GATX).
- Interactive Dashboard and Charts: Visual representations summarize crucial valuation metrics for straightforward analysis of GATX Corporation (GATX).
How It Works
- 1. Access the Template: Download and open the Excel file containing GATX Corporation’s preloaded financial data.
- 2. Adjust Key Inputs: Modify essential parameters such as revenue growth, discount rate, and capital expenditures.
- 3. Instant Results: The DCF model automatically computes intrinsic value and net present value (NPV).
- 4. Explore Different Scenarios: Analyze various projections to evaluate different valuation scenarios.
- 5. Present with Assurance: Deliver professional valuation analyses to enhance your decision-making process.
Why Choose This Calculator for GATX Corporation (GATX)?
- User-Friendly Interface: Tailored for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters easily to suit your financial analysis.
- Real-Time Adjustments: Observe immediate updates to GATX’s valuation as you change inputs.
- Preloaded Financial Data: Comes equipped with GATX’s actual financial metrics for swift evaluations.
- Relied Upon by Experts: Favored by investors and analysts for making strategic decisions.
Who Should Use GATX Corporation (GATX)?
- Investors: Make informed investment choices with reliable data from GATX's financial insights.
- Financial Analysts: Streamline your analysis with GATX's comprehensive reports and metrics.
- Consultants: Easily incorporate GATX's findings into client strategies and presentations.
- Finance Enthusiasts: Enhance your knowledge of the transportation and logistics sector through GATX's performance analysis.
- Educators and Students: Utilize GATX's resources as a case study in finance and business courses.
What the GATX Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations for GATX Corporation (GATX).
- Real-World Data: GATX's historical and projected financials preloaded for thorough analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to evaluate different scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into GATX's performance.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage specific to GATX Corporation (GATX).
- Dashboard with Visual Outputs: Charts and tables providing clear, actionable results for decision-making.