This Excel spreadsheet calculates the Modified Sharpe Ratio.

The standard Sharpe Ratio is only appropriate for normally-distributed returns, where the entire distribution can be summarized through the mean and the variance.

But many modern investment vehicles, such as hedge funds and bonds, display fat-tailed returns, in which there is the potential for extreme losses. In these situations, the standard Sharpe Ratio underestimates risk and should not be used.

The potential for extreme losses can be quantified through the modified Value at Risk, which takes into account the skew and kurtosis of the returns distribution.

The standard Sharpe Ratio is the effective return (μ – rf) divided by the variance (σ^{2}). However, the modified Sharpe Ratio is the effective return divided by the modified Value at Risk, and is defined by the following equations.

μ and σ are the mean and standard deviation, S is skew, K is kurtosis, z_{c} is the quantile of the distribution and Z is the Cornish-Fisher asymptotic expansion for the quantile of a non-gaussian distribution.

**Download Excel spreadsheet to calculate Modified Sharpe Ratio **

Hello,

I have one question concerning the confidence level. Is this value of 0.01 assumed or do I have to count it somehow?

It will be helpful for me to know it. I need to calculate the modified sharpe ratio for my master thesis and do know how to come about this confidence level.

Thank you a lot in advance.

best regards

Joanna

I am looking at your example for the calculation of MVAR.

Your equation states MVAR = mean – Z*Standard Deviation

Yet your excel spreadsheet = mean + Standard Deviation*Z

Can you please clarify what is the right calculation? Or are you replacing the (-) with a (+) because the “Z” coefficient is a negative?

Your speedy reply is greatly appreciated

Tejinder

Hi Tejinder,

If you look at the spreadsheet you have a negative Zcf score and so Zcf is actually -Z in the above formula. They are then consistent.

Mark