Discounted Cash Flow (DCF) Analysis Unlevered

Creatd, Inc. (CRTD)

$0.7361

-0.07 (-9.07%)
All numbers are in Millions, Currency in USD
Stock DCF: -22,783.52 | 0.7361 | 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 0.100.080.451.214.3013.6243.13136.58432.541,369.83
Revenue (%)
EBITDA -6.41-8.96-6.96-18.38-37.01-590.54-1,870.23-5,922.97-18,757.93-59,405.98
EBITDA (%)
EBIT -6.45-9-7.07-18.53-38.42-595.02-1,884.40-5,967.86-18,900.10-59,856.25
EBIT (%)
Depreciation 0.040.040.120.161.414.4814.1844.89142.17450.26
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 0.110.090.531.414.9915.8150.07158.56502.161,590.34
Total Cash (%)
Account Receivables 00.010.060.090.341.053.3210.5133.28105.39
Account Receivables (%)
Inventories ----0.110.341.073.3810.7033.90
Inventories (%)
Accounts Payable 1.461.251.762.6439.51125.13396.301,255.073,974.7812,588.06
Accounts Payable (%)
Capital Expenditure -0.01-0.03-0.03-0.04-0.64-2.02-6.40-20.25-64.14-203.13
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 0.7,361
Beta 3.943
Diluted Shares Outstanding 4.81
Cost of Debt
Tax Rate -0.87
After-tax Cost of Debt 29.10%
Risk-Free Rate
Market Risk Premium
Cost of Equity 22.117
Total Debt 1.28
Total Equity 3.54
Total Capital 4.82
Debt Weighting 26.52
Equity Weighting 73.48
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 0.100.080.451.214.3013.6243.13136.58432.541,369.83
EBITDA -6.41-8.96-6.96-18.38-37.01-590.54-1,870.23-5,922.97-18,757.93-59,405.98
EBIT -6.45-9-7.07-18.53-38.42-595.02-1,884.40-5,967.86-18,900.10-59,856.25
Tax Rate 0.00%0.00%0.00%0.00%-0.87%-0.17%-0.17%-0.17%-0.17%-0.17%
EBIAT -6.45-9-7.07-18.53-38.75-596.05-1,887.67-5,978.22-18,932.92-59,960.17
Depreciation 0.040.040.120.161.414.4814.1844.89142.17450.26
Accounts Receivable --0.01-0.06-0.03-0.25-0.71-2.27-7.19-22.77-72.12
Inventories ------0.23-0.73-2.31-7.32-23.19
Accounts Payable --0.220.520.8836.8785.62271.16858.772,719.718,613.28
Capital Expenditure -0.01-0.03-0.03-0.04-0.64-2.02-6.40-20.25-64.14-203.13
UFCF -6.42-9.21-6.52-17.57-1.35-508.91-1,611.73-5,104.31-16,165.26-51,195.07
WACC
PV UFCF -410.51-1,048.72-2,679.09-6,844.10-17,484.18
SUM PV UFCF -28,466.60

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 23.97
Free cash flow (t + 1) -52,218.98
Terminal Value -237,683.09
Present Value of Terminal Value -81,173.69

Intrinsic Value

Enterprise Value -109,640.29
Net Debt -2.52
Equity Value -109,637.77
Shares Outstanding 4.81
Equity Value Per Share -22,783.52