Sitio Royalties Corp. (STR) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Sitio Royalties Corp. (STR) Bundle
Explore the financial potential of Sitio Royalties Corp. (STR) with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to determine the intrinsic value of Sitio Royalties Corp. (STR) and refine your investment approach.
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 | 68.5 | 45.7 | 120.6 | 369.6 | 593.4 | 930.5 | 1,459.2 | 2,288.4 | 3,588.7 | 5,627.8 |
Revenue Growth, % | 0 | -33.25 | 163.87 | 206.51 | 60.53 | 56.82 | 56.82 | 56.82 | 56.82 | 56.82 |
EBITDA | 50.1 | 8.0 | 90.8 | 354.2 | 323.8 | 588.8 | 923.3 | 1,448.0 | 2,270.7 | 3,561.0 |
EBITDA, % | 73.23 | 17.46 | 75.28 | 95.84 | 54.56 | 63.28 | 63.28 | 63.28 | 63.28 | 63.28 |
Depreciation | 12.8 | 14.7 | 40.9 | 104.5 | 291.3 | 301.8 | 473.3 | 742.2 | 1,164.0 | 1,825.4 |
Depreciation, % | 18.71 | 32.16 | 33.92 | 28.28 | 49.1 | 32.43 | 32.43 | 32.43 | 32.43 | 32.43 |
EBIT | 37.3 | -6.7 | 49.9 | 249.7 | 32.4 | 287.0 | 450.0 | 705.7 | 1,106.8 | 1,735.6 |
EBIT, % | 54.51 | -14.7 | 41.36 | 67.56 | 5.47 | 30.84 | 30.84 | 30.84 | 30.84 | 30.84 |
Total Cash | 2.5 | 2.7 | 12.4 | 18.8 | 15.2 | 51.4 | 80.5 | 126.3 | 198.0 | 310.6 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | .0 | 36.2 | 142.0 | 107.3 | 161.0 | 252.5 | 396.0 | 621.1 | 974.0 |
Account Receivables, % | 0 | 0 | 30.02 | 38.42 | 18.09 | 17.31 | 17.31 | 17.31 | 17.31 | 17.31 |
Inventories | .0 | .0 | -1.0 | -142.0 | .0 | -73.0 | -114.5 | -179.6 | -281.6 | -441.6 |
Inventories, % | 0.000001460643 | 0.000002188232 | -0.81683 | -38.42 | 0 | -7.85 | -7.85 | -7.85 | -7.85 | -7.85 |
Accounts Payable | 2.2 | 1.5 | .0 | .0 | .0 | 12.3 | 19.2 | 30.2 | 47.3 | 74.2 |
Accounts Payable, % | 3.22 | 3.37 | 0 | 0 | 0 | 1.32 | 1.32 | 1.32 | 1.32 | 1.32 |
Capital Expenditure | -.6 | -35.8 | -38.7 | -558.4 | -170.5 | -446.9 | -700.9 | -1,099.1 | -1,723.7 | -2,703.1 |
Capital Expenditure, % | -0.8647 | -78.42 | -32.13 | -151.08 | -28.74 | -48.03 | -48.03 | -48.03 | -48.03 | -48.03 |
Tax Rate, % | 74.52 | 74.52 | 74.52 | 74.52 | 74.52 | 74.52 | 74.52 | 74.52 | 74.52 | 74.52 |
EBITAT | 15.3 | -6.7 | 49.4 | 242.3 | 8.3 | 208.0 | 326.2 | 511.5 | 802.1 | 1,257.9 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 29.7 | -28.5 | 14.8 | -176.4 | 21.7 | 94.5 | 55.5 | 87.1 | 136.6 | 214.2 |
WACC, % | 8.34 | 10.66 | 10.62 | 10.54 | 7.74 | 9.58 | 9.58 | 9.58 | 9.58 | 9.58 |
PV UFCF | ||||||||||
SUM PV UFCF | 428.9 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | 223 | |||||||||
Terminal Value | 3,992 | |||||||||
Present Terminal Value | 2,526 | |||||||||
Enterprise Value | 2,955 | |||||||||
Net Debt | 857 | |||||||||
Equity Value | 2,098 | |||||||||
Diluted Shares Outstanding, MM | 81 | |||||||||
Equity Value Per Share | 25.82 |
What You Will Receive
- Customizable Excel Template: A fully adjustable Excel-based DCF Calculator featuring pre-filled real STR financials.
- Accurate Data: Historical figures and projected estimates (highlighted in the yellow cells).
- Flexible Forecasting: Modify forecast parameters such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe the effects of your inputs on Sitio Royalties Corp.'s valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Interface: Organized for clarity and ease of navigation, complete with step-by-step guidance.
Key Features
- Customizable Revenue Inputs: Adjust essential factors such as production levels, pricing, and operating costs.
- Instant DCF Analysis: Quickly computes intrinsic value, NPV, and additional financial metrics.
- High-Precision Valuation: Leverages Sitio Royalties Corp.'s (STR) actual financial data for accurate valuation results.
- Effortless Scenario Testing: Evaluate various scenarios and analyze results with ease.
- Efficiency Booster: Streamline the valuation process without the hassle of creating intricate models from the ground up.
How It Works
- 1. Access the Template: Download and open the Excel file containing Sitio Royalties Corp.'s (STR) preloaded data.
- 2. Adjust Assumptions: Modify essential inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results Instantly: The DCF model automatically computes intrinsic value and NPV.
- 4. Explore Scenarios: Evaluate various forecasts to assess different valuation results.
- 5. Present with Confidence: Share professional valuation insights to back your decision-making.
Why Choose This Calculator for Sitio Royalties Corp. (STR)?
- Accurate Data: Real Sitio Royalties Corp. financials provide dependable valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you the effort of starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the field.
- User-Friendly: An intuitive design and clear step-by-step guidance make it accessible for all users.
Who Should Use Sitio Royalties Corp. (STR)?
- Individual Investors: Gain insights to make informed decisions about investing in Sitio Royalties Corp. (STR).
- Financial Analysts: Enhance valuation processes with comprehensive financial models tailored for Sitio Royalties Corp. (STR).
- Consultants: Provide clients with accurate and timely valuation analyses of Sitio Royalties Corp. (STR).
- Business Owners: Learn how companies like Sitio Royalties Corp. (STR) are valued to inform your own business strategies.
- Finance Students: Explore real-world valuation techniques using data and scenarios related to Sitio Royalties Corp. (STR).
What the Template Contains
- Pre-Filled DCF Model: Sitio Royalties Corp.'s (STR) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Sitio Royalties Corp.'s (STR) profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.