Energy Transfer LP (ET) DCF Valuation

Energy Transfer LP (ET) DCF Valuation

US | Energy | Oil & Gas Midstream | NYSE
Energy Transfer LP (ET) 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

Energy Transfer LP (ET) Bundle

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

TOTAL:

Simplify Energy Transfer LP (ET) valuation with this customizable DCF Calculator! Featuring real Energy Transfer LP (ET) financials and adjustable forecast inputs, you can explore scenarios and determine Energy Transfer LP (ET) fair value in just minutes.


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 54,213.0 38,954.0 67,417.0 89,876.0 78,586.0 81,565.8 84,658.6 87,868.7 91,200.5 94,658.6
Revenue Growth, % 0 -28.15 73.07 33.31 -12.56 3.79 3.79 3.79 3.79 3.79
EBITDA 10,498.0 9,538.0 12,630.0 12,288.0 12,560.0 15,047.0 15,617.6 16,209.7 16,824.4 17,462.3
EBITDA, % 19.36 24.49 18.73 13.67 15.98 18.45 18.45 18.45 18.45 18.45
Depreciation 3,147.0 3,678.0 3,817.0 4,164.0 4,385.0 5,076.9 5,269.4 5,469.2 5,676.6 5,891.8
Depreciation, % 5.8 9.44 5.66 4.63 5.58 6.22 6.22 6.22 6.22 6.22
EBIT 7,351.0 5,860.0 8,813.0 8,124.0 8,175.0 9,970.1 10,348.2 10,740.5 11,147.8 11,570.5
EBIT, % 13.56 15.04 13.07 9.04 10.4 12.22 12.22 12.22 12.22 12.22
Total Cash 291.0 367.0 336.0 257.0 161.0 402.6 417.9 433.7 450.2 467.3
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 5,343.0 3,989.0 7,740.0 8,627.0 9,215.0
Account Receivables, % 9.86 10.24 11.48 9.6 11.73
Inventories 1,935.0 1,739.0 2,014.0 2,461.0 2,478.0 2,758.9 2,863.5 2,972.1 3,084.8 3,201.8
Inventories, % 3.57 4.46 2.99 2.74 3.15 3.38 3.38 3.38 3.38 3.38
Accounts Payable 4,149.0 2,809.0 6,834.0 6,952.0 6,684.0 6,727.8 6,982.9 7,247.7 7,522.5 7,807.7
Accounts Payable, % 7.65 7.21 10.14 7.74 8.51 8.25 8.25 8.25 8.25 8.25
Capital Expenditure -5,960.0 -5,130.0 -2,822.0 -3,381.0 -3,134.0 -5,888.9 -6,112.1 -6,343.9 -6,584.5 -6,834.1
Capital Expenditure, % -10.99 -13.17 -4.19 -3.76 -3.99 -7.22 -7.22 -7.22 -7.22 -7.22
Tax Rate, % 29.69 29.69 29.69 29.69 29.69 29.69 29.69 29.69 29.69 29.69
EBITAT 7,069.6 2,176.1 7,016.0 6,363.3 5,747.5 7,209.4 7,482.7 7,766.5 8,061.0 8,366.6
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 1,127.6 934.1 8,010.0 5,930.3 6,125.5 6,745.4 6,463.3 6,708.3 6,962.7 7,226.7
WACC, % 8.7 7.37 8.32 8.29 8.11 8.16 8.16 8.16 8.16 8.16
PV UFCF
SUM PV UFCF 27,033.3
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 7,371
Terminal Value 119,680
Present Terminal Value 80,854
Enterprise Value 107,888
Net Debt 53,061
Equity Value 54,827
Diluted Shares Outstanding, MM 3,177
Equity Value Per Share 17.26

What You Will Get

  • Pre-Filled Financial Model: Energy Transfer LP’s actual data facilitates accurate DCF valuation.
  • Full Forecast Control: Modify revenue growth, margins, WACC, and other critical drivers.
  • Instant Calculations: Automatic updates provide real-time results as you make adjustments.
  • Investor-Ready Template: A polished Excel file crafted for high-quality valuation.
  • Customizable and Reusable: Designed for adaptability, enabling repeated use for comprehensive forecasts.

Key Features

  • Accurate Energy Data: Gain access to reliable historical performance metrics and future estimates for Energy Transfer LP (ET).
  • Adjustable Forecast Parameters: Modify highlighted fields such as WACC, growth rates, and profit margins to suit your analysis.
  • Real-Time Calculations: Enjoy automatic updates for DCF, Net Present Value (NPV), and cash flow evaluations.
  • Interactive Dashboard: Utilize clear charts and summaries to effectively illustrate your valuation findings.
  • Designed for All Users: A straightforward, user-friendly layout tailored for investors, CFOs, and consultants alike.

How It Works

  • Step 1: Download the prebuilt Excel template featuring Energy Transfer LP’s (ET) 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 access recalculated results, including Energy Transfer LP’s (ET) intrinsic value.
  • Step 5: Utilize the outputs to make informed investment decisions or create detailed reports.

Why Choose This Calculator for Energy Transfer LP (ET)?

  • Designed for Industry Experts: A sophisticated tool utilized by energy analysts, financial officers, and industry consultants.
  • Accurate Data Integration: Energy Transfer’s historical and projected financial data preloaded for precision.
  • Comprehensive Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
  • Insightful Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
  • User-Friendly Interface: Step-by-step guidance to facilitate your calculations.

Who Should Use This Product?

  • Individual Investors: Make informed decisions about buying or selling Energy Transfer LP (ET) stock.
  • Financial Analysts: Streamline valuation processes with ready-to-use financial models for Energy Transfer LP (ET).
  • Consultants: Deliver professional valuation insights on Energy Transfer LP (ET) to clients quickly and accurately.
  • Business Owners: Understand how large companies like Energy Transfer LP (ET) are valued to guide your own strategy.
  • Finance Students: Learn valuation techniques using real-world data and scenarios related to Energy Transfer LP (ET).

What the Template Contains

  • Pre-Filled Data: Contains Energy Transfer LP’s historical financials and projections.
  • Discounted Cash Flow Model: An editable DCF valuation model featuring automatic calculations.
  • Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC using custom inputs.
  • Key Financial Ratios: Evaluate Energy Transfer LP’s profitability, efficiency, and leverage.
  • Customizable Inputs: Easily modify revenue growth, margins, and tax rates.
  • Clear Dashboard: Visuals and tables summarizing essential valuation outcomes.

No products were found matching.