|
Valoración de DCF Independent Bank Corp. (INDB)
US | Financial Services | Banks - Regional | NASDAQ
|
- ✓ 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
Independent Bank Corp. (INDB) Bundle
¡Descubra el verdadero potencial de Independent Bank Corp. (INDB) con nuestra calculadora DCF avanzada! Ajuste los supuestos críticos, explore varios escenarios y evalúe cómo los cambios afectan la valoración de Independent Bank Corp. (INDB), todo dentro de una plantilla de Excel fácil de usar.
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 | 508.4 | 477.5 | 507.4 | 727.9 | 795.7 | 901.1 | 1,020.4 | 1,155.4 | 1,308.4 | 1,481.6 |
Revenue Growth, % | 0 | -6.09 | 6.27 | 43.46 | 9.32 | 13.24 | 13.24 | 13.24 | 13.24 | 13.24 |
EBITDA | 238.8 | 174.4 | 189.5 | 386.6 | .0 | 313.5 | 355.0 | 402.0 | 455.2 | 515.4 |
EBITDA, % | 46.97 | 36.53 | 37.35 | 53.1 | 0 | 34.79 | 34.79 | 34.79 | 34.79 | 34.79 |
Depreciation | 18.2 | 19.0 | 18.2 | 26.1 | .0 | 26.5 | 30.1 | 34.0 | 38.5 | 43.6 |
Depreciation, % | 3.58 | 3.98 | 3.59 | 3.58 | 0 | 2.95 | 2.95 | 2.95 | 2.95 | 2.95 |
EBIT | 220.6 | 155.4 | 171.3 | 360.5 | .0 | 286.9 | 324.9 | 367.9 | 416.6 | 471.8 |
EBIT, % | 43.39 | 32.55 | 33.76 | 49.52 | 0 | 31.84 | 31.84 | 31.84 | 31.84 | 31.84 |
Total Cash | 577.4 | 1,709.5 | 3,811.8 | 1,752.1 | 224.3 | 771.7 | 873.8 | 989.5 | 1,120.5 | 1,268.8 |
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 | -16.6 | -12.6 | -25.2 | -22.1 | -15.8 | -28.6 | -32.4 | -36.7 | -41.6 | -47.1 |
Capital Expenditure, % | -3.26 | -2.64 | -4.97 | -3.03 | -1.99 | -3.18 | -3.18 | -3.18 | -3.18 | -3.18 |
Tax Rate, % | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 |
EBITAT | 167.1 | 123.2 | 132.3 | 273.5 | .0 | 220.4 | 249.6 | 282.6 | 320.1 | 362.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 168.7 | 129.6 | 125.3 | 277.5 | -15.8 | 218.3 | 247.2 | 280.0 | 317.0 | 359.0 |
WACC, % | 9.09 | 9.25 | 9.16 | 9.1 | 9.1 | 9.14 | 9.14 | 9.14 | 9.14 | 9.14 |
PV UFCF | ||||||||||
SUM PV UFCF | 1,078.2 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 366 | |||||||||
Terminal Value | 5,129 | |||||||||
Present Terminal Value | 3,312 | |||||||||
Enterprise Value | 4,390 | |||||||||
Net Debt | 1,050 | |||||||||
Equity Value | 3,340 | |||||||||
Diluted Shares Outstanding, MM | 44 | |||||||||
Equity Value Per Share | 75.57 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled financials for Independent Bank Corp. (INDB).
- Real-World Data: Access to 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: Quickly observe how your inputs affect the valuation of Independent Bank Corp. (INDB).
- 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 INDB Data: Pre-loaded with Independent Bank Corp.'s historical financial performance and future projections.
- Customizable Assumptions: Modify revenue growth rates, profit margins, discount rates, tax implications, and capital investments.
- Interactive Valuation Tool: Automatically refreshes Net Present Value (NPV) and intrinsic value based on user-defined parameters.
- Scenario Analysis: Develop various forecasting scenarios to explore different valuation possibilities.
- Intuitive Interface: Designed for ease of use, suitable for both industry experts and newcomers.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Independent Bank Corp. (INDB) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Independent Bank Corp.'s (INDB) intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Independent Bank Corp. (INDB)?
- Accuracy: Utilizes real Independent Bank Corp. financials for precise data.
- Flexibility: Built to allow users to experiment and adjust inputs as needed.
- Time-Saving: Avoid the complications of constructing a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected at the CFO level.
- User-Friendly: Designed for ease of use, suitable for individuals without extensive financial modeling skills.
Who Should Use Independent Bank Corp. (INDB)?
- Investors: Gain insights and make informed investment choices with our comprehensive banking services.
- Financial Analysts: Streamline your analysis with tailored financial products designed for efficiency.
- Consultants: Easily customize our offerings for client presentations and financial assessments.
- Banking Enthusiasts: Enhance your knowledge of banking operations and market trends through our resources.
- Educators and Students: Utilize our services as a practical resource for finance and banking education.
What the Template Contains
- Pre-Filled Data: Contains Independent Bank Corp.'s (INDB) historical financials and projections.
- Discounted Cash Flow Model: An editable DCF valuation model featuring automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated worksheet for calculating WACC using custom inputs.
- Key Financial Ratios: Evaluate Independent Bank Corp.'s (INDB) profitability, efficiency, and leverage.
- Customizable Inputs: Easily modify revenue growth, margins, and tax rates.
- Clear Dashboard: Visualizations and tables summarizing essential valuation outcomes.