Please note that inconsistencies may arise during the recovery process. We kindly ask you to verify the integrity of the model.
To save the restored assumptions, consider adding the valuation to your watchlist or shared valuations.
Discounted Cash Flow to Firm (Perpetual Growth)
This model estimates the fair value of a share by discounting projected Free Cash Flow to the Firm (FCFF), also known as Unlevered Free Cash Flow.
The terminal value assumes cashflow grows at a constant Growth in Perpetuity rate forever:
Terminal Enterprise Value = FCFF_(final forecast year) × (1 + Growth in Perpetuity) / (Discount Rate - Growth in Perpetuity)
The terminal value and projected FCFF are discounted to present value using WACC. Equity value is obtained by adjusting enterprise value for net debt:
Equity Value =
Cumulative Present Value of FCFF +
Present Value of Terminal EV +
Cash and Short Term Investments −
Total Debt
Fair Value per Share = Equity Value ÷ Shares Outstanding
This model was inspired by Prof. Aswath Damodaran's spreadsheet ⬇️fcff2st.xls
Learn more: Prof. Aswath Damodaran's Guide to Discounted Cash Flow Valuation
Discount Rate (WACC)
WACC Calculation |
|
|---|---|
| Beta | 0.91 |
| * Equity Risk Premium | 4.46% |
| + Risk Free Rate | 4.15% |
| = Cost of Equity | 8.21% |
| * Equity Weight | 100% |
| + Cost of Debt | |
| * Debt Weight | 0% |
| * (1 - Tax Rate) | 75% |
| = WACC (Discount Rate) | |
Historical Averages
|
Monetary values in USD amounts except # |
Average |
LTM
Mar 07 |
2025
Dec 31 |
2024
Dec 31 |
2023
Dec 31 |
|---|---|---|---|---|---|
| Revenue |
|
0 | 0 | 0 | 0 |
| Revenue Growth Rate |
|
|
|
|
|
| Earnings Before Interest and Taxes (EBIT) | -9.16 | -9.22 | -9.22 | -7.39 | -10.82 |
| EBIT Margin |
|
|
|
|
|
| Income Tax Expense |
|
0 | 0 | 0 | 0 |
| Income Tax Rate | 25% | 25% | 25% | 25% | 25% |
| Depreciation and Amortization (D&A) | 0.048 | 0.004 | 0.003 | 0.002 | 0.184 |
| D&A Margin |
|
|
|
|
|
| Capital Expenditure (CapEx) | -0.007 | -0.012 | -0.012 | -0.001 | -0.005 |
| CapEx Margin |
|
|
|
|
|
| Change in Working Capital | -0.051 | 0.235 | 0.235 | -0.138 | -0.536 |
| Change in WC Margin |
|
|
|
|
|
| Free Cashflow to Firm (FCFF) | -6.88 | -6.69 | -6.69 | -5.68 | -8.47 |
| FCFF Margin |
|
|
|
|
|
Forecast Assumptions
Forecasting
Monetary values in USD
Fair Value Calculation |
|
|---|---|
| Exit Free Cashflow to Firm (FCFF) | |
| Terminal Enterprise Value (EV) | |
| Terminal Value Discount Factor | |
| Present Value of Terminal EV | |
| + Cumulative Present Value of FCFF | 0 USD |
| + Cash and Short Term Investments | 21.03 Mil. USD |
| - Total Debt | 0 USD |
| = Equity Value | |
| / Shares Outstanding | 11.62 Mil. |
| = Fair Value per Share | |
Deprecated Link
AI Insights
AI Insights help you understand your data more easily. With just a click, the assistant looks at the current page, generates a report with key metrics, and highlights any interesting trends, patterns, or outliers. You can also ask the assistant follow-up questions.
Delete Model
Are you sure you want to delete your model? All associated code will be permanently lost.