Hi all,
This is my first post...
I have a problem for which I need help.
I have a bunch of different different payments for 500 people. They all end their payments in a different period, e.g. period 14 or 50, and I have a total of 360 periods. Besides this each period has a different interest rate, which will be added to their payments.
One simple example of my problem (with three periods):
Person 1 has an initial saving of 500 and will paid an additional 10 in the first period, 15 in the second period and 11 in the third period.
Person 2 has an initial saving of 300 and will paid an additional 19 in the first period, 24 in the second period and 15 in the third period.
The interest rate for period 1 is 1%, period 2 is 3 % and period 3 is 5%.
So the calculation for person 1 in this example would be: (((500+10)*(1+0,01)+15)*(1+0,03)+11)*(1+0,05)
Is there a way I can do this in VBA, since I have 360 periods, 500 individuals and 1000 scenarios in which the interest rate is calculated.
It is crutial for me to solve this - please help!
/Chris
This is my first post...
I have a problem for which I need help.
I have a bunch of different different payments for 500 people. They all end their payments in a different period, e.g. period 14 or 50, and I have a total of 360 periods. Besides this each period has a different interest rate, which will be added to their payments.
One simple example of my problem (with three periods):
Person 1 has an initial saving of 500 and will paid an additional 10 in the first period, 15 in the second period and 11 in the third period.
Person 2 has an initial saving of 300 and will paid an additional 19 in the first period, 24 in the second period and 15 in the third period.
The interest rate for period 1 is 1%, period 2 is 3 % and period 3 is 5%.
So the calculation for person 1 in this example would be: (((500+10)*(1+0,01)+15)*(1+0,03)+11)*(1+0,05)
Is there a way I can do this in VBA, since I have 360 periods, 500 individuals and 1000 scenarios in which the interest rate is calculated.
It is crutial for me to solve this - please help!
/Chris
