Compound Interest Rate or Growth Rate
You want the Rate function, as in:
=rate(2010-1985,0,10000,-18000)
Answer: 2% per year
Regards,
Fred
"1944-71222" wrote in message
...
Is there a function in Excell that can be used to calculate an
investment"s
compound growth rate? If so what is it and how do you use it?
For instance if someone invested $10,000 in 1985 and that investment was
worth $18,000 today is there a function in Excell that can be used to
determine that investment's compound growth rate?
|