Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Tesla Inc. logo

Tesla Inc.

Sector: Consumer Cyclical   

Industry: Auto Manufacturers

244.12
 
USD
  
-2.87
  
(-1.16%)
Optionable: Yes  Market Cap: 845,870 M  90-day average vol: 116,217,255

Previous close: 246.99  Open: 242.98  Bid: 243.7  Ask: 243.74
52 week range    
101.81   
   299.29
Peers   
SPCE / 
FB / 
AAPL / 
NFLX / 
Last updated: Wednesday 27th September 2023
43
MarketXLS Rank
30
Value
30
Technical
71
Quality

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
Search for a stock

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord

Metrics

Peers

StockDividendMarket Cap (B)PEPrice ($)

AAPL

0.00513,027 B29171.66

AMZN

1,534 B58.53158.71

FB

899 B22.4224.91

NFLX

203 B38402.1

SPCE

3 B306.78.57
Financials

TSLA Income Statement

Annual
Dec-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
AccruedPreferredStockDividends8 M31 M-5 M
Amortization-9 M-79 M-98 M-114 M-189 M-343 M-399 M-466 M
Amortization of intangibles-66 M-44 M-51 M0.0
Basic EPS from continuing operations-0.04-0.29-0.81-0.26-1.340.27-1.640.251.87
Basic EPS total-3.94-1.91-1.640.251.874.02
Basic weighted shares outstanding358 M374 M385 M433 M497 M512 M531 M2,799 M2,958 M3,130 M
Cost of sales1,557 M2,317 M3,123 M5,401 M9,536 M17,419 M17,280 M24,906 M7,802 M60,609 M
Depreciation-84 M-156 M-279 M-477 M-769 M-1,110 M-1,370 M-1,570 M0.0
Depreciation unreconciled2,671 M
DepreciationAndAmortization-84 M-156 M-279 M-477 M-769 M-1,110 M-1,370 M-1,570 M-1,910 M
Diluted EPS total-0.79-2.31-1.56-3.94-1.91-1.640.211.633.62
Diluted normalized net income/share-0.04-0.29-0.81-0.26-1.340.26-1.640.211.63
Diluted weighted shares outstanding358 M374 M385 M433 M497 M512 M531 M3,249 M3,387 M3,475 M
ExciseTaxes563 M
GainOnSaleOfPPE-37 M
GeneralAndAdministrativeExpense-21 M-46 M-68 M-117 M-178 M-183 M2,646 M3,145 M4,517 M
Gross operating profit456 M882 M924 M1,599 M2,222 M4,042 M7,298 M33,866 M46,021 M20,853 M
ImpairmentOfCapitalAssets0.0
Income before tax-71 M-285 M-876 M-746 M-2,209 M-1,005 M-665 M28,390 M6,343 M13,719 M
Income restructuring and M&A-55 M-50 M
Income taxes3 M9 M13 M27 M32 M58 M110 M292 M699 M1,132 M
Interest income189000.01 M2 M9 M20 M24 M44 M30 M56 M297 M
InterestExpenseNonOperating33 M101 M119 M199 M471 M663 M685 M748 M32,786 M191 M
InterestExpenseOperating-6 M-26 M-32 M-39 M-43 M-65 M-73 M0.0
LossAndLossAdjustmentExpectedIncurred459 M
MarketingExpense-9 M-49 M-58 M
MinorityInterests98 M279 M87 M-87 M-141 M-125 M-31 M
MiscOtherSpecialCharges23 M2 M-42 M111 M-125 M22 M45 M-122 M135 M-43 M
Net income from total operations-74 M-294 M-889 M-675 M-1,961 M-976 M-862 M27,957 M5,519 M12,556 M
NetIncomeCommonStockholders-74 M-294 M-889 M-675 M-1,961 M-976 M-870 M27,926 M5,519 M12,556 M
NetIncomeContinuousOperations-74 M-294 M-889 M-675 M-1,961 M-976 M-862 M27,957 M5,519 M12,556 M
NetNonOperatingInterestIncomeExpense-33 M-100 M-117 M-190 M-452 M-639 M-641 M-718 M-32,730 M106 M
NonRecurringOperationExpense-30 M
Operating income-61 M-187 M-717 M-667 M-1,632 M-388 M390 M29,230 M38,938 M13,656 M
Operating income before depreciation (EBITDA)71 M92 M-294 M494 M-50 M1,675 M2,297 M31,387 M0.017,657 M
OperatingExpense518 M1,068 M1,640 M2,267 M3,855 M4,430 M6,908 M4,636 M7,083 M7,197 M
Other income net-23 M-2 M42 M-111 M125 M-22 M-45 M122 M-135 M43 M
OtherGandA-21 M-46 M-68 M-117 M-178 M-183 M2,646 M3,145 M4,517 M
OtherImpairmentOfCapitalAssets-13 M459 M0.0
OtherOperatingExpenses-3 M-28 M-51 M-63 M-84 M135 M149 M-41 M-27 M176 M
OtherTaxes-45 M-163 M-195 M
OtherunderPreferredStockDividend8 M31 M-5 M
PreferredStockDividends8 M31 M-5 M
RentAndLandingFees-21 M-46 M-68 M-117 M-178 M-183 M
Research & development expense232 M465 M718 M834 M1,378 M1,460 M4,113 M1,491 M2,593 M3,075 M
ResearchExpense232 M465 M718 M834 M1,378 M1,460 M4,113 M1,491 M2,593 M3,075 M
RestructringAndMnAIncome-55 M-50 M
SalariesAndWages-84 M-156 M-198 M-334 M-1,013 M-749 M-898 M-1,734 M0.0
Selling Gen & administrative expense286 M604 M922 M1,432 M2,477 M2,835 M2,646 M3,145 M4,517 M3,946 M
SellingAndMarketingExpense286 M604 M922 M1,432 M2,477 M2,835 M2,770 M3,946 M
SellingExpense286 M604 M922 M1,432 M2,477 M2,835 M2,770 M3,946 M
Special income/charges85 M50 M
Total Income available for interest expense (EBIT)-44 M-210 M-789 M-548 M-1,777 M-385 M-45 M29,065 M0.013,910 M
Total common shares outstanding1,848 M1,886 M1,981 M2,425 M2,534 M2,591 M2,720 M2,880 M3,101 M3,164 M
Total net income-74 M-294 M-889 M-675 M-1,961 M-976 M-862 M27,957 M5,519 M12,556 M
Total ordinary shares3,174 M3,174 M3,174 M3,174 M3,174 M3,174 M3,174 M3,174 M3,174 M3,174 M
Total revenues2,013 M3,198 M4,046 M7,000 M11,759 M21,461 M24,578 M58,772 M53,823 M81,462 M
TotalExpenses2,075 M3,385 M4,763 M7,667 M13,391 M21,849 M24,188 M29,542 M14,885 M67,806 M
TotalRevenue2,013 M3,198 M4,046 M7,000 M11,759 M21,461 M24,578 M58,772 M53,823 M81,462 M
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder/CEO of MarketXLS. With over six years of experience, I've helped 2500+ customers implement personalized investment research strategies and monitoring systems in Excel.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and Templates.
Get started today