|
Southwest Airlines Co. (LUV) DCF Valoración
US | Industrials | Airlines, Airports & Air 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
Southwest Airlines Co. (LUV) Bundle
¡Simplifique la valoración de Southwest Airlines Co. (LUV) con esta calculadora DCF personalizable! Con el Real Southwest Airlines Co. (LUV) Financials y las entradas de pronóstico ajustables, puede probar escenarios y descubrir el valor razonable de Southwest Airlines Co. (LUV) 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 | 22,428.0 | 9,048.0 | 15,790.0 | 23,814.0 | 26,091.0 | 30,998.4 | 36,828.8 | 43,755.8 | 51,985.6 | 61,763.4 |
Revenue Growth, % | 0 | -59.66 | 74.51 | 50.82 | 9.56 | 18.81 | 18.81 | 18.81 | 18.81 | 18.81 |
EBITDA | 4,229.0 | -2,699.0 | 3,028.0 | 2,380.0 | 2,391.0 | 1,696.3 | 2,015.3 | 2,394.4 | 2,844.8 | 3,379.8 |
EBITDA, % | 18.86 | -29.83 | 19.18 | 9.99 | 9.16 | 5.47 | 5.47 | 5.47 | 5.47 | 5.47 |
Depreciation | 1,219.0 | 1,255.0 | 1,272.0 | 1,351.0 | 1,522.0 | 2,409.7 | 2,862.9 | 3,401.4 | 4,041.1 | 4,801.2 |
Depreciation, % | 5.44 | 13.87 | 8.06 | 5.67 | 5.83 | 7.77 | 7.77 | 7.77 | 7.77 | 7.77 |
EBIT | 3,010.0 | -3,954.0 | 1,756.0 | 1,029.0 | 869.0 | -713.4 | -847.6 | -1,007.0 | -1,196.4 | -1,421.4 |
EBIT, % | 13.42 | -43.7 | 11.12 | 4.32 | 3.33 | -2.3 | -2.3 | -2.3 | -2.3 | -2.3 |
Total Cash | 4,072.0 | 13,334.0 | 15,504.0 | 12,292.0 | 11,474.0 | 19,339.1 | 22,976.6 | 27,298.2 | 32,432.6 | 38,532.8 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 1,086.0 | 1,130.0 | 1,357.0 | 1,040.0 | 1,154.0 | 2,152.2 | 2,557.0 | 3,038.0 | 3,609.4 | 4,288.3 |
Account Receivables, % | 4.84 | 12.49 | 8.59 | 4.37 | 4.42 | 6.94 | 6.94 | 6.94 | 6.94 | 6.94 |
Inventories | 529.0 | 414.0 | 537.0 | 790.0 | 807.0 | 1,038.2 | 1,233.4 | 1,465.4 | 1,741.1 | 2,068.5 |
Inventories, % | 2.36 | 4.58 | 3.4 | 3.32 | 3.09 | 3.35 | 3.35 | 3.35 | 3.35 | 3.35 |
Accounts Payable | 1,574.0 | 931.0 | 1,282.0 | 530.0 | 265.0 | 1,777.3 | 2,111.6 | 2,508.8 | 2,980.6 | 3,541.3 |
Accounts Payable, % | 7.02 | 10.29 | 8.12 | 2.23 | 1.02 | 5.73 | 5.73 | 5.73 | 5.73 | 5.73 |
Capital Expenditure | -1,027.0 | -515.0 | -511.0 | -3,946.0 | -3,553.0 | -2,708.9 | -3,218.5 | -3,823.8 | -4,543.0 | -5,397.5 |
Capital Expenditure, % | -4.58 | -5.69 | -3.24 | -16.57 | -13.62 | -8.74 | -8.74 | -8.74 | -8.74 | -8.74 |
Tax Rate, % | 26.54 | 26.54 | 26.54 | 26.54 | 26.54 | 26.54 | 26.54 | 26.54 | 26.54 | 26.54 |
EBITAT | 2,341.2 | -2,855.9 | 1,294.8 | 761.9 | 638.4 | -529.7 | -629.3 | -747.7 | -888.3 | -1,055.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 2,492.2 | -2,687.9 | 2,056.8 | -2,521.1 | -1,788.6 | -546.0 | -1,250.6 | -1,485.9 | -1,765.3 | -2,097.4 |
WACC, % | 7.98 | 7.91 | 7.93 | 7.93 | 7.93 | 7.94 | 7.94 | 7.94 | 7.94 | 7.94 |
PV UFCF | ||||||||||
SUM PV UFCF | -5,493.4 | |||||||||
Long Term Growth Rate, % | 3.00 | |||||||||
Free cash flow (T + 1) | -2,160 | |||||||||
Terminal Value | -43,766 | |||||||||
Present Terminal Value | -29,874 | |||||||||
Enterprise Value | -35,368 | |||||||||
Net Debt | -88 | |||||||||
Equity Value | -35,280 | |||||||||
Diluted Shares Outstanding, MM | 640 | |||||||||
Equity Value Per Share | -55.12 |
What You Will Receive
- Pre-Filled Financial Model: Southwest Airlines' actual data enables accurate DCF valuation.
- Full Forecast Control: Modify revenue growth, profit margins, WACC, and other essential drivers.
- Instant Calculations: Automatic updates provide immediate results as you make adjustments.
- Investor-Ready Template: A polished Excel file crafted for high-quality valuation.
- Customizable and Reusable: Designed for adaptability, allowing repeated use for comprehensive forecasts.
Key Features
- Customizable Flight Metrics: Adjust key parameters such as ticket pricing, load factor, and operational costs.
- Instant Route Profitability Analysis: Quickly assesses profitability, breakeven points, and other financial metrics.
- Industry-Leading Precision: Utilizes Southwest Airlines' actual financial data for accurate performance assessments.
- Dynamic Scenario Planning: Evaluate various market conditions and their impacts on profitability effortlessly.
- Efficiency Booster: Streamlines the process of analyzing complex operational models without starting from scratch.
How It Works
- 1. Access the Template: Download and open the Excel file containing Southwest Airlines Co.'s (LUV) financial data.
- 2. Modify Assumptions: Adjust key parameters such as growth projections, WACC, and capital expenditures.
- 3. View Results in Real-Time: The DCF model automatically computes intrinsic value and NPV based on your inputs.
- 4. Explore Different Scenarios: Evaluate various forecasts to understand a range of valuation possibilities.
- 5. Present with Assurance: Deliver expert valuation insights to back your strategic decisions.
Why Choose This Calculator for Southwest Airlines Co. (LUV)?
- Accuracy: Utilizes real Southwest Airlines financial data for precise calculations.
- Flexibility: Allows users to easily adjust and experiment with various input parameters.
- Time-Saving: Eliminate the need to create a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and attention to detail expected by CFOs.
- User-Friendly: Intuitive interface designed for users of all financial backgrounds.
Who Should Use This Product?
- Airline Investors: Develop comprehensive and accurate valuation models for assessing Southwest Airlines Co. (LUV).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the airline industry.
- Consultants and Advisors: Offer clients precise valuation insights for Southwest Airlines Co. (LUV) stock.
- Students and Educators: Utilize real-world airline data to practice and teach financial modeling techniques.
- Aviation Enthusiasts: Gain insights into how airlines like Southwest Airlines Co. (LUV) are valued in the market.
What the Template Contains
- Pre-Filled DCF Model: Southwest Airlines Co.'s (LUV) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital specific to Southwest Airlines Co. (LUV).
- Financial Ratios: Evaluate Southwest Airlines Co.'s (LUV) profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios for Southwest Airlines Co. (LUV).
- Financial Statements: Annual and quarterly reports of Southwest Airlines Co. (LUV) to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results for Southwest Airlines Co. (LUV).