Saul Centers, Inc. (BFS) DCF Valuation
- ✓ 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
Saul Centers, Inc. (BFS) Bundle
Discover the true value of Saul Centers, Inc. (BFS) with our professional-grade DCF Calculator! Adjust key assumptions, explore various scenarios, and evaluate how changes affect the valuation of Saul Centers, Inc. (BFS) – all within a single Excel template.
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 | 231.5 | 225.2 | 239.2 | 245.9 | 257.2 | 259.8 | 262.4 | 265.0 | 267.7 | 270.4 |
| Revenue Growth, % | 0 | -2.73 | 6.22 | 2.77 | 4.62 | 1 | 1 | 1 | 1 | 1 |
| EBITDA | 229.1 | 146.3 | 107.1 | 110.0 | 166.6 | 165.3 | 167.0 | 168.6 | 170.3 | 172.0 |
| EBITDA, % | 98.94 | 64.94 | 44.76 | 44.73 | 64.78 | 63.63 | 63.63 | 63.63 | 63.63 | 63.63 |
| Depreciation | 126.7 | 133.9 | 131.6 | 135.8 | 48.4 | 126.4 | 127.6 | 128.9 | 130.2 | 131.5 |
| Depreciation, % | 54.73 | 59.44 | 55 | 55.23 | 18.83 | 48.65 | 48.65 | 48.65 | 48.65 | 48.65 |
| EBIT | 102.4 | 12.4 | -24.5 | -25.8 | 118.2 | 38.9 | 39.3 | 39.7 | 40.1 | 40.5 |
| EBIT, % | 44.21 | 5.5 | -10.24 | -10.5 | 45.95 | 14.98 | 14.98 | 14.98 | 14.98 | 14.98 |
| Total Cash | 13.9 | 26.9 | 14.6 | 13.3 | 8.4 | 17.0 | 17.2 | 17.3 | 17.5 | 17.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 52.3 | 64.9 | 58.7 | 56.3 | 56.0 | 62.7 | 63.3 | 63.9 | 64.6 | 65.2 |
| Account Receivables, % | 22.59 | 28.83 | 24.52 | 22.91 | 21.78 | 24.13 | 24.13 | 24.13 | 24.13 | 24.13 |
| Inventories | 72.2 | .0 | .0 | -4.0 | .0 | 15.4 | 15.5 | 15.7 | 15.8 | 16.0 |
| Inventories, % | 31.18 | 0 | 0 | -1.61 | 0 | 5.91 | 5.91 | 5.91 | 5.91 | 5.91 |
| Accounts Payable | 35.2 | 24.4 | 25.6 | 43.0 | 50.0 | 38.3 | 38.6 | 39.0 | 39.4 | 39.8 |
| Accounts Payable, % | 15.2 | 10.83 | 10.68 | 17.48 | 19.45 | 14.73 | 14.73 | 14.73 | 14.73 | 14.73 |
| Capital Expenditure | .0 | 56.2 | .0 | 19.0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Capital Expenditure, % | 0 | 24.94 | 0 | 7.73 | 0 | 0 | 0 | 0 | 0 | 0 |
| Tax Rate, % | 23.67 | 23.67 | 23.67 | 23.67 | 23.67 | 23.67 | 23.67 | 23.67 | 23.67 | 23.67 |
| EBITAT | 82.5 | -1.2 | -1.2 | -37.2 | 90.2 | 20.4 | 20.6 | 20.8 | 21.0 | 21.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 119.9 | 237.6 | 137.8 | 141.4 | 142.0 | 113.0 | 147.8 | 149.3 | 150.8 | 152.3 |
| WACC, % | 6 | 3.84 | 3.97 | 6.52 | 5.88 | 5.24 | 5.24 | 5.24 | 5.24 | 5.24 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 609.8 | |||||||||
| Long Term Growth Rate, % | 3.50 | |||||||||
| Free cash flow (T + 1) | 158 | |||||||||
| Terminal Value | 9,047 | |||||||||
| Present Terminal Value | 7,007 | |||||||||
| Enterprise Value | 7,617 | |||||||||
| Net Debt | 1,379 | |||||||||
| Equity Value | 6,239 | |||||||||
| Diluted Shares Outstanding, MM | 24 | |||||||||
| Equity Value Per Share | 259.37 |
What You Will Get
- Real Saul Centers Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Saul Centers, Inc. (BFS).
- 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 analyze the impact of changes on Saul Centers' fair value.
- Versatile Excel Template: Designed for quick edits, scenario testing, and detailed projections specific to Saul Centers, Inc. (BFS).
- Time-Saving and Accurate: Avoid building models from scratch while ensuring precision and flexibility in your evaluations.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Saul Centers, Inc. (BFS).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs specific to the real estate sector.
- Customizable Forecast Assumptions: Adjust growth projections, capital expenditures, and discount rates for accurate modeling.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to Saul Centers, Inc. (BFS).
- Interactive Dashboard and Charts: Visual representations consolidate key valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the Excel file for Saul Centers, Inc. (BFS).
- Step 2: Review the pre-filled financial data and forecasts for Saul Centers, Inc. (BFS).
- 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 your assumptions.
- Step 5: Analyze the outputs and leverage the results for your investment strategies.
Why Choose This Calculator for Saul Centers, Inc. (BFS)?
- Accuracy: Leverage real Saul Centers financial data for precise calculations.
- Flexibility: Tailored for users to experiment and adjust inputs as needed.
- Time-Saving: Avoid the complexities of constructing a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and attention to detail expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling skills.
Who Should Use This Product?
- Individual Investors: Gain insights to make informed decisions regarding investments in Saul Centers, Inc. (BFS).
- Financial Analysts: Enhance valuation methodologies with comprehensive financial models tailored for Saul Centers, Inc. (BFS).
- Consultants: Provide clients with accurate and timely valuation analyses of Saul Centers, Inc. (BFS).
- Real Estate Professionals: Understand the valuation metrics of REITs like Saul Centers, Inc. (BFS) to inform investment strategies.
- Finance Students: Explore real-world valuation techniques using data from Saul Centers, Inc. (BFS) for practical learning.
What the Template Contains
- Pre-Filled DCF Model: Saul Centers, Inc.’s (BFS) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital specific to Saul Centers, Inc. (BFS).
- Financial Ratios: Evaluate Saul Centers, Inc.’s (BFS) profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios for Saul Centers, Inc. (BFS).
- Financial Statements: Annual and quarterly reports for Saul Centers, Inc. (BFS) to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results for Saul Centers, Inc. (BFS).