Register to reply 
How to calculate the interest forumulaby Banaticus
Tags: forumula 
Share this thread: 
#1
Dec1411, 03:52 PM

P: 30

1. The problem statement, all variables and given/known data
If you deposit $deposit into a bank account each year and get y% annual interest, the simple formula is [tex]\frac{deposit((1+y)^{years}1)}{y}[/tex] How is this formula calculated? What's going on? Let's look at $50, 6% interest, two years. Maybe I'm supposed to be dropping $50 in just as the first year ends, so I don't build any interest on it the first year. I then build interest on it the second year, then drop in another $50 just as the year ends: [tex]=(0*1.06+50)*1.06+50[/tex] no interest the first year + 50, then interest on that and another 50 =50*1.06+50 =103 That squares with the formula given earlier. So, let's look at three years [tex]=(0*1.06+50)*1.06*1.06+50*1.06+50[/tex] That could be rewritten as [tex]=50x^2+50x+50[/tex] where x is 1+interest and the variable is (years1, years2... 1) That comes to the same answer as the original formula, $159.18, so things are working out. Let's look at 7 years. How does: [tex]50*1.06^6+50*1.06^5+50*1.06^4+50*1.06^3+50*1.06^2+50*1.06+50[/tex] get turned into: [tex]\frac{50(1.06^71)}{.06}[/tex] Let's play around with it. [tex]50(1.06^6+1.06^5+1.06^4+1.06^3+1.06^2+1.06+1)[/tex] So [tex]1.06^6+1.06^5+1.06^4+1.06^3+1.06^2+1.06+1=\frac{1.06^71}{.06}[/tex] right? Maybe if I explicitly state the interest... [tex](1+.06)^6+(1+.06)^5+(1+.06)^4+(1+.06)^3+(1+.06)^2+(1+.06)+1[/tex] [tex](1^6+.06^6)+(1^5+.06^5)+(1^4+.06^4)+(1^3+.06^3)+(1^2+.06^2)+(1+.06)+1[/tex] [tex](1+.06^6)+(1+.06^5)+(1+.06^4)+(1+.06^3)+(1+.06^2)+(1+.06)+1[/tex] [tex]1+.06^6+1+.06^5+1+.06^4+1+.06^3+1+.06^2+1+.06+1[/tex] [tex].06^6+.06^5+.06^4+.06^3+.06^2+.06+7[/tex] This isn't helping, it's not taking me in the direction that I want to go. How does: [tex]50*1.06^6+50*1.06^5+50*1.06^4+50*1.06^3+50*1.06^2+50*1.06+50[/tex] which is 419.6918825 get turned into: [tex]\frac{50(1.06^71)}{.06}[/tex] which is 419.6918825? How is that original equation calculated? 


#2
Dec1411, 05:43 PM

Homework
Sci Advisor
HW Helper
Thanks
P: 12,462

If T(i) is the total after year i:
you start off with D  that would be T(0)=D. after one year you have the original deposit, plus the interest, which is rD, where r=y/100 (since y is a percentage) so in year 1 you have T(1)=(1+r)D year two you have the amount in T(1) plus interest on that: T(2)=(1+r)T(1) = D(1+r)^{2} which would kinda suggest that [itex]T(n)=D(1+r)^n[/itex] The amount of interest that has been earned must be the total in your bank account less the initial deposit: I = T(n)D [tex]I = D \big [ (1+r)^n  1 \big ][/tex] Which would be the usual formula for finding the interest earned after n compounding periods (in this case, annually). This has a similar shape to the formula you are examining. What was that formula supposed to find out, exactly? 


#3
Dec1411, 07:20 PM

Sci Advisor
HW Helper
Thanks
P: 4,956

RGV 


#4
Dec1411, 07:54 PM

Homework
Sci Advisor
HW Helper
Thanks
P: 12,462

How to calculate the interest forumula
Ah thank you  misread  except for [itex]years = n+1[/itex] (the exponent).
But that would match the comment about missing a year's interest I guess. Would also make y the interest rate represented as a fraction rather than as a percentage ... which was puzzling me. Both descriptions are used but I see that it is common to refer to a "percentage" and write a fraction (and call it the decimal form of the percentage). 


#5
Dec1511, 12:10 AM

P: 30

Thanks. I got the original formula from http://www.ajdesigner.com/phpinteres...deposits_p.php and it seems to be the same formula that my teacher was using (he didn't mandated anything, he just suggested that we use massive Excel tables to calculate it, so I went out looking for a multiple payment interest generating formula that gave the same answer that my tables were giving), but I just can't see how it was derived, how it was put together. Well, the formula as presented on that webpage was actually:
[tex]P=M((1+\frac{i}{q})^{nq}1)(\frac{q}{i})[/tex] where q was the number of periods in the year, etc., but since I was working with only one interest generating period (simple annual interest) and only one deposit during that time period, I simplified the formula by putting in 1 for q and then removing it from the equation. 


#6
Dec1511, 10:22 AM

Sci Advisor
HW Helper
Thanks
P: 4,956

RGV 


#7
Dec1511, 11:33 AM

P: 30




#8
Dec1511, 06:19 PM

Homework
Sci Advisor
HW Helper
Thanks
P: 12,462

let [itex]s=x+x^2+\ldots +x^{n1}+x^n[/itex]
then [itex]xs=x^2+x^3+\ldots + x^n + x^{n+1}[/itex] then [itex]xss = x^{n+1}x[/itex] or: [tex]s=\frac{x^{n+1}x}{x1}[/tex] hmmm ... did I miss something again? (That extra factor of x would be the interest in the (n+1)th year, so it doesn't count?) anyway: think "geometric series". 


Register to reply 
Related Discussions  
What is a quadratic forumula  Introductory Physics Homework  7  
Forumula pressure = f(height)  General Physics  2  
Momentum forumula questions  Introductory Physics Homework  5  
Rearranging forumula  Introductory Physics Homework  4  
Interpolation forumula  General Math  2 