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 (87.1%) in the period of the last 5 years, the total return, or increase in value of 241.3% of Microsoft is higher, thus better.
• Compared with SPY (26.8%) in the period of the last 3 years, the total return of 60.2% is greater, thus better.

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 (13.4%) in the period of the last 5 years, the compounded annual growth rate (CAGR) of 27.9% of Microsoft is larger, thus better.
• Compared with SPY (8.3%) in the period of the last 3 years, the compounded annual growth rate (CAGR) of 17.1% is larger, thus better.

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

• Looking at the 30 days standard deviation of 30.4% in the last 5 years of Microsoft, we see it is relatively larger, thus worse in comparison to the benchmark SPY (20.9%)
• During the last 3 years, the historical 30 days volatility is 27.4%, which is greater, thus worse than the value of 17.3% from the benchmark.

DownVol:

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

• The downside risk over 5 years of Microsoft is 20.6%, which is greater, thus worse compared to the benchmark SPY (15%) in the same period.
• Looking at downside volatility in of 18.6% in the period of the last 3 years, we see it is relatively larger, thus worse in comparison to SPY (12.1%).

Sharpe:

'The Sharpe ratio (also known as the Sharpe index, the Sharpe measure, and the reward-to-variability ratio) is a way to examine the performance of an investment by adjusting for its risk. The ratio measures the excess return (or risk premium) per unit of deviation in an investment asset or a trading strategy, typically referred to as risk, named after William F. Sharpe.'

• Compared with the benchmark SPY (0.52) in the period of the last 5 years, the risk / return profile (Sharpe) of 0.83 of Microsoft is higher, thus better.
• Compared with SPY (0.33) in the period of the last 3 years, the Sharpe Ratio of 0.53 is greater, thus better.

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

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

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 Ulcer Ratio over 5 years of Microsoft is 13 , which is larger, thus worse compared to the benchmark SPY (9.33 ) in the same period.
• Compared with SPY (10 ) in the period of the last 3 years, the Downside risk index of 15 is greater, thus worse.

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

• The maximum reduction from previous high over 5 years of Microsoft is -37.1 days, which is lower, thus worse compared to the benchmark SPY (-33.7 days) in the same period.
• Compared with SPY (-24.5 days) in the period of the last 3 years, the maximum DrawDown of -37.1 days is smaller, 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). 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'

• Compared with the benchmark SPY (488 days) in the period of the last 5 years, the maximum days below previous high of 392 days of Microsoft is lower, thus better.
• Compared with SPY (488 days) in the period of the last 3 years, the maximum days under water of 392 days is smaller, thus better.

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

• Looking at the average days under water of 84 days in the last 5 years of Microsoft, we see it is relatively smaller, thus better in comparison to the benchmark SPY (122 days)
• Looking at average days below previous high in of 120 days in the period of the last 3 years, we see it is relatively lower, thus better in comparison to SPY (179 days).