One way:

A1: $1
A2: 10 (yrs)
A3: .06 (interest rate)

=A1*(1+A3)^A2

HTH
Jason
Atlanta, GA

-----Original Message-----
in Excel, how do you calculate the future value of a
present value, given
that you know the interest rate for that period of
time. for example, $1
today will be worth how much in 10 years given a 6%
interest rate compounded
annually?
.