Mortgage Servicing
Standard

Merrowent Mortgage

Loan servicing, escrow, delinquency, and payoffs

50% OFF
$8.00
$4.00USD, plus applicable tax
Buy Now
10 tables391K rowsParquet + CSV

About Merrowent Mortgage

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.

Operating Profile

  • Servicing cadence: each active loan generates one monthly principal-and-interest plus escrow payment and one month-end portfolio snapshot.
  • Escrow posture: every account is a running ledger, so each month closes at the prior balance plus what was collected less what was disbursed.
  • Delinquency posture: servicing status moves month to month through Active, Delinquent, Forbearance and Reinstated, and liquidation always follows foreclosure.
  • Credit spread: about 6.1% of loan-months sit 30-plus days past due, from 3.6% at Super Prime to 13.4% at Subprime.
  • Payment posture: about 94% of payments post on time, 5.7% post late with a 4% fee capped at $125, and 0.4% are missed and collect nothing.
  • Modelling notes: the borrower file lists every relationship, and adjustable-rate loans hold one indexed rate rather than re-amortising at each reset.

Recent Business Events

  • 1Post-holiday delinquency rose modestly across the book before easing into spring, a normal seasonal pattern for residential servicing.
  • 2The annual escrow analysis repriced each borrower's deposit in their own review month, lifting accruals where tax and insurance premiums had risen.
  • 3Steady prepayment and payoff activity produced gradual runoff of serviced balance, taking the book from 6,500 loans to 6,202 over the two years.
KPI Focus Areas

These are the operating questions this kit is optimized to answer first.

01Focus

Serviced principal balance, servicing fee revenue, loan count, and average note rate

02Focus

Principal, interest, and escrow collected, scheduled versus paid, and on-time rate

03Focus

Escrow disbursement mix across taxes, insurance, and assessments

04Focus

Delinquency rate, bucket distribution, days past due, and foreclosure share

05Focus

Prepayment and payoff counts, balance runoff, and fee impact

06Focus

Performance by investor pool, product, region, and credit tier

Embedded Analytical Stories

Serviced book and fee economics

Track serviced balance and the fee revenue it earns, where the fee is a thin slice of the balance rather than the balance itself.

Escrow administration

Follow each loan's escrow ledger as accrual, tax and insurance bills, and the occasional advanced shortage reconcile month to month.

Delinquency migration

Follow loans from current into each delinquency bucket and foreclosure, by investor pool, product, region, and credit tier.

Runoff and prepayment

Measure prepayment and payoff activity and its effect on serviced balance and servicing fee revenue.

Merrowent Mortgage
$4.00USD, plus applicable tax
Buy Now