United Airlines Holdings, Inc. (UAL) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
United Airlines Holdings, Inc. (UAL) Bundle
Evaluate United Airlines Holdings, Inc. (UAL) financial outlook with expertise! This (UAL) DCF Calculator provides pre-filled financial data while allowing you the freedom to modify revenue growth, WACC, margins, and other essential parameters to align with your predictions.
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 | 43,259.0 | 15,355.0 | 24,634.0 | 44,955.0 | 53,717.0 | 66,865.3 | 83,231.8 | 103,604.4 | 128,963.5 | 160,529.8 |
| Revenue Growth, % | 0 | -64.5 | 60.43 | 82.49 | 19.49 | 24.48 | 24.48 | 24.48 | 24.48 | 24.48 |
| EBITDA | 6,848.0 | -5,342.0 | 1,505.0 | 5,119.0 | 7,832.0 | 1,754.1 | 2,183.5 | 2,717.9 | 3,383.2 | 4,211.3 |
| EBITDA, % | 15.83 | -34.79 | 6.11 | 11.39 | 14.58 | 2.62 | 2.62 | 2.62 | 2.62 | 2.62 |
| Depreciation | 2,288.0 | 2,488.0 | 2,485.0 | 2,456.0 | 2,671.0 | 5,618.8 | 6,994.1 | 8,706.0 | 10,836.9 | 13,489.5 |
| Depreciation, % | 5.29 | 16.2 | 10.09 | 5.46 | 4.97 | 8.4 | 8.4 | 8.4 | 8.4 | 8.4 |
| EBIT | 4,560.0 | -7,830.0 | -980.0 | 2,663.0 | 5,161.0 | -3,864.6 | -4,810.6 | -5,988.1 | -7,453.8 | -9,278.2 |
| EBIT, % | 10.54 | -50.99 | -3.98 | 5.92 | 9.61 | -5.78 | -5.78 | -5.78 | -5.78 | -5.78 |
| Total Cash | 4,944.0 | 11,683.0 | 18,406.0 | 16,414.0 | 14,388.0 | 30,160.2 | 37,542.5 | 46,731.7 | 58,170.2 | 72,408.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 1,364.0 | 1,295.0 | 1,663.0 | 1,801.0 | 1,898.0 | 3,460.6 | 4,307.6 | 5,362.0 | 6,674.4 | 8,308.1 |
| Account Receivables, % | 3.15 | 8.43 | 6.75 | 4.01 | 3.53 | 5.18 | 5.18 | 5.18 | 5.18 | 5.18 |
| Inventories | 1,072.0 | 932.0 | 983.0 | 1,109.0 | 1,561.0 | 2,395.3 | 2,981.5 | 3,711.3 | 4,619.8 | 5,750.5 |
| Inventories, % | 2.48 | 6.07 | 3.99 | 2.47 | 2.91 | 3.58 | 3.58 | 3.58 | 3.58 | 3.58 |
| Accounts Payable | 2,703.0 | 1,595.0 | 2,562.0 | 3,395.0 | 3,835.0 | 5,580.2 | 6,946.1 | 8,646.3 | 10,762.6 | 13,397.0 |
| Accounts Payable, % | 6.25 | 10.39 | 10.4 | 7.55 | 7.14 | 8.35 | 8.35 | 8.35 | 8.35 | 8.35 |
| Capital Expenditure | -4,528.0 | -1,727.0 | -2,107.0 | -4,819.0 | -7,171.0 | -7,266.5 | -9,045.1 | -11,259.1 | -14,014.9 | -17,445.3 |
| Capital Expenditure, % | -10.47 | -11.25 | -8.55 | -10.72 | -13.35 | -10.87 | -10.87 | -10.87 | -10.87 | -10.87 |
| Tax Rate, % | 22.7 | 22.7 | 22.7 | 22.7 | 22.7 | 22.7 | 22.7 | 22.7 | 22.7 | 22.7 |
| EBITAT | 3,505.6 | -6,274.1 | -752.7 | 1,982.5 | 3,989.2 | -2,980.1 | -3,709.5 | -4,617.5 | -5,747.7 | -7,154.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 1,532.6 | -6,412.1 | 173.3 | 188.5 | -619.8 | -5,279.4 | -5,828.0 | -7,254.5 | -9,030.2 | -11,240.5 |
| WACC, % | 7.18 | 7.26 | 7.17 | 7.11 | 7.19 | 7.18 | 7.18 | 7.18 | 7.18 | 7.18 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -30,678.9 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -11,465 | |||||||||
| Terminal Value | -221,230 | |||||||||
| Present Terminal Value | -156,395 | |||||||||
| Enterprise Value | -187,074 | |||||||||
| Net Debt | 30,650 | |||||||||
| Equity Value | -217,724 | |||||||||
| Diluted Shares Outstanding, MM | 332 | |||||||||
| Equity Value Per Share | -655.99 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real UAL financials.
- Real-World Data: Historical data and forward-looking estimates (as highlighted in the yellow cells).
- Forecast Flexibility: Modify forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the effects of your inputs on United Airlines' valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, with comprehensive step-by-step instructions.
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for United Airlines Holdings, Inc. (UAL).
- WACC Calculator: Features a pre-built Weighted Average Cost of Capital sheet with adjustable inputs specific to the airline industry.
- Customizable Forecast Assumptions: Easily modify growth rates, capital expenditures, and discount rates to fit UAL's financial outlook.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to United Airlines Holdings, Inc. (UAL).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.
How It Works
- Download the Template: Gain immediate access to the Excel-based UAL DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional parameters.
- Instant Calculations: The model automatically recalculates United Airlines' intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Leverage the results to inform your investment or financial analysis.
Why Choose This Calculator for United Airlines Holdings, Inc. (UAL)?
- Designed for Industry Experts: A sophisticated tool utilized by aviation analysts, CFOs, and financial consultants.
- Comprehensive Data: United Airlines' historical and forecasted financials preloaded for precise analysis.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Insightful Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly Interface: Step-by-step guidance ensures a smooth experience throughout the process.
Who Should Use This Product?
- Investors: Accurately estimate United Airlines' fair value before making investment decisions.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis at United Airlines Holdings, Inc. (UAL).
- Consultants: Efficiently customize the template for valuation reports tailored to clients in the aviation sector.
- Entrepreneurs: Acquire insights into financial modeling practices employed by leading airlines.
- Educators: Implement it as a teaching resource to illustrate valuation methodologies in finance courses.
What the Template Contains
- Pre-Filled DCF Model: United Airlines' financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Assess United Airlines' profitability, leverage, and efficiency.
- Editable Inputs: Modify assumptions such as growth, margins, and CAPEX to suit your scenarios.
- Financial Statements: Annual and quarterly reports to facilitate thorough analysis.
- Interactive Dashboard: Effortlessly visualize key valuation metrics and results.