Microsoft (MSFT)

TotalReturn:

'The total return on a portfolio of investments takes into account not only the capital appreciation on the portfolio, but also the income received on the portfolio. The income typically consists of interest, dividends, and securities lending fees. This contrasts with the price return, which takes into account only the capital gain on an investment.'

• The total return over 5 years of Microsoft is 262.7%, which is higher, thus better compared to the benchmark SPY (80.1%) in the same period.
• Looking at total return, or performance in of 82.6% in the period of the last 3 years, we see it is relatively larger, thus better in comparison to SPY (30.8%).

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 (12.5%) in the period of the last 5 years, the compounded annual growth rate (CAGR) of 29.5% of Microsoft is larger, thus better.
• During the last 3 years, the annual return (CAGR) is 22.3%, which is greater, thus better than the value of 9.4% from the benchmark.

Volatility:

'In finance, volatility (symbol σ) is the degree of variation of a trading price series over time as measured by the standard deviation of logarithmic returns. Historic volatility measures a time series of past market prices. Implied volatility looks forward in time, being derived from the market price of a market-traded derivative (in particular, an option). Commonly, the higher the volatility, the riskier the security.'

• The 30 days standard deviation over 5 years of Microsoft is 30.9%, which is greater, thus worse compared to the benchmark SPY (21.3%) in the same period.
• During the last 3 years, the historical 30 days volatility is 27.8%, which is higher, thus worse than the value of 17.6% from the benchmark.

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 volatility over 5 years of Microsoft is 20.9%, which is larger, thus worse compared to the benchmark SPY (15.3%) in the same period.
• During the last 3 years, the downside deviation is 18.8%, which is higher, thus worse than the value of 12.3% 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.'

• The risk / return profile (Sharpe) over 5 years of Microsoft is 0.87, which is greater, thus better compared to the benchmark SPY (0.47) in the same period.
• During the last 3 years, the risk / return profile (Sharpe) is 0.71, which is higher, thus better than the value of 0.39 from the benchmark.

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

• Looking at the ratio of annual return and downside deviation of 1.29 in the last 5 years of Microsoft, we see it is relatively larger, thus better in comparison to the benchmark SPY (0.66)
• Compared with SPY (0.56) in the period of the last 3 years, the ratio of annual return and downside deviation of 1.05 is higher, thus better.

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 Downside risk index over 5 years of Microsoft is 13 , which is greater, thus worse compared to the benchmark SPY (9.43 ) in the same period.
• During the last 3 years, the Ulcer Index is 15 , which is higher, thus worse than the value of 10 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.'

• Compared with the benchmark SPY (-33.7 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.
• During the last 3 years, the maximum DrawDown is -37.1 days, which is lower, thus worse than the value of -24.5 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) in days.'

• Looking at the maximum days below previous high of 392 days in the last 5 years of Microsoft, we see it is relatively lower, thus better in comparison to the benchmark SPY (478 days)
• During the last 3 years, the maximum days under water is 392 days, which is lower, thus better than the value of 478 days from the benchmark.

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 85 days, which is lower, thus better compared to the benchmark SPY (118 days) in the same period.
• Compared with SPY (173 days) in the period of the last 3 years, the average days below previous high of 121 days is lower, thus better.