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

Sector:    

Industry: 

 
USD
  
  
()
Optionable:   Market Cap:   90-day average vol:

Previous close:   Open:   Bid:   Ask:
52 week range    
   
   

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

NIO Balance Sheet

Annual
Invalid dateDec-18Dec-19Dec-20Dec-21Dec-22
"""debtc"""2,069 M1,857 M2,511 M8,070 M6,303 M
Accounts payable2,870 M3,112 M6,368 M12,639 M25,224 M
Accounts receivable757 M1,352 M1,124 M2,798 M5,118 M
Accrued expenses6,049 M6,951 M10,103 M21,156 M39,549 M
AccruedInterestReceivable14 M98 M
Accumulated depreciation & depletion-678 M-1,624 M-2,550 M-4,200 M-6,901 M
Additional paid in capital41,919 M40,228 M78,880 M92,467 M94,593 M
Building & improvements481 M829 M863 M876 M
Cash and equivalents3,134 M863 M38,504 M15,334 M19,888 M
CashCashEquivalentsAndShortTermInvestments8,346 M1,056 M42,454 M55,386 M42,213 M
CashEquivalents57 M83 M78 M18,328 M3,154 M
Common par2 M2 M3 M3 M3 M
Common stock equity6,837 M-6,300 M27,169 M34,710 M23,868 M
CommonStock2 M2 M3 M3 M3 M
Construction in progress1,449 M494 M193 M1,681 M
CurrentAccruedExpenses311 M352 M372 M7,202 M13,654 M
CurrentCapitalLeaseObligation394 M649 M580 M745 M1,026 M
CurrentDeferredRevenue342 M486 M1,004 M1,385 M3,562 M
CurrentDeferredTaxesAssets84 M106 M252 M560 M941 M
CurrentDeferredTaxesLiabilities25 M218 M
CurrentProvisions47 M120 M297 M518 M
Deferred revenues429 M571 M1,065 M1,417 M
Finished goods763 M387 M503 M1,047 M4,686 M
Float term debt1,168 M7,155 M5,938 M9,739 M10,886 M
GoodwillAndOtherIntangibleAssets217 M210 M205 M199 M213 M
Gross fixed assets (Plant Property & Equipment)5,690 M9,328 M9,008 M10,388 M23,033 M
IncomeTaxPayable51 M44 M182 M628 M286 M
Intangibles217 M210 M205 M199 M213 M
InterestPayable3 M106 M98 M41 M32 M
Inventories1,465 M890 M1,082 M2,056 M8,191 M
InventoriesAdjustmentsAllowances-10 M-5 M-3 M-149 M
Invested capital1,164 M6,640 M38,304 M44,449 M44,910 M
Leases653 M1,026 M997 M1,876 M
LineOfCredit1,870 M188 M1,550 M5,230 M539 M
LongTermCapitalLeaseObligation1,687 M1,070 M2,317 M6,517 M
LongTermDebtAndCapitalLeaseObligation1,168 M8,842 M7,009 M12,056 M17,403 M
LongTermProvisions131 M292 M656 M1,445 M49 M
Machinery furniture & equipment1,137 M1,639 M1,569 M1,901 M
Minority interest-16 M22 M4,693 M3,353 M3,779 M
Net fixed assets (net PP&E)5,012 M7,703 M6,457 M10,388 M23,033 M
Non-current deferred income taxes25 M218 M
NonCurrentAccountsReceivable583 M658 M1,289 M4,506 M221 M
NonCurrentAccruedExpenses131 M292 M656 M2,277 M
NonCurrentDeferredLiabilities670 M709 M1,054 M25 M218 M
NonCurrentDeferredRevenue545 M637 M1,004 M1,764 M
NonCurrentDeferredTaxesAssets4,370 M6,879 M8,020 M9,217 M12,727 M
NonCurrentPrepaidAssets616 M849 M128 M636 M
Notes payable3,112 M6,368 M12,639 M25,224 M
Number of employees15204.015204.015204.015204.015204.0
Other current assets31 M209 M-45 M-42 M2,246 M
Other equity adjustments-35 M-203 M-65 M-276 M1,036 M
Other fixed assets1,970 M5,340 M5,386 M10,388 M23,033 M
Other non-current assets96 M119 M56 M5,596 M7,512 M
Other non-current liabilities931 M62 M86 M3,540 M5,144 M
Other receivable139 M108 M214 M339 M1,381 M
OtherCurrentBorrowings199 M1,020 M381 M7,298 M5,277 M
OtherCurrentLiabilities220 M310 M345 M687 M385 M
OtherInventories39 M96 M122 M221 M510 M
OtherPayable2,597 M3,133 M2,836 M4,700 M
Payables5,738 M6,599 M9,731 M13,954 M25,895 M
Preferred securities of subsidiary trust4 M
PreferredSecuritiesOutsideStockEquity1,329 M1,456 M4,691 M
PreferredStock4 M
Prepaid expenses357 M162 M130 M1,850 M2,246 M
Raw materials696 M511 M580 M1,008 M2,974 M
RecievablesAdjustmentsAllowances-86 M-41 M-90 M
Restricted cash57 M83 M78 M2,994 M3,154 M
Retained earnings-35,040 M-46,326 M-51,648 M-55,634 M-69,914 M
Short term debt2,069 M1,208 M1,931 M7,298 M5,277 M
TaxesReceivable1,019 M1,254 M944 M1,040 M
Total assets18,843 M14,582 M54,642 M82,884 M96,264 M
Total current assets12,170 M4,928 M46,207 M63,641 M59,150 M
Total current liabilities8,593 M9,499 M13,976 M29,198 M45,852 M
Total equity6,837 M-6,300 M27,169 M34,710 M23,868 M
Total liabilities12,021 M20,860 M22,780 M44,820 M68,617 M
Total non-current assets6,673 M9,654 M8,435 M19,242 M37,114 M
Total non-current liabilities3,428 M11,361 M8,803 M15,622 M22,765 M
TotalEquityGrossMinority6,821 M-6,278 M27,171 M34,786 M24,090 M
TotalEquityGrossMinorityInterest6,821 M-6,278 M27,171 M34,786 M24,090 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest18,843 M14,582 M54,642 M82,884 M96,264 M
TotalNonCurrentLiabilitiesNetMinorityInteres3,428 M11,361 M8,803 M15,622 M22,765 M
TotalTaxPayable51 M44 M182 M628 M286 M
Treasury stock-9 M3 M-1,850 M-1,850 M
Work in progress7 M2 M3 M4 M171 M
Working capital3,576 M-4,571 M32,231 M34,443 M13,298 M
ltinv148 M115 M300 M3,059 M6,356 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