The following section provides a brief description of each statistic used in PerTrac and gives the formula used to calculate each.  PerTrac computes annualized statistics based on monthly data, unless Quarterly data is specified.

 

Value Added Monthly Index (VAMI) - This index reflects the growth of a hypothetical $1,000 in a given investment over time.  The index is equal to $1,000 at inception.  Subsequent month-end values are calculated by multiplying the previous month’s VAMI index by 1 plus the current month rate of return.

Where Vami 0 = 1000 and
Where R N  =  Return for period N

 

Vami N =  ( 1 + R N )  ´  Vami N-1

 

Average Return (Mean) - This is a simple average return (arithmetic mean) which is calculated by summing the returns for each period and dividing the total by the number of periods.  The simple average does not take the compounding effect of investment returns into account. 

Where N = Number of periods

Where R I = Return for period I

     N

Average Return  =  (  S  R I )  ¸  N         

    I=1                                         

 

Average Gain (Gain Mean) - This is a simple average (arithmetic mean) of the periods with a gain.  It is calculated by summing the returns for gain periods (return  ³ 0) and then dividing the total by the number of  gain periods. 

 

Where N = Number of periods

Where R I = Return for period I

Where G I = R I ( IF R I  ³  0 )  or  0 ( IF R I <  0 )

N G  = Number of periods that R I  ³  0

N

Average Gain  =  (  S  G I )  ¸  N G

I=1


Average Loss (Loss Mean) - This is a simple average (arithmetic mean) of the periods with a loss.  It is calculated by summing the returns for loss periods (return  < 0) and then dividing the total by the number of loss periods. 

 

Where N = Number of periods

Where R I = Return for period I

Where L I =  0 ( IF R I  ³  0 )  or R I ( IF R I <  0 )

N L = Number of periods that R I <  0

                                                          N

Average Loss  =  (  S  L I )  ¸ N L

                                                                                      I=1

 

Compound (Geometric) Average Return - The geometric mean is the monthly average return that assumes the same rate of return every period to arrive at the equivalent compound growth rate reflected in the actual return data.  In other words, the geometric mean is the monthly average return that, if applied each period, would give you a final Vami (growth) index that is equivalent to the actual final Vami index for the return stream you are considering.  In PerTrac, compound quarterly and annualized returns are calculated using the compound monthly return as a base.   

 

Where N = Number of periods

Where Vami (0) =  1000

 

Compound  Monthly ROR =  ( Vami N  ¸ Vami 0 ) 1/ N  - 1

Compound Quarterly ROR = ( 1 + Compound Monthly ROR ) 3 - 1

Compound Annualized ROR = ( 1 + Compound Monthly ROR ) 12 - 1

 

 

Average Calculation (within the annual returns table) – The average displays a simple average of the displayed statistic; however partial years are considered within the calculation.  For example:  a fund that has annual returns of 2002 (12.56%), 2003 (2.42%) and a partial 2004 year of 2 months (2.61%) would have an average Annual Return of 8.12%.  The result can be achieved by adding (12.56%+2.42%+2.61%) and dividing by 2.167.  The denominator of 2.167 was a result of 2 whole years and one sixth of a year (1+1+.1667).

 

Standard Deviation - Standard Deviation measures the dispersal or uncertainty in a random variable (in this case, investment returns).  It measures the degree of variation of returns around the mean (average) return.  The higher the volatility of the investment returns, the higher the standard deviation will be.  For this reason, standard deviation is often used as a measure of investment risk.

 

Where R I = Return for period I

Where M R = Mean of return set R

Where N = Number of Periods

N

M R  =  (  S  R I )  ¸  N                               

I=1

                                                                                                   N

Standard Deviation  =  ( S  ( R I - M R ) 2  ¸  (N - 1) ) ½

                                                                                          I = 1
Annualized Standard Deviation

 

Annualized Standard Deviation = Monthly Standard Deviation ´ ( 12 ) ½

Annualized Standard Deviation *  = Quarterly Standard Deviation ´ ( 4 ) ½

* Quarterly Data

 

Gain Standard Deviation - Similar to standard deviation, except this statistic calculates an average (mean) return for only the periods with a gain and then measures the variation of only the gain periods around this gain mean.  This statistic measures the volatility of upside performance. 

 

            Where N = Number of Periods

Where R I = Return for period I

Where M G = Gain Mean

Where G I = R I ( IF R I  ³  0 )  or  0 ( IF R I <  0 )

Where GG I = R I - M G ( IF R I  ³   0 ) or  0 ( IF R I  <  0 )

N G  = Number of periods that R I  ³  0

                                         N

M G  =  (  S  G I )  ¸  N G

I=1

                                                                                          N

Gain Deviation   =  ( S  (GG I ) 2  ¸  (N G - 1) ) ½

                                                                                  I=1

 

Loss Standard Deviation - Similar to standard deviation, except this statistic calculates an average (mean) return for only the periods with a loss and then measures the variation of only the losing periods around this loss mean.  This statistic measures the volatility of  downside performance.

 

            Where N = Number of Periods

Where R I = Return for period I

Where M L = Loss Mean

Where L I = R I ( IF R I <  0 )or  0 ( IF R I  ³  0 )

Where LL I = R I - M L ( IF R I  <   0 ) or  0 ( IF R I  ³  0 )  

N L  = Number of periods that R I <  0

                                          N

M L  =  (  S  L I )   ¸  N L

                                         I=1

                                                                                       N

Loss Deviation  =  ( S  ( LL I) 2   ¸   (N L - 1) ) ½

                                                                               I=1


Downside Deviation - Similar to the loss standard deviation except the downside deviation considers only returns that fall below a defined Minimum Acceptable Return (MAR) rather then the arithmetic mean.  For example, if the MAR is assumed to be 10%, the downside deviation would measure the variation of each period that falls below 10%. (The loss standard deviation, on the other hand, would take only losing periods, calculate an average return for the losing periods, and then measure the variation between each losing return and the losing return average).  In PerTrac, there are 3 downside deviation calculations, each using a different value for the MAR: 1)Uses a MAR which is defined by the user on the Preferences screen, 2) Uses the Sharpe risk free rate (which can also be defined in Preferences) as the MAR, and 3) uses zero as the MAR. 

 

Where R I = Return for period I

            Where N = Number of Periods

            Where R MAR = Period Minimum Acceptable Return

            Where L I = R I - R MAR ( IF R I - R MAR <  0 )or  0 ( IF R I - R MAR  ³  0 )

                                                                                                        N

Downside Deviation  =  ( (S  ( L I ) 2 )