Function(Compounding interest )
Author Message
Function(Compounding interest )

I need help.  I want to run a report in Access and get a
cumulative interst rate.  e.g.first record, date: 1/1/02
interest: 5%,next record date:2/1/02 interest:6%, next
record date:3/1/01 interest:7%.  after a report the
cumulative interest rate would be : (1+5%)*(1*6%)+(1+7%)-
1=19.091%.  Is there a function for this, If not then how

Thank you thank you thank you.

Sun, 12 Dec 2004 06:03:25 GMT
Function(Compounding interest )
Given the criteria you'll have to create your own
function.  It's both fun and educational.  The first step
is to get the formula right.  The formula you have does
not consider time, it's therefore useless.  Come back with
a formula and I'll put it to code.  Even if it IS a
homework assignment :)

Quote:
>-----Original Message-----
>I need help.  I want to run a report in Access and get a
>cumulative interst rate.  e.g.first record, date: 1/1/02
>interest: 5%,next record date:2/1/02 interest:6%, next
>record date:3/1/01 interest:7%.  after a report the
>cumulative interest rate would be : (1+5%)*(1*6%)+(1+7%)-
>1=19.091%.  Is there a function for this, If not then how
>can I edit the sum function in VB to do this? Please
help.

>Thank you thank you thank you.
>.

Sun, 12 Dec 2004 07:20:15 GMT
Function(Compounding interest )
You could try an expression along the lines of:

Sum(Exp(Log(1+[interest])))-1

since mathematically speaking:

x * y = Exp(Log(x) + Log(y))

provided x and y are > 0.

Quote:
> I need help.  I want to run a report in Access and get a
> cumulative interst rate.  e.g.first record, date: 1/1/02
> interest: 5%,next record date:2/1/02 interest:6%, next
> record date:3/1/01 interest:7%.  after a report the
> cumulative interest rate would be : (1+5%)*(1*6%)+(1+7%)-
> 1=19.091%.  Is there a function for this, If not then how

> Thank you thank you thank you.

Sun, 12 Dec 2004 21:12:14 GMT
Function(Compounding interest )
Hello jmangoubi.
You can not alter the sum function, but you can use it: the logarithm of a
product is equal to the sum of the logarithms. So use the following
expression:
=Exp(Sum(Log(1 + [interest])))-1

Regards,
Wolfgang

Quote:
> I need help.  I want to run a report in Access and get a
> cumulative interst rate.  e.g.first record, date: 1/1/02
> interest: 5%,next record date:2/1/02 interest:6%, next
> record date:3/1/01 interest:7%.  after a report the
> cumulative interest rate would be : (1+5%)*(1*6%)+(1+7%)-
> 1=19.091%.  Is there a function for this, If not then how