Compound Sales Growth (CAGR) Calculator
Calculate compound annual growth rate (CAGR) for sales and revenue. Compare periods, model future trajectories, and benchmark against industry targets.
Backlog Conversion Calculator
Predict revenue from your sales backlog using historical conversion rates. Model pipeline-to-revenue timing, backlog aging, and expected revenue by period.
$
Historical % that converts to revenue
%
mo
Cancellation/aging loss rate
%
For coverage ratio calculation
$
Expected Revenue⧉
$4,400,000.00
88.00% of $5,000,000.00
Expected Leakage⧉
$600,000.00
12.00% cancellation/loss
Monthly Conversion⧉
$733,333.33
Over 6.00 months
Coverage Ratio⧉
0.73×
Gap: $1,600,000.00
Backlog Coverage of Revenue Target73.00%
Expected: $4,400,000.00Target: $6,000,000.00
Backlog Conversion Schedule
| Month | Converted | Decayed | Remaining | Backlog |
|---|---|---|---|---|
| M1 | $814,814.81 | $18,518.52 | $4,166,666.67 | |
| M2 | $679,012.34 | $15,432.10 | $3,472,222.23 | |
| M3 | $565,843.62 | $12,860.08 | $2,893,518.53 | |
| M4 | $471,536.35 | $10,716.74 | $2,411,265.44 | |
| M5 | $392,946.96 | $8,930.61 | $2,009,387.87 | |
| M6 | $327,455.80 | $7,442.18 | $1,674,489.89 | |
| M7 | $272,879.84 | $6,201.81 | $1,395,408.24 | |
| M8 | $227,399.86 | $5,168.18 | $1,162,840.20 | |
| M9 | $189,499.88 | $4,306.82 | $969,033.50 |
Conversion Rate Scenarios ($5,000,000.00 backlog)
| Conv. Rate | Expected Rev. | Leakage | Coverage | Scale |
|---|---|---|---|---|
| 60% | $3,000,000.00 | $2,000,000.00 | 0.5× | |
| 70% | $3,500,000.00 | $1,500,000.00 | 0.58× | |
| 75% | $3,750,000.00 | $1,250,000.00 | 0.63× | |
| 80% | $4,000,000.00 | $1,000,000.00 | 0.67× | |
| 85% | $4,250,000.00 | $750,000.00 | 0.71× | |
| 88% ← | $4,400,000.00 | $600,000.00 | 0.73× | |
| 90% | $4,500,000.00 | $500,000.00 | 0.75× | |
| 92% | $4,600,000.00 | $400,000.00 | 0.77× | |
| 95% | $4,750,000.00 | $250,000.00 | 0.79× | |
| 98% | $4,900,000.00 | $100,000.00 | 0.82× |
Planning notes, formulas, and examples
About the Backlog Conversion Calculator
The Backlog Conversion Calculator estimates future revenue from your current sales backlog by applying historical conversion rates and delivery timelines. Sales backlog — contracts signed but not yet delivered or recognized — represents the most predictable component of future revenue. Unlike pipeline (opportunities in progress), backlog is committed and contracted, making its conversion highly reliable.
This calculator takes your total backlog value, historical conversion rate, and average delivery timeline to project expected revenue by period. It accounts for the reality that not all backlog converts (cancellations, scope changes, delivery failures) and that conversion happens over time, not instantaneously. The result is a realistic, time-phased revenue projection from your existing committed contracts.
Whether you manage a software implementation backlog, manufacturing order book, professional services queue, or subscription renewal pipeline, this calculator provides the conversion math needed for accurate revenue forecasting and capacity planning.
Use the result to compare scenarios, test assumptions, and revisit the model when pricing, volume, or financing inputs change.
When This Page Helps
Backlog is the foundation of revenue forecasting, yet many organizations simply assume 100% conversion, which consistently leads to over-forecasting. Even contracted backlog has leakage from cancellations, delays, and scope reductions. This calculator applies realistic conversion rates and timing to produce forecasts that match actual outcomes, improving planning accuracy for finance, operations, and leadership.
How to Use the Inputs
- Enter your current total backlog value (committed but undelivered contracts).
- Input your historical conversion rate (percentage of backlog that typically converts to revenue).
- Specify the average delivery timeline in months.
- Optionally enter the expected monthly decay rate for backlog aging.
- Review the expected revenue and conversion timeline.
- Check the period-by-period projection for budget and capacity planning.
- Use the conversion rate scenarios to model optimistic and pessimistic cases.
Formula used
Expected Revenue = Backlog Value × Historical Conversion Rate
Monthly Conversion = Expected Revenue / Delivery Timeline (months)
Backlog Aging Factor = (1 − Monthly Decay Rate) ^ Months
Adjusted Backlog = Original Backlog × Aging Factor
Conversion Velocity = Revenue Recognized / Average Backlog × 100Example Calculation
Result: $4,400,000 expected revenue over 6 months
With a $5M backlog and 88% historical conversion rate, expected revenue is $5M × 88% = $4.4M. Spread over a 6-month delivery timeline, that's approximately $733K/month in expected revenue from existing backlog. The remaining 12% ($600K) represents expected leakage from cancellations, delays, and scope changes.
Tips & Best Practices
- Track conversion rate by backlog age — older backlog typically converts at lower rates.
- Segment backlog by deal size and type for more accurate conversion rates.
- Update conversion rate assumptions quarterly based on trailing 12-month actuals.
- Separate backlog from pipeline: backlog is contracted, pipeline is still in negotiation.
- Build a cancellation reserve equal to your historical leakage rate for conservative planning.
- Monitor backlog-to-revenue velocity — if conversion is slowing, investigate delivery bottlenecks.
- Include backlog aging in financial forecasts, especially for contracts older than 6 months.
- Cross-reference backlog projections with delivery capacity to identify resource constraints.
Backlog as a Revenue Forecasting Foundation
The most accurate revenue forecasts start with backlog. Since these are contracted commitments, the conversion is highly predictable when adjusted for historical leakage. Layer pipeline conversion on top of backlog to build a complete forecast. Sophisticated forecasting models use age-weighted conversion rates and segment-specific assumptions for maximum accuracy.
Backlog Health Metrics
Beyond conversion rate, monitor backlog health with these metrics: average backlog age (older is riskier), backlog concentration (dependency on few large deals), backlog growth rate (positive trend indicates strong demand), and backlog-to-revenue velocity (how quickly backlog converts). Together, these metrics provide a comprehensive view of your future revenue quality.
Industry-Specific Backlog Considerations
In software, backlog often includes implementation projects where revenue recognition depends on delivery milestones. In manufacturing, backlog represents orders in production with material and labor costs already committed. In professional services, backlog is uncommenced or in-progress engagements. Each industry has unique factors affecting conversion rates and timing.
Sources & Methodology
Last updated:
Frequently Asked Questions
Backlog consists of signed, contracted deals awaiting delivery or fulfillment. Pipeline includes opportunities still in the sales process that haven't been won yet. Backlog has much higher conversion certainty (typically 80-95%) compared to pipeline (typically 15-35%). For forecasting, backlog is the most reliable revenue predictor.
A healthy backlog conversion rate depends on industry. Software/SaaS typically converts at 90-98%, professional services at 85-95%, manufacturing at 80-92%, and construction at 75-90%. If your rate is below 80%, investigate root causes like cancellation terms, scope creep, delivery delays, or qualification issues.
Older backlog generally converts at lower rates. A contract signed 1 month ago might convert at 95%, while one signed 9+ months ago might only convert at 70%. This is because delivery delays, customer situations, and market conditions change over time. Apply age-adjusted conversion rates for more accurate forecasting.
It depends on your definition. Auto-renewing contracts with high retention can be included as expected backlog, but with a conversion rate reflecting your renewal rate (not 100%). Renewals requiring active re-signing should be treated as pipeline until contracted. Be consistent in your classification and transparent about assumptions.
Focus on three areas: better qualification (don't book deals likely to cancel), faster delivery (reduce the window for cancellation), and proactive account management (engage customers between signing and delivery). Also review cancellation terms — deals with easy exit clauses convert at lower rates than those with committed terms.
Backlog coverage ratio is your backlog value divided by your revenue target for a period. A ratio of 1.0 or higher means your backlog alone covers your revenue target (assuming full conversion). Adjusting for conversion rate, a backlog of $1.1M with 90% conversion covers a $1M target. Track this ratio to assess forecast confidence.
Update backlog forecasts at least monthly, ideally weekly for fast-moving businesses. Each update should reflect new bookings added, deliveries completed (backlog consumed), cancellations removed, and revised delivery timelines. The refresh cadence should match your reporting and planning cycles.
Yes. Growing backlog with shrinking revenue indicates a delivery bottleneck — you're booking faster than you can deliver. While this suggests strong demand, it's operationally concerning because prolonged delivery delays increase cancellation risk and customer dissatisfaction. Address delivery capacity to convert backlog to revenue faster.
More in this topic
Linear Sales Forecast Calculator
Forecast future sales using linear regression (least squares). Enter historical data points and get trend-based projections with confidence insights.
Moving Average Sales Forecast Calculator
Forecast sales using simple, weighted, and exponential moving averages. Enter historical data to get smoothed trend projections and compare methods.