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 over 5 years of Microsoft is 245.9%, which is higher, thus better compared to the benchmark SPY (66.7%) in the same period.
• Looking at total return, or increase in value in of 163.4% in the period of the last 3 years, we see it is relatively higher, thus better in comparison to SPY (46%).

CAGR:

'The compound annual growth rate (CAGR) is a useful measure of growth over multiple time periods. It can be thought of as the growth rate that gets you from the initial investment value to the ending investment value if you assume that the investment has been compounding over the time period.'

• Compared with the benchmark SPY (10.8%) in the period of the last 5 years, the annual performance (CAGR) of 28.2% of Microsoft is higher, thus better.
• Looking at compounded annual growth rate (CAGR) in of 38.2% in the period of the last 3 years, we see it is relatively larger, thus better in comparison to SPY (13.5%).

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

• Looking at the volatility of 23.3% in the last 5 years of Microsoft, we see it is relatively larger, thus worse in comparison to the benchmark SPY (13.4%)
• Looking at historical 30 days volatility in of 21.3% in the period of the last 3 years, we see it is relatively higher, thus worse in comparison to SPY (12.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 volatility of 24.1% in the last 5 years of Microsoft, we see it is relatively greater, thus worse in comparison to the benchmark SPY (14.6%)
• During the last 3 years, the downside deviation is 22.9%, which is higher, thus worse than the value of 13.9% 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.'

• Looking at the risk / return profile (Sharpe) of 1.1 in the last 5 years of Microsoft, we see it is relatively larger, thus better in comparison to the benchmark SPY (0.62)
• Looking at ratio of return and volatility (Sharpe) in of 1.67 in the period of the last 3 years, we see it is relatively larger, thus better in comparison to SPY (0.89).

Sortino:

'The Sortino ratio, a variation of the Sharpe ratio only factors in the downside, or negative volatility, rather than the total volatility used in calculating the Sharpe ratio. The theory behind the Sortino variation is that upside volatility is a plus for the investment, and it, therefore, should not be included in the risk calculation. Therefore, the Sortino ratio takes upside volatility out of the equation and uses only the downside standard deviation in its calculation instead of the total standard deviation that is used in calculating the Sharpe ratio.'

• Looking at the downside risk / excess return profile of 1.07 in the last 5 years of Microsoft, we see it is relatively greater, thus better in comparison to the benchmark SPY (0.57)
• Looking at excess return divided by the downside deviation in of 1.56 in the period of the last 3 years, we see it is relatively higher, thus better in comparison to SPY (0.79).

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

• Compared with the benchmark SPY (3.99 ) in the period of the last 5 years, the Downside risk index of 5.48 of Microsoft is greater, thus worse.
• Looking at Downside risk index in of 3.63 in the period of the last 3 years, we see it is relatively lower, thus better in comparison to SPY (4.04 ).

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 reduction from previous high of -18.2 days in the last 5 years of Microsoft, we see it is relatively larger, thus better in comparison to the benchmark SPY (-19.3 days)
• Looking at maximum reduction from previous high in of -18.2 days in the period of the last 3 years, we see it is relatively greater, thus better in comparison to SPY (-19.3 days).

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'

• The maximum days below previous high over 5 years of Microsoft is 124 days, which is smaller, thus better compared to the benchmark SPY (187 days) in the same period.
• Compared with SPY (139 days) in the period of the last 3 years, the maximum days under water of 112 days is lower, 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.'

• Looking at the average time in days below previous high water mark of 29 days in the last 5 years of Microsoft, we see it is relatively lower, thus better in comparison to the benchmark SPY (41 days)
• Looking at average time in days below previous high water mark in of 19 days in the period of the last 3 years, we see it is relatively lower, thus better in comparison to SPY (36 days).