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

• Compared with the benchmark SPY (115.1%) in the period of the last 5 years, the total return of 152.4% of Microsoft is higher, thus better.
• Looking at total return in of 97% in the period of the last 3 years, we see it is relatively larger, thus better in comparison to SPY (71.1%).

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

• The annual return (CAGR) over 5 years of Microsoft is 20.4%, which is greater, thus better compared to the benchmark SPY (16.6%) in the same period.
• Compared with SPY (19.7%) in the period of the last 3 years, the compounded annual growth rate (CAGR) of 25.5% is larger, thus better.

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 26.9%, which is greater, thus worse compared to the benchmark SPY (17.5%) in the same period.
• Looking at 30 days standard deviation in of 26.4% in the period of the last 3 years, we see it is relatively higher, 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 volatility of 18.3% in the last 5 years of Microsoft, we see it is relatively larger, thus worse in comparison to the benchmark SPY (12.1%)
• During the last 3 years, the downside deviation is 17.3%, which is greater, thus worse than the value of 11.5% 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 ratio of return and volatility (Sharpe) over 5 years of Microsoft is 0.67, which is lower, thus worse compared to the benchmark SPY (0.8) in the same period.
• During the last 3 years, the Sharpe Ratio is 0.87, which is smaller, thus worse than the value of 0.98 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 (1.17) in the period of the last 5 years, the excess return divided by the downside deviation of 0.98 of Microsoft is lower, thus worse.
• Compared with SPY (1.49) in the period of the last 3 years, the downside risk / excess return profile of 1.33 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 Downside risk index over 5 years of Microsoft is 13 , which is greater, thus worse compared to the benchmark SPY (8.48 ) in the same period.
• Looking at Downside risk index in of 9.96 in the period of the last 3 years, we see it is relatively higher, thus worse in comparison to SPY (5.31 ).

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 drop from peak to valley of -37.1 days of Microsoft is lower, thus worse.
• Looking at maximum reduction from previous high in of -26.8 days in the period of the last 3 years, we see it is relatively smaller, thus worse in comparison to SPY (-18.8 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.'

• 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.
• Compared with SPY (199 days) in the period of the last 3 years, the maximum days under water of 229 days is larger, thus worse.

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

• The average days under water over 5 years of Microsoft is 101 days, which is lower, thus better compared to the benchmark SPY (120 days) in the same period.
• Compared with SPY (47 days) in the period of the last 3 years, the average time in days below previous high water mark of 66 days is higher, thus worse.