View original (French)

Average annual growth rate

nauzia45 Posted messages 356 Status Member -  
 Anonymous user -
Hello,

I am looking for a dual skill in excel + financial math!

My problem:

On 01/01/2010, my insurance amounted to €500
On 01/01/2019, my insurance amounts to €619

My question:

Calculate the average annual growth rate.

I found the calculation for what they call the CAGR online, but I don't know how to set up the formula in Excel. I tried using "IRR.PAYMENTS"; it doesn't work.

Thank you in advance for your valuable help.
PS: I am using Excel 2010

Configuration: Windows / Chrome 72.0.3626.121

6 answers

  1.
    jee pee Posted messages 31892 Registration date   Status Moderator Last intervention   9 984
     
    Hello, 

    =POWER(619/500,1/9)-1
    or 
    =(619/500)^(1/9)-1
    ==>
     2.4%


    Regards

    --
            a stranger is a friend you haven't met yet.
    1
    1. jee pee Posted messages 31892 Registration date   Status Moderator Last intervention   9 984
       
      The detail of the formula for those who might be interested.
      0
    2. nauzia45 Posted messages 356 Status Member 24
       
      Well yes, I had found that one, but I didn't know how to write the square root with its exponent "n"

      Have a nice evening and thank you again
      0