Discounted Cash Flow (DCF) Analysis Unlevered

Ideal Power Inc. (IPWR)

$13.14

-0.12 (-0.90%)
All numbers are in Millions, Currency in USD
Stock DCF: - | 13.14 | undervalue

Operating Data

Year
A/P
2017
Actual
2018
Projected
2019
Projected
2020
Projected
2021
Projected
2022
Projected
2023
Projected
2024
Projected
2025
Projected
2026
Projected
Revenue 1.21---------
Revenue (%)
EBITDA -9.98---------
EBITDA (%)
EBIT -10.44---------
EBIT (%)
Depreciation 0.45---------
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 10.02---------
Total Cash (%)
Account Receivables 0.22---------
Account Receivables (%)
Inventories 0.25---------
Inventories (%)
Accounts Payable 0.45---------
Accounts Payable (%)
Capital Expenditure -0.43---------
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 13.14
Beta 0.861
Diluted Shares Outstanding 5.94
Cost of Debt
Tax Rate 0.00
After-tax Cost of Debt -3.89%
Risk-Free Rate
Market Risk Premium
Cost of Equity 6.950
Total Debt 0.33
Total Equity 78.02
Total Capital 78.35
Debt Weighting 0.42
Equity Weighting 99.58
Wacc

Build Up Free Cash

Year
A/P
2017
Actual
2018
Projected
2019
Projected
2020
Projected
2021
Projected
2022
Projected
2023
Projected
2024
Projected
2025
Projected
2026
Projected
Revenue 1.21---------
EBITDA -9.98---------
EBIT -10.44---------
Tax Rate 0.00%-85.06%-25.91%0.00%0.00%-22.19%-22.19%-22.19%-22.19%-22.19%
EBIAT -10.44---------
Depreciation 0.45---------
Accounts Receivable ----------
Inventories ----------
Accounts Payable ----------
Capital Expenditure -0.43-0.13-0.10-0.07-0.04-----
UFCF -10.42---------
WACC
PV UFCF ---------
SUM PV UFCF -

Terminal Value

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

Intrinsic Value

Enterprise Value -
Net Debt -22.84
Equity Value -
Shares Outstanding 5.94
Equity Value Per Share -