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

• Looking at the total return of 71.3% in the last 5 years of Microsoft, we see it is relatively smaller, thus worse in comparison to the benchmark SPY (84.9%)
• During the last 3 years, the total return, or increase in value is 38.8%, which is smaller, thus worse than the value of 80.2% from the benchmark.

CAGR:

'The compound annual growth rate isn't a true return rate, but rather a representational figure. It is essentially a number that describes the rate at which an investment would have grown if it had grown the same rate every year and the profits were reinvested at the end of each year. In reality, this sort of performance is unlikely. However, CAGR can be used to smooth returns so that they may be more easily understood when compared to alternative investments.'

• Compared with the benchmark SPY (13.1%) in the period of the last 5 years, the compounded annual growth rate (CAGR) of 11.4% of Microsoft is smaller, thus worse.
• Compared with SPY (21.8%) in the period of the last 3 years, the compounded annual growth rate (CAGR) of 11.6% is lower, thus worse.

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

• Looking at the volatility of 26.4% in the last 5 years of Microsoft, we see it is relatively larger, thus worse in comparison to the benchmark SPY (17.1%)
• Looking at volatility in of 23.5% in the period of the last 3 years, we see it is relatively greater, thus worse in comparison to SPY (15.2%).

DownVol:

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

• 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 (11.8%)
• During the last 3 years, the downside risk is 16.6%, which is higher, thus worse than the value of 10.1% from the benchmark.

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

• Looking at the Sharpe Ratio of 0.34 in the last 5 years of Microsoft, we see it is relatively smaller, thus worse in comparison to the benchmark SPY (0.62)
• During the last 3 years, the ratio of return and volatility (Sharpe) is 0.39, which is smaller, thus worse than the value of 1.27 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.'

• The ratio of annual return and downside deviation over 5 years of Microsoft is 0.49, which is lower, thus worse compared to the benchmark SPY (0.9) in the same period.
• Looking at downside risk / excess return profile in of 0.55 in the period of the last 3 years, we see it is relatively smaller, thus worse in comparison to SPY (1.91).

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

• Compared with the benchmark SPY (8.45 ) in the period of the last 5 years, the Ulcer Ratio of 14 of Microsoft is higher, thus worse.
• During the last 3 years, the Ulcer Ratio is 11 , which is greater, thus worse than the value of 3.5 from the benchmark.

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

• Looking at the maximum DrawDown of -37.1 days in the last 5 years of Microsoft, we see it is relatively lower, thus worse in comparison to the benchmark SPY (-24.5 days)
• Looking at maximum drop from peak to valley in of -33.9 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 time in days below previous high water mark of 392 days in the last 5 years of Microsoft, we see it is relatively smaller, thus better in comparison to the benchmark SPY (488 days)
• During the last 3 years, the maximum time in days below previous high water mark is 229 days, which is higher, thus worse than the value of 87 days from the benchmark.

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

• Compared with the benchmark SPY (119 days) in the period of the last 5 years, the average days under water of 103 days of Microsoft is lower, thus better.
• During the last 3 years, the average days under water is 61 days, which is larger, thus worse than the value of 20 days from the benchmark.