National Bank Holdings Corporation (NBHC) DCF Valuation

National Bank Holdings Corporation (NBHC) DCF Valuation

US | Financial Services | Banks - Regional | NYSE
National Bank Holdings Corporation (NBHC) DCF Valuation
  • 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

Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

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
Account Receivables, % 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.