Delta Air Lines, Inc. (DAL) 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
Delta Air Lines, Inc. (DAL) Bundle
Simplify Delta Air Lines, Inc. (DAL) valuation with this customizable DCF Calculator! Featuring real Delta Air Lines, Inc. (DAL) financials and adjustable forecast inputs, you can test scenarios and uncover Delta Air Lines, Inc. (DAL) fair value in minutes.
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 | 47,007.0 | 17,095.0 | 29,899.0 | 50,582.0 | 58,048.0 | 71,863.8 | 88,967.8 | 110,142.7 | 136,357.3 | 168,811.2 |
| Revenue Growth, % | 0 | -63.63 | 74.9 | 69.18 | 14.76 | 23.8 | 23.8 | 23.8 | 23.8 | 23.8 |
| EBITDA | 9,080.0 | -12,346.0 | 3,675.0 | 5,050.0 | 8,783.0 | -2,227.5 | -2,757.6 | -3,414.0 | -4,226.5 | -5,232.4 |
| EBITDA, % | 19.32 | -72.22 | 12.29 | 9.98 | 15.13 | -3.1 | -3.1 | -3.1 | -3.1 | -3.1 |
| Depreciation | 2,581.0 | 2,312.0 | 1,998.0 | 2,107.0 | 2,341.0 | 4,871.8 | 6,031.3 | 7,466.8 | 9,243.9 | 11,444.0 |
| Depreciation, % | 5.49 | 13.52 | 6.68 | 4.17 | 4.03 | 6.78 | 6.78 | 6.78 | 6.78 | 6.78 |
| EBIT | 6,499.0 | -14,658.0 | 1,677.0 | 2,943.0 | 6,442.0 | -7,099.3 | -8,788.9 | -10,880.8 | -13,470.4 | -16,676.5 |
| EBIT, % | 13.83 | -85.74 | 5.61 | 5.82 | 11.1 | -9.88 | -9.88 | -9.88 | -9.88 | -9.88 |
| Total Cash | 2,882.0 | 14,096.0 | 11,319.0 | 6,534.0 | 3,868.0 | 20,988.0 | 25,983.3 | 32,167.5 | 39,823.5 | 49,301.8 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 2,854.0 | 1,396.0 | 2,404.0 | 3,176.0 | 3,130.0 | 4,879.4 | 6,040.7 | 7,478.5 | 9,258.4 | 11,461.9 |
| Account Receivables, % | 6.07 | 8.17 | 8.04 | 6.28 | 5.39 | 6.79 | 6.79 | 6.79 | 6.79 | 6.79 |
| Inventories | 1,251.0 | 732.0 | 1,098.0 | 1,424.0 | 1,314.0 | 2,255.7 | 2,792.6 | 3,457.3 | 4,280.1 | 5,298.8 |
| Inventories, % | 2.66 | 4.28 | 3.67 | 2.82 | 2.26 | 3.14 | 3.14 | 3.14 | 3.14 | 3.14 |
| Accounts Payable | 3,266.0 | 2,840.0 | 4,240.0 | 5,106.0 | 4,446.0 | 7,976.3 | 9,874.7 | 12,224.9 | 15,134.5 | 18,736.6 |
| Accounts Payable, % | 6.95 | 16.61 | 14.18 | 10.09 | 7.66 | 11.1 | 11.1 | 11.1 | 11.1 | 11.1 |
| Capital Expenditure | -4,936.0 | -1,899.0 | -3,247.0 | -6,366.0 | -5,323.0 | -7,793.6 | -9,648.5 | -11,944.9 | -14,787.8 | -18,307.4 |
| Capital Expenditure, % | -10.5 | -11.11 | -10.86 | -12.59 | -9.17 | -10.84 | -10.84 | -10.84 | -10.84 | -10.84 |
| Tax Rate, % | 17.81 | 17.81 | 17.81 | 17.81 | 17.81 | 17.81 | 17.81 | 17.81 | 17.81 | 17.81 |
| EBITAT | 4,998.5 | -11,646.8 | 1,179.8 | 2,026.6 | 5,294.4 | -5,363.8 | -6,640.4 | -8,220.8 | -10,177.4 | -12,599.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 1,804.5 | -9,682.8 | -43.2 | -2,464.4 | 1,808.4 | -7,446.4 | -10,057.3 | -12,451.0 | -15,414.5 | -19,083.2 |
| WACC, % | 7.77 | 7.82 | 7.65 | 7.62 | 7.87 | 7.74 | 7.74 | 7.74 | 7.74 | 7.74 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -50,109.6 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -19,465 | |||||||||
| Terminal Value | -338,848 | |||||||||
| Present Terminal Value | -233,362 | |||||||||
| Enterprise Value | -283,472 | |||||||||
| Net Debt | 24,540 | |||||||||
| Equity Value | -308,012 | |||||||||
| Diluted Shares Outstanding, MM | 643 | |||||||||
| Equity Value Per Share | -479.02 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Delta Air Lines, Inc. (DAL)’s financial data pre-filled to kickstart your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A sleek Excel model that adjusts to your valuation requirements.
- Built for Analysts and Investors: Perfect for testing projections, validating strategies, and enhancing efficiency.
Key Features
- Customizable Flight Metrics: Adjust essential parameters such as passenger load factor, yield per passenger, and operational costs.
- Instant DCF Valuation: Automatically calculates intrinsic value, NPV, and other financial metrics in real-time.
- Industry-Leading Precision: Leverages Delta Air Lines’ actual financial data for accurate valuation results.
- Seamless Scenario Testing: Easily evaluate various assumptions and analyze potential outcomes.
- Efficiency Booster: Avoid the hassle of constructing intricate valuation models from the ground up.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review Delta Air Lines, Inc.'s (DAL) pre-filled financial data and forecasts.
- Step 3: Adjust key inputs such as passenger revenue growth, operating expenses, and fuel costs (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you modify your assumptions.
- Step 5: Evaluate the results and leverage the insights for your investment strategies.
Why Choose Delta Air Lines, Inc. (DAL)?
- Exceptional Service: Experience unparalleled customer service and support throughout your journey.
- Extensive Network: Access to a vast network of destinations, making travel convenient and efficient.
- Modern Fleet: Fly with confidence on our state-of-the-art aircraft designed for comfort and safety.
- Loyalty Benefits: Enjoy rewards and perks through our SkyMiles program for frequent travelers.
- Commitment to Sustainability: Join us in our efforts towards reducing environmental impact and promoting eco-friendly practices.
Who Should Use Delta Air Lines, Inc. (DAL)?
- Travelers: Enjoy a seamless flying experience with a trusted airline.
- Business Professionals: Utilize convenient flight options to maximize productivity on the go.
- Frequent Flyers: Take advantage of loyalty programs for exclusive perks and benefits.
- Travel Planners: Access comprehensive routes and schedules for effective itinerary planning.
- Students and Educators: Explore real-world applications of aviation and travel management concepts.
What the Template Contains
- Preloaded DAL Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.