Discounted Cash Flow (DCF) Analysis Unlevered

Operating Data

Year
A/P
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
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 $ -
Beta 0
Diluted Shares Outstanding 7.93
Cost of Debt
Tax Rate -4.50
After-tax Cost of Debt 5.00%
Risk-Free Rate
Market Risk Premium
Cost of Equity 2.460
Total Debt 8.57
Total Equity -
Total Capital 8.57
Debt Weighting 100.00
Equity Weighting 0.00
Wacc

Build Up Free Cash

Year
A/P
2018
Projected
2019
Projected
2020
Projected
2021
Projected
2022
Projected
2023
Projected
2024
Projected
2025
Projected
Revenue --------
EBITDA --------
EBIT --------
Tax Rate -7.88%-27.89%-4.50%-13.42%-13.42%-13.42%-13.42%-13.42%
EBIAT --------
Depreciation --------
Accounts Receivable --------
Inventories --------
Accounts Payable --------
Capital Expenditure -0.02-------
UFCF --------
WACC
PV UFCF --------
SUM PV UFCF -

Terminal Value

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

Intrinsic Value

Enterprise Value -
Net Debt 8.56
Equity Value -
Shares Outstanding 7.93
Equity Value Per Share -