Skip to content
BOL Conferences Top Gun 23
Page 2 of 4 1 2 3 4
Thread Options
#2158453 - 12/27/17 03:32 PM Re: CFPB rate spread calculator RR Becca
RR Becca Offline
Power Poster
RR Becca
Joined: Sep 2004
Posts: 5,245
out of the frying pan...
Ditto on the spinning. Traffic overload?
_________________________
You call it ADD. I call it multi-tasking.

Return to Top
HMDA

   
HMDA Academy
#2158458 - 12/27/17 04:01 PM Re: CFPB rate spread calculator RR Becca
Indy Banker Offline
Platinum Poster
Joined: Aug 2010
Posts: 528
Spinning wheels....

Return to Top
#2158482 - 12/27/17 06:01 PM Re: CFPB rate spread calculator RR Becca
river girl Offline
Diamond Poster
Joined: Nov 2004
Posts: 1,005
spinning

Return to Top
#2158575 - 12/28/17 03:28 PM Re: CFPB rate spread calculator RR Becca
cgorham Offline
100 Club
Joined: Sep 2015
Posts: 120
Well, last night and this morning I'm getting "Sorry, an error has occured. Please try again later. If the problem persists, contact HMDA Help." I guess that is better than it sitting in limbo. And yes, they spelled occurred wrong.

I also noticed the Check Digit Tool they released yesterday has display issues. The “Generate a check digit” option states “A valid LEI and Loan/Application ID has a minimum of 20 characters”. LEIs are 20 characters long, and the loan ID would be a minimum of 1 character, so I would think the minimum is 21 characters. The “Validate a ULI” option appears to get this right by saying the ULI must be at least 23 characters. So the two options currently contradict each other. Not a big deal for most companies, but still wrong.

It is not very comforting that they are having these issues with what seem to be very simple tools that are being released at the 11th hour. These are websites that could probably be built by a fairly inexperienced coder in a few weeks. It doesn't bode well for the much more complex tools/platforms they are planning to release throughout 2018. I really feel they should have had everything relatively finalized and released (including the 2018 platform with edits) before we were required to collect the new data.
Last edited by cgorham; 12/28/17 03:29 PM.
Return to Top
#2158579 - 12/28/17 03:49 PM Re: CFPB rate spread calculator RR Becca
jedeca Offline
Member
Joined: Oct 2009
Posts: 69
KY
I tried it and it gave me a spread but I didn't see where you can mark the loan is for a first lien or a junior lien like the old one. Did I miss it?

Return to Top
#2158581 - 12/28/17 03:56 PM Re: CFPB rate spread calculator RR Becca
rlcarey Offline
10K Club
rlcarey
Joined: Jul 2001
Posts: 80,325
Galveston, TX
This is not used for HPML purposes. Under the new HMDA you report whatever spread that comes up - positive or even a negative spread.
_________________________
The opinions expressed here should not be construed to be those of my employer: PPDocs.com

Return to Top
#2158583 - 12/28/17 04:16 PM Re: CFPB rate spread calculator RR Becca
David Dickinson Offline
10K Club
David Dickinson
Joined: Nov 2000
Posts: 18,762
Central City, NE
Randy's right. This is a tool to report the rate spread between the APR and the APOR (positive, negative or 0) for all consumer loans and Approved Not Accepted on your HMDA LAR.

cgorham said: It is not very comforting that they are having these issues with what seem to be very simple tools that are being released at the 11th hour.
I agree with your comments. Sad.
_________________________
David Dickinson
http://www.bankerscompliance.com

Return to Top
#2158586 - 12/28/17 04:32 PM Re: CFPB rate spread calculator RR Becca
TMatt87 Offline
Diamond Poster
TMatt87
Joined: May 2011
Posts: 1,938
Idaho
I just tried it, and it returned a rate spread to 18 digits after the decimal place.
_________________________
All opinions are my own, not my employer's

Return to Top
#2158745 - 12/29/17 04:36 PM Re: CFPB rate spread calculator RR Becca
Indy Banker Offline
Platinum Poster
Joined: Aug 2010
Posts: 528
Has anyone opened up the new fixed or adjustable APOR Tables on the FFIEC site? They used to be available as an Excel spreadsheet, now they are produced in some garbage format that you can't even read.

Return to Top
#2158746 - 12/29/17 04:51 PM Re: CFPB rate spread calculator RR Becca
rlcarey Offline
10K Club
rlcarey
Joined: Jul 2001
Posts: 80,325
Galveston, TX
You are going to have to save it in plain text format and import into Excel. Definitely not very user friendly.
_________________________
The opinions expressed here should not be construed to be those of my employer: PPDocs.com

Return to Top
#2158747 - 12/29/17 04:54 PM Re: CFPB rate spread calculator RR Becca
rlcarey Offline
10K Club
rlcarey
Joined: Jul 2001
Posts: 80,325
Galveston, TX
They are still here - but don't know if they will update after 01/01/18.

https://www.ffiec.gov/ratespread/aportables.htm
_________________________
The opinions expressed here should not be construed to be those of my employer: PPDocs.com

Return to Top
#2158792 - 12/29/17 08:12 PM Re: CFPB rate spread calculator RR Becca
Indy Banker Offline
Platinum Poster
Joined: Aug 2010
Posts: 528
Thanks RL!

Return to Top
#2158846 - 01/02/18 02:44 PM Re: CFPB rate spread calculator RR Becca
Adam F Offline
Gold Star
Adam F
Joined: Apr 2013
Posts: 414
VA
Has anyone tried the calculator this morning?

A couple times I tried to run some numbers and it just spun. Then I got an error message and now I am getting a return of NA when the numbers I am running should be giving me a rate spread of 1.123.
_________________________
It is better to act cautiously beforehand than to suffer afterward.

The answers I give are my opinions. Not legal advice.

Return to Top
#2158861 - 01/02/18 03:29 PM Re: CFPB rate spread calculator Adam F
LaLendingLady Offline
Junior Member
Joined: Apr 2014
Posts: 36
It's working for me.

Return to Top
#2158881 - 01/02/18 04:50 PM Re: CFPB rate spread calculator RR Becca
raitchjay Offline
Power Poster
Joined: Oct 2009
Posts: 8,874
OK
Anybody having problems with APOR tables this morning? I'm reading something from my vendor (and our LOS won't calculate rate spreads today) basically saying that the FFIEC somehow screwed up the APOR tables.
_________________________
I'm fixin' to fix that.

Return to Top
#2158888 - 01/02/18 05:09 PM Re: CFPB rate spread calculator RR Becca
rlcarey Offline
10K Club
rlcarey
Joined: Jul 2001
Posts: 80,325
Galveston, TX
It is not the FFIEC, it is the CFPB and it is your vendor's fault if they didn't realize they changed the format of the tables that the CFPB is making available.
_________________________
The opinions expressed here should not be construed to be those of my employer: PPDocs.com

Return to Top
#2158891 - 01/02/18 05:14 PM Re: CFPB rate spread calculator RR Becca
raitchjay Offline
Power Poster
Joined: Oct 2009
Posts: 8,874
OK
My vendor's fault....yup, that sounds like my vendor.
_________________________
I'm fixin' to fix that.

Return to Top
#2158895 - 01/02/18 05:41 PM Re: CFPB rate spread calculator RR Becca
elebra Offline
100 Club
Joined: Apr 2009
Posts: 106
My vendor provided a few new spreadsheets to replace the old spreadsheets for calculations. Just save them in place of last week's table. I double checked the rates against the apor table provided on the cfpb's website.
Last edited by elebra; 01/02/18 05:41 PM.
Return to Top
#2158905 - 01/02/18 07:07 PM Re: CFPB rate spread calculator RR Becca
Indy Banker Offline
Platinum Poster
Joined: Aug 2010
Posts: 528
I don't understand why they couldn't just keep using the old APOR tables and add the new indexes. I can't work with the new table. I tried to save it as plain text document and open with Excel but still can't figure out how to get the indexes to appear in a columnar fashion like the current table, they have all 50 indexes for each week in a single cell. Gave up and just counted 15 over to get the 15-year index, 30 for the 30-year, etc. Plus the new table only includes 1 year of historical indexes.

Return to Top
#2158910 - 01/02/18 07:22 PM Re: CFPB rate spread calculator RR Becca
LaLendingLady Offline
Junior Member
Joined: Apr 2014
Posts: 36
Has anyone else tested the new APOR rates provided by the CFPB with the new calculator? It appears either the rate table is wrong or the calculator is. What the !!!???

Return to Top
#2158911 - 01/02/18 07:25 PM Re: CFPB rate spread calculator RR Becca
RR Joker Offline
10K Club
RR Joker
Joined: Nov 2002
Posts: 20,654
The Swamp
From what I read and what I'm seeing...I think they messed up their their spreadsheet [calculator]
_________________________
My opinion only. Not legal advice.

Say you'll haunt me - Stone Sour

Return to Top
#2158912 - 01/02/18 07:26 PM Re: CFPB rate spread calculator Indy Banker
Whyisit Offline
Member
Joined: Nov 2004
Posts: 56
We were given 4 sets of files to choose from in consultation with your compliance officer - are you kidding! What have others done?

Return to Top
#2158913 - 01/02/18 07:26 PM Re: CFPB rate spread calculator LaLendingLady
rlcarey Offline
10K Club
rlcarey
Joined: Jul 2001
Posts: 80,325
Galveston, TX
Originally Posted By LaLendingLady
Has anyone else tested the new APOR rates provided by the CFPB with the new calculator? It appears either the rate table is wrong or the calculator is. What the !!!???


Not sure what you are referring too. You would have to give us a specific example.
_________________________
The opinions expressed here should not be construed to be those of my employer: PPDocs.com

Return to Top
#2158914 - 01/02/18 07:27 PM Re: CFPB rate spread calculator RR Becca
NorthSouth Offline
Junior Member
Joined: Jun 2015
Posts: 26
I'm still digesting the vendor's way-too-long explanation about all of this.
_________________________
We often take for granted the very things that most deserve our gratitude.

Return to Top
#2158915 - 01/02/18 07:30 PM Re: CFPB rate spread calculator Indy Banker
rlcarey Offline
10K Club
rlcarey
Joined: Jul 2001
Posts: 80,325
Galveston, TX
Originally Posted By Indy Banker
they have all 50 indexes for each week in a single cell. Gave up and just counted 15 over to get the 15-year index, 30 for the 30-year, etc. Plus the new table only includes 1 year of historical indexes.


The file is delimited with "|" you have to import it as a delimited file and it will work. As far as one year, do you have loans with a final disposition in 2018 that you would locked the rate in prior to 01/01/17??
_________________________
The opinions expressed here should not be construed to be those of my employer: PPDocs.com

Return to Top
Page 2 of 4 1 2 3 4