Moving from Static Sensitivity to Stochastic Modeling for SMB Diligence

professional-advisory profile

January 07, 2026

by a professional-advisory from Clarkson University in Rocklin, CA, USA

I’m heading to two conferences this spring to dig into the same problem: how we can move from "gut-feel" metrics to actual system rigor in the SMB space. Most deal models I see are dangerously static. We hard-code a 10% churn rate or a 50 bps interest rate shift, run a sensitivity table, and call it a "Downside Case." But real systems aren't static; they are probabilistic. If churn, growth, and interest rates all move simultaneously, what is the actual probability of ruin? I’m currently moving my own deal analysis into Python to stop looking at single-point IRR estimates and start looking at p-values. I’ll be at these two events this spring to dig deeper into this: - MIT SSAC (Boston, March 6-7): I’m returning for the 20th anniversary to see if the influx of private capital has finally turned sports into a consistently profitable asset class through better technology and yield management. - SMBash (Dallas, April 22-24): This is my first time attending. I’m looking to connect with operators who are moving beyond the "viral thread" version of ETA and actually dealing with the math of Main Street. I am particularly interested in how these models perform in the tax, accounting, and B2B services sectors - industries with high seasonal variance where a single-year EBITDA multiple tells almost none of the story. If you are an operator or a searcher in Boston or Dallas and want to trade notes on building more rigorous diligence models or data partnerships, let’s find a time to connect.
0
7
79
Replies
7
commentor profile
Reply by a searcher
from University of Central Florida in Atlanta, GA, USA
This may be a controversial take, but it sounds like you’re expecting way too much from your model. Almost every operator in a small/medium business does not experience any type of growth, downside or j curve similar to what they modeled in their scenario analysis If you can account for the key risks and what actions you can take to rightsize the company if one or all go wrong, you at least have a plan. Typically the big risks in these size are related to lack of understanding of the operating model and what drives the business (could include sales cyle, working capital, unit economics, etc), customer concentration (and an outsized impact of that customer on ebitda), and human capital (owner had more involvement than you thought, or key sales / ops person leaves and take clients or staff) If you truly understand all of these and can account for how it impacts the business and returns when things go wrong, you’ve modeled a fairly credible downside case
commentor profile
Reply by a searcher
from Dartmouth College in Garden Grove, CA, USA
Yeah, I have run stochastic or probability based, distribution events in the past. To be honest, Excel often doesn't cut it without add-ons (depending on the exact situation and simulations needed) but there are ways to work around.
commentor profile
+5 more replies.
Join the discussion