Microsoft (MSFT)

TotalReturn:

'Total return is the amount of value an investor earns from a security over a specific period, typically one year, when all distributions are reinvested. Total return is expressed as a percentage of the amount invested. For example, a total return of 20% means the security increased by 20% of its original value due to a price increase, distribution of dividends (if a stock), coupons (if a bond) or capital gains (if a fund). Total return is a strong measure of an investment’s overall performance.'

• The total return, or increase in value over 5 years of Microsoft is 206.7%, which is larger, thus better compared to the benchmark SPY (107.7%) in the same period.
• Looking at total return in of 32.8% in the period of the last 3 years, we see it is relatively smaller, thus worse in comparison to SPY (33.8%).

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

• The annual return (CAGR) over 5 years of Microsoft is 25.2%, which is larger, thus better compared to the benchmark SPY (15.8%) in the same period.
• Compared with SPY (10.2%) in the period of the last 3 years, the compounded annual growth rate (CAGR) of 10% is smaller, thus worse.

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

• Looking at the 30 days standard deviation of 30.4% in the last 5 years of Microsoft, we see it is relatively larger, thus worse in comparison to the benchmark SPY (20.9%)
• Looking at historical 30 days volatility in of 27.6% in the period of the last 3 years, we see it is relatively greater, thus worse in comparison to SPY (17.5%).

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 deviation of 20.8% in the last 5 years of Microsoft, we see it is relatively greater, thus worse in comparison to the benchmark SPY (14.9%)
• During the last 3 years, the downside risk is 19.3%, which is higher, thus worse than the value of 12.2% from the benchmark.

Sharpe:

'The Sharpe ratio is the measure of risk-adjusted return of a financial portfolio. Sharpe ratio is a measure of excess portfolio return over the risk-free rate relative to its standard deviation. Normally, the 90-day Treasury bill rate is taken as the proxy for risk-free rate. A portfolio with a higher Sharpe ratio is considered superior relative to its peers. The measure was named after William F Sharpe, a Nobel laureate and professor of finance, emeritus at Stanford University.'

• Compared with the benchmark SPY (0.63) in the period of the last 5 years, the ratio of return and volatility (Sharpe) of 0.75 of Microsoft is higher, thus better.
• During the last 3 years, the ratio of return and volatility (Sharpe) is 0.27, which is lower, thus worse than the value of 0.44 from the benchmark.

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 (0.89) in the period of the last 5 years, the ratio of annual return and downside deviation of 1.09 of Microsoft is higher, thus better.
• Compared with SPY (0.63) in the period of the last 3 years, the downside risk / excess return profile of 0.39 is smaller, thus worse.

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

• The Ulcer Index over 5 years of Microsoft is 13 , which is greater, thus worse compared to the benchmark SPY (9.32 ) in the same period.
• Compared with SPY (10 ) in the period of the last 3 years, the Downside risk index of 16 is higher, thus worse.

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

• Looking at the maximum DrawDown of -37.1 days in the last 5 years of Microsoft, we see it is relatively smaller, thus worse in comparison to the benchmark SPY (-33.7 days)
• Looking at maximum DrawDown in of -37 days in the period of the last 3 years, we see it is relatively smaller, thus worse in comparison to SPY (-24.5 days).

MaxDuration:

'The Maximum Drawdown Duration is an extension of the Maximum Drawdown. However, this metric does not explain the drawdown in dollars or percentages, rather in days, weeks, or months. It is the length of time the account was in the Max Drawdown. A Max Drawdown measures a retrenchment from when an equity curve reaches a new high. It’s the maximum an account lost during that retrenchment. This method is applied because a valley can’t be measured until a new high occurs. Once the new high is reached, the percentage change from the old high to the bottom of the largest trough is recorded.'

• Looking at the maximum days under water of 392 days in the last 5 years of Microsoft, we see it is relatively lower, thus better in comparison to the benchmark SPY (488 days)
• Compared with SPY (488 days) in the period of the last 3 years, the maximum days below previous high of 378 days is smaller, thus better.

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

• The average days under water over 5 years of Microsoft is 88 days, which is lower, thus better compared to the benchmark SPY (123 days) in the same period.
• During the last 3 years, the average days under water is 117 days, which is lower, thus better than the value of 178 days from the benchmark.