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
can I edit the sum function in VB to do this? Please help.
If you need more info please ask I will supply it.

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.
>If you need more info please ask I will supply it.

>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
> can I edit the sum function in VB to do this? Please help.
> If you need more info please ask I will supply it.

> 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
> can I edit the sum function in VB to do this? Please help.
> If you need more info please ask I will supply it.

> Thank you thank you thank you.



Mon, 13 Dec 2004 18:06:11 GMT  
 
 [ 6 post ] 

 Relevant Pages 

1. Compound Interest Function -- need help

2. Compound Interest Function -- help needed

3. Interest Compounding Scenario

4. MS Access Creating a field to computate compound interest

5. Compounding of Interest

6. calculate compounded interest

7. Compound IF not working in Access97???

8. Compound properties?

9. compound conditionals in VB queries

10. OLE, Fichiers Compound and Office

11. Help: Creating a compound file.

12. Compound file implementation

 

 
Powered by phpBB® Forum Software