HMDA Rate Spread: Calculation, Reporting, and HPML Status

The HMDA rate spread is the difference between a mortgage loan’s annual percentage rate and the average prime offer rate (APOR) for a comparable transaction on the same date. Lenders report it under Regulation C so regulators can see which loans are priced well above the going market rate for well-qualified borrowers. A first-lien loan crosses the reporting threshold at 1.5 percentage points or more above APOR; a subordinate-lien loan crosses at 3.5 percentage points or more.1Federal Financial Institutions Examination Council. HMDA Rate Spread Calculator – Help The same math also decides whether the loan is a higher-priced mortgage loan under Regulation Z, which brings its own set of consumer protections.

What the Rate Spread Measures

The benchmark side of the comparison is the APOR, an annual percentage rate built from the interest rates and pricing terms currently offered to low-risk borrowers. The Consumer Financial Protection Bureau publishes APOR tables at least weekly, broken out by loan type (fixed or adjustable) and loan term.2eCFR. 12 CFR 1003.4 – Compilation of Reportable Data Subtract the applicable APOR from the loan’s APR and the result shows how much of a pricing premium the borrower paid. A spread of zero means the borrower got a prime-market rate. A spread of 3.0 means the borrower is paying three full percentage points above what the strongest applicants receive that week.

Regulators look at these numbers in aggregate. Patterns of higher spreads for particular demographic groups or neighborhoods can open a fair lending review. The spread does not prove discrimination by itself, but it flags files that warrant a closer look.

Which Loans Get a Number and Which Get “NA”

Rate spread reporting applies to closed-end mortgage loans and open-end lines of credit that are subject to Regulation Z and secured by a dwelling. It covers originations and applications that were approved but not accepted by the borrower when Regulation Z disclosures were required.3Consumer Financial Protection Bureau. Regulation C – 1003.4 Compilation of Reportable Data Whether the field carries an actual number depends on lien status and whether the calculated spread hits the reporting threshold.

Several categories always receive “NA” instead of a calculated spread:

  • Assumptions, because the borrower is taking over existing terms and no new pricing decision was made.
  • Purchased loans, because the reporting institution did not set the price.
  • Reverse mortgages, which sit outside the standard forward-mortgage comparison.
  • Loans not subject to Regulation Z, where no APR exists to compare.
  • Denied, withdrawn, or incomplete applications, where no final APR was ever produced.

Applications approved but not accepted also receive “NA” when Regulation Z disclosures were not required.4Federal Financial Institutions Examination Council. A Guide to HMDA Reporting – Getting It Right

Business-purpose loans secured by a dwelling trip up a lot of compliance teams. If the loan is a home purchase loan, home improvement loan, or refinancing, it is a covered loan under HMDA and belongs on the Loan Application Register. But business-purpose loans are generally exempt from Regulation Z, so the lender enters “NA” for the rate spread rather than calculating one.4Federal Financial Institutions Examination Council. A Guide to HMDA Reporting – Getting It Right The loan appears in the data without a spread attached.

Insured depository institutions and credit unions that qualify for a partial exemption under Regulation C are not required to report the rate spread data point at all. They still report other HMDA fields.

Getting the Rate-Set Date Right

The rate-set date decides which week’s APOR table applies, so an error here throws off everything downstream. The rule is that the rate-set date is the date the institution set the interest rate for the final time before final action on the loan.5eCFR. 12 CFR Part 1003 – Home Mortgage Disclosure (Regulation C)

How that plays out in practice:

  • With a standard rate lock, the date of the lock agreement is the rate-set date.
  • If the borrower exercises a float-down, or the lock expires and the rate is reset, the new date takes over.
  • A lock extension counts as a new rate-set date even when the rate is identical, because the lender exercised discretion in extending.
  • Without any lock agreement, the rate-set date is whenever the institution last set the rate before final action.

Loan-program switches mid-process are the trickiest case. If the borrower changes programs and the lender adjusts the rate to fit the new program, the program-change date becomes the rate-set date. If instead the lender resets the rate to what the borrower would have received under the new program on the original lock date, and the lender follows that practice consistently across files, the original lock date still controls.5eCFR. 12 CFR Part 1003 – Home Mortgage Disclosure (Regulation C) Consistency is what examiners check.

Calculating the Spread

Four inputs drive the calculation: the finalized APR, the rate-set date, the loan term (or the initial fixed-rate period for an adjustable-rate loan), and the lien status. Those choices point to the correct APOR value.

Using the FFIEC Calculator

The Federal Financial Institutions Examination Council publishes an online calculator that does the lookup and math. Enter the rate-set date, the APR, the loan term, the amortization type (fixed or adjustable), and the lien status; the tool pulls the correct APOR and returns the spread.1Federal Financial Institutions Examination Council. HMDA Rate Spread Calculator – Help If the result falls below the reporting threshold (1.5 points for first liens, 3.5 for subordinate liens), the calculator returns “NA.”

Doing It Manually

Manual calculation is simple subtraction. Loan APR minus APOR equals the spread. The APOR tables are downloadable as CSV files on the FFIEC website, with separate tables for fixed-rate and adjustable-rate products.6Federal Financial Institutions Examination Council. Average Prime Offer Rates Tables Match the correct week to the rate-set date, pick the right amortization type and term, and subtract.

Precision and Format

Report the spread as a percentage to at least three decimal places. A lender may go further (up to fifteen decimals) or round or truncate to three, and trailing zeros can be kept or dropped.4Federal Financial Institutions Examination Council. A Guide to HMDA Reporting – Getting It Right Say a first-lien loan carries an APR of 7.250% and the comparable APOR is 5.800%. The spread is 1.450, which falls below the 1.5-point threshold, so the field gets “NA.” Push the APR to 7.375% and the spread is 1.575, which gets reported as a number.

Adjustable-Rate Loans

ARMs add complexity. When the initial rate is set independently of the index and margin (common with promotional teaser rates), Regulation Z requires the lender to compute a composite APR rather than use the introductory rate alone. The FFIEC directs users to the official commentary at 12 CFR Part 1026, Supplement I, comment 17(c)(1)-10 for how to build that composite.1Federal Financial Institutions Examination Council. HMDA Rate Spread Calculator – Help The APOR benchmark for adjustable products is itself a composite, built from survey data covering both the initial rate and an estimated fully-indexed rate. And the loan term input on the calculator is the initial fixed-rate period, not the full amortization term.

Rate Spread and Higher-Priced Mortgage Loan Status

The HMDA rate spread uses the same math as the Regulation Z test that classifies a loan as a higher-priced mortgage loan (HPML). Both compare the APR to APOR. The consequences are different. HMDA reporting is a data-collection exercise. HPML classification triggers consumer protections that must be delivered before closing.

A closed-end loan secured by the borrower’s principal dwelling is an HPML if the APR exceeds APOR by:7Consumer Financial Protection Bureau. Regulation Z – 1026.35 Requirements for Higher-Priced Mortgage Loans

  • 1.5 percentage points or more for a first-lien loan with a conforming balance.
  • 2.5 percentage points or more for a first-lien loan with a jumbo balance (the loan amount exceeds the Freddie Mac conforming limit as of the rate-set date).
  • 3.5 percentage points or more for a subordinate-lien loan.

The overlap is deliberate. A first-lien conforming loan that has a reportable HMDA spread is, by definition, also an HPML. That means an escrow account for property taxes and hazard insurance before closing, plus a written appraisal from a certified or licensed appraiser who physically visits the property interior, and a second independent appraisal on certain recently flipped properties.8eCFR. 12 CFR 1026.35 – Requirements for Higher-Priced Mortgage Loans The HMDA number is the trigger the compliance team notices; the Regulation Z obligations are what the loan file has to actually contain.

Why Accuracy Matters

Rate spread is one of the most error-prone fields on the Loan Application Register because it depends on getting the rate-set date, amortization type, and loan term exactly right. A wrong date pulls the wrong APOR week, which produces a wrong spread, which can misclassify the loan and cascade into an HPML failure.

The Consumer Financial Protection Bureau enforces HMDA accuracy and has pursued substantial penalties for reporting failures. In one action, the CFPB ordered Bank of America to pay $12 million for HMDA data errors and to overhaul its compliance management system.9Consumer Financial Protection Bureau. Bank of America, N.A. In another, Nationstar Mortgage was fined $1.75 million for three consecutive years of inaccurate reporting, with the penalty size driven by market share, error volume, and prior violations.10Consumer Financial Protection Bureau. CFPB Takes Action Against Nationstar Mortgage for Flawed Mortgage Loan Reporting

For 2026, depository institutions with total assets above $59 million as of December 31, 2025, are required to collect and report HMDA data, including rate spread.11Federal Register. Home Mortgage Disclosure (Regulation C) Adjustment to Asset-Size Exemption Threshold Institutions at or below that line are exempt from HMDA data collection entirely. Non-depository mortgage lenders have separate origination-volume thresholds.

Running every file through the FFIEC calculator before submission catches most systemic errors before they reach a regulator. Documenting the inputs used in each calculation lets an examiner reconstruct the number during a review, which is often the difference between a finding and a clean exam.