Context#
A valuation model for a services back-book lived in a static spreadsheet: fifteen years of assumptions about volume, conversion, margin maturity and discounting, each buried in cells nobody could question mid-conversation. I rebuilt it as an interactive tool so the people in the room could change an assumption and see what it did to the valuation.
The published version uses invented figures and a generic business. The mechanics are the same as the version that shipped.
What it does#
- Bull / Base / Bear scenario toggle, so the reader can move between growth assumptions instead of accepting one management case at face value.
- Discount rate as the headline lever, the first slider on the page, because it's the assumption people in the room argue about. In the source model it was a cell three tabs deep.
- Secondary sliders underneath the valuation: margin trajectory, attrition, conversion and the take-rate assumption, each editable in real time.
Every change recalculates the full model live, so someone can test a claim like "if margin only gets to X, the valuation drops by Y" for themselves in the meeting.
It's a React dashboard with the scenario-driven financial model recalculating client-side, deployed as a route on this site.