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 ($)

SNY Income Statement

Invalid dateDec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
AcquiredInProcessRnD12,294 M
AcquiredInProcessRnDIncome5,269 M8,324 M9,519 M11,130 M
AcquisitionExpense-47 M
AllowancesForConstruction267 M
Amortization of intangibles1,866 M2,170 M2,528 M1,681 M1,580 M2,053 M3,068 M
Basic EPS from continuing operations3.026.914.5719.644.974.31
Basic EPS total6.716.914.5719.644.974.31
Basic weighted shares outstanding1,257 M1,247 M1,250 M1,254 M1,253 M1,252 M1,252 M
Cost of sales-11,613 M11,435 M11,976 M12,159 M12,255 M13,695 M14,236 M
Depreciation420 M
Depreciation unreconciled2,286 M2,170 M2,528 M1,681 M1,580 M2,053 M3,068 M
DepreciationAndAmortization2,286 M2,170 M2,528 M1,681 M1,580 M2,053 M3,068 M
Diluted EPS total6.666.874.5419.544.954.3
Diluted normalized net income/share2.996.874.5419.544.954.3
Diluted weighted shares outstanding671 M1,247 M1,250 M1,254 M1,253 M1,252 M1,256 M
Dividends paid per share3.913.76
Earnings from equity interest85 M499 M3,712 M8,666 M106 M68 M
EarningsFromEquityInterestNetOfTax85 M499 M3,712 M8,666 M106 M68 M
ExciseTaxes137 M39 M
Fees78 M
GainOnSaleOfBusiness5,751 M-4 M8,371 M
GainOnSaleOfPPE162 M2,806 M9,519 M
GainOnSaleOfSecurity7,398 M
GainsLossOnDisposalOfDiscontinuedOperations4,643 M-13 M-101 M
GeneralAndAdministrativeExpense435 M-47 M64 M4 M440 M
Gross operating profit24,608 M27,334 M24,150 M23,843 M25,563 M29,302 M32,208 M
ImpairmentOfCapitalAssets-254 M-94 M444 M330 M-494 M-559 M
Income before tax15,009 M14,274 M7,597 M28,398 M24,575 M28,492 M7,153 M
Income restructuring and M&A-731 M-1,480 M-1,062 M1,089 M820 M1,336 M1,490 M
Income taxes1,722 M481 M139 M1,807 M1,558 M2,006 M1,717 M
InsuranceAndClaims-47 M64 M4 M440 M
Interest income8,563 M164 M169 M53 M40 M206 M591 M
InterestExpenseNonOperating1,313 M
InterestExpenseOperating313 M826 M-315 M-686 M-654 M
InterestIncomeOperating72 M92 M37 M6,223 M118 M
LossAndLossAdjustmentExpectedIncurred-201 M
MarketingExpense-124 M
MinorityInterests121 M104 M31 M36 M56 M113 M-36 M
MiscOtherSpecialCharges33 M24 M2,067 M5,336 M6,223 M992 M1,254 M
Net income from total operations18,051 M13,884 M7,388 M26,627 M23,019 M26,599 M5,400 M
NetIncomeCommonStockholders18,051 M13,884 M7,388 M26,627 M23,019 M26,599 M5,400 M
NetIncomeContinuousOperations18,051 M13,884 M7,388 M26,627 M23,019 M26,599 M5,436 M
NetIncomeDiscontinuousOperations4,643 M-13 M-101 M-35 M-4 M
NetNonOperatingInterestIncomeExpense8,669 M164 M169 M53 M40 M129 M-722 M
Operating income3,743 M7,386 M460 M5,634 M6,922 M6,710 M8,204 M
Operating income before depreciation (EBITDA)17,295 M16,757 M6,969 M25,337 M29,891 M
OperatingExpense19,489 M19,948 M23,690 M18,209 M18,641 M22,592 M24,004 M
Other income net-5,836 M-5,764 M-6,548 M-15,812 M-15,848 M-19,380 M-1,161 M
Other special charges435 M63 M368 M
OtherCostofRevenue14,236 M
OtherGandA435 M-47 M64 M4 M440 M
OtherImpairmentOfCapitalAssets216 M
OtherOperatingExpenses233 M548 M1,207 M1,415 M1,805 M2,531 M3,516 M
RealizedCapitalGain30 M16 M
Research & development expense5,472 M5,863 M6,018 M5,530 M5,692 M6,706 M6,728 M
ResearchExpense5,472 M5,863 M6,018 M5,530 M5,692 M6,706 M6,728 M
RestructringAndMnAIncome-731 M-1,480 M-1,062 M1,089 M820 M1,336 M1,490 M
Revenue per share1,866 M2,170 M2,528 M1,681 M1,580 M2,053 M3,068 M
SalariesAndWages1,426 M1,579 M4,101 M-136 M5 M370 M
Selling Gen & administrative expense10,072 M9,788 M9,883 M9,719 M9,559 M10,932 M10,692 M
SellingAndMarketingExpense10,072 M9,788 M9,883 M9,655 M9,555 M10,492 M10,692 M
SellingExpense10,072 M9,859 M9,883 M9,779 M9,555 M10,492 M
Special income/charges985 M-435 M-331 M10,875 M-694 M-777 M-1,490 M
Total Income available for interest expense (EBIT)15,009 M14,587 M4,936 M28,083 M23,835 M27,838 M
Total common shares outstanding1,254 M1,245 M1,254 M1,251 M1,264 M1,261 M
Total net income18,051 M13,884 M7,388 M26,627 M23,019 M26,599 M5,400 M
Total ordinary shares2,530 M2,530 M2,530 M2,530 M2,530 M2,530 M2,530 M
Total revenues35,072 M38,769 M36,126 M36,041 M37,740 M42,997 M46,444 M
TotalExpenses7,876 M31,383 M35,666 M30,368 M30,896 M36,287 M38,240 M
TotalRevenue34,935 M38,769 M36,126 M36,002 M37,818 M42,997 M46,444 M
WriteDown-113 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