Stock Yards Bancorp, Inc. (SYBT) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Stock Yards Bancorp, Inc. (SYBT) Bundle
Looking to determine the intrinsic value of Stock Yards Bancorp, Inc.? Our SYBT DCF Calculator integrates real-world data with extensive customization features, allowing you to refine your forecasts and enhance your investment choices.
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 | 172.5 | 185.2 | 232.1 | 311.9 | 324.5 | 382.1 | 450.0 | 530.0 | 624.2 | 735.1 |
| Revenue Growth, % | 0 | 7.36 | 25.29 | 34.4 | 4.03 | 17.77 | 17.77 | 17.77 | 17.77 | 17.77 |
| EBITDA | 82.4 | 77.5 | 101.1 | 132.5 | .0 | 134.2 | 158.1 | 186.2 | 219.3 | 258.2 |
| EBITDA, % | 47.75 | 41.85 | 43.55 | 42.49 | 0 | 35.13 | 35.13 | 35.13 | 35.13 | 35.13 |
| Depreciation | 4.5 | 4.7 | 5.6 | 12.0 | 21.9 | 13.9 | 16.4 | 19.3 | 22.7 | 26.7 |
| Depreciation, % | 2.6 | 2.55 | 2.4 | 3.86 | 6.76 | 3.64 | 3.64 | 3.64 | 3.64 | 3.64 |
| EBIT | 77.9 | 72.8 | 95.5 | 120.5 | -21.9 | 120.3 | 141.7 | 166.9 | 196.6 | 231.5 |
| EBIT, % | 45.15 | 39.3 | 41.15 | 38.63 | -6.76 | 31.49 | 31.49 | 31.49 | 31.49 | 31.49 |
| Total Cash | 517.6 | 630.2 | 1,242.6 | 1,227.1 | 266.0 | 368.3 | 433.8 | 510.9 | 601.7 | 708.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 10.7 | 29.8 | 30.0 | 22.2 | 46.3 | 43.3 | 51.0 | 60.0 | 70.7 | 83.2 |
| Account Receivables, % | 6.21 | 16.1 | 12.94 | 7.1 | 14.28 | 11.32 | 11.32 | 11.32 | 11.32 | 11.32 |
| Inventories | -263.7 | -336.4 | -1,000.6 | -232.4 | .0 | -286.2 | -337.1 | -397.0 | -467.5 | -550.6 |
| Inventories, % | -152.87 | -181.65 | -431.16 | -74.5 | 0 | -74.9 | -74.9 | -74.9 | -74.9 | -74.9 |
| Accounts Payable | .6 | .4 | .3 | .7 | 2.1 | 1.2 | 1.4 | 1.7 | 2.0 | 2.3 |
| Accounts Payable, % | 0.37098 | 0.21111 | 0.12928 | 0.21161 | 0.64538 | 0.31367 | 0.31367 | 0.31367 | 0.31367 | 0.31367 |
| Capital Expenditure | -5.1 | -5.5 | -4.6 | -18.4 | -7.7 | -12.4 | -14.6 | -17.1 | -20.2 | -23.8 |
| Capital Expenditure, % | -2.96 | -2.95 | -1.97 | -5.91 | -2.38 | -3.23 | -3.23 | -3.23 | -3.23 | -3.23 |
| Tax Rate, % | 21.88 | 21.88 | 21.88 | 21.88 | 21.88 | 21.88 | 21.88 | 21.88 | 21.88 | 21.88 |
| EBITAT | 68.0 | 63.3 | 74.7 | 93.0 | -17.1 | 98.1 | 115.6 | 136.1 | 160.3 | 188.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 321.1 | 115.9 | 739.5 | -673.4 | -258.0 | 388.0 | 160.8 | 189.3 | 223.0 | 262.6 |
| WACC, % | 11.26 | 11.24 | 10.87 | 10.82 | 10.86 | 11.01 | 11.01 | 11.01 | 11.01 | 11.01 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 921.1 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 268 | |||||||||
| Terminal Value | 2,973 | |||||||||
| Present Terminal Value | 1,764 | |||||||||
| Enterprise Value | 2,685 | |||||||||
| Net Debt | 132 | |||||||||
| Equity Value | 2,553 | |||||||||
| Diluted Shares Outstanding, MM | 29 | |||||||||
| Equity Value Per Share | 86.99 |
What You Will Receive
- Pre-Filled Financial Model: Stock Yards Bancorp, Inc.'s (SYBT) actual data provides accurate DCF valuation.
- Full Forecast Control: Modify revenue growth, profit margins, WACC, and other critical factors.
- Instant Calculations: Real-time updates allow you to view results as you adjust inputs.
- Investor-Ready Template: A polished Excel file crafted for high-quality valuation analysis.
- Customizable and Reusable: Designed for adaptability, enabling multiple uses for comprehensive forecasts.
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for Stock Yards Bancorp, Inc. (SYBT).
- WACC Calculator: Features a pre-built Weighted Average Cost of Capital sheet with adjustable inputs for precise calculations.
- Customizable Forecast Assumptions: Easily modify growth rates, capital expenditures, and discount rates to fit your analysis.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for Stock Yards Bancorp, Inc. (SYBT).
- Visual Dashboard and Charts: Provides graphical representations that summarize key valuation metrics for straightforward analysis.
How It Works
- Download the Template: Gain immediate access to the Excel-based SYBT DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model will automatically refresh to reflect Stock Yards Bancorp's intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential valuation shifts.
- Analyze and Decide: Utilize the findings to inform your investment or financial strategy.
Why Choose This Calculator for Stock Yards Bancorp, Inc. (SYBT)?
- Designed for Experts: A sophisticated tool tailored for analysts, CFOs, and financial consultants.
- Accurate Data: Stock Yards Bancorp's historical and projected financials are preloaded for precision.
- Flexible Scenario Analysis: Easily simulate various forecasts and assumptions.
- Comprehensive Outputs: Automatically calculates intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Step-by-step instructions ensure a seamless experience.
Who Should Use This Product?
- Investors: Accurately estimate Stock Yards Bancorp, Inc.'s (SYBT) fair value before making investment decisions.
- CFOs: Leverage a professional-grade DCF model for financial reporting and analysis related to Stock Yards Bancorp, Inc. (SYBT).
- Consultants: Quickly adapt the template for valuation reports for clients focusing on Stock Yards Bancorp, Inc. (SYBT).
- Entrepreneurs: Gain insights into financial modeling used by successful institutions like Stock Yards Bancorp, Inc. (SYBT).
- Educators: Use it as a teaching tool to demonstrate valuation methodologies relevant to Stock Yards Bancorp, Inc. (SYBT).
What the Template Contains
- Preloaded SYBT Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.