Sunlands Technology Group (STG) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Sunlands Technology Group (STG) Bundle
Designed for accuracy, our (STG) DCF Calculator empowers you to evaluate the valuation of Sunlands Technology Group using up-to-date 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 | 300.6 | 302.0 | 343.7 | 318.3 | 295.9 | 355.8 | 427.7 | 514.1 | 618.1 | 743.0 |
| Revenue Growth, % | 0 | 0.45075 | 13.8 | -7.37 | -7.04 | 20.21 | 20.21 | 20.21 | 20.21 | 20.21 |
| EBITDA | -63.0 | -88.9 | 33.8 | 90.1 | 97.9 | 14.8 | 17.8 | 21.4 | 25.7 | 30.9 |
| EBITDA, % | -20.95 | -29.45 | 9.83 | 28.31 | 33.08 | 4.16 | 4.16 | 4.16 | 4.16 | 4.16 |
| Depreciation | 5.1 | 5.5 | 5.2 | 6.4 | 4.2 | 6.0 | 7.2 | 8.7 | 10.5 | 12.6 |
| Depreciation, % | 1.7 | 1.83 | 1.51 | 2.01 | 1.42 | 1.69 | 1.69 | 1.69 | 1.69 | 1.69 |
| EBIT | -68.1 | -94.5 | 28.6 | 83.7 | 93.7 | 8.8 | 10.6 | 12.7 | 15.3 | 18.4 |
| EBIT, % | -22.65 | -31.28 | 8.32 | 26.3 | 31.66 | 2.47 | 2.47 | 2.47 | 2.47 | 2.47 |
| Total Cash | 222.0 | 175.2 | 111.1 | 112.9 | 124.1 | 171.9 | 206.7 | 248.4 | 298.7 | 359.0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .8 | .0 | 7.6 | 3.7 | 4.0 | 3.6 | 4.3 | 5.2 | 6.2 | 7.4 |
| Account Receivables, % | 0.27823 | 0 | 2.22 | 1.15 | 1.36 | 1 | 1 | 1 | 1 | 1 |
| Inventories | 32.5 | 18.1 | 11.5 | 1.9 | 2.0 | 15.2 | 18.3 | 22.0 | 26.5 | 31.8 |
| Inventories, % | 10.82 | 6.01 | 3.33 | 0.60923 | 0.65939 | 4.29 | 4.29 | 4.29 | 4.29 | 4.29 |
| 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 | -3.5 | -3.7 | -2.3 | -3.0 | -.9 | -3.1 | -3.7 | -4.4 | -5.3 | -6.4 |
| Capital Expenditure, % | -1.16 | -1.22 | -0.65938 | -0.95652 | -0.29441 | -0.85956 | -0.85956 | -0.85956 | -0.85956 | -0.85956 |
| Tax Rate, % | 3.78 | 3.78 | 3.78 | 3.78 | 3.78 | 3.78 | 3.78 | 3.78 | 3.78 | 3.78 |
| EBITAT | -68.5 | -94.4 | 31.7 | 83.1 | 90.2 | 8.7 | 10.5 | 12.6 | 15.1 | 18.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -100.3 | -77.4 | 33.7 | 100.0 | 93.1 | -1.2 | 10.2 | 12.3 | 14.8 | 17.8 |
| WACC, % | 7.99 | 7.99 | 7.99 | 7.98 | 7.93 | 7.98 | 7.98 | 7.98 | 7.98 | 7.98 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 40.4 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | 18 | |||||||||
| Terminal Value | 239 | |||||||||
| Present Terminal Value | 163 | |||||||||
| Enterprise Value | 203 | |||||||||
| Net Debt | -62 | |||||||||
| Equity Value | 266 | |||||||||
| Diluted Shares Outstanding, MM | 14 | |||||||||
| Equity Value Per Share | 19.25 |
What You Will Receive
- Customizable Excel Template: A fully editable Excel-based DCF Calculator featuring pre-filled financial data for Sunlands Technology Group (STG).
- Accurate Data: Historical performance metrics and future projections (highlighted in the yellow cells).
- Flexible Forecasting: Adjust key assumptions such as revenue growth, EBITDA margin, and WACC.
- Instant Calculations: Quickly observe how your inputs affect the valuation of Sunlands Technology Group (STG).
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- Intuitive Layout: Organized for easy navigation and understanding, complete with step-by-step guidance.
Key Features
- Customizable Forecast Inputs: Adjust essential variables such as student enrollment growth, revenue per student, and operational costs.
- Instant DCF Valuation: Automatically computes intrinsic value, NPV, and other financial metrics in real-time.
- High-Precision Accuracy: Leverages Sunlands Technology Group’s (STG) actual financial data for credible valuation results.
- Streamlined Scenario Analysis: Effortlessly evaluate different scenarios and assess their impacts.
- Efficiency Booster: Remove the complexity of constructing detailed valuation models from the ground up.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Sunlands Technology Group (STG) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Sunlands Technology Group’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose Sunlands Technology Group (STG)?
- Save Time: Quickly access our comprehensive platform without the hassle of setup.
- Enhance Accuracy: Utilize our reliable data and insights to minimize valuation errors.
- Fully Customizable: Adjust features to align with your unique business strategies and forecasts.
- Easy to Understand: Intuitive interfaces and visualizations simplify data interpretation.
- Preferred by Professionals: Built for industry experts who prioritize accuracy and efficiency.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and trustworthy valuation models for analyzing portfolios involving Sunlands Technology Group (STG).
- Corporate Finance Teams: Evaluate valuation scenarios to inform internal strategies related to Sunlands Technology Group (STG).
- Consultants and Advisors: Deliver precise valuation insights to clients interested in Sunlands Technology Group (STG).
- Students and Educators: Utilize real-world data to practice and teach financial modeling techniques with a focus on Sunlands Technology Group (STG).
- Tech Enthusiasts: Gain insights into how technology companies like Sunlands Technology Group (STG) are valued in the market.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Sunlands Technology Group (STG) 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 Sunlands Technology Group (STG).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.