|
Valoración de DCF de Plumas Bancorp (PLBC)
US | Financial Services | Banks - Regional | NASDAQ
|
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
Plumas Bancorp (PLBC) Bundle
¡Mejore sus estrategias de inversión con la calculadora DCF de Plumas Bancorp (PLBC)! Explore datos financieros reales, ajuste las proyecciones y gastos de crecimiento, y observe instantáneamente cómo estas modificaciones afectan el valor intrínseco de Plumas Bancorp.
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 | 45.7 | 46.9 | 55.7 | 69.3 | 80.1 | 92.4 | 106.6 | 122.9 | 141.8 | 163.6 |
| Revenue Growth, % | 0 | 2.56 | 18.76 | 24.5 | 15.6 | 15.35 | 15.35 | 15.35 | 15.35 | 15.35 |
| EBITDA | 22.7 | 21.4 | 29.9 | 37.6 | .0 | 37.6 | 43.3 | 50.0 | 57.7 | 66.5 |
| EBITDA, % | 49.68 | 45.62 | 53.76 | 54.22 | 0 | 40.65 | 40.65 | 40.65 | 40.65 | 40.65 |
| Depreciation | 1.3 | 1.3 | 1.4 | 1.6 | 1.7 | 2.3 | 2.7 | 3.1 | 3.6 | 4.1 |
| Depreciation, % | 2.88 | 2.75 | 2.57 | 2.35 | 2.08 | 2.53 | 2.53 | 2.53 | 2.53 | 2.53 |
| EBIT | 21.4 | 20.1 | 28.5 | 35.9 | -1.7 | 35.2 | 40.6 | 46.9 | 54.1 | 62.4 |
| EBIT, % | 46.79 | 42.87 | 51.19 | 51.87 | -2.08 | 38.13 | 38.13 | 38.13 | 38.13 | 38.13 |
| Total Cash | 206.3 | 364.5 | 686.5 | 628.1 | 85.7 | 92.4 | 106.6 | 122.9 | 141.8 | 163.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 | -51.0 | -190.7 | -386.9 | -190.9 | .0 | -73.9 | -85.3 | -98.4 | -113.5 | -130.9 |
| Inventories, % | -111.72 | -407 | -695.19 | -275.47 | 0 | -80 | -80 | -80 | -80 | -80 |
| Accounts Payable | 7.0 | 8.3 | 13.4 | 15.3 | .0 | 14.6 | 16.9 | 19.5 | 22.5 | 25.9 |
| Accounts Payable, % | 15.41 | 17.63 | 24.08 | 22.08 | 0 | 15.84 | 15.84 | 15.84 | 15.84 | 15.84 |
| Capital Expenditure | -1.4 | -1.6 | -.9 | -3.0 | -2.3 | -2.8 | -3.3 | -3.8 | -4.4 | -5.0 |
| Capital Expenditure, % | -3.06 | -3.43 | -1.67 | -4.36 | -2.84 | -3.07 | -3.07 | -3.07 | -3.07 | -3.07 |
| Tax Rate, % | 25.95 | 25.95 | 25.95 | 25.95 | 25.95 | 25.95 | 25.95 | 25.95 | 25.95 | 25.95 |
| EBITAT | 15.5 | 14.6 | 21.0 | 26.6 | -1.2 | 25.9 | 29.8 | 34.4 | 39.7 | 45.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 73.5 | 155.1 | 222.8 | -168.9 | -208.0 | 113.9 | 42.8 | 49.4 | 57.0 | 65.8 |
| WACC, % | 6.69 | 6.69 | 6.71 | 6.72 | 6.71 | 6.71 | 6.71 | 6.71 | 6.71 | 6.71 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 276.6 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 67 | |||||||||
| Terminal Value | 1,425 | |||||||||
| Present Terminal Value | 1,030 | |||||||||
| Enterprise Value | 1,307 | |||||||||
| Net Debt | 4 | |||||||||
| Equity Value | 1,303 | |||||||||
| Diluted Shares Outstanding, MM | 6 | |||||||||
| Equity Value Per Share | 219.52 |
What You Will Receive
- Pre-Loaded Financial Model: Plumas Bancorp’s actual data allows for accurate DCF valuation.
- Comprehensive Forecast Control: Modify revenue growth, profit margins, WACC, and other essential factors.
- Real-Time Calculations: Automatic updates provide immediate feedback as you adjust inputs.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation analysis.
- Flexible and Reusable: Designed for adaptability, enabling repeated application for in-depth forecasts.
Key Features
- Authentic Plumas Bancorp Financials: Access reliable pre-loaded historical data and future forecasts.
- Adjustable Forecast Parameters: Modify yellow-highlighted fields such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Instant updates to DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Clear charts and summaries to help visualize your valuation outcomes.
- Suitable for All Skill Levels: An easy-to-navigate format designed for investors, CFOs, and consultants.
How It Works
- 1. Access the Template: Download and open the Excel file containing Plumas Bancorp’s (PLBC) financial data.
- 2. Modify Assumptions: Adjust key variables such as growth rates, WACC, and capital expenditures.
- 3. Analyze Results Immediately: The DCF model automatically computes intrinsic value and NPV.
- 4. Explore Scenarios: Evaluate various forecasts to understand different valuation possibilities.
- 5. Present with Assurance: Share expert valuation analyses to back your investment decisions.
Why Choose This Calculator for Plumas Bancorp (PLBC)?
- Comprehensive Tool: Features DCF, WACC, and financial ratio analyses all in one convenient package.
- Customizable Inputs: Modify the yellow-highlighted cells to explore various financial scenarios.
- Detailed Insights: Automatically computes Plumas Bancorp’s intrinsic value and Net Present Value.
- Preloaded Data: Access historical and forecasted data for reliable starting points.
- Professional Quality: Perfect for financial analysts, investors, and business consultants focusing on (PLBC).
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Plumas Bancorp (PLBC) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for Plumas Bancorp (PLBC).
- Consultants: Deliver professional valuation insights on Plumas Bancorp (PLBC) to clients quickly and accurately.
- Business Owners: Understand how companies like Plumas Bancorp (PLBC) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Plumas Bancorp (PLBC).
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations tailored for Plumas Bancorp (PLBC).
- Real-World Data: Plumas Bancorp’s historical and projected financials preloaded for in-depth analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into the company’s performance.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage specific to Plumas Bancorp (PLBC).
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results related to Plumas Bancorp (PLBC).