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

OPOF Cash Flow

Annual
Dec-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
(Increase) Decrease in other current assets-29 M-8 M26 M37 M-450000.016 M48 M79 M48 M-20 M
(Increase) Decrease in other current liabilities343000.0442000.04 M-243000.03 M
(Increase) Decrease in other working capital-779000.0300000.0-111000.0-14 M11 M3 M
(Increase) Decrease in receivables-848000.0-851000.0-885000.0-795000.0-774000.0-782000.0-784000.0-839000.0-1 M-909000.0
Acquisitions-23000.0-52000.0-860000.0
Cash at beginning of period42 M31 M33 M86 M26 M14 M42 M90 M120 M188 M
Cash at end of period31 M33 M37 M74 M14 M42 M90 M120 M188 M19 M
Cash flow-20 M1 M38 M47 M9 M28 M59 M71 M72 M-539000.0
CashFlowFromContinuingInvestingActivities16 M-9 M-15 M-24 M-98 M12 M29 M-122 M-61 M-213 M
ChangeInAccruedExpense3 M732000.0-625000.0-855000.0524000.02 M
ChangeInFederalFundsAndSecuritiesSoldForRepurchase-6 M6 M-12 M-7 M12 M-2 M-15 M-5 M-3 M12 M
ChangeInInterestPayable3 M732000.0-625000.0-855000.0524000.02 M
ChangeInPayablesAndAccruedExpense3 M732000.0-625000.0-855000.0524000.02 M
ChangeInWorkingCapital-30 M-9 M29 M36 M1 M16 M47 M63 M59 M-16 M
CommonStockDividendPaid-1 M-1 M-2 M-2 M-2 M-2 M-2 M-3 M-3 M-3 M
CommonStockPayments-157000.0-150000.0-7 M
Current deferred income taxes-316000.0-101000.0-227000.0-19000.0-117000.0-164000.0352000.0-634000.0275000.0-51000.0
Deferred income taxes-316000.0-101000.0-227000.0-19000.0-117000.0-164000.0352000.0-634000.0275000.0-51000.0
Depreciation2 M2 M3 M3 M3 M2 M2 M2 M2 M2 M
Depreciation unreconciled4 M5 M5 M5 M5 M4 M3 M3 M3 M4 M
DepreciationAndAmortization4 M5 M5 M5 M5 M4 M3 M3 M3 M4 M
FinancingCashFlow-7 M10 M-19 M4 M78 M-12 M6 M161 M105 M27 M
Free cash flow-31 M-3 M36 M8 M8 M27 M11 M-7 M22 M17 M
GainLossOnInvestmentSecurities-264000.02 M
GainLossOnSaleOfPPE28000.01000.06000.0-3000.04000.09000.082000.0-818000.0-2 M
IncomeTaxPaidSupplementalData550000.0535000.0200000.0600000.0
InterestPaidSupplementalData5 M4 M4 M3 M3 M5 M6 M6 M3 M3 M
Issuance of capital stock46000.0
Issuance of debt29 M-28 M-480000.0
IssuanceOfCapitalStock46000.0
IssuanceOfDebt5 M-5 M-25 M68 M-7 M-23 M-8 M1 M46 M
Net cash from financing activities-7 M10 M-19 M-34 M78 M-12 M-40 M82 M56 M45 M
Net cash from investing activities16 M-9 M-15 M-24 M-98 M12 M29 M-122 M-61 M-213 M
Net cash from operating activities-20 M1 M38 M9 M9 M28 M12 M-9 M23 M18 M
Net change in cash & cash equivalents-11 M2 M4 M-11 M-11 M28 M48 M31 M67 M-169 M
Net income from continuing operations3 M4 M4 M4 M-29000.05 M8 M5 M8 M9 M
NetBusinessPurchaseAndSale-23000.0-52000.0-860000.0
NetCommonStockIssuance46000.0-157000.0-150000.0-7 M
NetInvestmentPropertiesPurchaseAndSale37 M22 M10 M2 M30 M-2 M-8 M-48 M-71 M-43 M
NetInvestmentPurchaseAndSale37 M22 M10 M2 M30 M-2 M-8 M-48 M-71 M-43 M
NetIssuancePaymentsOfDebt5 M-5 M-25 M68 M-7 M-23 M-8 M1 M46 M
NetLongTermDebtIssuance5 M-5 M-25 M68 M-7 M-23 M-37 M29 M46 M
NetPPEPurchaseAndSale-11 M-4 M-2 M-891000.0-619000.0-478000.0-2 M1 M-1 M-359000.0
NetProceedsPaymentForLoan-11 M-28 M-24 M-37 M-138 M9 M-61 M
Operating (gains) losses1 M871000.0-113000.0-371000.0-2 M-25000.0-234000.0-1 M180000.0
Other financing charges net98 M61 M-3 M
Other investing changes net18 M9 M91 M45 M51 M11 M30 M11 M12 M2 M
Other non-cash items1 M600000.01 M2 M4 M3 M542000.01 M1 M2 M
Payment of cash dividends1 M1 M2 M2 M2 M2 M2 M3 M3 M3 M
PaymentForLoans-14 M-2 M-138 M-4 M-68 M
PensionAndEmployeeBenefitExpense-1000000.0-2 M
ProceedsFromLoans-11 M-28 M-10 M-35 M-131 M9 M7 M
ProceedsFromStockOptionExercised46000.01 M87000.085000.096000.0103000.0129000.0
ProvisionForLoanLeaseAndOtherLosses1000000.0794000.02 M
Purchase of property plant & equipment-11 M-4 M-2 M-891000.0-619000.0-478000.0-2 M1 M-1 M-359000.0
Purchase of short term investments10 M20 M55 M168 M141 M10 M25 M29 M118 M
PurchaseOfFixedMaturitySecurities-30 M-73 M-90 M-71 M
PurchaseOfInvestment-45 M-25 M-104 M-151 M-26 M-26 M-103 M-73 M-90 M-71 M
PurchaseOfPPE-11 M-4 M-2 M-891000.0-619000.0-478000.0-2 M-924000.0-2 M-1 M
Repayment of debt-5 M-25 M-80 M-100 M-148 M-33 M-62 M-72 M
RepaymentOfDebt-5 M-25 M-80 M-100 M-148 M-33 M-71 M-28 M-72 M
Repurchase of capital stock-157000.0-150000.0-7 M
Revenue per share3 M2 M2 M2 M2 M1 M1 M831000.01 M2 M
SaleOfInvestment64 M39 M24 M108 M4 M13 M66 M14 M7 M26 M
SaleOfPPE2 M31000.0995000.0
SalesOfFixedMaturitySecurities170000.0300000.0300000.014 M7 M26 M
ShortTermDebtIssuance38 M
ShortTermDebtPayments-9 M-28 M-480000.0
StockBasedCompensation17000.0160000.0224000.0261000.0294000.0416000.0
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