|
|
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?
|
|
0
|
|
|
|
Reply
|
 Utf
|
3/15/2010 1:23:01 AM |
|
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" <1944-71222@discussions.microsoft.com> wrote in message
news:86F96FF4-F8C3-40DB-A0CC-5049A827EB3A@microsoft.com...
> 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?
|
|
|
0
|
|
|
|
Reply
|
Ashish
|
3/15/2010 2:27:22 AM
|
|
You want the Rate function, as in:
=rate(2010-1985,0,10000,-18000)
Answer: 2% per year
Regards,
Fred
"1944-71222" <1944-71222@discussions.microsoft.com> wrote in message
news:86F96FF4-F8C3-40DB-A0CC-5049A827EB3A@microsoft.com...
> 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?
|
|
|
0
|
|
|
|
Reply
|
Fred
|
3/15/2010 4:38:21 AM
|
|
|
2 Replies
750 Views
(page loaded in 0.079 seconds)
Similiar Articles: Compound Interest Rate or Growth Rate - microsoft.public.excel ...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 in... Formula to calculate compound interest on increasing principal ...Compound Interest Rate or Growth Rate - microsoft.public.excel ... Formula to calculate compound interest on increasing principal ... Moreden, If you add to the principal ... Calculate a daily rate - microsoft.public.access.queries ...Compound Interest Rate or Growth Rate - microsoft.public.excel ... Calculate Daily Interest, Paid out Weekly - microsoft.public.excel ... Not sure if the subject makes ... X Factor into Percent... - microsoft.public.excel.worksheet ...Compound Interest Rate or Growth Rate - microsoft.public.excel ... Version: 2004 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I ... nt where P = future ... How to calculate overdue? - microsoft.public.access.queries ...Compound Interest Rate or Growth Rate - microsoft.public.excel ... Is there a function in Excell that can be used to calculate an investment"s ... how to calculate compound interest ? - microsoft.public.mac.office ...Compound Interest Rate or Growth Rate - microsoft.public.excel ... Is there a function in Excell that can be used to calculate an investment"s compound growth rate? how to calculate interest on payments - microsoft.public.excel ...Is 18% an annual or a quarterly rate? Is 18% truly "interest" (which often compounds), or ... on payments - microsoft.public.excel ... how to calculate compound interest ... Calculate How Long Funds Will Last - microsoft.public.excel ...... that will return how long funds will last if you earn a static interest rate and ... how to calculate compound interest ? - microsoft.public.mac.office ... Calculate How ... Health Savings Account - microsoft.public.greatplainsCompound Interest Rate or Growth Rate - microsoft.public.excel ... Health Savings Account - microsoft.public.greatplains Savings Account Interest Calculator with Compound ... annuity calculation for monthly payments but quarterly compoundin ...B5 (monthly interest rate): =A3/12 C5 (initial balance): =A1 B6 (1st month ... Formula to calculate compound interest on increasing principal ... how to calculate ... Compounded annual growth rate - CAGR - See your portfolio in a ...If we are calculating the annual compound growth rate, then each year the new basis is ... Compare that with $10,000 invested at a simple annual interest rate of 12%, which ... How to Calculate Compound Annual Growth Rate | eHow.comCompound annual growth rate, at first take, is a term that seems shrouded in a cloud of ... How to Compute a Compound Interest Rate. In finance, compound interest is interest ... Interest and Exponential Growth - Math2.orgThe Compound Interest Equation P = C (1 + r/n) nt where P = future value C = initial deposit r = interest rate (expressed as a fraction: eg. 0.06) How to Calculate the Compound Growth Rate | eHow.comCompound annual growth rate, often shown as CAGR, is used to ... Compound annual growth rate, at first take, is a term... How to Compute a Compound Interest Rate Calculate Compound Interest, Rate Of Growth, Math Assignment Help ...Calculate compound interest, simple interest, growth rate in simple mathematics. Expertsmind.com offers math assignment help, homework help and solutions for Compound ... 7/24/2012 3:52:09 PM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
39 followers. 