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

ST Balance Sheet

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
Accounts payable288 M291 M299 M323 M380 M377 M394 M459 M532 M482 M
Accounts receivable445 M468 M500 M557 M582 M558 M577 M653 M742 M744 M
Accrued expenses295 M313 M323 M614 M625 M628 M738 M829 M923 M821 M
Accumulated depreciation & depletion-386 M-475 M-560 M-656 M-714 M-821 M-917 M-1,016 M-1,112 M-1,227 M
Additional paid in capital1,610 M1,626 M1,643 M1,663 M1,691 M1,725 M1,760 M1,812 M1,866 M1,902 M
Cash and equivalents211 M342 M351 M753 M730 M774 M1,862 M1,709 M1,226 M508 M
CashCashEquivalentsAndShortTermInvestments211 M342 M351 M753 M730 M774 M1,862 M1,709 M1,226 M508 M
CashEquivalents211 M342 M351 M753 M730 M774 M
Common par2 M2 M2 M2 M2 M2 M2 M2 M2 M2 M
Common stock equity1,303 M1,669 M1,942 M2,346 M2,608 M2,574 M2,705 M3,095 M3,111 M2,996 M
CommonStock2 M2 M2 M2 M2 M2 M2 M2 M2 M2 M
Cost in excess2,425 M3,020 M3,005 M3,005 M3,081 M3,094 M3,111 M3,502 M3,911 M3,543 M
CurrentAccruedExpenses260 M218 M216 M325 M344 M347 M307 M
CurrentCapitalLeaseObligation10 M10 M28 M26 M30 M31 M30 M29 M27 M37 M
CurrentDeferredAssets15 M
CurrentDeferredRevenue15 M
CurrentDeferredTaxesAssets15 M359 M270 M191 M301 M275 M368 M359 M313 M298 M
CurrentDeferredTaxesLiabilities13 M636 M556 M428 M440 M440 M-543 M-593 M-577 M-525 M
Deferred revenues13 M
DeferredFinancingCosts-28 M-27 M-30 M-24 M
DefinedPensionBenefit109 M84 M88 M
EmployeeBenefits36 M34 M35 M40 M34 M36 M48 M39 M36 M38 M
Finished goods127 M155 M169 M195 M187 M198 M170 M201 M203 M224 M
Float term debt2,826 M3,565 M3,241 M3,242 M3,234 M3,227 M757 M7 M256 M2 M
GoodwillAndOtherIntangibleAssets3,336 M4,282 M4,081 M3,926 M3,978 M3,865 M3,803 M4,449 M4,911 M4,426 M
Gross fixed assets (Plant Property & Equipment)976 M1,169 M1,284 M1,406 M1,501 M1,652 M1,721 M1,837 M1,953 M2,113 M
IncomeTaxPayable8 M22 M24 M32 M27 M35 M19 M27 M44 M32 M
Intangibles911 M1,263 M1,075 M920 M897 M771 M692 M947 M1,000 M884 M
InterestPayable23 M26 M37 M37 M41 M43 M54 M45 M-196 M-182 M
Inventories356 M359 M390 M446 M492 M507 M451 M588 M645 M713 M
Invested capital4,129 M5,233 M5,183 M5,587 M5,843 M5,801 M6,676 M7,317 M7,326 M6,373 M
Leases24 M22 M20 M16 M
LongTermCapitalLeaseObligation57 M55 M47 M43 M50 M
LongTermDebtAndCapitalLeaseObligation2,826 M3,565 M3,241 M3,242 M3,234 M3,227 M3,971 M4,222 M4,215 M3,376 M
LongTermProvisions45 M36 M32 M29 M31 M29 M28 M27 M25 M23 M
Net fixed assets (net PP&E)589 M694 M724 M750 M787 M831 M804 M821 M841 M886 M
Non-current deferred income taxes363 M390 M393 M338 M226 M251 M260 M339 M365 M359 M
NonCurrentDeferredAssets17 M26 M21 M33 M28 M21 M85 M105 M101 M132 M
NonCurrentDeferredLiabilities363 M390 M393 M338 M226 M251 M260 M339 M365 M359 M
NonCurrentDeferredTaxesAssets17 M26 M21 M33 M28 M21 M85 M105 M101 M132 M
NonCurrentPensionAndOtherPostretirementBenefitPlans36 M34 M35 M40 M34 M36 M48 M39 M36 M38 M
Number of employees21300.021300.021300.021300.021300.021300.021300.021300.021300.021300.0
Other current assets23 M38 M46 M60 M90 M118 M201 M224 M225 M187 M
Other equity adjustments-12 M-26 M-34 M-63 M-26 M-20 M
Other fixed assets804 M821 M841 M886 M
Other non-current assets27 M18 M74 M85 M87 M152 M173 M162 M129 M135 M
Other non-current liabilities42 M40 M29 M34 M39 M90 M94 M63 M82 M67 M
Other receivable3,307 M3,522 M3,451 M3,046 M3,821 M-4,029 M-4,054 M
OtherCurrentLiabilities223 M252 M246 M4 M7 M15 M85 M99 M86 M73 M
OtherInventories11 M10 M10 M11 M451 M588 M645 M713 M
Payables295 M313 M323 M354 M407 M412 M413 M486 M576 M514 M
Preferred securities of subsidiary trust400 M400 M400 M
PreferredStock400 M400 M400 M
Prepaid expenses91 M109 M100 M93 M113 M127 M90 M126 M162 M137 M
Raw materials160 M142 M146 M158 M201 M205 M194 M285 M325 M376 M
RecievablesAdjustmentsAllowances-14 M-15 M-19 M-17 M-24 M-29 M
Restricted cash1,862 M1,709 M1,226 M508 M
Retained earnings67 M391 M637 M1,032 M1,341 M1,616 M1,728 M2,113 M2,367 M2,306 M
SecuritySoldNotYetRepurchased12 M50000.05 M3 M399 M350 M-35 M-48 M-292 M-88 M
Total assets5,117 M6,299 M6,241 M6,642 M6,798 M6,835 M7,844 M8,614 M8,756 M7,681 M
Total current assets1,119 M1,278 M1,341 M1,848 M1,917 M1,966 M2,980 M3,077 M2,775 M2,102 M
Total current liabilities678 M865 M583 M629 M640 M635 M1,495 M836 M1,179 M824 M
Total equity1,303 M1,669 M1,942 M2,346 M2,608 M2,574 M2,705 M3,095 M3,111 M2,996 M
Total liabilities3,814 M4,630 M4,299 M4,296 M4,189 M4,261 M5,139 M5,519 M5,645 M4,685 M
Total non-current assets3,969 M5,021 M4,899 M4,793 M4,881 M4,869 M4,864 M5,537 M5,981 M5,579 M
Total non-current liabilities3,311 M4,066 M3,730 M3,682 M3,564 M3,633 M4,401 M4,690 M4,723 M3,863 M
TotalEquityGrossMinority1,303 M1,669 M1,942 M2,346 M2,608 M2,574 M2,705 M3,095 M3,111 M2,996 M
TotalEquityGrossMinorityInterest1,303 M1,669 M1,942 M2,346 M2,608 M2,574 M2,705 M3,095 M3,111 M2,996 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest5,117 M6,299 M6,241 M6,642 M6,798 M6,835 M7,844 M8,614 M8,756 M7,681 M
TotalNonCurrentLiabilitiesNetMinorityInteres3,311 M4,066 M3,730 M3,682 M3,564 M3,633 M4,401 M4,690 M4,723 M3,863 M
TotalTaxPayable8 M22 M24 M32 M27 M35 M19 M27 M44 M32 M
Treasury stock-365 M-325 M-307 M-288 M-399 M-749 M-785 M-832 M-1,125 M-1,213 M
UnearnedPremiums-3 M-2 M
Work in progress69 M62 M75 M93 M104 M104 M87 M102 M118 M113 M
Working capital441 M413 M758 M1,219 M1,277 M1,331 M1,485 M2,241 M1,596 M1,279 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