Microsoft (MSFT)

TotalReturn:

'Total return, when measuring performance, is the actual rate of return of an investment or a pool of investments over a given evaluation period. Total return includes interest, capital gains, dividends and distributions realized over a given period of time. Total return accounts for two categories of return: income including interest paid by fixed-income investments, distributions or dividends and capital appreciation, representing the change in the market price of an asset.'

• The total return, or increase in value over 5 years of Microsoft is 152.4%, which is larger, thus better compared to the benchmark SPY (115.1%) in the same period.
• Looking at total return in of 97% in the period of the last 3 years, we see it is relatively greater, thus better in comparison to SPY (71.1%).

CAGR:

'The compound annual growth rate isn't a true return rate, but rather a representational figure. It is essentially a number that describes the rate at which an investment would have grown if it had grown the same rate every year and the profits were reinvested at the end of each year. In reality, this sort of performance is unlikely. However, CAGR can be used to smooth returns so that they may be more easily understood when compared to alternative investments.'

• Looking at the annual performance (CAGR) of 20.4% in the last 5 years of Microsoft, we see it is relatively higher, thus better in comparison to the benchmark SPY (16.6%)
• Looking at annual return (CAGR) in of 25.5% in the period of the last 3 years, we see it is relatively higher, thus better in comparison to SPY (19.7%).

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 (17.5%) in the period of the last 5 years, the volatility of 26.9% of Microsoft is higher, thus worse.
• Compared with SPY (17.5%) in the period of the last 3 years, the historical 30 days volatility of 26.4% is greater, thus worse.

DownVol:

'The downside volatility is similar to the volatility, or standard deviation, but only takes losing/negative periods into account.'

• Looking at the downside volatility of 18.3% in the last 5 years of Microsoft, we see it is relatively larger, thus worse in comparison to the benchmark SPY (12.1%)
• Compared with SPY (11.5%) in the period of the last 3 years, the downside volatility of 17.3% is higher, thus worse.

Sharpe:

'The Sharpe ratio (also known as the Sharpe index, the Sharpe measure, and the reward-to-variability ratio) is a way to examine the performance of an investment by adjusting for its risk. The ratio measures the excess return (or risk premium) per unit of deviation in an investment asset or a trading strategy, typically referred to as risk, named after William F. Sharpe.'

• Looking at the ratio of return and volatility (Sharpe) of 0.67 in the last 5 years of Microsoft, we see it is relatively smaller, thus worse in comparison to the benchmark SPY (0.8)
• During the last 3 years, the ratio of return and volatility (Sharpe) is 0.87, which is lower, thus worse than the value of 0.98 from the benchmark.

Sortino:

'The Sortino ratio measures the risk-adjusted return of an investment asset, portfolio, or strategy. It is a modification of the Sharpe ratio but penalizes only those returns falling below a user-specified target or required rate of return, while the Sharpe ratio penalizes both upside and downside volatility equally. Though both ratios measure an investment's risk-adjusted return, they do so in significantly different ways that will frequently lead to differing conclusions as to the true nature of the investment's return-generating efficiency. The Sortino ratio is used as a way to compare the risk-adjusted performance of programs with differing risk and return profiles. In general, risk-adjusted returns seek to normalize the risk across programs and then see which has the higher return unit per risk.'

• Compared with the benchmark SPY (1.17) in the period of the last 5 years, the downside risk / excess return profile of 0.98 of Microsoft is lower, thus worse.
• Looking at excess return divided by the downside deviation in of 1.33 in the period of the last 3 years, we see it is relatively lower, thus worse in comparison to SPY (1.49).

Ulcer:

'The Ulcer Index is a technical indicator that measures downside risk, in terms of both the depth and duration of price declines. The index increases in value as the price moves farther away from a recent high and falls as the price rises to new highs. The indicator is usually calculated over a 14-day period, with the Ulcer Index showing the percentage drawdown a trader can expect from the high over that period. The greater the value of the Ulcer Index, the longer it takes for a stock to get back to the former high.'

• Looking at the Ulcer Ratio of 13 in the last 5 years of Microsoft, we see it is relatively greater, thus worse in comparison to the benchmark SPY (8.48 )
• During the last 3 years, the Ulcer Index is 9.96 , which is higher, thus worse than the value of 5.31 from the benchmark.

MaxDD:

'Maximum drawdown is defined as the peak-to-trough decline of an investment during a specific period. It is usually quoted as a percentage of the peak value. The maximum drawdown can be calculated based on absolute returns, in order to identify strategies that suffer less during market downturns, such as low-volatility strategies. However, the maximum drawdown can also be calculated based on returns relative to a benchmark index, for identifying strategies that show steady outperformance over time.'

• Compared with the benchmark SPY (-24.5 days) in the period of the last 5 years, the maximum drop from peak to valley of -37.1 days of Microsoft is lower, thus worse.
• Compared with SPY (-18.8 days) in the period of the last 3 years, the maximum drop from peak to valley of -26.8 days is lower, 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) in days.'

• 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 lower, thus better.
• During the last 3 years, the maximum time in days below previous high water mark is 229 days, which is larger, 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 (120 days) in the period of the last 5 years, the average time in days below previous high water mark of 101 days of Microsoft is lower, thus better.
• During the last 3 years, the average days under water is 66 days, which is larger, thus worse than the value of 47 days from the benchmark.