View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Natalie
 
Posts: n/a
Default Cumulative Return

I have a series of monthly return and need to create a formula that can
compute it's cumulative return in the following manner:
(1+return1)*(1+return2)*(1+return3))*(1+return4)*( 1+return5)

Subsequently, I would need to compute the "average" return by creating
another formula in the following manner:
((1+return1)*(1+return2)*(1+return3)*(1+return4)*( 1+return5))^(1/n) €“ 1,
where "n" should be the "count" of months.

Appreciate any assistance. Thank you!!!