Compound Interest Rate or Growth Rate

**1944-71222** · March 15th, 2010, 01:23 AM posted to microsoft.public.excel.worksheet.functions

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?

**Ashish Mathur[_2_]** · March 15th, 2010, 02:27 AM posted to microsoft.public.excel.worksheet.functions

Hi,

Try this. E11 has 18,000 and D11 has 10,000. D11 has 2010 and D10 has 1985

=(E11/E10)^(1/(D11-D10))-1

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"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?

**Fred Smith[_4_]** · March 15th, 2010, 04:38 AM posted to microsoft.public.excel.worksheet.functions

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?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode