ARBIMETRA · Financial intelligence, made practical.

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.

CheckReferenceResultAbs. errorToleranceSource
Enterprise value by hand100010002.3e-131e-11Hand calculation
Value per share95952.8e-141e-11Hand calculation
Mid-year timing1048.808848171048.808848170.0e+01e-11Hand 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.