DCF CalculatorChange the judgment calls. Reported figures and market prices are locked.

Import a DCF spreadsheet

Your assumptions

Edited fields are outlined, with the base value shown. Percentages are typed as numbers: 25 means 25%.

These assumptions cannot be valued. The discount rate must be higher than terminal growth, and the return on capital and the sales-to-capital ratio must be above zero.

Value per share

Price

Base case

Long-run margin the price needs

From cash flows to a share price

Locked facts

Ten-year forecast

Sensitivity: value per share

Rows move the discount rate, columns move the long-run margin. Centre is your current case; the dashed cell is nearest the price.

Built on the DCF template: mid-year discounting, a part-year for 2026, and a terminal value in which reinvestment is growth ÷ return on capital. The four bundled models match their spreadsheets in examples/ to the cent. Imported spreadsheets must use the same template. Importing a newer version of a bundled model replaces it. Companies you import or add, and your edits, are kept in this browser only.