|
Valoración de DCF de Gogo Inc. (Gogo)
US | Communication Services | Telecommunications 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
Gogo Inc. (GOGO) Bundle
¡Descubra el verdadero potencial de Gogo Inc. (Gogo) con nuestra calculadora DCF avanzada! Personalice los supuestos esenciales, explore varios escenarios y evalúe cómo las fluctuaciones afectan la valoración de Gogo Inc. (Gogo), todo dentro de una plantilla de Excel conveniente.
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 | 835.7 | 269.7 | 335.7 | 404.1 | 397.6 | 373.2 | 350.4 | 328.9 | 308.7 | 289.8 |
| Revenue Growth, % | 0 | -67.73 | 24.47 | 20.36 | -1.61 | -6.13 | -6.13 | -6.13 | -6.13 | -6.13 |
| EBITDA | 113.2 | 90.5 | 52.3 | 157.2 | 140.9 | 102.3 | 96.0 | 90.1 | 84.6 | 79.4 |
| EBITDA, % | 13.55 | 33.56 | 15.58 | 38.9 | 35.43 | 27.4 | 27.4 | 27.4 | 27.4 | 27.4 |
| Depreciation | 16.7 | 14.2 | 15.5 | 12.6 | 16.7 | 14.3 | 13.4 | 12.6 | 11.8 | 11.1 |
| Depreciation, % | 2 | 5.25 | 4.61 | 3.11 | 4.2 | 3.83 | 3.83 | 3.83 | 3.83 | 3.83 |
| EBIT | 96.5 | 76.4 | 36.8 | 144.6 | 124.2 | 88.0 | 82.6 | 77.5 | 72.8 | 68.3 |
| EBIT, % | 11.55 | 28.31 | 10.97 | 35.78 | 31.23 | 23.57 | 23.57 | 23.57 | 23.57 | 23.57 |
| Total Cash | 170.0 | 435.3 | 145.9 | 175.3 | 139.0 | 180.8 | 169.7 | 159.3 | 149.5 | 140.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 42.9 | 42.3 | 37.7 | 60.7 | 73.4 | 48.9 | 45.9 | 43.1 | 40.5 | 38.0 |
| Account Receivables, % | 5.13 | 15.66 | 11.24 | 15.02 | 18.47 | 13.11 | 13.11 | 13.11 | 13.11 | 13.11 |
| Inventories | 117.1 | 28.1 | 34.0 | 49.5 | 63.2 | 46.8 | 43.9 | 41.2 | 38.7 | 36.3 |
| Inventories, % | 14.02 | 10.42 | 10.12 | 12.25 | 15.89 | 12.54 | 12.54 | 12.54 | 12.54 | 12.54 |
| Accounts Payable | 5.5 | 11.0 | 17.2 | 13.6 | 16.1 | 12.9 | 12.1 | 11.4 | 10.7 | 10.0 |
| Accounts Payable, % | 0.65751 | 4.08 | 5.12 | 3.38 | 4.05 | 3.46 | 3.46 | 3.46 | 3.46 | 3.46 |
| Capital Expenditure | -115.5 | -9.0 | -8.7 | -49.9 | -24.1 | -28.5 | -26.7 | -25.1 | -23.6 | -22.1 |
| Capital Expenditure, % | -13.82 | -3.33 | -2.58 | -12.35 | -6.06 | -7.63 | -7.63 | -7.63 | -7.63 | -7.63 |
| Tax Rate, % | -49.26 | -49.26 | -49.26 | -49.26 | -49.26 | -49.26 | -49.26 | -49.26 | -49.26 | -49.26 |
| EBITAT | 97.2 | 76.1 | -183.6 | 125.9 | 185.3 | 68.0 | 63.9 | 60.0 | 56.3 | 52.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -156.1 | 176.5 | -171.9 | 46.5 | 153.9 | 91.6 | 55.7 | 52.2 | 49.0 | 46.0 |
| WACC, % | 7.75 | 7.75 | 5.81 | 7.5 | 7.75 | 7.31 | 7.31 | 7.31 | 7.31 | 7.31 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 245.3 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | 47 | |||||||||
| Terminal Value | 1,100 | |||||||||
| Present Terminal Value | 773 | |||||||||
| Enterprise Value | 1,018 | |||||||||
| Net Debt | 539 | |||||||||
| Equity Value | 479 | |||||||||
| Diluted Shares Outstanding, MM | 133 | |||||||||
| Equity Value Per Share | 3.59 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real GOGO financials.
- Real-World Data: Historical data and forward-looking estimates (as indicated in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the effects of your inputs on Gogo Inc.'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 GOGO Data: Pre-loaded with Gogo Inc.'s historical performance metrics and future growth estimates.
- Customizable Assumptions: Modify parameters such as revenue growth rates, profit margins, discount rates, tax implications, and capital investments.
- Interactive Valuation Tool: Instant recalibrations of Net Present Value (NPV) and intrinsic value based on your custom inputs.
- Multiple Scenario Analysis: Develop various forecasting scenarios to evaluate different valuation possibilities.
- Intuitive User Interface: Designed to be accessible for both seasoned professionals and newcomers.
How It Works
- Download the Template: Gain immediate access to the Excel-based Gogo Inc. (GOGO) DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model will automatically refresh Gogo Inc.'s (GOGO) intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the findings to inform your investment or financial analysis.
Why Choose This Calculator for Gogo Inc. (GOGO)?
- Accurate Data: Utilize real Gogo Inc. financials for dependable valuation outcomes.
- Customizable: Tailor essential parameters like growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Pre-built calculations save you from starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the telecommunications sector.
- User-Friendly: An intuitive design and step-by-step guidance make it accessible for all users.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and trustworthy valuation models for analyzing Gogo Inc. (GOGO) stock.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights to clients focused on Gogo Inc. (GOGO).
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Tech Enthusiasts: Gain insights into how telecommunications companies like Gogo Inc. (GOGO) are assessed in the market.
What the Template Contains
- Historical Data: Includes Gogo Inc.’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Gogo Inc.’s intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Gogo Inc.’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.