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

• Compared with the benchmark SPY (95.4%) in the period of the last 5 years, the total return of 126.6% of Microsoft is greater, thus better.
• Looking at total return, or increase in value in of 106.5% in the period of the last 3 years, we see it is relatively larger, thus better in comparison to SPY (85.5%).

CAGR:

'Compound annual growth rate (CAGR) is a business and investing specific term for the geometric progression ratio that provides a constant rate of return over the time period. CAGR is not an accounting term, but it is often used to describe some element of the business, for example revenue, units delivered, registered users, etc. CAGR dampens the effect of volatility of periodic returns that can render arithmetic means irrelevant. It is particularly useful to compare growth rates from various data sets of common domain such as revenue growth of companies in the same industry.'

• Looking at the annual performance (CAGR) of 17.9% in the last 5 years of Microsoft, we see it is relatively greater, thus better in comparison to the benchmark SPY (14.4%)
• During the last 3 years, the compounded annual growth rate (CAGR) is 27.5%, which is greater, thus better than the value of 23% from the benchmark.

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.1%) in the period of the last 5 years, the historical 30 days volatility of 25.7% of Microsoft is larger, thus worse.
• Looking at 30 days standard deviation in of 23.2% in the period of the last 3 years, we see it is relatively larger, thus worse in comparison to SPY (15.3%).

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 17.4% in the last 5 years of Microsoft, we see it is relatively higher, thus worse in comparison to the benchmark SPY (11.8%)
• Compared with SPY (10.2%) in the period of the last 3 years, the downside deviation of 15.1% is larger, thus worse.

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.7) in the period of the last 5 years, the risk / return profile (Sharpe) of 0.6 of Microsoft is lower, thus worse.
• During the last 3 years, the Sharpe Ratio is 1.08, which is lower, thus worse than the value of 1.34 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.'

• The downside risk / excess return profile over 5 years of Microsoft is 0.88, which is lower, thus worse compared to the benchmark SPY (1.01) in the same period.
• During the last 3 years, the downside risk / excess return profile is 1.65, which is smaller, thus worse than the value of 2.01 from the benchmark.

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

• Looking at the Ulcer Ratio of 13 in the last 5 years of Microsoft, we see it is relatively larger, thus worse in comparison to the benchmark SPY (8.42 )
• Compared with SPY (3.51 ) in the period of the last 3 years, the Downside risk index of 7.49 is greater, thus worse.

MaxDD:

'Maximum drawdown measures the loss in any losing period during a fund’s investment record. It is defined as the percent retrenchment from a fund’s peak value to the fund’s valley value. The drawdown is in effect from the time the fund’s retrenchment begins until a new fund high is reached. The maximum drawdown encompasses both the period from the fund’s peak to the fund’s valley (length), and the time from the fund’s valley to a new fund high (recovery). It measures the largest percentage drawdown that has occurred in any fund’s data record.'

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

• Looking at the maximum time in days below previous high water mark 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)
• During the last 3 years, the maximum days under water is 229 days, which is larger, thus worse than the value of 87 days from the benchmark.

AveDuration:

'The Average 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. 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 (119 days) in the period of the last 5 years, the average days below previous high of 99 days of Microsoft is lower, thus better.
• Compared with SPY (21 days) in the period of the last 3 years, the average days under water of 52 days is larger, thus worse.