When you’re considering an investment, you might have a minimum percentage return in mind that you want it to earn each month or year. Calculating downside deviation can help you identify and steer clear of investments that are unlikely to meet these expectations. This risk measure, expressed as a percentage, reveals the extent to which an investment’s historical returns were lower than your minimum acceptable return, or MAR. A lower percentage suggests less risk of losing money. An investment with a high downside deviation has a habit of cranking out poor returns and might put a dent in your portfolio.
Substitute an investment’s information for each of the past six months into the formula (E - B + D)/B, in which B and E represent the price at the beginning and end of each month and D represents the dividends or interest it paid during the month. For example, if a stock’s price was $10 and $11 at the beginning and end of last month, respectively, and it paid no dividends, last month’s formula is ($11 - $10)/$10.
Calculate each formula to determine the investment’s monthly returns for each of the past six months. In this example, subtract $10 from $11 and divide by $10 to get 0.1, or a 10 percent return last month. Assume the other monthly returns in decimal form were -0.02, 0.03, 0.05, 0.02 and -0.04.
Identify the monthly returns that were less than your MAR, which is the minimum monthly return you require in order to own the investment. In this example, assume you require a 1 percent, or 0.01, monthly MAR. The stock’s monthly returns of -0.02 and -0.04 were less than your MAR.
Subtract each return you identified in Step 3 from your MAR. Square each result. In this example, subtract -0.02 from 0.01 to get 0.03. Square 0.03 to get 0.0009. Subtract and square the other result to get 0.0025.
Add each squared result. Divide that result by the number of returns you calculated in Step 2. In this example add 0.0009 to 0.0025 to get 0.0034. Divide 0.0034 by 6 to get 0.000567.
Calculate the square root of your result. Multiply that result by 100 to calculate the investment’s downside deviation as a percentage. Concluding the example, calculate the square root of 0.000567 to get 0.0238. Multiply 0.0238 by 100 to get a 2.38 percent downside deviation. This investment has a lower tendency of generating returns less than your 1 percent MAR than an investment with, say, a 9 percent downside deviation.
- You can calculate downside deviation using any periodic returns, such as quarterly or annual returns, and can use more than six periods in your calculation. The more periods you use, the more accurate your result will be.
- Compare an investment’s downside deviation with those of other investments to compare their risk. Make sure each downside deviation was calculated using the same type of periodic returns.
- An investment’s downside deviation is based on its historical returns and does not guarantee it will perform in any particular way in the future.
- Hemera Technologies/AbleStock.com/Getty Images
- How to Calculate the Equivalent Interest for an Investment Return
- How to Calculate Expected Return Using Excel
- How to Calculate the Average Yield on Investments
- How to Calculate Abnormal Returns with Stock Prices and S&P Information
- What Is Portfolio Volatility?
- How to Calculate the Average Return on a Portfolio of Stocks
- How to Calculate Rate Earned in Common Stock
- How to Illustrate Return on Investment