Is there an easier way to calculate a rolling 5-yr annualized return using quarterly returns? My returns are in the actual number, for example, 1.02 instead of .0102, for 1.02%. My formula is shown below, but come next quarter, I don't want to drag down each individual cell reference:
=((((1+C10/100)*(1+C11/100)*(1+C12/100)*(1+C13/100)*(1+C14/100)*(1+C15/100)*(1+C16/100)*(1+C17/100)*(1+C18/100)*(1+C19/100)*(1+C20/100)*(1+C21/100)*(1+C22/100)*(1+C23/100)*(1+C24/100)*(1+C25/100)*(1+C26/100)*(1+C27/100)*(1+C28/100)*(1+C29/100))^(4/20))-1)*100
=((((1+C10/100)*(1+C11/100)*(1+C12/100)*(1+C13/100)*(1+C14/100)*(1+C15/100)*(1+C16/100)*(1+C17/100)*(1+C18/100)*(1+C19/100)*(1+C20/100)*(1+C21/100)*(1+C22/100)*(1+C23/100)*(1+C24/100)*(1+C25/100)*(1+C26/100)*(1+C27/100)*(1+C28/100)*(1+C29/100))^(4/20))-1)*100
