How to calculate the interest forumula

  • Thread starter Thread starter Banaticus
  • Start date Start date
  • Tags Tags
    Interest
AI Thread Summary
The discussion focuses on understanding the formula for calculating interest on annual deposits in a bank account. The formula presented, \frac{deposit((1+y)^{years}-1)}{y}, is derived from the concept of geometric series, where each deposit earns interest over the years. Participants explore specific examples, such as depositing $50 at a 6% interest rate over multiple years, and confirm that the calculations align with the formula. Confusion arises regarding the derivation of the formula and the relationship between different representations of interest calculations. Ultimately, the conversation emphasizes the importance of understanding how the formula is constructed and applied in practical scenarios.
Banaticus
Messages
32
Reaction score
0

Homework Statement


If you deposit $deposit into a bank account each year and get y% annual interest, the simple formula is
\frac{deposit((1+y)^{years}-1)}{y}
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:
=(0*1.06+50)*1.06+50 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
=(0*1.06+50)*1.06*1.06+50*1.06+50
That could be rewritten as
=50x^2+50x+50 where x is 1+interest and the variable is (years-1, years-2... 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:
50*1.06^6+50*1.06^5+50*1.06^4+50*1.06^3+50*1.06^2+50*1.06+50
get turned into:
\frac{50(1.06^7-1)}{.06}

Let's play around with it.
50(1.06^6+1.06^5+1.06^4+1.06^3+1.06^2+1.06+1)
So
1.06^6+1.06^5+1.06^4+1.06^3+1.06^2+1.06+1=\frac{1.06^7-1}{.06}
right? Maybe if I explicitly state the interest...
(1+.06)^6+(1+.06)^5+(1+.06)^4+(1+.06)^3+(1+.06)^2+(1+.06)+1
(1^6+.06^6)+(1^5+.06^5)+(1^4+.06^4)+(1^3+.06^3)+(1^2+.06^2)+(1+.06)+1
(1+.06^6)+(1+.06^5)+(1+.06^4)+(1+.06^3)+(1+.06^2)+(1+.06)+1
1+.06^6+1+.06^5+1+.06^4+1+.06^3+1+.06^2+1+.06+1
.06^6+.06^5+.06^4+.06^3+.06^2+.06+7
This isn't helping, it's not taking me in the direction that I want to go. How does:
50*1.06^6+50*1.06^5+50*1.06^4+50*1.06^3+50*1.06^2+50*1.06+50
which is 419.6918825 get turned into:
\frac{50(1.06^7-1)}{.06}
which is 419.6918825? How is that original equation calculated?
 
Physics news on Phys.org
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 T(n)=D(1+r)^n

The amount of interest that has been earned must be the total in your bank account less the initial deposit: I = T(n)-D

I = D \big [ (1+r)^n - 1 \big ]

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?
 
Last edited:
Simon Bridge said:
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 T(n)=D(1+r)^n

The amount of interest that has been earned must be the total in your bank account less the initial deposit: I = T(n)-D

I = D \big [ (1+r)^n - 1 \big ]

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?

According to the description given by the OP, D gets deposited each year, so at the end of year 2 the account contains T(2) = D(1+r) + D(1+r)^2, etc. This leads to T(n) = D(x + x^2 + ... + x^n) = D\frac{x^{n+1}-1}{x-1}, where x = r+1. The value of T(n-1) [= amount at start of year n] would match the formula given by the OP.

RGV
 
Ah thank you - misread - except for years = n+1 (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).
 
Thanks. I got the original formula from http://www.ajdesigner.com/phpinterest/interest_regular_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:
P=M((1+\frac{i}{q})^{nq}-1)(\frac{q}{i}) 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.
Ray Vickson said:
This leads to T(n) = D(x + x^2 + ... + x^n) = D\frac{x^{n+1}-1}{x-1}, where x = r+1. The value of T(n-1) [= amount at start of year n] would match the formula given by the OP.
Thanks. :) I don't see how the second formula was calculated from the first though.
 
Banaticus said:
Thanks. I got the original formula from http://www.ajdesigner.com/phpinterest/interest_regular_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:
P=M((1+\frac{i}{q})^{nq}-1)(\frac{q}{i}) 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.

Thanks. :) I don't see how the second formula was calculated from the first though.

I don't know what your "second" and "first" refer to, since you cite several posts, each having some formulas.

RGV
 
Ray Vickson said:
I don't know what your "second" and "first" refer to
They refer to the portion of your post quoted immediately above the words "second" and "first" in the post you quoted. The inability of this forum to display a quote in a quoted post can swiftly become confusing, so let me just repost it:
Ray Vickson said:
D(x + x^2 + ... + x^n) = D\frac{x^{n+1}-1}{x-1},
Where does the x^{n+1}-1, etc., come from, how was that formula generated?
 
let s=x+x^2+\ldots +x^{n-1}+x^n

then xs=x^2+x^3+\ldots + x^n + x^{n+1}

then xs-s = x^{n+1}-x or:

s=\frac{x^{n+1}-x}{x-1}

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".
 
Last edited:
Back
Top