Loan servicing, escrow, delinquency, and payoffs
Industry
Residential mortgage servicing
Footprint
Servicing residential mortgages for borrowers across 26 U.S. states
Book focus
A seasoned book of owner-occupied and investment residential mortgages serviced for investor and portfolio owners
Company size
Mid-market servicer earning $12M to $14M of servicing fee revenue across the two-year window, about $6.5M a year
Data scope
Standard 10-table package
Planning note
Servicing operations, escrow, delinquency, prepayments, and payoffs rather than loan origination
Merrowent Mortgage is a fictional residential mortgage servicer that does not originate loans; it services an existing, seasoned book on behalf of fictional investor pools and portfolio owners. Every month it collects principal and interest, administers escrow, disburses property tax and insurance, manages delinquency and loss mitigation, and processes prepayments and payoffs. Its income is a servicing fee of 22 to 47 basis points on an unpaid principal balance of about $2.0 to $2.2 billion across some 6,500 loans, so the fee it earns is a thin slice of the balance it services. The book runs off gently as prepayments and payoffs season it.
These are the operating questions this kit is optimized to answer first.
Track serviced balance and the fee revenue it earns, where the fee is a thin slice of the balance rather than the balance itself.
Follow each loan's escrow ledger as accrual, tax and insurance bills, and the occasional advanced shortage reconcile month to month.
Follow loans from current into each delinquency bucket and foreclosure, by investor pool, product, region, and credit tier.
Measure prepayment and payoff activity and its effect on serviced balance and servicing fee revenue.