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

NVS Balance Sheet

Annual
Invalid dateDec-18Dec-19Dec-20Dec-21Dec-22Dec-23
"""debtc"""9,620 M7,092 M9,877 M6,502 M6,127 M230 M
Accounts payable5,556 M5,424 M5,403 M5,553 M5,146 M4,926 M
Accounts receivable8,727 M8,301 M8,217 M8,005 M8,066 M7,158 M
Accrued expenses13,372 M13,440 M11,627 M11,396 M7,679 M6,819 M
AccruedInterestReceivable12 M
Accumulated depreciation & depletion-18,332 M-14,930 M-15,955 M-15,602 M-14,109 M-11,879 M
Building & improvements14,135 M12,453 M13,340 M12,685 M12,141 M10,147 M
Cash and equivalents13,271 M11,173 M11,267 M12,407 M7,517 M13,393 M
CashCashEquivalentsAndShortTermInvestments8,352 M8,644 M9,632 M205 M143 M14,428 M
CashEquivalents10,150 M7,926 M7,517 M9,011 M4,640 M
CommercialPaper3,951 M2,289 M4,258 M893 M2,772 M
Common par944 M936 M913 M901 M890 M825 M
Common stock equity78,614 M55,474 M56,598 M67,655 M59,342 M46,667 M
CommonStock944 M936 M913 M901 M890 M825 M
Construction in progress2,042 M1,350 M1,248 M1,508 M1,184 M1,213 M
Cost in excess35,294 M26,524 M29,999 M29,595 M29,301 M23,341 M
CurrentAccruedExpenses4,577 M4,587 M2,301 M2,221 M
CurrentCapitalLeaseObligation246 M286 M275 M251 M230 M
CurrentDeferredRevenue236 M114 M56 M123 M
CurrentDeferredTaxesAssets8,782 M
CurrentDeferredTaxesLiabilities7,475 M5,867 M3,141 M3,070 M2,686 M
CurrentProvisions5,953 M7,324 M7,188 M6,931 M14,795 M13,166 M
Deferred revenues236 M114 M56 M123 M2,686 M
DefinedPensionBenefit137 M148 M673 M1,935 M910 M
EmployeeBenefits5,100 M4,627 M4,718 M3,789 M2,639 M
FinancialAssets2,345 M2,518 M2,901 M3,036 M2,411 M
Finished goods2,938 M2,317 M2,951 M2,636 M2,568 M1,448 M
Float term debt22,470 M20,353 M26,259 M22,902 M20,244 M18,436 M
GoodwillAndOtherIntangibleAssets74,013 M55,311 M66,808 M63,777 M60,945 M50,220 M
Gross fixed assets (Plant Property & Equipment)34,028 M28,676 M29,894 M28,708 M26,304 M22,803 M
IncomeTaxPayable2,038 M2,194 M2,458 M2,415 M2,533 M1,893 M
Intangibles38,719 M28,787 M36,809 M34,182 M31,644 M26,879 M
InterestPayable156 M98 M133 M127 M
Inventories6,956 M6,092 M7,242 M6,666 M7,175 M5,913 M
Invested capital129,557 M99,996 M113,427 M118,474 M59,342 M65,103 M
Land & improvements696 M1,049 M1,083 M1,014 M956 M403 M
Leases148 M
LineOfCredit701 M719 M976 M899 M863 M
LongTermCapitalLeaseObligation1,703 M1,719 M1,621 M1,538 M1,598 M
LongTermDebtAndCapitalLeaseObligation22,470 M22,056 M27,978 M24,523 M21,782 M20,034 M
LongTermProvisions848 M792 M823 M908 M689 M
Machinery furniture & equipment17,155 M13,824 M14,223 M13,501 M12,023 M9,630 M
Minority interest78 M77 M68 M167 M81 M83 M
Net fixed assets (net PP&E)15,696 M13,746 M13,939 M13,106 M12,195 M10,924 M
Non-current deferred income taxes7,475 M5,867 M3,141 M3,070 M2,686 M2,248 M
NonCurrentAccountsReceivable164 M569 M833 M895 M863 M
NonCurrentDeferredAssets9,167 M8,323 M3,933 M3,743 M3,739 M4,309 M
NonCurrentDeferredLiabilities7,475 M5,867 M3,141 M3,070 M2,686 M2,248 M
NonCurrentDeferredTaxesAssets8,699 M7,909 M3,933 M3,743 M3,739 M4,309 M
NonCurrentNoteReceivables159 M89 M78 M85 M
NonCurrentPensionAndOtherPostretirementBenefitPlans3,546 M3,469 M4,081 M3,127 M2,085 M
NonCurrentPrepaidAssets764 M
Number of employees104323.0104323.0104323.0104323.0104323.0104323.0
Other current assets5,802 M2,680 M2,523 M2,440 M2,739 M2,607 M
Other equity adjustments77,739 M54,618 M55,738 M66,802 M58,544 M45,883 M
Other fixed assets1,677 M13,939 M13,106 M12,195 M1,410 M
Other non-current assets290 M176 M219 M275 M1,110 M1,199 M
Other non-current liabilities1,371 M1,213 M1,393 M1,475 M1,578 M4,523 M
Other receivable1,360 M1,165 M963 M793 M1,001 M
OtherCurrentBorrowings4,968 M3,838 M4,357 M4,435 M2,241 M
OtherCurrentLiabilities426 M294 M2,025 M2,996 M55 M
OtherPayable673 M764 M716 M588 M
Payables8,795 M8,853 M9,326 M9,175 M7,679 M6,819 M
Prepaid expenses812 M898 M943 M1,102 M911 M
Raw materials931 M751 M967 M870 M934 M963 M
RecievablesAdjustmentsAllowances-51 M
Short term debt9,620 M6,846 M9,591 M6,227 M5,876 M
TaxesReceivable935 M870 M856 M823 M827 M426 M
Total assets145,563 M118,370 M127,778 M131,795 M117,453 M99,945 M
Total current assets35,563 M29,504 M29,673 M45,718 M36,910 M30,481 M
Total current liabilities29,607 M28,264 M33,059 M30,208 M28,656 M26,390 M
Total equity78,614 M55,474 M56,598 M67,655 M59,342 M46,667 M
Total liabilities66,871 M62,819 M71,112 M63,973 M58,030 M53,195 M
Total non-current assets110,000 M88,866 M98,105 M86,077 M80,543 M69,464 M
Total non-current liabilities37,264 M34,555 M38,053 M33,765 M29,374 M26,805 M
TotalEquityGrossMinority78,692 M55,551 M56,666 M67,822 M-11 M46,750 M
TotalEquityGrossMinorityInterest78,692 M55,551 M56,666 M67,822 M-11 M46,750 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest145,563 M118,370 M127,778 M131,795 M117,453 M99,945 M
TotalNonCurrentLiabilitiesNetMinorityInteres37,264 M34,555 M38,053 M33,765 M29,374 M26,805 M
TotalTaxPayable2,566 M2,665 M3,207 M3,034 M2,533 M1,893 M
Treasury stock-69 M-80 M-53 M-48 M-92 M-41 M
UnrealizedGainLoss45,883 M
Work in progress3,087 M3,024 M3,324 M3,160 M3,673 M3,502 M
Working capital5,956 M1,240 M-3,386 M15,510 M8,254 M4,091 M
ltinv10,697 M10,434 M11,611 M2,268 M1,606 M205 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