Microsoft Excel LibreOffice Calc

Microsoft Corp. (MSFT)

Long-term Debt and Solvency Analysis
Quarterly Data

Difficulty: Beginner

Solvency ratios also known as long-term debt ratios measure a company’s ability to meet long-term obligations.

Ratios (Summary)

Microsoft Corp., debt and solvency ratios (quarterly data)

Microsoft Excel LibreOffice Calc
Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014 Dec 31, 2013 Sep 30, 2013
Debt Ratios
Debt to equity 0.71 0.77 0.79 0.89 0.92 0.97 1.14 0.95 1.19 1.20 1.23 1.06 0.75 0.62 0.58 0.50 0.44 0.35 0.31 0.26 0.25 0.26 0.27 0.20
Debt to equity (including operating lease liability) 0.77 0.83 0.86 0.95 0.99 1.05 1.21 1.02 1.19 1.20 1.23 1.06 0.75 0.62 0.58 0.50 0.44 0.35 0.31 0.26 0.25 0.26 0.27 0.20
Debt to capital 0.41 0.44 0.44 0.47 0.48 0.49 0.53 0.49 0.54 0.55 0.55 0.51 0.43 0.38 0.37 0.33 0.31 0.26 0.24 0.21 0.20 0.21 0.21 0.16
Debt to capital (including operating lease liability) 0.43 0.45 0.46 0.49 0.50 0.51 0.55 0.50 0.54 0.55 0.55 0.51 0.43 0.38 0.37 0.33 0.31 0.26 0.24 0.21 0.20 0.21 0.21 0.16
Debt to assets 0.25 0.28 0.28 0.30 0.29 0.31 0.35 0.34 0.36 0.37 0.38 0.35 0.28 0.26 0.25 0.22 0.20 0.18 0.16 0.14 0.13 0.15 0.15 0.11
Debt to assets (including operating lease liability) 0.27 0.30 0.30 0.32 0.32 0.34 0.37 0.37 0.36 0.37 0.38 0.35 0.28 0.26 0.25 0.22 0.20 0.18 0.16 0.14 0.13 0.15 0.15 0.11
Financial leverage 2.80 2.78 2.81 3.00 3.13 3.10 3.27 2.78 3.33 3.23 3.26 3.02 2.69 2.43 2.35 2.23 2.20 1.96 1.90 1.88 1.92 1.79 1.80 1.74

Based on: 10-K (filing date: 2019-08-01), 10-Q (filing date: 2019-04-24), 10-Q (filing date: 2019-01-30), 10-Q (filing date: 2018-10-24), 10-K (filing date: 2018-08-03), 10-Q (filing date: 2018-04-26), 10-Q (filing date: 2018-01-31), 10-Q (filing date: 2017-10-26), 10-K (filing date: 2017-08-02), 10-Q (filing date: 2017-04-27), 10-Q (filing date: 2017-01-26), 10-Q (filing date: 2016-10-20), 10-K (filing date: 2016-07-28), 10-Q (filing date: 2016-04-21), 10-Q (filing date: 2016-01-28), 10-Q (filing date: 2015-10-22), 10-K (filing date: 2015-07-31), 10-Q (filing date: 2015-04-23), 10-Q (filing date: 2015-01-26), 10-Q (filing date: 2014-10-23), 10-K (filing date: 2014-07-31), 10-Q (filing date: 2014-04-24), 10-Q (filing date: 2014-01-23), 10-Q (filing date: 2013-10-24).

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 improved from Q2 2019 to Q3 2019 and from Q3 2019 to Q4 2019.
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 improved from Q2 2019 to Q3 2019 and from Q3 2019 to Q4 2019.
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 improved from Q2 2019 to Q3 2019 and from Q3 2019 to Q4 2019.
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 improved from Q2 2019 to Q3 2019 and from Q3 2019 to Q4 2019.
Debt to assets ratio A solvency ratio calculated as total debt divided by total assets. Microsoft Corp.’s debt to assets ratio improved from Q2 2019 to Q3 2019 and from Q3 2019 to Q4 2019.
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 improved from Q2 2019 to Q3 2019 and from Q3 2019 to Q4 2019.
Financial leverage ratio A solvency ratio calculated as total assets divided by total shareholders’ equity. Microsoft Corp.’s financial leverage ratio improved from Q2 2019 to Q3 2019 but then slightly deteriorated from Q3 2019 to Q4 2019 not reaching Q2 2019 level.

Debt to Equity

Microsoft Corp., debt to equity calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014 Dec 31, 2013 Sep 30, 2013
Selected Financial Data (USD $ in millions)
Short-term debt —  —  —  —  —  230  12,466  8,170  9,072  7,187  25,065  14,536  12,904  5,498  3,000  9,998  4,985  1,725  8,299  3,500  2,000  —  300  1,300 
Current portion of long-term debt 5,516  6,515  3,516  6,497  3,998  3,447  3,446  1,050  1,049  599  599  —  —  —  750  750  2,499  2,499  1,749  1,748  —  2,000  2,000  2,000 
Long-term debt, excluding current portion 66,662  66,585  69,653  69,733  72,242  73,480  73,348  76,255  76,073  76,222  59,306  60,154  40,783  40,896  40,679  27,819  27,808  27,644  18,260  18,472  20,645  20,679  20,676  12,632 
Total debt 72,178  73,100  73,169  76,230  76,240  77,157  89,260  85,475  86,194  84,008  84,970  74,690  53,687  46,394  44,429  38,567  35,292  31,868  28,308  23,720  22,645  22,679  22,976  15,932 
 
Stockholders’ equity 102,330  94,864  92,128  85,967  82,718  79,239  78,360  89,647  72,394  69,729  68,809  70,372  71,997  74,806  76,780  77,445  80,083  90,132  91,879  90,170  89,784  87,424  85,100  81,641 
Ratio
Debt to equity1 0.71 0.77 0.79 0.89 0.92 0.97 1.14 0.95 1.19 1.20 1.23 1.06 0.75 0.62 0.58 0.50 0.44 0.35 0.31 0.26 0.25 0.26 0.27 0.20
Benchmarks
Debt to Equity, Competitors2
Adobe Inc. — — 0.42 0.42 0.44 0.21 0.22 0.22 0.22 0.23 0.24 0.25 0.26 0.26 0.26 0.27 0.27 0.28 0.29 0.29 0.22 0.22 0.23 0.23
Alphabet Inc. — — 0.02 0.02 0.02 0.02 0.02 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.04 0.04 0.05 0.05 0.05 0.05 0.05 0.05 0.07
Facebook Inc. — — 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.01 0.01 0.02 0.02
International Business Machines Corp. — — 4.14 3.03 2.73 2.37 2.46 2.55 2.66 2.32 2.48 2.33 2.31 2.50 2.83 3.05 2.80 2.98 2.83 3.20 3.44 3.21 2.67 2.65
Intuit Inc. 0.12 0.11 0.15 0.15 0.19 0.19 0.95 0.73 0.36 0.29 1.46 1.18 0.86 0.80 1.94 0.81 0.21 0.21 0.21 0.17 0.16 0.15 0.22 0.22
Oracle Corp. 2.58 2.37 1.90 1.53 1.33 1.27 1.09 0.95 1.08 1.07 1.12 1.14 0.93 0.87 0.91 0.89 0.86 0.67 0.68 0.69 0.52 0.54 0.55 0.55
salesforce.com inc. 0.20 0.25 0.27 0.29 0.18 0.21 0.22 0.23 0.27 0.27 0.29 0.23 0.26 0.27 0.28 0.30 0.34 0.41 0.48 0.51 0.62 0.64 0.66 0.63

Based on: 10-K (filing date: 2019-08-01), 10-Q (filing date: 2019-04-24), 10-Q (filing date: 2019-01-30), 10-Q (filing date: 2018-10-24), 10-K (filing date: 2018-08-03), 10-Q (filing date: 2018-04-26), 10-Q (filing date: 2018-01-31), 10-Q (filing date: 2017-10-26), 10-K (filing date: 2017-08-02), 10-Q (filing date: 2017-04-27), 10-Q (filing date: 2017-01-26), 10-Q (filing date: 2016-10-20), 10-K (filing date: 2016-07-28), 10-Q (filing date: 2016-04-21), 10-Q (filing date: 2016-01-28), 10-Q (filing date: 2015-10-22), 10-K (filing date: 2015-07-31), 10-Q (filing date: 2015-04-23), 10-Q (filing date: 2015-01-26), 10-Q (filing date: 2014-10-23), 10-K (filing date: 2014-07-31), 10-Q (filing date: 2014-04-24), 10-Q (filing date: 2014-01-23), 10-Q (filing date: 2013-10-24).

1 Q4 2019 Calculation
Debt to equity = Total debt ÷ Stockholders’ equity
= 72,178 ÷ 102,330 = 0.71

2 Click competitor name to see calculations.

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 improved from Q2 2019 to Q3 2019 and from Q3 2019 to Q4 2019.

Debt to Equity (including Operating Lease Liability)

Microsoft Corp., debt to equity (including operating lease liability) calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014 Dec 31, 2013 Sep 30, 2013
Selected Financial Data (USD $ in millions)
Short-term debt —  —  —  —  —  230  12,466  8,170  9,072  7,187  25,065  14,536  12,904  5,498  3,000  9,998  4,985  1,725  8,299  3,500  2,000  —  300  1,300 
Current portion of long-term debt 5,516  6,515  3,516  6,497  3,998  3,447  3,446  1,050  1,049  599  599  —  —  —  750  750  2,499  2,499  1,749  1,748  —  2,000  2,000  2,000 
Long-term debt, excluding current portion 66,662  66,585  69,653  69,733  72,242  73,480  73,348  76,255  76,073  76,222  59,306  60,154  40,783  40,896  40,679  27,819  27,808  27,644  18,260  18,472  20,645  20,679  20,676  12,632 
Total debt 72,178  73,100  73,169  76,230  76,240  77,157  89,260  85,475  86,194  84,008  84,970  74,690  53,687  46,394  44,429  38,567  35,292  31,868  28,308  23,720  22,645  22,679  22,976  15,932 
Operating lease liabilities 6,188  5,972  5,683  5,652  5,568  5,751  5,640  5,768  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  — 
Total debt (including operating lease liability) 78,366  79,072  78,852  81,882  81,808  82,908  94,900  91,243  86,194  84,008  84,970  74,690  53,687  46,394  44,429  38,567  35,292  31,868  28,308  23,720  22,645  22,679  22,976  15,932 
 
Stockholders’ equity 102,330  94,864  92,128  85,967  82,718  79,239  78,360  89,647  72,394  69,729  68,809  70,372  71,997  74,806  76,780  77,445  80,083  90,132  91,879  90,170  89,784  87,424  85,100  81,641 
Ratio
Debt to equity (including operating lease liability)1 0.77 0.83 0.86 0.95 0.99 1.05 1.21 1.02 1.19 1.20 1.23 1.06 0.75 0.62 0.58 0.50 0.44 0.35 0.31 0.26 0.25 0.26 0.27 0.20
Benchmarks
Debt to Equity (including Operating Lease Liability), Competitors2
Alphabet Inc. — — 0.07 0.07 0.02 0.02 0.02 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.04 0.04 0.05 0.05 0.05 0.05 0.05 0.05 0.07
Facebook Inc. — — 0.09 0.08 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.01 0.01 0.02 0.02
International Business Machines Corp. — — 4.44 3.33 2.73 2.37 2.46 2.55 2.66 2.32 2.48 2.33 2.31 2.50 2.83 3.05 2.80 2.98 2.83 3.20 3.44 3.21 2.67 2.65
salesforce.com inc. 0.20 0.25 0.27 0.29 0.18 0.21 0.22 0.23 0.27 0.27 0.29 0.23 0.26 0.27 0.28 0.30 0.34 0.41 0.48 0.51 0.62 0.64 0.66 0.63

Based on: 10-K (filing date: 2019-08-01), 10-Q (filing date: 2019-04-24), 10-Q (filing date: 2019-01-30), 10-Q (filing date: 2018-10-24), 10-K (filing date: 2018-08-03), 10-Q (filing date: 2018-04-26), 10-Q (filing date: 2018-01-31), 10-Q (filing date: 2017-10-26), 10-K (filing date: 2017-08-02), 10-Q (filing date: 2017-04-27), 10-Q (filing date: 2017-01-26), 10-Q (filing date: 2016-10-20), 10-K (filing date: 2016-07-28), 10-Q (filing date: 2016-04-21), 10-Q (filing date: 2016-01-28), 10-Q (filing date: 2015-10-22), 10-K (filing date: 2015-07-31), 10-Q (filing date: 2015-04-23), 10-Q (filing date: 2015-01-26), 10-Q (filing date: 2014-10-23), 10-K (filing date: 2014-07-31), 10-Q (filing date: 2014-04-24), 10-Q (filing date: 2014-01-23), 10-Q (filing date: 2013-10-24).

1 Q4 2019 Calculation
Debt to equity (including operating lease liability) = Total debt (including operating lease liability) ÷ Stockholders’ equity
= 78,366 ÷ 102,330 = 0.77

2 Click competitor name to see calculations.

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 improved from Q2 2019 to Q3 2019 and from Q3 2019 to Q4 2019.

Debt to Capital

Microsoft Corp., debt to capital calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014 Dec 31, 2013 Sep 30, 2013
Selected Financial Data (USD $ in millions)
Short-term debt —  —  —  —  —  230  12,466  8,170  9,072  7,187  25,065  14,536  12,904  5,498  3,000  9,998  4,985  1,725  8,299  3,500  2,000  —  300  1,300 
Current portion of long-term debt 5,516  6,515  3,516  6,497  3,998  3,447  3,446  1,050  1,049  599  599  —  —  —  750  750  2,499  2,499  1,749  1,748  —  2,000  2,000  2,000 
Long-term debt, excluding current portion 66,662  66,585  69,653  69,733  72,242  73,480  73,348  76,255  76,073  76,222  59,306  60,154  40,783  40,896  40,679  27,819  27,808  27,644  18,260  18,472  20,645  20,679  20,676  12,632 
Total debt 72,178  73,100  73,169  76,230  76,240  77,157  89,260  85,475  86,194  84,008  84,970  74,690  53,687  46,394  44,429  38,567  35,292  31,868  28,308  23,720  22,645  22,679  22,976  15,932 
Stockholders’ equity 102,330  94,864  92,128  85,967  82,718  79,239  78,360  89,647  72,394  69,729  68,809  70,372  71,997  74,806  76,780  77,445  80,083  90,132  91,879  90,170  89,784  87,424  85,100  81,641 
Total capital 174,508  167,964  165,297  162,197  158,958  156,396  167,620  175,122  158,588  153,737  153,779  145,062  125,684  121,200  121,209  116,012  115,375  122,000  120,187  113,890  112,429  110,103  108,076  97,573 
Ratio
Debt to capital1 0.41 0.44 0.44 0.47 0.48 0.49 0.53 0.49 0.54 0.55 0.55 0.51 0.43 0.38 0.37 0.33 0.31 0.26 0.24 0.21 0.20 0.21 0.21 0.16
Benchmarks
Debt to Capital, Competitors2
Adobe Inc. — — 0.29 0.29 0.31 0.17 0.18 0.18 0.18 0.19 0.19 0.20 0.20 0.21 0.21 0.21 0.21 0.22 0.22 0.22 0.18 0.18 0.18 0.19
Alphabet Inc. — — 0.02 0.02 0.02 0.02 0.02 0.03 0.03 0.02 0.03 0.03 0.03 0.03 0.03 0.04 0.04 0.04 0.04 0.05 0.05 0.05 0.05 0.06
Facebook Inc. — — 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.01 0.01 0.02 0.02
International Business Machines Corp. — — 0.81 0.75 0.73 0.70 0.71 0.72 0.73 0.70 0.71 0.70 0.70 0.71 0.74 0.75 0.74 0.75 0.74 0.76 0.77 0.76 0.73 0.73
Intuit Inc. 0.10 0.10 0.13 0.13 0.16 0.16 0.49 0.42 0.26 0.23 0.59 0.54 0.46 0.44 0.66 0.45 0.18 0.18 0.17 0.15 0.14 0.13 0.18 0.18
Oracle Corp. 0.72 0.70 0.65 0.60 0.57 0.56 0.52 0.49 0.52 0.52 0.53 0.53 0.48 0.47 0.48 0.47 0.46 0.40 0.41 0.41 0.34 0.35 0.36 0.36
salesforce.com inc. 0.17 0.20 0.21 0.22 0.15 0.17 0.18 0.19 0.21 0.21 0.23 0.19 0.21 0.21 0.22 0.23 0.26 0.29 0.33 0.34 0.38 0.39 0.40 0.39

Based on: 10-K (filing date: 2019-08-01), 10-Q (filing date: 2019-04-24), 10-Q (filing date: 2019-01-30), 10-Q (filing date: 2018-10-24), 10-K (filing date: 2018-08-03), 10-Q (filing date: 2018-04-26), 10-Q (filing date: 2018-01-31), 10-Q (filing date: 2017-10-26), 10-K (filing date: 2017-08-02), 10-Q (filing date: 2017-04-27), 10-Q (filing date: 2017-01-26), 10-Q (filing date: 2016-10-20), 10-K (filing date: 2016-07-28), 10-Q (filing date: 2016-04-21), 10-Q (filing date: 2016-01-28), 10-Q (filing date: 2015-10-22), 10-K (filing date: 2015-07-31), 10-Q (filing date: 2015-04-23), 10-Q (filing date: 2015-01-26), 10-Q (filing date: 2014-10-23), 10-K (filing date: 2014-07-31), 10-Q (filing date: 2014-04-24), 10-Q (filing date: 2014-01-23), 10-Q (filing date: 2013-10-24).

1 Q4 2019 Calculation
Debt to capital = Total debt ÷ Total capital
= 72,178 ÷ 174,508 = 0.41

2 Click competitor name to see calculations.

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 improved from Q2 2019 to Q3 2019 and from Q3 2019 to Q4 2019.

Debt to Capital (including Operating Lease Liability)

Microsoft Corp., debt to capital (including operating lease liability) calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014 Dec 31, 2013 Sep 30, 2013
Selected Financial Data (USD $ in millions)
Short-term debt —  —  —  —  —  230  12,466  8,170  9,072  7,187  25,065  14,536  12,904  5,498  3,000  9,998  4,985  1,725  8,299  3,500  2,000  —  300  1,300 
Current portion of long-term debt 5,516  6,515  3,516  6,497  3,998  3,447  3,446  1,050  1,049  599  599  —  —  —  750  750  2,499  2,499  1,749  1,748  —  2,000  2,000  2,000 
Long-term debt, excluding current portion 66,662  66,585  69,653  69,733  72,242  73,480  73,348  76,255  76,073  76,222  59,306  60,154  40,783  40,896  40,679  27,819  27,808  27,644  18,260  18,472  20,645  20,679  20,676  12,632 
Total debt 72,178  73,100  73,169  76,230  76,240  77,157  89,260  85,475  86,194  84,008  84,970  74,690  53,687  46,394  44,429  38,567  35,292  31,868  28,308  23,720  22,645  22,679  22,976  15,932 
Operating lease liabilities 6,188  5,972  5,683  5,652  5,568  5,751  5,640  5,768  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  — 
Total debt (including operating lease liability) 78,366  79,072  78,852  81,882  81,808  82,908  94,900  91,243  86,194  84,008  84,970  74,690  53,687  46,394  44,429  38,567  35,292  31,868  28,308  23,720  22,645  22,679  22,976  15,932 
Stockholders’ equity 102,330  94,864  92,128  85,967  82,718  79,239  78,360  89,647  72,394  69,729  68,809  70,372  71,997  74,806  76,780  77,445  80,083  90,132  91,879  90,170  89,784  87,424  85,100  81,641 
Total capital (including operating lease liability) 180,696  173,936  170,980  167,849  164,526  162,147  173,260  180,890  158,588  153,737  153,779  145,062  125,684  121,200  121,209  116,012  115,375  122,000  120,187  113,890  112,429  110,103  108,076  97,573 
Ratio
Debt to capital (including operating lease liability)1 0.43 0.45 0.46 0.49 0.50 0.51 0.55 0.50 0.54 0.55 0.55 0.51 0.43 0.38 0.37 0.33 0.31 0.26 0.24 0.21 0.20 0.21 0.21 0.16
Benchmarks
Debt to Capital (including Operating Lease Liability), Competitors2
Alphabet Inc. — — 0.06 0.06 0.02 0.02 0.02 0.03 0.03 0.02 0.03 0.03 0.03 0.03 0.03 0.04 0.04 0.04 0.04 0.05 0.05 0.05 0.05 0.06
Facebook Inc. — — 0.08 0.08 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.01 0.01 0.02 0.02
International Business Machines Corp. — — 0.82 0.77 0.73 0.70 0.71 0.72 0.73 0.70 0.71 0.70 0.70 0.71 0.74 0.75 0.74 0.75 0.74 0.76 0.77 0.76 0.73 0.73
salesforce.com inc. 0.17 0.20 0.21 0.22 0.15 0.17 0.18 0.19 0.21 0.21 0.23 0.19 0.21 0.21 0.22 0.23 0.26 0.29 0.33 0.34 0.38 0.39 0.40 0.39

Based on: 10-K (filing date: 2019-08-01), 10-Q (filing date: 2019-04-24), 10-Q (filing date: 2019-01-30), 10-Q (filing date: 2018-10-24), 10-K (filing date: 2018-08-03), 10-Q (filing date: 2018-04-26), 10-Q (filing date: 2018-01-31), 10-Q (filing date: 2017-10-26), 10-K (filing date: 2017-08-02), 10-Q (filing date: 2017-04-27), 10-Q (filing date: 2017-01-26), 10-Q (filing date: 2016-10-20), 10-K (filing date: 2016-07-28), 10-Q (filing date: 2016-04-21), 10-Q (filing date: 2016-01-28), 10-Q (filing date: 2015-10-22), 10-K (filing date: 2015-07-31), 10-Q (filing date: 2015-04-23), 10-Q (filing date: 2015-01-26), 10-Q (filing date: 2014-10-23), 10-K (filing date: 2014-07-31), 10-Q (filing date: 2014-04-24), 10-Q (filing date: 2014-01-23), 10-Q (filing date: 2013-10-24).

1 Q4 2019 Calculation
Debt to capital (including operating lease liability) = Total debt (including operating lease liability) ÷ Total capital (including operating lease liability)
= 78,366 ÷ 180,696 = 0.43

2 Click competitor name to see calculations.

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 improved from Q2 2019 to Q3 2019 and from Q3 2019 to Q4 2019.

Debt to Assets

Microsoft Corp., debt to assets calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014 Dec 31, 2013 Sep 30, 2013
Selected Financial Data (USD $ in millions)
Short-term debt —  —  —  —  —  230  12,466  8,170  9,072  7,187  25,065  14,536  12,904  5,498  3,000  9,998  4,985  1,725  8,299  3,500  2,000  —  300  1,300 
Current portion of long-term debt 5,516  6,515  3,516  6,497  3,998  3,447  3,446  1,050  1,049  599  599  —  —  —  750  750  2,499  2,499  1,749  1,748  —  2,000  2,000  2,000 
Long-term debt, excluding current portion 66,662  66,585  69,653  69,733  72,242  73,480  73,348  76,255  76,073  76,222  59,306  60,154  40,783  40,896  40,679  27,819  27,808  27,644  18,260  18,472  20,645  20,679  20,676  12,632 
Total debt 72,178  73,100  73,169  76,230  76,240  77,157  89,260  85,475  86,194  84,008  84,970  74,690  53,687  46,394  44,429  38,567  35,292  31,868  28,308  23,720  22,645  22,679  22,976  15,932 
 
Total assets 286,556  263,281  258,859  257,619  258,848  245,497  256,003  249,097  241,086  225,017  224,610  212,524  193,694  181,869  180,098  172,896  176,223  176,683  174,848  169,656  172,384  156,119  153,543  142,348 
Ratio
Debt to assets1 0.25 0.28 0.28 0.30 0.29 0.31 0.35 0.34 0.36 0.37 0.38 0.35 0.28 0.26 0.25 0.22 0.20 0.18 0.16 0.14 0.13 0.15 0.15 0.11
Benchmarks
Debt to Assets, Competitors2
Adobe Inc. — — 0.21 0.21 0.22 0.12 0.12 0.13 0.13 0.14 0.14 0.14 0.15 0.15 0.16 0.16 0.16 0.17 0.17 0.17 0.14 0.14 0.15 0.15
Alphabet Inc. — — 0.02 0.02 0.02 0.02 0.02 0.03 0.02 0.02 0.02 0.02 0.02 0.02 0.03 0.03 0.04 0.04 0.04 0.04 0.04 0.04 0.04 0.05
Facebook Inc. — — 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.01 0.01 0.02 0.02
International Business Machines Corp. — — 0.47 0.38 0.37 0.38 0.37 0.37 0.37 0.38 0.38 0.36 0.36 0.37 0.38 0.38 0.36 0.37 0.34 0.35 0.35 0.38 0.37 0.36
Intuit Inc. 0.07 0.06 0.08 0.09 0.08 0.08 0.23 0.22 0.12 0.10 0.26 0.28 0.24 0.20 0.29 0.22 0.10 0.09 0.10 0.10 0.10 0.09 0.11 0.12
Oracle Corp. 0.52 0.51 0.49 0.45 0.44 0.44 0.44 0.40 0.43 0.43 0.44 0.44 0.39 0.38 0.39 0.38 0.38 0.33 0.33 0.33 0.27 0.28 0.28 0.28
salesforce.com inc. 0.10 0.14 0.14 0.14 0.08 0.10 0.10 0.11 0.11 0.13 0.12 0.10 0.10 0.12 0.12 0.12 0.13 0.16 0.18 0.19 0.20 0.23 0.23 0.24

Based on: 10-K (filing date: 2019-08-01), 10-Q (filing date: 2019-04-24), 10-Q (filing date: 2019-01-30), 10-Q (filing date: 2018-10-24), 10-K (filing date: 2018-08-03), 10-Q (filing date: 2018-04-26), 10-Q (filing date: 2018-01-31), 10-Q (filing date: 2017-10-26), 10-K (filing date: 2017-08-02), 10-Q (filing date: 2017-04-27), 10-Q (filing date: 2017-01-26), 10-Q (filing date: 2016-10-20), 10-K (filing date: 2016-07-28), 10-Q (filing date: 2016-04-21), 10-Q (filing date: 2016-01-28), 10-Q (filing date: 2015-10-22), 10-K (filing date: 2015-07-31), 10-Q (filing date: 2015-04-23), 10-Q (filing date: 2015-01-26), 10-Q (filing date: 2014-10-23), 10-K (filing date: 2014-07-31), 10-Q (filing date: 2014-04-24), 10-Q (filing date: 2014-01-23), 10-Q (filing date: 2013-10-24).

1 Q4 2019 Calculation
Debt to assets = Total debt ÷ Total assets
= 72,178 ÷ 286,556 = 0.25

2 Click competitor name to see calculations.

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 improved from Q2 2019 to Q3 2019 and from Q3 2019 to Q4 2019.

Debt to Assets (including Operating Lease Liability)

Microsoft Corp., debt to assets (including operating lease liability) calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014 Dec 31, 2013 Sep 30, 2013
Selected Financial Data (USD $ in millions)
Short-term debt —  —  —  —  —  230  12,466  8,170  9,072  7,187  25,065  14,536  12,904  5,498  3,000  9,998  4,985  1,725  8,299  3,500  2,000  —  300  1,300 
Current portion of long-term debt 5,516  6,515  3,516  6,497  3,998  3,447  3,446  1,050  1,049  599  599  —  —  —  750  750  2,499  2,499  1,749  1,748  —  2,000  2,000  2,000 
Long-term debt, excluding current portion 66,662  66,585  69,653  69,733  72,242  73,480  73,348  76,255  76,073  76,222  59,306  60,154  40,783  40,896  40,679  27,819  27,808  27,644  18,260  18,472  20,645  20,679  20,676  12,632 
Total debt 72,178  73,100  73,169  76,230  76,240  77,157  89,260  85,475  86,194  84,008  84,970  74,690  53,687  46,394  44,429  38,567  35,292  31,868  28,308  23,720  22,645  22,679  22,976  15,932 
Operating lease liabilities 6,188  5,972  5,683  5,652  5,568  5,751  5,640  5,768  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  — 
Total debt (including operating lease liability) 78,366  79,072  78,852  81,882  81,808  82,908  94,900  91,243  86,194  84,008  84,970  74,690  53,687  46,394  44,429  38,567  35,292  31,868  28,308  23,720  22,645  22,679  22,976  15,932 
 
Total assets 286,556  263,281  258,859  257,619  258,848  245,497  256,003  249,097  241,086  225,017  224,610  212,524  193,694  181,869  180,098  172,896  176,223  176,683  174,848  169,656  172,384  156,119  153,543  142,348 
Ratio
Debt to assets (including operating lease liability)1 0.27 0.30 0.30 0.32 0.32 0.34 0.37 0.37 0.36 0.37 0.38 0.35 0.28 0.26 0.25 0.22 0.20 0.18 0.16 0.14 0.13 0.15 0.15 0.11
Benchmarks
Debt to Assets (including Operating Lease Liability), Competitors2
Alphabet Inc. — — 0.05 0.05 0.02 0.02 0.02 0.03 0.02 0.02 0.02 0.02 0.02 0.02 0.03 0.03 0.04 0.04 0.04 0.04 0.04 0.04 0.04 0.05
Facebook Inc. — — 0.07 0.07 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.01 0.01 0.02 0.02
International Business Machines Corp. — — 0.51 0.42 0.37 0.38 0.37 0.37 0.37 0.38 0.38 0.36 0.36 0.37 0.38 0.38 0.36 0.37 0.34 0.35 0.35 0.38 0.37 0.36
salesforce.com inc. 0.10 0.14 0.14 0.14 0.08 0.10 0.10 0.11 0.11 0.13 0.12 0.10 0.10 0.12 0.12 0.12 0.13 0.16 0.18 0.19 0.20 0.23 0.23 0.24

Based on: 10-K (filing date: 2019-08-01), 10-Q (filing date: 2019-04-24), 10-Q (filing date: 2019-01-30), 10-Q (filing date: 2018-10-24), 10-K (filing date: 2018-08-03), 10-Q (filing date: 2018-04-26), 10-Q (filing date: 2018-01-31), 10-Q (filing date: 2017-10-26), 10-K (filing date: 2017-08-02), 10-Q (filing date: 2017-04-27), 10-Q (filing date: 2017-01-26), 10-Q (filing date: 2016-10-20), 10-K (filing date: 2016-07-28), 10-Q (filing date: 2016-04-21), 10-Q (filing date: 2016-01-28), 10-Q (filing date: 2015-10-22), 10-K (filing date: 2015-07-31), 10-Q (filing date: 2015-04-23), 10-Q (filing date: 2015-01-26), 10-Q (filing date: 2014-10-23), 10-K (filing date: 2014-07-31), 10-Q (filing date: 2014-04-24), 10-Q (filing date: 2014-01-23), 10-Q (filing date: 2013-10-24).

1 Q4 2019 Calculation
Debt to assets (including operating lease liability) = Total debt (including operating lease liability) ÷ Total assets
= 78,366 ÷ 286,556 = 0.27

2 Click competitor name to see calculations.

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 improved from Q2 2019 to Q3 2019 and from Q3 2019 to Q4 2019.

Financial Leverage

Microsoft Corp., financial leverage calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014 Dec 31, 2013 Sep 30, 2013
Selected Financial Data (USD $ in millions)
Total assets 286,556  263,281  258,859  257,619  258,848  245,497  256,003  249,097  241,086  225,017  224,610  212,524  193,694  181,869  180,098  172,896  176,223  176,683  174,848  169,656  172,384  156,119  153,543  142,348 
Stockholders’ equity 102,330  94,864  92,128  85,967  82,718  79,239  78,360  89,647  72,394  69,729  68,809  70,372  71,997  74,806  76,780  77,445  80,083  90,132  91,879  90,170  89,784  87,424  85,100  81,641 
Ratio
Financial leverage1 2.80 2.78 2.81 3.00 3.13 3.10 3.27 2.78 3.33 3.23 3.26 3.02 2.69 2.43 2.35 2.23 2.20 1.96 1.90 1.88 1.92 1.79 1.80 1.74
Benchmarks
Financial Leverage, Competitors2
Adobe Inc. — — 1.98 1.98 2.00 1.74 1.74 1.73 1.72 1.70 1.71 1.72 1.71 1.70 1.69 1.68 1.67 1.68 1.69 1.67 1.59 1.56 1.56 1.55
Alphabet Inc. — — 1.34 1.34 1.31 1.30 1.31 1.29 1.29 1.21 1.20 1.19 1.20 1.19 1.21 1.21 1.23 1.24 1.24 1.23 1.25 1.27 1.27 1.27
Facebook Inc. — — 1.32 1.27 1.16 1.15 1.14 1.15 1.14 1.11 1.11 1.10 1.10 1.10 1.11 1.10 1.12 1.12 1.12 1.12 1.11 1.14 1.13 1.14
International Business Machines Corp. — — 8.76 7.94 7.35 6.17 6.57 6.90 7.12 6.20 6.54 6.41 6.44 6.80 7.50 7.96 7.75 8.17 8.24 9.23 9.90 8.34 7.15 7.39
Intuit Inc. 1.68 1.70 1.91 1.77 2.20 2.45 4.23 3.38 3.00 2.93 5.57 4.20 3.66 3.96 6.78 3.65 2.13 2.28 2.23 1.72 1.69 1.73 2.11 1.83
Oracle Corp. 4.99 4.61 3.87 3.37 3.00 2.89 2.48 2.39 2.51 2.48 2.55 2.60 2.37 2.29 2.32 2.33 2.28 2.05 2.07 2.11 1.93 1.94 1.96 1.98
salesforce.com inc. 1.97 1.81 1.91 2.08 2.24 1.98 2.06 2.15 2.34 2.11 2.35 2.30 2.55 2.30 2.38 2.45 2.69 2.48 2.73 2.76 3.01 2.78 2.83 2.64

Based on: 10-K (filing date: 2019-08-01), 10-Q (filing date: 2019-04-24), 10-Q (filing date: 2019-01-30), 10-Q (filing date: 2018-10-24), 10-K (filing date: 2018-08-03), 10-Q (filing date: 2018-04-26), 10-Q (filing date: 2018-01-31), 10-Q (filing date: 2017-10-26), 10-K (filing date: 2017-08-02), 10-Q (filing date: 2017-04-27), 10-Q (filing date: 2017-01-26), 10-Q (filing date: 2016-10-20), 10-K (filing date: 2016-07-28), 10-Q (filing date: 2016-04-21), 10-Q (filing date: 2016-01-28), 10-Q (filing date: 2015-10-22), 10-K (filing date: 2015-07-31), 10-Q (filing date: 2015-04-23), 10-Q (filing date: 2015-01-26), 10-Q (filing date: 2014-10-23), 10-K (filing date: 2014-07-31), 10-Q (filing date: 2014-04-24), 10-Q (filing date: 2014-01-23), 10-Q (filing date: 2013-10-24).

1 Q4 2019 Calculation
Financial leverage = Total assets ÷ Stockholders’ equity
= 286,556 ÷ 102,330 = 2.80

2 Click competitor name to see calculations.

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 improved from Q2 2019 to Q3 2019 but then slightly deteriorated from Q3 2019 to Q4 2019 not reaching Q2 2019 level.