Peoples Bancorp of North Carolina, Inc. (PEBK) 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
Peoples Bancorp of North Carolina, Inc. (PEBK) Bundle
Whether you’re an investor or analyst, this (PEBK) DCF Calculator is your go-to resource for accurate valuation. Preloaded with real data from Peoples Bancorp of North Carolina, Inc., you can adjust forecasts and instantly observe the effects.
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 | 60.2 | 61.8 | 61.8 | 1.1 | 76.1 | 76.9 | 77.8 | 78.7 | 79.6 | 80.5 |
| Revenue Growth, % | 0 | 2.66 | 0.03076325 | -98.16 | 6578.4 | 1.13 | 1.13 | 1.13 | 1.13 | 1.13 |
| EBITDA | 21.2 | 16.8 | 24.5 | 26.3 | .0 | 31.1 | 31.4 | 31.8 | 32.2 | 32.5 |
| EBITDA, % | 35.18 | 27.24 | 39.65 | 2311.33 | 0 | 40.42 | 40.42 | 40.42 | 40.42 | 40.42 |
| Depreciation | 4.0 | 4.2 | 5.6 | 6.0 | 3.1 | 19.5 | 19.7 | 19.9 | 20.1 | 20.4 |
| Depreciation, % | 6.59 | 6.77 | 9.01 | 529.5 | 4.11 | 25.3 | 25.3 | 25.3 | 25.3 | 25.3 |
| EBIT | 17.2 | 12.6 | 18.9 | 20.3 | -3.1 | 27.0 | 27.3 | 27.6 | 27.9 | 28.3 |
| EBIT, % | 28.59 | 20.47 | 30.64 | 1781.83 | -4.11 | 35.12 | 35.12 | 35.12 | 35.12 | 35.12 |
| Total Cash | 244.8 | 406.8 | 684.0 | 517.0 | 82.4 | 76.9 | 77.8 | 78.7 | 79.6 | 80.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 20.0 | 20.4 | 23.9 | 37.9 | .0 | 31.5 | 31.9 | 32.2 | 32.6 | 33.0 |
| Account Receivables, % | 33.22 | 33.08 | 38.62 | 3330.29 | 0 | 40.98 | 40.98 | 40.98 | 40.98 | 40.98 |
| Inventories | -52.4 | -161.7 | -277.5 | -76.7 | .0 | -59.6 | -60.2 | -60.9 | -61.6 | -62.3 |
| Inventories, % | -87.08 | -261.82 | -449.17 | -6735.03 | 0 | -77.42 | -77.42 | -77.42 | -77.42 | -77.42 |
| Accounts Payable | 10.8 | 10.1 | 11.8 | 12.2 | .0 | 23.6 | 23.9 | 24.1 | 24.4 | 24.7 |
| Accounts Payable, % | 17.88 | 16.28 | 19.17 | 1069.36 | 0 | 30.67 | 30.67 | 30.67 | 30.67 | 30.67 |
| Capital Expenditure | -2.8 | -2.5 | -.5 | -4.6 | -1.9 | -17.2 | -17.4 | -17.6 | -17.8 | -18.0 |
| Capital Expenditure, % | -4.71 | -4.03 | -0.78341 | -400.61 | -2.56 | -22.42 | -22.42 | -22.42 | -22.42 | -22.42 |
| Tax Rate, % | 21.97 | 21.97 | 21.97 | 21.97 | 21.97 | 21.97 | 21.97 | 21.97 | 21.97 | 21.97 |
| EBITAT | 14.1 | 10.4 | 15.1 | 16.1 | -2.4 | 21.7 | 21.9 | 22.2 | 22.4 | 22.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 58.4 | 120.2 | 134.4 | -196.9 | -52.2 | 75.5 | 24.7 | 25.0 | 25.3 | 25.6 |
| WACC, % | 13.56 | 13.59 | 13.41 | 13.36 | 13.24 | 13.43 | 13.43 | 13.43 | 13.43 | 13.43 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 131.9 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 26 | |||||||||
| Terminal Value | 228 | |||||||||
| Present Terminal Value | 122 | |||||||||
| Enterprise Value | 254 | |||||||||
| Net Debt | -62 | |||||||||
| Equity Value | 316 | |||||||||
| Diluted Shares Outstanding, MM | 6 | |||||||||
| Equity Value Per Share | 56.25 |
What You Will Get
- Real PEBK Financial Data: Pre-filled with Peoples Bancorp of North Carolina'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 Peoples Bancorp'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
- Comprehensive Financial Data: Peoples Bancorp of North Carolina, Inc.'s (PEBK) historical financial statements and detailed forecasts.
- Customizable Parameters: Adjust inputs for WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Valuation: Instantly view the intrinsic value of Peoples Bancorp of North Carolina, Inc. (PEBK) as it updates live.
- Intuitive Visualizations: Dashboard graphs present valuation outcomes and essential metrics clearly.
- Designed for Precision: A reliable tool tailored for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the prebuilt Excel template featuring Peoples Bancorp of North Carolina, Inc. (PEBK) data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Adjust forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view updated results, including the intrinsic value of Peoples Bancorp of North Carolina, Inc. (PEBK).
- Step 5: Utilize the outputs to make informed investment decisions or create detailed reports.
Why Choose This Calculator for Peoples Bancorp of North Carolina, Inc. (PEBK)?
- Accurate Data: Utilize real financial figures from Peoples Bancorp for dependable valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations streamline the process, so you don’t have to start from scratch.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants focusing on PEBK.
- User-Friendly: A clear layout and step-by-step guidance make it accessible for all users.
Who Should Use This Product?
- Finance Students: Explore banking fundamentals and apply them using real data from Peoples Bancorp of North Carolina, Inc. (PEBK).
- Academics: Integrate banking models into your curriculum or research projects.
- Investors: Evaluate your investment strategies and analyze the financial performance of Peoples Bancorp of North Carolina, Inc. (PEBK).
- Analysts: Enhance your analysis with a customizable financial model tailored for banking institutions.
- Small Business Owners: Understand how regional banks like Peoples Bancorp of North Carolina, Inc. (PEBK) assess business financing and growth opportunities.
What the Template Contains
- Pre-Filled DCF Model: Peoples Bancorp of North Carolina’s (PEBK) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Peoples Bancorp’s (PEBK) profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.