|
Suburban Propane Partners, L.P. (SPH) DCF Valuation
US | Utilities | Regulated Gas | NYSE
|
- ✓ 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
Suburban Propane Partners, L.P. (SPH) Bundle
Designed for accuracy, our [SPH] DCF Calculator enables you to assess Suburban Propane Partners, L.P. valuation using real-world financial data, offering complete flexibility to modify all essential parameters for improved projections.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 1,107.9 | 1,288.8 | 1,501.5 | 1,429.2 | 1,327.2 | 1,396.4 | 1,469.3 | 1,546.0 | 1,626.7 | 1,711.6 |
| Revenue Growth, % | 0 | 16.32 | 16.51 | -4.81 | -7.14 | 5.22 | 5.22 | 5.22 | 5.22 | 5.22 |
| EBITDA | 252.1 | 296.6 | 259.6 | 260.4 | 216.5 | 272.6 | 286.8 | 301.8 | 317.5 | 334.1 |
| EBITDA, % | 22.76 | 23.01 | 17.29 | 18.22 | 16.31 | 19.52 | 19.52 | 19.52 | 19.52 | 19.52 |
| Depreciation | 116.8 | 104.6 | 58.8 | 62.6 | 67.0 | 89.4 | 94.0 | 98.9 | 104.1 | 109.5 |
| Depreciation, % | 10.54 | 8.11 | 3.92 | 4.38 | 5.05 | 6.4 | 6.4 | 6.4 | 6.4 | 6.4 |
| EBIT | 135.3 | 192.0 | 200.8 | 197.8 | 149.5 | 183.2 | 192.8 | 202.8 | 213.4 | 224.5 |
| EBIT, % | 12.22 | 14.9 | 13.37 | 13.84 | 11.26 | 13.12 | 13.12 | 13.12 | 13.12 | 13.12 |
| Total Cash | 3.1 | 5.8 | 4.1 | 3.5 | 3.2 | 4.2 | 4.4 | 4.6 | 4.9 | 5.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 55.4 | 71.4 | 78.5 | 67.7 | 66.4 | 71.3 | 75.0 | 78.9 | 83.0 | 87.3 |
| Account Receivables, % | 5 | 5.54 | 5.23 | 4.74 | 5.01 | 5.1 | 5.1 | 5.1 | 5.1 | 5.1 |
| Inventories | 46.9 | 61.8 | 66.9 | 61.8 | 55.4 | 61.4 | 64.6 | 68.0 | 71.5 | 75.3 |
| Inventories, % | 4.23 | 4.8 | 4.46 | 4.33 | 4.18 | 4.4 | 4.4 | 4.4 | 4.4 | 4.4 |
| Accounts Payable | 32.0 | 39.2 | 35.2 | 40.0 | 41.1 | 39.6 | 41.6 | 43.8 | 46.1 | 48.5 |
| Accounts Payable, % | 2.89 | 3.04 | 2.34 | 2.8 | 3.09 | 2.83 | 2.83 | 2.83 | 2.83 | 2.83 |
| Capital Expenditure | -32.5 | -29.9 | -44.4 | -44.9 | -59.4 | -44.2 | -46.5 | -48.9 | -51.5 | -54.2 |
| Capital Expenditure, % | -2.93 | -2.32 | -2.95 | -3.15 | -4.48 | -3.17 | -3.17 | -3.17 | -3.17 | -3.17 |
| Tax Rate, % | 0.97987 | 0.97987 | 0.97987 | 0.97987 | 0.97987 | 0.97987 | 0.97987 | 0.97987 | 0.97987 | 0.97987 |
| EBITAT | 135.7 | 190.3 | 200.2 | 196.8 | 148.0 | 182.2 | 191.7 | 201.7 | 212.2 | 223.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 149.6 | 241.3 | 198.4 | 235.2 | 164.2 | 215.1 | 234.4 | 246.6 | 259.5 | 273.0 |
| WACC, % | 11.55 | 11.5 | 11.54 | 11.52 | 11.5 | 11.52 | 11.52 | 11.52 | 11.52 | 11.52 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 885.1 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | 274 | |||||||||
| Terminal Value | 2,489 | |||||||||
| Present Terminal Value | 1,443 | |||||||||
| Enterprise Value | 2,328 | |||||||||
| Net Debt | 136 | |||||||||
| Equity Value | 2,192 | |||||||||
| Diluted Shares Outstanding, MM | 65 | |||||||||
| Equity Value Per Share | 33.81 |
What You Will Receive
- Customizable Excel Template: A fully adaptable Excel-based DCF Calculator featuring pre-filled real SPH financials.
- Actual Market Data: Historical figures and forward-looking projections (highlighted in the yellow cells).
- Forecasting Flexibility: Adjust forecast parameters such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe how your inputs affect Suburban Propane's valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- Intuitive Layout: Organized for clarity and simplicity, complete with step-by-step guidance.
Key Features
- Customizable Financial Inputs: Adjust essential factors such as distribution growth, operating margin, and capital investments.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and additional financial metrics.
- High-Precision Estimates: Leverages Suburban Propane’s actual financial data for accurate valuation results.
- Effortless Scenario Analysis: Easily evaluate various assumptions and analyze different outcomes.
- Efficiency Booster: Remove the hassle of creating intricate valuation models from the ground up.
How It Works
- Step 1: Download the prebuilt Excel template featuring Suburban Propane Partners, L.P. (SPH) data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see the recalculated results, including Suburban Propane Partners, L.P. (SPH)'s intrinsic value.
- Step 5: Make well-informed investment decisions or create reports based on the outputs.
Why Choose This Calculator for Suburban Propane Partners, L.P. (SPH)?
- User-Friendly Interface: Tailored for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters easily to suit your financial analysis.
- Real-Time Valuation: Observe immediate updates to Suburban Propane's valuation as you change inputs.
- Preloaded Data: Comes with Suburban Propane’s actual financial figures for swift evaluations.
- Relied Upon by Experts: Favored by investors and analysts for making well-informed decisions.
Who Should Use This Product?
- Investors: Accurately assess Suburban Propane's fair value before making investment decisions.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis specific to Suburban Propane Partners, L.P. (SPH).
- Consultants: Efficiently customize the template for valuation reports tailored to clients in the energy sector.
- Entrepreneurs: Acquire insights into financial modeling practices used by leading companies in the propane industry.
- Educators: Employ it as a teaching resource to illustrate valuation methodologies in the context of energy partnerships.
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations tailored for Suburban Propane Partners, L.P. (SPH).
- Real-World Data: Suburban Propane's historical and projected financials preloaded for thorough analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage specific to Suburban Propane Partners, L.P. (SPH).
- Dashboard with Visual Outputs: Charts and tables providing clear, actionable results for informed decision-making.