Recon Technology, Ltd. (RCON) 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
Recon Technology, Ltd. (RCON) Bundle
Whether you're an investor or analyst, this (RCON) DCF Calculator is your go-to resource for accurate valuation. Preloaded with real data from Recon Technology, Ltd., you can adjust forecasts and observe the effects in real-time.
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 | 8.9 | 6.6 | 11.5 | 9.2 | 9.4 | 9.6 | 9.8 | 10.0 | 10.2 | 10.4 |
Revenue Growth, % | 0 | -26.38 | 74.76 | -19.89 | 2.59 | 1.89 | 1.89 | 1.89 | 1.89 | 1.89 |
EBITDA | -2.5 | -7.9 | 13.9 | -7.1 | -6.9 | -3.4 | -3.5 | -3.6 | -3.6 | -3.7 |
EBITDA, % | -28.51 | -120.28 | 121.36 | -77.49 | -73.15 | -35.83 | -35.83 | -35.83 | -35.83 | -35.83 |
Depreciation | .4 | .7 | .9 | 1.0 | 2.9 | 1.2 | 1.3 | 1.3 | 1.3 | 1.3 |
Depreciation, % | 4.64 | 10.47 | 7.73 | 10.33 | 30.9 | 12.81 | 12.81 | 12.81 | 12.81 | 12.81 |
EBIT | -3.0 | -8.6 | 13.0 | -8.1 | -9.8 | -4.2 | -4.3 | -4.4 | -4.5 | -4.6 |
EBIT, % | -33.15 | -130.75 | 113.63 | -87.83 | -104.04 | -44.19 | -44.19 | -44.19 | -44.19 | -44.19 |
Total Cash | 4.2 | 47.1 | 43.4 | 39.5 | 27.1 | 8.6 | 8.7 | 8.9 | 9.1 | 9.3 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 8.9 | 11.2 | 9.2 | 11.1 | 34.6 | 9.2 | 9.4 | 9.6 | 9.8 | 9.9 |
Account Receivables, % | 99.89 | 170.61 | 80.29 | 120.34 | 366.76 | 96.04 | 96.04 | 96.04 | 96.04 | 96.04 |
Inventories | .3 | .5 | .5 | .9 | .2 | .5 | .5 | .5 | .5 | .5 |
Inventories, % | 3.05 | 7.6 | 4.65 | 9.43 | 1.64 | 5.27 | 5.27 | 5.27 | 5.27 | 5.27 |
Accounts Payable | 3.2 | 3.0 | 2.3 | 1.5 | 1.4 | 2.5 | 2.6 | 2.6 | 2.7 | 2.7 |
Accounts Payable, % | 35.37 | 45.8 | 19.98 | 16.08 | 14.8 | 26.41 | 26.41 | 26.41 | 26.41 | 26.41 |
Capital Expenditure | -.5 | -.1 | -.1 | -.1 | .0 | -.2 | -.2 | -.2 | -.2 | -.2 |
Capital Expenditure, % | -5.94 | -1.09 | -0.82624 | -1.4 | 0 | -1.85 | -1.85 | -1.85 | -1.85 | -1.85 |
Tax Rate, % | 3.04 | 3.04 | 3.04 | 3.04 | 3.04 | 3.04 | 3.04 | 3.04 | 3.04 | 3.04 |
EBITAT | -3.0 | -8.4 | 13.3 | -7.8 | -9.5 | -4.2 | -4.3 | -4.3 | -4.4 | -4.5 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -9.1 | -10.5 | 15.3 | -10.0 | -29.5 | 23.0 | -3.3 | -3.4 | -3.4 | -3.5 |
WACC, % | 12.17 | 12.15 | 12.17 | 12.12 | 12.13 | 12.15 | 12.15 | 12.15 | 12.15 | 12.15 |
PV UFCF | ||||||||||
SUM PV UFCF | 11.4 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | -4 | |||||||||
Terminal Value | -30 | |||||||||
Present Terminal Value | -17 | |||||||||
Enterprise Value | -6 | |||||||||
Net Debt | -10 | |||||||||
Equity Value | 4 | |||||||||
Diluted Shares Outstanding, MM | 5 | |||||||||
Equity Value Per Share | 0.77 |
What You Will Get
- Real RCON Financial Data: Pre-filled with Recon Technology’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Recon Technology’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for Recon Technology, Ltd. (RCON).
- WACC Calculator: Features a pre-built Weighted Average Cost of Capital sheet with adjustable inputs specific to RCON.
- Customizable Forecast Assumptions: Easily modify growth rates, capital expenditures, and discount rates for accurate projections.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios pertinent to Recon Technology, Ltd. (RCON).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.
How It Works
- 1. Download the Template: Obtain and open the Excel file featuring Recon Technology, Ltd. (RCON)'s preloaded data.
- 2. Adjust Key Inputs: Modify essential parameters such as growth rates, WACC, and capital expenditures.
- 3. Instant Results: The DCF model automatically computes intrinsic value and NPV in real-time.
- 4. Explore Different Scenarios: Analyze various forecasts to evaluate different valuation possibilities.
- 5. Present with Assurance: Deliver expert valuation insights to enhance your decision-making process.
Why Choose This Calculator for Recon Technology, Ltd. (RCON)?
- Accuracy: Utilizes real Recon Technology financial data for precise calculations.
- Flexibility: Allows users to easily adjust and test various inputs.
- Time-Saving: Eliminate the need to create a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling skills.
Who Should Use This Product?
- Investors: Evaluate Recon Technology’s valuation before making stock transactions.
- CFOs and Financial Analysts: Enhance valuation methodologies and validate forecasts.
- Startup Founders: Understand how established companies like Recon Technology are appraised.
- Consultants: Provide comprehensive valuation reports for client needs.
- Students and Educators: Utilize real-time data to practice and instruct on valuation strategies.
What the Template Contains
- Preloaded RCON 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.