Stock Analysis on Net

Alphabet Inc. (NASDAQ:GOOG)

$24.99

Analysis of Debt

Microsoft Excel

Paying user area

The data is hidden behind: . Unhide it.

This is a one-time payment. There is no automatic renewal.


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Apple Pay Google Pay
Visa Secure Mastercard Identity Check American Express SafeKey

Total Debt (Carrying Amount)

Alphabet Inc., balance sheet: debt

US$ in millions

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Current portion of long-term notes
Current portion of future finance lease payments, net and other current debt
Long-term debt, excluding current portion
Total debt (carrying amount)

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

Debt item Description The company
Total debt (carrying amount) Sum of the carrying values as of the balance sheet date of all debt plus capital lease obligations. Alphabet Inc. total debt increased from 2021 to 2022 but then decreased significantly from 2022 to 2023.

Total Debt (Fair Value)

Microsoft Excel
Dec 31, 2023
Selected Financial Data (US$ in millions)
Outstanding notes, including current portion
Future finance lease payments, net and other
Total debt (fair value)
Financial Ratio
Debt, fair value to carrying amount ratio

Based on: 10-K (reporting date: 2023-12-31).


Weighted-average Interest Rate on Debt

Weighted-average effective interest rate:

Interest rate Debt amount1 Interest rate × Debt amount Weighted-average interest rate2
Total

Based on: 10-K (reporting date: 2023-12-31).

1 US$ in millions

2 Weighted-average interest rate = 100 × ÷ =


Interest Costs Incurred

Alphabet Inc., interest costs incurred

US$ in millions

Microsoft Excel
12 months ended: Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Interest expense
Interest capitalized
Interest costs incurred

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

Debt item Description The company
Interest expense Amount of the cost of borrowed funds accounted for as interest expense for debt. Alphabet Inc. interest expense increased from 2021 to 2022 but then decreased significantly from 2022 to 2023.
Interest capitalized Amount of interest costs capitalized disclosed as an adjusting item to interest costs incurred. Alphabet Inc. interest capitalized decreased from 2021 to 2022 but then increased from 2022 to 2023 exceeding 2021 level.
Interest costs incurred Total interest costs incurred during the period and either capitalized or charged against earnings. Alphabet Inc. interest costs incurred decreased from 2021 to 2022 but then slightly increased from 2022 to 2023.

Adjusted Interest Coverage Ratio

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Net income
Add: Income tax expense
Add: Interest expense
Earnings before interest and tax (EBIT)
 
Interest costs incurred
Financial Ratio With and Without Capitalized Interest
Interest coverage ratio (without capitalized interest)1
Adjusted interest coverage ratio (with capitalized interest)2

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

2023 Calculations

1 Interest coverage ratio (without capitalized interest) = EBIT ÷ Interest expense
= ÷ =

2 Adjusted interest coverage ratio (with capitalized interest) = EBIT ÷ Interest costs incurred
= ÷ =


Solvency ratio Description The company
Adjusted interest coverage ratio A solvency ratio calculated as EBIT divided by interest payments (including capitalized interest). Alphabet Inc. adjusted interest coverage ratio deteriorated from 2021 to 2022 but then improved from 2022 to 2023 not reaching 2021 level.