Definitive Analysis
Definitive Analysis
Financial Statements
Periods / Units
Fundamentals
Valuations
Miscellaneous
Analysis Mode
Full Access
See Pricing Start Trial

NGL Energy Partners LP

Intrinsic Value Analysis (Discounted Cash Flow)Industry: Oil & Gas MidstreamSector: Energy

Fair Value Summary

Current Price$9.70
5Y Range57.97 – 94.89
5Y Selected76.43
(-) Safety Margin80.60%
5Y Buy Price$14.83
Upside (to Buy Price)52.86%
10Y Range54.76 – 85.34
10Y Selected70.05
(-) Safety Margin80.60%
10Y Buy Price$13.59
Upside (to Buy Price)40.10%

Company Predictability & Safety

MetricValue
Revenue R2 (5Y)0.2495
Revenue R2 (10Y)0.6399
Net Income R2 (5Y)0.6230
Net Income R2 (10Y)0.0048
EBITDA R2 (5Y)0.3237
EBITDA R2 (10Y)0.3761
FCF R2 (5Y)0.0465
FCF R2 (10Y)0.5984
Safety Score0.1940

DA 10-Year Projection

Metric2026202720282029203020312032203320342035
% Growth-11.47%-9.75%-8.03%-6.31%-4.59%-2.87%-1.16%0.56%2.28%4.00%
Revenue3,071.422,772.032,549.472,388.582,278.892,213.412,187.832,200.162,250.352,340.37
EBITDA1,481.861,337.421,230.041,152.421,099.501,067.901,055.561,061.511,085.731,129.15
D&A-93.93-84.78-77.97-73.05-69.69-67.69-66.91-67.29-68.82-71.57
EBIT1,387.931,252.641,152.071,079.371,029.801,000.21988.65994.221,016.901,057.58
Pro forma Taxes-291.47-263.06-241.93-226.67-216.26-210.04-207.62-208.79-213.55-222.09
NOPAT1,096.47989.59910.13852.70813.54790.16781.04785.43803.35835.49
Capital Expenditures-110.28-99.53-91.54-85.76-81.82-79.47-78.55-79.00-80.80-84.03
NWC Investment28.1121.1615.7311.377.754.631.81-0.87-3.55-6.36
(+) D&A93.9384.7877.9773.0569.6967.6966.9167.2968.8271.57
Free Cash Flow1,108.23995.99912.29851.36809.17783.01771.20772.85787.83816.67
Diluted Shares Outstanding130,836,966.00130,836,966.00130,836,966.00130,836,966.00130,836,966.00130,836,966.00130,836,966.00130,836,966.00130,836,966.00130,836,966.00

Discounting Periods

MetricMar-26Mar-27Mar-28Mar-29Mar-30Mar-31Mar-32Mar-33Mar-34Mar-35
Period Start9/30/254/1/264/1/274/1/284/1/294/1/304/1/314/1/324/1/334/1/34
Period End3/31/263/31/273/31/283/31/293/31/303/31/313/31/323/31/333/31/343/31/35
Mid-Point12/30/259/30/269/30/279/30/289/30/299/30/309/30/319/30/329/30/339/30/34
Time (t)0.100.701.712.713.714.715.716.717.718.71
Valuation Date1/16/26

Base Case Projected Flows

WACC: 9.10%Terminal Growth: 2.32%
Metric2026202720282029203020312032203320342035TV (5y)TV (10y)
Discount Factor0.990.940.860.790.720.660.610.560.510.47
PV UFCF1,098.62937.10786.08672.40585.78519.58469.06430.87402.59382.53
Raw: 12,214.99
8,466.12
Raw: 12,328.31
5,528.55

Base Case Valuation

5-Year Horizon10-Year Horizon
UFCFUFCF
Enterprise Value12,546.1111,813.17
(-) Net Debt3,079.003,079.00
Equity Value9,467.118,734.17
(/) Shares Out130.84130.84
Fair Value$72.36$66.76
(-) Safety Margin80.60%80.60%
Buy Price$14.04$12.95
Current Price$9.70$9.70
Upside (to Buy Price)44.72%33.51%

Conservative Projected Flows

WACC: 10.10%Terminal Growth: 1.82%
Metric2026202720282029203020312032203320342035TV (5y)TV (10y)
Discount Factor0.990.930.850.770.700.640.580.520.480.43
PV UFCF1,097.62931.13773.91655.98566.29497.72445.25405.28375.24353.30
Raw: 9,952.74
6,638.21
Raw: 10,045.07
4,141.56

Conservative Valuation

5-Year Horizon10-Year Horizon
UFCFUFCF
Enterprise Value10,663.1410,243.29
(-) Net Debt3,079.003,079.00
Equity Value7,584.147,164.30
(/) Shares Out130.84130.84
Fair Value$57.97$54.76
(-) Safety Margin80.60%80.60%
Buy Price$11.25$10.62
Current Price$9.70$9.70
Upside (to Buy Price)15.93%9.51%

Aggressive Projected Flows

WACC: 8.10%Terminal Growth: 2.82%
Metric2026202720282029203020312032203320342035TV (5y)TV (10y)
Discount Factor0.990.950.880.810.750.690.640.590.550.51
PV UFCF1,099.63943.16798.56689.39606.14542.61494.39458.33432.21414.47
Raw: 15,763.10
11,357.15
Raw: 15,909.33
7,765.89

Aggressive Valuation

5-Year Horizon10-Year Horizon
UFCFUFCF
Enterprise Value15,494.0314,244.79
(-) Net Debt3,079.003,079.00
Equity Value12,415.0311,165.79
(/) Shares Out130.84130.84
Fair Value$94.89$85.34
(-) Safety Margin80.60%80.60%
Buy Price$18.41$16.56
Current Price$9.70$9.70
Upside (to Buy Price)89.78%70.68%

Reverse DCF: Market Implied Growth

Current Price$9.70
WACC Used9.1%
IMPLIED REVENUE GROWTH122.52%
Metric2027202820292030203120322033203420352036
Implied Revenue4,508.4810,032.3722,324.2249,676.30110,540.69245,977.32547,353.591,217,982.002,710,277.586,030,963.14
Constant Implied Growth122.52%122.52%122.52%122.52%122.52%122.52%122.52%122.52%122.52%122.52%
Implied Free Cash Flow0.451.002.234.9711.0524.6054.74121.80271.03603.10
Discount Factor0.960.860.790.720.660.610.560.510.470.43
Present Value of Implied FCF0.430.861.763.607.3414.9630.5262.24126.95258.93

Rolling Historical DCF (Backtest)

Valuation based on actual realized growth.
YearValuation DateActual PriceRealized Growth (5Y)Calculated Fair ValueValuation Delta
20202020-03-31$2.60-15.33%$-31.22-1,300.95%
20192019-03-31$14.07-7.84%$-27.54-295.73%
20182018-03-31$11.00-0.97%$-21.47-295.18%
20172017-03-31$22.60-22.06%$-46.55-305.95%
20162016-03-31$7.52-30.32%$-37.70-601.34%
20152015-03-31$26.23-17.98%$-13.58-151.78%
20142014-03-31$37.53-18.05%$-34.53-192.01%
20132013-03-31$27.44-7.06%$-2.06-107.51%
20122012-03-31$20.61-0.94%$64.84214.61%
20112011-03-31$20.9811.19%$-40.62-293.62%
20102010-03-31$20.9838.86%$44.64112.76%
20092009-03-31$20.9825.43%$85.94309.64%

Monte Carlo Simulation (1,000 Iterations)

Mean Fair Value
$68.91
Median
$66.41
10th Percentile
$54.09
90th Percentile
$86.08

Fair Value Distribution

$38.52 - $43.98
8
$43.98 - $49.43
26
$49.43 - $54.88
87
$54.88 - $60.33
148
$60.33 - $65.79
206
$65.79 - $71.24
163
$71.24 - $76.69
121
$76.69 - $82.14
106
$82.14 - $87.60
46
$87.60 - $93.05
38
$93.05 - $98.50
20
$98.50 - $103.95
11
$103.95 - $109.41
8
$109.41 - $114.86
1
$114.86 - $120.31
4
$120.31 - $125.76
3
$125.76 - $131.22
1
$131.22 - $136.67
0
$136.67 - $142.12
2
$142.12 - $147.57
1