|
Valoración de DCF de Air Lease Corporation (AL)
US | Industrials | Rental & Leasing Services | 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
Air Lease Corporation (AL) Bundle
¡Explore el futuro financiero de Air Lease Corporation (AL) con nuestra calculadora DCF fácil de usar! Ingrese sus proyecciones para el crecimiento, los márgenes y los gastos para determinar el valor intrínseco de Air Lease Corporation (AL) y refinar su enfoque de inversión.
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 | 2,016.9 | 2,015.4 | 2,088.4 | 2,317.3 | 2,685.0 | 2,888.9 | 3,108.2 | 3,344.3 | 3,598.2 | 3,871.5 |
| Revenue Growth, % | 0 | -0.07263608 | 3.62 | 10.96 | 15.87 | 7.59 | 7.59 | 7.59 | 7.59 | 7.59 |
| EBITDA | 1,475.2 | 1,470.4 | 1,474.2 | 1,373.4 | 1,876.5 | 1,998.2 | 2,149.9 | 2,313.2 | 2,488.8 | 2,677.8 |
| EBITDA, % | 73.14 | 72.96 | 70.59 | 59.27 | 69.89 | 69.17 | 69.17 | 69.17 | 69.17 | 69.17 |
| Depreciation | 702.8 | 780.7 | 882.6 | 966.0 | 1,068.8 | 1,140.1 | 1,226.7 | 1,319.9 | 1,420.1 | 1,527.9 |
| Depreciation, % | 34.85 | 38.74 | 42.26 | 41.68 | 39.81 | 39.47 | 39.47 | 39.47 | 39.47 | 39.47 |
| EBIT | 772.4 | 689.7 | 591.6 | 407.4 | 807.7 | 858.0 | 923.2 | 993.3 | 1,068.7 | 1,149.9 |
| EBIT, % | 38.3 | 34.22 | 28.33 | 17.58 | 30.08 | 29.7 | 29.7 | 29.7 | 29.7 | 29.7 |
| Total Cash | 317.5 | 1,734.2 | 1,086.5 | 766.4 | 460.9 | 1,178.9 | 1,268.5 | 1,364.8 | 1,468.4 | 1,579.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Inventories | .0 | .0 | .0 | -24.6 | .0 | -6.1 | -6.6 | -7.1 | -7.6 | -8.2 |
| Inventories, % | 0 | 0 | 0 | -1.06 | 0 | -0.21232 | -0.21232 | -0.21232 | -0.21232 | -0.21232 |
| Accounts Payable | 516.5 | 492.5 | 611.8 | 696.9 | 1,164.1 | 882.7 | 949.7 | 1,021.8 | 1,099.4 | 1,182.9 |
| Accounts Payable, % | 25.61 | 24.44 | 29.29 | 30.07 | 43.36 | 30.55 | 30.55 | 30.55 | 30.55 | 30.55 |
| Capital Expenditure | -4,839.3 | -2,678.2 | -3,232.7 | -3,639.6 | -4,527.9 | -2,888.9 | -3,108.2 | -3,344.3 | -3,598.2 | -3,871.5 |
| Capital Expenditure, % | -239.94 | -132.89 | -154.79 | -157.06 | -168.64 | -100 | -100 | -100 | -100 | -100 |
| Tax Rate, % | 18.45 | 18.45 | 18.45 | 18.45 | 18.45 | 18.45 | 18.45 | 18.45 | 18.45 | 18.45 |
| EBITAT | 616.4 | 550.6 | 477.5 | 284.9 | 658.7 | 672.4 | 723.5 | 778.4 | 837.5 | 901.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -3,003.6 | -1,370.9 | -1,753.3 | -2,279.1 | -2,357.8 | -1,351.7 | -1,090.6 | -1,173.4 | -1,262.5 | -1,358.4 |
| WACC, % | 5.42 | 5.42 | 5.45 | 5.08 | 5.48 | 5.37 | 5.37 | 5.37 | 5.37 | 5.37 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -5,337.8 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -1,386 | |||||||||
| Terminal Value | -41,102 | |||||||||
| Present Terminal Value | -31,642 | |||||||||
| Enterprise Value | -36,980 | |||||||||
| Net Debt | 18,722 | |||||||||
| Equity Value | -55,702 | |||||||||
| Diluted Shares Outstanding, MM | 111 | |||||||||
| Equity Value Per Share | -499.84 |
What You Will Get
- Pre-Filled Financial Model: Air Lease Corporation’s (AL) actual data enables precise DCF valuation.
- Full Forecast Control: Adjust revenue growth, margins, WACC, and other key drivers to fit your analysis.
- Instant Calculations: Automatic updates provide immediate results as you modify inputs.
- Investor-Ready Template: A polished Excel file crafted for professional-grade valuation presentations.
- Customizable and Reusable: Designed for flexibility, allowing for repeated use in detailed forecasting scenarios.
Key Features
- Customizable Financial Inputs: Adjust key metrics such as lease rates, aircraft acquisition costs, and operating expenses.
- Instant DCF Valuation: Quickly determines intrinsic value, NPV, and other financial metrics with ease.
- High-Precision Accuracy: Leverages Air Lease Corporation's (AL) actual financial data for dependable valuation results.
- Effortless Scenario Analysis: Explore various assumptions and analyze different outcomes without hassle.
- Efficiency Boost: Streamline your analysis process without the need for complex valuation frameworks.
How It Works
- 1. Access the Template: Download and open the Excel file containing Air Lease Corporation’s (AL) preloaded data.
- 2. Modify Assumptions: Adjust key inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results Instantly: The DCF model automatically calculates intrinsic value and NPV.
- 4. Explore Scenarios: Analyze various forecasts to evaluate different valuation outcomes.
- 5. Present with Assurance: Showcase professional valuation insights to enhance your decision-making.
Why Choose This Calculator?
- User-Friendly Interface: Perfect for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters to suit your analytical needs.
- Real-Time Feedback: Observe immediate updates to Air Lease Corporation’s (AL) valuation as you change inputs.
- Preloaded Data: Comes equipped with Air Lease Corporation’s (AL) latest financial information for swift evaluations.
- Preferred by Experts: A go-to tool for investors and analysts seeking to make strategic choices.
Who Should Use This Product?
- Investors: Evaluate Air Lease Corporation’s (AL) valuation before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts for Air Lease Corporation (AL).
- Startup Founders: Understand the valuation strategies of established companies like Air Lease Corporation (AL).
- Consultants: Provide clients with comprehensive valuation analyses related to Air Lease Corporation (AL).
- Students and Educators: Utilize the financial data of Air Lease Corporation (AL) to teach and practice valuation principles.
What the Template Contains
- Pre-Filled DCF Model: Air Lease Corporation’s (AL) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Air Lease Corporation’s (AL) profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.