Sunoco LP (SUN) DCF Valuation

Sunoco LP (SUN) 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

Sunoco LP (SUN) 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:

Designed for accuracy, our Sunoco LP (SUN) DCF Calculator empowers you to evaluate Sunoco LP (SUN) valuation using real-world financial data, offering complete flexibility to modify all essential parameters for enhanced projections.


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 16,596.0 10,710.0 17,596.0 25,729.0 23,068.0 26,799.7 31,135.0 36,171.6 42,023.0 48,820.9
Revenue Growth, % 0 -35.47 64.3 46.22 -10.34 16.18 16.18 16.18 16.18 16.18
EBITDA 537.0 602.0 894.0 877.0 837.0 1,124.2 1,306.1 1,517.4 1,762.8 2,048.0
EBITDA, % 3.24 5.62 5.08 3.41 3.63 4.19 4.19 4.19 4.19 4.19
Depreciation 183.0 189.0 177.0 193.0 187.0 291.3 338.4 393.1 456.7 530.6
Depreciation, % 1.1 1.76 1.01 0.75013 0.81065 1.09 1.09 1.09 1.09 1.09
EBIT 354.0 413.0 717.0 684.0 650.0 832.9 967.7 1,124.2 1,306.1 1,517.4
EBIT, % 2.13 3.86 4.07 2.66 2.82 3.11 3.11 3.11 3.11 3.11
Total Cash 21.0 97.0 25.0 82.0 29.0 86.8 100.8 117.1 136.0 158.1
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 411.0 306.0 538.0 905.0 876.0
Account Receivables, % 2.48 2.86 3.06 3.52 3.8
Inventories 419.0 382.0 534.0 821.0 889.0 866.8 1,007.0 1,169.9 1,359.1 1,579.0
Inventories, % 2.52 3.57 3.03 3.19 3.85 3.23 3.23 3.23 3.23 3.23
Accounts Payable 494.0 267.0 515.0 966.0 998.0 883.2 1,026.0 1,192.0 1,384.8 1,608.9
Accounts Payable, % 2.98 2.49 2.93 3.75 4.33 3.3 3.3 3.3 3.3 3.3
Capital Expenditure -148.0 -124.0 -174.0 -186.0 -215.0 -251.6 -292.3 -339.5 -394.5 -458.3
Capital Expenditure, % -0.89178 -1.16 -0.98886 -0.72292 -0.93203 -0.93868 -0.93868 -0.93868 -0.93868 -0.93868
Tax Rate, % 27.67 27.67 27.67 27.67 27.67 27.67 27.67 27.67 27.67 27.67
EBITAT 374.3 371.0 577.2 542.0 470.1 702.8 816.5 948.6 1,102.1 1,280.4
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 73.3 351.0 444.2 346.0 435.1 684.1 729.1 847.1 984.1 1,143.3
WACC, % 8.05 7.78 7.54 7.51 7.33 7.64 7.64 7.64 7.64 7.64
PV UFCF
SUM PV UFCF 3,468.2
Long Term Growth Rate, % 1.00
Free cash flow (T + 1) 1,155
Terminal Value 17,386
Present Terminal Value 12,031
Enterprise Value 15,499
Net Debt 4,084
Equity Value 11,415
Diluted Shares Outstanding, MM 85
Equity Value Per Share 134.15

What You Will Get

  • Real SUN Financials: Access to historical and projected data for precise valuation.
  • Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
  • Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
  • Scenario Analysis: Evaluate various scenarios to assess Sunoco's future performance.
  • User-Friendly Design: Designed for professionals but easy enough for beginners to navigate.

Key Features

  • Accurate SUN Data: Pre-loaded with Sunoco LP’s historical financial information and future projections.
  • Comprehensive Input Customization: Modify revenue growth rates, profit margins, WACC, tax implications, and capital expenditures.
  • Interactive Valuation Framework: Real-time updates to Net Present Value (NPV) and intrinsic value based on your adjustments.
  • Scenario Analysis: Develop various forecasting scenarios to evaluate different valuation possibilities.
  • Intuitive User Interface: Well-organized, easy to navigate, suitable for both seasoned professionals and newcomers.

How It Functions

  1. Download the Template: Gain immediate access to the Excel-based SUN DCF Calculator.
  2. Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and more.
  3. Instant Calculations: The model automatically refreshes Sunoco LP’s intrinsic value.
  4. Test Scenarios: Experiment with various assumptions to assess potential valuation shifts.
  5. Analyze and Decide: Utilize the outcomes to inform your investment or financial analysis.

Why Choose the Sunoco LP (SUN) Calculator?

  • Accuracy: Utilizes real Sunoco LP financial data to ensure precise calculations.
  • Flexibility: Allows users to easily test and adjust inputs as needed.
  • Time-Saving: Avoid the complexities of creating a financial model from the ground up.
  • Professional-Grade: Crafted with the expertise and usability expected at the CFO level.
  • User-Friendly: Intuitive interface designed for users of all financial backgrounds.

Who Should Use Sunoco LP (SUN)?

  • Investors: Gain insights and make informed decisions with Sunoco's robust investment strategies.
  • Financial Analysts: Streamline your analysis with comprehensive data and reports tailored for Sunoco (SUN).
  • Consultants: Effortlessly customize presentations and reports focused on Sunoco's market performance.
  • Energy Sector Enthusiasts: Enhance your knowledge of the energy market through Sunoco's operational examples.
  • Educators and Students: Utilize Sunoco (SUN) as a case study in energy finance and investment courses.

What the Template Contains

  • Pre-Filled DCF Model: Sunoco LP’s financial data preloaded for immediate use.
  • WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
  • Financial Ratios: Evaluate Sunoco LP’s 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.

Es wurden keine passenden Produkte gefunden.