|
51Talk Online Education Group (COE) 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
51Talk Online Education Group (COE) Bundle
Take charge of your 51Talk Online Education Group (COE) valuation analysis with our cutting-edge DCF Calculator! Preloaded with real (COE) data, this Excel template enables you to adjust forecasts and assumptions to accurately calculate the intrinsic value of 51Talk Online Education Group.
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 | 29.1 | 43.1 | 46.6 | 2.1 | 3.7 | 4.1 | 4.5 | 5.0 | 5.5 | 6.1 |
| Revenue Growth, % | 0 | 48.29 | 8.11 | -95.57 | 80.16 | 10.25 | 10.25 | 10.25 | 10.25 | 10.25 |
| EBITDA | -1.2 | 3.0 | -.6 | -1.7 | -1.9 | -1.1 | -1.2 | -1.3 | -1.4 | -1.6 |
| EBITDA, % | -4.27 | 6.96 | -1.32 | -81.44 | -50.03 | -26.02 | -26.02 | -26.02 | -26.02 | -26.02 |
| Depreciation | .5 | .4 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Depreciation, % | 1.79 | 0.92226 | 0.02853791 | 0.68448 | 0.36517 | 0.75906 | 0.75906 | 0.75906 | 0.75906 | 0.75906 |
| EBIT | -1.8 | 2.6 | -.6 | -1.7 | -1.9 | -1.1 | -1.2 | -1.3 | -1.5 | -1.6 |
| EBIT, % | -6.06 | 6.04 | -1.35 | -82.12 | -50.4 | -26.78 | -26.78 | -26.78 | -26.78 | -26.78 |
| Total Cash | 18.4 | 27.6 | 18.1 | 3.2 | 3.2 | 2.9 | 3.2 | 3.5 | 3.9 | 4.3 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .0 | .2 | .0 | .0 | .1 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables, % | 0.16381 | 0.49808 | 0.01527749 | 0 | 1.95 | 0.52642 | 0.52642 | 0.52642 | 0.52642 | 0.52642 |
| Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Inventories, % | 0.0207629 | 0.09420176 | 0.04984866 | -0.91707 | 0 | -0.15045 | -0.15045 | -0.15045 | -0.15045 | -0.15045 |
| 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 | -.2 | -.6 | -.8 | .0 | .0 | .0 | .0 | -.1 | -.1 | -.1 |
| Capital Expenditure, % | -0.75057 | -1.42 | -1.8 | -0.03322701 | -1.06 | -1.01 | -1.01 | -1.01 | -1.01 | -1.01 |
| Tax Rate, % | -0.7912 | -0.7912 | -0.7912 | -0.7912 | -0.7912 | -0.7912 | -0.7912 | -0.7912 | -0.7912 | -0.7912 |
| EBITAT | -1.9 | 2.5 | -1.3 | -1.7 | -1.9 | -1.1 | -1.2 | -1.3 | -1.5 | -1.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -1.6 | 2.1 | -1.9 | -1.6 | -2.0 | -1.0 | -1.2 | -1.3 | -1.5 | -1.6 |
| WACC, % | 5.39 | 5.39 | 5.39 | 5.39 | 5.39 | 5.39 | 5.39 | 5.39 | 5.39 | 5.39 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -5.7 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -2 | |||||||||
| Terminal Value | -49 | |||||||||
| Present Terminal Value | -38 | |||||||||
| Enterprise Value | -43 | |||||||||
| Net Debt | -3 | |||||||||
| Equity Value | -40 | |||||||||
| Diluted Shares Outstanding, MM | 6 | |||||||||
| Equity Value Per Share | -7.12 |
What You Will Get
- Comprehensive COE Financial Data: Pre-loaded with 51Talk’s historical and forecasted data for detailed analysis.
- Customizable Template: Easily adjust key metrics such as revenue growth, WACC, and EBITDA %.
- Instant Calculations: Watch 51Talk’s intrinsic value refresh automatically as you make adjustments.
- Professional Valuation Tool: Tailored for investors, analysts, and consultants aiming for precise DCF outcomes.
- User-Friendly Interface: Intuitive layout and straightforward instructions suitable for all skill levels.
Key Features
- Comprehensive Learning Platform: Offers a range of interactive courses tailored for various skill levels.
- Personalized Learning Paths: Customizable educational journeys based on individual goals and progress.
- Real-Time Feedback: Instant assessments and feedback to enhance the learning experience.
- Qualified Instructors: Access to certified teachers with expertise in online education.
- Engaging Multimedia Content: Utilizes videos, quizzes, and interactive materials to facilitate learning.
How It Works
- Step 1: Download the Excel file for 51Talk Online Education Group (COE).
- Step 2: Review the pre-filled financial data and forecasts for 51Talk.
- Step 3: Adjust key inputs such as enrollment growth, operating margins, and marketing expenses (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you modify your assumptions.
- Step 5: Evaluate the outputs and leverage the results for your investment strategies.
Why Choose This Calculator for 51Talk Online Education Group (COE)?
- Reliable Data: Utilize authentic financial metrics from 51Talk to achieve trustworthy valuation outcomes.
- Customizable Options: Tailor essential factors such as growth rates, WACC, and tax rates to align with your forecasts.
- Efficiency: Ready-made calculations save you time and eliminate the hassle of starting anew.
- Professional-Quality Tool: Crafted for investors, analysts, and consultants in the education sector.
- Easy to Use: User-friendly design and clear instructions make it accessible for everyone.
Who Should Use This Product?
- Investors: Evaluate 51Talk’s (COE) performance before making investment decisions.
- Education Administrators: Optimize educational program assessments and projections.
- Entrepreneurs: Understand how online education companies like 51Talk (COE) are valued.
- Consultants: Provide detailed valuation analyses and reports for clients in the education sector.
- Students and Educators: Utilize real-time data to practice and impart valuation methodologies.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled 51Talk Online Education Group (COE) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for 51Talk Online Education Group (COE).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.