Description

Microsoft Corporation develops, licenses, and supports software, services, devices, and solutions worldwide. Its Productivity and Business Processes segment offers Office, Exchange, SharePoint, Microsoft Teams, Office 365 Security and Compliance, and Skype for Business, as well as related Client Access Licenses (CAL); Skype, Outlook.com, and OneDrive; LinkedIn that includes Talent, Learning, Sales, and Marketing solutions, as well as premium subscriptions; and Dynamics 365, a set of cloud-based and on-premises business solutions for small and medium businesses, large organizations, and divisions of enterprises. Its Intelligent Cloud segment licenses SQL and Windows Servers, Visual Studio, System Center, and related CALs; GitHub that provides a collaboration platform and code hosting service for developers; and Azure, a cloud platform. It also offers support services and Microsoft consulting services to assist customers in developing, deploying, and managing Microsoft server and desktop solutions; and training and certification to developers and IT professionals on various Microsoft products. Its More Personal Computing segment provides Windows original equipment manufacturer (OEM) licensing and other non-volume licensing of the Windows operating system; Windows Commercial, such as volume licensing of the Windows operating system, Windows cloud services, and other Windows commercial offerings; patent licensing; Windows Internet of Things; and MSN advertising. It also offers Surface, PC accessories, PCs, tablets, gaming and entertainment consoles, and other intelligent devices; Gaming, including Xbox hardware, and Xbox content and services; video games and third-party video game royalties; and Search, including Bing and Microsoft advertising. It sells its products through OEMs, distributors, and resellers; and directly through digital marketplaces, online stores, and retail stores. The company was founded in 1975 and is headquartered in Redmond, Washington.

Statistics (YTD)

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

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

Which means for our asset as example:
  • Looking at the total return, or performance of 191.9% in the last 5 years of Microsoft, we see it is relatively larger, thus better in comparison to the benchmark SPY (101.9%)
  • Looking at total return, or performance in of 34.7% in the period of the last 3 years, we see it is relatively larger, thus better in comparison to SPY (33.5%).

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

Which means for our asset as example:
  • Compared with the benchmark SPY (15.1%) in the period of the last 5 years, the annual return (CAGR) of 23.9% of Microsoft is larger, thus better.
  • During the last 3 years, the annual performance (CAGR) is 10.5%, which is greater, thus better than the value of 10.1% from the benchmark.

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:
  • Compared with the benchmark SPY (21%) in the period of the last 5 years, the 30 days standard deviation of 30.5% of Microsoft is larger, thus worse.
  • Compared with SPY (17.5%) in the period of the last 3 years, the historical 30 days volatility of 27.5% is higher, thus worse.

DownVol:

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

Which means for our asset as example:
  • Compared with the benchmark SPY (15%) in the period of the last 5 years, the downside volatility of 20.9% of Microsoft is greater, thus worse.
  • Looking at downside volatility in of 19.2% in the period of the last 3 years, we see it is relatively larger, thus worse in comparison to SPY (12.3%).

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

Which means for our asset as example:
  • Looking at the risk / return profile (Sharpe) of 0.7 in the last 5 years of Microsoft, we see it is relatively greater, thus better in comparison to the benchmark SPY (0.6)
  • Looking at Sharpe Ratio in of 0.29 in the period of the last 3 years, we see it is relatively lower, thus worse in comparison to SPY (0.44).

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:
  • Compared with the benchmark SPY (0.84) in the period of the last 5 years, the excess return divided by the downside deviation of 1.03 of Microsoft is larger, thus better.
  • During the last 3 years, the excess return divided by the downside deviation is 0.42, which is lower, thus worse than the value of 0.62 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.'

Using this definition on our asset we see for example:
  • Looking at the Ulcer Ratio of 13 in the last 5 years of Microsoft, we see it is relatively greater, thus worse in comparison to the benchmark SPY (9.32 )
  • Looking at Downside risk index in of 16 in the period of the last 3 years, we see it is relatively greater, thus worse in comparison to SPY (10 ).

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 drop from peak to valley of -37.1 days of Microsoft is smaller, thus worse.
  • Looking at maximum drop from peak to valley in of -37 days in the period of the last 3 years, we see it is relatively smaller, thus worse in comparison to SPY (-24.5 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.'

Which means for our asset as example:
  • The maximum days under water over 5 years of Microsoft is 392 days, which is lower, thus better compared to the benchmark SPY (488 days) in the same period.
  • Compared with SPY (488 days) in the period of the last 3 years, the maximum time in days below previous high water mark of 368 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:
  • The average days under water over 5 years of Microsoft is 88 days, which is lower, thus better compared to the benchmark SPY (122 days) in the same period.
  • Compared with SPY (177 days) in the period of the last 3 years, the average time in days below previous high water mark of 113 days is lower, thus better.

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 and do not account for slippage, fees or taxes.