Wheels Up Experience Inc. (UP) 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
Wheels Up Experience Inc. (UP) Bundle
Gain insights into your Wheels Up Experience Inc. (UP) valuation analysis using our cutting-edge DCF Calculator! Equipped with real (UP) data, this Excel template enables you to adjust forecasts and assumptions to accurately calculate the intrinsic value of Wheels Up Experience Inc.
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 | 384.9 | 695.0 | 1,194.3 | 1,579.8 | 1,253.3 | 1,767.2 | 2,491.8 | 3,513.5 | 4,954.2 | 6,985.6 |
| Revenue Growth, % | 0 | 80.56 | 71.84 | 32.28 | -20.66 | 41 | 41 | 41 | 41 | 41 |
| EBITDA | -38.2 | -3.9 | -133.5 | -481.9 | -386.2 | -293.3 | -413.5 | -583.0 | -822.1 | -1,159.2 |
| EBITDA, % | -9.91 | -0.5593 | -11.17 | -30.51 | -30.82 | -16.59 | -16.59 | -16.59 | -16.59 | -16.59 |
| Depreciation | 39.4 | 58.5 | 54.2 | 65.9 | 58.5 | 113.2 | 159.6 | 225.1 | 317.3 | 447.5 |
| Depreciation, % | 10.22 | 8.42 | 4.54 | 4.17 | 4.67 | 6.41 | 6.41 | 6.41 | 6.41 | 6.41 |
| EBIT | -77.5 | -62.4 | -187.7 | -547.9 | -444.7 | -406.5 | -573.1 | -808.1 | -1,139.4 | -1,606.6 |
| EBIT, % | -20.14 | -8.98 | -15.71 | -34.68 | -35.49 | -23 | -23 | -23 | -23 | -23 |
| Total Cash | 84.0 | 312.8 | 784.6 | 585.9 | 263.9 | 674.0 | 950.3 | 1,339.9 | 1,889.4 | 2,664.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 20.0 | 58.6 | 87.5 | 117.9 | 49.8 | 114.5 | 161.4 | 227.6 | 320.9 | 452.5 |
| Account Receivables, % | 5.2 | 8.43 | 7.32 | 7.46 | 3.97 | 6.48 | 6.48 | 6.48 | 6.48 | 6.48 |
| Inventories | .9 | 5.3 | 9.4 | 53.8 | 22.3 | 24.7 | 34.8 | 49.0 | 69.1 | 97.5 |
| Inventories, % | 0.2385 | 0.76549 | 0.78794 | 3.41 | 1.78 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 |
| Accounts Payable | 27.9 | 20.9 | 43.7 | 43.2 | 33.0 | 68.1 | 96.1 | 135.5 | 191.0 | 269.4 |
| Accounts Payable, % | 7.25 | 3.01 | 3.66 | 2.73 | 2.63 | 3.86 | 3.86 | 3.86 | 3.86 | 3.86 |
| Capital Expenditure | -8.1 | -15.5 | -60.1 | -151.4 | -36.7 | -77.3 | -109.0 | -153.7 | -216.7 | -305.5 |
| Capital Expenditure, % | -2.1 | -2.23 | -5.03 | -9.58 | -2.93 | -4.37 | -4.37 | -4.37 | -4.37 | -4.37 |
| Tax Rate, % | -0.28457 | -0.28457 | -0.28457 | -0.28457 | -0.28457 | -0.28457 | -0.28457 | -0.28457 | -0.28457 | -0.28457 |
| EBITAT | -91.1 | -74.3 | -187.7 | -548.0 | -446.0 | -406.5 | -573.1 | -808.1 | -1,139.4 | -1,606.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -52.9 | -81.3 | -203.8 | -708.8 | -334.6 | -402.5 | -551.6 | -777.7 | -1,096.6 | -1,546.3 |
| WACC, % | 13.35 | 13.35 | 13.35 | 13.35 | 13.35 | 13.35 | 13.35 | 13.35 | 13.35 | 13.35 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -2,809.5 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -1,577 | |||||||||
| Terminal Value | -13,901 | |||||||||
| Present Terminal Value | -7,431 | |||||||||
| Enterprise Value | -10,240 | |||||||||
| Net Debt | 73 | |||||||||
| Equity Value | -10,313 | |||||||||
| Diluted Shares Outstanding, MM | 132 | |||||||||
| Equity Value Per Share | -78.02 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real Wheels Up Experience Inc. (UP) financials.
- Real-World Data: Historical data and forward-looking estimates (as indicated in the highlighted cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the effects of your inputs on Wheels Up’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-Time Wheels Up Data: Pre-filled with Wheels Up Experience Inc.'s historical performance and future projections.
- Fully Customizable Inputs: Modify flight hours, pricing strategies, operational costs, and growth rates.
- Dynamic Valuation Model: Instant updates to Net Present Value (NPV) and intrinsic value based on your adjustments.
- Scenario Testing: Develop various forecasting scenarios to evaluate different valuation results.
- User-Friendly Design: Intuitive, organized, and suitable for both industry experts and newcomers.
How It Works
- 1. Access the Template: Download and open the Excel file containing Wheels Up Experience Inc.'s (UP) preloaded data.
- 2. Modify Assumptions: Adjust key variables such as growth rates, WACC, and capital expenditures as needed.
- 3. Analyze Results Instantly: The DCF model will automatically compute the intrinsic value and NPV.
- 4. Explore Scenarios: Evaluate various forecasts to assess different valuation results.
- 5. Present with Assurance: Deliver professional valuation insights to inform your decision-making.
Why Choose This Calculator for Wheels Up Experience Inc. (UP)?
- Accurate Data: Real Wheels Up financials provide dependable valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you from 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 ensure ease of use for everyone.
Who Should Use This Product?
- Aviation Enthusiasts: Discover the intricacies of private aviation and how to leverage them using real-time data.
- Travel Professionals: Integrate advanced flight solutions into your travel planning or consultancy services.
- Investors: Evaluate your strategies and assess the market performance of Wheels Up Experience Inc. (UP).
- Analysts: Enhance your analysis with a comprehensive, customizable flight service model.
- Corporate Executives: Understand how private aviation services can optimize business travel for large organizations.
What the Template Contains
- Pre-Filled DCF Model: Wheels Up Experience Inc.'s (UP) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital specific to Wheels Up Experience Inc. (UP).
- Financial Ratios: Assess Wheels Up Experience Inc.'s (UP) profitability, leverage, and efficiency metrics.
- Editable Inputs: Modify assumptions such as growth rates, profit margins, and CAPEX to tailor your analysis.
- Financial Statements: Access to annual and quarterly reports for comprehensive evaluation.
- Interactive Dashboard: Effortlessly visualize key valuation metrics and outcomes for Wheels Up Experience Inc. (UP).