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.'

• Looking at the total return of 163.3% in the last 5 years of Microsoft, we see it is relatively higher, thus better in comparison to the benchmark SPY (109.7%)
• Compared with SPY (70.1%) in the period of the last 3 years, the total return, or performance of 104.4% is larger, thus better.

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 21.5% in the last 5 years of Microsoft, we see it is relatively larger, thus better in comparison to the benchmark SPY (16%)
• During the last 3 years, the annual return (CAGR) is 27%, which is greater, thus better than the value of 19.5% from the benchmark.

Volatility:

'Volatility is a rate at which the price of a security increases or decreases for a given set of returns. Volatility is measured by calculating the standard deviation of the annualized returns over a given period of time. It shows the range to which the price of a security may increase or decrease. Volatility measures the risk of a security. It is used in option pricing formula to gauge the fluctuations in the returns of the underlying assets. Volatility indicates the pricing behavior of the security and helps estimate the fluctuations that may happen in a short period of time.'

• The 30 days standard deviation over 5 years of Microsoft is 26.8%, which is larger, thus worse compared to the benchmark SPY (17.5%) in the same period.
• Looking at historical 30 days volatility in of 26.2% in the period of the last 3 years, we see it is relatively larger, thus worse in comparison to SPY (17.4%).

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.'

• The downside deviation over 5 years of Microsoft is 18.2%, which is greater, thus worse compared to the benchmark SPY (12.1%) in the same period.
• Compared with SPY (11.5%) in the period of the last 3 years, the downside risk of 17.1% is greater, 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.'

• Compared with the benchmark SPY (0.77) in the period of the last 5 years, the Sharpe Ratio of 0.71 of Microsoft is smaller, thus worse.
• Compared with SPY (0.97) in the period of the last 3 years, the ratio of return and volatility (Sharpe) of 0.94 is lower, thus worse.

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.12) in the period of the last 5 years, the downside risk / excess return profile of 1.04 of Microsoft is smaller, thus worse.
• Looking at ratio of annual return and downside deviation in of 1.43 in the period of the last 3 years, we see it is relatively smaller, thus worse in comparison to SPY (1.47).

Ulcer:

'The ulcer index is a stock market risk measure or technical analysis indicator devised by Peter Martin in 1987, and published by him and Byron McCann in their 1989 book The Investors Guide to Fidelity Funds. It's designed as a measure of volatility, but only volatility in the downward direction, i.e. the amount of drawdown or retracement occurring over a period. Other volatility measures like standard deviation treat up and down movement equally, but a trader doesn't mind upward movement, it's the downside that causes stress and stomach ulcers that the index's name suggests.'

• The Ulcer Index over 5 years of Microsoft is 13 , which is higher, thus worse compared to the benchmark SPY (8.48 ) in the same period.
• During the last 3 years, the Ulcer Index is 9.94 , which is larger, thus worse than the value of 5.3 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.'

• The maximum drop from peak to valley over 5 years of Microsoft is -37.1 days, which is lower, thus worse compared to the benchmark SPY (-24.5 days) in the same period.
• During the last 3 years, the maximum DrawDown is -26.8 days, which is lower, thus worse than the value of -18.8 days from the benchmark.

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 time in days below previous high water mark of 392 days of Microsoft is lower, thus better.
• Looking at maximum time in days below previous high water mark in of 229 days in the period of the last 3 years, we see it is relatively higher, thus worse in comparison to SPY (199 days).

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 higher, thus worse than the value of 47 days from the benchmark.