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

Metrics

Valuation

Returns

Risk

Ranks

Dividends

Analyst Estimates

Financial Health

Technicals

Growth

Profitability

Peers

StockDividendMarket Cap (B)PEPrice ($)
Financials

SBS Income Statement

Annual
Invalid dateDec-17Dec-18Dec-19Dec-20Dec-21Dec-22
AcquiredInProcessRnD6 M
AcquiredInProcessRnDIncome108 M
Amortization of intangibles-1,251 M-1,353 M-1,746 M2,006 M2,229 M2,424 M
Basic EPS from continuing operations3.694.154.931.423.374.57
Basic EPS total3.694.154.931.423.374.57
Basic weighted shares outstanding1,181 M1,137 M1,187 M1,867 M1,114 M1,109 M
CommissionExpenses-21250.0
Cost of sales-8,779 M9,086 M10,138 M11,180 M12,800 M14,351 M
Depreciation-51 M-39 M-65 M-31 M-75 M-106 M
Depreciation unreconciled72000.0-2,785 M-3,592 M4,013 M4,408 M4,769 M
DepreciationAndAmortization1,302 M-1,393 M-1,780 M2,037 M2,253 M2,451 M
Diluted EPS total4.154.931.423.374.57
Diluted weighted shares outstanding1,181 M1,137 M1,187 M1,867 M1,114 M1,109 M
Dividends paid per share1.031.28
GeneralAndAdministrativeExpense1,099 M997 M1,188 M1,404 M1,124 M1,399 M
Gross operating profit5,829 M6,999 M7,846 M6,618 M6,691 M7,705 M
ImpairmentOfCapitalAssets-83 M167 M128 M445 M644 M782 M
Income before tax3,504 M4,714 M5,848 M2,284 M4,596 M6,196 M
Income taxes-984 M-1,077 M-1,310 M-353 M962 M1,230 M
Interest income326 M446 M373 M337 M472 M1,092 M
InterestExpenseOperating676 M-732 M-737 M627 M-845 M-1,505 M
MiscOtherSpecialCharges1,099 M1,679 M-19 M3,244 M-22 M
Net income from total operations4,357 M4,720 M5,851 M2,651 M3,754 M5,069 M
NetIncomeCommonStockholders4,357 M4,720 M5,851 M2,651 M3,754 M5,069 M
NetIncomeContinuousOperations4,357 M4,720 M5,851 M2,651 M3,754 M5,069 M
NetIncomeFromOtherGainsLosses-984 M-1,077 M-1,310 M-353 M97 M79 M
NetNonOperatingInterestIncomeExpense326 M475 M373 M337 M472 M1,092 M
NetOperatingInterestIncomeExpense-676 M732 M737 M-627 M845 M1,505 M
Operating income4,044 M5,308 M5,855 M4,463 M4,741 M5,394 M
Operating income before depreciation (EBITDA)4,180 M1,197 M1,518 M4,948 M6,831 M7,141 M
OperatingExpense1,785 M1,690 M1,991 M2,155 M1,950 M2,310 M
OperationAndMaintenance8,779 M9,086 M10,138 M11,180 M12,800 M14,351 M
Other income net-3,151 M-2,803 M19 M-108 M-27 M-492 M
OtherGandA1,099 M997 M1,188 M1,404 M1,124 M1,399 M
OtherOperatingExpenses-10,647 M-10,944 M-12,257 M-37 M15,394 M17,443 M
RealizedCapitalGain27 M492 M
SalariesAndWages-196 M-238 M864 M
Selling Gen & administrative expense1,785 M1,690 M1,991 M2,155 M1,950 M2,310 M
SellingAndMarketingExpense686 M693 M803 M751 M826 M912 M
SellingExpense686 M693 M803 M751 M826 M912 M
Special income/charges-77 M167 M128 M445 M644 M782 M
Total Income available for interest expense (EBIT)4,180 M3,982 M5,110 M2,911 M3,751 M4,691 M
Total common shares outstanding1,469 M1,475 M1,499 M1,516 M1,458 M1,496 M
Total net income4,357 M4,720 M5,851 M2,651 M3,754 M5,069 M
Total ordinary shares684 M684 M684 M684 M684 M684 M
Total revenues14,608 M16,085 M17,984 M17,798 M19,491 M22,056 M
TotalExpenses-6,994 M10,777 M12,129 M13,335 M14,750 M16,661 M
TotalRevenue14,608 M16,085 M17,984 M17,798 M19,491 M22,056 M
WriteDown279000.0108000.0593000.0-277000.0576000.01 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.

We respect your privacy and will never share your email.
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