Stock Analysis on Net

Tesla Inc. (NASDAQ:TSLA)

Analysis of Debt

Microsoft Excel

Total Debt (Carrying Amount)

Tesla 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 debt and finance leases 2,373 1,502 1,589 2,132 1,785
Debt and finance leases, net of current portion 2,857 1,597 5,245 9,556 11,634
Total debt and finance leases (carrying amount) 5,230 3,099 6,834 11,688 13,419

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 and finance leases (carrying amount) Sum of the carrying values as of the balance sheet date of all debt plus capital lease obligations. Tesla Inc. total debt decreased from 2021 to 2022 but then increased from 2022 to 2023 not reaching 2021 level.

Total Debt (Fair Value)

Microsoft Excel
Dec 31, 2023
Selected Financial Data (US$ in millions)
Convertible Senior Notes 443
Other debt 4,620
Finance lease liabilities 573
Total debt and finance leases (fair value) 5,636
Financial Ratio
Debt, fair value to carrying amount ratio 1.08

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


Weighted-average Interest Rate on Debt

Weighted-average interest rate on debt and finance leases: 6.41%

Interest rate Debt amount1 Interest rate × Debt amount Weighted-average interest rate2
8.68% 37 3
5.75% 7
6.57% 4,259 280
4.80% 13 1
5.81% 367 21
5.50% 573 32
Total 5,256 337
6.41%

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

1 US$ in millions

2 Weighted-average interest rate = 100 × 337 ÷ 5,256 = 6.41%


Interest Costs Incurred

Tesla 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 191 371 748 685
Capitalized interest 53 48 31
Interest costs incurred 191 424 796 716

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. Tesla Inc. interest expense decreased from 2021 to 2022 and from 2022 to 2023.
Capitalized interest Amount of interest costs capitalized disclosed as an adjusting item to interest costs incurred.
Interest costs incurred Total interest costs incurred during the period and either capitalized or charged against earnings. Tesla Inc. interest costs incurred decreased from 2021 to 2022 and 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 (loss) attributable to common stockholders 14,997 12,556 5,519 721 (862)
Add: Net income attributable to noncontrolling interest (23) 31 125 141 87
Add: Income tax expense (5,001) 1,132 699 292 110
Add: Interest expense 156 191 371 748 685
Earnings before interest and tax (EBIT) 10,129 13,910 6,714 1,902 20
 
Interest costs incurred 191 424 796 716
Financial Ratio With and Without Capitalized Interest
Interest coverage ratio (without capitalized interest)1 64.93 72.83 18.10 2.54 0.03
Adjusted interest coverage ratio (with capitalized interest)2 72.83 15.83 2.39 0.03

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
= 10,129 ÷ 156 = 64.93

2 Adjusted interest coverage ratio (with capitalized interest) = EBIT ÷ Interest costs incurred
= 10,129 ÷ 0 =