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

SPLP Balance Sheet

Annual
Dec-12Dec-13Dec-14Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
"""debtc"""14 M27 M20 M64 M2 M4 M16 M2,101 M335 M42 M
Accounts payable34 M34 M35 M89 M105 M106 M88 M101 M123 M110 M
Accounts receivable84 M89 M87 M163 M188 M210 M170 M164 M194 M184 M
Accrued expenses79 M76 M76 M171 M179 M226 M192 M175 M212 M225 M
Accumulated depreciation & depletion-39 M-54 M-78 M-152 M-191 M-238 M-267 M-308 M-340 M-361 M
Cash and equivalents226 M230 M210 M463 M434 M347 M138 M136 M325 M234 M
CashCashEquivalentsAndShortTermInvestments425 M409 M349 M516 M493 M349 M138 M136 M325 M234 M
CashEquivalents226 M26 M210 M463 M434 M347 M0.0
Common stock equity527 M617 M495 M549 M546 M516 M-191 M535 M663 M800 M
CommonStock100000.033 M43 M90 M111 M152 M179 M212 M257 M307 M
Cost in excess64 M87 M46 M167 M170 M184 M150 M151 M148 M126 M
CurrentAccruedExpenses45 M42 M41 M82 M74 M120 M104 M70 M87 M113 M
CurrentCapitalLeaseObligation3 M2 M774000.09 M10 M14 M9 M9 M9 M8 M
CurrentDeferredAssets24 M22 M30 M
CurrentDeferredRevenue8 M3 M4 M
CurrentDeferredTaxesAssets24 M22 M70 M179 M106 M94 M88 M64 M14 M41 M
CurrentDeferredTaxesLiabilities1 M3 M78 M181000.079 M-99 M-130 M-131 M
CurrentProvisions177 M180 M143 M147 M150 M152 M
Deferred revenues1 M3 M271000.0
Deposits79 M118 M165 M366 M511 M711 M755 M356 M825 M1,568 M
DividendsPayable4 M
EmployeeBenefits183 M82 M85 M
Finished goods19 M20 M24 M43 M49 M56 M48 M42 M49 M57 M
Float term debt140 M223 M296 M330 M413 M478 M338 M345 M297 M215 M
GeneralPartnershipCapital549 M546 M463 M535 M
GoodwillAndOtherIntangibleAssets190 M218 M165 M395 M369 M367 M308 M289 M268 M221 M
Gross fixed assets (Plant Property & Equipment)216 M236 M262 M414 M463 M535 M551 M567 M612 M642 M
Intangibles126 M131 M119 M227 M199 M184 M159 M139 M120 M95 M
InterestPayable13 M10 M11 M11 M23 M39 M39 M30 M22 M21 M
Inventories49 M60 M64 M119 M143 M159 M148 M137 M184 M214 M
Invested capital667 M840 M862 M926 M1,016 M1,051 M469 M1,203 M1,231 M1,195 M
Leases9 M8 M7 M7 M
LimitedPartnershipCapital545 M575 M492 M618 M650 M666 M654 M707 M795 M952 M
LoansReceivable227 M2,498 M1,041 M1,548 M
LongTermCapitalLeaseObligation2 M734000.0288000.026 M22 M28 M36 M
LongTermDebtAndCapitalLeaseObligation140 M223 M296 M330 M413 M478 M349 M345 M297 M215 M
LongTermProvisions35 M31 M77 M169 M206 M279 M139 M70 M378 M208 M
Minority interest249 M256 M169 M156 M21 M4 M4 M5 M6 M1 M
Net fixed assets (net PP&E)178 M182 M184 M261 M272 M297 M284 M259 M272 M281 M
NetOtherUnrealizedGainLoss-3 M501000.070000.0
NetUnrealizedGainLossForeignCurrency25 M
Non-current deferred income taxes6 M3 M4 M4 M3 M2 M2 M2 M14 M41 M
NonCurrentDeferredAssets77 M33 M74 M183 M109 M96 M91 M67 M
NonCurrentDeferredLiabilities223 M146 M212 M289 M271 M208 M186 M2 M14 M41 M
NonCurrentDeferredTaxesAssets77 M33 M74 M183 M109 M96 M91 M67 M146 M111 M
NonCurrentNoteReceivables16 M50 M76 M62 M88 M164 M196 M2,183 M511 M423 M
NonCurrentPensionAndOtherPostretirementBenefitPlans183 M82 M85 M
NotesReceivable52 M26 M42 M74 M139 M336 M555 M2,428 M856 M982 M
Number of employees4500.04500.04500.04500.04500.04500.04500.04500.04500.04500.0
Other current assets46 M76 M76 M8 M185 M342 M41 M42 M42 M1,132 M
Other equity adjustments-18 M42 M3 M-69 M-104 M-177 M
Other fixed assets284 M259 M272 M281 M
Other non-current assets24 M43 M45 M122 M61 M80 M635 M348 M609 M196 M
Other non-current liabilities24 M12 M12 M10 M16 M21 M25 M40 M36 M42 M
Other receivable145000.01 M838000.0328000.0355000.0425000.02 M2 M3 M961000.0
OtherCurrentBorrowings1 M650000.0602000.01 M2 M3 M2 M2,091 M334 M42 M
OtherCurrentLiabilities60 M107 M113 M218 M318 M454 M728 M331 M502 M1,423 M
OtherInventories10 M20 M17 M15 M17 M21 M148 M137 M184 M214 M
OtherPayable46 M4 M2 M3 M
Payables34 M34 M35 M89 M105 M106 M88 M105 M125 M112 M
Preferred securities of subsidiary trust25.0
PreferredStock25.0
Prepaid expenses14 M17 M15 M18 M20 M33 M42 M58 M48 M40 M
Raw materials14 M12 M12 M43 M53 M59 M46 M40 M62 M79 M
RecievablesAdjustmentsAllowances-2 M-2 M-2 M-1 M-5 M-18 M-37 M-27 M-14 M-30 M
Restricted cash136 M
Retained earnings-191 M-173 M-132 M-152 M
SecuritySoldNotYetRepurchased50 M78 M21 M20 M45 M45 M
Short term debt14 M27 M20 M64 M2 M4 M16 M2,101 M335 M42 M
Total assets1,378 M1,522 M1,493 M1,967 M2,164 M2,356 M2,332 M3,934 M2,675 M3,236 M
Total current assets681 M648 M664 M916 M1,029 M1,092 M541 M803 M1,284 M1,805 M
Total current liabilities180 M235 M230 M466 M515 M670 M1,079 M517 M715 M1,649 M
Total equity527 M617 M495 M549 M546 M516 M-191 M535 M663 M800 M
Total liabilities602 M649 M829 M1,263 M1,597 M1,837 M1,865 M3,395 M2,006 M2,434 M
Total non-current assets684 M822 M856 M1,143 M1,135 M1,264 M1,790 M3,437 M1,921 M1,431 M
Total non-current liabilities422 M412 M596 M797 M906 M986 M786 M641 M808 M591 M
TotalEquityGrossMinority777 M873 M664 M704 M567 M489 M467 M539 M669 M801 M
TotalEquityGrossMinorityInterest777 M873 M664 M704 M567 M489 M467 M539 M669 M801 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest1,378 M1,522 M1,493 M1,967 M2,164 M2,356 M2,332 M3,934 M2,675 M3,236 M
TotalNonCurrentLiabilitiesNetMinorityInteres422 M412 M596 M797 M906 M986 M786 M641 M808 M591 M
TotalPartnershipCapital545 M575 M492 M618 M650 M666 M654 M707 M795 M952 M
Treasury stock15 M16 M
UnrealizedGainLoss25 M
Work in progress8 M8 M10 M19 M25 M25 M28 M25 M37 M39 M
Working capital501 M413 M434 M450 M514 M422 M-537 M286 M569 M156 M
ltinv200 M295 M312 M120 M236 M258 M276 M291 M261 M310 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