K
karlcsr
I have tried for quite a while to figure out a formula within Excel
that will give the annual rate of return if you insert the initial
amount invested, the number of years invested, and the final amount
held.
For instance, if you start with $1,000 and in five years the amount is
$1,500, the compounded rate of return (I am not sure of the
terminology) I don't want the answer of 10 percent. If the rate of
return was 10 percent, compounded, I would wind up with about
$1,610.51. Is there a way that I can get this compounded rate of
return (or whatever the proper terminology is) from an Excel
spreadsheet?
Thanks!
(e-mail address removed)
that will give the annual rate of return if you insert the initial
amount invested, the number of years invested, and the final amount
held.
For instance, if you start with $1,000 and in five years the amount is
$1,500, the compounded rate of return (I am not sure of the
terminology) I don't want the answer of 10 percent. If the rate of
return was 10 percent, compounded, I would wind up with about
$1,610.51. Is there a way that I can get this compounded rate of
return (or whatever the proper terminology is) from an Excel
spreadsheet?
Thanks!
(e-mail address removed)