If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Compound Interest Rate or Growth Rate
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? |
#2
|
|||
|
|||
Compound Interest Rate or Growth Rate
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? |
#3
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|