Description

Microsoft Corporation - Common Stock

Statistics (YTD)

What do these metrics mean? [Read More] [Hide]

TotalReturn:

'Total return is the amount of value an investor earns from a security over a specific period, typically one year, when all distributions are reinvested. Total return is expressed as a percentage of the amount invested. For example, a total return of 20% means the security increased by 20% of its original value due to a price increase, distribution of dividends (if a stock), coupons (if a bond) or capital gains (if a fund). Total return is a strong measure of an investment’s overall performance.'

Which means for our asset as example:
  • Compared with the benchmark SPY (88%) in the period of the last 5 years, the total return, or performance of 420.8% of Microsoft is greater, thus better.
  • During the last 3 years, the total return, or increase in value is 192.1%, which is greater, thus better than the value of 39.5% 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.'

Applying this definition to our asset in some examples:
  • The compounded annual growth rate (CAGR) over 5 years of Microsoft is 39.1%, which is greater, thus better compared to the benchmark SPY (13.5%) in the same period.
  • Compared with SPY (11.7%) in the period of the last 3 years, the annual performance (CAGR) of 42.9% is greater, thus better.

Volatility:

'Volatility is a statistical measure of the dispersion of returns for a given security or market index. Volatility can either be measured by using the standard deviation or variance between returns from that same security or market index. Commonly, the higher the volatility, the riskier the security. In the securities markets, volatility is often associated with big swings in either direction. For example, when the stock market rises and falls more than one percent over a sustained period of time, it is called a 'volatile' market.'

Using this definition on our asset we see for example:
  • The historical 30 days volatility over 5 years of Microsoft is 27.8%, which is greater, thus worse compared to the benchmark SPY (18.8%) in the same period.
  • During the last 3 years, the volatility is 31.7%, which is greater, thus worse than the value of 22.3% from the benchmark.

DownVol:

'Downside risk is the financial risk associated with losses. That is, it is the risk of the actual return being below the expected return, or the uncertainty about the magnitude of that difference. 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.'

Using this definition on our asset we see for example:
  • Looking at the downside volatility of 18.5% in the last 5 years of Microsoft, we see it is relatively larger, thus worse in comparison to the benchmark SPY (13.7%)
  • During the last 3 years, the downside risk is 21.4%, which is greater, thus worse than the value of 16.5% from the benchmark.

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

Using this definition on our asset we see for example:
  • The Sharpe Ratio over 5 years of Microsoft is 1.32, which is larger, thus better compared to the benchmark SPY (0.58) in the same period.
  • Looking at Sharpe Ratio in of 1.27 in the period of the last 3 years, we see it is relatively higher, thus better in comparison to SPY (0.41).

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

Using this definition on our asset we see for example:
  • Looking at the excess return divided by the downside deviation of 1.98 in the last 5 years of Microsoft, we see it is relatively greater, thus better in comparison to the benchmark SPY (0.8)
  • During the last 3 years, the downside risk / excess return profile is 1.88, which is larger, thus better than the value of 0.56 from the benchmark.

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

Which means for our asset as example:
  • Compared with the benchmark SPY (5.79 ) in the period of the last 5 years, the Ulcer Index of 5.17 of Microsoft is lower, thus better.
  • Looking at Downside risk index in of 5.66 in the period of the last 3 years, we see it is relatively lower, thus better in comparison to SPY (7.08 ).

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

Using this definition on our asset we see for example:
  • Compared with the benchmark SPY (-33.7 days) in the period of the last 5 years, the maximum DrawDown of -28 days of Microsoft is larger, thus better.
  • Looking at maximum DrawDown in of -28 days in the period of the last 3 years, we see it is relatively higher, thus better in comparison to SPY (-33.7 days).

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

Using this definition on our asset we see for example:
  • Compared with the benchmark SPY (139 days) in the period of the last 5 years, the maximum days below previous high of 112 days of Microsoft is lower, thus better.
  • Compared with SPY (139 days) in the period of the last 3 years, the maximum time in days below previous high water mark of 112 days is lower, thus better.

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

Applying this definition to our asset in some examples:
  • Compared with the benchmark SPY (37 days) in the period of the last 5 years, the average time in days below previous high water mark of 21 days of Microsoft is lower, thus better.
  • During the last 3 years, the average time in days below previous high water mark is 22 days, which is lower, thus better than the value of 45 days from the benchmark.

Performance (YTD)

Historical returns have been extended using synthetic data.

Allocations
()

Allocations

Returns (%)

  • Note that yearly returns do not equal the sum of monthly returns due to compounding.
  • Performance results of Microsoft are hypothetical, do not account for slippage, fees or taxes, and are based on backtesting, which has many inherent limitations, some of which are described in our Terms of Use.