Resource · Last updated July 14, 2026 · By the ColdDMCalculator team
Cold DM Revenue Forecast Worksheet: Project Your Pipeline
A revenue forecast turns campaign assumptions into projected income. This worksheet builds three scenarios — conservative, base, and optimistic — so you know exactly what to expect and when the campaign is worth running.
Forecasting framework
Define your scenarios
Create three scenarios: conservative (rates 20–30% below your averages), base (your expected rates), and optimistic (rates 20–30% above your averages). The conservative scenario is your safety check — if it's not profitable, the campaign is risky.
Project volume by time period
For each scenario, project the number of DMs you'll send over 30, 60, and 90 days. Multiply by reply rate, positive reply rate, booking rate, and close rate at each stage to get projected clients and revenue.
Calculate pipeline value
Pipeline value is the total projected revenue across all scenarios. Use this to set expectations and plan resource allocation. The base scenario is your planning number; the conservative scenario is your risk-adjusted number.
Compare scenarios to assess risk
If the conservative scenario loses money, the campaign depends on above-average performance. That's a red flag. Aim for the conservative scenario to at least break even — then the base and optimistic scenarios become upside.
Scenario inputs
Set rates for each scenario. Conservative uses rates 20–30% below your averages. Base uses expected rates. Optimistic uses rates 20–30% above.
| Metric | Conservative | Base | Optimistic |
|---|---|---|---|
| Reply rate | 5% | 8% | 12% |
| Positive reply rate | 30% | 45% | 55% |
| Booking rate | 40% | 55% | 65% |
| Close rate | 20% | 30% | 40% |
| Average client value | $2,000 | $3,000 | $4,000 |
30-day forecast example
Projected results for a 600-DM campaign across three scenarios.
| Metric | Conservative | Base | Optimistic |
|---|---|---|---|
| DMs sent | 600 | 600 | 600 |
| Projected replies | 30 | 48 | 72 |
| Projected interested | 9 | 22 | 40 |
| Projected meetings | 4 | 12 | 26 |
| Projected clients | 1 | 4 | 10 |
| Projected revenue | $2,000 | $12,000 | $40,000 |
The conservative scenario projects $2,000 in revenue — likely below campaign cost. The base scenario projects $12,000, which is the planning number. The optimistic scenario shows $40,000 if rates outperform.
How to Use This Resource
- Fill in the scenario inputs with your actual rates (or conservative estimates if you're new).
- Run the Cold DM Calculator to generate all three scenarios automatically.
- After the first 100 sends, replace assumed rates with actuals and re-forecast.
- Compare conservative scenario revenue against campaign cost to decide whether to proceed.
This resource is for educational planning purposes. Results vary based on execution, audience, and platform rules.
Related: All Resources · Calculator · Outreach ROI Template · Goal-Setting Worksheet
Frequently asked questions
Which scenario should I plan around?
Plan your budget and resource allocation around the conservative scenario. Plan your expectations around the base scenario. Use the optimistic scenario to understand upside potential, not as a planning number.
How do I update the forecast with actual data?
After the first 100 sends, replace your assumed reply rate with the actual rate. Recalculate downstream. Repeat every 100 sends. The forecast gets more accurate as actual data replaces assumptions.
Should I forecast by month or by campaign?
What if my conservative scenario loses money?
Either reduce campaign cost, increase average client value, or improve your targeting to raise reply rates. Don't launch a campaign that only works if everything goes well.
Build your revenue forecast.
Run the calculator to project conservative, base, and optimistic scenarios.
Forecasts are estimates based on user-provided assumptions. Results are not guaranteed.