hmda_rate_spread
Compute the rate spread between loan APR and APOR to meet HMDA reporting and fair lending analysis requirements.
Instructions
Calculate the rate spread for a mortgage loan using the CFPB rate spread calculator. Rate spread = difference between the loan APR and the average prime offer rate (APOR). Used for HMDA reporting and fair lending analysis.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| apr | Yes | Annual percentage rate (e.g. '6.0') | |
| loan_term | Yes | Loan term in months (e.g. '360' for 30-year) | |
| lock_in_date | Yes | Rate lock-in date in MM/DD/YYYY format (e.g. '01/15/2023') | |
| reverse_mortgage | Yes | Reverse mortgage flag (1=yes, 2=no) | |
| action_taken_type | Yes | Action taken type (1=originated, 2=approved not accepted, etc.) | |
| amortization_type | Yes | Amortization type |