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

SPLK Income Statement

Annual
Jan-14Jan-15Jan-16Jan-17Jan-18Jan-19Jan-20Jan-21Jan-22Jan-23
Amortization of intangibles19 M19 M123 M125 M161 M503 M1,293 M1,417 M
Basic EPS from continuing operations-0.75-1.81-2.2-2.65-1.85-1.89-2.22-5.68-8.29-1.71
Basic EPS total-0.75-1.81-2.2-2.65-1.85-1.89-2.22-5.68-8.29-1.71
Basic weighted shares outstanding105 M120 M127 M134 M140 M146 M152 M160 M162 M162 M
CommissionExpenses54 M61 M89 M109 M116 M174 M209 M156 M
Cost of sales36 M68 M114 M191 M256 M345 M430 M547 M734 M816 M
Depreciation29 M43 M
DepreciationAndAmortization29 M43 M
Diluted EPS total-0.75-1.81-2.2-2.65-1.85-1.89-2.22-5.68-8.29-1.71
Diluted normalized net income/share-8.29-1.71
Diluted weighted shares outstanding105 M120 M127 M134 M140 M146 M152 M162 M162 M
GainOnSaleOfPPE3 M-10 M
GainOnSaleOfSecurity2000.0-66000.0-174000.0-911000.01 M1 M-5 M
GeneralAndAdministrativeExpense54 M103 M122 M153 M159 M238 M333 M335 M522 M455 M
Gross operating profit267 M382 M554 M759 M1,053 M1,458 M1,929 M1,682 M1,940 M2,838 M
Income before tax-79 M-215 M-287 M-350 M-189 M-263 M-332 M-901 M-1,321 M-265 M
Income restructuring and M&A230 M302 M9 M-5 M
Income taxes6000.02 M-8 M6 M1 M12 M5 M7 M18 M12 M
Interest income225000.0754000.02 M-3 M9 M31 M54 M14 M3 M25 M
InterestExpenseNonOperating9 M42 M96 M123 M175 M46 M
MiscOtherSpecialCharges-920000.0216000.0-519000.0-3 M-4 M-2 M-2 M-12 M-2 M-9 M
Net income from total operations-79 M-217 M-279 M-355 M-190 M-276 M-337 M-908 M-1,339 M-278 M
NetIncomeCommonStockholders-79 M-217 M-279 M-355 M-190 M-276 M-337 M-908 M-1,339 M-278 M
NetIncomeContinuousOperations-79 M-217 M-279 M-355 M-190 M-276 M-337 M-908 M-1,339 M-278 M
NetNonOperatingInterestIncomeExpense225000.0754000.02 M-3 M149000.0-11 M-42 M-109 M-172 M-21 M
Normalized income-49 M-360 M-963 M-221 M-154 M-224 M-281 M-710 M-997 M-200 M
Operating income-78 M-216 M-288 M-344 M-185 M-251 M-287 M-780 M-1,147 M-236 M
Operating income before depreciation (EBITDA)-72 M-202 M-266 M-317 M-92 M-68 M7 M-444 M-760 M-3 M
OperatingExpense345 M598 M842 M1,103 M1,238 M1,710 M2,216 M2,462 M3,087 M3,073 M
Other income net920000.0-216000.0519000.03 M4 M2 M2 M12 M2 M9 M
OtherGandA54 M103 M122 M153 M159 M238 M333 M335 M522 M455 M
OtherImpairmentOfCapitalAssets2 M
OtherOperatingExpenses-3 M-3 M-4 M-4 M-9 M-7 M-7 M-18 M
OtherWriteOff203000.0285000.040000.056000.08000.022000.0504000.0106000.07 M
PromotionAndAdvertising6 M8 M13 M10 M10 M17 M30 M24 M
RentAndLandingFees6 M11 M12 M28 M17 M-2 M
Research & development expense76 M151 M215 M296 M301 M442 M620 M791 M1,030 M997 M
ResearchExpense76 M151 M215 M296 M301 M442 M620 M997 M
RestructringAndMnAIncome230 M302 M9 M-5 M
Revenue per share19 M19 M123 M125 M161 M531 M1,373 M1,427 M
SalariesAndWages69 M214 M292 M378 M358 M-7 M
Selling Gen & administrative expense269 M448 M627 M807 M937 M1,268 M1,596 M1,671 M2,057 M2,076 M
SellingAndMarketingExpense215 M344 M505 M654 M778 M1,030 M1,264 M1,336 M1,535 M1,622 M
Special income/charges-230 M-302 M-9 M5 M
Total Income available for interest expense (EBIT)-79 M-215 M-287 M-350 M-180 M-221 M-235 M-778 M-1,146 M-219 M
Total common shares outstanding118 M125 M132 M138 M144 M150 M159 M164 M161 M166 M
Total net income-79 M-217 M-279 M-355 M-190 M-276 M-337 M-908 M-1,339 M-278 M
Total ordinary shares169 M169 M169 M169 M169 M169 M169 M169 M169 M169 M
Total revenues303 M451 M668 M950 M1,309 M1,803 M2,359 M2,229 M2,674 M3,654 M
TotalExpenses381 M667 M956 M1,294 M1,495 M2,054 M2,646 M3,010 M3,820 M3,889 M
TotalRevenue303 M451 M668 M950 M1,309 M1,803 M2,359 M2,229 M2,674 M3,654 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