Thread Options
#2041489 - 09/30/15 03:45 PM Irregular Payment and APR
Many Hats Offline
Platinum Poster
Joined: May 2008
Posts: 915
Orlando, FL
I am looking at a consumer mortgage loan that has the following payment structure: 120 mo P&I; fixed rate; with an add'l $10,000 principal pmt due annually on the anniversary date of the loan. The addt’l principal payment is disclosed via a separate addendum to the note but is not included in the APR calculation. When I enter the loan into APRWIN, I get a huge APR and finance charge understatement. I used the irregular tolerance of .25%. Am I correct that the $10,000 annual principal payment must be included in the APR calculation?

Return to Top
Lending Compliance
#2041531 - 09/30/15 04:52 PM Re: Irregular Payment and APR Many Hats
Rocky P Offline
Power Poster
Joined: Jun 2003
Posts: 7,208
Florida
The APR would be for the terms of the contract. Richard would probably be the best to answer, but it might appear that you have 11 payments, followed by the payment plus the $10,000, then repeat 9 more times.
_________________________
Integrity. With it, nothing else matters. Without it, nothing else matters.

Return to Top
#2041600 - 09/30/15 06:42 PM Re: Irregular Payment and APR Many Hats
Many Hats Offline
Platinum Poster
Joined: May 2008
Posts: 915
Orlando, FL
I entered the payment stream as follows:

1 - $1551.58, 119 pmts
2 - $1553.95, 1 pmt (this is the final pmt)
3 - $10,000, 9 pmts (I used 9 since there wouldn't be a $10,000 pmt at maturity)

I come up with an understated APR by 5.4378 and understated finance charge by $89,643

I used a .25% tolerance (assuming this qualifies as an irregular loan)

Am I on the right track?

Return to Top
#2041650 - 09/30/15 07:48 PM Re: Irregular Payment and APR Many Hats
Rocky P Offline
Power Poster
Joined: Jun 2003
Posts: 7,208
Florida
What about matching the note.
11 x $1,151.58
1 x $11,151.58

repeat 10 more times then

11 x $1,151.58
1 x $1,153.95
_________________________
Integrity. With it, nothing else matters. Without it, nothing else matters.

Return to Top
#2041706 - 09/30/15 08:56 PM Re: Irregular Payment and APR Rocky P
Richard Insley Offline
Power Poster
Richard Insley
Joined: Oct 2000
Posts: 9,987
Toano, VA
Originally Posted By Rocky P
11 x $1,151.58
1 x $11,151.58...
That's the right way to to the calculations, but (due to a software flaw) I think APRWIN chokes somewhere short of 20 payment streams.
_________________________
...gone fishing.

Return to Top

Moderator:  Andy_Z