Future Value of Investment

[Peter]

Can anyone tell me what function I need to use to calculate the future value
of an investment after x years at a given, non-variable, interest rate? e.g.
what will $100,000 be worth if invested at 8%p.a. after 20 years?

Thank you.

 

[Guest]

Use the formula A = P*(1+R/100)^N
where amount would eb the result(future value), P =
investment , N = period , R = rate of interest

 

[Peter]

Fabulous.

Thank you.

-----Original Message-----
Use the formula A = P*(1+R/100)^N
where amount would eb the result(future value), P =
investment , N = period , R = rate of interest
.