Udemy, Inc. (UDMY) 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
Udemy, Inc. (UDMY) Bundle
Explore Udemy, Inc. (UDMY) financial outlook with our user-friendly DCF Calculator! Enter your projections for growth, profit margins, and expenses to calculate Udemy, Inc. (UDMY) intrinsic value and shape your investment decisions.
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 | 276.3 | 429.9 | 518.2 | 629.1 | 728.9 | 935.6 | 1,200.8 | 1,541.1 | 1,978.0 | 2,538.7 |
Revenue Growth, % | 0 | 55.58 | 20.53 | 21.41 | 15.87 | 28.35 | 28.35 | 28.35 | 28.35 | 28.35 |
EBITDA | -59.6 | -62.3 | -63.5 | -130.0 | -78.5 | -149.2 | -191.5 | -245.8 | -315.5 | -404.9 |
EBITDA, % | -21.56 | -14.48 | -12.26 | -20.66 | -10.77 | -15.95 | -15.95 | -15.95 | -15.95 | -15.95 |
Depreciation | 8.7 | 11.1 | 15.3 | 27.4 | 24.6 | 30.7 | 39.4 | 50.6 | 65.0 | 83.4 |
Depreciation, % | 3.16 | 2.57 | 2.95 | 4.36 | 3.37 | 3.28 | 3.28 | 3.28 | 3.28 | 3.28 |
EBIT | -68.3 | -73.3 | -78.8 | -157.4 | -103.1 | -179.9 | -230.9 | -296.4 | -380.4 | -488.3 |
EBIT, % | -24.73 | -17.06 | -15.21 | -25.02 | -14.15 | -19.23 | -19.23 | -19.23 | -19.23 | -19.23 |
Total Cash | 49.4 | 175.0 | 533.9 | 465.4 | 476.9 | 557.6 | 715.7 | 918.5 | 1,178.9 | 1,513.1 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 26.8 | 46.3 | 73.2 | 104.5 | 92.6 | 119.6 | 153.5 | 197.0 | 252.8 | 324.4 |
Account Receivables, % | 9.7 | 10.76 | 14.12 | 16.62 | 12.7 | 12.78 | 12.78 | 12.78 | 12.78 | 12.78 |
Inventories | 7.4 | 14.5 | 32.1 | 30.2 | .0 | 31.9 | 41.0 | 52.6 | 67.5 | 86.7 |
Inventories, % | 2.69 | 3.38 | 6.2 | 4.81 | 0 | 3.41 | 3.41 | 3.41 | 3.41 | 3.41 |
Accounts Payable | 16.3 | 23.7 | 34.6 | 14.5 | 2.5 | 38.8 | 49.9 | 64.0 | 82.1 | 105.4 |
Accounts Payable, % | 5.91 | 5.52 | 6.68 | 2.31 | 0.34379 | 4.15 | 4.15 | 4.15 | 4.15 | 4.15 |
Capital Expenditure | -11.1 | -14.5 | -18.2 | -15.7 | -13.1 | -28.5 | -36.5 | -46.9 | -60.2 | -77.2 |
Capital Expenditure, % | -4.02 | -3.38 | -3.51 | -2.5 | -1.79 | -3.04 | -3.04 | -3.04 | -3.04 | -3.04 |
Tax Rate, % | -3.52 | -3.52 | -3.52 | -3.52 | -3.52 | -3.52 | -3.52 | -3.52 | -3.52 | -3.52 |
EBITAT | -69.7 | -76.4 | -80.0 | -159.8 | -106.8 | -179.9 | -230.9 | -296.4 | -380.4 | -488.3 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -90.0 | -99.1 | -116.5 | -197.6 | -65.0 | -200.3 | -260.0 | -333.7 | -428.3 | -549.7 |
WACC, % | 13.6 | 13.6 | 13.6 | 13.6 | 13.6 | 13.6 | 13.6 | 13.6 | 13.6 | 13.6 |
PV UFCF | ||||||||||
SUM PV UFCF | -1,152.9 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -561 | |||||||||
Terminal Value | -4,831 | |||||||||
Present Terminal Value | -2,553 | |||||||||
Enterprise Value | -3,706 | |||||||||
Net Debt | -299 | |||||||||
Equity Value | -3,407 | |||||||||
Diluted Shares Outstanding, MM | 150 | |||||||||
Equity Value Per Share | -22.70 |
What You Will Get
- Editable Course Inputs: Easily modify assumptions (enrollment rates, course prices, growth %) to explore various outcomes.
- Real-World Data: Udemy’s financial metrics pre-filled to kickstart your analysis.
- Automatic Revenue Outputs: The template computes projected revenue and profitability for you.
- Customizable and Professional: A sleek Excel model tailored to meet your valuation requirements.
- Built for Educators and Investors: Perfect for evaluating course performance, validating strategies, and enhancing efficiency.
Key Features
- 🔍 Real-Life UDMY Financials: Pre-filled historical and projected data for Udemy, Inc. (UDMY).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Udemy’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Udemy’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review Udemy’s pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as course enrollment growth, marketing expenses, and subscription rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
- Step 5: Evaluate the outputs and leverage the results for your investment strategies.
Why Choose This Udemy Calculator?
- Accuracy: Reliable Udemy financials guarantee precise data.
- Flexibility: Built for users to experiment and adjust inputs effortlessly.
- Time-Saving: Eliminate the need to create a financial model from the ground up.
- Professional-Grade: Crafted with CFO-level accuracy and user experience in focus.
- User-Friendly: Intuitive interface suitable for users without extensive financial modeling skills.
Who Should Use This Product?
- Students: Enhance your learning experience with a wide range of courses and resources.
- Professionals: Upskill and stay competitive in the job market by acquiring new knowledge.
- Instructors: Create and share your expertise with a global audience through course creation.
- Employers: Invest in employee development by providing access to valuable training materials.
- Education Institutions: Incorporate online learning into curricula to enrich student education.
What the Template Contains
- Pre-Filled DCF Model: Udemy’s financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Udemy’s profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.