Discounted Cash Flow (DCF) Analysis Unlevered

Stem, Inc. (STEM)

$11.195

-0.49 (-4.23%)
All numbers are in Millions, Currency in USD
Stock DCF: - | 11.195 | undervalue

Operating Data

Year
A/P
2019
Actual
2020
Actual
2021
Actual
2022
Projected
2023
Projected
2024
Projected
2025
Projected
2026
Projected
Revenue --------
Revenue (%)
EBITDA --------
EBITDA (%)
EBIT --------
EBIT (%)
Depreciation --------
Depreciation (%)

Balance Sheet Data

Year
A/P
2019
Actual
2020
Actual
2021
Actual
2022
Projected
2023
Projected
2024
Projected
2025
Projected
2026
Projected
Total Cash --------
Total Cash (%)
Account Receivables --------
Account Receivables (%)
Inventories --------
Inventories (%)
Accounts Payable --------
Accounts Payable (%)
Capital Expenditure --------
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 11.195
Beta 2.088
Diluted Shares Outstanding 105.56
Cost of Debt
Tax Rate 0.00
After-tax Cost of Debt 5.24%
Risk-Free Rate
Market Risk Premium
Cost of Equity 13.453
Total Debt 331.65
Total Equity 1,181.76
Total Capital 1,513.41
Debt Weighting 21.91
Equity Weighting 78.09
Wacc

Build Up Free Cash

Year
A/P
2019
Actual
2020
Actual
2021
Actual
2022
Projected
2023
Projected
2024
Projected
2025
Projected
2026
Projected
Revenue --------
EBITDA --------
EBIT --------
Tax Rate 0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%
EBIAT --------
Depreciation --------
Accounts Receivable --------
Inventories --------
Accounts Payable --------
Capital Expenditure --12.04-10.17-----
UFCF --------
WACC
PV UFCF -----
SUM PV UFCF -

Terminal Value

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

Intrinsic Value

Enterprise Value -
Net Debt -416.13
Equity Value -
Shares Outstanding 105.56
Equity Value Per Share -