Discounted Cash Flow (DCF) Analysis Unlevered

NuStar Energy L.P. (NS)

$16.1

-0.01 (-0.06%)
All numbers are in Millions, Currency in USD
Stock DCF: -34.63 | 16.1 | overvalue

Operating Data

Year
A/P
2017
Actual
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Projected
2023
Projected
2024
Projected
2025
Projected
2026
Projected
Revenue 1,814.021,961.761,498.021,481.561,618.501,588.761,559.561,530.901,502.771,475.16
Revenue (%)
EBITDA 599.41322.17-5.21315.74528.08327.47321.45315.54309.74304.05
EBITDA (%)
EBIT 335.1824.29-286.6730.64253.7058.2257.1556.1055.0754.06
EBIT (%)
Depreciation 264.23297.87281.46285.10274.38269.25264.30259.44254.67249.99
Depreciation (%)

Balance Sheet Data

Year
A/P
2017
Actual
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Projected
2023
Projected
2024
Projected
2025
Projected
2026
Projected
Total Cash 24.2913.6416.19153.635.6443.9543.1542.3541.5840.81
Total Cash (%)
Account Receivables 176.78148.31152.53133.47135.13142.49139.88137.31134.78132.31
Account Receivables (%)
Inventories 26.8622.7112.3911.0616.6416.6516.3516.0515.7515.46
Inventories (%)
Accounts Payable 145.93143.12109.8371.7382.45103.61101.7199.849896.20
Accounts Payable (%)
Capital Expenditure -347.73-465.13-546.30-208.72-179.87-332.21-326.10-320.11-314.23-308.45
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 16.1
Beta 1.980
Diluted Shares Outstanding 109.59
Cost of Debt
Tax Rate 14.92
After-tax Cost of Debt 5.69%
Risk-Free Rate
Market Risk Premium
Cost of Equity 13.037
Total Debt 3,197.75
Total Equity 1,764.33
Total Capital 4,962.08
Debt Weighting 64.44
Equity Weighting 35.56
Wacc

Build Up Free Cash

Year
A/P
2017
Actual
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Projected
2023
Projected
2024
Projected
2025
Projected
2026
Projected
Revenue 1,814.021,961.761,498.021,481.561,618.501,588.761,559.561,530.901,502.771,475.16
EBITDA 599.41322.17-5.21315.74528.08327.47321.45315.54309.74304.05
EBIT 335.1824.29-286.6730.64253.7058.2257.1556.1055.0754.06
Tax Rate 3.64%179.81%151.21%-2.42%14.92%69.43%69.43%69.43%69.43%69.43%
EBIAT 322.99-19.39146.8031.38215.8517.8017.4717.1516.8316.52
Depreciation 264.23297.87281.46285.10274.38269.25264.30259.44254.67249.99
Accounts Receivable -28.47-4.2219.06-1.65-7.372.622.572.522.48
Inventories -4.1410.321.33-5.59-0.010.310.300.290.29
Accounts Payable --2.81-33.29-38.1010.7121.17-1.90-1.87-1.83-1.80
Capital Expenditure -347.74-465.13-546.30-208.72-179.87-332.21-326.10-320.11-314.23-308.45
UFCF 239.49-156.85-145.2390.05313.83-31.37-43.31-42.52-41.73-40.97
WACC
PV UFCF -28.97-36.93-33.47-30.34-27.50
SUM PV UFCF -157.20

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 8.30
Free cash flow (t + 1) -41.79
Terminal Value -663.28
Present Value of Terminal Value -445.20

Intrinsic Value

Enterprise Value -602.40
Net Debt 3,192.11
Equity Value -3,794.52
Shares Outstanding 109.59
Equity Value Per Share -34.63