|
National Bank Holdings Corporation (NBHC) DCF Valuation
US | Financial Services | Banks - Regional | NYSE
|
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
National Bank Holdings Corporation (NBHC) Bundle
Explore the financial outlook of National Bank Holdings Corporation (NBHC) with our user-friendly DCF Calculator! Enter your growth, margin, and cost assumptions to calculate the intrinsic value of National Bank Holdings Corporation (NBHC) and enhance 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 | 295.8 | 333.2 | 298.0 | 340.3 | 417.6 | 458.3 | 502.9 | 552.0 | 605.8 | 664.8 |
Revenue Growth, % | 0 | 12.67 | -10.58 | 14.2 | 22.7 | 9.75 | 9.75 | 9.75 | 9.75 | 9.75 |
EBITDA | 111.2 | 123.8 | 128.6 | 102.6 | .0 | 135.7 | 148.9 | 163.5 | 179.4 | 196.9 |
EBITDA, % | 37.61 | 37.16 | 43.14 | 30.16 | 0 | 29.61 | 29.61 | 29.61 | 29.61 | 29.61 |
Depreciation | 9.4 | 9.3 | 8.5 | 10.7 | .0 | 11.0 | 12.0 | 13.2 | 14.5 | 15.9 |
Depreciation, % | 3.17 | 2.79 | 2.85 | 3.16 | 0 | 2.39 | 2.39 | 2.39 | 2.39 | 2.39 |
EBIT | 101.8 | 114.6 | 120.1 | 91.9 | .0 | 124.8 | 136.9 | 150.3 | 164.9 | 181.0 |
EBIT, % | 34.43 | 34.38 | 40.3 | 27 | 0 | 27.22 | 27.22 | 27.22 | 27.22 | 27.22 |
Total Cash | 748.4 | 1,267.5 | 1,537.5 | 901.8 | 190.8 | 408.5 | 448.3 | 492.0 | 540.0 | 592.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 | -11.2 | -4.4 | -5.1 | -12.4 | -36.8 | -17.7 | -19.4 | -21.3 | -23.4 | -25.7 |
Capital Expenditure, % | -3.79 | -1.31 | -1.73 | -3.65 | -8.82 | -3.86 | -3.86 | -3.86 | -3.86 | -3.86 |
Tax Rate, % | 19.11 | 19.11 | 19.11 | 19.11 | 19.11 | 19.11 | 19.11 | 19.11 | 19.11 | 19.11 |
EBITAT | 80.8 | 88.6 | 93.6 | 71.4 | .0 | 98.1 | 107.7 | 118.2 | 129.7 | 142.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 79.0 | 93.6 | 96.9 | 69.7 | -36.8 | 91.4 | 100.3 | 110.1 | 120.8 | 132.6 |
WACC, % | 11.94 | 11.81 | 11.85 | 11.84 | 12.04 | 11.9 | 11.9 | 11.9 | 11.9 | 11.9 |
PV UFCF | ||||||||||
SUM PV UFCF | 393.0 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 135 | |||||||||
Terminal Value | 1,367 | |||||||||
Present Terminal Value | 779 | |||||||||
Enterprise Value | 1,172 | |||||||||
Net Debt | 203 | |||||||||
Equity Value | 969 | |||||||||
Diluted Shares Outstanding, MM | 38 | |||||||||
Equity Value Per Share | 25.42 |
What You Will Get
- Real NBHC Financial Data: Pre-filled with National Bank Holdings Corporation’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See NBHC’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- 🔍 Real-Life NBHC Financials: Pre-filled historical and projected data for National Bank Holdings Corporation (NBHC).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate National Bank Holdings Corporation’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize National Bank Holdings Corporation’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- 1. Access the Template: Download and open the Excel file containing National Bank Holdings Corporation's (NBHC) preloaded financial data.
- 2. Adjust Assumptions: Modify key inputs such as growth rates, WACC, and capital expenditures to fit your analysis.
- 3. View Results Instantly: The DCF model automatically calculates intrinsic value and NPV based on your inputs.
- 4. Explore Scenarios: Evaluate multiple forecasts to assess various valuation outcomes for National Bank Holdings Corporation (NBHC).
- 5. Utilize with Assurance: Deliver professional valuation insights that bolster your decision-making process.
Why Choose This Calculator for National Bank Holdings Corporation (NBHC)?
- Accuracy: Utilizes real NBHC financials to ensure precise data.
- Flexibility: Tailored for users to easily adjust and test different inputs.
- Time-Saving: Eliminate the complexity of creating a DCF model from the ground up.
- Professional-Grade: Crafted with the precision and usability expected at the CFO level.
- User-Friendly: Intuitive interface suitable for users without extensive financial modeling skills.
Who Should Use This Product?
- Institutional Investors: Develop comprehensive and accurate valuation models for assessing investments in National Bank Holdings Corporation (NBHC).
- Corporate Strategy Teams: Evaluate valuation scenarios to inform business strategies within the banking sector.
- Financial Consultants: Deliver precise valuation insights to clients interested in National Bank Holdings Corporation (NBHC).
- Students and Educators: Utilize real-time data to enhance learning and practice in financial modeling.
- Finance Enthusiasts: Gain insights into how banking institutions like National Bank Holdings Corporation (NBHC) are valued in the financial market.
What the Template Contains
- Pre-Filled Data: Includes National Bank Holdings Corporation's (NBHC) historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze National Bank Holdings Corporation's (NBHC) profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.