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

142.05
 
USD
  
-5.00
  
(-3.40%)
Optionable: Yes  Market Cap: 500,362 M  90-day average vol: 100,799,512

Previous close: 147.05  Open: 140.56  Bid: 141.65  Ask: 141.72
52 week range    
138.80   
   299.29
Peers   
SPCE / 
FB / 
AAPL / 
NFLX / 
Last updated: Tuesday 23rd April 2024
36
MarketXLS Rank
30
Value
23
Technical
57
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

Financials

TSLA Cash Flow

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
(Increase) Decrease in inventories-633 M-179 M-1,023 M-429 M-422 M-1,709 M-6,465 M-1,195 M
(Increase) Decrease in other current assets-4 M-24 M-53 M115 M-344 M
(Increase) Decrease in other current liabilities316 M359 M771 M469 M406 M801 M321 M793 M1,131 M1,532 M
(Increase) Decrease in other working capital57 M-665000.0132 M81 M-47 M110 M151 M-815 M-647 M
(Increase) Decrease in payables415 M263 M751 M388 M1,723 M646 M2,102 M4,578 M8,029 M2,605 M
(Increase) Decrease in receivables-184 M46 M-217 M-25 M-497 M-367 M-652 M-130 M-1,124 M-586 M
Acquisitions-12 M214 M-115 M-18 M-45 M-13 M-64 M
Amortization of intangibles70 M72 M87 M
AssetImpairmentCharge16 M45 M66 M132 M85 M193 M202 M140 M177 M463 M
CapitalExpenditureReported970 M1,635 M1,281 M3,415 M2,101 M1,332 M3,167 M6,482 M7,158 M8,898 M
Cash at beginning of period846 M1,906 M1,197 M3,767 M3,965 M4,277 M6,783 M19,901 M18,144 M16,924 M
Cash at end of period1,906 M1,197 M3,393 M3,965 M4,277 M6,783 M19,673 M18,144 M16,924 M17,189 M
Cash flow-57 M-524 M-124 M-61 M2,098 M2,405 M5,715 M11,497 M14,724 M13,256 M
CashFlowFromContinuingInvestingActivities-990 M-1,674 M-1,416 M-4,196 M-2,337 M-1,436 M-3,132 M-7,868 M-11,973 M-15,584 M
ChangeInAccountPayable415 M263 M751 M388 M1,723 M646 M2,102 M4,578 M8,029 M2,605 M
ChangeInAccruedExpense162 M
ChangeInInterestPayable162 M
ChangeInPayablesAndAccruedExpense415 M263 M751 M388 M1,723 M646 M2,102 M4,578 M8,029 M2,605 M
ChangeInPrepaidAssets-61 M-30 M57 M-72 M-82 M-288 M-251 M-271 M-3,713 M-2,652 M
ChangeInWorkingCapital544 M638 M861 M663 M480 M473 M1,249 M2,446 M-2,142 M-296 M
ChangesInAccountReceivables-184 M46 M-217 M-25 M-497 M-367 M-652 M-130 M-1,124 M-586 M
CommonStockPayments-35 M
Current deferred income taxes-196 M-6,349 M
Deferred income taxes-196 M-6,349 M
Depreciation232 M423 M947 M1,636 M1,901 M2,154 M2,322 M2,911 M3,747 M4,667 M
Depreciation unreconciled302 M495 M1,042 M1,727 M2,060 M2,342 M2,322 M2,911 M3,747 M4,667 M
DepreciationAndAmortization302 M495 M1,042 M1,727 M2,060 M2,342 M2,322 M2,911 M3,747 M4,667 M
Effect of exchange rate changes-36 M-34 M-7 M40 M-23 M8 M334 M-183 M-444 M4 M
FinancingCashFlow2,143 M1,524 M3,744 M4,415 M574 M1,529 M9,973 M-5,203 M-3,527 M2,589 M
Free cash flow-1,027 M-2,159 M-1,405 M-3,475 M-3 M1,073 M2,548 M5,015 M7,566 M4,358 M
GainLossOnSaleOfPPE14 M38 M35 M106 M162 M146 M117 M
IncomeTaxPaidSupplementalData3 M9 M16 M66 M35 M54 M115 M561 M1,203 M1,119 M
InterestPaidSupplementalData21 M32 M39 M183 M381 M455 M444 M266 M152 M126 M
Issuance of capital stock750 M1,702 M400 M848 M12,269 M
Issuance of debt3 M569 M770 M346 M-100 M
IssuanceOfCapitalStock750 M1,702 M400 M848 M12,269 M
IssuanceOfDebt-8 M365 M723 M243 M-840 M-747 M-584 M8,426 M-3,866 M2,087 M
Net cash from financing activities2,143 M1,524 M3,744 M4,415 M574 M1,529 M9,973 M-5,203 M-3,527 M2,589 M
Net cash from investing activities-990 M-1,674 M-1,416 M-4,196 M-2,337 M-1,436 M-3,132 M-7,868 M-11,973 M-15,584 M
Net cash from operating activities-57 M-524 M-124 M-61 M2,098 M2,405 M5,715 M11,497 M14,724 M13,256 M
Net change in cash & cash equivalents1,060 M-709 M2,196 M198 M312 M2,506 M12,890 M-1,574 M-776 M261 M
Net income from continuing operations-294 M-889 M-773 M-2,241 M-1,063 M-775 M862 M5,644 M12,587 M14,974 M
NetBusinessPurchaseAndSale-12 M214 M-115 M-18 M-45 M-13 M-64 M
NetCommonStockIssuance-35 M750 M1,702 M400 M848 M12,269 M
NetForeignCurrencyExchangeGainLoss-2 M56 M-29 M52 M-2 M-48 M-114 M-55 M81 M-144 M
NetIntangiblesPurchaseAndSale-5 M-10 M-1,500 M
NetInvestmentPropertiesPurchaseAndSale-21 M-26 M-349 M-667 M-218 M-59 M48 M-1,386 M-4,815 M-6,622 M
NetInvestmentPurchaseAndSale-21 M-26 M-349 M-667 M-218 M-59 M48 M-1,386 M-4,815 M-6,622 M
NetIssuancePaymentsOfDebt-8 M365 M723 M243 M-840 M-747 M-584 M8,426 M-3,866 M2,087 M
NetLongTermDebtIssuance-11 M-204 M-47 M243 M-840 M-747 M-584 M8,426 M-3,866 M2,087 M
NetPPEPurchaseAndSale-970 M-1,635 M-1,281 M-3,415 M-2,101 M-1,327 M-3,157 M-6,482 M-7,158 M-8,898 M
Operating (gains) losses12 M93 M5 M158 M160 M98 M-114 M-55 M81 M-144 M
Other financing charges net1,697 M319 M1,176 M3,753 M1,133 M991 M-2,129 M-14,336 M-202 M-198 M
Other investing changes net-4 M-26 M-366 M-667 M-218 M-59 M48 M-1,254 M998 M-1000000.0
Other non-cash items-621 M-862 M-1,259 M-368 M461 M267 M1,396 M551 M647 M404 M
ProceedsFromIssuanceOfWarrants389 M-178 M-11000.0174 M
ProceedsFromStockOptionExercised100 M107 M164 M259 M296 M263 M417 M707 M541 M700 M
Purchase of Float term investments-206 M-132 M-5,835 M-19,112 M
Purchase of property plant & equipment-970 M-1,635 M-1,281 M-3,415 M-2,101 M-1,332 M-3,167 M-6,482 M-7,158 M-8,898 M
Purchase of short term investments-11 M-204 M-47 M408 M-559 M-389 M-240 M8,874 M3,931 M
PurchaseOfIntangibles-5 M-10 M-1,500 M
PurchaseOfInvestment-206 M-132 M-5,835 M-19,112 M
PurchaseOfLongTermInvestments-206 M
PurchaseOfPPE-970 M-1,635 M-1,281 M-3,415 M-2,101 M-1,327 M-3,157 M-6,482 M-7,158 M-8,898 M
Repayment of debt-11 M-204 M-47 M-165 M-281 M-358 M-344 M-448 M-3,866 M-1,844 M
RepaymentOfDebt-11 M-204 M-47 M-165 M-281 M-358 M-344 M-448 M-3,866 M-1,844 M
Repurchase of capital stock-35 M
Revenue per share70 M72 M95 M91 M159 M188 M180 M
Sale of short term investments189 M17 M22 M12,491 M
SaleOfInvestment189 M17 M22 M12,491 M
ShortTermDebtIssuance3 M569 M770 M511 M
ShortTermDebtPayments-165 M-100 M
StockBasedCompensation156 M198 M334 M467 M749 M898 M1,734 M2,121 M1,560 M1,812 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