|
Valoración de DCF de JetBlue Airways Corporation (JBLU)
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
JetBlue Airways Corporation (JBLU) Bundle
¡Simplifique la valoración de JetBlue Airways Corporation (JBLU) con esta calculadora DCF personalizable! Con Real JetBlue Airways Corporation (JBLU) financieras y entradas de pronóstico ajustables, puede probar escenarios y descubrir el valor razonable de JetBlue Airways Corporation (JBLU) en minutos.
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 | 8,094.0 | 2,957.0 | 6,037.0 | 9,158.0 | 9,615.0 | 11,855.8 | 14,618.8 | 18,025.8 | 22,226.8 | 27,406.8 |
| Revenue Growth, % | 0 | -63.47 | 104.16 | 51.7 | 4.99 | 23.31 | 23.31 | 23.31 | 23.31 | 23.31 |
| EBITDA | 1,358.0 | -1,192.0 | 452.0 | 314.0 | 497.0 | -176.6 | -217.8 | -268.5 | -331.1 | -408.3 |
| EBITDA, % | 16.78 | -40.31 | 7.49 | 3.43 | 5.17 | -1.49 | -1.49 | -1.49 | -1.49 | -1.49 |
| Depreciation | 525.0 | 535.0 | 540.0 | 585.0 | 621.0 | 1,099.5 | 1,355.8 | 1,671.7 | 2,061.3 | 2,541.7 |
| Depreciation, % | 6.49 | 18.09 | 8.94 | 6.39 | 6.46 | 9.27 | 9.27 | 9.27 | 9.27 | 9.27 |
| EBIT | 833.0 | -1,727.0 | -88.0 | -271.0 | -124.0 | -1,276.1 | -1,573.5 | -1,940.3 | -2,392.4 | -2,950.0 |
| EBIT, % | 10.29 | -58.4 | -1.46 | -2.96 | -1.29 | -10.76 | -10.76 | -10.76 | -10.76 | -10.76 |
| Total Cash | 929.0 | 1,918.0 | 2,018.0 | 1,042.0 | 1,567.0 | 3,259.0 | 4,018.5 | 4,955.1 | 6,109.8 | 7,533.8 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 231.0 | 98.0 | 207.0 | 317.0 | 336.0 | 392.5 | 484.0 | 596.8 | 735.8 | 907.3 |
| Account Receivables, % | 2.85 | 3.31 | 3.43 | 3.46 | 3.49 | 3.31 | 3.31 | 3.31 | 3.31 | 3.31 |
| Inventories | 81.0 | 71.0 | 74.0 | 87.0 | 109.0 | 159.1 | 196.2 | 242.0 | 298.3 | 367.9 |
| Inventories, % | 1 | 2.4 | 1.23 | 0.94999 | 1.13 | 1.34 | 1.34 | 1.34 | 1.34 | 1.34 |
| Accounts Payable | 401.0 | 365.0 | 499.0 | 532.0 | 641.0 | 902.0 | 1,112.2 | 1,371.4 | 1,691.0 | 2,085.1 |
| Accounts Payable, % | 4.95 | 12.34 | 8.27 | 5.81 | 6.67 | 7.61 | 7.61 | 7.61 | 7.61 | 7.61 |
| Capital Expenditure | -1,156.0 | -791.0 | -995.0 | -923.0 | -1,206.0 | -1,900.1 | -2,343.0 | -2,889.0 | -3,562.3 | -4,392.5 |
| Capital Expenditure, % | -14.28 | -26.75 | -16.48 | -10.08 | -12.54 | -16.03 | -16.03 | -16.03 | -16.03 | -16.03 |
| Tax Rate, % | 7.19 | 7.19 | 7.19 | 7.19 | 7.19 | 7.19 | 7.19 | 7.19 | 7.19 | 7.19 |
| EBITAT | 617.2 | -1,242.6 | -60.9 | -224.5 | -115.1 | -997.7 | -1,230.2 | -1,516.9 | -1,870.4 | -2,306.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 75.2 | -1,391.6 | -493.9 | -652.5 | -632.1 | -1,643.9 | -2,135.7 | -2,633.5 | -3,247.2 | -4,004.0 |
| WACC, % | 6.63 | 6.57 | 6.48 | 6.89 | 7.19 | 6.75 | 6.75 | 6.75 | 6.75 | 6.75 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -10,966.5 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -4,084 | |||||||||
| Terminal Value | -85,902 | |||||||||
| Present Terminal Value | -61,955 | |||||||||
| Enterprise Value | -72,921 | |||||||||
| Net Debt | 4,214 | |||||||||
| Equity Value | -77,135 | |||||||||
| Diluted Shares Outstanding, MM | 333 | |||||||||
| Equity Value Per Share | -231.71 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real JBLU financials.
- Real-World Data: Historical data and forward-looking estimates (as indicated in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the effect of your inputs on JetBlue's valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- 🔍 Real-Life JBLU Financials: Pre-filled historical and projected data for JetBlue Airways Corporation (JBLU).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate JetBlue’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize JetBlue’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- 1. Access the Template: Download and open the Excel file containing JetBlue Airways Corporation's (JBLU) preloaded data.
- 2. Modify Assumptions: Adjust key inputs such as growth rates, WACC, and capital expenditures to fit your analysis.
- 3. View Results Instantly: The DCF model automatically calculates the intrinsic value and NPV for JetBlue Airways Corporation (JBLU).
- 4. Explore Scenarios: Analyze various forecasts to evaluate different valuation outcomes for JetBlue Airways Corporation (JBLU).
- 5. Present with Assurance: Deliver professional valuation insights to inform your decision-making process regarding JetBlue Airways Corporation (JBLU).
Why Choose This Calculator?
- Accurate Data: Real JetBlue financials guarantee trustworthy valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations remove the hassle of starting from scratch.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the aviation sector.
- User-Friendly: Intuitive design and step-by-step guidance make it accessible for all users.
Who Should Use JetBlue Airways Corporation (JBLU)?
- Travelers: Enjoy affordable and reliable air travel options with exceptional service.
- Frequent Flyers: Take advantage of loyalty programs to earn rewards and benefits.
- Business Travelers: Experience convenient flight schedules and amenities tailored for productivity.
- Travel Planners: Utilize JetBlue's extensive network to create seamless travel itineraries.
- Families: Benefit from family-friendly policies and services designed for a comfortable journey.
What the Template Contains
- Pre-Filled Data: Includes JetBlue Airways' historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze JetBlue's profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.