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 |

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 |

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 |

3/15/2010 4:38:21 AM

I used the wizard to set up my home mortgage. It is a direct debit from my Credit Union savings account. As I am preparing for taxes I ran through the Tax Estimator and there is $0 showing for Itemized Deductions, #4 Mortgage Interest. I went to the Bill Summary page, went to edit the payment, then the split and it shows Mortgage Interested as (Calculated). Why doesnâ€™t this pick up on the Tax Estimator, Itemized Deductions, #4 Mortgage Interest automatically? What do I do to force it? Doug "Doug" <Doug@discussions.microsoft.com> wrote in message news:0E84D4AE-436B...

Hi, I was wondering... most credit cards I own have multiple credit card rates in effect at the same time. For example, 0% intro APR, ends in 6 mo. 8.99% after that Cash Advance: 18.94% Balance Transfer: 9.99% My statements keep these balances separate, but can Money track these differences too? It'd be nice if these various rates were reflected in the Debt Planner. Thanks! In microsoft.public.money, Larry Kyrala wrote: > > >My statements keep these balances separate, but can Money >track these differences too? It cannot do what you are envisioning. ...

Version: 2004 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I would like to put in a spread sheet a compounded rate of return calculator that the user would only have to put in present value, time period, interest rate <br><br>Example: $25,000 present value <br> 1% interest rate <br> &n...

I receive Excel files via e-mail from my head office that can't be opened with Office xp. As close as I can tell, these files are called "Compound Excel Files". I can't find any explanation of what a Compound File is and why I wouldn't be able to open it. In addition, when I notified the office, they cut out the pertinent information segment of the file and re-sent it. Surprisingly, I was able to open it. They claim they didn't change the format or program. There's information on compound documents in the following article: Using a Dual File Format i...

hi, i am using MS Money2006. my default currency is set to ?. one of my account is in different currency. the problem is it does not calculate the current value of that account in ? using the current exchange rate. it takes the older and the same exchange rate. where can i change the setting so that it always takes the actual current exchange rate? rnv ...

Can anyone guide me where I can get started with visual basic for access 2007? Is there any free web site offering courses for VB in Access 2007. thanks. I found these: http://office.microsoft.com/en-gb/access/HA012142131033.aspx http://learnaccessvba.com/ (Access 2003) http://www.functionx.com/vbaccess/ You can also find quite good introductions in the Help if you browse rather than search. Hit Alt-F11 to bring up the (scary!) VBA development environment and browse the Help there. It's a highly concentrated subject, though, and expect it to take time to be fluen...

P=1000 N=5 (years) P*(1+R)^N=1403 How do I get the value of R Thanx -- Dr. Sachin Wagh MBBS, DHA, DPH "Dr. Sachin Wagh" <DrSachinWagh@discussions.microsoft.com> wrote in message news:3C2D48B1-89EA-4CEC-9188-B40AE95413F9@microsoft.com... > P=1000 > N=5 (years) > P*(1+R)^N=1403 > How do I get the value of R The easy way is Tools > Goal Seek Another way is that R= ((1403/P)^(1/N))-1 -- David Biddulph R= ((1403/P)^(1/N))-1 solved the problem thanx a ton David! "David Biddulph" wrote: > "Dr. Sachin Wagh" <DrSachinWagh@discussions.m...

Hi. I am finally ripping my cd collection and digitizing it. I am using Windows Media Player 11 on Windows XP Home Edition. I have all the updates, etc. Does ripping in MP3's have a constant-bit rate? I swear I saw the option in the options tab somewhere, but only the .wma files seem to have constant bit rate or variable bit rate. I know some ripping programs have the cbr or vbr choice for mp3's. What is it in the wma 11 player? I can't find anything in the help topics for the program or on the pages in the links from the help file. Maybe I missed something, I d...

Hi, Is there a formula in Excel that returns the Compounded Annual Growt Rate(CAGR)? For example, I have a column with Yearly $ amounts with 1 years of data. With a financial calculator, if I have the starting amount, the ending $ dollar amount and the number of years(or periods) I can calculate the CAGR. Can Excel do something similar with the data Thanks -- Message posted from http://www.ExcelForum.com Deacs, If you want the annualized rate, and have the start and end values, use: =(EndValue/StartValue)^(1/Years) If these values are in cells, it might look like: =(B2/B1)^(1/B3) -...

I am trying to calculate annual percentage rate for a mortgage estimate. The Formula works as long as I don't use a rate above 5.5% and term in months above 310. I need to calculate using 360 month term. Also I need to combine 1st and 2nd lien loan info into a single APR. Anyone know how to creat this; Here is the formula I Have been using: =RATE(B4,PMT(ROUND(B2/12,6),B4,B1,0,0),B1-B3,0,0,0)*12 Data is as follows: B1 = 110410 (Loan Amt) B2 = 6.5% (Interest Rate) B3 = 3360 (Estimated Closing Costs) B4 = 360 (Term) sts, It would help the function converge if you offer it an init...

Need to write a paragraph on the four sentence types...Just need to have an example of each type....please someone help!! Thanks On 30/05/2010 4:18 PM, Peggylynne wrote: > Need to write a paragraph on the four sentence types...Just need to have an > example of each type....please someone help!! Thanks See http://www.eslbee.com/sentences.htm and some of the other sites that appear when you google for the subject of your post. -- Hope this helps, Doug Robbins - Word MVP Please reply to the newsgroup unless you want to obtain my services on a professional basis. ...

I would like to have an online database that works with a e-commerc website. I am going to have all the inventory set at 0's. When th first order is made I would like it to start an email to be compose with the product name and number. I want the email sent out at 4pm t one address everyday. Is there anyway to do with working with Excel an with SQL/Access -- Hend ----------------------------------------------------------------------- Hendy's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=471 View this thread: http://www.excelforum.com/showthread.php?threadid=...

0.5064431 I Have An Interest ... 9.796143E-02 0.4677629 Now Visit Tobacco Is Drugs 0.9484228 ...

How would I make a Fx. that would add $500 + 4% interest each mouth? A1 B1 C1 ie 500 +4% = =+500 +4% = =+500 +4% = Hi Jason in C1 put =A1*1.04 In A2 put =C1 Copy both down as far as you ned. "Jason" wrote: > How would I make a Fx. that would add $500 + 4% interest each mouth? > A1 B1 C1 > ie 500 +4% = > =+500 +4% = > =+500 +4% = that is not adding the $500 add each mouth, it needs to be A.500 + 4%, than add B.500, and then A+B+4%, and so on "Michael" wrote: > Hi Jason > ...

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? 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> wrot...

Following the last M05 major update, I noticed that the currency echange rates do NOT update online (automatically) anymore. If one goes onto settings / currencies, their is a check box for online update - but it does not seem to work. Any advice? ...

My company is a Financial Services company that is interested in implementing MS CRM. This would initially be done for the Investment Advisory portion of our business and later implemented for the rest of the organization. Are there any MS CRM customers/clients in the Investment Advisory business that can comment on their deployment of MS CRM and there overall experience as far as usage of this solution? Also, can you comment on whether the solution was useful without customization or was there customization to the product. If there was customization, then how much (% amount) and wh...

Hello I have setup a quarantine mailbox, and configured all the content filters. Eveything seems to be working, but when i look at the SCL rating on a quarantined email in the quarantined inbox the SCL rating is -1. This cant be correct, because emails with an SCL rating that =7 get quarantined, so it appears that i cam not seing the real SCL rating on the email. how can i expose this ? i know i can look at the headers of the eamil but uit says -1 not 7 as it should SCL rating of -1 is assigned to authenticated senders, as also senders on Safe Sender lists, from IP addresses on IP ...

Does anyone know how to set up a mortgage/loan so that the payment interest and principle are calculated based on compounding the balance daily instead of monthly, which seem to tbe the default? Quicken gave the user the option of selecting that the loan was compounded daily, monthly, ... Money doesn't have that level of detail. What I do is enter the term, payment, etc., and let Money calculate the interest rate. It may be off slightly from the bank's. At the end of the year, I reconcile it to the mortgage statement. A simple once-a-year adjustment is easy enough. -- Chris Co...

I deposit Rs. 2574 each year for 21 years At the end of 21 years I get Rs. 129635 How do I understand the Compound Rate thats' been applied Regards & Thanx -- Dr. Sachin Wagh MBBS, DHA, DPH One way: =RATE(21,-2574,1,129635) In article <A567B75F-728B-4986-AAF4-0830386AF800@microsoft.com>, Dr. Sachin Wagh <DrSachinWagh@discussions.microsoft.com> wrote: > I deposit Rs. 2574 each year for 21 years > > At the end of 21 years I get Rs. 129635 > > How do I understand the Compound Rate thats' been applied > > Regards & Thanx SORRY, Not ...

Hello ASPNET Forum, I have a question regarding HTML Tokens. I am unable to successfully query Google for relevant results to my question. Is there anywhere I can find information on HTML Tokens and their corresponding sizes, and render times. I understand that there would be many factors that would determine size and draw/render times, but is there any base standard. That is; Which would be largest in size, and which would take longest to load (and render)? Something like, <div></div> is larger in size (bytes? something like that), than a <p></p&...

hello, Ok, I have a material cost in cell A1 - todays date in A2, the date the material will be delivered in A3, and an inflation value in A4 (%per annum). I need a formula that will work out what the material will cost when the material is delivered. eg. costs £100 today at a rate of 5%per annum it will cost £105 next year and £110.25 in two years. All input values are in seperate cells and can vary. Also it will have to cope with fractions of a year. Any ideas? Ciara Try this: Set A2 and A3 to "Date" format. A5 = A1*(1+A4)^((VALUE(A3)-VALUE(A2))/365) ...

I was wondering, when Microsoft sit down to write the next version of Excel, say for 2006, does anyone know how they decide what to add or amend or remove? S:) Yes is probably an unsatisfying reply, but Yes, of course. Those people are not allowed to answer your follow-up question, so don't ask it. Best wishes Harald "Steve" <crankylemming@aol.com> skrev i melding news:1103146538.084504.53960@z14g2000cwz.googlegroups.com... > I was wondering, when Microsoft sit down to write the next version of > Excel, say for 2006, does anyone know how they decide what to add o...

Did anything change with the Direct Deposit Earnings Statement in the Year End Update? My old DD Earnings statement prints the Pay Rate from the Pay Code window. Now that the Year End update has been applied, the Pay Rate on the DD Earnings Statement shows the rate per hour. For instance, the salary pay rate for an employee is $56,559.60. This is the amount that used to show in the Pay Rate. It now shows $27.19 which is $56,559.60/2080 hours. I just wanted to make sure that this changed in the year end update. Thanks, Jocelyn ...

Hi I need to work out compound interest on =A350. If I have=20 =A350 at 5% per year compound, how much will it be in 5=20 years time. Sorry, but I have absolutely no idea how to figure this=20 one out. Tried the following formula =3DNOMINAL(50,5) but=20 it came up with a wierd answer. Any help would be most appreciated. Thanking you in=20 anticipation. Regards Sue On 5/6/04 8:50 AM, in article 944701c43368$bf643f90$a001280a@phx.gbl, "anonymous@discussions.microsoft.com" <anonymous@discussions.microsoft.com> wrote: > Hi > > I need to work out compound interes...