The Missed-Revenue Worksheet: What Slow Replies Cost You
By the Flon team · Published July 11, 2026 · Last updated July 11, 2026
Slow lead response doesn't show up on a P&L as a line item — it shows up as lower conversion, quietly, every month, with no obvious cause. This worksheet turns that invisible leak into one dollar figure by walking your own numbers through a simple formula: how many leads wait too long, how much their close rate drops when they do, and what each closed deal is worth.
The direction of the effect is well documented — contacting a lead within 5 minutes instead of 30+ minutes can change qualification odds by roughly 21×, and 35–50% of sales go to whichever business responds first, not whichever has the better offer. The exact size of the drop varies by business, which is why this worksheet asks you to use your own numbers rather than a generic industry average.
How to use it: Fill in rows A, B, D, E, and G with your real numbers, pulled from your CRM or phone/form logs where possible. Rows C, F, and H calculate themselves from what you entered. If you genuinely don't know row E (your close rate on slow-answered leads), use the conservative placeholder in the note below it — then replace it with real data as soon as you have it.
$0 / month missed
Speed to lead probably isn't your biggest leak — worth a periodic check, not urgent action.
The worksheet
Worked example (illustrative — hypothetical numbers, conservative assumptions, not a real client)
| Step | Input | Example number |
|---|---|---|
| A | Leads per month | 120 |
| B | % waiting over 5 minutes | 55% |
| C | Slow-response leads (120 × 0.55) | 66 |
| D | Close rate, fast-answered leads | 30% |
| E | Close rate, slow-answered leads (conservative: half of D) | 15% |
| F | Gap (30% − 15%) | 15 points (0.15) |
| G | Average deal value | $1,800 |
| H | Missed revenue (66 × 0.15 × $1,800) | $17,820 / month |
Even with a deliberately conservative gap assumption (half, not the larger multiple the research suggests), this hypothetical business is leaving roughly $17.8k on the table every month — about $214k a year — purely from response speed, before touching lead quality, pricing, or sales skill. Run your own numbers through row H before drawing conclusions about your business; the point of the conservative placeholder is to give you a credible floor, not a scare number.
How to interpret your result
| Monthly missed revenue (row H) | What it suggests |
|---|---|
| Under $1,000 | Speed to lead probably isn't your biggest leak — worth a periodic check, not urgent action. |
| $1,000–$5,000 | A real, fixable gap. Worth comparing against the cost of closing it (see below). |
| $5,000–$20,000 | Meaningful revenue is walking away monthly. This usually justifies action within the quarter. |
| $20,000+ | Speed to lead is very likely one of the largest fixable leaks in the business right now. |
Compare row H against what closing the gap costs. A system built specifically to answer every inbound lead in under 60 seconds, qualify it, and follow up until resolved is scoped after a Blueprint ($1,900, credited to the build), then operated monthly. In most worked examples, a single month of missed revenue covers a meaningful share of what it costs to run.
FAQ
What if I don't know my close rate by response speed at all? Start by tagging 20–30 recent leads in your CRM with rough response time and outcome (won/lost). That's usually enough to estimate rows D and E credibly. Until then, use the conservative placeholder and treat row H as a floor, not a ceiling.
Does this worksheet account for lead quality differences? No — it isolates response speed on purpose. If your slow-answered leads also tend to be lower quality (e.g., they came in after-hours from a different channel), your real gap could be larger or smaller than row F suggests; adjust row E with that context in mind.
Is a 5-minute threshold the right bar to use? It's the most-cited threshold in the research and a reasonable default. If your sales cycle is naturally slower (e.g., complex B2B), you can substitute your own "fast" threshold in row B and D — the formula still works, just recalibrate what "fast" means for your business.
See your real number, not an estimate
This worksheet uses numbers you provide. The Lead Response Grader measures your actual response time by sending your own form a real test inquiry — free, no estimate required. Related reading: the lead response audit checklist to find where the slow responses are coming from, and speed to lead in the glossary for the research behind this worksheet.