Microsoft Excel LibreOffice Calc

Alphabet Inc. (GOOG)

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)

Alphabet Inc., debt and solvency ratios (quarterly data)

Microsoft Excel LibreOffice Calc
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
Debt to equity 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
Debt to capital 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

Based on: 10-K (filing date: 2019-02-05), 10-Q (filing date: 2018-10-26), 10-Q (filing date: 2018-07-24), 10-Q (filing date: 2018-04-24), 10-K (filing date: 2018-02-06), 10-Q (filing date: 2017-10-27), 10-Q (filing date: 2017-07-25), 10-Q (filing date: 2017-05-02), 10-K (filing date: 2017-02-03), 10-Q (filing date: 2016-11-03), 10-Q (filing date: 2016-08-04), 10-Q (filing date: 2016-05-03), 10-K (filing date: 2016-02-11), 10-Q (filing date: 2015-10-29), 10-Q (filing date: 2015-07-23), 10-Q (filing date: 2015-04-29), 10-K (filing date: 2015-02-09), 10-Q (filing date: 2014-10-23), 10-Q (filing date: 2014-07-25), 10-Q (filing date: 2014-04-24).

Ratio Description The company
Debt-to-equity ratio A solvency ratio calculated as total debt divided by total shareholders’ equity. Alphabet Inc.’s debt-to-equity ratio improved from Q2 2018 to Q3 2018 and from Q3 2018 to Q4 2018.
Debt-to-capital ratio A solvency ratio calculated as total debt divided by total debt plus shareholders’ equity. Alphabet Inc.’s debt-to-capital ratio improved from Q2 2018 to Q3 2018 and from Q3 2018 to Q4 2018.

Debt to Equity

Alphabet Inc., debt to equity calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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
Selected Financial Data (USD $ in millions)
Short-term debt –  –  –  1,329  –  –  –  –  –  –  2,219  3,221  3,225  3,237  3,008  2,009  2,009  2,009  2,009  3,009 
Long-term debt, excluding short-term portion 4,012  3,986  3,981  3,973  3,969  3,964  3,955  3,937  3,935  3,938  1,984  1,987  1,995  1,994  2,225  3,226  3,228  3,230  3,232  3,234 
Total debt 4,012  3,986  3,981  5,302  3,969  3,964  3,955  3,937  3,935  3,938  4,203  5,208  5,220  5,231  5,233  5,235  5,237  5,239  5,241  6,243 
Stockholders’ equity 177,628  169,840  162,000  160,825  152,502  157,100  148,286  144,949  139,036  134,103  127,879  123,569  120,331  116,241  111,783  108,448  104,500  98,815  95,749  91,711 
Ratio
Debt to equity1 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

Based on: 10-K (filing date: 2019-02-05), 10-Q (filing date: 2018-10-26), 10-Q (filing date: 2018-07-24), 10-Q (filing date: 2018-04-24), 10-K (filing date: 2018-02-06), 10-Q (filing date: 2017-10-27), 10-Q (filing date: 2017-07-25), 10-Q (filing date: 2017-05-02), 10-K (filing date: 2017-02-03), 10-Q (filing date: 2016-11-03), 10-Q (filing date: 2016-08-04), 10-Q (filing date: 2016-05-03), 10-K (filing date: 2016-02-11), 10-Q (filing date: 2015-10-29), 10-Q (filing date: 2015-07-23), 10-Q (filing date: 2015-04-29), 10-K (filing date: 2015-02-09), 10-Q (filing date: 2014-10-23), 10-Q (filing date: 2014-07-25), 10-Q (filing date: 2014-04-24).

Q4 2018 Calculations

1 Debt to equity = Total debt ÷ Stockholders’ equity
= 4,012 ÷ 177,628 = 0.02

Ratio Description The company
Debt-to-equity ratio A solvency ratio calculated as total debt divided by total shareholders’ equity. Alphabet Inc.’s debt-to-equity ratio improved from Q2 2018 to Q3 2018 and from Q3 2018 to Q4 2018.

Debt to Capital

Alphabet Inc., debt to capital calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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
Selected Financial Data (USD $ in millions)
Short-term debt –  –  –  1,329  –  –  –  –  –  –  2,219  3,221  3,225  3,237  3,008  2,009  2,009  2,009  2,009  3,009 
Long-term debt, excluding short-term portion 4,012  3,986  3,981  3,973  3,969  3,964  3,955  3,937  3,935  3,938  1,984  1,987  1,995  1,994  2,225  3,226  3,228  3,230  3,232  3,234 
Total debt 4,012  3,986  3,981  5,302  3,969  3,964  3,955  3,937  3,935  3,938  4,203  5,208  5,220  5,231  5,233  5,235  5,237  5,239  5,241  6,243 
Stockholders’ equity 177,628  169,840  162,000  160,825  152,502  157,100  148,286  144,949  139,036  134,103  127,879  123,569  120,331  116,241  111,783  108,448  104,500  98,815  95,749  91,711 
Total capital 181,640  173,826  165,981  166,127  156,471  161,064  152,241  148,886  142,971  138,041  132,082  128,777  125,551  121,472  117,016  113,683  109,737  104,054  100,990  97,954 
Ratio
Debt to capital1 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

Based on: 10-K (filing date: 2019-02-05), 10-Q (filing date: 2018-10-26), 10-Q (filing date: 2018-07-24), 10-Q (filing date: 2018-04-24), 10-K (filing date: 2018-02-06), 10-Q (filing date: 2017-10-27), 10-Q (filing date: 2017-07-25), 10-Q (filing date: 2017-05-02), 10-K (filing date: 2017-02-03), 10-Q (filing date: 2016-11-03), 10-Q (filing date: 2016-08-04), 10-Q (filing date: 2016-05-03), 10-K (filing date: 2016-02-11), 10-Q (filing date: 2015-10-29), 10-Q (filing date: 2015-07-23), 10-Q (filing date: 2015-04-29), 10-K (filing date: 2015-02-09), 10-Q (filing date: 2014-10-23), 10-Q (filing date: 2014-07-25), 10-Q (filing date: 2014-04-24).

Q4 2018 Calculations

1 Debt to capital = Total debt ÷ Total capital
= 4,012 ÷ 181,640 = 0.02

Ratio Description The company
Debt-to-capital ratio A solvency ratio calculated as total debt divided by total debt plus shareholders’ equity. Alphabet Inc.’s debt-to-capital ratio improved from Q2 2018 to Q3 2018 and from Q3 2018 to Q4 2018.