Allegiant Travel Company (ALGT) DCF Valuation
- ✓ 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
Allegiant Travel Company (ALGT) Bundle
Explore the financial outlook of Allegiant Travel Company (ALGT) with our user-friendly DCF Calculator! Enter your forecasts for growth, margins, and expenses to calculate the intrinsic value of Allegiant Travel Company (ALGT) and enhance 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 | 1,841.0 | 990.1 | 1,707.9 | 2,301.8 | 2,509.9 | 2,949.7 | 3,466.6 | 4,074.1 | 4,788.0 | 5,627.0 |
Revenue Growth, % | 0 | -46.22 | 72.5 | 34.77 | 9.04 | 17.52 | 17.52 | 17.52 | 17.52 | 17.52 |
EBITDA | 533.9 | -128.4 | 446.1 | 305.6 | 490.2 | 442.2 | 519.7 | 610.8 | 717.8 | 843.6 |
EBITDA, % | 29 | -12.97 | 26.12 | 13.27 | 19.53 | 14.99 | 14.99 | 14.99 | 14.99 | 14.99 |
Depreciation | 155.9 | 176.3 | 181.0 | 197.5 | 223.1 | 320.6 | 376.8 | 442.8 | 520.4 | 611.6 |
Depreciation, % | 8.47 | 17.8 | 10.6 | 8.58 | 8.89 | 10.87 | 10.87 | 10.87 | 10.87 | 10.87 |
EBIT | 378.0 | -304.6 | 265.0 | 108.0 | 267.1 | 121.6 | 143.0 | 168.0 | 197.4 | 232.0 |
EBIT, % | 20.54 | -30.77 | 15.52 | 4.69 | 10.64 | 4.12 | 4.12 | 4.12 | 4.12 | 4.12 |
Total Cash | 457.8 | 685.3 | 1,182.8 | 955.1 | 814.7 | 1,399.9 | 1,645.2 | 1,933.5 | 2,272.3 | 2,670.5 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 25.5 | 192.2 | 62.7 | 106.6 | 70.7 | 188.3 | 221.3 | 260.1 | 305.6 | 359.2 |
Account Receivables, % | 1.39 | 19.41 | 3.67 | 4.63 | 2.82 | 6.38 | 6.38 | 6.38 | 6.38 | 6.38 |
Inventories | 28.4 | 24.0 | 27.5 | 35.5 | 36.3 | 50.5 | 59.4 | 69.8 | 82.0 | 96.4 |
Inventories, % | 1.54 | 2.42 | 1.61 | 1.54 | 1.45 | 1.71 | 1.71 | 1.71 | 1.71 | 1.71 |
Accounts Payable | 27.7 | 34.2 | 43.6 | 58.3 | 54.5 | 72.0 | 84.7 | 99.5 | 116.9 | 137.4 |
Accounts Payable, % | 1.5 | 3.45 | 2.55 | 2.53 | 2.17 | 2.44 | 2.44 | 2.44 | 2.44 | 2.44 |
Capital Expenditure | -505.2 | -280.2 | -255.5 | -434.7 | -870.5 | -733.1 | -861.6 | -1,012.6 | -1,190.0 | -1,398.6 |
Capital Expenditure, % | -27.44 | -28.3 | -14.96 | -18.88 | -34.68 | -24.85 | -24.85 | -24.85 | -24.85 | -24.85 |
Tax Rate, % | 26.06 | 26.06 | 26.06 | 26.06 | 26.06 | 26.06 | 26.06 | 26.06 | 26.06 | 26.06 |
EBITAT | 291.3 | -155.3 | 204.7 | 54.4 | 197.5 | 80.2 | 94.2 | 110.7 | 130.1 | 152.9 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -84.3 | -415.1 | 265.6 | -220.0 | -418.7 | -446.6 | -419.9 | -493.4 | -579.9 | -681.5 |
WACC, % | 7.02 | 6.32 | 7.03 | 6.3 | 6.94 | 6.72 | 6.72 | 6.72 | 6.72 | 6.72 |
PV UFCF | ||||||||||
SUM PV UFCF | -2,132.4 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -695 | |||||||||
Terminal Value | -14,722 | |||||||||
Present Terminal Value | -10,634 | |||||||||
Enterprise Value | -12,767 | |||||||||
Net Debt | 2,220 | |||||||||
Equity Value | -14,986 | |||||||||
Diluted Shares Outstanding, MM | 18 | |||||||||
Equity Value Per Share | -831.70 |
What You Will Receive
- Customizable Excel Template: A fully editable Excel-based DCF Calculator featuring pre-filled real ALGT financials.
- Authentic Data: Historical performance data and future estimates (highlighted in the yellow cells).
- Flexible Forecasting: Modify forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe how your inputs affect Allegiant Travel Company’s valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- Intuitive Layout: Organized for clarity and ease of navigation, complete with step-by-step guidance.
Key Features
- Customizable Financial Inputs: Adjust essential metrics such as ticket revenue, operating margins, and fleet expenditures.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and additional financial metrics.
- High-Precision Accuracy: Incorporates Allegiant's actual financial data for credible valuation results.
- Simplified Scenario Testing: Easily evaluate various assumptions and analyze the resulting impacts.
- Efficiency Booster: Avoid the hassle of creating intricate valuation models from the ground up.
How It Works
- Step 1: Download the prebuilt Excel template featuring Allegiant Travel Company's (ALGT) data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Immediately view updated results, including Allegiant Travel Company's (ALGT) intrinsic value.
- Step 5: Utilize the outputs to make informed investment decisions or create detailed reports.
Why Choose This Calculator for Allegiant Travel Company (ALGT)?
- All-in-One Solution: Features DCF, WACC, and comprehensive financial ratio analyses tailored for Allegiant Travel Company.
- Flexible Inputs: Modify the yellow-highlighted cells to explore different financial scenarios for (ALGT).
- In-Depth Analysis: Automatically computes Allegiant's intrinsic value and Net Present Value for informed decision-making.
- Preloaded Information: Includes historical and projected data to provide reliable starting points for (ALGT).
- Expert-Level Tool: Perfect for financial analysts, investors, and consultants focusing on Allegiant Travel Company.
Who Should Use This Product?
- Investors: Assess Allegiant Travel Company’s valuation before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and evaluate financial forecasts.
- Startup Founders: Gain insights into how established companies like Allegiant Travel are appraised.
- Consultants: Provide detailed valuation reports for clients in the travel industry.
- Students and Educators: Utilize current data to enhance learning and practice valuation skills.
What the Template Contains
- Historical Data: Includes Allegiant Travel Company's past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Allegiant Travel Company's intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Allegiant Travel Company's financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.