The Downside Deviation itself, however, is a little more
complicated. To calculate it, we have set the MAR at 5% per annum (which is the same as the risk-free rate of return from the Sharpe
Ratio).
First, we identify those returns which are less than the MAR of
5.0% per annum or 0.42% per month. Using the same date we did to
calculate the Sharpe Ratio, those returns are isolated in the third
column of the calculation box.
Second, we then square those returns, which is shown in the
fourth column.
Third, we then calculate the sum of the squared returns, which is
0.39%.
Fourth, we then need to divide that sum by the total number of
months, which is 15. The result is 0.000263.
Last, we need to find the square root of that number (then
multiply it by 100 to get a percentage). The answer is 1.63%, which
is the monthly Downside Deviation (the annual Deviation is found by
multiplying it by the square root of 12).