Discounted Cash Flow (DCF) Analysis Unlevered

AxoGen, Inc. (AXGN)

$9.58

+0.20 (+2.13%)
All numbers are in Millions, Currency in USD
Stock DCF: -54.84 | 9.58 | overvalue

Operating Data

Year
A/P
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Revenue 83.94106.71112.30127.36138.58157.50178.99203.42231.19262.74
Revenue (%)
EBITDA -20.34-26.22-19.27-20.89-23.47-31.28-35.55-40.40-45.91-52.18
EBITDA (%)
EBIT -21.19-29.10-22.73-25.63-28.32-35.69-40.56-46.10-52.39-59.54
EBIT (%)
Depreciation 0.852.883.464.744.854.415.025.706.487.36
Depreciation (%)

Balance Sheet Data

Year
A/P
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Total Cash 116.6196.51103.9784.0948.79133.30151.49172.16195.66222.37
Total Cash (%)
Account Receivables 15.3216.9417.6218.1622.1925.2328.6732.5837.0342.08
Account Receivables (%)
Inventories 11.9813.8612.5316.6918.9120.5323.3326.5130.1334.25
Inventories (%)
Accounts Payable 4.528.264.605.928.968.9310.1411.5313.1014.89
Accounts Payable (%)
Capital Expenditure -6.60-5.23-22.60-28.40-21.25-22.21-25.25-28.69-32.61-37.06
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 9.58
Beta 0.622
Diluted Shares Outstanding 42.08
Cost of Debt
Tax Rate 0.00
After-tax Cost of Debt 0.93%
Risk-Free Rate
Market Risk Premium
Cost of Equity 6.650
Total Debt 67.43
Total Equity 403.16
Total Capital 470.58
Debt Weighting 14.33
Equity Weighting 85.67
Wacc

Build Up Free Cash

Year
A/P
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Revenue 83.94106.71112.30127.36138.58157.50178.99203.42231.19262.74
EBITDA -20.34-26.22-19.27-20.89-23.47-31.28-35.55-40.40-45.91-52.18
EBIT -21.19-29.10-22.73-25.63-28.32-35.69-40.56-46.10-52.39-59.54
Tax Rate 0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%
EBIAT -21.19-29.10-22.73-25.63-28.32-35.69-40.56-46.10-52.39-59.54
Depreciation 0.852.883.464.744.854.415.025.706.487.36
Accounts Receivable --1.62-0.67-0.54-4.03-3.04-3.44-3.91-4.45-5.05
Inventories --1.881.33-4.16-2.21-1.62-2.80-3.18-3.62-4.11
Accounts Payable -3.75-3.671.333.04-0.041.221.381.571.79
Capital Expenditure -6.60-5.23-22.60-28.40-21.25-22.21-25.25-28.69-32.61-37.06
UFCF -26.94-31.20-44.88-52.67-47.92-58.19-65.82-74.80-85.01-96.61
WACC
PV UFCF -54.99-58.77-63.11-67.77-72.78
SUM PV UFCF -317.41

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 5.83
Free cash flow (t + 1) -98.55
Terminal Value -2,573.04
Present Value of Terminal Value -1,938.21

Intrinsic Value

Enterprise Value -2,255.63
Net Debt 52.14
Equity Value -2,307.77
Shares Outstanding 42.08
Equity Value Per Share -54.84