Formula
Funding rate for a source = Source funded ÷ Source leads. Cost per funded deal = Source cost ÷ Source funded. ROI = (Source funded × Revenue per funded deal − Source cost) ÷ Source cost.
Blended cost per funded deal = (Source 1 cost + Source 2 cost + Source 3 cost) ÷ (Source 1 funded + Source 2 funded + Source 3 funded).
Blended funding rate = Total funded ÷ Total leads. Total revenue = Total funded × Revenue per funded deal.
Lowest cost per funded deal = the source with the smallest Cost ÷ Funded; a source with zero funded deals is shown with a dash and ranked last.
Worked examples
Example 1: exclusive, shared and aged sources side by side (tool defaults)
Source 1, Exclusive web leads: $9,000 for 120 leads, 9 funded. Funding rate = 9 ÷ 120 = 7.50%. Cost per funded = $9,000 ÷ 9 = $1,000. ROI = (9 × $4,500 − $9,000) ÷ $9,000 = ($40,500 − $9,000) ÷ $9,000 = 350%. Source 2, Shared leads: $5,000 for 200 leads, 6 funded. Funding rate = 3.00%. Cost per funded = $5,000 ÷ 6 = $833. ROI = ($27,000 − $5,000) ÷ $5,000 = 440%. Source 3, Aged data: $1,500 for 1,000 leads, 4 funded. Funding rate = 0.40%. Cost per funded = $1,500 ÷ 4 = $375. ROI = ($18,000 − $1,500) ÷ $1,500 = 1100%. Blended: $15,500 ÷ 19 funded = $816 per funded deal; 19 ÷ 1,320 leads = 1.44% blended funding rate; total revenue 19 × $4,500 = $85,500. Lowest cost per funded deal: Aged data at $375. The tool is right on cost, but 1,000 aged records took far more dialing labour than 120 exclusive leads, and labour is not in these inputs; the MCA lead ROI calculator adds it.
Example 2: the same three sources after a quarter of tighter credit
Exclusive web leads: $12,000 for 150 leads, 12 funded. Funding rate = 8.00%; cost per funded = $12,000 ÷ 12 = $1,000; ROI = (12 × $5,000 − $12,000) ÷ $12,000 = 400%. Shared leads: $6,000 for 300 leads, 5 funded. Funding rate = 1.67%; cost per funded = $1,200; ROI = ($25,000 − $6,000) ÷ $6,000 = 317%. Aged data: $2,000 for 2,000 leads, 1 funded. Funding rate = 0.05%; cost per funded = $2,000; ROI = ($5,000 − $2,000) ÷ $2,000 = 150%. Blended: $20,000 ÷ 18 = $1,111 per funded deal; 18 ÷ 2,450 = 0.73%; total revenue $90,000. Now Exclusive web leads is cheapest per funded deal at $1,000, and aged data is the most expensive at $2,000 despite being the cheapest per record. The ranking flipped because the funding rates on shared and aged leads fell faster than on exclusive leads when funders tightened, which is the usual pattern: low-intent sources are the first to stop converting.