TuanChe Limited (TC) 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
TuanChe Limited (TC) Bundle
Designed for accuracy, our TuanChe Limited (TC) DCF Calculator enables you to evaluate TuanChe Limited (TC) valuation using actual financial data, offering full flexibility to modify all key parameters for improved 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 | 88.4 | 45.3 | 49.0 | 25.1 | 22.2 | 16.7 | 12.5 | 9.3 | 7.0 | 5.2 |
Revenue Growth, % | 0 | -48.78 | 8.27 | -48.77 | -11.37 | -25.16 | -25.16 | -25.16 | -25.16 | -25.16 |
EBITDA | -35.2 | -22.5 | -14.2 | -13.1 | -15.8 | -8.0 | -6.0 | -4.5 | -3.4 | -2.5 |
EBITDA, % | -39.8 | -49.73 | -28.93 | -52.03 | -71 | -48.3 | -48.3 | -48.3 | -48.3 | -48.3 |
Depreciation | .6 | 1.0 | 1.0 | .6 | .6 | .3 | .2 | .2 | .1 | .1 |
Depreciation, % | 0.68644 | 2.15 | 2.07 | 2.31 | 2.61 | 1.97 | 1.97 | 1.97 | 1.97 | 1.97 |
EBIT | -35.8 | -23.5 | -15.2 | -13.6 | -16.4 | -8.4 | -6.3 | -4.7 | -3.5 | -2.6 |
EBIT, % | -40.49 | -51.88 | -31 | -54.34 | -73.61 | -50.26 | -50.26 | -50.26 | -50.26 | -50.26 |
Total Cash | 38.1 | 22.5 | 9.7 | 10.7 | 2.2 | 5.5 | 4.1 | 3.1 | 2.3 | 1.7 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 9.9 | 9.1 | 6.6 | 6.8 | 4.0 | 3.0 | 2.2 | 1.7 | 1.3 | .9 |
Account Receivables, % | 11.23 | 20.02 | 13.41 | 27.28 | 17.79 | 17.95 | 17.95 | 17.95 | 17.95 | 17.95 |
Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Inventories, % | 0 | 0 | 0 | 0 | 0.000000616 | 0.000000123 | 0.000000123 | 0.000000123 | 0.000000123 | 0.000000123 |
Accounts Payable | .8 | 3.0 | 4.1 | 1.9 | 1.4 | 1.0 | .7 | .6 | .4 | .3 |
Accounts Payable, % | 0.90342 | 6.6 | 8.27 | 7.46 | 6.41 | 5.93 | 5.93 | 5.93 | 5.93 | 5.93 |
Capital Expenditure | -1.8 | -.3 | -.1 | .0 | .0 | -.1 | -.1 | -.1 | .0 | .0 |
Capital Expenditure, % | -2.05 | -0.62018 | -0.27073 | -0.11573 | 0 | -0.61211 | -0.61211 | -0.61211 | -0.61211 | -0.61211 |
Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
EBITAT | -35.7 | -23.3 | -15.2 | -13.2 | -16.4 | -8.3 | -6.2 | -4.6 | -3.5 | -2.6 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -46.0 | -19.5 | -10.7 | -15.1 | -13.4 | -7.5 | -5.5 | -4.1 | -3.1 | -2.3 |
WACC, % | 4.77 | 4.75 | 4.77 | 4.68 | 4.77 | 4.75 | 4.75 | 4.75 | 4.75 | 4.75 |
PV UFCF | ||||||||||
SUM PV UFCF | -20.3 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -2 | |||||||||
Terminal Value | -86 | |||||||||
Present Terminal Value | -68 | |||||||||
Enterprise Value | -89 | |||||||||
Net Debt | 2 | |||||||||
Equity Value | -91 | |||||||||
Diluted Shares Outstanding, MM | 2 | |||||||||
Equity Value Per Share | -53.47 |
What You Will Receive
- Customizable Excel Template: A fully adjustable Excel-based DCF Calculator featuring pre-filled real TuanChe Limited (TC) financials.
- Accurate Data: Historical figures and forward-looking projections (highlighted in the yellow cells).
- Forecast Adaptability: Modify forecast assumptions such as revenue growth, EBITDA percentage, and WACC.
- Instant Calculations: Quickly observe how your inputs affect TuanChe Limited (TC)’s valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- Intuitive Design: Organized for clarity and simplicity, complete with step-by-step guidance.
Key Features
- Comprehensive Historical Data: TuanChe Limited’s (TC) past financial statements and pre-filled projections.
- Customizable Parameters: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Calculations: Monitor TuanChe Limited’s (TC) intrinsic value updates instantly.
- Intuitive Visualizations: Dashboard graphs illustrate valuation outcomes and essential metrics.
- Designed for Precision: A reliable resource for analysts, investors, and finance professionals.
How It Works
- Download: Obtain the pre-built Excel file featuring TuanChe Limited’s (TC) financial data.
- Customize: Modify forecasts such as revenue growth, EBITDA %, and WACC to fit your analysis.
- Update Automatically: Watch as intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various projections and instantly compare the results.
- Make Decisions: Leverage the valuation insights to inform your investment approach.
Why Choose This Calculator for TuanChe Limited (TC)?
- All-in-One Solution: Combines DCF, WACC, and financial ratio analyses tailored for TuanChe Limited (TC).
- Flexible Inputs: Modify yellow-highlighted cells to explore different financial scenarios for TuanChe Limited (TC).
- In-Depth Analysis: Automatically computes TuanChe Limited's (TC) intrinsic value and Net Present Value.
- Preloaded Information: Historical and projected data provide reliable foundations for analysis.
- High-Quality Standards: Perfect for financial analysts, investors, and consultants focusing on TuanChe Limited (TC).
Who Should Use TuanChe Limited (TC)?
- Finance Students: Explore innovative automotive retail strategies and apply them using real market data.
- Academics: Integrate industry-specific models into your research or teaching materials.
- Investors: Evaluate your investment hypotheses and assess valuation scenarios for TuanChe Limited (TC).
- Analysts: Enhance your analysis process with a tailored, user-friendly financial model.
- Small Business Owners: Understand how major players in the automotive sector are evaluated and analyzed.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations for TuanChe Limited (TC).
- Real-World Data: TuanChe Limited's historical and projected financials preloaded for in-depth analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into TuanChe Limited (TC).
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results specific to TuanChe Limited (TC).