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

SNY Balance Sheet

Annual
Invalid dateDec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
"""debtc"""1,275 M2,633 M4,815 M2,999 M3,452 M4,451 M2,045 M
Accounts payable4,633 M5,041 M5,313 M5,295 M6,180 M7,328 M
Accounts receivable7,216 M7,260 M7,937 M7,491 M7,568 M8,424 M9,296 M
Accrued expenses6,200 M6,323 M6,345 M6,713 M7,476 M8,792 M7,925 M
Accumulated depreciation & depletion-12,399 M-13,046 M-14,134 M-14,317 M-15,579 M-14,610 M
Additional paid in capital52,862 M13 M147 M362 M532 M
Building & improvements6,768 M6,883 M7,282 M6,828 M7,170 M7,681 M
Cash and equivalents10,315 M6,925 M9,427 M13,915 M10,098 M677 M8,710 M
CashCashEquivalentsAndShortTermInvestments2,847 M3,402 M3,591 M201 M250 M677 M8,710 M
CashEquivalents9,843 M6,264 M8,726 M12,771 M8,740 M
Common par2,508 M2,495 M2,508 M2,518 M2,527 M74,040 M
Common stock equity58,070 M58,876 M58,934 M63,106 M68,681 M74,784 M74,040 M
CommonStock2,508 M2,495 M2,508 M2,518 M2,527 M74,040 M
Construction in progress2,297 M2,484 M2,391 M2,454 M3,097 M
Cost in excess40,264 M44,235 M44,519 M44,364 M48,056 M49,892 M49,404 M
CurrentCapitalLeaseObligation261 M232 M269 M277 M
CurrentDeferredAssets164 M248 M175 M242 M
CurrentDeferredRevenue252 M319 M
CurrentDeferredTaxesAssets832 M1,458 M164 M248 M175 M242 M
CurrentDeferredTaxesLiabilities1,605 M3,414 M2,294 M1,770 M1,617 M1,841 M
CurrentProvisions572 M940 M790 M631 M594 M13,741 M
Deferred revenues1,605 M3,414 M2,294 M252 M319 M1,841 M
DefinedPensionBenefit53 M77 M155 M177 M408 M271 M
FinancialAssets63 M19 M37 M24 M3 M
Finished goods2,342 M2,533 M2,629 M2,521 M2,412 M2,800 M
Float term debt14,326 M22,007 M20,131 M19,745 M17,123 M14,857 M14,347 M
GoodwillAndOtherIntangibleAssets53,344 M66,124 M61,091 M62,705 M69,463 M71,532 M73,723 M
Gross fixed assets (Plant Property & Equipment)21,978 M22,697 M25,151 M24,880 M27,555 M11,684 M26,424 M
IncomeTaxPayable392 M258 M604 M309 M597 M
Intangibles13,080 M21,889 M16,572 M18,341 M21,407 M21,640 M24,319 M
Inventories6,818 M7,477 M7,994 M8,352 M8,715 M8,960 M9,666 M
InventoriesAdjustmentsAllowances-913 M-792 M-902 M-836 M
Invested capital80,406 M88,883 M87,065 M90,851 M93,804 M89,641 M88,387 M
Land & improvements318 M283 M255 M236 M240 M228 M
LongTermCapitalLeaseObligation987 M931 M1,839 M1,904 M1,755 M
LongTermDebtAndCapitalLeaseObligation14,326 M22,007 M21,118 M20,676 M18,962 M16,761 M16,102 M
LongTermProvisions9,154 M7,206 M7,641 M7,315 M6,721 M7,602 M
Machinery furniture & equipment12,595 M13,047 M13,640 M13,651 M14,303 M16,861 M
Minority interest169 M159 M174 M146 M350 M368 M313 M
Net fixed assets (net PP&E)9,579 M9,651 M11,017 M10,563 M11,976 M11,684 M11,814 M
Non-current deferred income taxes1,605 M3,414 M2,294 M1,770 M1,617 M3,699 M
NonCurrentAccountsReceivable156 M164 M248 M175 M
NonCurrentDeferredAssets4,291 M4,613 M5,434 M4,176 M4,598 M5,381 M6,615 M
NonCurrentDeferredLiabilities1,605 M3,414 M2,294 M1,770 M1,617 M3,699 M
NonCurrentDeferredTaxesAssets4,291 M4,613 M5,434 M4,176 M4,598 M5,381 M6,615 M
NonCurrentNoteReceivables713 M464 M521 M537 M485 M
NonCurrentPrepaidAssets17 M126 M115 M92 M59 M114 M
Number of employees86000.086000.086000.086000.086000.086000.086000.0
Other current assets2,005 M2,917 M2,445 M2,737 M3,571 M3,532 M1,919 M
Other equity adjustments52,278 M52,925 M52,425 M56,793 M62,156 M
Other fixed assets9,579 M9,651 M1,583 M1,711 M2,745 M1,654 M
Other non-current assets3,398 M3,039 M2,828 M2,817 M3,216 M3,180 M2,833 M
Other non-current liabilities1,026 M963 M508 M387 M577 M7,025 M501 M
Other receivable627 M627 M735 M567 M805 M15 M
OtherCurrentBorrowings1,275 M2,633 M4,554 M2,767 M3,183 M4,174 M
OtherCurrentLiabilities5,494 M5,491 M6,459 M6,643 M7,328 M12,126 M496 M
OtherEquityAdjustments52,278 M52,925 M52,425 M56,793 M62,156 M
OtherPayable387 M497 M413 M467 M559 M6,813 M
Payables6,200 M6,323 M6,345 M6,713 M7,476 M8,792 M7,925 M
PreferredSecuritiesOutsideStockEquity508 M387 M577 M
Prepaid expenses336 M469 M493 M525 M615 M768 M
Raw materials1,041 M1,099 M1,163 M975 M1,278 M1,550 M
RecievablesAdjustmentsAllowances-95 M
Restricted cash315 M
Short term debt1,275 M2,633 M4,554 M2,767 M3,183 M4,174 M2,045 M
TaxesReceivable832 M1,458 M1,411 M1,895 M1,414 M374 M391 M
Total assets99,813 M111,408 M112,736 M114,413 M120,242 M113,986 M126,464 M
Total current assets26,388 M24,647 M28,936 M33,786 M30,653 M22,209 M30,670 M
Total current liabilities15,463 M17,376 M20,387 M19,280 M21,295 M27,210 M24,207 M
Total equity58,070 M58,876 M58,934 M63,106 M68,681 M74,784 M74,040 M
Total liabilities41,574 M52,373 M53,370 M51,161 M51,211 M50,996 M52,111 M
Total non-current assets73,425 M86,761 M83,800 M80,261 M89,253 M91,777 M95,794 M
Total non-current liabilities26,111 M34,997 M33,241 M31,881 M29,916 M23,786 M27,904 M
TotalEquityGrossMinority58,239 M59,035 M59,108 M63,252 M69,031 M75,152 M74,353 M
TotalEquityGrossMinorityInterest58,239 M59,035 M59,108 M63,252 M69,031 M75,152 M74,353 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest99,813 M111,408 M112,736 M114,413 M120,242 M113,986 M126,464 M
TotalNonCurrentLiabilitiesNetMinorityInteres26,111 M34,997 M33,241 M31,881 M29,916 M23,786 M27,904 M
TotalTaxPayable1,180 M785 M619 M951 M737 M1,979 M597 M
Treasury stock-14 M-153 M-9 M-705 M-939 M
Work in progress4,348 M4,637 M5,104 M4,856 M5,025 M5,316 M
Working capital1,818 M266 M-1,158 M-1,910 M-3,751 M-5,001 M6,463 M
ltinv5,365 M5,531 M5,266 M2,105 M2,422 M424 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