Star Group, L.P. (SGU) DCF Valuation

Star Group, L.P. (SGU) DCF Valuation
  • ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
  • ✓ Professional Design: Trusted, Industry-Standard Templates
  • ✓ Pre-Built For Quick And Efficient Use
  • ✓ No Expertise Is Needed; Easy To Follow

Star Group, L.P. (SGU) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

Enhance your investment choices with the Star Group, L.P. (SGU) DCF Calculator! Utilize real financial data, adjust growth projections and expenses, and instantly observe how these modifications affect the intrinsic value of Star Group, L.P. (SGU).


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,467.5 1,497.1 2,006.6 1,952.9 1,766.1 1,655.3 1,551.4 1,454.0 1,362.7 1,277.2
Revenue Growth, % 0 2.02 34.03 -2.68 -9.56 -6.28 -6.28 -6.28 -6.28 -6.28
EBITDA 120.9 163.7 93.1 94.9 92.6 112.3 105.2 98.6 92.4 86.6
EBITDA, % 8.24 10.93 4.64 4.86 5.24 6.78 6.78 6.78 6.78 6.78
Depreciation 34.6 33.5 32.6 32.4 31.5 32.0 30.0 28.1 26.3 24.7
Depreciation, % 2.36 2.24 1.62 1.66 1.78 1.93 1.93 1.93 1.93 1.93
EBIT 86.2 130.2 60.5 62.5 61.1 80.3 75.2 70.5 66.1 61.9
EBIT, % 5.88 8.7 3.01 3.2 3.46 4.85 4.85 4.85 4.85 4.85
Total Cash 56.9 4.8 14.6 45.2 117.3 46.0 43.1 40.4 37.8 35.5
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 83.6 99.7 138.3 114.1 95.0
Account Receivables, % 5.7 6.66 6.89 5.84 5.38
Inventories 50.3 61.2 83.6 56.5 41.6 56.0 52.5 49.2 46.1 43.2
Inventories, % 3.42 4.09 4.16 2.89 2.35 3.38 3.38 3.38 3.38 3.38
Accounts Payable 30.8 37.3 49.1 35.6 31.5 35.2 33.0 31.0 29.0 27.2
Accounts Payable, % 2.1 2.49 2.45 1.82 1.79 2.13 2.13 2.13 2.13 2.13
Capital Expenditure -14.1 -15.1 -18.7 -9.0 -10.7 -13.1 -12.3 -11.5 -10.8 -10.1
Capital Expenditure, % -0.96269 -1.01 -0.93199 -0.46148 -0.60319 -0.79337 -0.79337 -0.79337 -0.79337 -0.79337
Tax Rate, % 33.89 33.89 33.89 33.89 33.89 33.89 33.89 33.89 33.89 33.89
EBITAT 63.0 94.1 43.5 39.6 40.4 55.7 52.2 48.9 45.8 42.9
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -19.5 91.9 8.2 100.7 91.1 57.9 77.5 72.6 68.0 63.8
WACC, % 5.08 5.06 5.06 4.89 4.94 5 5 5 5 5
PV UFCF
SUM PV UFCF 294.0
Long Term Growth Rate, % 0.50
Free cash flow (T + 1) 64
Terminal Value 1,423
Present Terminal Value 1,115
Enterprise Value 1,409
Net Debt 187
Equity Value 1,221
Diluted Shares Outstanding, MM 35
Equity Value Per Share 34.63

What You Will Get

  • Real SGU Financial Data: Pre-filled with Star Group, L.P.'s historical and projected data for precise analysis.
  • Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
  • Automatic Calculations: See Star Group, L.P.'s intrinsic value update instantly based on your changes.
  • Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
  • User-Friendly Design: Simple structure and clear instructions for all experience levels.

Key Features

  • Comprehensive SGU Data: Pre-filled with Star Group’s historical performance metrics and future growth estimates.
  • Customizable Assumptions: Modify revenue projections, profit margins, discount rates, tax implications, and capital investments.
  • Interactive Valuation Tool: Real-time updates to Net Present Value (NPV) and intrinsic value based on your customized inputs.
  • Scenario Analysis: Develop various forecasting scenarios to evaluate different valuation results.
  • Intuitive Interface: Clean, organized layout designed for both seasoned professionals and newcomers.

How It Works

  • 1. Access the Template: Download and open the Excel file containing Star Group, L.P.'s (SGU) preloaded data.
  • 2. Modify Assumptions: Adjust key variables such as growth rates, WACC, and capital expenditures.
  • 3. View Results Instantly: The DCF model automatically calculates intrinsic value and NPV.
  • 4. Experiment with Scenarios: Analyze various forecasts to evaluate different valuation results.
  • 5. Present with Assurance: Share professional valuation insights to bolster your decision-making.

Why Choose Star Group, L.P. (SGU) Calculator?

  • Save Time: Skip the hassle of building a DCF model from the ground up – it’s ready for immediate use.
  • Enhance Accuracy: Dependable financial data and formulas minimize valuation errors.
  • Completely Customizable: Adjust the model to align with your specific assumptions and forecasts.
  • User-Friendly: Intuitive charts and outputs simplify the analysis of results.
  • Endorsed by Professionals: Created for experts who prioritize both precision and ease of use.

Who Should Use Star Group, L.P. (SGU)?

  • Investors: Gain insights and make informed choices with a comprehensive analysis tool.
  • Financial Analysts: Enhance efficiency with a customizable financial model tailored for your needs.
  • Consultants: Effortlessly modify the template for impactful client presentations or reports.
  • Energy Sector Enthusiasts: Expand your knowledge of market trends and valuation methods using real-case studies.
  • Educators and Students: Utilize it as a hands-on resource in energy finance and investment courses.

What the Template Contains

  • Pre-Filled DCF Model: Star Group, L.P.’s (SGU) financial data preloaded for immediate use.
  • WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
  • Financial Ratios: Evaluate Star Group, L.P.’s (SGU) 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.

No products were found matching.