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:

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

Using this definition on our asset we see for example:
  • Compared with the benchmark SPY (115.6%) in the period of the last 5 years, the total return, or performance of 338.8% of Microsoft is greater, thus better.
  • During the last 3 years, the total return, or performance is 147.6%, which is larger, thus better than the value of 43% from the benchmark.

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:
  • Looking at the annual performance (CAGR) of 34.4% in the last 5 years of Microsoft, we see it is relatively higher, thus better in comparison to the benchmark SPY (16.6%)
  • Looking at annual performance (CAGR) in of 35.2% in the period of the last 3 years, we see it is relatively greater, thus better in comparison to SPY (12.6%).

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

Applying this definition to our asset in some examples:
  • Looking at the historical 30 days volatility of 27.7% in the last 5 years of Microsoft, we see it is relatively greater, thus worse in comparison to the benchmark SPY (18.8%)
  • Compared with SPY (22.8%) in the period of the last 3 years, the historical 30 days volatility of 32.3% is higher, thus worse.

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 deviation of 18.7% in the last 5 years of Microsoft, we see it is relatively larger, thus worse in comparison to the benchmark SPY (13.6%)
  • During the last 3 years, the downside deviation is 22%, which is larger, thus worse than the value of 16.7% from the benchmark.

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

Using this definition on our asset we see for example:
  • Looking at the risk / return profile (Sharpe) of 1.15 in the last 5 years of Microsoft, we see it is relatively larger, thus better in comparison to the benchmark SPY (0.75)
  • Compared with SPY (0.44) in the period of the last 3 years, the Sharpe Ratio of 1.01 is larger, 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.'

Which means for our asset as example:
  • Compared with the benchmark SPY (1.04) in the period of the last 5 years, the excess return divided by the downside deviation of 1.7 of Microsoft is larger, thus better.
  • During the last 3 years, the ratio of annual return and downside deviation is 1.49, which is greater, thus better than the value of 0.61 from the benchmark.

Ulcer:

'The Ulcer Index is a technical indicator that measures downside risk, in terms of both the depth and duration of price declines. The index increases in value as the price moves farther away from a recent high and falls as the price rises to new highs. The indicator is usually calculated over a 14-day period, with the Ulcer Index showing the percentage drawdown a trader can expect from the high over that period. The greater the value of the Ulcer Index, the longer it takes for a stock to get back to the former high.'

Using this definition on our asset we see for example:
  • The Downside risk index over 5 years of Microsoft is 5.32 , which is lower, thus better compared to the benchmark SPY (5.59 ) in the same period.
  • Looking at Ulcer Index in of 6.13 in the period of the last 3 years, we see it is relatively lower, thus better in comparison to SPY (7.14 ).

MaxDD:

'Maximum drawdown measures the loss in any losing period during a fund’s investment record. It is defined as the percent retrenchment from a fund’s peak value to the fund’s valley value. The drawdown is in effect from the time the fund’s retrenchment begins until a new fund high is reached. The maximum drawdown encompasses both the period from the fund’s peak to the fund’s valley (length), and the time from the fund’s valley to a new fund high (recovery). It measures the largest percentage drawdown that has occurred in any fund’s data record.'

Which means for our asset as example:
  • Looking at the maximum reduction from previous high of -28 days in the last 5 years of Microsoft, we see it is relatively greater, thus better in comparison to the benchmark SPY (-33.7 days)
  • During the last 3 years, the maximum reduction from previous high is -28 days, which is greater, thus better than the value of -33.7 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.'

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 under water of 112 days of Microsoft is lower, thus better.
  • Compared with SPY (139 days) in the period of the last 3 years, the maximum days under water of 112 days is lower, 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.'

Applying this definition to our asset in some examples:
  • Looking at the average time in days below previous high water mark of 23 days in the last 5 years of Microsoft, we see it is relatively smaller, thus better in comparison to the benchmark SPY (33 days)
  • Compared with SPY (45 days) in the period of the last 3 years, the average time in days below previous high water mark of 27 days is smaller, 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, 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.