|
Mondee Holdings, Inc. (Mond) DCF Valoración
US | Consumer Cyclical | Travel 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
Mondee Holdings, Inc. (MOND) Bundle
¡Ahorre tiempo y mejore la precisión con nuestra calculadora DCF (MOND)! Utilizando datos reales de Mondee Holdings, Inc. y suposiciones personalizables, esta herramienta le permite pronosticar, analizar y valorar a Mondee como un inversor experimentado.
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
FY1 2024 |
FY2 2025 |
FY3 2026 |
FY4 2027 |
FY5 2028 |
|
---|---|---|---|---|---|---|---|---|---|---|
Revenue | 65.8 | 93.2 | 159.5 | 223.3 | 337.1 | 508.8 | 767.9 | 1,159.0 | 1,749.3 | |
Revenue Growth, % | 0 | 41.64 | 71.13 | 40.03 | 50.93 | 50.93 | 50.93 | 50.93 | 50.93 | |
EBITDA | -24.6 | -2.0 | -51.7 | -11.9 | -65.2 | -98.4 | -148.6 | -224.2 | -338.4 | |
EBITDA, % | -37.46 | -2.19 | -32.41 | -5.33 | -19.35 | -19.35 | -19.35 | -19.35 | -19.35 | |
Depreciation | 11.4 | 12.9 | 11.8 | 16.1 | 38.5 | 58.2 | 87.8 | 132.5 | 200.0 | |
Depreciation, % | 17.35 | 13.8 | 7.38 | 7.19 | 11.43 | 11.43 | 11.43 | 11.43 | 11.43 | |
EBIT | -36.1 | -14.9 | -63.5 | -28.0 | -103.7 | -156.6 | -236.3 | -356.7 | -538.4 | |
EBIT, % | -54.8 | -15.99 | -39.79 | -12.53 | -30.78 | -30.78 | -30.78 | -30.78 | -30.78 | |
Total Cash | 31.4 | 15.5 | 78.8 | 36.0 | 109.5 | 165.3 | 249.5 | 376.5 | 568.3 | |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | |
Account Receivables | 9.8 | 14.1 | 27.5 | 129.9 | 88.8 | 134.1 | 202.4 | 305.4 | 461.0 | |
Account Receivables, % | 14.86 | 15.14 | 17.26 | 58.15 | 26.35 | 26.35 | 26.35 | 26.35 | 26.35 | |
Inventories | .0 | 8.5 | 8.6 | .0 | 12.2 | 18.5 | 27.9 | 42.1 | 63.5 | |
Inventories, % | 0.000001519849 | 9.1 | 5.42 | 0 | 3.63 | 3.63 | 3.63 | 3.63 | 3.63 | |
Accounts Payable | 18.2 | 19.5 | 33.7 | 115.0 | 102.2 | 154.2 | 232.7 | 351.2 | 530.1 | |
Accounts Payable, % | 27.62 | 20.96 | 21.16 | 51.49 | 30.31 | 30.31 | 30.31 | 30.31 | 30.31 | |
Capital Expenditure | -4.1 | -4.0 | -7.3 | -11.7 | -17.1 | -25.8 | -39.0 | -58.8 | -88.8 | |
Capital Expenditure, % | -6.17 | -4.32 | -4.56 | -5.26 | -5.08 | -5.08 | -5.08 | -5.08 | -5.08 | |
Tax Rate, % | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |
EBITAT | -27.0 | -15.0 | -63.5 | -26.9 | -96.2 | -145.2 | -219.1 | -330.7 | -499.1 | |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -11.2 | -17.6 | -58.4 | -35.0 | -58.8 | -112.3 | -169.5 | -255.8 | -386.0 | |
WACC, % | 15.84 | 21.14 | 21.14 | 20.3 | 19.6 | 19.6 | 19.6 | 19.6 | 19.6 | |
PV UFCF | ||||||||||
SUM PV UFCF | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | -509.4 | |
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -394 | |||||||||
Terminal Value | -2,237 | |||||||||
Present Terminal Value | -914 | |||||||||
Enterprise Value | -1,423 | |||||||||
Net Debt | 138 | |||||||||
Equity Value | -1,561 | |||||||||
Diluted Shares Outstanding, MM | 77 | |||||||||
Equity Value Per Share | -20.22 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Mondee Holdings, Inc. (MOND) 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 refined Excel model that adjusts to your valuation requirements.
- Built for Analysts and Investors: Perfect for testing projections, validating strategies, and optimizing your time.
Key Features
- Real-Life MOND Data: Pre-filled with Mondee Holdings’ historical financials and forward-looking projections.
- Fully Customizable Inputs: Adjust revenue growth, margins, WACC, tax rates, and capital expenditures.
- Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your inputs.
- Scenario Testing: Create multiple forecast scenarios to analyze different valuation outcomes.
- User-Friendly Design: Simple, structured, and designed for professionals and beginners alike.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Mondee Holdings, Inc. (MOND) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Mondee Holdings, Inc. (MOND)'s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose Mondee Holdings, Inc. (MOND)?
- Streamlined Processes: Our platform eliminates the hassle of manual calculations – start using it immediately.
- Enhanced Precision: Access to accurate market data and advanced algorithms minimizes valuation discrepancies.
- Completely Adaptable: Modify our tools to align with your specific forecasts and insights.
- User-Friendly Design: Intuitive visuals and reports simplify the interpretation of your financial results.
- Endorsed by Industry Leaders: Crafted for professionals who prioritize accuracy and functionality.
Who Should Use Mondee Holdings, Inc. (MOND)?
- Travel Industry Students: Explore market dynamics and apply analytical techniques using real-world data.
- Researchers: Integrate industry-specific models into academic projects or studies.
- Investors: Validate your investment strategies and evaluate performance metrics for Mondee Holdings.
- Market Analysts: Enhance your analysis with a ready-to-use, customizable financial model.
- Entrepreneurs: Understand how large travel companies like Mondee are assessed and valued.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Mondee Holdings historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), featuring parameters such as Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models illustrating intrinsic value with comprehensive calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to facilitate analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Mondee Holdings, Inc. (MOND).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions for easy result analysis.