Formula
Stage conversion = Count at this stage ÷ Count at the previous stage, for Leads → Contacted, Contacted → Submitted an application, Applied → Received an offer, and Offered → Funded.
Lead to funded = Funded ÷ Leads, which also equals the product of the four stage conversions. Leads needed per funded deal = 1 ÷ Lead to funded.
Revenue from these leads = Funded × Revenue per funded deal. Weakest stage = the stage pair with the lowest conversion.
Worth of a 10% lift at the weakest stage = Funded × 0.10 × Revenue per funded deal, because a 10% relative lift at any single stage raises funded deals by 10%.
Worked examples
Example 1: a thousand leads through a broker's funnel (tool defaults)
Inputs: 1,000 leads, 620 contacted, 240 applied, 150 offered, 54 funded, $4,000 revenue per funded deal. Leads → Contacted: 620 ÷ 1,000 = 62.0%. Contacted → Applied: 240 ÷ 620 = 38.7%. Applied → Offered: 150 ÷ 240 = 62.5%. Offered → Funded: 54 ÷ 150 = 36.0%. Lead to funded: 54 ÷ 1,000 = 5.40%; check by multiplying 0.62 × 0.387 × 0.625 × 0.36 = 0.054. Leads per funded deal: 1 ÷ 0.054 = 18.5. Revenue from these leads: 54 × $4,000 = $216,000. Weakest stage: Offered → Funded at 36.0%, meaning almost two in three merchants who receive an offer do not take it. Worth of a 10% lift there: 54 × 0.10 × $4,000 = $21,600 on this batch of leads. If offers converted at 39.6% instead of 36.0%, funded deals would rise from 54 to about 59.
Example 2: a smaller batch with a contact problem and an offer problem
Inputs: 500 leads, 250 contacted, 100 applied, 70 offered, 20 funded, $5,000 per funded deal. Leads → Contacted: 250 ÷ 500 = 50.0%. Contacted → Applied: 100 ÷ 250 = 40.0%. Applied → Offered: 70 ÷ 100 = 70.0%. Offered → Funded: 20 ÷ 70 = 28.6%. Lead to funded: 20 ÷ 500 = 4.00%. Leads per funded deal: 25. Revenue: 20 × $5,000 = $100,000. Weakest stage: Offered → Funded at 28.6%. Worth of a 10% lift: 20 × 0.10 × $5,000 = $10,000. The contact rate of 50% is also weak, and the tool only flags one stage; a manager would look at both, because contact rate is usually cheaper to fix (speed, more attempts, texting with consent) than offer acceptance (pricing, competition, stacking). Here the underwriting approval rate of 70% is healthy, so the leads are fundable; the problem is reaching them and winning them.