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
Or start with one of the largest companies:
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
- 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.
- 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.
- 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.
- Add what comes after. The value after the last year from long-run growth or an exit multiple of EBITDA.
- 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.