Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
annualized return calculation for the purpose of portfolio performance evaluation | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Count Intervals of 1 Numeric value in a Row and Return Count down Column | Excel Worksheet Functions | |||
Huge problem with "if" formula's | Excel Discussion (Misc queries) | |||
Excel - return a picture or range rows as the result of a formula | Excel Worksheet Functions |