First Community Corporation (FCCO) 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
First Community Corporation (FCCO) Bundle
Engineered for accuracy, our (FCCO) DCF Calculator empowers you to evaluate First Community Corporation's valuation using real-world financial data, providing complete flexibility to modify all essential parameters for enhanced projections.
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 | 48.9 | 53.8 | 59.0 | 59.5 | 58.1 | 60.7 | 63.5 | 66.4 | 69.4 | 72.5 |
Revenue Growth, % | 0 | 10.08 | 9.7 | 0.83542 | -2.42 | 4.55 | 4.55 | 4.55 | 4.55 | 4.55 |
EBITDA | 16.0 | 14.6 | 21.6 | 20.2 | 17.0 | 19.4 | 20.2 | 21.2 | 22.1 | 23.1 |
EBITDA, % | 32.64 | 27.13 | 36.54 | 34 | 29.21 | 31.9 | 31.9 | 31.9 | 31.9 | 31.9 |
Depreciation | 2.1 | 2.0 | 1.9 | 1.8 | 1.9 | 2.1 | 2.2 | 2.3 | 2.5 | 2.6 |
Depreciation, % | 4.34 | 3.72 | 3.25 | 3.06 | 3.3 | 3.53 | 3.53 | 3.53 | 3.53 | 3.53 |
EBIT | 13.8 | 12.6 | 19.6 | 18.4 | 15.0 | 17.2 | 18.0 | 18.8 | 19.7 | 20.6 |
EBIT, % | 28.3 | 23.41 | 33.29 | 30.94 | 25.9 | 28.37 | 28.37 | 28.37 | 28.37 | 28.37 |
Total Cash | 334.5 | 424.9 | 633.9 | 369.3 | 94.7 | 60.7 | 63.5 | 66.4 | 69.4 | 72.5 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Inventories, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
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 | .0 | -1.1 | -.8 | -1.2 | -1.1 | -.9 | -.9 | -1.0 | -1.0 | -1.1 |
Capital Expenditure, % | 0 | -2.02 | -1.38 | -2.06 | -1.84 | -1.46 | -1.46 | -1.46 | -1.46 | -1.46 |
Tax Rate, % | 21.26 | 21.26 | 21.26 | 21.26 | 21.26 | 21.26 | 21.26 | 21.26 | 21.26 | 21.26 |
EBITAT | 11.0 | 10.1 | 15.5 | 14.6 | 11.8 | 13.7 | 14.3 | 14.9 | 15.6 | 16.3 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 13.1 | 11.0 | 16.6 | 15.2 | 12.7 | 14.9 | 15.6 | 16.3 | 17.0 | 17.8 |
WACC, % | 10.44 | 10.51 | 10.39 | 10.44 | 10.39 | 10.44 | 10.44 | 10.44 | 10.44 | 10.44 |
PV UFCF | ||||||||||
SUM PV UFCF | 60.7 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 18 | |||||||||
Terminal Value | 215 | |||||||||
Present Terminal Value | 131 | |||||||||
Enterprise Value | 192 | |||||||||
Net Debt | 14 | |||||||||
Equity Value | 178 | |||||||||
Diluted Shares Outstanding, MM | 8 | |||||||||
Equity Value Per Share | 23.29 |
What You Will Receive
- Adjustable Forecast Inputs: Effortlessly modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: First Community Corporation’s (FCCO) financial data pre-loaded to facilitate your analysis.
- Automated DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A sleek Excel model tailored to fit your valuation requirements.
- Designed for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Comprehensive Financial Insights: Gain access to reliable pre-loaded historical data and future forecasts for First Community Corporation (FCCO).
- Adjustable Projection Parameters: Modify highlighted cells for key metrics like WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic revisions to DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Intuitive charts and summaries to help you easily interpret your valuation outcomes.
- Designed for All Skill Levels: A straightforward, user-friendly format tailored for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the prebuilt Excel template containing First Community Corporation’s (FCCO) data.
- Step 2: Review the pre-filled sheets to familiarize yourself with the key performance indicators.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see the updated results, including First Community Corporation’s intrinsic value.
- Step 5: Make well-informed investment decisions or create reports based on the outputs.
Why Choose First Community Corporation (FCCO)?
- Community Focused: Committed to serving the financial needs of our local communities.
- Expert Guidance: Our team of professionals offers personalized support to help you navigate your financial journey.
- Innovative Solutions: We provide a range of products tailored to meet diverse client needs.
- Proven Track Record: A history of financial stability and growth that you can rely on.
- Customer-Centric Approach: We prioritize our customers, ensuring satisfaction and trust in every interaction.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling First Community Corporation (FCCO) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for First Community Corporation (FCCO).
- Consultants: Deliver professional valuation insights on First Community Corporation (FCCO) to clients quickly and accurately.
- Business Owners: Understand how community banks like First Community Corporation (FCCO) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to First Community Corporation (FCCO).
What the Template Contains
- Historical Data: Includes First Community Corporation’s (FCCO) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate First Community Corporation’s (FCCO) intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of First Community Corporation’s (FCCO) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.