70% of PE-backed CEOs don't make it to exit. Here's how not to be one →
70% of PE-backed CEOs don't make it to exit. Here's how not to be one →
The tool
Paste twelve months of revenue by customer. This builds the curve from your own book — not from an assumed distribution — and tells you how few customers carry all of your profit, and what the rest of them give back.
Your own data · Nothing leaves your browser · About five minutes
Read this first.
Your customer list never leaves your computer. There is no upload, no server, and no account — the arithmetic runs in this page, and closing the tab erases it. You can disconnect from the internet and it will still work.
Step 1
One row per customer, twelve months. A CSV or a paste straight out of Excel both work. Keep the customer name if you want it in the output; strip it if you would rather not have names on screen. Do not clean it up or group anything — the messiness is the point.
You can also drag a file onto this box.
Optional. Used only for the table at the bottom.
Step 2
Revenue by customer on its own cannot tell you profit by customer. These three turn it into one, and the total reconciles against what you actually earn — so you will know if the inputs are wrong.
Percent. Revenue minus cost of goods, across the whole business.
Percent of revenue. Everything below gross profit.
Order handling, service, admin, freight minimums — cost that arrives with an account regardless of its size.
That last slider is the only judgement in the model, and it is worth understanding. At zero, cost to serve is assumed purely proportional to size and there is no curve at all — every customer looks equally profitable. The curve is the fixed cost. Most middle-market industrial books sit between 25% and 50%; if you have measured your real cost per order, use it.
Map your profit
