+ Show Spoiler [Data] +
Here is the code for the "New Balance" cells: =D2*(1+$H$1/12)
As I dragged the code down to each additional cell the D2 stepped to D3, D4, etc. H1 is the cell which has the interest rate of 0.0499.
Blogs > micronesia |
micronesia
United States24513 Posts
+ Show Spoiler [Data] + Here is the code for the "New Balance" cells: =D2*(1+$H$1/12) As I dragged the code down to each additional cell the D2 stepped to D3, D4, etc. H1 is the cell which has the interest rate of 0.0499. | ||
Cauld
United States350 Posts
So for your first payment: 0.0499/12 ~ 0.00416 + 1 = 1.00416 1.00416*20,000 = 20083.17 So your interest is compounded monthly and your payment is setup to pay off the loan in the desired time frame. There's no front loading the interest, the interest is based on the principle which naturally decreases over time. | ||
micronesia
United States24513 Posts
On April 22 2011 08:00 Cauld wrote: I don't think interest is calculated in any crazy way. Take the principle and multiply by 1 + the percentage rate divided by the number of payments/year. That's your new principle. So for your first payment: 0.0499/12 ~ 0.00416 + 1 = 1.00416 1.00416*20,000 = 20083.17 So your interest is compounded monthly and your payment is setup to pay off the loan in the desired time frame. There's no front loading the interest, the interest is based on the principle which naturally decreases over time. I believe when my loan started my payoff amount was significantly higher than my 20k balance plus my first payment, thus, front loaded interest. edit: can't you also see it clearly in the first graph? That information was given to me directly. | ||
eNtitY~
United States1293 Posts
| ||
micronesia
United States24513 Posts
On April 22 2011 08:05 eNtitY~ wrote: Weird, I also got a $20,000 Car loan in 2008. I think I'm paying much more than $2653 in interest though :/ Do you know your interest rate? I cosigned with my dad and agreed for automatic payments from my checking account so I got a pretty good rate for the time (summer 2k8). | ||
Cauld
United States350 Posts
On April 22 2011 08:02 micronesia wrote: Show nested quote + On April 22 2011 08:00 Cauld wrote: I don't think interest is calculated in any crazy way. Take the principle and multiply by 1 + the percentage rate divided by the number of payments/year. That's your new principle. So for your first payment: 0.0499/12 ~ 0.00416 + 1 = 1.00416 1.00416*20,000 = 20083.17 So your interest is compounded monthly and your payment is setup to pay off the loan in the desired time frame. There's no front loading the interest, the interest is based on the principle which naturally decreases over time. I believe when my loan started my payoff amount was significantly higher than my 20k balance plus my first payment, thus, front loaded interest. edit: can't you also see it clearly in the first graph? That information was given to me directly. No. The interest is based on the principle. So as you make payments and the principle decreases, so does the interest amount. Since your payment is staying the same and is greater than the monthly interest the additional payment is applied to the principle. The next month the principle is smaller, so the interest amount also smaller, etc. Your payment amount is setup so that the remaining principle after the desired number of payments is 0. But, its possible to have a loan where you only pay interest, and principle increases each month (your payment would have to be less than the monthly interest). After a given amount of time your payment increases and then you begin to pay down the principle. Just do a couple of the monthly calculations and you'll see how it goes. They can tell you that over the course of the loan how much you will end up paying. But there's nothing stopping you from paying off the balance at any point and not paying any remaining interest (except for a clause in your contract that may forbid, or have a penalty, for early repayment). What you're looking at is even more pronounced in the case of a 30-year mortgage. That's just how paying off a loan works. I guess if you wanted to call it front loaded interest you could, but I don't think that's an accurate description of the situation. In my mind front loaded interest would be something where your rate is %10 for the first 2 years and then drops to 2%. | ||
eNtitY~
United States1293 Posts
On April 22 2011 08:08 micronesia wrote: Show nested quote + On April 22 2011 08:05 eNtitY~ wrote: Weird, I also got a $20,000 Car loan in 2008. I think I'm paying much more than $2653 in interest though :/ Do you know your interest rate? I cosigned with my dad and agreed for automatic payments from my checking account so I got a pretty good rate for the time (summer 2k8). Yeah just checked, it's 9.4 and I've already paid $4000 in interest . I'll end up paying ~$10k in interest before it's done. I also co-signed with my dad (Very high 700s CS) but didn't do automatic payments and also had a 72 month contract. | ||
Ryps
Romania2740 Posts
Looks like its a mazda hatchback ? | ||
Myles
United States5162 Posts
On April 22 2011 08:08 micronesia wrote: Show nested quote + On April 22 2011 08:05 eNtitY~ wrote: Weird, I also got a $20,000 Car loan in 2008. I think I'm paying much more than $2653 in interest though :/ Do you know your interest rate? I cosigned with my dad and agreed for automatic payments from my checking account so I got a pretty good rate for the time (summer 2k8). Yea, you got 3.3% lower rate than I did when I co-signed with my dad for a 17k loan in '07. Of course, now that I'm older/wiser I feel I could have got a better deal, but that's life. | ||
eNtitY~
United States1293 Posts
| ||
tofucake
Hyrule18947 Posts
As for the payment, you're close. It's actually Where r is the periodic interest rate. For calculating payments, it'll be daily. The reason your interest decreases over time is because at the start of the loan, you have a higher principal balance (P above). The actual payment (assuming Simple Interest here) is: Fees = Total amount paid minus any fee balance (late fees, typically) Interest = Current principal balance times the periodic interest rate (APR / 365) times the number of days since last payment plus any outstanding interest due Principal is the rest On an Actuarial loan, that 365 could be 360, 363, or 365. On a Rule of 78s loan you're getting totally shafted in every way possible (Ro78s is illegal in 17 states because of it's terribadness) What this means is that, as long as you don't have a Rule of 78s loan, paying early and overpaying will reduce overall how much you pay. This may seem counter intuitive (wtf pay more = pay less?) but the financing company (or bank) gets all of its profit off of the interest. By overpaying you prematurely reduce the principal balance, so if you paid $400 every month instead of $377.56 you'd end up paying off the loan a couple months early, which reduces the number of days calculated for how much interest is due (so you don't pay that interest at all). By paying early, you're cutting short the number of days interest is calculated on as well. For example, if you payed May 1st, you'd put $40.84, but if you pay a day earlier $39.48. So that's another $1.36 that goes directly to principal, which will reduce how much you pay next month. | ||
tofucake
Hyrule18947 Posts
On April 22 2011 08:11 Cauld wrote: Principal never ever ever increases by anything other than a bounced check. EVERShow nested quote + On April 22 2011 08:02 micronesia wrote: On April 22 2011 08:00 Cauld wrote: I don't think interest is calculated in any crazy way. Take the principle and multiply by 1 + the percentage rate divided by the number of payments/year. That's your new principle. So for your first payment: 0.0499/12 ~ 0.00416 + 1 = 1.00416 1.00416*20,000 = 20083.17 So your interest is compounded monthly and your payment is setup to pay off the loan in the desired time frame. There's no front loading the interest, the interest is based on the principle which naturally decreases over time. I believe when my loan started my payoff amount was significantly higher than my 20k balance plus my first payment, thus, front loaded interest. edit: can't you also see it clearly in the first graph? That information was given to me directly. No. The interest is based on the principle. So as you make payments and the principle decreases, so does the interest amount. Since your payment is staying the same and is greater than the monthly interest the additional payment is applied to the principle. The next month the principle is smaller, so the interest amount also smaller, etc. Your payment amount is setup so that the remaining principle after the desired number of payments is 0. But, its possible to have a loan where you only pay interest, and principle increases each month (your payment would have to be less than the monthly interest). After a given amount of time your payment increases and then you begin to pay down the principle. Just do a couple of the monthly calculations and you'll see how it goes. They can tell you that over the course of the loan how much you will end up paying. But there's nothing stopping you from paying off the balance at any point and not paying any remaining interest (except for a clause in your contract that may forbid, or have a penalty, for early repayment). What you're looking at is even more pronounced in the case of a 30-year mortgage. That's just how paying off a loan works. I guess if you wanted to call it front loaded interest you could, but I don't think that's an accurate description of the situation. In my mind front loaded interest would be something where your rate is %10 for the first 2 years and then drops to 2%. | ||
Michaelj
United States186 Posts
Example: $20,000 loan 1% interest $300 monthly payment Period 1: $20,000 remaining principal, $200 interest payment, $100 principal payment Period 2: $19,900 remaining principal, $199 interest payment, $101 principal payment Period 3: $19,799 remaining principal, $198 interest payment, $102 principal payment So you see it's pretty clear that you are just paying the interest on the principal that you currently have outstanding. The car companies have just adjusted your monthly payment amount such that you pay an even amount every month, and everything takes care of itself neatly by the time you 5 years are up. TLDR: The suggested payment amount presumes you take the full 5 years to pay. If you have $15k in principal left, and want to pay if off in full today, you can and not pay a dime of extra interest | ||
Michaelj
United States186 Posts
On April 22 2011 08:25 tofucake wrote: Show nested quote + Principal never ever ever increases by anything other than a bounced check. EVEROn April 22 2011 08:11 Cauld wrote: On April 22 2011 08:02 micronesia wrote: On April 22 2011 08:00 Cauld wrote: I don't think interest is calculated in any crazy way. Take the principle and multiply by 1 + the percentage rate divided by the number of payments/year. That's your new principle. So for your first payment: 0.0499/12 ~ 0.00416 + 1 = 1.00416 1.00416*20,000 = 20083.17 So your interest is compounded monthly and your payment is setup to pay off the loan in the desired time frame. There's no front loading the interest, the interest is based on the principle which naturally decreases over time. I believe when my loan started my payoff amount was significantly higher than my 20k balance plus my first payment, thus, front loaded interest. edit: can't you also see it clearly in the first graph? That information was given to me directly. No. The interest is based on the principle. So as you make payments and the principle decreases, so does the interest amount. Since your payment is staying the same and is greater than the monthly interest the additional payment is applied to the principle. The next month the principle is smaller, so the interest amount also smaller, etc. Your payment amount is setup so that the remaining principle after the desired number of payments is 0. But, its possible to have a loan where you only pay interest, and principle increases each month (your payment would have to be less than the monthly interest). After a given amount of time your payment increases and then you begin to pay down the principle. Just do a couple of the monthly calculations and you'll see how it goes. They can tell you that over the course of the loan how much you will end up paying. But there's nothing stopping you from paying off the balance at any point and not paying any remaining interest (except for a clause in your contract that may forbid, or have a penalty, for early repayment). What you're looking at is even more pronounced in the case of a 30-year mortgage. That's just how paying off a loan works. I guess if you wanted to call it front loaded interest you could, but I don't think that's an accurate description of the situation. In my mind front loaded interest would be something where your rate is %10 for the first 2 years and then drops to 2%. You'd be surprised... in the housing boom people would get negative amortization loans that meant they would pay LESS than interest. They'd try to flip the house as soon as they could. http://en.wikipedia.org/wiki/Negative_amortization | ||
micronesia
United States24513 Posts
On April 22 2011 08:11 Cauld wrote: Show nested quote + On April 22 2011 08:02 micronesia wrote: On April 22 2011 08:00 Cauld wrote: I don't think interest is calculated in any crazy way. Take the principle and multiply by 1 + the percentage rate divided by the number of payments/year. That's your new principle. So for your first payment: 0.0499/12 ~ 0.00416 + 1 = 1.00416 1.00416*20,000 = 20083.17 So your interest is compounded monthly and your payment is setup to pay off the loan in the desired time frame. There's no front loading the interest, the interest is based on the principle which naturally decreases over time. I believe when my loan started my payoff amount was significantly higher than my 20k balance plus my first payment, thus, front loaded interest. edit: can't you also see it clearly in the first graph? That information was given to me directly. No. The interest is based on the principle. So as you make payments and the principle decreases, so does the interest amount. Since your payment is staying the same and is greater than the monthly interest the additional payment is applied to the principle. The next month the principle is smaller, so the interest amount also smaller, etc. Your payment amount is setup so that the remaining principle after the desired number of payments is 0. But, its possible to have a loan where you only pay interest, and principle increases each month (your payment would have to be less than the monthly interest). After a given amount of time your payment increases and then you begin to pay down the principle. Just do a couple of the monthly calculations and you'll see how it goes. They can tell you that over the course of the loan how much you will end up paying. But there's nothing stopping you from paying off the balance at any point and not paying any remaining interest (except for a clause in your contract that may forbid, or have a penalty, for early repayment). What you're looking at is even more pronounced in the case of a 30-year mortgage. That's just how paying off a loan works. I guess if you wanted to call it front loaded interest you could, but I don't think that's an accurate description of the situation. In my mind front loaded interest would be something where your rate is %10 for the first 2 years and then drops to 2%. If you are right (and what you said makes sense) then my payoff amount at the end of the first month would have just been the 20,083 dollars... I might be remembering incorrectly but I am pretty sure that's not what it was. If it WAS then it works exactly how my 'high school math class' explained and is consistent with your explanation. Do you know why they inform me in my loan information how much of my payment went to interest and how much went to principal? Was it just to show how much interest I accrued that prior month? And I guess also to show how much I knocked down the principal that month? | ||
micronesia
United States24513 Posts
On April 22 2011 08:24 tofucake wrote: Your last payment is off because that's how it works out. Your last payment due will only be for the remaining principal, as you'll have paid off the interest on the 59th payment. As for the payment, you're close. It's actually Where r is the periodic interest rate. For calculating payments, it'll be daily. The reason your interest decreases over time is because at the start of the loan, you have a higher principal balance (P above). The actual payment (assuming Simple Interest here) is: Fees = Total amount paid minus any fee balance (late fees, typically) Interest = Current principal balance times the periodic interest rate (APR / 365) times the number of days since last payment plus any outstanding interest due Principal is the rest On an Actuarial loan, that 365 could be 360, 363, or 365. On a Rule of 78s loan you're getting totally shafted in every way possible (Ro78s is illegal in 17 states because of it's terribadness) What this means is that, as long as you don't have a Rule of 78s loan, paying early and overpaying will reduce overall how much you pay. This may seem counter intuitive (wtf pay more = pay less?) but the financing company (or bank) gets all of its profit off of the interest. By overpaying you prematurely reduce the principal balance, so if you paid $400 every month instead of $377.56 you'd end up paying off the loan a couple months early, which reduces the number of days calculated for how much interest is due (so you don't pay that interest at all). By paying early, you're cutting short the number of days interest is calculated on as well. For example, if you payed May 1st, you'd put $40.84, but if you pay a day earlier $39.48. So that's another $1.36 that goes directly to principal, which will reduce how much you pay next month. Oh okay I should have realized that it compounds daily instead of monthly... well I guess that information wasn't given to me directly so I can't blame myself for not knowing :p And I guess from what I'm reading the type of 'front loading' I am thinking of would only happen with special conditions in the agreement. On April 22 2011 08:26 Michaelj wrote: They're not "front-loading" the interest. They do calculate your payments such that you can 60 equal payments. But if your loan agreement allows you to prepay your loan, you would find that you could just pay for the remaining principal, and not pay any of the extra interest. Example: $20,000 loan 1% interest $300 monthly payment Period 1: $20,000 remaining principal, $200 interest payment, $100 principal payment Period 2: $19,900 remaining principal, $199 interest payment, $101 principal payment Period 3: $19,799 remaining principal, $198 interest payment, $102 principal payment So you see it's pretty clear that you are just paying the interest on the principal that you currently have outstanding. The car companies have just adjusted your monthly payment amount such that you pay an even amount every month, and everything takes care of itself neatly by the time you 5 years are up. TLDR: The suggested payment amount presumes you take the full 5 years to pay. If you have $15k in principal left, and want to pay if off in full today, you can and not pay a dime of extra interest I hope you are right and that's how my loan is working because that's better for us! | ||
tofucake
Hyrule18947 Posts
On April 22 2011 08:28 Michaelj wrote: Show nested quote + On April 22 2011 08:25 tofucake wrote: On April 22 2011 08:11 Cauld wrote: Principal never ever ever increases by anything other than a bounced check. EVEROn April 22 2011 08:02 micronesia wrote: On April 22 2011 08:00 Cauld wrote: I don't think interest is calculated in any crazy way. Take the principle and multiply by 1 + the percentage rate divided by the number of payments/year. That's your new principle. So for your first payment: 0.0499/12 ~ 0.00416 + 1 = 1.00416 1.00416*20,000 = 20083.17 So your interest is compounded monthly and your payment is setup to pay off the loan in the desired time frame. There's no front loading the interest, the interest is based on the principle which naturally decreases over time. I believe when my loan started my payoff amount was significantly higher than my 20k balance plus my first payment, thus, front loaded interest. edit: can't you also see it clearly in the first graph? That information was given to me directly. No. The interest is based on the principle. So as you make payments and the principle decreases, so does the interest amount. Since your payment is staying the same and is greater than the monthly interest the additional payment is applied to the principle. The next month the principle is smaller, so the interest amount also smaller, etc. Your payment amount is setup so that the remaining principle after the desired number of payments is 0. But, its possible to have a loan where you only pay interest, and principle increases each month (your payment would have to be less than the monthly interest). After a given amount of time your payment increases and then you begin to pay down the principle. Just do a couple of the monthly calculations and you'll see how it goes. They can tell you that over the course of the loan how much you will end up paying. But there's nothing stopping you from paying off the balance at any point and not paying any remaining interest (except for a clause in your contract that may forbid, or have a penalty, for early repayment). What you're looking at is even more pronounced in the case of a 30-year mortgage. That's just how paying off a loan works. I guess if you wanted to call it front loaded interest you could, but I don't think that's an accurate description of the situation. In my mind front loaded interest would be something where your rate is %10 for the first 2 years and then drops to 2%. You'd be surprised... in the housing boom people would get negative amortization loans that meant they would pay LESS than interest. They'd try to flip the house as soon as they could. http://en.wikipedia.org/wiki/Negative_amortization Yes but those were sub-prime house loans, not car loans. Please trust me. This is literally what I do for a living. | ||
Cauld
United States350 Posts
| ||
a176
Canada6688 Posts
On April 22 2011 08:14 eNtitY~ wrote: Show nested quote + On April 22 2011 08:08 micronesia wrote: On April 22 2011 08:05 eNtitY~ wrote: Weird, I also got a $20,000 Car loan in 2008. I think I'm paying much more than $2653 in interest though :/ Do you know your interest rate? I cosigned with my dad and agreed for automatic payments from my checking account so I got a pretty good rate for the time (summer 2k8). Yeah just checked, it's 9.4 and I've already paid $4000 in interest . I'll end up paying ~$10k in interest before it's done. I also co-signed with my dad (Very high 700s CS) but didn't do automatic payments and also had a 72 month contract. why in the world would you agree to an-almost 10% interest rate, completely ridiculous | ||
eNtitY~
United States1293 Posts
On April 22 2011 09:01 a176 wrote: Show nested quote + On April 22 2011 08:14 eNtitY~ wrote: On April 22 2011 08:08 micronesia wrote: On April 22 2011 08:05 eNtitY~ wrote: Weird, I also got a $20,000 Car loan in 2008. I think I'm paying much more than $2653 in interest though :/ Do you know your interest rate? I cosigned with my dad and agreed for automatic payments from my checking account so I got a pretty good rate for the time (summer 2k8). Yeah just checked, it's 9.4 and I've already paid $4000 in interest . I'll end up paying ~$10k in interest before it's done. I also co-signed with my dad (Very high 700s CS) but didn't do automatic payments and also had a 72 month contract. why in the world would you agree to an-almost 10% interest rate, completely ridiculous Well.... And being 20. Man that was retarded. Can you refinance auto loans if your car is worth more than the balance? | ||
| ||
Next event in 4m
[ Submit Event ] |
StarCraft 2 StarCraft: Brood War Flash 7654 League of LegendsJYJ165 TY 109 sorry 46 NaDa 24 Trikslyr23 NotJumperer 18 IntoTheRainbow 10 Hm[arnc] 6 hero 3 Counter-Strike Super Smash Bros Other Games WinterStarcraft455 Skadoodle307 XaKoH 227 Fuzer 117 monkeys_forever98 Hui .92 UpATreeSC58 Dewaltoss25 Organizations Other Games StarCraft 2 Other Games StarCraft 2 StarCraft: Brood War
StarCraft 2 • LUISG 19 StarCraft: Brood War• AfreecaTV YouTube • intothetv • Kozan • IndyKCrew • LaughNgamezSOOP • Laughngamez YouTube • Migwel • sooper7s League of Legends |
H.4.0.S
Master's Coliseum
herO vs MaxPax
Serral vs Reynor
Chat StarLeague
SOOP Global
ByuN vs Zoun
Dark vs herO
Replay Cast
SOOP
NightMare vs Rogue
Master's Coliseum
OSC
Chat StarLeague
HupCup
[ Show More ] Replay Cast
OlimoLeague
LiuLi Cup
Dark vs MaxPax
Reynor vs Serral
herO vs GuMiho
Clem vs SKillous
Replay Cast
LiuLi Cup
OSC
Tenacious Turtle Tussle
The PondCast
LiuLi Cup
OSC
LiuLi Cup
Korean StarCraft League
|
|