ChoiceOne Financial Services, Inc. (COFS) 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
ChoiceOne Financial Services, Inc. (COFS) Bundle
Explore ChoiceOne Financial Services, Inc. (COFS) financial future with our user-friendly DCF Calculator! Enter your projections for growth, margins, and costs to determine ChoiceOne Financial Services, Inc. (COFS) intrinsic value and inform your investment strategy.
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 | 36.9 | 73.8 | 79.8 | 81.4 | 80.6 | 102.7 | 130.7 | 166.4 | 211.8 | 269.6 |
Revenue Growth, % | 0 | 99.95 | 8.22 | 1.94 | -0.91539 | 27.3 | 27.3 | 27.3 | 27.3 | 27.3 |
EBITDA | 11.6 | 26.6 | 38.9 | 41.0 | .0 | 34.2 | 43.5 | 55.4 | 70.6 | 89.8 |
EBITDA, % | 31.42 | 36.05 | 48.75 | 50.38 | 0 | 33.32 | 33.32 | 33.32 | 33.32 | 33.32 |
Depreciation | 2.0 | 4.2 | 3.9 | 3.8 | .0 | 4.2 | 5.4 | 6.9 | 8.7 | 11.1 |
Depreciation, % | 5.32 | 5.72 | 4.92 | 4.68 | 0 | 4.13 | 4.13 | 4.13 | 4.13 | 4.13 |
EBIT | 9.6 | 22.4 | 35.0 | 37.2 | .0 | 30.0 | 38.1 | 48.6 | 61.8 | 78.7 |
EBIT, % | 26.1 | 30.33 | 43.83 | 45.69 | 0 | 29.19 | 29.19 | 29.19 | 29.19 | 29.19 |
Total Cash | 398.2 | 654.3 | 1,130.8 | 590.8 | 569.7 | 102.7 | 130.7 | 166.4 | 211.8 | 269.6 |
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 | -.8 | -1.9 | -2.8 | -1.2 | -4.2 | -3.0 | -3.8 | -4.9 | -6.2 | -7.9 |
Capital Expenditure, % | -2.08 | -2.51 | -3.46 | -1.43 | -5.25 | -2.94 | -2.94 | -2.94 | -2.94 | -2.94 |
Tax Rate, % | 16.84 | 16.84 | 16.84 | 16.84 | 16.84 | 16.84 | 16.84 | 16.84 | 16.84 | 16.84 |
EBITAT | 8.2 | 18.5 | 29.1 | 31.8 | .0 | 25.1 | 32.0 | 40.7 | 51.8 | 66.0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 9.4 | 20.9 | 30.3 | 34.4 | -4.2 | 26.3 | 33.5 | 42.7 | 54.3 | 69.2 |
WACC, % | 9.52 | 9.39 | 9.42 | 9.57 | 9.42 | 9.47 | 9.47 | 9.47 | 9.47 | 9.47 |
PV UFCF | ||||||||||
SUM PV UFCF | 166.4 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 71 | |||||||||
Terminal Value | 945 | |||||||||
Present Terminal Value | 601 | |||||||||
Enterprise Value | 768 | |||||||||
Net Debt | 180 | |||||||||
Equity Value | 588 | |||||||||
Diluted Shares Outstanding, MM | 8 | |||||||||
Equity Value Per Share | 77.59 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to develop various scenarios.
- Real-World Data: ChoiceOne Financial Services, Inc. (COFS) financial data pre-filled to kickstart your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A refined Excel model that adjusts to your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Customizable Financial Inputs: Adjust essential metrics such as loan growth, interest rates, and operating expenses.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and additional financial metrics.
- High Precision Results: Incorporates ChoiceOne Financial Services’ actual financial data for accurate valuation insights.
- Simplified Scenario Testing: Easily evaluate various assumptions and analyze different outcomes.
- Efficiency Booster: Streamline the valuation process without the hassle of creating intricate models from the ground up.
How It Works
- Download: Obtain the ready-to-use Excel file featuring ChoiceOne Financial Services, Inc. (COFS) financial data.
- Customize: Modify forecasts such as revenue growth, EBITDA %, and WACC to suit your analysis.
- Update Automatically: Watch as intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various projections and instantly compare their outcomes.
- Make Decisions: Utilize the valuation results to inform your investment strategy.
Why Choose ChoiceOne Financial Services, Inc. (COFS)?
- Save Time: Access ready-to-use financial tools without the hassle of building from the ground up.
- Enhance Accuracy: Utilize dependable financial data and formulas to minimize valuation errors.
- Fully Customizable: Adjust the tools to align with your specific assumptions and forecasts.
- Easy to Understand: Intuitive charts and outputs simplify the analysis of results.
- Endorsed by Professionals: Crafted for experts who prioritize precision and user-friendliness.
Who Should Use This Product?
- Investors: Assess ChoiceOne Financial Services, Inc.'s (COFS) performance before making investment decisions.
- CFOs and Financial Analysts: Optimize financial assessments and validate forecasts for the company.
- Startup Founders: Understand the valuation methods applied to established financial services like ChoiceOne.
- Consultants: Provide detailed valuation analyses and reports to clients in the financial sector.
- Students and Educators: Utilize current financial data to enhance learning and teaching of valuation principles.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations tailored for ChoiceOne Financial Services, Inc. (COFS).
- Real-World Data: ChoiceOne's historical and projected financials preloaded for thorough analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into financial performance.
- Key Ratios: Integrated analysis covering profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables presenting clear, actionable results for decision-making.