Resource · Worksheet
Cold DM ROI Forecast Worksheet
Forecasting ROI before you spend keeps expectations honest. This worksheet walks from input assumptions through cost and revenue to a simple profit and break-even point, using your own numbers rather than borrowed benchmarks. The forecast is not a promise; it is a scenario that helps you decide whether the program is worth attempting at the scale you have in mind, and where the leverage lies if it underperforms. A forecast you build yourself is also one you can defend, which matters when other people's money is involved.
How to use this worksheet
Fill the assumption block first, then the cost block, then the revenue block. The final lines compute profit and the break-even send count. Re-run it whenever a key assumption changes, because a forecast built on stale numbers is just a decorated guess that feels authoritative.
Share the forecast with anyone whose money is involved. A written forecast prevents the argument later about what was expected, and it forces you to defend your rates instead of hand-waving them. The act of writing the numbers is itself a check on wishful thinking.
Every number here is an assumption until measured; label forecasts as estimates.
Assumption block
These five inputs drive everything downstream. Spend real thought on each; a careless rate here compounds into a wildly wrong profit line, which is worse than no forecast because it feels authoritative while being fiction.
| Assumption | Your value | Basis |
|---|---|---|
| Sends per month | ___ | Capacity plan |
| Reply rate | ___% | Estimate |
| Meeting rate | ___% | Estimate |
| Close rate | ___% | Estimate |
| Avg client value | $___ | Pricing |
Cost block
Include everything that scales with outreach so the profit line is meaningful. A forecast that ignores labor or tooling will show profit that evaporates the moment you pay the people who did the work, which is the most common way a 'profitable' campaign turns out not to be.
- Tool and software subscriptions used for outreach.
- Labor hours at a realistic rate, not a rounded zero.
- Any ad or profile costs tied to the campaign.
- Overhead allocated per campaign fairly.
Revenue and profit lines
Multiply sends down the funnel, then subtract cost to see profit and break-even. The break-even line is the most useful output: it tells you the minimum volume before the program pays for itself, which is the real go or no-go threshold.
Compute clients
Sends times each rate to reach a client count.
Compute revenue
Clients times average value for gross revenue.
Compute profit
Revenue minus total cost for net profit.
Find break-even
Sends where revenue equals cost, your go or no-go threshold.
Using the forecast
The value is in the sensitivity, not the single number. Change one rate and watch profit move; the rate that moves profit most is where your improvement effort belongs, because that is the lever with the highest payoff.
- 1Raise reply rate 1 percent, note profit change.
- 2Raise close rate 1 percent, note profit change.
- 3Lower cost 10 percent, note profit change.
- 4Identify the highest-leverage lever to attack first.
Reading break-even honestly
Break-even tells you the volume where you stop losing money, not where you start winning comfortably. Add a margin above break-even before committing, because real campaigns incur costs the simple model omits, such as refunds, churn, and the time to manage edge cases.
Break-even is a floor, not a target; plan to clear it with room to spare.
Suggested image brief
| Placement | Purpose | Filename and alt text |
|---|---|---|
| After the direct answer | Create an original AI-generated workflow graphic that summarizes the decision, metric, and next action for this topic without third-party logos. | cold-dm-roi-forecast-worksheet-workflow.webp - Cold DM ROI Forecast Worksheet workflow diagram |
Quick checklist
- All five assumptions entered with a basis.
- Cost block includes labor and tools.
- Client and revenue computed clearly.
- Profit line calculated and labeled.
- Break-even send count found.
- Sensitivity test performed on one rate.
Related: ROI Calculator · Cost Calculator · Revenue Forecast Worksheet · ROI Template · All Resources
Frequently asked questions
Which assumption matters most?
Usually close rate and average value, because they sit at the bottom of the funnel and multiply everything above them.
How do I get realistic rates?
Start from conservative guesses, then replace them with your own measured rates after the first few hundred sends.
What is break-even for?
It tells you the minimum volume needed before the program pays for itself, useful for go or no-go decisions.
Should I include my salary?
If outreach is your work, yes; otherwise use the labor cost of whoever executes it so profit is honest.
Does a positive forecast guarantee profit?
No. Forecasts are scenarios; actual rates and costs will differ, sometimes materially from the plan.
Forecast your next cold DM campaign.
Run the free calculator — no signup required.
Forecasts are estimates based on user-provided assumptions. Results are not guaranteed.
Benchmarks, templates, and examples on this page are illustrative planning references, not guarantees of performance. Adjust your outreach to comply with platform terms and applicable regulations.