China Pharma Holdings, Inc. (CPHI) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
China Pharma Holdings, Inc. (CPHI) Bundle
As an investor or analyst, the (CPHI) DCF Calculator is your go-to resource for accurate valuation. Featuring real data from China Pharma Holdings, Inc., you can easily adjust forecasts and observe the effects in real time.
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 | 10.9 | 10.9 | 9.6 | 8.1 | 7.0 | 6.3 | 5.6 | 5.1 | 4.5 | 4.1 |
Revenue Growth, % | 0 | -0.52625 | -11.27 | -15.95 | -13.48 | -10.31 | -10.31 | -10.31 | -10.31 | -10.31 |
EBITDA | -17.5 | .1 | .2 | -.8 | .0 | -1.3 | -1.2 | -1.1 | -1.0 | -.9 |
EBITDA, % | -159.75 | 0.98332 | 2.39 | -10.34 | 0.12032 | -21.37 | -21.37 | -21.37 | -21.37 | -21.37 |
Depreciation | 2.9 | 2.7 | 3.1 | 2.7 | 2.8 | 2.0 | 1.8 | 1.6 | 1.4 | 1.3 |
Depreciation, % | 26.81 | 24.66 | 32.02 | 33.32 | 39.27 | 31.22 | 31.22 | 31.22 | 31.22 | 31.22 |
EBIT | -20.4 | -2.6 | -2.9 | -3.5 | -2.7 | -3.0 | -2.7 | -2.4 | -2.1 | -1.9 |
EBIT, % | -186.57 | -23.67 | -29.64 | -43.66 | -39.15 | -47.22 | -47.22 | -47.22 | -47.22 | -47.22 |
Total Cash | 1.1 | 1.0 | 4.9 | 2.0 | 1.4 | 1.4 | 1.3 | 1.2 | 1.0 | .9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .7 | .6 | .8 | .5 | .7 | .4 | .4 | .4 | .3 | .3 |
Account Receivables, % | 6.24 | 5.37 | 8.66 | 5.73 | 9.45 | 7.09 | 7.09 | 7.09 | 7.09 | 7.09 |
Inventories | 3.6 | 3.7 | 3.3 | 2.9 | 3.7 | 2.4 | 2.2 | 1.9 | 1.7 | 1.6 |
Inventories, % | 32.85 | 34.1 | 34.64 | 36.37 | 53.24 | 38.24 | 38.24 | 38.24 | 38.24 | 38.24 |
Accounts Payable | 1.4 | 1.2 | .9 | .7 | 1.0 | .7 | .6 | .6 | .5 | .5 |
Accounts Payable, % | 12.51 | 11.36 | 9.61 | 8.23 | 13.78 | 11.1 | 11.1 | 11.1 | 11.1 | 11.1 |
Capital Expenditure | -.1 | -.9 | -.4 | -.4 | .0 | -.2 | -.2 | -.2 | -.2 | -.2 |
Capital Expenditure, % | -1.24 | -7.98 | -4.54 | -4.96 | -0.16426 | -3.78 | -3.78 | -3.78 | -3.78 | -3.78 |
Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
EBITAT | -20.7 | -2.8 | -3.3 | -9.1 | -2.7 | -3.0 | -2.7 | -2.4 | -2.1 | -1.9 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -20.8 | -1.2 | -.9 | -6.3 | -.7 | .0 | -.9 | -.8 | -.7 | -.6 |
WACC, % | 7.28 | 7.28 | 7.28 | 7.28 | 7.28 | 7.28 | 7.28 | 7.28 | 7.28 | 7.28 |
PV UFCF | ||||||||||
SUM PV UFCF | -2.4 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -1 | |||||||||
Terminal Value | -12 | |||||||||
Present Terminal Value | -9 | |||||||||
Enterprise Value | -11 | |||||||||
Net Debt | 3 | |||||||||
Equity Value | -14 | |||||||||
Diluted Shares Outstanding, MM | 3 | |||||||||
Equity Value Per Share | -4.25 |
What You Will Get
- Real CPHI Data: Preloaded financials – encompassing revenue to EBIT – based on actual and projected figures.
- Full Customization: Modify all essential parameters (yellow cells) such as WACC, growth %, and tax rates.
- Instant Valuation Updates: Automatic recalculations to evaluate the effects of changes on CPHI’s fair value.
- Versatile Excel Template: Designed for quick edits, scenario analysis, and comprehensive projections.
- Time-Saving and Accurate: Bypass the hassle of building models from scratch while ensuring precision and adaptability.
Key Features
- 🔍 Real-Life CPHI Financials: Pre-filled historical and projected data for China Pharma Holdings, Inc. (CPHI).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate CPHI’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize CPHI’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download the Template: Gain immediate access to the Excel-based CPHI DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional factors.
- Instant Calculations: The model automatically recalculates the intrinsic value of China Pharma Holdings, Inc. (CPHI).
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Leverage the results to inform your investment or financial analysis decisions.
Why Choose This Calculator for China Pharma Holdings, Inc. (CPHI)?
- Accurate Data: Up-to-date financial information for CPHI ensures trustworthy 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 the hassle of starting from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants focused on CPHI.
- User-Friendly: Simple interface and guided instructions make it accessible for all users.
Who Should Use This Product?
- Investors: Evaluate China Pharma Holdings, Inc.'s (CPHI) market position before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and analyze financial forecasts for CPHI.
- Startup Founders: Understand the valuation strategies of established companies like China Pharma Holdings, Inc. (CPHI).
- Consultants: Create detailed valuation assessments and reports for clients focusing on CPHI.
- Students and Educators: Utilize real-time data from China Pharma Holdings, Inc. (CPHI) to enhance learning on valuation practices.
What the Template Contains
- Pre-Filled DCF Model: China Pharma Holdings, Inc.’s (CPHI) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate China Pharma Holdings, Inc.’s (CPHI) profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.