Hess Midstream LP (HESM) DCF Valuation

Hess Midstream LP (HESM) 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

Hess Midstream LP (HESM) 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 strategies with the Hess Midstream LP (HESM) DCF Calculator! View real Hess financial data, adjust growth projections and expenses, and instantly observe how these modifications affect the intrinsic value of Hess Midstream LP (HESM).


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 848.3 1,091.9 1,203.8 1,275.2 1,348.6 1,458.6 1,577.6 1,706.2 1,845.4 1,995.9
Revenue Growth, % 0 28.72 10.25 5.93 5.76 8.16 8.16 8.16 8.16 8.16
EBITDA 545.3 733.4 903.4 972.5 1,017.1 1,044.9 1,130.1 1,222.3 1,322.0 1,429.8
EBITDA, % 64.28 67.17 75.05 76.26 75.42 71.64 71.64 71.64 71.64 71.64
Depreciation 142.5 156.9 165.6 181.3 192.5 214.2 231.6 250.5 271.0 293.1
Depreciation, % 16.8 14.37 13.76 14.22 14.27 14.68 14.68 14.68 14.68 14.68
EBIT 402.8 576.5 737.8 791.2 824.6 830.7 898.5 971.7 1,051.0 1,136.7
EBIT, % 47.48 52.8 61.29 62.05 61.14 56.95 56.95 56.95 56.95 56.95
Total Cash 3.3 2.6 2.2 3.1 5.4 4.2 4.6 5.0 5.4 5.8
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 87.9 93.2 120.3 123.0 124.4
Account Receivables, % 10.36 8.54 9.99 9.65 9.22
Inventories .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Inventories, % 0 0 0 0 0 0 0 0 0 0
Accounts Payable 30.6 30.0 26.9 35.0 79.7 50.3 54.4 58.8 63.6 68.8
Accounts Payable, % 3.61 2.75 2.23 2.74 5.91 3.45 3.45 3.45 3.45 3.45
Capital Expenditure -306.4 -301.1 -163.2 -238.2 -223.5 -328.2 -355.0 -383.9 -415.2 -449.1
Capital Expenditure, % -36.12 -27.58 -13.56 -18.68 -16.57 -22.5 -22.5 -22.5 -22.5 -22.5
Tax Rate, % 81.63 81.63 81.63 81.63 81.63 81.63 81.63 81.63 81.63 81.63
EBITAT 402.9 567.9 720.8 758.7 151.5 682.0 737.6 797.7 862.8 933.2
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 181.7 417.8 693.0 707.2 163.8 523.6 607.0 656.5 710.0 767.9
WACC, % 7.87 7.82 7.79 7.73 5.09 7.26 7.26 7.26 7.26 7.26
PV UFCF
SUM PV UFCF 2,625.2
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 783
Terminal Value 14,892
Present Terminal Value 10,490
Enterprise Value 13,115
Net Debt 3,206
Equity Value 9,909
Diluted Shares Outstanding, MM 56
Equity Value Per Share 176.01

What You Will Get

  • Comprehensive HESM Financials: Access to historical and projected data for precise valuation.
  • Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
  • Real-Time Calculations: Intrinsic value and NPV are computed automatically.
  • Scenario Analysis: Evaluate various scenarios to assess Hess Midstream's future performance.
  • User-Friendly Design: Designed for industry professionals while remaining approachable for newcomers.

Key Features

  • Real-Time HESM Data: Pre-loaded with Hess Midstream's historical performance metrics and future projections.
  • Customizable Parameters: Modify revenue growth rates, profit margins, WACC, tax rates, and capital investments.
  • Adaptive Valuation Framework: Instant updates to Net Present Value (NPV) and intrinsic value based on your adjustments.
  • Scenario Analysis: Develop various forecasting scenarios to evaluate different valuation possibilities.
  • User-Centric Interface: Intuitive, organized, and suitable for both experts and newcomers.

How It Works

  1. Step 1: Download the Excel file.
  2. Step 2: Review pre-entered Hess Midstream data (historical and projected).
  3. Step 3: Adjust key assumptions (yellow cells) based on your analysis.
  4. Step 4: View automatic recalculations for Hess Midstream’s intrinsic value.
  5. Step 5: Use the outputs for investment decisions or reporting.

Why Choose This Calculator for Hess Midstream LP (HESM)?

  • Accuracy: Utilizes real Hess Midstream financial data for precise results.
  • Flexibility: Allows users to easily adjust and experiment with various inputs.
  • Time-Saving: Avoid the complexities of constructing a DCF model from the ground up.
  • Professional-Grade: Crafted with the expertise and functionality expected at the CFO level.
  • User-Friendly: Intuitive interface suitable for users with varying levels of financial modeling expertise.

Who Should Use This Product?

  • Finance Students: Explore cash flow analysis and apply it to real-world data from Hess Midstream LP (HESM).
  • Academics: Integrate industry-standard models into your teaching or research involving Hess Midstream LP (HESM).
  • Investors: Validate your investment strategies and evaluate the financial performance of Hess Midstream LP (HESM).
  • Analysts: Enhance your analysis process with a tailored, ready-to-use DCF model for Hess Midstream LP (HESM).
  • Small Business Owners: Understand the financial metrics used to assess companies like Hess Midstream LP (HESM).

What the Template Contains

  • Preloaded HESM Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
  • DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
  • Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
  • Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
  • Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
  • Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.

No products were found matching.