Discounted Cash Flow (DCF) Analysis Unlevered

Sphere 3D Corp. (ANY)

$ 2.6
-0.18 (-6.47%)

Operating Data

Year
A/P
2013
Projected
2014
Projected
2015
Projected
2016
Projected
2017
Projected
2018
Projected
2019
Projected
2020
Projected
2021
Projected
2022
Projected
2023
Projected
2024
Projected
2025
Projected
Revenue -------------
Revenue (%)
EBITDA -------------
EBITDA (%)
EBIT -------------
EBIT (%)
Depreciation -------------
Depreciation (%)

Balance Sheet Data

Year
A/P
2013
Actual
2014
Actual
2015
Actual
2016
Actual
2017
Actual
2018
Actual
2019
Actual
2020
Actual
2021
Projected
2022
Projected
2023
Projected
2024
Projected
2025
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 $ 2.6
Beta 2.087
Diluted Shares Outstanding 2.69
Cost of Debt
Tax Rate -0.07
After-tax Cost of Debt 5.00%
Risk-Free Rate
Market Risk Premium
Cost of Equity 19.069
Total Debt 2.50
Total Equity 7
Total Capital 9.50
Debt Weighting 26.34
Equity Weighting 73.66
Wacc

Build Up Free Cash

Year
A/P
2013
Projected
2014
Projected
2015
Projected
2016
Projected
2017
Projected
2018
Projected
2019
Projected
2020
Projected
2021
Projected
2022
Projected
2023
Projected
2024
Projected
2025
Projected
Revenue -------------
EBITDA -------------
EBIT -------------
Tax Rate 0.00%-0.33%2.81%-1.22%5.87%-106.59%0.00%-0.07%-12.44%-12.44%-12.44%-12.44%-12.44%
EBIAT -------------
Depreciation -------------
Accounts Receivable -------------
Inventories -------------
Accounts Payable -------------
Capital Expenditure -1.13-6-0.58-0.24-0.12-0.06-------
UFCF -------------
WACC
PV UFCF -------------
SUM PV UFCF -

Terminal Value

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

Intrinsic Value

Enterprise Value -
Net Debt 2.04
Equity Value -
Shares Outstanding 2.69
Equity Value Per Share -