To annualize monthly returns, you need to do it in two steps. First calculate
the total return, then annualize it.

In each row, calculate the running total return as:

=(1+MonthlyReturn%)*(1+PreviousTotalReturn%)-1

In your summary row, calculate your annualized return as:

=rate(TotalPeriods/12,0,-1,1+TotalReturn%)

--
Regards,
Fred


"ExcelEmailer" wrote in message
...
Hi All,
This is a great way to learn hints, and in reading about Pivot Tables below,
I thought someone may know the solution to my problem:
- I have 2 columns of data, A is the month/year and B is the PERCENT RETURN
for that month
- I have 17 months of data, and was asked to ANNUALIZE the ENTIRE PERIOD?
- Is this possible ? I tried using the (1 + (RETURN ^(17/12) * (1 +
(RETURN ^(17/12), which is time consuming and somehow got a ridiculous
number????
- HOW DO I ANNUALIZE PERCENT RETURNS more efficiently? Arrays? Pivot
tables? I am so overwhelmed and forget all that I learned LONG ago...ANY
HELP WILL COME BACK TO YOU IN GOOD VIBES! Keep up the great posts!