Discounted Cash Flow (DCF) Analysis Unlevered

NuStar Logistics, L.P. SB NT FX/FL ... (NSS)

$25.1499

+0.09 (+0.36%)
All numbers are in Millions, Currency in USD
Stock DCF: - | 25.1499 | undervalue

Operating Data

Year
A/P
2021
Actual
2022
Projected
2023
Projected
2024
Projected
2025
Projected
2026
Projected
Revenue 1,618.50-----
Revenue (%)
EBITDA 102.51-----
EBITDA (%)
EBIT -171.87-----
EBIT (%)
Depreciation 274.38-----
Depreciation (%)

Balance Sheet Data

Year
A/P
2021
Actual
2022
Projected
2023
Projected
2024
Projected
2025
Projected
2026
Projected
Total Cash 5.64-----
Total Cash (%)
Account Receivables 135.13-----
Account Receivables (%)
Inventories 16.64-----
Inventories (%)
Accounts Payable 82.45-----
Accounts Payable (%)
Capital Expenditure -181.13-----
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 25.1,499
Beta 0.414
Diluted Shares Outstanding 77.89
Cost of Debt
Tax Rate 9.23
After-tax Cost of Debt -6.09%
Risk-Free Rate
Market Risk Premium
Cost of Equity 5.411
Total Debt 3,187.40
Total Equity 1,958.83
Total Capital 5,146.23
Debt Weighting 61.94
Equity Weighting 38.06
Wacc

Build Up Free Cash

Year
A/P
2021
Actual
2022
Projected
2023
Projected
2024
Projected
2025
Projected
2026
Projected
Revenue 1,618.50-----
EBITDA 102.51-----
EBIT -171.87-----
Tax Rate 9.23%9.23%9.23%9.23%9.23%9.23%
EBIAT -156-----
Depreciation 274.38-----
Accounts Receivable ------
Inventories ------
Accounts Payable ------
Capital Expenditure -181.13-----
UFCF -62.76-----
WACC
PV UFCF -----
SUM PV UFCF -

Terminal Value

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

Intrinsic Value

Enterprise Value -
Net Debt 3,181.77
Equity Value -
Shares Outstanding 77.89
Equity Value Per Share -