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

• Compared with the benchmark SPY (91.7%) in the period of the last 5 years, the total return of 78.1% of Microsoft is lower, thus worse.
• Looking at total return, or performance in of 34.8% in the period of the last 3 years, we see it is relatively lower, thus worse in comparison to SPY (84.4%).

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 return (CAGR) of 12.3% in the last 5 years of Microsoft, we see it is relatively lower, thus worse in comparison to the benchmark SPY (14%)
• During the last 3 years, the compounded annual growth rate (CAGR) is 10.5%, which is lower, thus worse than the value of 22.7% 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.'

• Looking at the 30 days standard deviation of 26.4% in the last 5 years of Microsoft, we see it is relatively greater, thus worse in comparison to the benchmark SPY (17%)
• During the last 3 years, the 30 days standard deviation is 23.6%, which is larger, thus worse than the value of 15.1% from the benchmark.

DownVol:

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

• The downside volatility over 5 years of Microsoft is 18.2%, which is larger, thus worse compared to the benchmark SPY (11.7%) in the same period.
• Compared with SPY (10.1%) in the period of the last 3 years, the downside risk of 16.7% 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.67) in the period of the last 5 years, the Sharpe Ratio of 0.37 of Microsoft is lower, thus worse.
• Looking at ratio of return and volatility (Sharpe) in of 0.34 in the period of the last 3 years, we see it is relatively lower, thus worse in comparison to SPY (1.34).

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 (0.98) in the period of the last 5 years, the downside risk / excess return profile of 0.54 of Microsoft is lower, thus worse.
• Looking at downside risk / excess return profile in of 0.48 in the period of the last 3 years, we see it is relatively lower, thus worse in comparison to SPY (2).

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 15 , which is greater, thus worse compared to the benchmark SPY (8.45 ) in the same period.
• During the last 3 years, the Downside risk index is 11 , which is higher, thus worse than the value of 3.5 from the benchmark.

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

• Compared with the benchmark SPY (-24.5 days) in the period of the last 5 years, the maximum reduction from previous high 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 -33.9 days is lower, thus worse.

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

• 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 smaller, thus better.
• During the last 3 years, the maximum time in days below previous high water mark is 229 days, which is higher, 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 (120 days) in the period of the last 5 years, the average days under water of 105 days of Microsoft is lower, thus better.
• Compared with SPY (20 days) in the period of the last 3 years, the average days under water of 63 days is greater, thus worse.