Discounted Cash Flow (DCF) Analysis Unlevered

Alpine Immune Sciences, Inc. (ALPN)

$7.45

-0.67 (-8.25%)
All numbers are in Millions, Currency in USD
Stock DCF: -31,875.08 | 7.45 | 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 0.701.749.3423.4430.0687.39254.01738.322,146.066,237.92
Revenue (%)
EBITDA -36.15-41.05-26.59-51.06-55.06-1,428.23-4,151.42-12,066.88-35,074.68-101,951.20
EBITDA (%)
EBIT -36.53-41.51-27.17-57.95-63.89-1,453.90-4,226.03-12,283.76-35,705.07-103,783.57
EBIT (%)
Depreciation 0.390.470.586.898.8325.6774.61216.88630.401,832.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 52.3040.52105.58120.77237.642,129.486,189.7517,991.6852,296.22152,008.89
Total Cash (%)
Account Receivables 0.240.690.39250.3932.3694.06273.39794.662,309.83
Account Receivables (%)
Inventories ----------
Inventories (%)
Accounts Payable 1.721.540.583.354.2964.12186.37541.721,574.604,576.88
Accounts Payable (%)
Capital Expenditure -0.50-0.82-0.80-9.85-12.63-36.70-106.67-310.06-901.26-2,619.68
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 7.45
Beta 1.289
Diluted Shares Outstanding 33.44
Cost of Debt
Tax Rate -4.20
After-tax Cost of Debt 3.35%
Risk-Free Rate
Market Risk Premium
Cost of Equity 9.464
Total Debt 14.22
Total Equity 249.09
Total Capital 263.31
Debt Weighting 5.40
Equity Weighting 94.60
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 0.701.749.3423.4430.0687.39254.01738.322,146.066,237.92
EBITDA -36.15-41.05-26.59-51.06-55.06-1,428.23-4,151.42-12,066.88-35,074.68-101,951.20
EBIT -36.53-41.51-27.17-57.95-63.89-1,453.90-4,226.03-12,283.76-35,705.07-103,783.57
Tax Rate 0.99%0.00%0.02%-0.17%-4.20%-0.67%-0.67%-0.67%-0.67%-0.67%
EBIAT -36.17-41.51-27.17-58.05-66.58-1,463.67-4,254.44-12,366.35-35,945.15-104,481.39
Depreciation 0.390.470.586.898.8325.6774.61216.88630.401,832.36
Accounts Receivable --0.450.30-24.6124.61-31.97-61.70-179.33-521.27-1,515.17
Inventories ----------
Accounts Payable --0.17-0.962.770.9459.83122.25355.351,032.893,002.28
Capital Expenditure -0.49-0.82-0.80-9.85-0.41-36.70-106.67-310.06-901.26-2,619.68
UFCF -36.28-42.49-28.05-82.85-44.83-1,446.84-4,225.95-12,283.52-35,704.39-103,781.60
WACC
PV UFCF -1,325.79-3,548.43-9,451.28-25,173.58-67,050.12
SUM PV UFCF -106,549.20

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 9.13
Free cash flow (t + 1) -105,857.23
Terminal Value -1,484,673.61
Present Value of Terminal Value -959,202.30

Intrinsic Value

Enterprise Value -1,065,751.51
Net Debt 0.84
Equity Value -1,065,752.35
Shares Outstanding 33.44
Equity Value Per Share -31,875.08