China Jo-Jo Drugstores, Inc. (CJJD) 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
China Jo-Jo Drugstores, Inc. (CJJD) Bundle
Designed for accuracy, our (CJJD) DCF Calculator empowers you to assess China Jo-Jo Drugstores, Inc. valuation using real-world financial data, along with the complete flexibility to modify all essential parameters for improved projections.
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 | 117.3 | 133.1 | 164.4 | 148.8 | 154.5 | 166.6 | 179.7 | 193.8 | 208.9 | 225.3 |
| Revenue Growth, % | 0 | 13.47 | 23.48 | -9.48 | 3.85 | 7.83 | 7.83 | 7.83 | 7.83 | 7.83 |
| EBITDA | -3.7 | -6.1 | -.6 | -20.0 | 1.2 | -6.9 | -7.4 | -8.0 | -8.6 | -9.3 |
| EBITDA, % | -3.12 | -4.56 | -0.35277 | -13.41 | 0.79386 | -4.13 | -4.13 | -4.13 | -4.13 | -4.13 |
| Depreciation | 2.1 | 1.8 | 1.3 | .7 | 5.4 | 2.6 | 2.8 | 3.0 | 3.3 | 3.5 |
| Depreciation, % | 1.78 | 1.36 | 0.76432 | 0.48249 | 3.48 | 1.57 | 1.57 | 1.57 | 1.57 | 1.57 |
| EBIT | -5.7 | -7.9 | -1.8 | -20.7 | -4.2 | -9.5 | -10.3 | -11.1 | -11.9 | -12.9 |
| EBIT, % | -4.89 | -5.93 | -1.12 | -13.9 | -2.69 | -5.7 | -5.7 | -5.7 | -5.7 | -5.7 |
| Total Cash | 16.3 | 22.1 | 18.6 | 18.8 | 20.1 | 22.5 | 24.3 | 26.2 | 28.2 | 30.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 14.9 | 18.5 | 22.5 | 16.8 | 19.1 | 21.3 | 23.0 | 24.8 | 26.7 | 28.8 |
| Account Receivables, % | 12.7 | 13.91 | 13.69 | 11.32 | 12.34 | 12.79 | 12.79 | 12.79 | 12.79 | 12.79 |
| Inventories | 12.2 | 17.0 | 16.0 | 15.3 | 17.2 | 18.1 | 19.5 | 21.1 | 22.7 | 24.5 |
| Inventories, % | 10.44 | 12.75 | 9.75 | 10.29 | 11.11 | 10.87 | 10.87 | 10.87 | 10.87 | 10.87 |
| Accounts Payable | 21.6 | 29.9 | 27.3 | 27.0 | 31.6 | 32.0 | 34.5 | 37.2 | 40.1 | 43.3 |
| Accounts Payable, % | 18.38 | 22.46 | 16.63 | 18.14 | 20.47 | 19.21 | 19.21 | 19.21 | 19.21 | 19.21 |
| Capital Expenditure | -2.3 | -.6 | -.3 | -.3 | -.9 | -1.1 | -1.2 | -1.3 | -1.4 | -1.5 |
| Capital Expenditure, % | -1.95 | -0.45381 | -0.18622 | -0.20947 | -0.59767 | -0.67875 | -0.67875 | -0.67875 | -0.67875 | -0.67875 |
| Tax Rate, % | -1.51 | -1.51 | -1.51 | -1.51 | -1.51 | -1.51 | -1.51 | -1.51 | -1.51 | -1.51 |
| EBITAT | -5.8 | -7.9 | -2.8 | -21.1 | -4.2 | -9.5 | -10.3 | -11.1 | -11.9 | -12.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -11.5 | -6.7 | -7.4 | -14.6 | .8 | -10.8 | -9.2 | -9.9 | -10.7 | -11.6 |
| WACC, % | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -45.8 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -12 | |||||||||
| Terminal Value | -471 | |||||||||
| Present Terminal Value | -378 | |||||||||
| Enterprise Value | -424 | |||||||||
| Net Debt | 23 | |||||||||
| Equity Value | -447 | |||||||||
| Diluted Shares Outstanding, MM | 1 | |||||||||
| Equity Value Per Share | -309.35 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real CJJD financials.
- Real-World Data: Historical data and forward-looking estimates (highlighted in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the effect of your inputs on China Jo-Jo Drugstores' valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for China Jo-Jo Drugstores, Inc. (CJJD).
- WACC Calculator: Ready-to-use Weighted Average Cost of Capital sheet with adjustable inputs for accurate assessments.
- Customizable Forecast Assumptions: Easily alter growth rates, capital expenditures, and discount rates to fit your analysis.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for China Jo-Jo Drugstores, Inc. (CJJD).
- Interactive Dashboard and Charts: Visual representations provide a clear overview of essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the Excel file for China Jo-Jo Drugstores, Inc. (CJJD).
- Step 2: Review the pre-filled financial data and forecasts specific to CJJD.
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
- Step 5: Analyze the outputs and leverage the results for your investment decisions regarding CJJD.
Why Choose This Calculator for China Jo-Jo Drugstores, Inc. (CJJD)?
- Accurate Data: Utilize real China Jo-Jo Drugstores financials for dependable valuation outcomes.
- Customizable: Tailor essential variables like growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Pre-configured calculations save you from starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the retail pharmacy sector.
- User-Friendly: A straightforward design and clear instructions ensure accessibility for all users.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling China Jo-Jo Drugstores, Inc. (CJJD) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for China Jo-Jo Drugstores, Inc. (CJJD).
- Consultants: Deliver professional valuation insights on China Jo-Jo Drugstores, Inc. (CJJD) to clients quickly and accurately.
- Business Owners: Understand how companies like China Jo-Jo Drugstores, Inc. (CJJD) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to China Jo-Jo Drugstores, Inc. (CJJD).
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations for China Jo-Jo Drugstores, Inc. (CJJD).
- Real-World Data: Historical and projected financials for CJJD 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 CJJD's performance.
- Key Ratios: Integrated analysis of profitability, efficiency, and leverage specific to CJJD.
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable insights regarding CJJD.