Paying users zone. Data is hidden behind hidden.

  • Get 1-month access to Microsoft Corp. for $19.99, or

  • get full access to the entire website for at least 3 months from $49.99.


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Apple Pay Google Pay
Verified by Visa MasterCard SecureCode American Express SafeKey

This is a one-time payment. There is no automatic renewal.

Microsoft Excel LibreOffice Calc

Microsoft Corp. (MSFT)


Analysis of Investments

High level of difficulty


Investment Accounting Policy

Microsoft considers all highly liquid interest-earning investments with a maturity of three months or less at the date of purchase to be cash equivalents. The fair values of these investments approximate their carrying values. In general, investments with original maturities of greater than three months and remaining maturities of less than one year are classified as short-term investments. Investments with maturities beyond one year may be classified as short-term based on their highly liquid nature and because such marketable securities represent the investment of cash that is available for current operations.

Debt investments are classified as available-for-sale and realized gains and losses are recorded using the specific identification method. Changes in fair value, excluding other-than-temporary impairments, are recorded in OCI. Debt investments are impaired when a decline in fair value is judged to be other-than-temporary. Fair value is calculated based on publicly available market information or other estimates determined by management. Microsoft employs a systematic methodology on a quarterly basis that considers available quantitative and qualitative evidence in evaluating potential impairment of the investments. If the cost of an investment exceeds its fair value, Microsoft evaluates, among other factors, general market conditions, credit quality of debt instrument issuers, and the duration and extent to which the fair value is less than cost. Microsoft also evaluates whether Microsoft has plans to sell the security or it is more likely than not that Microsoft will be required to sell the security before recovery. In addition, Microsoft considers specific adverse conditions related to the financial health of and business outlook for the investee, including industry and sector performance, changes in technology, and operational and financing cash flow factors. Once a decline in fair value is determined to be other-than-temporary, an impairment charge is recorded in other income (expense), net and a new cost basis in the investment is established.

Equity investments with readily determinable fair values are measured at fair value. Equity investments without readily determinable fair values are measured using the equity method, or measured at cost with adjustments for observable changes in price or impairments (referred to as the measurement alternative). Microsoft performs a qualitative assessment on a quarterly basis and recognizes an impairment if there are sufficient indicators that the fair value of the investment is less than carrying value. Changes in value are recorded in other income (expense), net.

Microsoft lends certain fixed-income and equity securities to increase investment returns. These transactions are accounted for as secured borrowings and the loaned securities continue to be carried as investments on Microsoft’s consolidated balance sheets. Cash and/or security interests are received as collateral for the loaned securities with the amount determined based upon the underlying security lent and the creditworthiness of the borrower. Cash received is recorded as an asset with a corresponding liability.

Source: 10-K (filing date: 2019-08-01).


Adjustment to Net Income (Loss): Mark to Market Available-for-sale Securities

Microsoft Corp., adjustment to Net Income

US$ in millions

Microsoft Excel LibreOffice Calc
12 months ended Jun 30, 2019 Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014
Net income (as reported) hidden hidden hidden hidden hidden hidden
Add: Net change related to investments hidden hidden hidden hidden hidden hidden
Net income (adjusted) hidden hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2019-08-01), 10-K (filing date: 2018-08-03), 10-K (filing date: 2017-08-02), 10-K (filing date: 2016-07-28), 10-K (filing date: 2015-07-31), 10-K (filing date: 2014-07-31).


Adjusted Ratios: Mark to Market Available-for-sale Securities (Summary)

Microsoft Corp., adjusted ratios

Microsoft Excel LibreOffice Calc
Jun 30, 2019 Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014
Net Profit Margin
Reported net profit margin hidden hidden hidden hidden hidden hidden
Adjusted net profit margin hidden hidden hidden hidden hidden hidden
Return on Equity (ROE)
Reported ROE hidden hidden hidden hidden hidden hidden
Adjusted ROE hidden hidden hidden hidden hidden hidden
Return on Assets (ROA)
Reported ROA hidden hidden hidden hidden hidden hidden
Adjusted ROA hidden hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2019-08-01), 10-K (filing date: 2018-08-03), 10-K (filing date: 2017-08-02), 10-K (filing date: 2016-07-28), 10-K (filing date: 2015-07-31), 10-K (filing date: 2014-07-31).

Ratio Description The company
Adjusted net profit margin An indicator of profitability, calculated as adjusted net income divided by revenue. Microsoft Corp.’s adjusted net profit margin deteriorated from 2017 to 2018 but then improved from 2018 to 2019 exceeding 2017 level.
Adjusted ROE A profitability ratio calculated as adjusted net income divided by shareholders’ equity. Microsoft Corp.’s adjusted ROE deteriorated from 2017 to 2018 but then improved from 2018 to 2019 exceeding 2017 level.
Adjusted ROA A profitability ratio calculated as adjusted net income divided by total assets. Microsoft Corp.’s adjusted ROA deteriorated from 2017 to 2018 but then improved from 2018 to 2019 exceeding 2017 level.

Microsoft Corp., Ratios: Reported vs. Adjusted


Adjusted Net Profit Margin

Microsoft Excel LibreOffice Calc
Jun 30, 2019 Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014
As Reported
Selected Financial Data (US$ in millions)
Net income hidden hidden hidden hidden hidden hidden
Revenue hidden hidden hidden hidden hidden hidden
Ratio
Net profit margin1 hidden hidden hidden hidden hidden hidden
Adjusted: Mark to Market Available-for-sale Securities
Selected Financial Data (US$ in millions)
Adjusted net income hidden hidden hidden hidden hidden hidden
Revenue hidden hidden hidden hidden hidden hidden
Ratio
Adjusted net profit margin2 hidden hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2019-08-01), 10-K (filing date: 2018-08-03), 10-K (filing date: 2017-08-02), 10-K (filing date: 2016-07-28), 10-K (filing date: 2015-07-31), 10-K (filing date: 2014-07-31).

2019 Calculations

1 Net profit margin = 100 × Net income ÷ Revenue
= 100 × hidden ÷ hidden = hidden

2 Adjusted net profit margin = 100 × Adjusted net income ÷ Revenue
= 100 × hidden ÷ hidden = hidden

Ratio Description The company
Adjusted net profit margin An indicator of profitability, calculated as adjusted net income divided by revenue. Microsoft Corp.’s adjusted net profit margin deteriorated from 2017 to 2018 but then improved from 2018 to 2019 exceeding 2017 level.

Adjusted Return on Equity (ROE)

Microsoft Excel LibreOffice Calc
Jun 30, 2019 Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014
As Reported
Selected Financial Data (US$ in millions)
Net income hidden hidden hidden hidden hidden hidden
Stockholders’ equity hidden hidden hidden hidden hidden hidden
Ratio
ROE1 hidden hidden hidden hidden hidden hidden
Adjusted: Mark to Market Available-for-sale Securities
Selected Financial Data (US$ in millions)
Adjusted net income hidden hidden hidden hidden hidden hidden
Stockholders’ equity hidden hidden hidden hidden hidden hidden
Ratio
Adjusted ROE2 hidden hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2019-08-01), 10-K (filing date: 2018-08-03), 10-K (filing date: 2017-08-02), 10-K (filing date: 2016-07-28), 10-K (filing date: 2015-07-31), 10-K (filing date: 2014-07-31).

2019 Calculations

1 ROE = 100 × Net income ÷ Stockholders’ equity
= 100 × hidden ÷ hidden = hidden

2 Adjusted ROE = 100 × Adjusted net income ÷ Stockholders’ equity
= 100 × hidden ÷ hidden = hidden

Ratio Description The company
Adjusted ROE A profitability ratio calculated as adjusted net income divided by shareholders’ equity. Microsoft Corp.’s adjusted ROE deteriorated from 2017 to 2018 but then improved from 2018 to 2019 exceeding 2017 level.

Adjusted Return on Assets (ROA)

Microsoft Excel LibreOffice Calc
Jun 30, 2019 Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014
As Reported
Selected Financial Data (US$ in millions)
Net income hidden hidden hidden hidden hidden hidden
Total assets hidden hidden hidden hidden hidden hidden
Ratio
ROA1 hidden hidden hidden hidden hidden hidden
Adjusted: Mark to Market Available-for-sale Securities
Selected Financial Data (US$ in millions)
Adjusted net income hidden hidden hidden hidden hidden hidden
Total assets hidden hidden hidden hidden hidden hidden
Ratio
Adjusted ROA2 hidden hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2019-08-01), 10-K (filing date: 2018-08-03), 10-K (filing date: 2017-08-02), 10-K (filing date: 2016-07-28), 10-K (filing date: 2015-07-31), 10-K (filing date: 2014-07-31).

2019 Calculations

1 ROA = 100 × Net income ÷ Total assets
= 100 × hidden ÷ hidden = hidden

2 Adjusted ROA = 100 × Adjusted net income ÷ Total assets
= 100 × hidden ÷ hidden = hidden

Ratio Description The company
Adjusted ROA A profitability ratio calculated as adjusted net income divided by total assets. Microsoft Corp.’s adjusted ROA deteriorated from 2017 to 2018 but then improved from 2018 to 2019 exceeding 2017 level.