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

NTES Balance Sheet

Annual
Dec-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
"""debtc"""976 M2,050 M2,273 M3,816 M6,624 M13,659 M17,020 M19,836 M19,687 M3,499 M
Accounts payable339 M548 M856 M1,569 M2,443 M1,201 M1,212 M1,134 M985 M219 M
Accounts receivable403 M873 M2,614 M4,251 M3,620 M4,002 M4,169 M4,576 M5,508 M725 M
Accrued expenses1,164 M2,015 M3,820 M6,508 M9,334 M9,897 M11,080 M14,047 M16,119 M14,840 M
AccruedInterestReceivable246 M305 M258 M274 M418 M511 M524 M682 M677 M
Accumulated depreciation & depletion-899 M-968 M-1,118 M-1,403 M-1,775 M-2,629 M-3,506 M-4,436 M-5,277 M-6,270 M
Additional paid in capital855 M1,226 M1,779 M1,638 M1,753 M3,914 M27,829 M37,916 M3,314 M
Building & improvements610 M570 M667 M1,208 M1,497 M1,408 M3,451 M3,714 M4,721 M
Cash and equivalents1,458 M2,021 M6,071 M5,439 M2,764 M4,977 M3,246 M9,117 M14,498 M4,000 M
CashCashEquivalentsAndShortTermInvestments3,273 M4,999 M8,081 M15,891 M18,434 M21,344 M21,709 M25,442 M15,008 M11,623 M
CashEquivalents2,372 M2,941 M3,067 M4,309 M8,691 M4,692 M3,150 M3,051 M2,726 M391 M
Common par3 M3 M3 M3 M3 M3 M3 M3 M3 M393000.0
Common stock equity20,245 M23,390 M29,240 M38,191 M45,732 M45,232 M61,454 M82,127 M95,328 M15,185 M
CommonStock3 M3 M3 M3 M3 M3 M3 M3 M3 M393000.0
Construction in progress197 M575 M1,091 M663 M1,087 M1,567 M466 M784 M653 M
Cost in excess319 M595 M2,166 M
CurrentAccruedExpenses323 M516 M1,121 M1,415 M2,919 M3,441 M3,396 M4,802 M5,936 M11,808 M
CurrentCapitalLeaseObligation230 M191 M331 M334 M38 M
CurrentDeferredAssets129 M202 M411 M536 M823 M155 M
CurrentDeferredRevenue1,945 M2,590 M5,408 M8,853 M7,793 M9,088 M10,142 M12,314 M14,696 M1,815 M
CurrentDeferredTaxesAssets129 M202 M411 M536 M823 M1,064 M904 M1,087 M1,481 M
CurrentDeferredTaxesLiabilities149 M102 M167 M359 M
Deferred revenues2,094 M2,692 M5,575 M8,853 M7,793 M9,088 M10,142 M12,314 M14,696 M1,815 M
DividendsPayable1,983 M1,468 M2,546 M3,258 M1,440 M8,841 M4,280 M6,724 M
Float term debt1,275 M530 M
GoodwillAndOtherIntangibleAssets13 M108 M191 M843 M820 M5,733 M7,346 M8,623 M7,321 M
Gross fixed assets (Plant Property & Equipment)1,783 M2,327 M3,449 M3,823 M6,138 M7,301 M8,591 M9,759 M11,755 M6,399 M
IncomeTaxPayable35 M288 M620 M1,361 M1,410 M1,969 M3,157 M3,286 M3,459 M2,813 M
Intangibles13 M108 M191 M843 M820 M5,733 M7,346 M8,304 M6,725 M
Inventories28 M818 M1,578 M5,475 M1,066 M651 M592 M965 M144 M
Invested capital20,245 M23,390 M29,240 M38,191 M45,732 M45,232 M61,454 M82,127 M15,159 M15,715 M
Land & improvements11 M78 M239 M589 M593 M3,503 M3,707 M
Leases42 M41 M25 M40 M98 M165 M153 M192 M288 M
LineOfCredit19,505 M19,352 M
LoansReceivable14 M57 M36 M46 M31 M20 M21 M6 M42 M
LongTermCapitalLeaseObligation280 M475 M732 M98 M
LongTermDebtAndCapitalLeaseObligation280 M475 M2,007 M627 M
LongTermProvisions-2 M4 M4 M10 M61 M51 M-31 M41 M61 M
Machinery furniture & equipment922 M1,064 M1,428 M1,912 M2,863 M4,161 M4,522 M5,069 M6,094 M
Minority interest-77 M-32 M84 M272 M703 M794 M1,139 M11,667 M4,096 M601 M
Net fixed assets (net PP&E)883 M1,359 M2,331 M2,420 M4,363 M4,672 M5,085 M5,323 M6,478 M129 M
Non-current deferred income taxes81 M392 M213 M393 M382 M713 M1,346 M308 M
NonCurrentAccountsReceivable1,600 M198 M157 M
NonCurrentDeferredAssets23 M21 M25 M560 M823 M1,064 M904 M1,087 M1,298 M215 M
NonCurrentDeferredLiabilities81 M392 M213 M393 M382 M713 M1,346 M308 M
NonCurrentDeferredRevenue450000.0200000.0200000.0200000.0
NonCurrentDeferredTaxesAssets23 M21 M25 M560 M823 M1,064 M904 M1,087 M1,298 M215 M
NonCurrentNoteReceivables98 M72 M64 M55 M
NonCurrentPrepaidAssets3 M8 M25 M88 M93 M106 M141 M166 M151 M
Number of employees32064.032064.032064.032064.032064.032064.032064.032064.032064.032064.0
Other current assets25 M45 M120 M87 M233 M91 M118 M100 M126 M13,345 M
Other equity adjustments878 M937 M1,038 M1,222 M1,243 M1,232 M1,144 M578 M417 M63 M
Other fixed assets872 M1,281 M2,092 M2,420 M3,769 M5,379 M4,622 M773 M5,434 M129 M
Other non-current assets60 M75 M1,302 M2,217 M199 M1,234 M217 M242 M436 M6,806 M
Other non-current liabilities145 M134 M85 M200000.018 M49 M177 M149 M366 M88 M
Other receivable22 M27 M38 M50 M54,102 M51,179 M59,241 M1,360 M837 M96,496 M
OtherCurrentBorrowings976 M2,050 M2,273 M3,816 M6,624 M13,659 M16,828 M19,505 M
OtherCurrentLiabilities2,624 M3,304 M6,175 M9,971 M8,898 M2,466 M2 M546 M204 M
OtherEquityAdjustments878 M937 M1,038 M1,222 M1,243 M1,232 M1,144 M578 M417 M
OtherEquityInterest878 M937 M1,011 M1,160 M1,206 M1,215 M1,215 M1,228 M195 M185 M
OtherPayable428 M616 M1,107 M1,801 M2,408 M2,993 M3,315 M3,828 M4,661 M
Payables841 M1,498 M2,699 M5,093 M6,415 M6,455 M7,683 M9,245 M10,183 M3,032 M
PreferredSecuritiesOutsideStockEquity134 M615 M5,386 M10,449 M10,796 M145 M
Prepaid expenses859 M1,016 M2,283 M3,290 M3,134 M3,303 M4,154 M3,927 M4,554 M5,448 M
RecievablesAdjustmentsAllowances-8 M-11 M-14 M-24 M-85 M-131 M-77 M-113 M-403 M
Restricted cash2,137 M2,629 M2,193 M3,473 M5,927 M4,692 M3,150 M3,051 M2,877 M2,699 M
Retained earnings18,509 M21,224 M26,420 M35,329 M42,733 M43,997 M56,394 M64,163 M77,494 M13,205 M
Short term debt976 M2,050 M2,273 M3,816 M6,624 M13,659 M16,828 M19,505 M19,352 M3,462 M
Total assets24,546 M30,355 M41,157 M58,032 M71,031 M86,968 M112,124 M141,875 M153,644 M25,048 M
Total current assets22,798 M27,733 M34,409 M49,383 M61,948 M68,716 M85,105 M107,831 M113,120 M19,081 M
Total current liabilities4,233 M6,756 M11,667 M19,176 M23,750 M35,109 M38,243 M46,743 M50,501 M8,239 M
Total equity20,245 M23,390 M29,240 M38,191 M45,732 M45,232 M61,454 M82,127 M95,328 M15,185 M
Total liabilities4,378 M6,997 M11,834 M19,569 M24,596 M40,942 M49,532 M48,081 M54,220 M9,263 M
Total non-current assets1,749 M2,622 M6,749 M8,648 M9,084 M18,252 M27,019 M34,044 M40,524 M5,967 M
Total non-current liabilities145 M240 M166 M392 M846 M5,833 M11,289 M1,337 M3,719 M1,023 M
TotalEquityGrossMinority20,168 M23,358 M29,324 M38,463 M46,435 M46,026 M62,593 M82,998 M99,279 M108,737 M
TotalEquityGrossMinorityInterest20,168 M23,358 M29,324 M38,463 M46,435 M46,026 M62,593 M82,998 M99,279 M108,737 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest24,546 M30,355 M41,157 M58,032 M71,031 M86,968 M112,124 M141,875 M153,644 M25,048 M
TotalNonCurrentLiabilitiesNetMinorityInteres145 M240 M166 M392 M846 M5,833 M11,289 M1,337 M3,719 M1,023 M
TotalTaxPayable74 M334 M736 M1,723 M1,565 M2,261 M3,157 M4,283 M4,537 M2,813 M
Treasury stock99 M132 M1,199 M2,062 M7,593 M1 M-10,446 M-20,502 M-1,582 M
Working capital18,565 M20,976 M22,742 M30,207 M38,198 M33,607 M46,862 M61,088 M9,826 M10,841 M
ltinv766 M1,050 M2,875 M2,520 M2,785 M5,345 M11,654 M18,341 M24,629 M18,544 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