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

OPI Balance Sheet

Annual
Dec-13Dec-14Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
Accounts payable6 M7 M
Accounts receivable33 M36 M48 M61 M72 M84 M102 M113 M106 M133 M
Accrued expenses6 M7 M6 M7 M
Accumulated depreciation & depletion-188 M-220 M-297 M-342 M-375 M-388 M-452 M-496 M-561 M-650 M
Additional paid in capital1,106 M1,458 M1,474 M1,969 M2,610 M2,612 M2,615 M2,617 M2,620 M2,621 M
Building & improvements1,325 M1,428 M1,621 M2,399 M3,064 M2,692 M2,729 M3,072 M3,150 M3,297 M
Cash and equivalents9 M16 M30 M20 M39 M101 M42 M83 M12 M12 M
CashCashEquivalentsAndShortTermInvestments9 M16 M30 M20 M39 M101 M42 M83 M12 M12 M
CashEquivalents9 M16 M30 M3 M4 M7 M
Common par-308 M-409 M-662 M248000.0481000.0482000.0483000.0484000.0486000.0488000.0
Common stock equity990 M1,297 M935 M1,330 M1,779 M1,706 M1,609 M1,497 M1,386 M1,256 M
CommonStock-308 M-409 M-662 M248000.0481000.0482000.0483000.0484000.0486000.0488000.0
CurrentCapitalLeaseObligation1543.01584.0
CurrentDeferredRevenue712000.0712000.0
DeferredCosts12 M11 M21 M23 M26 M40 M43 M54 M73 M87 M
DeferredFinancingCosts9 M14 M18 M16 M14 M17 M
DividendsPayable-101 M122 M145 M171 M106 M-106 M-106 M-107 M-63 M
Float term debt445 M1,098 M1,222 M1,675 M3,080 M2,327 M2,203 M2,578 M2,238 M2,368 M
GoodwillAndOtherIntangibleAssets142 M150 M125 M352 M1,057 M732 M549 M506 M369 M263 M
Gross fixed assets (Plant Property & Equipment)1,588 M1,698 M1,899 M3,040 M4,008 M3,546 M3,560 M3,946 M3,971 M4,084 M
Intangibles142 M150 M125 M352 M1,057 M732 M549 M506 M369 M263 M
InterestPayable17 M28 M45 M65 M90 M135 M-108 M
Invested capital1,434 M2,395 M2,157 M3,005 M4,862 M4,036 M6,015 M6,653 M5,862 M5,991 M
Land & improvements244 M254 M268 M627 M924 M841 M831 M874 M821 M786 M
Leases19 M16 M11 M14 M20 M13 M
LineOfCredit157 M160 M570 M175 M195 M205 M
LongTermCapitalLeaseObligation2 M174000.0
LongTermDebtAndCapitalLeaseObligation445 M1,098 M1,222 M1,675 M3,080 M2,327 M2,203 M2,578 M2,238 M2,368 M
LongTermProvisions343000.04 M15 M891000.0594000.073000.03 M
Minority interest20 M
Net fixed assets (net PP&E)1,400 M1,479 M1,603 M2,698 M3,633 M3,159 M3,108 M3,450 M3,410 M3,434 M
NetOtherUnrealizedGainLoss-8 M-44 M
NonCurrentDeferredAssets12 M11 M21 M23 M26 M40 M43 M54 M73 M87 M
Other current assets25 M12 M68 M96 M432 M91 M88 M35 M10 M46 M
Other equity adjustments49000.037000.027 M-808 M-978 M-1,084 M-1,190 M-1,297 M-1,403 M-1,466 M
Other fixed assets2 M168000.0
Other non-current assets26 M13 M13 M22 M21 M2 M
Other non-current liabilities11 M17 M14 M12 M
Other receivable1,148 M1,276 M1,923 M3,618 M55 M69 M83 M86 M112 M
OtherCapitalStock0.0
OtherCurrentLiabilities26 M29 M58 M94 M180 M132 M116 M143 M140 M140 M
OtherDeferredCosts12 M11 M21 M23 M26 M40 M43 M54 M73 M87 M
OtherPayable6 M7 M6 M
Payables6 M7 M6 M7 M
Preferred securities of subsidiary trust275000.0
PreferredStock275000.0
Properties10 M11 M830185.0
Restricted cash4 M7 M15 M1 M14 M
Retained earnings192 M248 M96 M108 M147 M177 M184 M176 M170 M100 M
Short term debt157 M160 M570 M175 M195 M205 M
Total assets1,632 M2,428 M2,385 M3,704 M5,239 M4,193 M3,946 M4,242 M3,980 M3,990 M
Total current assets68 M65 M147 M177 M543 M275 M247 M232 M128 M206 M
Total current liabilities183 M29 M218 M664 M355 M132 M123 M149 M342 M352 M
Total equity990 M1,297 M935 M1,330 M1,779 M1,706 M1,609 M1,497 M1,386 M1,256 M
Total liabilities643 M1,130 M1,450 M2,353 M3,460 M2,487 M2,337 M2,745 M2,594 M2,734 M
Total non-current assets1,580 M2,366 M2,249 M3,540 M4,715 M3,931 M3,700 M4,010 M3,852 M3,784 M
Total non-current liabilities445 M1,098 M1,222 M1,675 M3,084 M2,342 M2,214 M2,596 M2,252 M2,382 M
TotalEquityGrossMinority990 M1,297 M935 M1,290 M1,779 M1,706 M1,609 M1,497 M1,386 M1,256 M
TotalEquityGrossMinorityInterest990 M1,297 M935 M1,290 M1,779 M1,706 M1,609 M1,497 M1,386 M1,256 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest1,632 M2,428 M2,385 M3,704 M5,239 M4,193 M3,946 M4,242 M3,980 M3,990 M
TotalNonCurrentLiabilitiesNetMinorityInteres445 M1,098 M1,222 M1,675 M3,084 M2,342 M2,214 M2,596 M2,252 M2,382 M
UnearnedIncome33 M467 M
UnearnedPremiums16 M18 M56 M46 M-40 M-32 M-24 M-22 M
UnrealizedGainLoss-808 M-978 M-1,084 M-1,190 M-1,297 M-1,403 M-1,466 M
Working capital-115 M36 M-71 M-487 M188 M143 M124 M83 M-214 M-147 M
debtc157 M160 M570 M175 M195 M205 M
ltinv680 M488 M467 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