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)


Long-term Debt and Solvency Analysis

Difficulty: Beginner


Ratios (Summary)

Microsoft Corp., debt and solvency ratios

Microsoft Excel LibreOffice Calc
Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
Debt Ratios
Debt to equity hidden hidden hidden hidden hidden hidden
Debt to equity (including operating lease liability) hidden hidden hidden hidden hidden hidden
Debt to capital hidden hidden hidden hidden hidden hidden
Debt to capital (including operating lease liability) hidden hidden hidden hidden hidden hidden
Debt to assets hidden hidden hidden hidden hidden hidden
Debt to assets (including operating lease liability) hidden hidden hidden hidden hidden hidden
Financial leverage hidden hidden hidden hidden hidden hidden
Coverage Ratios
Interest coverage hidden hidden hidden hidden hidden hidden
Fixed charge coverage 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
Debt to equity ratio A solvency ratio calculated as total debt divided by total shareholders’ equity. Microsoft Corp.’s debt to equity ratio deteriorated from 2016 to 2017 but then improved from 2017 to 2018 not reaching 2016 level.
Debt to equity (including operating lease liability) ratio A solvency ratio calculated as total debt (including operating lease liability) divided by total shareholders’ equity. Microsoft Corp.’s debt to equity (including operating lease liability) ratio deteriorated from 2016 to 2017 but then slightly improved from 2017 to 2018.
Debt to capital ratio A solvency ratio calculated as total debt divided by total debt plus shareholders’ equity. Microsoft Corp.’s debt to capital ratio deteriorated from 2016 to 2017 but then improved from 2017 to 2018 not reaching 2016 level.
Debt to capital (including operating lease liability) ratio A solvency ratio calculated as total debt (including operating lease liability) divided by total debt (including operating lease liability) plus shareholders’ equity. Microsoft Corp.’s debt to capital (including operating lease liability) ratio deteriorated from 2016 to 2017 but then slightly improved from 2017 to 2018.
Debt to assets ratio A solvency ratio calculated as total debt divided by total assets. Microsoft Corp.’s debt to assets ratio deteriorated from 2016 to 2017 but then improved from 2017 to 2018 not reaching 2016 level.
Debt to assets (including operating lease liability) ratio A solvency ratio calculated as total debt (including operating lease liability) divided by total assets. Microsoft Corp.’s debt to assets (including operating lease liability) ratio deteriorated from 2016 to 2017 but then slightly improved from 2017 to 2018.
Financial leverage ratio A solvency ratio calculated as total assets divided by total shareholders’ equity. Microsoft Corp.’s financial leverage ratio deteriorated from 2016 to 2017 but then slightly improved from 2017 to 2018.

Ratio Description The company
Interest coverage ratio A solvency ratio calculated as EBIT divided by interest payments. Microsoft Corp.’s interest coverage ratio deteriorated from 2016 to 2017 but then improved from 2017 to 2018 not reaching 2016 level.
Fixed charge coverage ratio A solvency ratio calculated as earnings before fixed charges and tax divided by fixed charges. Microsoft Corp.’s fixed charge coverage ratio deteriorated from 2016 to 2017 but then improved from 2017 to 2018 not reaching 2016 level.

Debt to Equity

Microsoft Corp., debt to equity 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)
Short-term debt hidden hidden hidden hidden hidden hidden
Current portion of long-term debt hidden hidden hidden hidden hidden hidden
Long-term debt, excluding current portion hidden hidden hidden hidden hidden hidden
Total debt hidden hidden hidden hidden hidden hidden
 
Stockholders’ equity hidden hidden hidden hidden hidden hidden
Ratio
Debt to equity1 hidden hidden hidden hidden hidden hidden
Benchmarks
Debt to Equity, Competitors
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
Debt to Equity, Sector
Software & Computer Services hidden hidden hidden hidden hidden hidden
Debt to Equity, 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 Debt to equity = Total debt ÷ Stockholders’ equity
= hidden ÷ hidden = hidden

Ratio Description The company
Debt to equity ratio A solvency ratio calculated as total debt divided by total shareholders’ equity. Microsoft Corp.’s debt to equity ratio deteriorated from 2016 to 2017 but then improved from 2017 to 2018 not reaching 2016 level.

Debt to Equity (including Operating Lease Liability)

Microsoft Corp., debt to equity (including operating lease liability) 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)
Short-term debt hidden hidden hidden hidden hidden hidden
Current portion of long-term debt hidden hidden hidden hidden hidden hidden
Long-term debt, excluding current portion hidden hidden hidden hidden hidden hidden
Total debt hidden hidden hidden hidden hidden hidden
Current operating lease liabilities hidden hidden hidden hidden hidden hidden
Long-term operating lease liabilities hidden hidden hidden hidden hidden hidden
Total debt (including operating lease liability) hidden hidden hidden hidden hidden hidden
 
Stockholders’ equity hidden hidden hidden hidden hidden hidden
Ratio
Debt to equity (including operating lease liability)1 hidden hidden hidden hidden hidden hidden
Benchmarks
Debt to Equity (including Operating Lease Liability), Sector
Software & Computer Services hidden hidden hidden hidden hidden hidden
Debt to Equity (including Operating Lease Liability), 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 Debt to equity (including operating lease liability) = Total debt (including operating lease liability) ÷ Stockholders’ equity
= hidden ÷ hidden = hidden

Ratio Description The company
Debt to equity (including operating lease liability) ratio A solvency ratio calculated as total debt (including operating lease liability) divided by total shareholders’ equity. Microsoft Corp.’s debt to equity (including operating lease liability) ratio deteriorated from 2016 to 2017 but then slightly improved from 2017 to 2018.

Debt to Capital

Microsoft Corp., debt to capital 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)
Short-term debt hidden hidden hidden hidden hidden hidden
Current portion of long-term debt hidden hidden hidden hidden hidden hidden
Long-term debt, excluding current portion hidden hidden hidden hidden hidden hidden
Total debt hidden hidden hidden hidden hidden hidden
Stockholders’ equity hidden hidden hidden hidden hidden hidden
Total capital hidden hidden hidden hidden hidden hidden
Ratio
Debt to capital1 hidden hidden hidden hidden hidden hidden
Benchmarks
Debt to Capital, Competitors
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
Debt to Capital, Sector
Software & Computer Services hidden hidden hidden hidden hidden hidden
Debt to Capital, 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 Debt to capital = Total debt ÷ Total capital
= hidden ÷ hidden = hidden

Ratio Description The company
Debt to capital ratio A solvency ratio calculated as total debt divided by total debt plus shareholders’ equity. Microsoft Corp.’s debt to capital ratio deteriorated from 2016 to 2017 but then improved from 2017 to 2018 not reaching 2016 level.

Debt to Capital (including Operating Lease Liability)

Microsoft Corp., debt to capital (including operating lease liability) 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)
Short-term debt hidden hidden hidden hidden hidden hidden
Current portion of long-term debt hidden hidden hidden hidden hidden hidden
Long-term debt, excluding current portion hidden hidden hidden hidden hidden hidden
Total debt hidden hidden hidden hidden hidden hidden
Current operating lease liabilities hidden hidden hidden hidden hidden hidden
Long-term operating lease liabilities hidden hidden hidden hidden hidden hidden
Total debt (including operating lease liability) hidden hidden hidden hidden hidden hidden
Stockholders’ equity hidden hidden hidden hidden hidden hidden
Total capital (including operating lease liability) hidden hidden hidden hidden hidden hidden
Ratio
Debt to capital (including operating lease liability)1 hidden hidden hidden hidden hidden hidden
Benchmarks
Debt to Capital (including Operating Lease Liability), Sector
Software & Computer Services hidden hidden hidden hidden hidden hidden
Debt to Capital (including Operating Lease Liability), 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 Debt to capital (including operating lease liability) = Total debt (including operating lease liability) ÷ Total capital (including operating lease liability)
= hidden ÷ hidden = hidden

Ratio Description The company
Debt to capital (including operating lease liability) ratio A solvency ratio calculated as total debt (including operating lease liability) divided by total debt (including operating lease liability) plus shareholders’ equity. Microsoft Corp.’s debt to capital (including operating lease liability) ratio deteriorated from 2016 to 2017 but then slightly improved from 2017 to 2018.

Debt to Assets

Microsoft Corp., debt to assets 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)
Short-term debt hidden hidden hidden hidden hidden hidden
Current portion of long-term debt hidden hidden hidden hidden hidden hidden
Long-term debt, excluding current portion hidden hidden hidden hidden hidden hidden
Total debt hidden hidden hidden hidden hidden hidden
 
Total assets hidden hidden hidden hidden hidden hidden
Ratio
Debt to assets1 hidden hidden hidden hidden hidden hidden
Benchmarks
Debt to Assets, Competitors
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
Debt to Assets, Sector
Software & Computer Services hidden hidden hidden hidden hidden hidden
Debt to Assets, 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 Debt to assets = Total debt ÷ Total assets
= hidden ÷ hidden = hidden

Ratio Description The company
Debt to assets ratio A solvency ratio calculated as total debt divided by total assets. Microsoft Corp.’s debt to assets ratio deteriorated from 2016 to 2017 but then improved from 2017 to 2018 not reaching 2016 level.

Debt to Assets (including Operating Lease Liability)

Microsoft Corp., debt to assets (including operating lease liability) 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)
Short-term debt hidden hidden hidden hidden hidden hidden
Current portion of long-term debt hidden hidden hidden hidden hidden hidden
Long-term debt, excluding current portion hidden hidden hidden hidden hidden hidden
Total debt hidden hidden hidden hidden hidden hidden
Current operating lease liabilities hidden hidden hidden hidden hidden hidden
Long-term operating lease liabilities hidden hidden hidden hidden hidden hidden
Total debt (including operating lease liability) hidden hidden hidden hidden hidden hidden
 
Total assets hidden hidden hidden hidden hidden hidden
Ratio
Debt to assets (including operating lease liability)1 hidden hidden hidden hidden hidden hidden
Benchmarks
Debt to Assets (including Operating Lease Liability), Sector
Software & Computer Services hidden hidden hidden hidden hidden hidden
Debt to Assets (including Operating Lease Liability), 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 Debt to assets (including operating lease liability) = Total debt (including operating lease liability) ÷ Total assets
= hidden ÷ hidden = hidden

Ratio Description The company
Debt to assets (including operating lease liability) ratio A solvency ratio calculated as total debt (including operating lease liability) divided by total assets. Microsoft Corp.’s debt to assets (including operating lease liability) ratio deteriorated from 2016 to 2017 but then slightly improved from 2017 to 2018.

Financial Leverage

Microsoft Corp., financial leverage 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)
Total assets hidden hidden hidden hidden hidden hidden
Stockholders’ equity hidden hidden hidden hidden hidden hidden
Ratio
Financial leverage1 hidden hidden hidden hidden hidden hidden
Benchmarks
Financial Leverage, Competitors
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
Financial Leverage, Sector
Software & Computer Services hidden hidden hidden hidden hidden hidden
Financial Leverage, 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 Financial leverage = Total assets ÷ Stockholders’ equity
= hidden ÷ hidden = hidden

Ratio Description The company
Financial leverage ratio A solvency ratio calculated as total assets divided by total shareholders’ equity. Microsoft Corp.’s financial leverage ratio deteriorated from 2016 to 2017 but then slightly improved from 2017 to 2018.

Interest Coverage

Microsoft Corp., interest coverage 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
Add: Income tax expense hidden hidden hidden hidden hidden hidden
Add: Interest expense hidden hidden hidden hidden hidden hidden
Earnings before interest and tax (EBIT) hidden hidden hidden hidden hidden hidden
Ratio
Interest coverage1 hidden hidden hidden hidden hidden hidden
Benchmarks
Interest Coverage, Competitors
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
Interest Coverage, Sector
Software & Computer Services hidden hidden hidden hidden hidden hidden
Interest Coverage, 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 Interest coverage = EBIT ÷ Interest expense
= hidden ÷ hidden = hidden

Ratio Description The company
Interest coverage ratio A solvency ratio calculated as EBIT divided by interest payments. Microsoft Corp.’s interest coverage ratio deteriorated from 2016 to 2017 but then improved from 2017 to 2018 not reaching 2016 level.

Fixed Charge Coverage

Microsoft Corp., fixed charge coverage 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
Add: Income tax expense hidden hidden hidden hidden hidden hidden
Add: Interest expense hidden hidden hidden hidden hidden hidden
Earnings before interest and tax (EBIT) hidden hidden hidden hidden hidden hidden
Add: Operating lease cost hidden hidden hidden hidden hidden hidden
Earnings before fixed charges and tax hidden hidden hidden hidden hidden hidden
 
Interest expense hidden hidden hidden hidden hidden hidden
Operating lease cost hidden hidden hidden hidden hidden hidden
Fixed charges hidden hidden hidden hidden hidden hidden
Ratio
Fixed charge coverage1 hidden hidden hidden hidden hidden hidden
Benchmarks
Fixed Charge Coverage, Competitors
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
Fixed Charge Coverage, Sector
Software & Computer Services hidden hidden hidden hidden hidden hidden
Fixed Charge Coverage, 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 Fixed charge coverage = Earnings before fixed charges and tax ÷ Fixed charges
= hidden ÷ hidden = hidden

Ratio Description The company
Fixed charge coverage ratio A solvency ratio calculated as earnings before fixed charges and tax divided by fixed charges. Microsoft Corp.’s fixed charge coverage ratio deteriorated from 2016 to 2017 but then improved from 2017 to 2018 not reaching 2016 level.