Willis Lease Finance Corporation (WLFC) 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
Willis Lease Finance Corporation (WLFC) Bundle
Enhance your investment strategy with the (WLFC) DCF Calculator! Utilize real financial data from Willis Lease Finance Corporation, adjust growth projections and expenses, and instantly observe how these alterations affect the intrinsic value of (WLFC).
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 | 409.2 | 288.7 | 274.2 | 311.9 | 408.0 | 418.3 | 428.8 | 439.6 | 450.7 | 462.1 |
| Revenue Growth, % | 0 | -29.44 | -5.02 | 13.76 | 30.79 | 2.52 | 2.52 | 2.52 | 2.52 | 2.52 |
| EBITDA | 242.7 | 176.9 | 167.6 | 164.8 | 233.4 | 244.1 | 250.2 | 256.5 | 263.0 | 269.7 |
| EBITDA, % | 59.32 | 61.28 | 61.13 | 52.83 | 57.22 | 58.36 | 58.36 | 58.36 | 58.36 | 58.36 |
| Depreciation | 86.2 | 94.5 | 90.5 | 88.3 | 90.9 | 114.9 | 117.8 | 120.8 | 123.9 | 127.0 |
| Depreciation, % | 21.08 | 32.75 | 33.01 | 28.3 | 22.29 | 27.48 | 27.48 | 27.48 | 27.48 | 27.48 |
| EBIT | 156.5 | 82.4 | 77.1 | 76.5 | 142.5 | 129.1 | 132.4 | 135.7 | 139.2 | 142.7 |
| EBIT, % | 38.24 | 28.53 | 28.13 | 24.54 | 34.93 | 30.87 | 30.87 | 30.87 | 30.87 | 30.87 |
| Total Cash | 6.7 | 42.5 | 14.3 | 12.1 | 23.6 | 26.2 | 26.8 | 27.5 | 28.2 | 28.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 24.1 | 28.3 | 39.6 | 128.4 | 58.5 | 71.6 | 73.4 | 75.3 | 77.2 | 79.1 |
| Account Receivables, % | 5.88 | 9.79 | 14.45 | 41.16 | 14.34 | 17.12 | 17.12 | 17.12 | 17.12 | 17.12 |
| Inventories | 41.8 | 59.4 | 51.0 | 38.6 | 41.0 | 60.0 | 61.6 | 63.1 | 64.7 | 66.3 |
| Inventories, % | 10.21 | 20.59 | 18.58 | 12.37 | 10.04 | 14.36 | 14.36 | 14.36 | 14.36 | 14.36 |
| Accounts Payable | 41.8 | 23.1 | 21.7 | 43.0 | 45.0 | 42.6 | 43.7 | 44.8 | 45.9 | 47.1 |
| Accounts Payable, % | 10.22 | 8 | 7.9 | 13.8 | 11.03 | 10.19 | 10.19 | 10.19 | 10.19 | 10.19 |
| Capital Expenditure | -295.7 | -412.2 | -207.9 | -293.0 | -168.8 | -320.7 | -328.8 | -337.1 | -345.6 | -354.3 |
| Capital Expenditure, % | -72.27 | -142.79 | -75.84 | -93.94 | -41.37 | -76.68 | -76.68 | -76.68 | -76.68 | -76.68 |
| Tax Rate, % | 39.86 | 39.86 | 39.86 | 39.86 | 39.86 | 39.86 | 39.86 | 39.86 | 39.86 | 39.86 |
| EBITAT | 117.8 | 46.3 | 28.3 | 42.5 | 85.7 | 73.3 | 75.2 | 77.1 | 79.0 | 81.0 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -115.7 | -312.0 | -93.5 | -217.3 | 77.3 | -167.1 | -138.1 | -141.5 | -145.1 | -148.8 |
| WACC, % | 5.92 | 5.43 | 4.92 | 5.41 | 5.53 | 5.44 | 5.44 | 5.44 | 5.44 | 5.44 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -634.9 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -152 | |||||||||
| Terminal Value | -4,411 | |||||||||
| Present Terminal Value | -3,384 | |||||||||
| Enterprise Value | -4,019 | |||||||||
| Net Debt | 1,796 | |||||||||
| Equity Value | -5,815 | |||||||||
| Diluted Shares Outstanding, MM | 6 | |||||||||
| Equity Value Per Share | -897.27 |
What You Will Receive
- Flexible Forecast Inputs: Modify key assumptions (growth %, margins, WACC) to explore various scenarios.
- Industry-Specific Data: Willis Lease Finance Corporation’s (WLFC) financial data pre-loaded to accelerate your analysis.
- Instant DCF Calculations: The template automatically computes Net Present Value (NPV) and intrinsic value for you.
- Tailored and Professional: A refined Excel model that adjusts to your valuation requirements.
- Designed for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- 🔍 Real-Life WLFC Financials: Pre-filled historical and projected data for Willis Lease Finance Corporation (WLFC).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate WLFC’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize WLFC’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review Willis Lease Finance Corporation’s (WLFC) pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust the assumptions.
- Step 5: Analyze the outputs and leverage the results for informed investment decisions.
Why Choose Willis Lease Finance Corporation (WLFC)?
- Streamlined Operations: Benefit from a comprehensive leasing solution without the hassle of complex setups.
- Enhanced Reliability: Our extensive industry expertise ensures dependable financial transactions and asset management.
- Flexible Solutions: Customize leasing options to align with your specific operational needs and financial goals.
- User-Friendly Experience: Intuitive interfaces and detailed reports simplify decision-making and analysis.
- Industry Leader: Trusted by aviation professionals for our commitment to excellence and innovation.
Who Should Use This Product?
- Aviation Investors: Develop comprehensive valuation models for aircraft leasing and financing.
- Corporate Finance Teams: Evaluate leasing options to inform strategic decisions within the aviation sector.
- Consultants and Advisors: Deliver precise valuation insights for Willis Lease Finance Corporation (WLFC).
- Students and Educators: Utilize industry data to enhance learning and teaching in finance and aviation.
- Aviation Enthusiasts: Gain insights into how companies like Willis Lease Finance Corporation (WLFC) are valued in the market.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Willis Lease Finance Corporation (WLFC) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Willis Lease Finance Corporation (WLFC).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.