Tuya Inc. (TUYA) 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
Tuya Inc. (TUYA) Bundle
Explore Tuya Inc. (TUYA) financial potential with our easy-to-use DCF Calculator! Enter your projections for growth, margins, and expenses to calculate Tuya Inc. (TUYA) intrinsic value and shape your investment approach.
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 | 105.8 | 179.9 | 302.1 | 208.2 | 230.0 | 297.5 | 384.8 | 497.6 | 643.7 | 832.5 |
Revenue Growth, % | 0 | 70.03 | 67.94 | -31.09 | 10.48 | 29.34 | 29.34 | 29.34 | 29.34 | 29.34 |
EBITDA | -70.0 | -64.2 | -173.2 | -160.0 | -99.3 | -166.1 | -214.9 | -277.9 | -359.5 | -464.9 |
EBITDA, % | -66.21 | -35.67 | -57.34 | -76.85 | -43.16 | -55.85 | -55.85 | -55.85 | -55.85 | -55.85 |
Depreciation | 3.4 | 5.7 | 10.4 | 8.2 | 6.5 | 9.9 | 12.8 | 16.5 | 21.4 | 27.6 |
Depreciation, % | 3.21 | 3.16 | 3.43 | 3.94 | 2.85 | 3.32 | 3.32 | 3.32 | 3.32 | 3.32 |
EBIT | -73.4 | -69.8 | -183.6 | -168.2 | -105.8 | -176.0 | -227.6 | -294.4 | -380.8 | -492.5 |
EBIT, % | -69.42 | -38.83 | -60.77 | -80.79 | -46.01 | -59.16 | -59.16 | -59.16 | -59.16 | -59.16 |
Total Cash | 229.9 | 179.8 | 1,066.1 | 954.3 | 789.7 | 297.4 | 384.7 | 497.6 | 643.6 | 832.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 7.1 | 21.8 | 34.1 | 14.9 | 14.2 | 25.8 | 33.4 | 43.2 | 55.9 | 72.3 |
Account Receivables, % | 6.69 | 12.11 | 11.29 | 7.18 | 6.16 | 8.68 | 8.68 | 8.68 | 8.68 | 8.68 |
Inventories | 23.0 | 42.3 | 62.6 | 45.4 | 32.9 | 60.7 | 78.5 | 101.6 | 131.4 | 169.9 |
Inventories, % | 21.76 | 23.5 | 20.72 | 21.8 | 14.29 | 20.41 | 20.41 | 20.41 | 20.41 | 20.41 |
Accounts Payable | 12.2 | 23.2 | 12.2 | 9.6 | 11.6 | 22.6 | 29.3 | 37.9 | 49.0 | 63.4 |
Accounts Payable, % | 11.51 | 12.88 | 4.04 | 4.61 | 5.03 | 7.61 | 7.61 | 7.61 | 7.61 | 7.61 |
Capital Expenditure | -2.5 | -3.2 | -6.2 | -.7 | -1.5 | -4.3 | -5.5 | -7.1 | -9.2 | -11.9 |
Capital Expenditure, % | -2.35 | -1.78 | -2.05 | -0.34106 | -0.65177 | -1.43 | -1.43 | -1.43 | -1.43 | -1.43 |
Tax Rate, % | -5.69 | -5.69 | -5.69 | -5.69 | -5.69 | -5.69 | -5.69 | -5.69 | -5.69 | -5.69 |
EBITAT | -73.6 | -70.1 | -184.1 | -170.4 | -111.8 | -176.0 | -227.6 | -294.4 | -380.8 | -492.5 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -90.6 | -90.6 | -223.5 | -129.1 | -91.5 | -198.8 | -239.1 | -309.3 | -400.1 | -517.4 |
WACC, % | 6.14 | 6.14 | 6.14 | 6.14 | 6.14 | 6.14 | 6.14 | 6.14 | 6.14 | 6.14 |
PV UFCF | ||||||||||
SUM PV UFCF | -1,357.8 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -528 | |||||||||
Terminal Value | -12,761 | |||||||||
Present Terminal Value | -9,475 | |||||||||
Enterprise Value | -10,833 | |||||||||
Net Debt | -491 | |||||||||
Equity Value | -10,342 | |||||||||
Diluted Shares Outstanding, MM | 555 | |||||||||
Equity Value Per Share | -18.62 |
What You Will Receive
- Customizable Excel Template: A fully adjustable Excel-based DCF Calculator featuring pre-filled real TUYA financials.
- Accurate Data: Historical data and forward-looking projections (highlighted in the yellow cells).
- Flexible Forecasting: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe how your inputs affect Tuya’s valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- Intuitive Design: Organized for clarity and user-friendliness, complete with step-by-step guidance.
Key Features
- Comprehensive TUYA Data: Pre-loaded with Tuya Inc.’s historical financial metrics and future growth estimates.
- Customizable Assumptions: Modify revenue growth rates, profit margins, discount rates, tax percentages, and capital expenditures.
- Interactive Valuation Model: Automatically recalculates Net Present Value (NPV) and intrinsic value as you adjust inputs.
- Scenario Analysis: Develop various forecasting scenarios to explore different valuation possibilities.
- Intuitive Interface: Designed to be simple and accessible for both seasoned professionals and newcomers.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Tuya Inc. (TUYA) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Tuya Inc.'s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Tuya Inc. (TUYA)?
- Accurate Data: Utilize real Tuya financials for dependable valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you from starting from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the tech industry.
- User-Friendly: Easy-to-navigate design and clear instructions ensure accessibility for all users.
Who Should Use Tuya Inc. (TUYA)?
- Investors: Evaluate Tuya's market position before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts.
- Startup Founders: Understand the valuation strategies of successful tech companies like Tuya.
- Consultants: Provide in-depth valuation analysis and reports to clients.
- Students and Educators: Utilize current market data to study and teach valuation principles.
What the Tuya Template Contains
- Preloaded TUYA Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.