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!!!
|