National Bankshares, Inc. (NKSH) 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
National Bankshares, Inc. (NKSH) Bundle
Evaluate National Bankshares, Inc.'s (NKSH) financial outlook like an expert! This (NKSH) DCF Calculator provides pre-filled financial data while allowing you the flexibility to modify revenue growth, WACC, margins, and other essential 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 | 46.6 | 46.1 | 50.3 | 59.4 | 46.6 | 47.2 | 47.8 | 48.3 | 48.9 | 49.5 |
| Revenue Growth, % | 0 | -0.94937 | 9.11 | 18.11 | -21.51 | 1.19 | 1.19 | 1.19 | 1.19 | 1.19 |
| EBITDA | 21.4 | 19.9 | 25.3 | 32.4 | 19.4 | 22.2 | 22.5 | 22.8 | 23.0 | 23.3 |
| EBITDA, % | 46 | 43.07 | 50.22 | 54.47 | 41.66 | 47.08 | 47.08 | 47.08 | 47.08 | 47.08 |
| Depreciation | .7 | .7 | .6 | .6 | .8 | .7 | .7 | .7 | .7 | .7 |
| Depreciation, % | 1.59 | 1.54 | 1.26 | 1.02 | 1.62 | 1.41 | 1.41 | 1.41 | 1.41 | 1.41 |
| EBIT | 20.7 | 19.2 | 24.6 | 31.8 | 18.7 | 21.6 | 21.8 | 22.1 | 22.3 | 22.6 |
| EBIT, % | 44.41 | 41.54 | 48.96 | 53.45 | 40.04 | 45.68 | 45.68 | 45.68 | 45.68 | 45.68 |
| Total Cash | 522.4 | 680.6 | 824.9 | 728.3 | 631.6 | 47.2 | 47.8 | 48.3 | 48.9 | 49.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 4.3 | 5.0 | 5.1 | 6.0 | 6.3 | 5.1 | 5.1 | 5.2 | 5.3 | 5.3 |
| Account Receivables, % | 9.2 | 10.9 | 10.14 | 10.1 | 13.54 | 10.78 | 10.78 | 10.78 | 10.78 | 10.78 |
| Inventories | -98.0 | -148.7 | -152.5 | -85.7 | .0 | -37.8 | -38.2 | -38.7 | -39.1 | -39.6 |
| Inventories, % | -210.47 | -322.4 | -303 | -144.15 | 0 | -80 | -80 | -80 | -80 | -80 |
| Accounts Payable | .1 | .1 | .0 | .1 | 1.4 | .4 | .4 | .4 | .4 | .4 |
| Accounts Payable, % | 0.3093 | 0.12144 | 0.09539899 | 0.17837 | 3.04 | 0.74808 | 0.74808 | 0.74808 | 0.74808 | 0.74808 |
| Capital Expenditure | -1.0 | -1.8 | -.3 | -1.3 | -1.5 | -1.1 | -1.2 | -1.2 | -1.2 | -1.2 |
| Capital Expenditure, % | -2.22 | -3.96 | -0.64196 | -2.12 | -3.2 | -2.43 | -2.43 | -2.43 | -2.43 | -2.43 |
| Tax Rate, % | 15.98 | 15.98 | 15.98 | 15.98 | 15.98 | 15.98 | 15.98 | 15.98 | 15.98 | 15.98 |
| EBITAT | 17.5 | 16.1 | 20.4 | 25.9 | 15.7 | 18.0 | 18.2 | 18.4 | 18.6 | 18.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 111.0 | 64.8 | 24.4 | -42.3 | -69.7 | 55.4 | 18.1 | 18.3 | 18.5 | 18.7 |
| WACC, % | 17.6 | 17.53 | 17.38 | 17.24 | 17.54 | 17.46 | 17.46 | 17.46 | 17.46 | 17.46 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 89.7 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 19 | |||||||||
| Terminal Value | 124 | |||||||||
| Present Terminal Value | 55 | |||||||||
| Enterprise Value | 145 | |||||||||
| Net Debt | -87 | |||||||||
| Equity Value | 232 | |||||||||
| Diluted Shares Outstanding, MM | 6 | |||||||||
| Equity Value Per Share | 39.33 |
What You Will Get
- Real NKSH Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are calculated in real-time.
- Scenario Analysis: Evaluate various scenarios to assess National Bankshares' future performance.
- User-Friendly Design: Designed for finance professionals while remaining accessible to newcomers.
Key Features
- Customizable Financial Inputs: Adjust essential variables such as loan growth, net interest margin, and operating expenses.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and other financial metrics.
- High Precision Accuracy: Leverages National Bankshares, Inc.'s (NKSH) actual financial data for dependable valuation results.
- Simplified Scenario Analysis: Effortlessly evaluate different scenarios and analyze their impacts.
- Efficiency Booster: Avoid the hassle of constructing intricate valuation models from the ground up.
How It Works
- Download the Template: Gain immediate access to the Excel-based NKSH DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional variables.
- Instant Calculations: The model automatically recalculates National Bankshares, Inc.'s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the findings to inform your investment or financial assessment.
Why Choose This Calculator for National Bankshares, Inc. (NKSH)?
- User-Friendly Interface: Perfect for both novice and experienced users.
- Customizable Inputs: Adjust parameters easily to suit your financial analysis.
- Real-Time Feedback: Observe immediate changes in National Bankshares’ valuation as you modify inputs.
- Pre-Loaded Data: Comes with National Bankshares’ actual financial figures for swift evaluations.
- Relied Upon by Experts: Utilized by investors and financial analysts for making well-informed choices.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for analyzing portfolios involving National Bankshares, Inc. (NKSH).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within their organizations.
- Consultants and Advisors: Deliver precise valuation insights related to National Bankshares, Inc. (NKSH) for their clients.
- Students and Educators: Utilize real-time data to learn and teach financial modeling techniques.
- Banking Enthusiasts: Gain insights into how financial institutions like National Bankshares, Inc. (NKSH) are valued in the marketplace.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled National Bankshares, Inc. (NKSH) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for National Bankshares, Inc. (NKSH).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.