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 (67.9%) in the period of the last 5 years, the total return, or increase in value of 260.2% of Microsoft is larger, thus better.
• Compared with SPY (46.6%) in the period of the last 3 years, the total return of 164.2% is larger, thus better.

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

• Compared with the benchmark SPY (10.9%) in the period of the last 5 years, the annual return (CAGR) of 29.2% of Microsoft is greater, 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 greater, thus better in comparison to SPY (13.6%).

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

• The volatility over 5 years of Microsoft is 23.2%, which is greater, thus worse compared to the benchmark SPY (13.3%) in the same period.
• Compared with SPY (12.5%) in the period of the last 3 years, the volatility of 21.7% is larger, thus worse.

DownVol:

'Downside risk is the financial risk associated with losses. That is, it is the risk of the actual return being below the expected return, or the uncertainty about the magnitude of that difference. 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 deviation over 5 years of Microsoft is 23.8%, which is higher, thus worse compared to the benchmark SPY (14.6%) in the same period.
• During the last 3 years, the downside risk is 22.9%, which is greater, thus worse than the value of 14.2% from the benchmark.

Sharpe:

'The Sharpe ratio was developed by Nobel laureate William F. Sharpe, and is used to help investors understand the return of an investment compared to its risk. The ratio is the average return earned in excess of the risk-free rate per unit of volatility or total risk. Subtracting the risk-free rate from the mean return allows an investor to better isolate the profits associated with risk-taking activities. One intuition of this calculation is that a portfolio engaging in 'zero risk' investments, such as the purchase of U.S. Treasury bills (for which the expected return is the risk-free rate), has a Sharpe ratio of exactly zero. Generally, the greater the value of the Sharpe ratio, the more attractive the risk-adjusted return.'

• Compared with the benchmark SPY (0.64) in the period of the last 5 years, the risk / return profile (Sharpe) of 1.15 of Microsoft is higher, thus better.
• During the last 3 years, the risk / return profile (Sharpe) is 1.65, which is higher, thus better than the value of 0.89 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.'

• The ratio of annual return and downside deviation over 5 years of Microsoft is 1.12, which is larger, thus better compared to the benchmark SPY (0.58) in the same period.
• 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 greater, thus better in comparison to SPY (0.78).

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 5.46 in the last 5 years of Microsoft, we see it is relatively greater, thus better in comparison to the benchmark SPY (3.96 )
• Compared with SPY (4.01 ) in the period of the last 3 years, the Ulcer Ratio of 3.67 is smaller, 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.'

• The maximum DrawDown over 5 years of Microsoft is -18.2 days, which is greater, thus better compared to the benchmark SPY (-19.3 days) in the same period.
• Compared with SPY (-19.3 days) in the period of the last 3 years, the maximum DrawDown of -18.2 days is higher, thus better.

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.
• During the last 3 years, the maximum days under water is 112 days, which is smaller, thus better than the value of 139 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.'

• The average days below previous high over 5 years of Microsoft is 29 days, which is lower, thus better compared to the benchmark SPY (41 days) in the same period.
• During the last 3 years, the average time in days below previous high water mark is 19 days, which is lower, thus better than the value of 36 days from the benchmark.