Finance
What is the business really worth — and how fragile is that number?
A DCF is hostage to three guessed inputs. Change growth, margin, or WACC a little and the value swings a lot. This template runs all three as ranges and returns a valuation distribution, not one brittle number.
Get this in Google Sheets →The model
A 5-year unlevered free-cash-flow projection with a Gordon-growth terminal value. Revenue growth, EBIT margin, and WACC are the uncertain inputs.
| Revenue (Year 1) | $1,000,000 |
| Revenue growth | 5% – 15% – 30% (uncertain) |
| EBIT margin | 10% – 20% – 28% (uncertain) |
| WACC | 8% – 10% – 14% (uncertain) |
| Terminal growth | 3% |
| Enterprise value | → simulated |
What Sortia tells you
Enterprise value across thousands of scenarios:
P5$1.7M
Median$2.9M
P95$4.7M
Mean$3.0M
P5 · $1.7Mmedian · $2.9MP95 · $4.7M
The valuation spans $1.7M to $4.7M — nearly 3× — from reasonable ranges on just three inputs. The tornado chart ranks which assumption moves the value most, so you know where to tighten your estimate instead of arguing about the headline number.
Try it in your own sheet
- Open Sortia in Google Sheets and choose Start from a template.
- Pick DCF Valuation with Monte Carlo — the model loads with the inputs filled in.
- Change the assumptions to fit your situation and press Run.