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

Answer 1 / 6
jee pee Posted messages 9435 Registration date   Status Moderator Last intervention   9 971
 
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
jee pee Posted messages 9435 Registration date   Status Moderator Last intervention   9 971
 
The detail of the formula for those who might be interested.
0
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