Thread: Looking for final interest payment on a loan just paid off

Hi there,
It has been over 7 years since I have had to use any of my mathematics of finance knowledge and wow does it disappear when you do not use it.
i have pulled out my old books to determine additional payments to a P.V. (geese, at least I think that's the formula I want) but I cannot remember how to execute the problem. Can someone please help.
Here are the values...
interest rate is 8% c.s.a.
loan with interest as of Sept. 1 2011
= $31 938.59

Regular payments of $1000 per month starting Sept 1st.

On top of the $1000 payment, an additional payment of $5000 was made on Dec 1 st 2011
Not knowing the interest amount, I have paid of the rest of the principle on May 1st totaling $17 938.59
i would like to figure out the balance of the loan owing, which should only be the interest from Sept 1.

The formula I think I should be using is:

31938.59=1000[1-(1+I)-n]
______
I

Then I would need to find the balance on the 8th payment???

Help please! I am a business owner, not in school anymore . Although maybe I should be! Lol

I have I think figured out that...
Pv=-31938.59
I=.04
N=8
Because there is no real ending term of time with the loan, should I enter in eight months since that's the time it took to pay it off?

Originally Posted by Tlmuntain

Here are the values...
interest rate is 8% c.s.a.
loan with interest as of Sept. 1 2011
= $31 938.59

Regular payments of $1000 per month starting Sept 1st.

On top of the $1000 payment, an additional payment of $5000 was made on Dec 1 st 2011
Not knowing the interest amount, I have paid of the rest of the principle on May 1st totaling $17 938.59
i would like to figure out the balance of the loan owing, which should only be the interest from Sept 1.

My fellow Canadian, you are more confusing than my mother-in-law!

Your loan amount (INCLUDING INTEREST calculated as if $1000 will be paid monthly and nothing else!)
at Sep 1st/11 is really 30,938.50: due to payment made Sep 1st ...... RIGHT?
So if you stuck to $1,000 monthly, your final payment would be 938.59...RIGHT?

And this: "interest rate is 8% c.s.a."
means compounded semi-annually...RIGHT?
Boy, wonder why we still do that...started in the 1800's I think, when farmers
paid back farm loans twice yearly, to match income from early crops and later crops!

The interest to use is the MONTHLY equivalent to the semi-annual rate, thusly:
(1 + i)^12 = 1.04^2 ; works out to i = .006558... per month;
as example, $20,000 for 1 month means interest of 20000 * .006558 = $131.16

We need the amount of loan WITHOUT interest...or the loan's cash proceeds:
that's the Present Value of 31 monthly payments of $1,000 ($30,938, so 31 close enough):
that works out to $27,970 (give or take a Loonie...worth 1.01583...USA!)

After 7 payments of $1,000 (to Apr 1st) plus your extra payment of $5,000, the $27,970
reduces to $17.007 as at Apr 1st: so when you walked in to pay off on May 1st,
17,007 + 113 (interest for April) = 17,120 was owing.

Since you paid 17,938, then owing to you should be 17938 - 17120 = $818.

Ok, above is a close as I can make it with the info you've given.
Let me know if you need more.

Here's what a "loan account statement" would look like:

Code:

DATE   PAYMENT INTEREST BALANCE
Sep 1                    27970
Oct 1  -1000    183      27153
Nov 1  -1000    178      26331
Dec 1  -6000    173      20504
Jan 1  -1000    134      19638
Feb 1  -1000    129      18767
Mar 1  -1000    123      17890
Apr 1  -1000    117      17007
May 1           113      17120

Lol, but not as confusing as my mother-in-law !

Here is my chart from G/L
Yes case means semi-annually lol
The prospect of the loan was to pay 1000 until we could pay them in full.
My last fiscal year end was August 31, 2011 where the balance owing including interest was
31938
So here my table
Date. Payment. Balance no interest added
August 31 31938
Sept 1. 1000. 30938
Oct 1. 1000. 29938
Nov 1. 1000. 28938
Dec 1. 6000. 22938
Jan 1. 1000. 21938
Feb 1. 1000. 20938
Mar 1. 1000. 19938
Apr 1. 1000. 18938
May 1. 18938. 0

Now I just need the interest amount owing on the loan from sept 1 till the payout on may 1 st.
I hope that is clearer lol . AND to make it more confusing, I am not sure if hey will charge me 5 or 8 percent interest. Depends on how close they read the contract, I SHOULD be paying eight percent but they may only charge me five. Both C.S.A.
Thank you for helping me, I think I sounded confusing because I tried on my own for two hours before reaching out for help lol

Sorry, it didn't space out as nicely as I had typed it in!

Originally Posted by Tlmuntain

My last fiscal year end was August 31, 2011
where the balance owing including interest was 31938

Geezzzzz TL: does that mean
1: including interest up to that point
or
2: including all future interest

I assumed you meant #2.

Including interest to that point.
They have given me the interest accrued at my year ends which I have entered into my books. Therefore the 31938 was interested up to that point.

if I take .006558 and multiply that to each of my balances in my table, would that then give me the interest...ex
30938 x .006558 = 202.89
So then my balance due the end of sept would be 31140.
Then 1000 was paid oct 1st bringing it to 30140
Calculate interest again = 197.46
So balance due end of oct would be 29912
Etc etc .?? Is it hat simple? Was I trying to complicate it too much?

Not quite; this way:

Code:

DATE   PAYMENT INTEREST BALANCE
Sep 1                    30938
Oct 1  -1000    203      30141
Nov 1  -1000    198      29339
Dec 1  -6000    192      23531
Jan 1  -1000    154      22685***
Feb 1  -1000    149      21834
Mar 1  -1000    143      20977
Apr 1  -1000    138      20115
May 1           132      20247

Total interest = 1309

***example: 22685 * .006558 = 148.77 : becomes end of Jan interest...