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:
  • Compared with the benchmark SPY (94.8%) in the period of the last 5 years, the total return, or performance of 273.6% of Microsoft is higher, thus better.
  • Compared with SPY (31.6%) in the period of the last 3 years, the total return of 71.7% is higher, thus better.

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

Using this definition on our asset we see for example:
  • Compared with the benchmark SPY (14.3%) in the period of the last 5 years, the compounded annual growth rate (CAGR) of 30.2% of Microsoft is larger, thus better.
  • Compared with SPY (9.6%) in the period of the last 3 years, the annual performance (CAGR) of 19.7% is greater, thus better.

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

Applying this definition to our asset in some examples:
  • The volatility over 5 years of Microsoft is 30.4%, which is higher, 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 volatility of 27.3% is larger, 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.'

Applying this definition to our asset in some examples:
  • Compared with the benchmark SPY (15%) in the period of the last 5 years, the downside risk of 20.6% of Microsoft is greater, thus worse.
  • Looking at downside risk in of 18.5% in the period of the last 3 years, we see it is relatively larger, thus worse in comparison to SPY (12.1%).

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

Applying this definition to our asset in some examples:
  • Compared with the benchmark SPY (0.56) in the period of the last 5 years, the Sharpe Ratio of 0.91 of Microsoft is larger, thus better.
  • During the last 3 years, the risk / return profile (Sharpe) is 0.63, which is higher, thus better than the value of 0.41 from the benchmark.

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:
  • The downside risk / excess return profile over 5 years of Microsoft is 1.35, which is higher, thus better compared to the benchmark SPY (0.79) in the same period.
  • During the last 3 years, the downside risk / excess return profile is 0.93, which is greater, thus better than the value of 0.59 from the benchmark.

Ulcer:

'Ulcer Index is a method for measuring investment risk that addresses the real concerns of investors, unlike the widely used standard deviation of return. UI is a measure of the depth and duration of drawdowns in prices from earlier highs. Using Ulcer Index instead of standard deviation can lead to very different conclusions about investment risk and risk-adjusted return, especially when evaluating strategies that seek to avoid major declines in portfolio value (market timing, dynamic asset allocation, hedge funds, etc.). The Ulcer Index was originally developed in 1987. Since then, it has been widely recognized and adopted by the investment community. According to Nelson Freeburg, editor of Formula Research, Ulcer Index is “perhaps the most fully realized statistical portrait of risk there is.'

Using this definition on our asset we see for example:
  • Compared with the benchmark SPY (9.33 ) in the period of the last 5 years, the Ulcer Index of 13 of Microsoft is greater, thus worse.
  • Looking at Ulcer Ratio in of 15 in the period of the last 3 years, we see it is relatively larger, thus worse in comparison to SPY (10 ).

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

Applying this definition to our asset in some examples:
  • 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 lower, thus worse.
  • Compared with SPY (-24.5 days) in the period of the last 3 years, the maximum drop from peak to valley of -37.1 days is smaller, thus worse.

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:
  • Looking at the maximum days below previous high of 392 days in the last 5 years of Microsoft, we see it is relatively lower, 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 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.'

Which means for our asset as example:
  • Looking at the average days under water of 84 days in the last 5 years of Microsoft, we see it is relatively lower, thus better in comparison to the benchmark SPY (123 days)
  • Looking at average time in days below previous high water mark in of 120 days in the period of the last 3 years, we see it is relatively smaller, thus better in comparison to SPY (179 days).

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.