Tian Ruixiang Holdings Ltd (TIRX) 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
Tian Ruixiang Holdings Ltd (TIRX) Bundle
Gain insight into your Tian Ruixiang Holdings Ltd (TIRX) valuation analysis using our sophisticated DCF Calculator! Preloaded with real (TIRX) data, this Excel template empowers you to adjust forecasts and assumptions, enabling you to determine the intrinsic value of Tian Ruixiang Holdings Ltd (TIRX) with accuracy.
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 | 2.0 | 3.2 | 2.8 | 1.4 | 1.2 | 1.2 | 1.2 | 1.1 | 1.1 | 1.1 |
| Revenue Growth, % | 0 | 62.29 | -14.12 | -51.56 | -7.96 | -2.84 | -2.84 | -2.84 | -2.84 | -2.84 |
| EBITDA | .1 | .8 | -2.0 | -4.7 | -2.9 | -.6 | -.6 | -.5 | -.5 | -.5 |
| EBITDA, % | 6.86 | 24.24 | -71.62 | -350.39 | -236.01 | -48.1 | -48.1 | -48.1 | -48.1 | -48.1 |
| Depreciation | .0 | .2 | .3 | .2 | .1 | .1 | .1 | .1 | .1 | .1 |
| Depreciation, % | 1.73 | 7 | 9.14 | 15.41 | 6.41 | 7.94 | 7.94 | 7.94 | 7.94 | 7.94 |
| EBIT | .1 | .6 | -2.3 | -4.9 | -3.0 | -.6 | -.6 | -.6 | -.6 | -.6 |
| EBIT, % | 5.13 | 17.24 | -80.76 | -365.8 | -242.42 | -51.68 | -51.68 | -51.68 | -51.68 | -51.68 |
| Total Cash | 6.2 | 6.1 | 30.0 | 26.2 | 26.8 | 1.2 | 1.2 | 1.1 | 1.1 | 1.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .2 | 1.2 | .3 | 7.8 | .0 | .4 | .4 | .4 | .4 | .3 |
| Account Receivables, % | 8.64 | 38.38 | 11.5 | 578.05 | 1.52 | 32.01 | 32.01 | 32.01 | 32.01 | 32.01 |
| Inventories | 1.6 | 2.2 | 1.2 | .7 | .0 | .6 | .6 | .5 | .5 | .5 |
| Inventories, % | 80.68 | 66.65 | 41.82 | 51.24 | 0 | 48.08 | 48.08 | 48.08 | 48.08 | 48.08 |
| 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 | -.2 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Capital Expenditure, % | -9.75 | -0.10639 | -0.12223 | -0.17353 | 0 | -2.03 | -2.03 | -2.03 | -2.03 | -2.03 |
| Tax Rate, % | -7.04 | -7.04 | -7.04 | -7.04 | -7.04 | -7.04 | -7.04 | -7.04 | -7.04 | -7.04 |
| EBITAT | .0 | .5 | -2.3 | -5.0 | -3.2 | -.5 | -.5 | -.5 | -.5 | -.5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -1.9 | -.9 | -.1 | -11.8 | 5.3 | -1.4 | -.4 | -.4 | -.4 | -.4 |
| WACC, % | 8.15 | 8.25 | 8.28 | 8.28 | 8.28 | 8.25 | 8.25 | 8.25 | 8.25 | 8.25 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -2.5 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 0 | |||||||||
| Terminal Value | -6 | |||||||||
| Present Terminal Value | -4 | |||||||||
| Enterprise Value | -7 | |||||||||
| Net Debt | 0 | |||||||||
| Equity Value | -7 | |||||||||
| Diluted Shares Outstanding, MM | 1 | |||||||||
| Equity Value Per Share | -10.76 |
What You Will Receive
- Customizable Excel Template: A fully adjustable Excel-based DCF Calculator featuring pre-filled real TIRX financials.
- Accurate Data: Historical performance data and future estimates (highlighted in the yellow cells).
- Flexible Forecasting: Adjust forecast parameters such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe how your inputs affect the valuation of Tian Ruixiang Holdings Ltd (TIRX).
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- Intuitive Layout: Organized for clarity and user-friendliness, complete with step-by-step guidance.
Key Features
- Accurate Financial Data for TIRX: Access reliable pre-loaded historical figures and future forecasts for Tian Ruixiang Holdings Ltd (TIRX).
- Tailored Forecast Assumptions: Modify highlighted cells for key metrics like WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic adjustments to DCF, Net Present Value (NPV), and cash flow evaluations.
- User-Friendly Dashboard: Clear charts and summaries to easily interpret your valuation outcomes.
- Designed for All Users: An intuitive layout suitable for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Tian Ruixiang Holdings Ltd (TIRX) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Tian Ruixiang Holdings Ltd (TIRX)’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Tian Ruixiang Holdings Ltd (TIRX)?
- Accurate Data: Utilize real financial metrics from Tian Ruixiang for trustworthy valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Built-in calculations allow you to bypass starting from the ground up.
- Professional-Grade Tool: Crafted specifically for investors, analysts, and consultants.
- User-Friendly: The intuitive design and guided instructions make it accessible for all users.
Who Should Use This Product?
- Investors: Assess Tian Ruixiang Holdings Ltd's (TIRX) valuation prior to making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and evaluate financial forecasts for TIRX.
- Startup Founders: Understand the valuation practices of established companies like Tian Ruixiang Holdings Ltd (TIRX).
- Consultants: Provide detailed valuation assessments for clients involving TIRX.
- Students and Educators: Utilize practical data from Tian Ruixiang Holdings Ltd (TIRX) to enhance learning of valuation strategies.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations for Tian Ruixiang Holdings Ltd (TIRX).
- Real-World Data: Historical and projected financials for Tian Ruixiang Holdings Ltd (TIRX) preloaded for in-depth analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore different scenarios.
- Financial Statements: Complete annual and quarterly breakdowns to provide deeper insights into the company's performance.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics specific to Tian Ruixiang Holdings Ltd (TIRX).
- Dashboard with Visual Outputs: Visual representations including charts and tables for clear, actionable insights.