|
Saul Centers, Inc. (BFS) Valoración de DCF
US | Real Estate | REIT - Retail | NYSE
|
- ✓ 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
¡Descubra el verdadero valor de Saul Centers, Inc. (BFS) con nuestra calculadora DCF de grado profesional! Ajuste los supuestos clave, explore varios escenarios y evalúe cómo los cambios afectan la valoración de Saul Centers, Inc. (BFS), todo dentro de una sola plantilla de Excel.
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).