Paying users zone. Data is covered by hidden.


We accept:

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

Microsoft Excel LibreOffice Calc

Microsoft Corp. (MSFT)


Profitability Analysis

Difficulty: Beginner


Ratios (Summary)

Microsoft Corp., profitability ratios

Microsoft Excel LibreOffice Calc
Jun 30, 2019 Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014
Return on Sales
Gross profit margin hidden hidden hidden hidden hidden hidden
Operating profit margin hidden hidden hidden hidden hidden hidden
Net profit margin hidden hidden hidden hidden hidden hidden
Return on Investment
Return on equity (ROE) hidden hidden hidden hidden hidden hidden
Return on assets (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
Gross profit margin Gross profit margin indicates the percentage of revenue available to cover operating and other expenditures. Microsoft Corp.’s gross profit margin improved from 2017 to 2018 and from 2018 to 2019.
Operating profit margin A profitability ratio calculated as operating income divided by revenue. Microsoft Corp.’s operating profit margin improved from 2017 to 2018 and from 2018 to 2019.
Net profit margin An indicator of profitability, calculated as net income divided by revenue. Microsoft Corp.’s net profit margin deteriorated from 2017 to 2018 but then improved from 2018 to 2019 exceeding 2017 level.

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

Gross Profit Margin

Microsoft Corp., gross profit margin calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Jun 30, 2019 Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014
Selected Financial Data (USD $ in millions)
Gross margin hidden hidden hidden hidden hidden hidden
Revenue hidden hidden hidden hidden hidden hidden
Ratio
Gross profit margin1 hidden hidden hidden hidden hidden hidden
Benchmarks
Gross Profit Margin, Competitors2
Adobe Inc. hidden hidden hidden hidden hidden hidden
Alphabet Inc. hidden hidden hidden hidden hidden hidden
Facebook Inc. hidden hidden hidden hidden hidden hidden
International Business Machines Corp. hidden hidden hidden hidden hidden hidden
Intuit Inc. hidden hidden hidden hidden hidden hidden
Oracle Corp. hidden hidden hidden hidden hidden hidden
salesforce.com inc. 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).

1 2019 Calculation
Gross profit margin = 100 × Gross margin ÷ Revenue
= 100 × hidden ÷ hidden = hidden

2 Click competitor name to see calculations.

Ratio Description The company
Gross profit margin Gross profit margin indicates the percentage of revenue available to cover operating and other expenditures. Microsoft Corp.’s gross profit margin improved from 2017 to 2018 and from 2018 to 2019.

Operating Profit Margin

Microsoft Corp., operating profit margin calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Jun 30, 2019 Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014
Selected Financial Data (USD $ in millions)
Operating income hidden hidden hidden hidden hidden hidden
Revenue hidden hidden hidden hidden hidden hidden
Ratio
Operating profit margin1 hidden hidden hidden hidden hidden hidden
Benchmarks
Operating Profit Margin, Competitors2
Adobe Inc. hidden hidden hidden hidden hidden hidden
Alphabet Inc. hidden hidden hidden hidden hidden hidden
Facebook Inc. hidden hidden hidden hidden hidden hidden
International Business Machines Corp. hidden hidden hidden hidden hidden hidden
Intuit Inc. hidden hidden hidden hidden hidden hidden
Oracle Corp. hidden hidden hidden hidden hidden hidden
salesforce.com inc. hidden hidden hidden hidden hidden hidden
Operating Profit Margin, Sector
Software & Computer Services hidden hidden hidden hidden hidden hidden
Operating Profit Margin, Industry
Technology 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).

1 2019 Calculation
Operating profit margin = 100 × Operating income ÷ Revenue
= 100 × hidden ÷ hidden = hidden

2 Click competitor name to see calculations.

Ratio Description The company
Operating profit margin A profitability ratio calculated as operating income divided by revenue. Microsoft Corp.’s operating profit margin improved from 2017 to 2018 and from 2018 to 2019.

Net Profit Margin

Microsoft Corp., net profit margin calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Jun 30, 2019 Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014
Selected Financial Data (USD $ 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
Benchmarks
Net Profit Margin, Competitors2
Adobe Inc. hidden hidden hidden hidden hidden hidden
Alphabet Inc. hidden hidden hidden hidden hidden hidden
Facebook Inc. hidden hidden hidden hidden hidden hidden
International Business Machines Corp. hidden hidden hidden hidden hidden hidden
Intuit Inc. hidden hidden hidden hidden hidden hidden
Oracle Corp. hidden hidden hidden hidden hidden hidden
salesforce.com inc. hidden hidden hidden hidden hidden hidden
Net Profit Margin, Sector
Software & Computer Services hidden hidden hidden hidden hidden hidden
Net Profit Margin, Industry
Technology 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).

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

2 Click competitor name to see calculations.

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

Return on Equity (ROE)

Microsoft Corp., ROE calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Jun 30, 2019 Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014
Selected Financial Data (USD $ 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
Benchmarks
ROE, Competitors2
Adobe Inc. hidden hidden hidden hidden hidden hidden
Alphabet Inc. hidden hidden hidden hidden hidden hidden
Facebook Inc. hidden hidden hidden hidden hidden hidden
International Business Machines Corp. hidden hidden hidden hidden hidden hidden
Intuit Inc. hidden hidden hidden hidden hidden hidden
Oracle Corp. hidden hidden hidden hidden hidden hidden
salesforce.com inc. hidden hidden hidden hidden hidden hidden
ROE, Sector
Software & Computer Services hidden hidden hidden hidden hidden hidden
ROE, Industry
Technology 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).

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

2 Click competitor name to see calculations.

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

Return on Assets (ROA)

Microsoft Corp., ROA calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Jun 30, 2019 Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014
Selected Financial Data (USD $ 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
Benchmarks
ROA, Competitors2
Adobe Inc. hidden hidden hidden hidden hidden hidden
Alphabet Inc. hidden hidden hidden hidden hidden hidden
Facebook Inc. hidden hidden hidden hidden hidden hidden
International Business Machines Corp. hidden hidden hidden hidden hidden hidden
Intuit Inc. hidden hidden hidden hidden hidden hidden
Oracle Corp. hidden hidden hidden hidden hidden hidden
salesforce.com inc. hidden hidden hidden hidden hidden hidden
ROA, Sector
Software & Computer Services hidden hidden hidden hidden hidden hidden
ROA, Industry
Technology 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).

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

2 Click competitor name to see calculations.

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