Question about loan interest rates in Canada/USA
-
Thanks Leppie, I used your instructions and got this :- Interest = 25/12 = 2.083333%
3000 750 62.4999900 812.49999
2250 750 46.8749925 796.8749925
1500 750 31.2499950 781.249995
750 750 15.6249975 765.6249975
TOT 156.249975 3156.249975Hey, the interest I pay went down :-) Looks like 25% is not such a bad interest amount after all :-)
Here's the excel function: =PMT(0.25/12,4,3000) and that equals 4 payments of -789.46. xacc-ide 0.0.99-preview2 (now with integrated debugger)
-
Banks in Canada are pretty unfriendly to new people - they treat no-credit-history as equivalent to bad-credit-history. Guilty until proven innocent here. It sucks, but they don't probably have any better options - too many new immigrants are dodgy types and banks may have had bad experiences with them. Anyway my post was not about the interest rate as such - I m ok with a 25% rate. I am interested in how the interest is calculated. Leppie gave me a rough idea of how it's done and I did some calculations and it turned out that 25% is actually a decent interest rate for a short term loan. See my reply to Leppie where I've given the full set of calculations.
Nishant Sivakumar wrote: they treat no-credit-history as equivalent to bad-credit-history. I experienced that here in the USA when I was much yonger and had did not have a credit history. However, a few yeras later when I was making $55K per year, it did not matter that I had not credit history, they had over $80K waiting for me for whatever my need in available credit card credit most at 12.5% although the first 6 months would be at 2.5%. This is how they snag people into going in over thier heads. The point here in the USA, is simply, you make enough money, no credit or bad credit does not matter. You make little money and have no credit history, it is the same as having bad credit. Rocky <>< Latest Post: Cool ASP.NET 2.0 feature! Blog: www.RockyMoore.com/TheCoder/[^]
-
I've seen loan companies advertise loan offers for people where they provide an interest rate. I was just wondering how this interest is calculated. Assume I take a loan for $3000 and the interest rate is 25% and that I am planning to pay it back in 4 months (4 installments). Is it going to be :- (1) 25% of 3000 = 750. Thus amount to be repaid is 3000+750 = 3750. So amount per installment = 3750/4 = $937.5 OR (2) 25% of 3000 = 750 for 1 year. So for 4 months it will be 750/3 = 250 (since 4 months is 1/3rd of 1 year) Thus amt to be repaid is now 3000+250 = 3250. Installment amt per month = 3250/4 = $812.5 Could someone tell me if it's (1) or (2) please? Thanks, Nish
Not many loans work like that (at least in the US). They are amortized through a means of paying more interest up first, so that if you don't follow through with the loan, they get as much up front as possible. To really oversimply the issue, it would be like... 3,000 * (.25 / 12) = x ...where 12 is the loan term in months. According to this forumula, you'd pay about 312.50 a month for the loan to pay it off. But, the amounts (principal and interest) are adjusted according to a predetermined amortization table so pay less principal and more interest up front. Running it through one of my calcs I get a month payment of $285.13 I wish to got I'd get some info on amortizaton calcutions though. Most of the stuff I've read has always said "it's too complicated" which is just another way of saying the author doesn't know himself/herself. Jeremy Falcon
-
Here's the excel function: =PMT(0.25/12,4,3000) and that equals 4 payments of -789.46. xacc-ide 0.0.99-preview2 (now with integrated debugger)
Heres a C function that works for all cases
/--------------------------------------------------------------- // Desc: returns payment for amt financed for num payments // Params:apr (percentage rate as whole num),num ( number of payments,amt (amount financed) // returns: the payment per period // requires math.h //--------------------------------------------------------------- double Calc_Payment3(double apr,int num,double amt) { double m1,m2,temp; temp=apr/1200; /* apr/12/100 */ temp+=1; temp=pow(temp,(double)num); m1=temp; temp=1/m1; m2=1-temp; /* base factor */ temp=apr/1200; m1=temp/m2; return(amt*m1); } //---------------------------------------------------------------Richard Suppose you were an idiot... And suppose you were a member of Congress... But I repeat myself. --Mark Twain -- modified at 16:29 Monday 10th October, 2005 -
Thanks Leppie, I used your instructions and got this :- Interest = 25/12 = 2.083333%
3000 750 62.4999900 812.49999
2250 750 46.8749925 796.8749925
1500 750 31.2499950 781.249995
750 750 15.6249975 765.6249975
TOT 156.249975 3156.249975Hey, the interest I pay went down :-) Looks like 25% is not such a bad interest amount after all :-)
Nishant Sivakumar wrote: Looks like 25% is not such a bad interest amount after all :omg: For a loan I would just walk away at 10%. I would expect a reasonable amount to be in the 5-7% range for an unsecured loan, and 4.75-5.75% for a secured loan. Given that it is short term, I would stick it on a credit card - Mine is currently at 15.9%, although I've got an offer in for a balance transfer at 5.9% so I'd transfer it after the month interest free grace.
My: Blog | Photos "Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
-
Not many loans work like that (at least in the US). They are amortized through a means of paying more interest up first, so that if you don't follow through with the loan, they get as much up front as possible. To really oversimply the issue, it would be like... 3,000 * (.25 / 12) = x ...where 12 is the loan term in months. According to this forumula, you'd pay about 312.50 a month for the loan to pay it off. But, the amounts (principal and interest) are adjusted according to a predetermined amortization table so pay less principal and more interest up front. Running it through one of my calcs I get a month payment of $285.13 I wish to got I'd get some info on amortizaton calcutions though. Most of the stuff I've read has always said "it's too complicated" which is just another way of saying the author doesn't know himself/herself. Jeremy Falcon
This is the norm for auto loans and consumer loans - but not home loans etc.. We have to use it from time to time in certain States when figuring insurance payments. Its pretty simple. Here is a link to the process. Its called the Rule of 78's http://www.obre.state.il.us/CONSUMER/Tips/RULEOF78.HTM [^] Richard Suppose you were an idiot... And suppose you were a member of Congress... But I repeat myself. --Mark Twain
-
Heres a C function that works for all cases
/--------------------------------------------------------------- // Desc: returns payment for amt financed for num payments // Params:apr (percentage rate as whole num),num ( number of payments,amt (amount financed) // returns: the payment per period // requires math.h //--------------------------------------------------------------- double Calc_Payment3(double apr,int num,double amt) { double m1,m2,temp; temp=apr/1200; /* apr/12/100 */ temp+=1; temp=pow(temp,(double)num); m1=temp; temp=1/m1; m2=1-temp; /* base factor */ temp=apr/1200; m1=temp/m2; return(amt*m1); } //---------------------------------------------------------------Richard Suppose you were an idiot... And suppose you were a member of Congress... But I repeat myself. --Mark Twain -- modified at 16:29 Monday 10th October, 2005Glad to see you changed the numbers :) I had a real WTF moment reading the email notification ;P xacc-ide 0.0.99-preview2 (now with integrated debugger)
-
Glad to see you changed the numbers :) I had a real WTF moment reading the email notification ;P xacc-ide 0.0.99-preview2 (now with integrated debugger)
I originally posted an obscure method used by one insurance company that I pulled from my lib. Knew it was wrong when I saw the /400 . Richard Suppose you were an idiot... And suppose you were a member of Congress... But I repeat myself. --Mark Twain
-
This is the norm for auto loans and consumer loans - but not home loans etc.. We have to use it from time to time in certain States when figuring insurance payments. Its pretty simple. Here is a link to the process. Its called the Rule of 78's http://www.obre.state.il.us/CONSUMER/Tips/RULEOF78.HTM [^] Richard Suppose you were an idiot... And suppose you were a member of Congress... But I repeat myself. --Mark Twain
Cool, thanks for the link. Jeremy Falcon
-
I've seen loan companies advertise loan offers for people where they provide an interest rate. I was just wondering how this interest is calculated. Assume I take a loan for $3000 and the interest rate is 25% and that I am planning to pay it back in 4 months (4 installments). Is it going to be :- (1) 25% of 3000 = 750. Thus amount to be repaid is 3000+750 = 3750. So amount per installment = 3750/4 = $937.5 OR (2) 25% of 3000 = 750 for 1 year. So for 4 months it will be 750/3 = 250 (since 4 months is 1/3rd of 1 year) Thus amt to be repaid is now 3000+250 = 3250. Installment amt per month = 3250/4 = $812.5 Could someone tell me if it's (1) or (2) please? Thanks, Nish
I used the following program when comparing mortgages: http://www.definitivesolutions.com/aprcalc.htm Personally, I would save up for 4 months and pay cash, no calculations needed and you might get a discount :)