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

• The total return, or performance over 5 years of Microsoft is 145.8%, which is greater, thus better compared to the benchmark SPY (101.3%) in the same period.
• Looking at total return in of 116.5% in the period of the last 3 years, we see it is relatively larger, thus better in comparison to SPY (77.2%).

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 (15.1%) in the period of the last 5 years, the annual return (CAGR) of 19.8% of Microsoft is larger, thus better.
• Looking at compounded annual growth rate (CAGR) in of 29.5% in the period of the last 3 years, we see it is relatively larger, thus better in comparison to SPY (21.1%).

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 historical 30 days volatility over 5 years of Microsoft is 25.6%, which is greater, thus worse compared to the benchmark SPY (17.1%) in the same period.
• Compared with SPY (15.6%) in the period of the last 3 years, the volatility of 23.6% is greater, thus worse.

DownVol:

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

• Looking at the downside risk of 17.3% in the last 5 years of Microsoft, we see it is relatively higher, thus worse in comparison to the benchmark SPY (11.8%)
• Compared with SPY (10.4%) in the period of the last 3 years, the downside deviation of 15.2% is greater, thus worse.

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

• Looking at the risk / return profile (Sharpe) of 0.67 in the last 5 years of Microsoft, we see it is relatively smaller, thus worse in comparison to the benchmark SPY (0.74)
• Looking at risk / return profile (Sharpe) in of 1.15 in the period of the last 3 years, we see it is relatively smaller, thus worse in comparison to SPY (1.19).

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 excess return divided by the downside deviation of 1 in the last 5 years of Microsoft, we see it is relatively lower, thus worse in comparison to the benchmark SPY (1.07)
• Compared with SPY (1.79) in the period of the last 3 years, the ratio of annual return and downside deviation of 1.77 is lower, thus worse.

Ulcer:

'Ulcer Index is a method for measuring investment risk that addresses the real concerns of investors, unlike the widely used standard deviation of return. UI is a measure of the depth and duration of drawdowns in prices from earlier highs. Using Ulcer Index instead of standard deviation can lead to very different conclusions about investment risk and risk-adjusted return, especially when evaluating strategies that seek to avoid major declines in portfolio value (market timing, dynamic asset allocation, hedge funds, etc.). The Ulcer Index was originally developed in 1987. Since then, it has been widely recognized and adopted by the investment community. According to Nelson Freeburg, editor of Formula Research, Ulcer Index is “perhaps the most fully realized statistical portrait of risk there is.'

• Looking at the Ulcer Ratio of 13 in the last 5 years of Microsoft, we see it is relatively larger, thus worse in comparison to the benchmark SPY (8.41 )
• Compared with SPY (3.61 ) in the period of the last 3 years, the Downside risk index of 7.33 is greater, thus worse.

MaxDD:

'A maximum drawdown is the maximum loss from a peak to a trough of a portfolio, before a new peak is attained. Maximum Drawdown is an indicator of downside risk over a specified time period. It can be used both as a stand-alone measure or as an input into other metrics such as 'Return over Maximum Drawdown' and the Calmar Ratio. Maximum Drawdown is expressed in percentage terms.'

• The maximum drop from peak to valley over 5 years of Microsoft is -37.1 days, which is lower, thus worse compared to the benchmark SPY (-24.5 days) in the same period.
• Looking at maximum reduction from previous high in of -23.7 days in the period of the last 3 years, we see it is relatively lower, 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.'

• Looking at the maximum days under water of 392 days in the last 5 years of Microsoft, we see it is relatively lower, thus better in comparison to the benchmark SPY (488 days)
• Compared with SPY (87 days) in the period of the last 3 years, the maximum time in days below previous high water mark of 229 days is higher, thus worse.

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 99 days, which is smaller, thus better compared to the benchmark SPY (120 days) in the same period.
• Compared with SPY (21 days) in the period of the last 3 years, the average time in days below previous high water mark of 52 days is higher, thus worse.