|
Valoración de DCF de Investigar Holding Corporation (ISTR)
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
Investar Holding Corporation (ISTR) Bundle
¡Descubra el verdadero valor de Investigar Holding Corporation (ISTR) con nuestra calculadora DCF avanzada! Ajuste los supuestos esenciales, explore varios escenarios y evalúe cómo los cambios afectan la valoración de Investigar Holding Corporation (ISTR), todo convenientemente dentro de una sola plantilla de Excel.
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 | 71.0 | 85.7 | 96.3 | 108.4 | 83.1 | 87.7 | 92.5 | 97.7 | 103.1 | 108.8 |
| Revenue Growth, % | 0 | 20.58 | 12.37 | 12.6 | -23.37 | 5.54 | 5.54 | 5.54 | 5.54 | 5.54 |
| EBITDA | 24.4 | 21.9 | 14.9 | 48.8 | .0 | 21.1 | 22.3 | 23.5 | 24.8 | 26.2 |
| EBITDA, % | 34.37 | 25.57 | 15.48 | 45.01 | 0 | 24.09 | 24.09 | 24.09 | 24.09 | 24.09 |
| Depreciation | 3.5 | 4.6 | 5.0 | 4.4 | 3.8 | 4.2 | 4.4 | 4.7 | 5.0 | 5.2 |
| Depreciation, % | 4.87 | 5.33 | 5.18 | 4.09 | 4.55 | 4.81 | 4.81 | 4.81 | 4.81 | 4.81 |
| EBIT | 21.0 | 17.3 | 9.9 | 44.3 | -3.8 | 16.9 | 17.8 | 18.8 | 19.9 | 21.0 |
| EBIT, % | 29.5 | 20.24 | 10.29 | 40.91 | -4.55 | 19.28 | 19.28 | 19.28 | 19.28 | 19.28 |
| Total Cash | 304.1 | 303.8 | 452.1 | 445.2 | 390.2 | 87.7 | 92.5 | 97.7 | 103.1 | 108.8 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 7.9 | 13.0 | 11.4 | 12.7 | 14.4 | 11.8 | 12.4 | 13.1 | 13.8 | 14.6 |
| Account Receivables, % | 11.14 | 15.14 | 11.8 | 11.76 | 17.3 | 13.43 | 13.43 | 13.43 | 13.43 | 13.43 |
| Inventories | -52.7 | -49.0 | -111.0 | -53.7 | .0 | -49.3 | -52.0 | -54.9 | -57.9 | -61.1 |
| Inventories, % | -74.24 | -57.2 | -115.36 | -49.53 | 0 | -56.19 | -56.19 | -56.19 | -56.19 | -56.19 |
| 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 | -7.9 | -7.6 | -3.3 | -1.1 | -1.1 | -4.5 | -4.8 | -5.0 | -5.3 | -5.6 |
| Capital Expenditure, % | -11.15 | -8.86 | -3.45 | -0.97423 | -1.29 | -5.14 | -5.14 | -5.14 | -5.14 | -5.14 |
| Tax Rate, % | 18.36 | 18.36 | 18.36 | 18.36 | 18.36 | 18.36 | 18.36 | 18.36 | 18.36 | 18.36 |
| EBITAT | 16.8 | 13.9 | 8.0 | 35.7 | -3.1 | 13.6 | 14.4 | 15.2 | 16.0 | 16.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 57.2 | 2.1 | 73.3 | -19.7 | -55.7 | 65.2 | 16.2 | 17.1 | 18.0 | 19.0 |
| WACC, % | 12.78 | 12.76 | 12.83 | 12.8 | 12.93 | 12.82 | 12.82 | 12.82 | 12.82 | 12.82 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 103.9 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 19 | |||||||||
| Terminal Value | 179 | |||||||||
| Present Terminal Value | 98 | |||||||||
| Enterprise Value | 202 | |||||||||
| Net Debt | 257 | |||||||||
| Equity Value | -55 | |||||||||
| Diluted Shares Outstanding, MM | 10 | |||||||||
| Equity Value Per Share | -5.60 |
What You Will Receive
- Authentic Investar Data: Preloaded financials – encompassing revenue to EBIT – derived from real and projected figures.
- Complete Customization: Modify all essential parameters (yellow cells) such as WACC, growth %, and tax rates.
- Instant Valuation Adjustments: Automatic recalculations to assess the effects of changes on Investar Holding Corporation’s (ISTR) fair value.
- Flexible Excel Template: Designed for quick modifications, scenario analysis, and comprehensive projections.
- Efficient and Precise: Avoid the hassle of building models from the ground up while ensuring accuracy and adaptability.
Key Features
- Comprehensive Financial Data: Gain access to reliable pre-loaded historical information and future estimates for Investar Holding Corporation (ISTR).
- Adjustable Forecast Parameters: Modify the highlighted cells for WACC, growth rates, and profit margins to suit your analysis.
- Real-Time Calculations: Enjoy automatic updates for DCF, Net Present Value (NPV), and cash flow evaluations.
- User-Friendly Dashboard: View clear charts and summaries to easily interpret your valuation findings.
- Suitable for All Skill Levels: Designed with a straightforward, intuitive layout for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Investar Holding Corporation (ISTR) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Investar Holding Corporation's (ISTR) intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Investar Holding Corporation (ISTR)?
- All-in-One Solution: Offers DCF, WACC, and financial ratio analyses tailored for Investar Holding Corporation (ISTR).
- Flexible Parameters: Modify the highlighted cells to explore different financial scenarios.
- In-Depth Analysis: Automatically computes the intrinsic value and Net Present Value for Investar Holding Corporation (ISTR).
- Preloaded Information: Historical and projected data provide a solid foundation for analysis.
- Expert-Level Tool: Perfect for financial analysts, investors, and business advisors focusing on Investar Holding Corporation (ISTR).
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Investar Holding Corporation (ISTR) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models specific to Investar Holding Corporation (ISTR).
- Consultants: Deliver professional valuation insights on Investar Holding Corporation (ISTR) to clients quickly and accurately.
- Business Owners: Understand how companies like Investar Holding Corporation (ISTR) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Investar Holding Corporation (ISTR).
What the Template Contains
- Historical Data: Includes Investar Holding Corporation’s (ISTR) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Investar Holding Corporation’s (ISTR) 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 Investar Holding Corporation’s (ISTR) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.