The old rate spread calculator is being kept on the FFIEC HMDA website for historical purposes, but should not be used for ongoing rate spread calculations. A final and last update to the "old" calculator was September 15, 2011. If there is a non-HMDA related business need to access data used to update the "old" calculator, please visit the US Treasury Department's website at: http://www.treasury.gov/resource-center/data-chart-center/interest-rates/Pages/TextView.aspx?data=yield

IF THE APPLICATION DATE IS ON OR AFTER OCTOBER 1, 2009 OR THE ACTION TAKEN DATE IS ON OR AFTER JANUARY 1, 2010 USE THE NEW CALCULATOR.

The old rate spread calculator generates the spread between the Annual Percentage Rate (APR) and the comparable treasury security utilizing the "Treasury Securities of Comparable Maturity under Regulation C" table, action taken, lock-in date, APR, term (loan maturity), and lien status. Rate spread is a calculated field and is NOT simply the APR on the loan application.

A batch rate spread calculator is also available to allow institutions to calculate the rate spread on multiple Loan Application Registers (LARs).

The "Treasury Securities of Comparable Maturity under Regulation C " table is available in ASCII comma delimited format to view, print and download. See Help for more details.

NOTE: Do not use the rate spread calculator to calculate the HOEPA status; they are two different fields which require two different calculations. See Help for more details.

Action Taken:	1 - Loan Originated (Info)
Lock-In Date (mm/dd/ccyy)
APR (00.00)%
Term (Years, Whole Number)
Lien Status	1 - Secured by a first lien 2 - Secured by a Junior lien 3 - Not secured by a lien 4 - NA (purchased loan)