Skillful Craftsman Education Technology Limited (EDTK) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Skillful Craftsman Education Technology Limited (EDTK) Bundle
Evaluate the financial outlook of Skillful Craftsman Education Technology Limited (EDTK) like an expert! This (EDTK) DCF Calculator provides you with pre-filled financial data and the complete flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your predictions.
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue | 28.6 | 29.2 | 23.1 | 11.3 | 2.0 | 1.2 | .8 | .5 | .3 | .2 |
Revenue Growth, % | 0 | 1.98 | -20.97 | -50.87 | -82.35 | -38.05 | -38.05 | -38.05 | -38.05 | -38.05 |
EBITDA | 22.2 | 19.3 | 11.4 | -9.7 | -3.7 | .0 | .0 | .0 | .0 | .0 |
EBITDA, % | 77.75 | 66.29 | 49.38 | -85.3 | -184.94 | 1.62 | 1.62 | 1.62 | 1.62 | 1.62 |
Depreciation | 9.0 | 10.3 | 12.0 | 10.0 | .3 | .5 | .3 | .2 | .1 | .1 |
Depreciation, % | 31.45 | 35.45 | 51.87 | 88.36 | 12.91 | 44.01 | 44.01 | 44.01 | 44.01 | 44.01 |
EBIT | 13.2 | 9.0 | -.6 | -19.7 | -4.0 | -.3 | -.2 | -.1 | -.1 | .0 |
EBIT, % | 46.31 | 30.84 | -2.49 | -173.66 | -197.85 | -25.07 | -25.07 | -25.07 | -25.07 | -25.07 |
Total Cash | 11.9 | 17.5 | 23.8 | 21.0 | 17.8 | 1.0 | .6 | .4 | .2 | .1 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .1 | 5.8 | .3 | .5 | .0 | .1 | .0 | .0 | .0 | .0 |
Account Receivables, % | 0.27546 | 19.87 | 1.24 | 4.35 | 2.06 | 5.56 | 5.56 | 5.56 | 5.56 | 5.56 |
Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Inventories, % | 0 | 0 | 0 | 0.000008831001 | 0 | 0.0000017662 | 0.0000017662 | 0.0000017662 | 0.0000017662 | 0.0000017662 |
Accounts Payable | .2 | .1 | .1 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Accounts Payable, % | 0.8709 | 0.38983 | 0.3352 | 0.19335 | 0 | 0.35785 | 0.35785 | 0.35785 | 0.35785 | 0.35785 |
Capital Expenditure | -1.7 | -12.9 | -2.4 | .0 | .0 | -.1 | -.1 | -.1 | .0 | .0 |
Capital Expenditure, % | -5.85 | -44.1 | -10.25 | 0 | 0 | -12.04 | -12.04 | -12.04 | -12.04 | -12.04 |
Tax Rate, % | 0.57424 | 0.57424 | 0.57424 | 0.57424 | 0.57424 | 0.57424 | 0.57424 | 0.57424 | 0.57424 | 0.57424 |
EBITAT | 9.9 | 4.5 | -1.0 | -20.1 | -3.9 | -.3 | -.2 | -.1 | -.1 | .0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 17.4 | -3.9 | 14.1 | -10.3 | -3.2 | .1 | .1 | .1 | .0 | .0 |
WACC, % | 4.99 | 4.31 | 5.67 | 5.67 | 5.65 | 5.26 | 5.26 | 5.26 | 5.26 | 5.26 |
PV UFCF | ||||||||||
SUM PV UFCF | .3 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 0 | |||||||||
Terminal Value | 1 | |||||||||
Present Terminal Value | 1 | |||||||||
Enterprise Value | 1 | |||||||||
Net Debt | -5 | |||||||||
Equity Value | 6 | |||||||||
Diluted Shares Outstanding, MM | 15 | |||||||||
Equity Value Per Share | 0.36 |
What You Will Get
- Editable Forecast Inputs: Effortlessly modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Skillful Craftsman Education Technology Limited’s (EDTK) financial data pre-loaded to facilitate your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A sleek Excel model that adjusts to meet your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Customizable Learning Modules: Tailor educational content to meet diverse student needs and preferences.
- Real-Time Performance Tracking: Monitor student progress and engagement with instant analytics.
- Industry-Leading Educational Tools: Leverage cutting-edge technology for enhanced learning experiences.
- Flexible Course Design: Easily adapt courses to incorporate new materials and teaching strategies.
- Efficiency Boost: Streamline administrative tasks to focus more on teaching and learning.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Skillful Craftsman Education Technology Limited (EDTK) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Skillful Craftsman Education Technology Limited’s (EDTK) intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose Skillful Craftsman Education Technology Limited (EDTK)?
- Expertise: Backed by industry-leading knowledge in educational technology.
- Customization: Tailored solutions that allow users to adapt tools to their specific needs.
- Efficiency: Streamline your educational processes without starting from scratch.
- High-Quality: Created with precision and insight, ensuring top-tier performance.
- Accessibility: Intuitive design that makes it easy for all users, regardless of technical skill.
Who Should Use This Product?
- Investors: Assess the fair value of Skillful Craftsman Education Technology Limited (EDTK) before making investment choices.
- CFOs: Utilize a robust DCF model for precise financial reporting and analysis.
- Consultants: Easily customize the template for client valuation reports.
- Entrepreneurs: Discover financial modeling techniques employed by leading education technology firms.
- Educators: Employ it as a resource to illustrate valuation methodologies in the classroom.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations for Skillful Craftsman Education Technology Limited (EDTK).
- Real-World Data: Historical and projected financials for EDTK preloaded for thorough analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore different scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into EDTK's performance.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage specific to EDTK.
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results related to EDTK.