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



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







Analyst Estimates

Financial Health





StockDividendMarket Cap (B)PEPrice ($)

NVS Income Statement

Invalid dateDec-18Dec-19Dec-20Dec-21Dec-22Dec-23
AcquiredInProcessRnD664 M11,732 M
AcquiredInProcessRnDIncome8,072 M
AllowancesForConstruction218 M
Basic EPS from continuing operations3.123.5510.717.15
Basic EPS total5.445.123.5510.713.197.15
Basic weighted shares outstanding2,319 M2,291 M2,277 M2,243 M1,778 M2,077 M
Cost of sales-14,510 M-14,425 M-15,121 M-15,867 M-15,486 M12,472 M
Depletion472 M
Depreciation-305 M-330 M
Depreciation unreconciled472 M
DepreciationAndAmortization-305 M-330 M
DevelopmentExpense167 M
Diluted EPS total5.385.063.5210.633.177.1
Diluted normalized net income/share3.083.5210.637.1
Diluted weighted shares outstanding17,838 M16,113 M20,350 M11,517 M1,789 M2,092 M
Dividends paid per share3.463.2
Earnings from equity interest6,438 M659 M673 M15,339 M-9 M-13 M
EarningsFromEquityInterestNetOfTax6,438 M659 M673 M15,339 M-9 M-13 M
GainOnSaleOfBusiness4,691 M
GainOnSaleOfPPE12,611 M
GainOnSaleOfSecurity-184 M
GainsLossOnDisposalOfDiscontinuedOperations-186 M4,590 M
GeneralAndAdministrativeExpense16,533 M
Gross operating profit31,589 M34,252 M34,777 M37,010 M36,342 M34,188 M
ImpairmentOfCapitalAssets-37 M
Income before tax14,095 M8,940 M9,878 M26,137 M8,371 M9,123 M
Income restructuring and M&A3,171 M
Income taxes-11,505 M-5,354 M-6,264 M2,119 M1,416 M551 M
InsuranceAndClaims823 M
Interest income292 M245 M91 M71 M379 M627 M
InterestExpenseNonOperating932 M850 M869 M811 M837 M986 M
InterestExpenseOperating855 M
InterestIncomeOperating142 M
MinorityInterests3 M5 M-1000000.0-3 M-4 M
MiscOtherSpecialCharges14,240 M2,031 M1,742 M1,852 M805 M1,772 M
Net income from total operations81,409 M81,530 M71,633 M46,785 M5,672 M14,850 M
NetIncomeCommonStockholders81,409 M81,530 M71,633 M24,021 M6,955 M14,850 M
NetIncomeContinuousOperations81,409 M81,530 M71,633 M46,785 M5,672 M8,572 M
NetIncomeDiscontinuousOperations-186 M9,180 M6,282 M
NetNonOperatingInterestIncomeExpense-746 M-805 M-947 M-891 M-633 M-419 M
Operating income50,155 M53,374 M55,830 M11,689 M9,197 M7,997 M
Operating income before depreciation (EBITDA)15,027 M9,790 M10,747 M26,948 M9,208 M
OperatingExpense24,815 M27,197 M26,367 M-25,321 M-27,145 M26,191 M
Other income net-20,678 M-2,690 M-10,487 M-15,339 M193 M-1,759 M
OtherCostofRevenue12,472 M
OtherGainLossFromDispositionOfDiscontinuedOperations4,590 M
OtherGandA16,533 M
OtherOperatingExpenses2,609 M3,426 M3,190 M-895 M-2,896 M2,303 M
RealizedCapitalGain2,440 M
RentAndLandingFees15,710 M
Research & development expense8,489 M9,402 M8,980 M9,540 M9,996 M11,371 M
ResearchExpense8,489 M9,402 M8,980 M11,371 M
RestructringAndMnAIncome3,171 M
SalariesAndWages-1,011 M
Selling Gen & administrative expense13,717 M14,369 M14,197 M14,886 M14,253 M12,517 M
SellingAndMarketingExpense13,717 M14,369 M14,197 M12,517 M
SellingExpense13,717 M14,369 M14,197 M
Special income/charges-603 M11,732 M702 M
Total Income available for interest expense (EBIT)15,027 M9,790 M10,747 M26,948 M9,208 M
Total common shares outstanding2,311 M2,265 M2,257 M2,235 M2,120 M
Total net income81,409 M81,530 M71,633 M46,785 M5,672 M14,850 M
Total ordinary shares2,044 M2,044 M2,044 M2,044 M2,044 M2,044 M
Total revenues89,480 M94,996 M97,318 M51,626 M50,545 M45,440 M
TotalExpenses10,305 M12,772 M11,246 M11,306 M12,464 M38,663 M
TotalRevenue89,480 M94,996 M97,318 M52,877 M51,828 M46,660 M
WriteDown603 M-752 M-702 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


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.


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