Topic Options
#2167814 - 03/13/18 11:32 AM Rate Calc Accuracy AGAIN?
ccman Offline
Platinum Poster

Registered: 09/04/07
Posts: 738
We have an APR of 4.273 when tested on Rate Calc for 30 year fixed loan dated today shows a -0.227.
Can someone double check the 30 yr. APOR. Its showing a 4.01 APOR? HELP...

Top
TRID - TILA/RESPA Integrated Disclosures Rule
#2167819 - 03/13/18 11:40 AM Re: Rate Calc Accuracy AGAIN? [Re: ccman]
ccman Offline
Platinum Poster

Registered: 09/04/07
Posts: 738
Found the error. This "pipe" whatever file format is [censored]!!!

Top
#2167889 - 03/13/18 02:33 PM Re: Rate Calc Accuracy AGAIN? [Re: ccman]
Dan Persfull Offline
10K Club

Registered: 08/28/02
Posts: 45092
Loc: Bloomington, IN
Are you trying to use the spread sheet in the pipe delimited txt format? If so convert it to an Excel format.

open a blank work sheet
click on cell A1
click on data
click on from text
choose the apor file you want to convert
click import
click on my data has headings and click next
on the next screen uncheck tabs and check other and enter | and then click next
on the next screen uncheck general and check date click finish and then click import.

Now you can format the columns to your liking.
_________________________
The opinions expressed are mine and they are not to be taken as legal advice.

Top