Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

TSLA Stock Forecast, Price Targets, Chart, Dividends & Analysis

Tesla Inc. logo

Tesla Inc.

Sector: Consumer Cyclical   

Industry: Auto Manufacturers

342.03
 
USD
  
-3.97
  
(-1.15%)
Previous close: 346.0  Open: 345.0  Bid: 341.8  Ask: 342.03
52 week range    
138.80   
   358.64
Mkt Cap: 1,110,681 M  Avg Vol (90 Days): 88,656,637
Peers   
SPCE / 
FB / 
AAPL / 
NFLX / 
Last updated: Thursday 21st November 2024

Stock Rankings

50
MarketXLS Rank
20
Value
69
Technical
63
Quality
How are these ranks calculated?
Ad slot not ready
Search for a stock

Metrics

Peers

StockDividendMarket Cap (B)PEPrice ($)

AAPL

0.00443,451 B37.01229

AMZN

2,151 B43.42202.88

FB

NFLX

372 B46.58883.85

SPCE

0 B-46.68
Financials

TSLA Income Statement

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
AccruedPreferredStockDividends-8 M-31 M5 M
Amortization of intangibles13 M376 M362 M282 M339 M313 M257 M215 M253 M
Basic EPS from continuing operations-0.16-0.46-0.31-0.79-0.38-0.330.251.874.024.73
Basic EPS total-0.16-0.46-0.31-0.79-0.38-0.330.251.874.024.73
Basic weighted shares outstanding1,868 M1,923 M2,163 M2,486 M2,558 M2,655 M2,799 M2,958 M3,130 M3,174 M
Cost of sales2,317 M3,123 M5,401 M9,536 M17,419 M20,509 M24,906 M40,217 M60,609 M463 M
Depreciation156 M279 M477 M769 M1,110 M1,370 M1,570 M1,910 M60,609 M3,330 M
Depreciation unreconciled60,609 M
DepreciationAndAmortization156 M279 M477 M769 M1,110 M1,370 M1,570 M1,910 M60,609 M3,330 M
Diluted EPS total-0.16-0.46-0.31-0.79-0.38-0.330.211.633.624.3
Diluted normalized net income/share-0.79-0.38-0.330.211.633.624.3
Diluted weighted shares outstanding1,868 M1,923 M2,163 M2,486 M2,558 M2,655 M3,249 M3,387 M3,475 M3,485 M
GainOnSaleOfPPE-37 M
GainOnSaleOfSecurity128 M64 M16 M
GeneralAndAdministrativeExpense604 M922 M1,432 M2,477 M2,835 M2,646 M3,145 M4,517 M3,946 M4,800 M
Gross operating profit882 M924 M1,599 M2,222 M4,042 M4,069 M6,630 M13,606 M20,853 M17,660 M
Income before tax-285 M-876 M-746 M-2,209 M-1,005 M-665 M1,154 M6,343 M13,719 M9,973 M
Income restructuring and M&A55 M50 M
Income taxes9 M13 M27 M32 M58 M110 M292 M699 M1,132 M-5,001 M
Interest income1 M2 M9 M20 M24 M44 M30 M56 M297 M1,066 M
InterestExpenseNonOperating101 M119 M199 M471 M663 M685 M748 M371 M191 M156 M
InterestExpenseOperating26 M32 M39 M43 M65 M73 M12 M
MarketingExpense49 M58 M
MinorityInterests98 M279 M87 M-87 M-141 M-120 M-31 M23 M
MiscOtherSpecialCharges2 M-42 M111 M-125 M22 M45 M-122 M135 M-43 M172 M
Net income from total operations-294 M-889 M-675 M-1,961 M-976 M-862 M721 M5,524 M12,583 M14,997 M
NetIncomeCommonStockholders-123 M-889 M-675 M-24 M1,662 M-870 M721 M37,880 M12,583 M14,997 M
NetIncomeContinuousOperations-294 M-889 M-675 M-1,961 M-976 M-862 M721 M5,519 M12,587 M14,997 M
NetNonOperatingInterestIncomeExpense-100 M-117 M-190 M-452 M-639 M-641 M-718 M-315 M106 M910 M
NonRecurringOperationExpense30 M
Normalized income4,972 M
Operating income-187 M-717 M-667 M-1,632 M-388 M-69 M1,994 M6,523 M13,656 M8,891 M
Operating income before depreciation (EBITDA)144 M-230 M494 M28 M1,761 M2,427 M4,224 M9,625 M17,657 M14,796 M
OperatingExpense1,068 M1,640 M2,267 M3,855 M4,430 M4,138 M4,636 M7,083 M7,197 M8,769 M
Other income net-2 M42 M-111 M125 M-22 M-45 M122 M-135 M-219 M-172 M
OtherGandA604 M922 M1,432 M2,477 M2,835 M2,646 M3,145 M4,517 M3,946 M4,800 M
OtherImpairmentOfCapitalAssets13 M101 M204 M
OtherOperatingExpenses-28 M-51 M-63 M-84 M-135 M-149 M-41 M27 M-176 M-255 M
OtherTaxes45 M163 M195 M79,113 M
OtherunderPreferredStockDividend-8 M-31 M5 M
PreferredStockDividends-8 M-31 M5 M
RentAndLandingFees46 M68 M117 M178 M183 M
Research & development expense465 M718 M834 M1,378 M1,460 M1,343 M1,491 M2,593 M3,075 M3,969 M
ResearchExpense465 M718 M834 M1,378 M1,460 M1,343 M1,491 M2,593 M3,075 M3,969 M
RestructringAndMnAIncome55 M50 M
Revenue per share79 M13 M376 M476 M405 M638 M661 M672 M708 M759 M
SalariesAndWages156 M198 M334 M-1,013 M-44 M-7 M1,734 M7,123 M-326 M
Selling Gen & administrative expense604 M922 M1,432 M2,477 M2,835 M2,646 M3,145 M4,517 M3,946 M4,800 M
SellingAndMarketingExpense49 M58 M
Special income/charges-85 M-50 M-176 M
Total Income available for interest expense (EBIT)-158 M-725 M-548 M-1,699 M-299 M85 M1,902 M6,714 M13,910 M10,129 M
Total common shares outstanding1,886 M1,981 M2,425 M2,534 M2,591 M2,720 M2,880 M3,101 M3,164 M3,185 M
Total net income-294 M-889 M-675 M-1,961 M-976 M-862 M721 M5,524 M12,583 M14,997 M
Total ordinary shares3,195 M3,195 M3,195 M3,195 M3,195 M3,195 M3,195 M3,195 M3,195 M3,195 M
Total revenues3,198 M4,046 M7,000 M11,759 M21,461 M24,578 M58,772 M53,823 M81,462 M96,773 M
TotalExpenses3,385 M4,763 M7,667 M13,391 M21,849 M24,647 M29,542 M47,300 M67,630 M9,232 M
TotalRevenue3,198 M4,046 M7,000 M11,759 M21,461 M24,578 M31,536 M53,823 M81,462 M96,773 M
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

MarketXLS is a complete Excel stock solution

Kevin Hsu

StockKevin.com

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.

Dave

Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University