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

175.79
 
USD
  
-4.04
  
(-2.25%)
Optionable: Yes  Market Cap: 565,842 M  90-day average vol: 102,523,179

Previous close: 179.83  Open: 177.45  Bid: 175.53  Ask: 175.56
52 week range    
152.37   
   299.29
Peers   
SPCE / 
FB / 
AAPL / 
NFLX / 
Last updated: Friday 29th March 2024
39
MarketXLS Rank
30
Value
30
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 Balance Sheet

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
"""debtc"""611 M628 M984 M797 M2,568 M1,957 M
Accounts payable778 M916 M1,860 M2,390 M3,405 M3,771 M6,051 M10,025 M15,255 M14,431 M
Accounts receivable227 M169 M499 M515 M949 M1,324 M1,886 M1,913 M2,952 M3,508 M
Accrued expenses1,047 M916 M1,860 M2,490 M3,405 M3,771 M6,051 M14,817 M15,255 M14,431 M
Accumulated depreciation & depletion-293 M-571 M-997 M-1,724 M-2,699 M-3,734 M-5,117 M-7,918 M-9,041 M-12,057 M
Additional paid in capital2,345 M3,409 M7,774 M9,178 M10,249 M12,736 M27,260 M29,803 M32,177 M34,892 M
Cash and equivalents1,906 M1,197 M3,393 M3,368 M3,686 M6,268 M19,384 M17,576 M16,253 M16,398 M
CashCashEquivalentsAndShortTermInvestments1,906 M1,197 M3,393 M3,368 M3,686 M6,268 M19,384 M17,707 M22,185 M29,094 M
CashEquivalents1,924 M1,220 M3,499 M3,523 M3,878 M6,514 M238 M345 M
Common par126000.0131000.0161000.0169000.0173000.01000000.01000000.01000000.03 M3 M
Common stock equity912 M1,084 M4,753 M4,237 M4,923 M6,618 M22,225 M30,189 M44,704 M62,634 M
CommonStock126000.0131000.0161000.0169000.0173000.01000000.01000000.01000000.03 M3 M
Construction in progress5,598 M
Cost in excess60 M68 M198 M207 M200 M194 M253 M
CurrentAccruedExpenses269 M423 M3,670 M
CurrentCapitalLeaseObligation10 M89 M165 M686 M1,339 M1,618 M1,468 M869 M1,054 M672 M
CurrentDeferredRevenue449 M707 M1,427 M1,015 M630 M1,163 M1,458 M2,372 M1,747 M2,864 M
CurrentDeferredTaxesAssets86 M190 M731 M580 M910 M1,454 M2,018 M2,006 M2,184 M9,882 M
CurrentDeferredTaxesLiabilities-86 M-193 M-706 M-556 M-918 M-1,489 M-2,102 M-1,941 M-1,937 M-3,230 M
CurrentProvisions2,210 M2,309 M329 M36 M265 M
Deferred revenues449 M707 M1,427 M1,015 M630 M1,163 M1,458 M2,372 M1,747 M2,864 M
Deposits76 M78 M86 M77 M16 M
EmployeeBenefits347 M
Finished goods397 M477 M1,017 M1,014 M1,581 M1,356 M1,666 M1,277 M3,475 M5,049 M
Float term debt1,877 M2,068 M5,860 M9,418 M2,568 M1,785 M2,132 M4,254 M1,502 M2,373 M
GoodwillAndOtherIntangibleAssets13 M376 M422 M350 M537 M520 M1,717 M409 M431 M
Gross fixed assets (Plant Property & Equipment)2,889 M5,766 M6,980 M11,751 M14,029 M15,348 M19,422 M39,094 M35,152 M45,962 M
IncomeTaxPayable71 M101 M153 M186 M348 M611 M777 M1,122 M1,235 M1,204 M
Intangibles13 M376 M362 M282 M339 M313 M1,517 M215 M178 M
InterestPayable7 M16 M
Inventories954 M1,278 M2,067 M2,264 M3,113 M3,552 M4,101 M5,757 M12,839 M13,626 M
InventoriesAdjustmentsAllowances-16 M-45 M-66 M-132 M-85 M-193 M-202 M-140 M-177 M-463 M
Invested capital4,666 M5,220 M16,473 M23,074 M18,490 M20,895 M34,926 M39,688 M48,267 M69,690 M
Land & improvements4,675 M
Leases767 M1,791 M3,530 M4,850 M2,550 M2,850 M3,540 M1,826 M6,080 M7,360 M
LineOfCredit105 M138 M220 M282 M233 M286 M318 M525 M
LongTermCapitalLeaseObligation12 M17 M77 M589 M993 M1,232 M1,540 M2,662 M2,649 M5,360 M
LongTermDebtAndCapitalLeaseObligation1,877 M2,068 M5,879 M9,418 M9,404 M11,634 M9,607 M6,916 M1,502 M2,373 M
LongTermProvisions488 M1,294 M10 M2,309 M9,404 M11,634 M9,556 M133 M1,597 M2,857 M
Machinery furniture & equipment15,878 M
Minority interest1,152 M1,395 M1,390 M1,492 M1,454 M826 M1,194 M975 M
Net fixed assets (net PP&E)2,596 M5,195 M5,983 M10,028 M11,330 M11,614 M14,305 M31,176 M26,111 M33,905 M
NetOtherUnrealizedGainLoss37 M-1000000.0-23 M16 M
Non-current deferred income taxes-86 M-188 M-680 M-538 M-861 M-1,185 M-1,488 M24 M-1,178 M-2,122 M
NonCurrentAccountsReceivable506 M457 M422 M393 M
NonCurrentAccruedExpenses97 M1,398 M
NonCurrentDeferredAssets328 M6,733 M
NonCurrentDeferredLiabilities292 M446 M852 M1,178 M991 M1,207 M1,284 M2,076 M2,804 M3,251 M
NonCurrentDeferredRevenue292 M446 M852 M1,178 M991 M1,207 M1,284 M2,052 M2,804 M3,251 M
NonCurrentDeferredTaxesAssets611 M859 M1,754 M2,424 M2,716 M3,410 M4,948 M11,080 M328 M6,733 M
Notes payable602 M100 M
NotesReceivable9 M9 M11 M128 M
Number of employees127855.0127855.0127855.0127855.0127855.0127855.0127855.0127855.0127855.0127855.0
Other current assets41 M99 M204 M199 M253 M273 M380 M531 M870 M1,174 M
Other equity adjustments-4 M-24 M33 M-8 M-36 M54 M
Other fixed assets1,829 M3,403 M5,983 M10,028 M11,330 M11,614 M14,305 M4,204 M26,111 M33,905 M
Other non-current assets55 M78 M485 M715 M970 M1,470 M1,536 M2,138 M3,865 M4,531 M
Other non-current liabilities155 M502 M1,891 M4,084 M4,006 M2,691 M4,082 M320 M5,330 M8,153 M
Other receivable3,137 M3,805 M4,036 M81,462 M96,773 M
OtherCapitalStock5.03.03.0
OtherCurrentBorrowings1,115 M800 M2,222 M1,399 M1,758 M1,088 M1,016 M1,975 M
OtherCurrentLiabilities54 M423 M1,390 M1,731 M2,094 M3,948 M3,855 M294 M8,205 M9,080 M
OtherEquityInterest-102 M-96 M
OtherInventories954 M1,278 M2,067 M2,264 M3,113 M3,552 M4,101 M575 M12,839 M13,626 M
OtherPayable100 M10 M1,500 M
Payables778 M916 M1,860 M2,490 M3,405 M3,771 M6,051 M11,147 M15,255 M14,431 M
Preferred securities of subsidiary trust100 M
PreferredSecuritiesOutsideStockEquity9 M70000.051 M568 M
PreferredStock100 M
Prepaid expenses76 M116 M194 M268 M366 M959 M1,346 M1,723 M2,941 M3,388 M
Properties6,913 M
Raw materials392 M529 M680 M821 M932 M1,428 M1,508 M2,816 M6,137 M5,390 M
RecievablesAdjustmentsAllowances-45 M-41 M-37 M
Restricted cash18 M23 M106 M155 M193 M246 M238 M345 M294 M543 M
Retained earnings-1,434 M-2,326 M-3,021 M-4,941 M-5,326 M-6,119 M-5,036 M331 M12,524 M27,739 M
Short term debt611 M628 M984 M797 M2,568 M1,088 M
Total assets5,831 M8,068 M13,610 M18,191 M21,379 M25,724 M52,148 M62,131 M82,338 M106,618 M
Total current assets3,180 M2,782 M6,260 M6,571 M8,307 M12,103 M26,717 M27,100 M40,917 M49,616 M
Total current liabilities2,107 M2,674 M7,871 M6,033 M6,458 M8,882 M11,364 M19,705 M26,709 M28,748 M
Total equity912 M1,084 M4,753 M4,237 M4,923 M6,618 M22,225 M30,189 M44,704 M62,634 M
Total liabilities4,919 M6,984 M16,494 M23,023 M23,427 M26,199 M28,469 M31,116 M36,440 M43,009 M
Total non-current assets2,651 M5,286 M7,350 M11,621 M13,072 M13,621 M16,361 M35,031 M30,897 M45,784 M
Total non-current liabilities2,812 M4,310 M8,622 M16,990 M16,969 M17,317 M17,105 M11,411 M11,233 M16,634 M
TotalEquityGrossMinority912 M1,084 M5,905 M5,632 M6,313 M8,110 M23,679 M31,583 M45,898 M63,609 M
TotalEquityGrossMinorityInterest912 M1,084 M5,905 M5,632 M6,313 M8,110 M23,679 M31,583 M45,898 M63,609 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest5,831 M8,068 M22,399 M28,655 M29,740 M34,309 M52,148 M62,131 M82,338 M106,618 M
TotalNonCurrentLiabilitiesNetMinorityInteres2,812 M4,310 M8,622 M16,990 M16,969 M17,317 M17,105 M11,411 M11,233 M16,634 M
TotalTaxPayable1,122 M
UnearnedIncome1,260 M184 M184 M
Work in progress56 M164 M234 M243 M297 M362 M493 M1,089 M2,385 M2,016 M
Working capital1,073 M108 M-1,612 M537 M1,849 M3,221 M15,353 M7,395 M14,208 M20,868 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.

We respect your privacy and will never share your email.
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