You can use the Future Value FV function
Things to note:
Your interest rate must match your "periods" (years, months, etc)
Use negative values for money leaving you, positive for money coming in.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Rene" wrote in message
...
What is the function I use for showing me how much a fixed 6% annually
will
yield over the years. For instance, on $100,000 the first year would
yield
$106,000, the second year, how much, the fifth year, tenth, etc.
--
Rene - Do appreciate your help. I have had simply the best help with
these
groups, and it's where I turn to for serious help.