Southside Bancshares, Inc. (SBSI) 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
Southside Bancshares, Inc. (SBSI) Bundle
Explore the financial future of Southside Bancshares, Inc. (SBSI) with our user-friendly DCF Calculator! Enter your assumptions regarding growth, margins, and expenses to calculate the intrinsic value of Southside Bancshares, Inc. (SBSI) and inform your investment decisions.
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 | 211.3 | 236.0 | 237.7 | 251.9 | 241.7 | 250.4 | 259.4 | 268.7 | 278.3 | 288.3 |
Revenue Growth, % | 0 | 11.69 | 0.74074 | 5.96 | -4.04 | 3.59 | 3.59 | 3.59 | 3.59 | 3.59 |
EBITDA | 99.9 | 105.6 | 142.2 | 130.7 | 111.7 | 125.2 | 129.7 | 134.3 | 139.1 | 144.1 |
EBITDA, % | 47.28 | 44.74 | 59.84 | 51.9 | 46.22 | 49.99 | 49.99 | 49.99 | 49.99 | 49.99 |
Depreciation | 11.7 | 11.6 | 11.0 | 10.9 | 10.6 | 11.9 | 12.4 | 12.8 | 13.3 | 13.7 |
Depreciation, % | 5.55 | 4.92 | 4.65 | 4.32 | 4.38 | 4.76 | 4.76 | 4.76 | 4.76 | 4.76 |
EBIT | 88.2 | 94.0 | 131.2 | 119.9 | 101.1 | 113.3 | 117.3 | 121.5 | 125.9 | 130.4 |
EBIT, % | 41.73 | 39.82 | 55.19 | 47.59 | 41.84 | 45.23 | 45.23 | 45.23 | 45.23 | 45.23 |
Total Cash | 2,489.3 | 2,695.7 | 2,966.1 | 1,414.4 | 560.5 | 250.4 | 259.4 | 268.7 | 278.3 | 288.3 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 28.5 | 38.7 | 39.1 | 49.4 | 50.5 | 43.5 | 45.0 | 46.6 | 48.3 | 50.1 |
Account Receivables, % | 13.47 | 16.4 | 16.47 | 19.59 | 20.89 | 17.36 | 17.36 | 17.36 | 17.36 | 17.36 |
Inventories | -139.6 | -147.2 | -240.9 | .0 | .0 | -114.4 | -118.5 | -122.8 | -127.2 | -131.7 |
Inventories, % | -66.08 | -62.39 | -101.33 | 0 | 0 | -45.7 | -45.7 | -45.7 | -45.7 | -45.7 |
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 | -15.9 | -11.4 | -8.4 | -9.3 | -6.9 | -11.2 | -11.6 | -12.1 | -12.5 | -12.9 |
Capital Expenditure, % | -7.52 | -4.85 | -3.52 | -3.69 | -2.86 | -4.49 | -4.49 | -4.49 | -4.49 | -4.49 |
Tax Rate, % | 14.28 | 14.28 | 14.28 | 14.28 | 14.28 | 14.28 | 14.28 | 14.28 | 14.28 | 14.28 |
EBITAT | 74.9 | 82.6 | 113.7 | 105.2 | 86.7 | 98.1 | 101.6 | 105.2 | 109.0 | 112.9 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 181.9 | 80.1 | 209.6 | -144.3 | 89.2 | 220.2 | 104.9 | 108.6 | 112.5 | 116.5 |
WACC, % | 10.21 | 10.43 | 10.34 | 10.43 | 10.27 | 10.33 | 10.33 | 10.33 | 10.33 | 10.33 |
PV UFCF | ||||||||||
SUM PV UFCF | 513.8 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 119 | |||||||||
Terminal Value | 1,426 | |||||||||
Present Terminal Value | 872 | |||||||||
Enterprise Value | 1,386 | |||||||||
Net Debt | 380 | |||||||||
Equity Value | 1,006 | |||||||||
Diluted Shares Outstanding, MM | 31 | |||||||||
Equity Value Per Share | 32.72 |
What You Will Get
- Real SBSI 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 computed automatically.
- Scenario Analysis: Evaluate various scenarios to assess Southside Bancshares' future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- 🔍 Real-Life SBSI Financials: Pre-filled historical and projected data for Southside Bancshares, Inc. (SBSI).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) such as WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Southside Bancshares’ intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Southside Bancshares’ valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the Excel file for Southside Bancshares, Inc. (SBSI).
- Step 2: Review the pre-filled financial data and forecasts for Southside Bancshares.
- Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you modify your assumptions.
- Step 5: Evaluate the outputs and leverage the results for your investment decisions.
Why Choose This Calculator for Southside Bancshares, Inc. (SBSI)?
- All-in-One Solution: Features DCF, WACC, and comprehensive financial ratio analyses tailored for SBSI.
- Flexible Inputs: Modify the yellow-highlighted cells to explore a variety of financial scenarios.
- In-Depth Analysis: Automatically computes the intrinsic value and Net Present Value for Southside Bancshares, Inc. (SBSI).
- Preloaded Information: Access historical and forecasted data to provide reliable baseline figures.
- Expert-Level Tool: Perfect for financial analysts, investors, and business consultants focusing on SBSI.
Who Should Use This Product?
- Investors: Determine the intrinsic value of Southside Bancshares, Inc. (SBSI) to inform your investment strategies.
- CFOs: Utilize an advanced DCF model for accurate financial reporting and comprehensive analysis.
- Consultants: Easily customize the template for client valuation reports related to Southside Bancshares, Inc. (SBSI).
- Entrepreneurs: Acquire knowledge of financial modeling techniques employed by leading banks and financial institutions.
- Educators: Implement this resource as a teaching aid to illustrate various valuation methodologies.
What the Template Contains
- Pre-Filled Data: Includes Southside Bancshares, Inc.'s (SBSI) historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations tailored for (SBSI).
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs specific to (SBSI).
- Key Financial Ratios: Analyze Southside Bancshares, Inc.'s (SBSI) profitability, efficiency, and leverage metrics.
- Customizable Inputs: Edit revenue growth, margins, and tax rates easily for (SBSI).
- Clear Dashboard: Charts and tables summarizing key valuation results for (SBSI).