|
Air Transport Services Group, Inc. (ATSG) DCF Valoración de DCF
US | Industrials | Airlines, Airports & Air Services | 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
Air Transport Services Group, Inc. (ATSG) Bundle
Como inversor o analista, esta calculadora DCF (ATSG) es su recurso de referencia para una valoración precisa. Cargados con datos reales de Air Transport Services Group, Inc., puede ajustar fácilmente sus pronósticos y observar los efectos en tiempo real.
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,570.6 | 1,734.3 | 2,045.5 | 2,045.5 | 2,070.6 | 2,273.3 | 2,495.7 | 2,740.0 | 3,008.1 | 3,302.5 |
| Revenue Growth, % | 0 | 10.42 | 17.94 | 0 | 1.23 | 9.79 | 9.79 | 9.79 | 9.79 | 9.79 |
| EBITDA | 395.7 | 382.4 | 674.9 | 638.4 | 507.7 | 618.2 | 678.7 | 745.1 | 818.0 | 898.1 |
| EBITDA, % | 25.2 | 22.05 | 33 | 31.21 | 24.52 | 27.19 | 27.19 | 27.19 | 27.19 | 27.19 |
| Depreciation | 257.5 | 278.1 | 308.4 | 331.1 | 343.0 | 364.9 | 400.6 | 439.8 | 482.9 | 530.1 |
| Depreciation, % | 16.4 | 16.03 | 15.08 | 16.19 | 16.56 | 16.05 | 16.05 | 16.05 | 16.05 | 16.05 |
| EBIT | 138.2 | 104.3 | 366.5 | 307.4 | 164.7 | 253.3 | 278.1 | 305.3 | 335.2 | 368.0 |
| EBIT, % | 8.8 | 6.01 | 17.92 | 15.03 | 7.95 | 11.14 | 11.14 | 11.14 | 11.14 | 11.14 |
| Total Cash | 39.7 | 69.5 | 27.1 | 27.1 | 53.6 | 53.5 | 58.8 | 64.5 | 70.8 | 77.8 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 162.9 | 153.5 | 205.4 | 301.6 | 215.6 | 247.4 | 271.6 | 298.2 | 327.4 | 359.4 |
| Account Receivables, % | 10.37 | 8.85 | 10.04 | 14.75 | 10.41 | 10.88 | 10.88 | 10.88 | 10.88 | 10.88 |
| Inventories | 40.4 | 49.2 | 57.8 | 57.8 | 49.9 | 61.2 | 67.2 | 73.8 | 81.0 | 89.0 |
| Inventories, % | 2.57 | 2.84 | 2.82 | 2.82 | 2.41 | 2.69 | 2.69 | 2.69 | 2.69 | 2.69 |
| Accounts Payable | 141.1 | 141.4 | 174.2 | 193.0 | 227.7 | 209.5 | 230.0 | 252.5 | 277.3 | 304.4 |
| Accounts Payable, % | 8.98 | 8.15 | 8.52 | 9.44 | 10.99 | 9.22 | 9.22 | 9.22 | 9.22 | 9.22 |
| Capital Expenditure | -510.4 | -504.7 | -599.4 | -599.4 | -793.4 | -720.8 | -791.3 | -868.8 | -953.8 | -1,047.1 |
| Capital Expenditure, % | -32.5 | -29.1 | -29.31 | -29.31 | -38.32 | -31.71 | -31.71 | -31.71 | -31.71 | -31.71 |
| Tax Rate, % | 28.39 | 28.39 | 28.39 | 28.39 | 28.39 | 28.39 | 28.39 | 28.39 | 28.39 | 28.39 |
| EBITAT | 83.7 | 80.1 | 325.6 | 234.3 | 117.9 | 189.5 | 208.1 | 228.4 | 250.8 | 275.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -231.3 | -145.7 | 7.0 | -111.5 | -204.0 | -227.6 | -192.3 | -211.2 | -231.8 | -254.5 |
| WACC, % | 5.35 | 5.73 | 6.01 | 5.72 | 5.61 | 5.68 | 5.68 | 5.68 | 5.68 | 5.68 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -945.4 | |||||||||
| Long Term Growth Rate, % | 1.00 | |||||||||
| Free cash flow (T + 1) | -257 | |||||||||
| Terminal Value | -5,488 | |||||||||
| Present Terminal Value | -4,162 | |||||||||
| Enterprise Value | -5,108 | |||||||||
| Net Debt | 1,764 | |||||||||
| Equity Value | -6,871 | |||||||||
| Diluted Shares Outstanding, MM | 76 | |||||||||
| Equity Value Per Share | -90.94 |
What You Will Get
- Pre-Filled Financial Model: ATSG’s actual data allows for accurate DCF valuation.
- Full Forecast Control: Modify revenue growth, margins, WACC, and other essential parameters.
- Instant Calculations: Automatic updates provide immediate feedback as you make adjustments.
- Investor-Ready Template: A polished Excel file crafted for high-quality valuation.
- Customizable and Reusable: Designed for adaptability, enabling repeated use for in-depth forecasts.
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for Air Transport Services Group, Inc. (ATSG).
- WACC Calculator: Features a pre-built Weighted Average Cost of Capital sheet with adjustable inputs specific to ATSG.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates for accurate projections.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios pertinent to Air Transport Services Group, Inc. (ATSG).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.
How It Works
- Download the Template: Gain immediate access to the Excel-based ATSG DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates the intrinsic value of Air Transport Services Group, Inc. (ATSG).
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the results to inform your investment strategy or financial analysis.
Why Choose This Calculator?
- Designed for Experts: A sophisticated tool favored by analysts, CFOs, and aviation consultants.
- Comprehensive Data: ATSG’s historical and projected financials are preloaded for precise calculations.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Clear Results: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly: Step-by-step instructions ensure a smooth experience.
Who Should Use This Product?
- Investors: Effectively evaluate Air Transport Services Group, Inc.'s (ATSG) fair value prior to making investment choices.
- CFOs: Utilize a high-quality DCF model for comprehensive financial reporting and analysis.
- Consultants: Seamlessly customize the template for client valuation reports.
- Entrepreneurs: Acquire knowledge on financial modeling practices employed by leading logistics companies.
- Educators: Implement it as a resource to illustrate valuation techniques in the classroom.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations tailored for Air Transport Services Group, Inc. (ATSG).
- Real-World Data: ATSG’s historical and projected financials preloaded for in-depth analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into ATSG's performance.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics specific to ATSG.
- Dashboard with Visual Outputs: Charts and tables designed to present clear, actionable results for informed decision-making.