Discounted Cash Flow (DCF) Analysis Unlevered

Rubicon Technology, Inc. (RBCN)

$2.11

-0.01 (-0.47%)
All numbers are in Millions, Currency in USD
Stock DCF: - | 2.11 | undervalue

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 5.043.883.534.474.063.913.773.633.503.37
Revenue (%)
EBITDA -16.591.34-0.96-0.91-0.32-2.74-2.64-2.54-2.45-2.36
EBITDA (%)
EBIT -17.760.99-1.13-1.08-0.46-3.08-2.97-2.86-2.76-2.66
EBIT (%)
Depreciation 1.170.350.170.170.140.350.330.320.310.30
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 1825.6024.1711.1326.0120.2819.5418.8318.1417.48
Total Cash (%)
Account Receivables 0.720.731.050.390.720.700.670.650.630.60
Account Receivables (%)
Inventories 3.872.311.851.070.661.791.731.661.601.54
Inventories (%)
Accounts Payable 0.580.400.730.500.550.530.510.490.470.45
Accounts Payable (%)
Capital Expenditure ----------
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 2.11
Beta 1.169
Diluted Shares Outstanding 2.50
Cost of Debt
Tax Rate -59.04
After-tax Cost of Debt -%
Risk-Free Rate
Market Risk Premium
Cost of Equity 9.400
Total Debt -
Total Equity 5.27
Total Capital -
Debt Weighting -
Equity Weighting -
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 5.043.883.534.474.063.913.773.633.503.37
EBITDA -16.591.34-0.96-0.91-0.32-2.74-2.64-2.54-2.45-2.36
EBIT -17.760.99-1.13-1.08-0.46-3.08-2.97-2.86-2.76-2.66
Tax Rate -0.50%2.43%-1.96%-1.24%-59.04%-12.06%-12.06%-12.06%-12.06%-12.06%
EBIAT -17.850.96-1.15-1.09-0.73-3.46-3.33-3.21-3.09-2.98
Depreciation 1.170.350.170.170.140.350.330.320.310.30
Accounts Receivable --0.02-0.320.67-0.330.020.030.020.020.02
Inventories -1.550.460.780.41-1.130.070.060.060.06
Accounts Payable --0.180.33-0.240.05-0.02-0.02-0.02-0.02-0.02
Capital Expenditure ----------
UFCF ------4.24-2.92-2.82-2.71-2.61
WACC
PV UFCF -----
SUM PV UFCF -

Terminal Value

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

Intrinsic Value

Enterprise Value -
Net Debt -11.26
Equity Value -
Shares Outstanding 2.50
Equity Value Per Share -