Discounted Cash Flow (DCF) Analysis Unlevered

SG Blocks Inc

SG Blocks Inc (SGBX)

$2.4
-0.01 (-0.41%)

Operating Data

Year
A/P
2013
Actual
2014
Actual
2015
Actual
2016
Actual
2017
Actual
2018
Actual
2019
Actual
2020
Projected
2021
Projected
2022
Projected
2023
Projected
2024
Projected
Revenue 2.456.042.411.925.068.192.984.125.687.8310.8014.89
Revenue (%)
EBITDA -1.94-0.84-1.670.27-4.16-4.25-6.93-3.03-4.18-5.76-7.94-10.96
EBITDA (%)
EBIT -1.94-0.85-1.68-0.03-4.75-4.85-7.10-3.30-4.56-6.28-8.66-11.95
EBIT (%)
Depreciation -0.000.000.290.590.600.160.270.380.520.720.99
Depreciation (%)

Balance Sheet Data

Year
A/P
2013
Actual
2014
Actual
2015
Actual
2016
Actual
2017
Actual
2018
Actual
2019
Actual
2020
Projected
2021
Projected
2022
Projected
2023
Projected
2024
Projected
Total Cash 0.630.920.500.584.901.371.631.532.112.914.015.53
Total Cash (%)
Account Receivables 0.250.170.090.233.012.011.210.901.241.712.363.26
Account Receivables (%)
Inventories 0.030.030.160.010.110.180.070.090.130.170.240.33
Inventories (%)
Accounts Payable ------2.112.904.005.527.6210.50
Accounts Payable (%)
Capital Expenditure -0.01-0.00-0.01-0.00-0.01-0.02-0.01-0.01-0.01-0.02-0.02-0.03
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 2.4
Beta -6.244
Diluted Shares Outstanding 0.30
Cost of Debt
Tax Rate 0.00
After-tax Cost of Debt 5.00%
Risk-Free Rate
Market Risk Premium
Cost of Equity -47.241
Total Debt -
Total Equity 0.73
Total Capital 0.73
Debt Weighting 0.00
Equity Weighting 100.00
Wacc

Build Up Free Cash

Year
A/P
2013
Actual
2014
Actual
2015
Actual
2016
Actual
2017
Actual
2018
Actual
2019
Actual
2020
Projected
2021
Projected
2022
Projected
2023
Projected
2024
Projected
Revenue 2.456.042.411.925.068.192.984.125.687.8310.8014.89
EBITDA -1.94-0.84-1.670.27-4.16-4.25-6.93-3.03-4.18-5.76-7.94-10.96
EBIT -1.94-0.85-1.68-0.03-4.75-4.85-7.10-3.30-4.56-6.28-8.66-11.95
Tax Rate 0.03%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%
EBIAT -1.94-0.85-1.68-0.03-4.75-4.85-7.10-3.30-4.56-6.28-8.66-11.95
Depreciation -0.000.000.290.590.600.160.270.380.520.720.99
Accounts Receivable -0.080.08-0.15-2.771.000.800.31-0.34-0.47-0.65-0.89
Inventories --0.00-0.120.15-0.10-0.070.12-0.03-0.03-0.05-0.07-0.09
Accounts Payable -------0.801.101.522.092.89
Capital Expenditure -0.01-0.00-0.01-0.00-0.00-0.08-0.00-0.01-0.01-0.02-0.02-0.03
UFCF -1.95-0.77-1.720.26-7.04-3.34-6.03-1.96-3.46-4.78-6.59-9.09
WACC
PV UFCF -3.71-12.45-32.53-85.04-222.28
SUM PV UFCF -356.00

Terminal Value

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

Intrinsic Value

Enterprise Value 95.15
Net Debt -1.63
Equity Value 96.77
Shares Outstanding 0.30
Equity Value Per Share 319.55