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

SPLP Income Statement

Amortization of intangibles-25 M-11 M-14 M-31 M-30 M-30 M-22 M151 M-3 M-25 M
Basic EPS from continuing operations1.170.51-0.270.25-
Basic EPS total1.380.88-0.37-0.125.866.099.03
Basic weighted shares outstanding30 M30 M29 M26 M26 M26 M25 M25 M22 M23 M
Cost of sales471 M-497 M-588 M-816 M-958 M-1,110 M953 M860 M1,004 M1,097 M
Depreciation-27 M-31 M-38 M-71 M-72 M-80 M-66 M65 M61 M54 M
DepreciationAndAmortization-27 M-31 M-38 M-71 M-72 M-80 M-66 M65 M61 M54 M
Diluted EPS total1.380.85-0.37-
Diluted normalized net income/share1.170.99-0.680.25-1.19-
Diluted weighted shares outstanding30 M31 M29 M26 M26 M26 M25 M51 M29 M27 M
Earnings from equity interest14 M28 M-3 M-50 M-26 M37 M0.0
EarningsFromEquityInterestNetOfTax14 M28 M-3 M-50 M-26 M37 M0.0
GainOnSaleOfBusiness31 M8 M86 M
GainOnSaleOfPPE7 M940000.0
GainOnSaleOfSecurity17 M2 M2 M148000.0790000.0-63 M47 M26 M-24 M35 M
GainsLossOnDisposalOfDiscontinuedOperations11 M6 M10 M-81 M-3 M138000.0
GeneralAndAdministrativeExpense170 M-8 M-9 M-15 M-18 M-19 M335 M291 M304 M383 M
Gross operating profit203 M202 M231 M277 M1,786 M2,059 M502 M451 M521 M599 M
ImpairmentOfCapitalAssets2 M3 M44 M24 M-2 M16 M1 M
Income before tax63 M17 M25 M22 M40 M-9 M145 M125 M201 M275 M
Income restructuring and M&A-47 M-26 M15 M-91 M-14 M
Income taxes17 M6 M24 M24 M51 M13 M15 M38 M84 M74 M
Interest income21 M28 M37 M71 M80 M
InterestExpenseNonOperating15 M11 M12 M14 M27 M50 M55 M41 M30 M38 M
InterestExpenseOperating-11 M-12 M-22 M-41 M-49 M-34 M-28 M-29 M
MinorityInterests-23 M-25 M-287000.04 M-6 M-1 M97000.0-603000.0-1 M-193000.0
MiscOtherSpecialCharges19 M811000.0-16 M4 M1 M4 M2 M4 M4 M3 M
Net income from total operations41 M19 M-8 M7 M1,372 M1,552 M-2 M73 M131 M206 M
NetIncomeCommonStockholders41 M19 M-8 M7 M1,372 M1,552 M-2 M81 M100 M203 M
NetIncomeContinuousOperations41 M19 M-8 M7 M1,372 M1,552 M-2 M73 M131 M206 M
NetIncomeDiscontinuousOperations12 M6 M10 M-774000.0-6 M-19 M-125 M-10 M138000.0
NetIncomeFromOtherGainsLosses6 M28 M-2 M4 M17 M-10 M-8 M
NetNonOperatingInterestIncomeExpense7 M17 M25 M57 M-27 M-50 M-55 M-63 M-30 M-61 M
Normalized income143 M
Operating income22 M-165000.042 M-10 M1,445 M1,706 M169 M165 M247 M222 M
Operating income before depreciation (EBITDA)107 M60 M64 M95 M118 M80 M218 M198 M263 M338 M
OperatingExpense181 M-705 M-824 M-1,141 M-1,332 M-1,594 M333 M286 M274 M380 M
Other income net-36 M-3 M14 M-148000.0-790000.063 M-47 M-26 M16 M-120 M
Other special charges1 M-3 M
OtherGainLossFromDispositionOfDiscontinuedOperations3 M0.0-7 M138000.0
OtherGandA170 M-8 M-9 M-15 M-18 M-19 M335 M291 M304 M383 M
OtherImpairmentOfCapitalAssets-829000.0-829000.0-1 M-7 M-2 M-8 M-30 M
OtherOperatingExpenses11 M-404000.0-144000.05 M3 M98000.0-2 M-5 M-30 M-4 M
OtherWriteOff-80000.0-50000.0-2 M-682000.0-468000.0-605000.0-2 M
PromotionAndAdvertising-2 M-3 M-3 M
ProvisionForGainLossOnDisposal415000.080000.050000.0-774000.0-6 M-19 M-43 M13 M-44000.0
RentAndLandingFees-8 M-8 M-9 M-15 M-18 M-19 M
RestructringAndMnAIncome-47 M-26 M15 M-91 M-14 M
Revenue per share-25 M-11 M-14 M-31 M-30 M-30 M-23 M152 M-1 M-24 M
SalariesAndWages-100000.0-27 M-4 M-9 M-779000.0887000.0
Selling Gen & administrative expense170 M202 M188 M282 M338 M353 M335 M291 M304 M383 M
SellingAndMarketingExpense-2 M202 M188 M282 M338 M353 M
SellingExpense202 M188 M282 M338 M353 M
Special income/charges-2 M-3 M-44 M-24 M2 M-16 M-1 M
Total Income available for interest expense (EBIT)78 M28 M26 M24 M46 M-673000.0151 M133 M203 M284 M
Total common shares outstanding30 M31 M28 M26 M26 M25 M25 M23 M21 M22 M
Total net income41 M19 M-8 M7 M1,372 M1,552 M-2 M73 M131 M206 M
Total ordinary shares21 M21 M21 M21 M21 M21 M21 M21 M21 M21 M
Total revenues674 M699 M819 M1,093 M2,744 M3,169 M1,455 M1,311 M1,525 M1,695 M
TotalExpenses652 M-1,201 M-1,412 M-1,957 M-2,290 M-2,704 M1,286 M1,146 M1,278 M1,477 M
TotalRevenue674 M571 M600 M999 M1,372 M1,585 M1,455 M1,311 M1,525 M1,695 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