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? |
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? |
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? |
All times are GMT +1. The time now is 07:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com