LinkBack URL
About LinkBacksDear All, could you help me to solve following?
I need to know, how much i is and how to calculate it.
Thanks milion times
Originally Posted by Eske939
Dear All, could you help me to solve following?
I need to know, how much i is and how to calculate it.
Thanks milion times
Sum of geometric sequence:, and here:
![\sum^{60}_{n=1}\left(\frac{1}{1+i}\right)^n=\sum^{ 60}_{n=1}\left(\frac{1-i}{2}\right)^n=\frac{\frac{1-i}{2}\left[\left(\frac{1-i}{2}\right)^{61}-1\right]}{\frac{1-i}{2}-1}](http://latex.codecogs.com/png.latex?\sum^{60}_{n=1}\left(\frac{1}{1+i}\right)^n=\sum^{ 60}_{n=1}\left(\frac{1-i}{2}\right)^n=\frac{\frac{1-i}{2}\left[\left(\frac{1-i}{2}\right)^{61}-1\right]}{\frac{1-i}{2}-1})
...--- Since
and
, we get ---...:
^{31}}{2^{61}}-1+i}{1+i}=)
...
By the way, check your indexes...
Tonio
Hello Tonio,
thank you very much for your help. But to be honest, I know nothing from math, I need to calculate this for loan purposes. Is there any change you continue in it and get me something like: i=..... so I can input it into excel and have the number?
Or let me know how to calculate this in excel?
Thank you in advance.
Eske
Too bad you didn't say the first time you don't know anything about maths: I would have saved myself a lot of trouble and time...
Anyway, if you want this for loan purposes then we will need more information: how come that complex unit i got there, say....or perhaps it is another thing altogether since I know of any use of complex numbers to calculate loans interests and stuff.
Tonio
I suspect the "i" is an interest rate. Although I am still confused as to how he has an index of "n" on the sum and "k" inside. I believe he meant
.
That is, as Tonio says, as geometric sequence and its sum is
^{-61}}{1-\frac{1}{1+i}})
^{-61}}{\frac{i}{1+i}})
.
You still have thatbut I suspect that you don't need dozens of decimal place and can take
to be approximately 1- 61(1+ i) so that (1- (1+i)^{-61}) is approximately 61(1+ i) and the whole thing is
. that will give you
or
, a quadratic equation for i. Solve it using the quadratic formula.
And, by the way, this was titled "infinite series". 60 is hardly infinite!
Dear All, could you help me to solve following?
I need to know, how much i is and how to calculate it.
Thanks milion times60 times is just
so, assuming the sum should be from k=1 to 60
and for convenience letting x=1+i, solving for x,
when finally i=x-1
is a geometric series and equals
Solving this graphically, using root-finding software, we get
}-3,955=0)
for x=0.907783 approximately.
Slight variations in x yield quite different results.
This gives i=x-1=0.907783-1=-0.092217
If the sum of the series is 39.55 rather than 3,955,
this yields x=1.0143, so i=0.0143 approximately.
  |
