Calculate future return value in excel

[webmax]

Hi
I have a data which consist of current value 10000 increase values ie 10% . years 5 years.
If the current value is 10000 if there is 10% increase everyone years what is the value after 5 years.

I need excel formula for this

Thanks
Webmax

[avk]

"A2" is 10000 "B2" is percentage 10
"C2"

Please Login or Register  to view this content.

First year 11000
"A3" is 11000 "B3" 10 same formula as above upto 5 years

[webmax]

Hi,

I need the formula in that i want to know after 5th year what is the value.

Regards
Webmax

[avk]

What answer you expected.

[curiouscat408]

Try:

=FV(10%, 5, 0, -10000)

Note the sign for 10000. Inflows (10000) and outflows (FV) must have opposite signs.

I arbitrarily chose minus sign for inflows because I usually like the result of "time value" functions (PV, FV, PMT, etc) to be positive.

[josephteh]

Using mathematical equation, =10000*(1+10%)^5