Formula
Monthly servicing revenue = Portfolio balance serviced × Servicing fee (annual share of balance) ÷ 12 + Number of accounts × Flat monthly fee per account.
Monthly servicing cost = Monthly servicing staff cost + Monthly system, payments and compliance cost + Number of accounts × Variable cost per account per month.
Monthly servicing margin = Revenue − Cost. Revenue per account = Revenue ÷ Accounts. Cost per account = Cost ÷ Accounts. Average balance per account = Balance ÷ Accounts.
Break-even portfolio balance (fixed costs) = (Staff cost + System cost) ÷ (Servicing fee ÷ 12). This is the balance at which the percentage fee covers fixed costs alone; the flat fee and the variable cost per account are left out so the figure is independent of account count.
Worked examples
Example 1: the default portfolio ($25 million, 900 accounts, 1 percent fee)
Revenue: $25,000,000 × 0.01 ÷ 12 = $20,833.33, plus 900 × $0 flat fee = $20,833.33 a month. Cost: $32,000 staff + $9,000 systems + 900 × $6 = $32,000 + $9,000 + $5,400 = $46,400. Margin: $20,833.33 − $46,400 = −$25,566.67, shown as −$25,567 and flagged. Revenue per account: $20,833.33 ÷ 900 = $23.15. Cost per account: $46,400 ÷ 900 = $51.56. Average balance per account: $25,000,000 ÷ 900 = $27,778. Break-even balance: ($32,000 + $9,000) ÷ (0.01 ÷ 12) = $41,000 ÷ 0.000833 = $49,200,000. The operation loses money at this scale: it needs almost twice the balance before the 1 percent fee covers staff and systems, and that is before the $6 per account variable cost, which adds $5,400 a month. The fix is some combination of more balance, a higher fee, a flat per-account charge, or lower cost per account.
Example 2: a small-balance book with a flat fee
Inputs: $8,000,000 balance, 1,600 accounts, 1.25 percent fee, $4 flat monthly fee per account, $18,000 staff, $5,000 systems, $5 variable cost. Revenue: $8,000,000 × 0.0125 ÷ 12 = $8,333.33, plus 1,600 × $4 = $6,400, total $14,733.33. Cost: $18,000 + $5,000 + 1,600 × $5 = $31,000. Margin: −$16,266.67. Revenue per account: $14,733.33 ÷ 1,600 = $9.21. Cost per account: $31,000 ÷ 1,600 = $19.38. Average balance: $5,000. Break-even balance on the percentage fee: $23,000 ÷ (0.0125 ÷ 12) = $22,080,000. The flat fee contributes $6,400, nearly half of revenue, but the average balance of $5,000 earns only $5.21 a month at 1.25 percent, far below the $19.38 cost. Small-balance servicing cannot be priced as a percentage of balance; it needs a flat fee closer to the cost per account.
Example 3: what it takes to make Example 1 break even
Keep the default costs and 900 accounts. Fixed costs are $41,000 and variable costs $5,400, so revenue must reach $46,400. Option A, more balance at 1 percent: $46,400 × 12 ÷ 0.01 = $55,680,000, more than double the current book. Option B, a flat fee on the current $25 million: ($46,400 − $20,833.33) ÷ 900 = $28.41 per account per month. Option C, a higher percentage: $46,400 × 12 ÷ $25,000,000 = 2.23 percent a year. Option D, mixed: raise the fee to 1.5 percent ($31,250 a month) and add a $17 flat fee ($15,300), total $46,550, margin $150. Each option has a different market constraint: lenders rarely accept a servicing fee above what their own cost would be, so Option C may be unsellable, while Option A depends on winning business you do not yet have.