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 over 5 years of Microsoft is 212.9%, which is greater, thus better compared to the benchmark SPY (94.2%) in the same period.
• During the last 3 years, the total return, or increase in value is 48.2%, which is greater, thus better than the value of 27.9% from the benchmark.

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

• Looking at the annual performance (CAGR) of 25.7% in the last 5 years of Microsoft, we see it is relatively larger, thus better in comparison to the benchmark SPY (14.2%)
• During the last 3 years, the annual return (CAGR) is 14%, which is higher, thus better than the value of 8.6% 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 volatility over 5 years of Microsoft is 30.4%, which is greater, thus worse compared to the benchmark SPY (20.9%) in the same period.
• Compared with SPY (17.3%) in the period of the last 3 years, the 30 days standard deviation of 27.6% is greater, thus worse.

DownVol:

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

• Compared with the benchmark SPY (15%) in the period of the last 5 years, the downside volatility of 20.7% of Microsoft is greater, thus worse.
• Compared with SPY (12.1%) in the period of the last 3 years, the downside deviation of 18.9% is greater, thus worse.

Sharpe:

'The Sharpe ratio is the measure of risk-adjusted return of a financial portfolio. Sharpe ratio is a measure of excess portfolio return over the risk-free rate relative to its standard deviation. Normally, the 90-day Treasury bill rate is taken as the proxy for risk-free rate. A portfolio with a higher Sharpe ratio is considered superior relative to its peers. The measure was named after William F Sharpe, a Nobel laureate and professor of finance, emeritus at Stanford University.'

• Compared with the benchmark SPY (0.56) in the period of the last 5 years, the Sharpe Ratio of 0.76 of Microsoft is larger, thus better.
• Looking at ratio of return and volatility (Sharpe) in of 0.42 in the period of the last 3 years, we see it is relatively larger, thus better in comparison to SPY (0.35).

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.78) in the period of the last 5 years, the ratio of annual return and downside deviation of 1.12 of Microsoft is greater, thus better.
• Compared with SPY (0.5) in the period of the last 3 years, the ratio of annual return and downside deviation of 0.61 is greater, thus better.

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

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

• 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 (-33.7 days)
• During the last 3 years, the maximum drop from peak to valley is -37.1 days, which is smaller, thus worse than the value of -24.5 days from the benchmark.

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 below previous high 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 days under water is 392 days, which is smaller, thus better than the value of 488 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.'

• The average time in days below previous high water mark over 5 years of Microsoft is 84 days, which is smaller, thus better compared to the benchmark SPY (123 days) in the same period.
• During the last 3 years, the average time in days below previous high water mark is 120 days, which is smaller, thus better than the value of 180 days from the benchmark.