On 2002-08-26 12:20, cptkoble wrote:

Hi Dave,

> Do you make weekly, monthly, annual or no deposits?

It will be an annual deposit.

>Are the amounts deposited equal?

Yes

Do you assume a constant rate of interest?

Yes, and that is just what I would like to get out of this sheet. I want to play a little with the amount in let's say 25 or 30 years, combined with the yearly deposit. The %-rate required to achieve my goal, and to be calculated, is at this time still the problem.

Thanx

---------------------------------------------

Hi Ricardo

I tried your formula but it won't give the correct answer. Sorry.

Based upon the known 8% intrest (example)

The first year 1-1-03 I deposit 100, on 1-1-04 I will have 100*1,08^1. This to be added up with the next deposit will make the total 208. The year following the fun really start. Based on the deposit on the 1st of 2002 it will give me 100*1,08^2 added up with the 100*1,08^1 for the deposit from the last year and then to be added up with the new deposit of 100.

You can imagine it is not too difficult to create this in a sheet up to 30 years given the % to calculate the total future value.

Problem is though to calculate this % when given the total future value, the yearly deposit and the amount of years to follow your savings.

Thanx