Performance Metric Calculations
Hi,
I need to calculate the ANNUALIZED performance metrics for the following set of data.
Month //% Return //Risk Free Rate %
Jan //9.378 //0.02
Feb // 2.145 //0.02
Mar //1.669 //0.02
Apr //2.384 //0.03
May //3.143 //0.07
Jun //1.521 //0.02
July //0.433 //0.02
Aug //2.211 //0.12
Sep //3.099 //0.23
Oct //5.126 //0.26
Nov //10.274 //0.31
Dec //3.392 //0.29
Jan //0.71 //0.23
Feb //12.129 //0.27
Mar //3.844 //0.27
Apr //0.435 //0.3
May //-0.315 //0.3
Jun //2.319 //0.29
Jul //4.059 //0.33
Aug //3.024 //0.45
Sep //0.192 //0.51
Oct //2.346 //0.51
Nov //7.187 //0.52
Dec //0.185 //0.74
Jan //4.489 //0.8
Feb //3.033 //0.89
Mar //0.166 //0.98
Apr //-0.339 //1.07
May //7.865 //1.01
Jun //3.121 //1.03
Jul //2.813 //1.07
Aug //5.378 //1.23
Sep //2.413 //1.32
Oct //5.184 //1.41
Nov //5.032 //1.57
Dec //-1.477 //1.7
Jan //3.248 //1.76
With regards to this data set, the risk free rates above are the historical quotes taken from the corresponding time period. Are these ok to use?
The metrics I need to calculate are;
Metric //Calculation //Answer
Average Return //=average(cells) 3.292%
Variance //=var(cells) 0.092%
St. Dev //=st.dev.(cells) 3.026%
Beta // ""
Unsystematic Risk // ""
Downside Deviation// ""
VAR 5% // ""
Sharpe // ""
M^2 // ""
Treynor // ""
Jensens Alpha // ""
Information Ratio // ""
Sortino // ""
RAROC // ""
Compounded Annual Return// ""
Max Drawdown // ""
Id be extremely grateful for your explanations & help to solve these. Thanks!
Corporis suscipit nobis eaque placeat quisquam occaecati molestiae. Rerum dolorem qui eius dolores blanditiis aut. Quidem dolores minima soluta aliquam asperiores perferendis. Rem voluptate illo dolore nihil libero ipsam laudantium. Ea est iste laboriosam in. Unde sapiente hic omnis non laudantium quas quam enim.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...