Southern Missouri Bancorp, Inc. (SMBC) 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
Southern Missouri Bancorp, Inc. (SMBC) Bundle
Evaluate Southern Missouri Bancorp, Inc.'s (SMBC) financial outlook like an expert! This (SMBC) DCF Calculator provides pre-filled financial data along with the flexibility to modify revenue growth, WACC, margins, and other crucial assumptions to align with your projections.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 97.5 | 112.7 | 124.8 | 152.9 | 164.3 | 187.5 | 213.9 | 244.0 | 278.4 | 317.6 |
| Revenue Growth, % | 0 | 15.63 | 10.68 | 22.58 | 7.44 | 14.08 | 14.08 | 14.08 | 14.08 | 14.08 |
| EBITDA | 40.0 | 65.1 | 65.8 | 57.0 | 73.2 | 87.5 | 99.8 | 113.9 | 129.9 | 148.2 |
| EBITDA, % | 41.01 | 57.78 | 52.76 | 37.28 | 44.55 | 46.67 | 46.67 | 46.67 | 46.67 | 46.67 |
| Depreciation | 5.6 | 5.4 | 5.9 | 7.6 | 10.1 | 9.9 | 11.3 | 12.9 | 14.7 | 16.7 |
| Depreciation, % | 5.7 | 4.81 | 4.75 | 4.94 | 6.14 | 5.27 | 5.27 | 5.27 | 5.27 | 5.27 |
| EBIT | 34.4 | 59.7 | 59.9 | 49.5 | 63.1 | 77.6 | 88.6 | 101.0 | 115.3 | 131.5 |
| EBIT, % | 35.32 | 52.96 | 48.01 | 32.34 | 38.41 | 41.41 | 41.41 | 41.41 | 41.41 | 41.41 |
| Total Cash | 231.7 | 331.6 | 327.0 | 472.8 | 14.0 | 153.2 | 174.7 | 199.3 | 227.4 | 259.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 12.1 | 10.1 | 11.1 | .0 | .0 | 11.3 | 12.9 | 14.8 | 16.8 | 19.2 |
| Account Receivables, % | 12.43 | 8.94 | 8.86 | 0 | 0 | 6.05 | 6.05 | 6.05 | 6.05 | 6.05 |
| Inventories | -69.9 | -136.9 | .0 | -96.6 | .0 | -88.0 | -100.4 | -114.6 | -130.7 | -149.1 |
| Inventories, % | -71.69 | -121.42 | 0 | -63.14 | 0 | -46.97 | -46.97 | -46.97 | -46.97 | -46.97 |
| Accounts Payable | 1.6 | .8 | .8 | 4.7 | 12.9 | 5.2 | 6.0 | 6.8 | 7.8 | 8.9 |
| Accounts Payable, % | 1.69 | 0.69104 | 0.64198 | 3.09 | 7.83 | 2.79 | 2.79 | 2.79 | 2.79 | 2.79 |
| Capital Expenditure | -4.3 | -2.9 | -4.6 | -6.0 | -9.0 | -7.5 | -8.6 | -9.8 | -11.2 | -12.8 |
| Capital Expenditure, % | -4.41 | -2.53 | -3.7 | -3.95 | -5.51 | -4.02 | -4.02 | -4.02 | -4.02 | -4.02 |
| Tax Rate, % | 20.48 | 20.48 | 20.48 | 20.48 | 20.48 | 20.48 | 20.48 | 20.48 | 20.48 | 20.48 |
| EBITAT | 27.5 | 47.2 | 47.2 | 39.2 | 50.2 | 61.6 | 70.2 | 80.1 | 91.4 | 104.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 88.2 | 117.9 | -89.4 | 152.3 | -37.2 | 133.0 | 84.5 | 96.3 | 109.9 | 125.4 |
| WACC, % | 18.69 | 18.56 | 18.52 | 18.6 | 18.62 | 18.6 | 18.6 | 18.6 | 18.6 | 18.6 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 338.9 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 128 | |||||||||
| Terminal Value | 771 | |||||||||
| Present Terminal Value | 328 | |||||||||
| Enterprise Value | 667 | |||||||||
| Net Debt | 64 | |||||||||
| Equity Value | 604 | |||||||||
| Diluted Shares Outstanding, MM | 11 | |||||||||
| Equity Value Per Share | 53.41 |
What You Will Get
- Real Southern Missouri Bancorp Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Southern Missouri Bancorp, Inc. (SMBC).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates to fit your analysis needs.
- Instant Valuation Updates: Automatic recalculations to assess the impact of changes on Southern Missouri Bancorp’s fair value.
- Versatile Excel Template: Designed for quick edits, scenario testing, and detailed projections specific to Southern Missouri Bancorp, Inc. (SMBC).
- Time-Saving and Accurate: Eliminate the hassle of building models from scratch while ensuring precision and flexibility in your financial analysis.
Key Features
- Comprehensive Financial Data: Southern Missouri Bancorp, Inc.'s (SMBC) historical financial statements and pre-filled forecasts.
- Customizable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Valuation: Observe Southern Missouri Bancorp, Inc.'s (SMBC) intrinsic value update instantly.
- Intuitive Visual Outputs: Dashboard graphs showcase valuation results and essential metrics.
- Designed for Precision: A professional-grade tool for analysts, investors, and finance professionals.
How It Works
- 1. Open the Template: Download and open the Excel file featuring Southern Missouri Bancorp, Inc. (SMBC)'s preloaded data.
- 2. Edit Assumptions: Modify key inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results Instantly: The DCF model automatically calculates intrinsic value and NPV based on your inputs.
- 4. Test Scenarios: Evaluate various forecasts to explore different valuation outcomes.
- 5. Use with Confidence: Deliver professional valuation insights to enhance your decision-making process.
Why Choose This Calculator?
- Accurate Data: Real Southern Missouri Bancorp, Inc. (SMBC) financials ensure reliable valuation results.
- Customizable: Adjust key parameters like growth rates, WACC, and tax rates to align with your projections.
- Time-Saving: Pre-built calculations remove the hassle of starting from scratch.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the banking sector.
- User-Friendly: Intuitive design and step-by-step guidance make it accessible for all users.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for investment strategies related to Southern Missouri Bancorp, Inc. (SMBC).
- Corporate Finance Teams: Evaluate financial scenarios to inform strategic decisions within their organizations.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in Southern Missouri Bancorp, Inc. (SMBC).
- Students and Educators: Utilize real-time financial data to enhance learning and practice in financial modeling.
- Banking Enthusiasts: Gain insights into how regional banks like Southern Missouri Bancorp, Inc. (SMBC) are assessed in the financial market.
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations tailored for Southern Missouri Bancorp, Inc. (SMBC).
- Real-World Data: Southern Missouri Bancorp's historical and projected financials preloaded for thorough analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage specific to Southern Missouri Bancorp, Inc. (SMBC).
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results.