|
Ihuman Inc. (IH) DCF Valoración
CN | Consumer Defensive | Education & Training Services | NYSE
|
- ✓ 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
iHuman Inc. (IH) Bundle
¡Descubra el verdadero potencial de Ihuman Inc. (IH) con nuestra calculadora DCF avanzada! Ajuste los supuestos críticos, explore varios escenarios y evalúe cómo los diferentes factores influyen en la valoración de Ihuman Inc. (IH), todo dentro de una sola plantilla de Excel.
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 | 30.0 | 72.9 | 129.5 | 135.0 | 139.5 | 204.1 | 298.7 | 437.0 | 639.3 | 935.4 |
| Revenue Growth, % | 0 | 143.27 | 77.61 | 4.32 | 3.31 | 46.31 | 46.31 | 46.31 | 46.31 | 46.31 |
| EBITDA | -38.1 | -5.7 | -6.6 | 16.8 | 23.5 | -34.1 | -49.9 | -73.1 | -106.9 | -156.4 |
| EBITDA, % | -127.24 | -7.83 | -5.06 | 12.42 | 16.85 | -16.72 | -16.72 | -16.72 | -16.72 | -16.72 |
| Depreciation | .1 | .4 | .9 | 1.5 | 1.6 | 1.5 | 2.2 | 3.3 | 4.8 | 7.0 |
| Depreciation, % | 0.27303 | 0.52903 | 0.67935 | 1.1 | 1.15 | 0.74574 | 0.74574 | 0.74574 | 0.74574 | 0.74574 |
| EBIT | -38.2 | -6.1 | -7.4 | 15.3 | 21.9 | -35.5 | -52.0 | -76.1 | -111.3 | -162.9 |
| EBIT, % | -127.51 | -8.36 | -5.74 | 11.32 | 15.7 | -17.41 | -17.41 | -17.41 | -17.41 | -17.41 |
| Total Cash | 14.4 | 118.1 | 117.2 | 143.9 | 166.3 | 179.0 | 261.9 | 383.2 | 560.7 | 820.3 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 2.9 | 10.7 | 8.1 | 11.2 | 8.6 | 18.4 | 26.9 | 39.3 | 57.6 | 84.2 |
| Account Receivables, % | 9.6 | 14.72 | 6.24 | 8.31 | 6.15 | 9 | 9 | 9 | 9 | 9 |
| Inventories | 2.8 | 2.3 | 3.8 | 2.6 | 2.3 | 7.8 | 11.4 | 16.7 | 24.5 | 35.8 |
| Inventories, % | 9.45 | 3.17 | 2.97 | 1.94 | 1.62 | 3.83 | 3.83 | 3.83 | 3.83 | 3.83 |
| Accounts Payable | 1.4 | 3.0 | 4.2 | 3.3 | 3.0 | 6.8 | 9.9 | 14.5 | 21.3 | 31.1 |
| Accounts Payable, % | 4.71 | 4.05 | 3.23 | 2.46 | 2.17 | 3.33 | 3.33 | 3.33 | 3.33 | 3.33 |
| Capital Expenditure | -.3 | -2.2 | -4.4 | -6.2 | -.9 | -5.2 | -7.6 | -11.1 | -16.3 | -23.8 |
| Capital Expenditure, % | -1.09 | -2.99 | -3.42 | -4.58 | -0.6393 | -2.54 | -2.54 | -2.54 | -2.54 | -2.54 |
| Tax Rate, % | 10.7 | 10.7 | 10.7 | 10.7 | 10.7 | 10.7 | 10.7 | 10.7 | 10.7 | 10.7 |
| EBITAT | -38.4 | -6.2 | -7.4 | 12.6 | 19.6 | -33.5 | -49.1 | -71.8 | -105.0 | -153.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -42.9 | -13.8 | -8.6 | 5.2 | 23.0 | -48.8 | -63.4 | -92.8 | -135.8 | -198.6 |
| WACC, % | 6.65 | 6.65 | 6.65 | 6.64 | 6.64 | 6.65 | 6.65 | 6.65 | 6.65 | 6.65 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -427.0 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -203 | |||||||||
| Terminal Value | -4,361 | |||||||||
| Present Terminal Value | -3,162 | |||||||||
| Enterprise Value | -3,589 | |||||||||
| Net Debt | -166 | |||||||||
| Equity Value | -3,423 | |||||||||
| Diluted Shares Outstanding, MM | 55 | |||||||||
| Equity Value Per Share | -62.52 |
What You Will Get
- Comprehensive IH Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Real-Time Calculations: Intrinsic value and NPV are computed automatically.
- Scenario Analysis: Explore various scenarios to assess iHuman Inc.'s future performance.
- User-Friendly Interface: Designed for professionals while remaining approachable for newcomers.
Key Features
- Comprehensive iHuman Data: Pre-filled with iHuman Inc.'s historical performance metrics and future projections.
- Fully Customizable Inputs: Modify user engagement rates, growth trajectories, operating costs, and investment strategies.
- Dynamic Valuation Model: Instant updates to Net Present Value (NPV) and intrinsic value based on your parameters.
- Scenario Testing: Develop various forecasting scenarios to evaluate different valuation possibilities.
- User-Friendly Design: Intuitive, organized, and tailored for both seasoned professionals and newcomers.
How It Works
- Step 1: Download the prebuilt Excel template featuring iHuman Inc.’s (IH) data.
- Step 2: Navigate through the pre-filled sheets to grasp the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view recalculated results, including iHuman Inc.’s (IH) intrinsic value.
- Step 5: Make informed investment decisions or generate reports based on the outputs.
Why Choose iHuman Inc. (IH) Calculator?
- User-Friendly Interface: Tailored for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters to suit your specific analysis needs.
- Real-Time Feedback: Observe immediate updates to iHuman's valuation as you change inputs.
- Pre-Configured Data: Comes with iHuman's latest financial statistics for swift evaluations.
- Preferred by Experts: Utilized by investors and analysts for making well-informed choices.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and dependable valuation models for analyzing portfolios involving iHuman Inc. (IH).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within their organizations.
- Consultants and Advisors: Deliver precise valuation insights to clients regarding iHuman Inc. (IH) stock.
- Students and Educators: Leverage real-world data to enhance learning and practice in financial modeling.
- Tech Enthusiasts: Gain insights into the valuation methodologies applied to tech companies like iHuman Inc. (IH).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled iHuman Inc. (IH) 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 iHuman Inc. (IH).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.