Question of
the Week
Q
- Hi Jeff,
Thanks
for the great note business newsletter. Can you tell how to determine the
balance of a note if the buyer pays more than the scheduled payment every
month? For example,
Amount of Note: 36,000.00
First Payment: Sept 1, 2013 (17
Payment 163 remaining)
Monthly payment: 344.00 per the
note, buyer pays 350.00 monthly
Term: 180
Interest Rate: 8%
The note seller calculated 4
months x 6.00 dollars for 2013
and 12 months X 6 for 2014. And
now he received January's
payment (1 month X 6.00 dollars)
How would you handle this
situation? How would you
determine the balance? The note
seller stated that he subtracted
24 from the principal at the end
of 2013 and then he subtracted
72 dollars at the end of 2014.
Confused… Thanks for your help.
~ Kevin
A -
Hi Kevin!
Thanks for the email! What the seller did isn't exactly accurate but it's a good
guess-timate. The way we would do it is to enter it into an amortization
program (we use T-Value) and it will give us the exact current balance. On the
calculator if they have made 17 payments of $350 instead of $344 it would look
like this:…First the stated note terms are this:
N = 180
I = 8
PV = -36,000
PMT= 344.03
FV = 0
The balance after 17 payments at
the stated $344.03 is this:
N = 163
I = 8
PV = -34,133.87
PMT= 344.03
FV = 0
If they paid $350.00 for the
last 17 months we have to
re-amortize it then solve for
the balance like this:
RE-amortize:
N = 174.20
I = 8
PV = -36,000
PMT= 350.00
FV = 0
solve for new balance after 17
payments 174.20 – 17 = 157.20:
N = 157.20
I = 8
PV = -34,026.86
PMT= 350.00
FV = 0
So you see just subtracting $72
isn't quite accurate because it
does not account for the
amortized portion of the ratio
between interest and principal
in the amortized payments. Hope
this helps!
~ Jeff
|