Paying users zone. Data is covered by hidden.

  • Get to Microsoft Corp. for $19.99, or

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

Microsoft Excel LibreOffice Calc


Profitability Analysis

Difficulty: Beginner


Ratios (Summary)

Microsoft Corp., profitability ratios

Microsoft Excel LibreOffice Calc
Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
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: 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), 10-K (filing date: 2013-07-30).

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 2016 to 2017 and from 2017 to 2018.
Operating profit margin A profitability ratio calculated as operating income divided by revenue. Microsoft Corp.’s operating profit margin improved from 2016 to 2017 and from 2017 to 2018.
Net profit margin An indicator of profitability, calculated as net income divided by revenue. Microsoft Corp.’s net profit margin improved from 2016 to 2017 but then deteriorated significantly from 2017 to 2018.

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

Gross Profit Margin

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

Microsoft Excel LibreOffice Calc
Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
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, Competitors
Adobe Systems 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
Oracle Corp. hidden hidden hidden hidden hidden hidden
salesforce.com inc. hidden hidden hidden hidden hidden hidden

Based on: 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), 10-K (filing date: 2013-07-30).

2018 Calculations

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

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 2016 to 2017 and from 2017 to 2018.

Operating Profit Margin

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

Microsoft Excel LibreOffice Calc
Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
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, Competitors
Adobe Systems 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
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: 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), 10-K (filing date: 2013-07-30).

2018 Calculations

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

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 2016 to 2017 and from 2017 to 2018.

Net Profit Margin

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

Microsoft Excel LibreOffice Calc
Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
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, Competitors
Adobe Systems 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
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: 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), 10-K (filing date: 2013-07-30).

2018 Calculations

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

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

Return on Equity (ROE)

Microsoft Corp., ROE calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
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, Competitors
Adobe Systems 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
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: 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), 10-K (filing date: 2013-07-30).

2018 Calculations

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

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

Return on Assets (ROA)

Microsoft Corp., ROA calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
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, Competitors
Adobe Systems 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
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: 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), 10-K (filing date: 2013-07-30).

2018 Calculations

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

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