First Internet Bancorp (INBK) 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
First Internet Bancorp (INBK) Bundle
Evaluate First Internet Bancorp's financial outlook like an expert! This INBK DCF Calculator comes with pre-filled financial data and offers full flexibility to modify revenue growth, WACC, margins, and other critical assumptions to align with your 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 | 73.8 | 91.6 | 118.4 | 113.4 | 84.4 | 89.3 | 94.6 | 100.2 | 106.1 | 112.3 |
| Revenue Growth, % | 0 | 24.07 | 29.29 | -4.22 | -25.58 | 5.89 | 5.89 | 5.89 | 5.89 | 5.89 |
| EBITDA | -1.9 | 41.7 | 65.3 | 48.8 | .0 | 25.2 | 26.7 | 28.3 | 30.0 | 31.7 |
| EBITDA, % | -2.58 | 45.58 | 55.21 | 43.07 | 0 | 28.26 | 28.26 | 28.26 | 28.26 | 28.26 |
| Depreciation | 7.7 | 7.8 | 8.8 | 8.7 | 5.7 | 7.3 | 7.7 | 8.2 | 8.7 | 9.2 |
| Depreciation, % | 10.37 | 8.55 | 7.41 | 7.7 | 6.81 | 8.17 | 8.17 | 8.17 | 8.17 | 8.17 |
| EBIT | -9.6 | 33.9 | 56.6 | 40.1 | -5.7 | 17.9 | 19.0 | 20.1 | 21.3 | 22.6 |
| EBIT, % | -12.95 | 37.03 | 47.79 | 35.37 | -6.81 | 20.08 | 20.08 | 20.08 | 20.08 | 20.08 |
| Total Cash | 868.2 | 917.4 | 1,046.0 | 646.9 | 880.8 | 89.3 | 94.6 | 100.2 | 106.1 | 112.3 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 1,081.6 | 1,031.9 | 928.7 | 21.1 | 26.7 | 62.6 | 66.3 | 70.2 | 74.3 | 78.7 |
| Account Receivables, % | 1465.72 | 1127.11 | 784.61 | 18.58 | 31.7 | 70.06 | 70.06 | 70.06 | 70.06 | 70.06 |
| Inventories | -348.0 | -437.2 | -460.2 | .0 | .0 | -53.6 | -56.8 | -60.1 | -63.7 | -67.4 |
| Inventories, % | -471.65 | -477.57 | -388.77 | 0 | 0 | -60 | -60 | -60 | -60 | -60 |
| Accounts Payable | 3.8 | 1.4 | 2.0 | 2.9 | 3.8 | 2.8 | 2.9 | 3.1 | 3.3 | 3.5 |
| Accounts Payable, % | 5.11 | 1.57 | 1.7 | 2.57 | 4.56 | 3.1 | 3.1 | 3.1 | 3.1 | 3.1 |
| Capital Expenditure | -4.1 | -25.6 | -29.9 | -17.5 | -5.4 | -14.4 | -15.2 | -16.1 | -17.1 | -18.1 |
| Capital Expenditure, % | -5.56 | -27.92 | -25.25 | -15.45 | -6.36 | -16.11 | -16.11 | -16.11 | -16.11 | -16.11 |
| Tax Rate, % | -70.38 | -70.38 | -70.38 | -70.38 | -70.38 | -70.38 | -70.38 | -70.38 | -70.38 | -70.38 |
| EBITAT | -8.9 | 29.5 | 48.1 | 35.5 | -9.8 | 16.3 | 17.2 | 18.3 | 19.3 | 20.5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -735.1 | 148.2 | 153.7 | 475.1 | -14.2 | 25.9 | 9.4 | 9.9 | 10.5 | 11.1 |
| WACC, % | 17.01 | 16.05 | 15.76 | 16.33 | 18.12 | 16.65 | 16.65 | 16.65 | 16.65 | 16.65 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 46.1 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 11 | |||||||||
| Terminal Value | 77 | |||||||||
| Present Terminal Value | 36 | |||||||||
| Enterprise Value | 82 | |||||||||
| Net Debt | 314 | |||||||||
| Equity Value | -232 | |||||||||
| Diluted Shares Outstanding, MM | 9 | |||||||||
| Equity Value Per Share | -26.18 |
What You Will Get
- Real First Internet Bancorp Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on First Internet Bancorp’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections.
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility.
Key Features
- Comprehensive Financial Data: Get reliable pre-loaded historical figures and future forecasts for First Internet Bancorp (INBK).
- Adjustable Forecast Parameters: Modify highlighted cells to tailor your assumptions on WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Clear charts and summaries to help you easily interpret your valuation outcomes.
- Designed for All Skill Levels: An intuitive layout suitable for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered First Internet Bancorp (INBK) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for First Internet Bancorp’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator?
- User-Friendly Interface: Perfect for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters easily to suit your financial analysis needs.
- Real-Time Feedback: Observe immediate changes in First Internet Bancorp’s valuation with input adjustments.
- Preloaded Data: Comes equipped with First Internet Bancorp’s actual financial metrics for efficient evaluation.
- Relied Upon by Experts: Favored by investors and analysts for making insightful financial decisions.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for assessing portfolio performance in First Internet Bancorp (INBK).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within their organizations.
- Consultants and Advisors: Deliver precise valuation insights to clients interested in First Internet Bancorp (INBK) stock.
- Students and Educators: Utilize real-world financial data to enhance learning and practice in financial modeling.
- Banking Enthusiasts: Gain insights into how financial institutions like First Internet Bancorp (INBK) are valued within the industry.
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations tailored for First Internet Bancorp (INBK).
- Real-World Data: First Internet Bancorp’s historical and projected financials preloaded for analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to test various scenarios.
- Financial Statements: Full annual and quarterly breakdowns for deeper insights into First Internet Bancorp (INBK).
- Key Ratios: Built-in analysis for profitability, efficiency, and leverage specific to First Internet Bancorp (INBK).
- Dashboard with Visual Outputs: Charts and tables for clear, actionable results regarding First Internet Bancorp (INBK).