|
Gaotu Techedu Inc. (GOTU) DCF Valuation
CN | Consumer Defensive | Education & Training Services | NYSE
|
- ✓ 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
Gaotu Techedu Inc. (GOTU) Bundle
Engineered for accuracy, our (GOTU) DCF Calculator empowers you to evaluate Gaotu Techedu Inc. valuation using real-world financial data and offers complete flexibility to modify all essential parameters for enhanced projections.
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 | 289.7 | 976.1 | 899.0 | 342.3 | 405.7 | 455.0 | 510.4 | 572.5 | 642.2 | 720.4 |
| Revenue Growth, % | 0 | 236.89 | -7.9 | -61.93 | 18.52 | 12.17 | 12.17 | 12.17 | 12.17 | 12.17 |
| EBITDA | 31.2 | -232.6 | -387.1 | -6.5 | -13.0 | -55.7 | -62.5 | -70.1 | -78.6 | -88.2 |
| EBITDA, % | 10.77 | -23.83 | -43.06 | -1.89 | -3.2 | -12.24 | -12.24 | -12.24 | -12.24 | -12.24 |
| Depreciation | 1.7 | 7.8 | 15.4 | 9.7 | 7.4 | 7.1 | 7.9 | 8.9 | 10.0 | 11.2 |
| Depreciation, % | 0.57006 | 0.803 | 1.72 | 2.83 | 1.83 | 1.55 | 1.55 | 1.55 | 1.55 | 1.55 |
| EBIT | 29.6 | -240.5 | -402.6 | -16.2 | -20.4 | -62.8 | -70.4 | -79.0 | -88.6 | -99.4 |
| EBIT, % | 10.2 | -24.63 | -44.78 | -4.73 | -5.03 | -13.79 | -13.79 | -13.79 | -13.79 | -13.79 |
| Total Cash | 212.0 | 1,053.1 | 479.9 | 512.9 | 395.9 | 386.0 | 433.0 | 485.7 | 544.8 | 611.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 3.6 | 1.6 | 6.8 | 30.5 | 9.8 | 12.3 | 13.8 | 15.5 | 17.3 | 19.5 |
| Account Receivables, % | 1.26 | 0.16276 | 0.76146 | 8.9 | 2.42 | 2.7 | 2.7 | 2.7 | 2.7 | 2.7 |
| Inventories | 1.2 | 6.6 | 2.1 | 3.1 | 3.4 | 2.8 | 3.1 | 3.5 | 3.9 | 4.4 |
| Inventories, % | 0.41714 | 0.67475 | 0.23767 | 0.91197 | 0.83072 | 0.61445 | 0.61445 | 0.61445 | 0.61445 | 0.61445 |
| Accounts Payable | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Accounts Payable, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Capital Expenditure | -8.4 | -38.9 | -37.3 | -17.8 | -5.6 | -16.0 | -18.0 | -20.2 | -22.6 | -25.4 |
| Capital Expenditure, % | -2.9 | -3.99 | -4.15 | -5.2 | -1.38 | -3.52 | -3.52 | -3.52 | -3.52 | -3.52 |
| Tax Rate, % | 317.27 | 317.27 | 317.27 | 317.27 | 317.27 | 317.27 | 317.27 | 317.27 | 317.27 | 317.27 |
| EBITAT | 27.7 | -234.6 | -407.9 | 84.1 | 44.4 | -36.5 | -41.0 | -46.0 | -51.6 | -57.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 16.1 | -269.0 | -430.6 | 51.4 | 66.6 | -47.4 | -52.9 | -59.3 | -66.6 | -74.7 |
| WACC, % | 5.34 | 5.35 | 5.35 | 5.17 | 5.17 | 5.28 | 5.28 | 5.28 | 5.28 | 5.28 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -255.5 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -76 | |||||||||
| Terminal Value | -2,325 | |||||||||
| Present Terminal Value | -1,798 | |||||||||
| Enterprise Value | -2,053 | |||||||||
| Net Debt | -61 | |||||||||
| Equity Value | -1,992 | |||||||||
| Diluted Shares Outstanding, MM | 261 | |||||||||
| Equity Value Per Share | -7.64 |
What You Will Get
- Comprehensive GOTU Financials: Access historical and projected data for precise valuation.
- Customizable Parameters: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are calculated in real-time.
- Scenario Analysis: Evaluate various scenarios to assess Gaotu Techedu’s future performance.
- User-Friendly Interface: Designed for professionals while remaining approachable for newcomers.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Gaotu Techedu Inc. (GOTU).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs specific to the education sector.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to reflect market conditions.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to Gaotu Techedu Inc. (GOTU).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the Excel file for Gaotu Techedu Inc. (GOTU).
- Step 2: Review Gaotu Techedu's pre-filled financial data and projections.
- Step 3: Adjust key inputs such as enrollment growth, discount rate, and operational costs (highlighted cells).
- Step 4: Observe the DCF model refresh in real-time as you modify assumptions.
- Step 5: Evaluate the results and utilize the findings for your investment strategies.
Why Choose This Calculator for Gaotu Techedu Inc. (GOTU)?
- Accurate Data: Utilize real Gaotu Techedu financials for trustworthy valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations remove the hassle of starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the education sector.
- User-Friendly: Streamlined design and clear instructions make it accessible for all users.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Gaotu Techedu Inc. (GOTU) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for Gaotu Techedu Inc. (GOTU).
- Consultants: Deliver professional valuation insights on Gaotu Techedu Inc. (GOTU) to clients quickly and accurately.
- Business Owners: Understand how education companies like Gaotu Techedu Inc. (GOTU) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Gaotu Techedu Inc. (GOTU).
What the Template Contains
- Preloaded GOTU 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.