Does anyone know if there is a formula function like IRR (a,b) for
average annual return if I have string of returns that are quarterly-
I have been calculating this in a manual formule but I was wondering if
there was a short cut formula


--
rathersurfPosted from http://www.pcreview.co.uk/ newsgroup access

Assuming you have a string of returns like:

2.7%, 3.4%, -1.2%, 5.8%, 1.4%, 0.6%

The total return is: =(1+a1)*(1+a2)*(1+a3)*(1+a4) *(1+a5)*(1+a6)-1

The result is 13%. In other words, a $1 investment grew to $1.13 over the time
period. Now use the Rate function to calculate the annual rate which would
generate this result:

=Rate(6/4,0,-1,1+b1)

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"rathersurf" <rathersurf.1sj96n@ wrote in message
...

Does anyone know if there is a formula function like IRR (a,b) for
average annual return if I have string of returns that are quarterly-
I have been calculating this in a manual formule but I was wondering if
there was a short cut formula


--
rathersurfPosted from http://www.pcreview.co.uk/ newsgroup access