Microsoft (MSFT)

TotalReturn:

'The total return on a portfolio of investments takes into account not only the capital appreciation on the portfolio, but also the income received on the portfolio. The income typically consists of interest, dividends, and securities lending fees. This contrasts with the price return, which takes into account only the capital gain on an investment.'

• Looking at the total return, or increase in value of 131.8% in the last 5 years of Microsoft, we see it is relatively larger, thus better in comparison to the benchmark SPY (107.8%)
• During the last 3 years, the total return is 45%, which is greater, thus better than the value of 34.1% from the benchmark.

CAGR:

'The compound annual growth rate (CAGR) is a useful measure of growth over multiple time periods. It can be thought of as the growth rate that gets you from the initial investment value to the ending investment value if you assume that the investment has been compounding over the time period.'

• The compounded annual growth rate (CAGR) over 5 years of Microsoft is 18.4%, which is greater, thus better compared to the benchmark SPY (15.8%) in the same period.
• Compared with SPY (10.3%) in the period of the last 3 years, the annual return (CAGR) of 13.2% is greater, thus better.

Volatility:

'Volatility is a statistical measure of the dispersion of returns for a given security or market index. Volatility can either be measured by using the standard deviation or variance between returns from that same security or market index. Commonly, the higher the volatility, the riskier the security. In the securities markets, volatility is often associated with big swings in either direction. For example, when the stock market rises and falls more than one percent over a sustained period of time, it is called a 'volatile' market.'

• Compared with the benchmark SPY (18%) in the period of the last 5 years, the 30 days standard deviation of 27.1% of Microsoft is higher, thus worse.
• Looking at volatility in of 27.6% in the period of the last 3 years, we see it is relatively higher, thus worse in comparison to SPY (18.8%).

DownVol:

'Risk measures typically quantify the downside risk, whereas the standard deviation (an example of a deviation risk measure) measures both the upside and downside risk. Specifically, downside risk in our definition is the semi-deviation, that is the standard deviation of all negative returns.'

• Looking at the downside risk of 18.6% in the last 5 years of Microsoft, we see it is relatively larger, thus worse in comparison to the benchmark SPY (12.5%)
• Compared with SPY (13%) in the period of the last 3 years, the downside volatility of 18.8% is greater, thus worse.

Sharpe:

'The Sharpe ratio was developed by Nobel laureate William F. Sharpe, and is used to help investors understand the return of an investment compared to its risk. The ratio is the average return earned in excess of the risk-free rate per unit of volatility or total risk. Subtracting the risk-free rate from the mean return allows an investor to better isolate the profits associated with risk-taking activities. One intuition of this calculation is that a portfolio engaging in 'zero risk' investments, such as the purchase of U.S. Treasury bills (for which the expected return is the risk-free rate), has a Sharpe ratio of exactly zero. Generally, the greater the value of the Sharpe ratio, the more attractive the risk-adjusted return.'

• The Sharpe Ratio over 5 years of Microsoft is 0.59, which is smaller, thus worse compared to the benchmark SPY (0.74) in the same period.
• Looking at Sharpe Ratio in of 0.39 in the period of the last 3 years, we see it is relatively smaller, thus worse in comparison to SPY (0.41).

Sortino:

'The Sortino ratio improves upon the Sharpe ratio by isolating downside volatility from total volatility by dividing excess return by the downside deviation. The Sortino ratio is a variation of the Sharpe ratio that differentiates harmful volatility from total overall volatility by using the asset's standard deviation of negative asset returns, called downside deviation. The Sortino ratio takes the asset's return and subtracts the risk-free rate, and then divides that amount by the asset's downside deviation. The ratio was named after Frank A. Sortino.'

• Compared with the benchmark SPY (1.06) in the period of the last 5 years, the excess return divided by the downside deviation of 0.85 of Microsoft is lower, thus worse.
• Compared with SPY (0.6) in the period of the last 3 years, the excess return divided by the downside deviation of 0.57 is lower, thus worse.

Ulcer:

'Ulcer Index is a method for measuring investment risk that addresses the real concerns of investors, unlike the widely used standard deviation of return. UI is a measure of the depth and duration of drawdowns in prices from earlier highs. Using Ulcer Index instead of standard deviation can lead to very different conclusions about investment risk and risk-adjusted return, especially when evaluating strategies that seek to avoid major declines in portfolio value (market timing, dynamic asset allocation, hedge funds, etc.). The Ulcer Index was originally developed in 1987. Since then, it has been widely recognized and adopted by the investment community. According to Nelson Freeburg, editor of Formula Research, Ulcer Index is “perhaps the most fully realized statistical portrait of risk there is.'

• Looking at the Downside risk index of 13 in the last 5 years of Microsoft, we see it is relatively greater, thus worse in comparison to the benchmark SPY (8.45 )
• During the last 3 years, the Ulcer Index is 10 , which is larger, thus worse than the value of 5.73 from the benchmark.

MaxDD:

'A maximum drawdown is the maximum loss from a peak to a trough of a portfolio, before a new peak is attained. Maximum Drawdown is an indicator of downside risk over a specified time period. It can be used both as a stand-alone measure or as an input into other metrics such as 'Return over Maximum Drawdown' and the Calmar Ratio. Maximum Drawdown is expressed in percentage terms.'

• Compared with the benchmark SPY (-24.5 days) in the period of the last 5 years, the maximum DrawDown of -37.1 days of Microsoft is smaller, thus worse.
• Compared with SPY (-18.8 days) in the period of the last 3 years, the maximum DrawDown of -26.8 days is smaller, thus worse.

MaxDuration:

'The Drawdown Duration is the length of any peak to peak period, or the time between new equity highs. The Max Drawdown Duration is the worst (the maximum/longest) amount of time an investment has seen between peaks (equity highs). Many assume Max DD Duration is the length of time between new highs during which the Max DD (magnitude) occurred. But that isn’t always the case. The Max DD duration is the longest time between peaks, period. So it could be the time when the program also had its biggest peak to valley loss (and usually is, because the program needs a long time to recover from the largest loss), but it doesn’t have to be'

• Compared with the benchmark SPY (488 days) in the period of the last 5 years, the maximum days under water of 392 days of Microsoft is smaller, thus better.
• During the last 3 years, the maximum time in days below previous high water mark is 201 days, which is greater, thus worse than the value of 199 days from the benchmark.

AveDuration:

'The Drawdown Duration is the length of any peak to peak period, or the time between new equity highs. The Avg Drawdown Duration is the average amount of time an investment has seen between peaks (equity highs), or in other terms the average of time under water of all drawdowns. So in contrast to the Maximum duration it does not measure only one drawdown event but calculates the average of all.'

• Compared with the benchmark SPY (118 days) in the period of the last 5 years, the average days under water of 96 days of Microsoft is lower, thus better.
• Looking at average days under water in of 59 days in the period of the last 3 years, we see it is relatively higher, thus worse in comparison to SPY (45 days).