Broker Marketing ROI Calculator
See whether the commission from settled loans covers what you spent to win and deliver them.
Campaign costs and settlements
Campaign return
Example inputs- $13,140
- 123%
- $63
- $719
- 3
Follow Enquiries Through to Settlement
Count enquiries, qualified appointments, applications and settlements from the same campaign. Follow those enquiries through to settlement even when the loans settle after the ads end. Count each enquiry once at each stage it reaches so repeat calls or applications for the same enquiry do not inflate the totals.
Divide each stage count by the one before it to see where enquiries drop out. In the fictional example, 92 enquiries lead to 31 qualified appointments, 13 applications and eight settlements. That is about 34% from enquiry to appointment, 42% from appointment to application and 62% from application to settlement.
Count Revenue and Delivery Costs
Use average commission received per settled loan within the period you enter. Keep forecast trail separate in the future trail field. When you include future trail, the calculator adds that amount to cash received so you can see how the forecast changes your return.
Put ad spend and other acquisition costs in the campaign budget. Include fixed delivery costs, such as pre-settlement file work, even when the campaign produces no settlements. Enter the processing or servicing cost that comes with each settled loan separately.
Use the same tax basis and revenue period when you compare campaigns. If you enter commission after a split or other deduction, leave that deduction out of delivery costs so you only count it once.
Read ROI and Break-Even Volume
Cost per enquiry and cost per settlement divide total acquisition spend by their respective counts. The campaign spends $4,870 on ads and $880 on other acquisition costs. That works out to $63 per enquiry and $719 per settlement.
Net campaign return is settlement revenue minus acquisition and delivery costs. Return on investment (ROI) is that net return divided by total costs, multiplied by 100.
Eight settlements at $2,980 each earn $23,840. With $290 in fixed delivery costs and $582.50 per settled loan, total costs reach $10,700, leaving $13,140 and a 123% ROI.
For break-even, divide acquisition spend plus fixed delivery costs by the revenue per settlement less its delivery cost. Business Queensland’s break-even guide explains how each sale contributes towards fixed costs. Round up to a whole settlement. The campaign needs three settlements because two leave part of the $6,040 in fixed costs unpaid.
At zero settlements, the same campaign loses $6,040 and returns an ROI of -100%. Cost per settlement has no value until a loan settles. If each settlement earns less than or equal to its own delivery cost, no number of settlements can cover positive fixed costs.