Calculating Based on A Percentage

S

Stan

I have a field with a dollor value of $10.00 I would like
to increase this number by 10% for five years. The
resultant should include the prior years % percentage
increase.

Example:

year 1 $10.00 * 10% = $11.00
year 2 $11.00 * 10% = $12.10
year 3 $12.10 * 10% = $13.31
year 4 $13.31 * 10% = $14.64
year 5 $14.64 * 10% = $16.10

I know there must be a function to this, does anyone have
it.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top