Sierra Bancorp (BSRR) 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
Sierra Bancorp (BSRR) Bundle
Explore the financial future of Sierra Bancorp with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to calculate Sierra Bancorp's intrinsic value 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 | 120.8 | 131.0 | 127.6 | 130.1 | 139.1 | 144.2 | 149.5 | 155.0 | 160.7 | 166.6 |
| Revenue Growth, % | 0 | 8.39 | -2.62 | 1.99 | 6.94 | 3.68 | 3.68 | 3.68 | 3.68 | 3.68 |
| EBITDA | 51.8 | 50.6 | 61.5 | 48.5 | 49.7 | 58.5 | 60.6 | 62.8 | 65.1 | 67.5 |
| EBITDA, % | 42.85 | 38.65 | 48.19 | 37.24 | 35.72 | 40.53 | 40.53 | 40.53 | 40.53 | 40.53 |
| Depreciation | 3.9 | 4.1 | 4.3 | 3.5 | 3.2 | 4.2 | 4.4 | 4.6 | 4.7 | 4.9 |
| Depreciation, % | 3.21 | 3.13 | 3.35 | 2.72 | 2.32 | 2.95 | 2.95 | 2.95 | 2.95 | 2.95 |
| EBIT | 47.9 | 46.5 | 57.2 | 44.9 | 46.5 | 54.2 | 56.2 | 58.3 | 60.4 | 62.6 |
| EBIT, % | 39.63 | 35.52 | 44.84 | 34.53 | 33.4 | 37.58 | 37.58 | 37.58 | 37.58 | 37.58 |
| Total Cash | 680.9 | 615.4 | 1,230.8 | 1,012.1 | 78.6 | 131.7 | 136.5 | 141.5 | 146.8 | 152.1 |
| 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 | -89.1 | -88.5 | -268.9 | -95.5 | .0 | -90.8 | -94.1 | -97.6 | -101.2 | -104.9 |
| Inventories, % | -73.74 | -67.54 | -210.79 | -73.4 | 0 | -62.93 | -62.93 | -62.93 | -62.93 | -62.93 |
| 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 | -.8 | -2.9 | -.4 | -1.3 | -1.4 | -1.5 | -1.5 | -1.6 | -1.7 | -1.7 |
| Capital Expenditure, % | -0.64793 | -2.23 | -0.29085 | -0.97778 | -1.02 | -1.03 | -1.03 | -1.03 | -1.03 | -1.03 |
| Tax Rate, % | 25.01 | 25.01 | 25.01 | 25.01 | 25.01 | 25.01 | 25.01 | 25.01 | 25.01 | 25.01 |
| EBITAT | 36.1 | 35.4 | 43.0 | 33.7 | 34.8 | 40.8 | 42.3 | 43.9 | 45.5 | 47.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 128.3 | 36.0 | 227.3 | -137.5 | -58.8 | 134.4 | 48.5 | 50.3 | 52.2 | 54.1 |
| WACC, % | 8.61 | 8.66 | 8.61 | 8.59 | 8.59 | 8.61 | 8.61 | 8.61 | 8.61 | 8.61 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 277.4 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 55 | |||||||||
| Terminal Value | 834 | |||||||||
| Present Terminal Value | 552 | |||||||||
| Enterprise Value | 829 | |||||||||
| Net Debt | 367 | |||||||||
| Equity Value | 463 | |||||||||
| Diluted Shares Outstanding, MM | 15 | |||||||||
| Equity Value Per Share | 31.38 |
What You Will Receive
- Customizable Excel Template: A fully editable Excel-based DCF Calculator featuring pre-filled real Sierra Bancorp (BSRR) financials.
- Authentic Data: Historical figures and forward-looking projections (highlighted in the yellow cells).
- Flexible Forecasting: Adjust forecast parameters such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe how your inputs affect Sierra Bancorp’s valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- Easy-to-Use Layout: Organized for simplicity and usability, complete with step-by-step guidance.
Key Features
- Comprehensive Financial Data: Gain access to precise pre-loaded historical data and future forecasts for Sierra Bancorp (BSRR).
- Adjustable Forecast Parameters: Modify highlighted cells for key variables such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic recalculations for DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Intuitive charts and summaries to easily interpret your valuation outcomes.
- Designed for All Skill Levels: A straightforward, user-centric layout suitable for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the Excel file for Sierra Bancorp (BSRR).
- Step 2: Review Sierra Bancorp’s pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust the assumptions.
- Step 5: Analyze the results and leverage the outputs for informed investment decisions.
Why Choose Sierra Bancorp (BSRR)?
- Save Time: No need to navigate complex banking processes – our services are streamlined for efficiency.
- Enhance Financial Security: Our robust financial strategies ensure your investments are well-protected.
- Fully Customizable Solutions: Tailor banking services to meet your unique financial needs and goals.
- User-Friendly Experience: Intuitive interfaces make managing your finances straightforward and hassle-free.
- Trusted by Clients: Sierra Bancorp (BSRR) is recognized for its commitment to reliability and customer satisfaction.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for portfolio assessment of Sierra Bancorp (BSRR).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in Sierra Bancorp (BSRR) stock.
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Banking Enthusiasts: Gain insights into how banking institutions like Sierra Bancorp (BSRR) are valued in the financial market.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Sierra Bancorp (BSRR) 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 Sierra Bancorp (BSRR).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.