|
Valoración de DCF de Sabine Royalty Trust (SBR)
US | Energy | Oil & Gas Exploration & Production | 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
Sabine Royalty Trust (SBR) Bundle
¡Descubra el verdadero potencial de Sabine Royalty Trust (SBR) con nuestra calculadora DCF avanzada! Ajuste los supuestos esenciales, explore varios escenarios y evalúe cómo los cambios afectan la valoración de Sabine Royalty Trust (SBR), todo dentro de una plantilla integral 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 | 46.7 | 36.3 | 60.9 | 125.7 | 93.8 | 88.8 | 84.1 | 79.6 | 75.3 | 71.3 |
Revenue Growth, % | 0 | -22.24 | 67.63 | 106.47 | -25.39 | -5.34 | -5.34 | -5.34 | -5.34 | -5.34 |
EBITDA | 43.9 | 33.3 | 57.9 | 122.7 | 89.4 | 84.1 | 79.6 | 75.3 | 71.3 | 67.5 |
EBITDA, % | 93.88 | 91.59 | 94.99 | 97.59 | 95.34 | 94.68 | 94.68 | 94.68 | 94.68 | 94.68 |
Depreciation | 2.9 | 3.1 | 3.1 | 3.3 | .0 | 3.9 | 3.7 | 3.5 | 3.3 | 3.2 |
Depreciation, % | 6.12 | 8.41 | 5.01 | 2.61 | 0.01821659 | 4.44 | 4.44 | 4.44 | 4.44 | 4.44 |
EBIT | 41.0 | 30.2 | 54.8 | 119.4 | 89.4 | 80.1 | 75.9 | 71.8 | 68.0 | 64.3 |
EBIT, % | 87.77 | 83.17 | 89.97 | 94.98 | 95.33 | 90.24 | 90.24 | 90.24 | 90.24 | 90.24 |
Total Cash | 6.7 | 4.8 | 16.2 | 16.2 | 9.3 | 13.7 | 12.9 | 12.3 | 11.6 | 11.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Inventories, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
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 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Capital Expenditure, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
EBITAT | 41.0 | 30.2 | 54.8 | 119.4 | 89.4 | 80.1 | 75.9 | 71.8 | 68.0 | 64.3 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 43.9 | 33.3 | 57.9 | 122.7 | 89.4 | 84.1 | 79.6 | 75.3 | 71.3 | 67.5 |
WACC, % | 6.83 | 6.83 | 6.83 | 6.83 | 6.83 | 6.83 | 6.83 | 6.83 | 6.83 | 6.83 |
PV UFCF | ||||||||||
SUM PV UFCF | 313.5 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 68 | |||||||||
Terminal Value | 1,071 | |||||||||
Present Terminal Value | 770 | |||||||||
Enterprise Value | 1,083 | |||||||||
Net Debt | -9,342 | |||||||||
Equity Value | 10,426 | |||||||||
Diluted Shares Outstanding, MM | 15 | |||||||||
Equity Value Per Share | 715.10 |
What You Will Receive
- Pre-Filled Financial Model: Utilize Sabine Royalty Trust’s (SBR) actual data for accurate DCF valuation.
- Comprehensive Forecast Control: Modify revenue growth, profit margins, discount rates, and other essential factors.
- Real-Time Calculations: Automatic updates provide immediate results as adjustments are made.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation presentations.
- Flexible and Reusable: Designed for adaptability, enabling repeated application for in-depth forecasts.
Key Features
- Comprehensive SBR Data: Pre-loaded with Sabine Royalty Trust’s historical performance metrics and future projections.
- Flexible Input Options: Modify assumptions for revenue streams, operating expenses, discount rates, tax implications, and capital investments.
- Adaptive Valuation Framework: Real-time adjustments to Net Present Value (NPV) and intrinsic value based on your customized inputs.
- Multiple Scenario Analysis: Develop various forecasting scenarios to explore different valuation possibilities.
- Intuitive User Interface: Designed for ease of use, catering to both seasoned professionals and newcomers.
How It Works
- Download: Get the pre-prepared Excel file containing Sabine Royalty Trust’s (SBR) financial data.
- Customize: Modify assumptions such as revenue projections, operating margins, and discount rates.
- Update Automatically: The intrinsic value and net present value calculations refresh in real-time.
- Test Scenarios: Develop various forecasts and analyze results immediately.
- Make Decisions: Leverage the valuation insights to inform your investment approach.
Why Choose This Calculator for Sabine Royalty Trust (SBR)?
- User-Friendly Interface: Tailored for both novices and seasoned investors.
- Customizable Inputs: Adjust parameters easily to suit your financial analysis.
- Real-Time Valuation: Monitor immediate changes to Sabine Royalty Trust’s (SBR) value as you tweak inputs.
- Preloaded Data: Comes with Sabine Royalty Trust’s (SBR) historical financial information for swift evaluations.
- Relied Upon by Experts: A go-to tool for investors and analysts for making strategic choices.
Who Should Use This Product?
- Investors: Evaluate Sabine Royalty Trust’s (SBR) performance before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methods and assess financial forecasts for (SBR).
- Startup Founders: Understand the valuation strategies of established entities like Sabine Royalty Trust (SBR).
- Consultants: Create detailed valuation reports for clients involving (SBR).
- Students and Educators: Utilize real-time data from (SBR) to learn and teach valuation practices.
What the Template Contains
- Pre-Filled Data: Contains Sabine Royalty Trust's historical financials and projections.
- Discounted Cash Flow Model: An editable DCF valuation model with real-time calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for WACC calculations based on user-defined inputs.
- Key Financial Ratios: Assess Sabine Royalty Trust's profitability, efficiency, and leverage metrics.
- Customizable Inputs: Easily modify revenue growth, margins, and tax rates.
- Clear Dashboard: Visualizations and tables that summarize essential valuation outcomes.