Comstock Holding Companies, Inc. (CHCI) DCF Valuation
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
Comstock Holding Companies, Inc. (CHCI) Bundle
Looking to determine the intrinsic value of Comstock Holding Companies, Inc.? Our (CHCI) DCF Calculator integrates real-world data with complete customization features, allowing you to adjust forecasts and make more informed investment choices.
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 | 25.3 | 28.7 | 31.1 | 39.3 | 44.7 | 51.6 | 59.6 | 68.9 | 79.5 | 91.8 |
| Revenue Growth, % | 0 | 13.47 | 8.24 | 26.44 | 13.76 | 15.47 | 15.47 | 15.47 | 15.47 | 15.47 |
| EBITDA | 2.5 | 2.8 | 5.2 | 8.2 | 9.4 | 8.0 | 9.3 | 10.7 | 12.4 | 14.3 |
| EBITDA, % | 9.84 | 9.59 | 16.59 | 20.75 | 20.97 | 15.55 | 15.55 | 15.55 | 15.55 | 15.55 |
| Depreciation | .2 | .1 | .1 | .2 | .2 | .3 | .3 | .3 | .4 | .5 |
| Depreciation, % | 0.85713 | 0.34812 | 0.30232 | 0.524 | 0.47405 | 0.50112 | 0.50112 | 0.50112 | 0.50112 | 0.50112 |
| EBIT | 2.3 | 2.7 | 5.1 | 8.0 | 9.2 | 7.8 | 9.0 | 10.4 | 12.0 | 13.8 |
| EBIT, % | 8.99 | 9.24 | 16.29 | 20.23 | 20.49 | 15.05 | 15.05 | 15.05 | 15.05 | 15.05 |
| Total Cash | 3.5 | 7.0 | 15.8 | 11.7 | 18.8 | 16.6 | 19.2 | 22.2 | 25.6 | 29.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 5.5 | 3.6 | 1.7 | 3.8 | 5.2 | 6.3 | 7.3 | 8.5 | 9.8 | 11.3 |
| Account Receivables, % | 21.84 | 12.64 | 5.61 | 9.65 | 11.73 | 12.29 | 12.29 | 12.29 | 12.29 | 12.29 |
| Inventories | -5.5 | -3.6 | -1.7 | .0 | .0 | -4.1 | -4.7 | -5.5 | -6.3 | -7.3 |
| Inventories, % | -21.84 | -12.53 | -5.46 | 0 | 0 | -7.97 | -7.97 | -7.97 | -7.97 | -7.97 |
| Accounts Payable | 1.4 | .9 | .8 | .7 | .8 | 1.5 | 1.8 | 2.1 | 2.4 | 2.7 |
| Accounts Payable, % | 5.68 | 2.97 | 2.52 | 1.89 | 1.87 | 2.99 | 2.99 | 2.99 | 2.99 | 2.99 |
| Capital Expenditure | -.2 | -.1 | -.2 | -.6 | -.2 | -.4 | -.5 | -.6 | -.6 | -.7 |
| Capital Expenditure, % | -0.81763 | -0.51173 | -0.60464 | -1.59 | -0.55231 | -0.81573 | -0.81573 | -0.81573 | -0.81573 | -0.81573 |
| Tax Rate, % | 4.51 | 4.51 | 4.51 | 4.51 | 4.51 | 4.51 | 4.51 | 4.51 | 4.51 | 4.51 |
| EBITAT | 2.3 | 2.4 | 14.3 | 7.4 | 8.8 | 7.5 | 8.6 | 9.9 | 11.5 | 13.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 3.7 | 1.7 | 14.1 | 3.2 | 7.4 | 11.0 | 8.3 | 9.6 | 11.1 | 12.8 |
| WACC, % | 7.72 | 7.69 | 7.72 | 7.7 | 7.71 | 7.71 | 7.71 | 7.71 | 7.71 | 7.71 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 42.1 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | 13 | |||||||||
| Terminal Value | 178 | |||||||||
| Present Terminal Value | 123 | |||||||||
| Enterprise Value | 165 | |||||||||
| Net Debt | -12 | |||||||||
| Equity Value | 177 | |||||||||
| Diluted Shares Outstanding, MM | 10 | |||||||||
| Equity Value Per Share | 17.49 |
What You Will Receive
- Adjustable Forecast Inputs: Effortlessly modify key assumptions (growth %, margins, WACC) to explore various scenarios.
- Comprehensive Data: Comstock Holding Companies, Inc. (CHCI) financial data pre-loaded to facilitate your analysis.
- Automated DCF Calculations: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Tailored and Professional Design: A refined Excel model that aligns with your valuation requirements.
- Designed for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for Comstock Holding Companies, Inc. (CHCI).
- WACC Calculator: Features a pre-built Weighted Average Cost of Capital sheet with adjustable inputs specific to CHCI.
- Customizable Forecast Assumptions: Easily modify growth rates, capital expenditures, and discount rates relevant to Comstock Holding Companies, Inc. (CHCI).
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios pertinent to Comstock Holding Companies, Inc. (CHCI).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Comstock Holding Companies, Inc. (CHCI) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Comstock Holding Companies, Inc. (CHCI)’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Comstock Holding Companies, Inc. (CHCI)?
- User-Friendly Interface: Perfectly crafted for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters easily to suit your specific analysis.
- Real-Time Feedback: Instantly view changes to Comstock’s valuation as you modify inputs.
- Preloaded Data: Comes with Comstock’s actual financial information for immediate evaluation.
- Relied Upon by Experts: Utilized by investors and analysts for making well-informed choices.
Who Should Use This Product?
- Real Estate Investors: Create comprehensive valuation models for property analysis related to Comstock Holding Companies, Inc. (CHCI).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in Comstock Holding Companies, Inc. (CHCI).
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Market Analysts: Gain insights into how real estate firms like Comstock Holding Companies, Inc. (CHCI) are valued in the market.
What the Template Contains
- Preloaded CHCI 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.