Air Lease Corporation (AL) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Air Lease Corporation (AL) Bundle
Explore the financial future of Air Lease Corporation (AL) with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to determine the intrinsic value of Air Lease Corporation (AL) and refine your investment approach.
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.