Nicolet Bankshares, Inc. (NIC) 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
Nicolet Bankshares, Inc. (NIC) Bundle
Designed for accuracy, our (NIC) DCF Calculator enables you to evaluate Nicolet Bankshares, Inc. valuation using real-world financial data, offering complete flexibility to modify all key parameters for improved 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 | 169.9 | 192.0 | 225.3 | 297.9 | 272.5 | 309.3 | 351.1 | 398.6 | 452.4 | 513.5 |
| Revenue Growth, % | 0 | 12.99 | 17.38 | 32.2 | -8.52 | 13.51 | 13.51 | 13.51 | 13.51 | 13.51 |
| EBITDA | 78.8 | 91.6 | 95.0 | 147.7 | 105.0 | 138.8 | 157.6 | 178.8 | 203.0 | 230.4 |
| EBITDA, % | 46.36 | 47.73 | 42.15 | 49.57 | 38.55 | 44.87 | 44.87 | 44.87 | 44.87 | 44.87 |
| Depreciation | 7.7 | 8.0 | 8.5 | 14.2 | 18.4 | 14.8 | 16.8 | 19.1 | 21.7 | 24.6 |
| Depreciation, % | 4.52 | 4.15 | 3.77 | 4.77 | 6.75 | 4.79 | 4.79 | 4.79 | 4.79 | 4.79 |
| EBIT | 71.1 | 83.7 | 86.5 | 133.5 | 86.6 | 124.0 | 140.7 | 159.7 | 181.3 | 205.8 |
| EBIT, % | 41.84 | 43.58 | 38.38 | 44.8 | 31.79 | 40.08 | 40.08 | 40.08 | 40.08 | 40.08 |
| Total Cash | 650.7 | 1,342.2 | 1,538.9 | 1,084.9 | 1,294.0 | 309.3 | 351.1 | 398.6 | 452.4 | 513.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .0 | .0 | .0 | .0 | 133.7 | 30.4 | 34.5 | 39.1 | 44.4 | 50.4 |
| Account Receivables, % | 0 | 0 | 0 | 0 | 49.08 | 9.82 | 9.82 | 9.82 | 9.82 | 9.82 |
| Inventories | -201.4 | -841.7 | -832.6 | -180.9 | .0 | -223.2 | -253.3 | -287.5 | -326.4 | -370.5 |
| Inventories, % | -118.52 | -438.46 | -369.54 | -60.73 | 0 | -72.15 | -72.15 | -72.15 | -72.15 | -72.15 |
| Accounts Payable | 38.2 | 48.3 | 68.7 | 70.2 | .0 | 62.9 | 71.4 | 81.1 | 92.0 | 104.5 |
| Accounts Payable, % | 22.48 | 25.18 | 30.5 | 23.56 | 0 | 20.34 | 20.34 | 20.34 | 20.34 | 20.34 |
| Capital Expenditure | -4.4 | -10.8 | -12.8 | -12.2 | -18.2 | -15.3 | -17.3 | -19.7 | -22.3 | -25.3 |
| Capital Expenditure, % | -2.59 | -5.62 | -5.68 | -4.11 | -6.68 | -4.93 | -4.93 | -4.93 | -4.93 | -4.93 |
| Tax Rate, % | 28.99 | 28.99 | 28.99 | 28.99 | 28.99 | 28.99 | 28.99 | 28.99 | 28.99 | 28.99 |
| EBITAT | 54.4 | 62.1 | 64.7 | 100.0 | 61.5 | 92.1 | 104.6 | 118.7 | 134.7 | 152.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 297.2 | 709.8 | 71.7 | -548.3 | -323.1 | 481.1 | 138.6 | 157.3 | 178.6 | 202.7 |
| WACC, % | 13.42 | 13.24 | 13.28 | 13.29 | 12.97 | 13.24 | 13.24 | 13.24 | 13.24 | 13.24 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 858.8 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 207 | |||||||||
| Terminal Value | 1,840 | |||||||||
| Present Terminal Value | 988 | |||||||||
| Enterprise Value | 1,847 | |||||||||
| Net Debt | -325 | |||||||||
| Equity Value | 2,171 | |||||||||
| Diluted Shares Outstanding, MM | 15 | |||||||||
| Equity Value Per Share | 144.08 |
What You Will Get
- Editable Forecast Inputs: Effortlessly adjust key assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Nicolet Bankshares, Inc.'s (NIC) financial data pre-filled to facilitate your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A refined Excel model that caters to your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for Nicolet Bankshares, Inc. (NIC).
- WACC Calculator: Features a pre-built Weighted Average Cost of Capital sheet with adjustable inputs specific to the banking sector.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to reflect Nicolet Bankshares' financial strategies.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to Nicolet Bankshares, Inc. (NIC).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.
How It Works
- Download: Obtain the pre-prepared Excel file containing Nicolet Bankshares, Inc. (NIC) financial data.
- Customize: Modify projections, such as revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various projections and instantly compare the results.
- Make Decisions: Utilize the valuation outputs to inform your investment strategy.
Why Choose Nicolet Bankshares, Inc. (NIC)?
- Save Time: No need to navigate complex banking processes – our services are streamlined for your convenience.
- Enhance Financial Security: Our robust systems and expert team ensure your investments are well-protected.
- Completely Tailored Solutions: Customize banking services to align with your unique financial goals.
- User-Friendly Experience: Intuitive interfaces and clear communications make banking straightforward.
- Endorsed by Professionals: Trusted by industry experts for our commitment to excellence and customer satisfaction.
Who Should Use This Product?
- Investors: Accurately estimate Nicolet Bankshares, Inc.'s (NIC) fair value before making investment decisions.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis related to Nicolet Bankshares, Inc. (NIC).
- Consultants: Quickly customize the template for valuation reports for clients involving Nicolet Bankshares, Inc. (NIC).
- Entrepreneurs: Gain insights into financial modeling practices used by leading financial institutions like Nicolet Bankshares, Inc. (NIC).
- Educators: Employ it as a teaching tool to illustrate valuation methodologies relevant to Nicolet Bankshares, Inc. (NIC).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Nicolet Bankshares, Inc. (NIC) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), encompassing parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models demonstrating intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to facilitate analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Nicolet Bankshares, Inc. (NIC).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions for easy analysis of results.