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 158.9%, which is higher, thus better compared to the benchmark SPY (109.2%) in the same period.
• Compared with SPY (77.9%) in the period of the last 3 years, the total return, or performance of 113.2% is higher, 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.'

• The annual performance (CAGR) over 5 years of Microsoft is 21%, which is greater, thus better compared to the benchmark SPY (16%) in the same period.
• During the last 3 years, the annual performance (CAGR) is 28.9%, which is greater, thus better than the value of 21.3% from the benchmark.

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 historical 30 days volatility over 5 years of Microsoft is 26.1%, which is larger, thus worse compared to the benchmark SPY (17.3%) in the same period.
• Compared with SPY (16.8%) in the period of the last 3 years, the 30 days standard deviation of 25.5% is greater, thus worse.

DownVol:

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

• Compared with the benchmark SPY (11.9%) in the period of the last 5 years, the downside deviation of 17.6% of Microsoft is higher, thus worse.
• Looking at downside volatility in of 16.5% in the period of the last 3 years, we see it is relatively larger, thus worse in comparison to SPY (10.9%).

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 ratio of return and volatility (Sharpe) of 0.71 in the last 5 years of Microsoft, we see it is relatively lower, thus worse in comparison to the benchmark SPY (0.78)
• Looking at Sharpe Ratio in of 1.04 in the period of the last 3 years, we see it is relatively lower, thus worse in comparison to SPY (1.12).

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

• The excess return divided by the downside deviation over 5 years of Microsoft is 1.05, which is lower, thus worse compared to the benchmark SPY (1.13) in the same period.
• During the last 3 years, the excess return divided by the downside deviation is 1.6, which is lower, thus worse than the value of 1.72 from the benchmark.

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

• The Downside risk index over 5 years of Microsoft is 13 , which is higher, thus worse compared to the benchmark SPY (8.43 ) in the same period.
• Compared with SPY (3.76 ) in the period of the last 3 years, the Ulcer Index of 7.42 is larger, 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.'

• Looking at the maximum reduction from previous high of -37.1 days in the last 5 years of Microsoft, we see it is relatively smaller, thus worse in comparison to the benchmark SPY (-24.5 days)
• Compared with SPY (-18.8 days) in the period of the last 3 years, the maximum DrawDown of -23.7 days is lower, thus worse.

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

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

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 time in days below previous high water mark over 5 years of Microsoft is 99 days, which is lower, thus better compared to the benchmark SPY (120 days) in the same period.
• Looking at average days below previous high in of 50 days in the period of the last 3 years, we see it is relatively higher, thus worse in comparison to SPY (22 days).