Free Templates · Mortgage Origination

Mortgage Loan Officer Commission and Draw Excel Calculator

A 4-tab, 100% formula-driven Excel workbook modeling basis-point commissions, per-loan floors and caps, self-gen vs. company-lead splits, Year 1 recoverable draw recovery, and break-even pipeline volume.

Direct download (free, no registration required)

Includes editable blue inputs, 10 live mathematical and regulatory checks in the Controls tab (standard Excel formulas only, zero macros, compatible with Excel, LibreOffice, and Google Sheets), preloaded with the Quillfield Home Loans 2027 case (60 funded loans, $21.64M volume, $210,600 commission).

Download MLO_Commission_Calculator.xlsx Explore The Mortgage Loan Officer →

What the Workbook Computes Dynamically

TabScope & Formulas
Inputs_and_SummaryEditable blue assumptions for retail bps (100 bps), company-lead bps (50 bps), $1,000 floor, $7,500 cap, $3,000 recoverable draw, $15,000 bonus, CFPB 10% bonus cap check, break-even loans/applications, and 3-seat comparison (Bank $131,560, Nonbank Retail $225,600, Broker $220,040).
Pipeline_and_PullThroughFour-channel lead funnel (328 leads, 96 applications, 62.5% pull-through, 60 funded loans), 5-tier loan-size commission schedule with dynamic MIN/MAX floor and cap logic, and 12-month Year 1 ramp draw tracker ($6,000 peak deficit in Month 2, cleared in Month 5).
Break_Even_SensitivityThree 2D sensitivity tables: annual commission across $0.5M to $3.0M monthly volume vs. 40 to 125 bps, monthly surplus/deficit after draw and overhead, and annual funded loans across 4 to 16 monthly applications vs. 45% to 75% pull-through.
Controls10 live cross-sheet mathematical and regulatory identity checks (funnel reconciliation, volume SUMPRODUCT, floor/cap bounds, effective bps, CFPB 10% bonus cap, draw recovery) returning OK or CHECK automatically.

Read the full guide behind every formula

See the worked examples, 12 CFR 1026.36 compliance rules, and recoverable draw traps in Mortgage Loan Officer Commission Structure, or study the complete mortgage desk in The Mortgage Loan Officer.