ARBIMETRA LAB
DCF Valuation
Values a business from projected free cash flows, with a terminal value, per-share value and sensitivity table.
What it does
Values a business from projected free cash flows, with a terminal value, per-share value and sensitivity table.
Use it to translate forecasts into value.
Data you need
- Free cash flows
- Discount rate
- Terminal assumption
Supported data: Assumptions. Level: Intermediate.
Formula and method
EV = Σ FCFₜ/(1+r)ᵗ + TV/(1+r)ᴺ · TV = FCF(1+g)/(r−g)
Each forecast cash flow is discounted at the chosen rate with end-of-year or mid-year timing. A terminal value from perpetual growth or an exit multiple is discounted too, then net debt is deducted to reach equity value.
Assumptions
- Cash flows are unlevered
- The discount rate matches their risk
Input checks
- Growth must be below the discount rate
How to read the result
Check how much of the value comes from the terminal value.
Worked example
Illustrative run on the default assumptions in the form. These figures are the actual output of this model on that example, and they say nothing about your own data.
- Enterprise value = 1,556.04, equity value = 1,556.04, value per share = 1,556.04.
- The result is a consequence of your inputs, not a market price.
Limitations
- Educational use, not investment advice
- Small input changes can move the result a lot
Numerical validation
Validated 12 of 12 automated checks passed, including numerical results, invalid input, missing values, small samples, constant variables, charts and the interpretation text.
| Check | Reference | Result | Abs. error | Tolerance | Source |
|---|---|---|---|---|---|
| Enterprise value by hand | 1000 | 1000 | 2.3e-13 | 1e-11 | Hand calculation |
| Value per share | 95 | 95 | 2.8e-14 | 1e-11 | Hand calculation |
| Mid-year timing | 1048.80884817 | 1048.80884817 | 0.0e+0 | 1e-11 | Hand calculation |
Computed with python 3.13.2, numpy 2.2.5, scipy 1.14.1, pandas 2.3.3, statsmodels 0.14.4, scikit-learn 1.7.0, in your browser. A passing check confirms the listed comparison only. It does not make any result suitable for your data, and it is not a claim of equivalence with other statistical software.
Questions
What is a reasonable terminal growth rate?
It should not exceed long-run growth of the economy and must be below the discount rate.
ARBIMETRA LAB is an educational and research tool. Results should be checked by the researcher and are not professional advice.
