Skip to content
value.today

Valuation builder

A discounted-cash-flow model of any company with filings on file, filled in from what it reported. Every assumption is yours; save your models, share them with your team or by a read-only link.

A tool for your own analysis, not investment advice. It does arithmetic on the figures the company filed and on assumptions you choose; it does not forecast, and the result is only as good as those assumptions. Every formula is on the methodology page.

Open a company's model

Banks and insurers are not offered: free cash flow means little for them. Their valuation pages compare them with their peers' multiples instead.

How the model works

  1. Start from the filings. Revenue, margins, tax rate, depreciation, capital spending and working capital from the company's last annual reports as filed; debt, cash and shares from its newest balance sheet. Each figure names its filing and period.
  2. Set the path. Revenue growth and operating margin for each of five, seven or ten years, in a bear, a base and a bull case.
  3. Discount it. Free cash flow to the firm each year, discounted at the WACC (the risk-free rate, beta and an equity risk premium for shareholders; the cost of debt after tax for lenders) or at a rate you set.
  4. Add what comes after. The value after the last year from long-run growth or an exit multiple of EBITDA.
  5. Reach a value per share. Less debt and minority interests, plus cash, divided by the diluted shares, beside the market price and its date, with sensitivity tables.

Every formula, with a worked example: methodology.