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

ROL Cash Flow

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
(Increase) Decrease in inventories-2 M814000.0-671000.0-837000.0-374000.0-2 M-11 M3 M-540000.0-4 M
(Increase) Decrease in other current assets-3 M-2 M-1 M-4 M4 M-8 M7 M-11 M6 M-16 M
(Increase) Decrease in other current liabilities2 M3 M3 M1 M5 M5 M7 M12 M10 M7 M
(Increase) Decrease in other working capital-3 M-2 M-3 M-4 M4 M-13 M18 M-7 M14 M4 M
(Increase) Decrease in payables15 M-2 M13 M-26 M-24 M6 M50 M1 M304000.043 M
(Increase) Decrease in receivables-14 M-16 M-22 M-20 M-23 M-29 M-24 M-37 M-58 M-62 M
Acquisitions-63 M-33 M-46 M-130 M-77 M-431 M-148 M-146 M-119 M-367 M
AssetImpairmentCharge11 M10 M11 M10 M14 M15 M18 M15 M19 M27 M
CapitalExpenditureReported29 M39 M33 M25 M27 M27 M23 M27 M31 M32 M
Cash at beginning of period118 M108 M135 M143 M107 M115 M94 M98 M105 M95 M
Cash at end of period115 M137 M143 M103 M116 M-22 M98 M105 M95 M104 M
Cash flow193 M196 M227 M231 M287 M318 M436 M402 M466 M528 M
CashFlowFromContinuingInvestingActivities-89 M-69 M-77 M-154 M-101 M-455 M-162 M-99 M-134 M-373 M
ChangeInAccountPayable15 M-2 M13 M-26 M-24 M6 M50 M1 M304000.043 M
ChangeInAccruedExpense-6 M-311000.03 M4 M-6 M-3 M996000.0
ChangeInPayablesAndAccruedExpense10 M-2 M16 M-21 M-30 M2 M50 M1 M304000.043 M
ChangeInWorkingCapital-7 M-17 M-7 M-45 M-44 M-37 M48 M-39 M-28 M-28 M
ChangesInAccountReceivables-13 M-12 M-16 M-14 M-13 M-20 M-12 M-22 M-34 M-46 M
CommonStockDividendPaid-76 M-92 M-109 M-122 M-153 M-154 M-160 M-209 M-212 M-264 M
CommonStockPayments-36 M-7 M-31 M-8 M-10 M-10 M-8 M-11 M-7 M-315 M
Current deferred income taxes8 M3 M-3 M19 M8 M-7 M-1 M3 M2 M-8 M
Deferred income taxes8 M3 M-3 M19 M8 M-7 M-1 M3 M2 M-8 M
Depreciation44 M88 M87 M91 M100 M
Depreciation unreconciled42 M42 M50 M56 M65 M80 M88 M87 M91 M100 M
DepreciationAndAmortization44 M88 M87 M91 M100 M
Effect of exchange rate changes-5 M13 M-14 M-3 M12 M-6 M-6 M2 M
ExcessTaxBenefitFromStockBasedCompensation-5 M-2 M-4 M
FinancingCashFlow-107 M-97 M-136 M-130 M-162 M128 M-281 M-290 M-336 M-149 M
Free cash flow167 M160 M196 M208 M262 M293 M420 M449 M450 M508 M
GainLossOnSaleOfBusiness-15 M
GainLossOnSaleOfPPE2 M-36 M-8 M-7 M
IncomeTaxPaidSupplementalData74 M83 M89 M91 M77 M76 M81 M120 M120 M159 M
InterestPaidSupplementalData13000.025000.06 M5 M1 M4 M19 M
Issuance of debt440 M-34 M40 M145 M493 M
IssuanceOfDebt292 M-88 M-48 M-100 M438 M
Net cash from financing activities-107 M-97 M-136 M-130 M-162 M128 M-281 M-290 M-336 M-149 M
Net cash from investing activities-89 M-69 M-77 M-154 M-101 M-455 M-162 M-99 M-134 M-373 M
Net cash from operating activities193 M196 M227 M231 M287 M318 M436 M402 M466 M528 M
Net change in cash & cash equivalents-3 M29 M8 M-40 M9 M-137 M-8 M13 M-4 M6 M
Net income from continuing operations138 M152 M167 M179 M232 M203 M261 M357 M369 M435 M
NetBusinessPurchaseAndSale-63 M-33 M-46 M-130 M-77 M-431 M-148 M-146 M-119 M-351 M
NetCommonStockIssuance-36 M-7 M-31 M-8 M-10 M-10 M-8 M-11 M-7 M-315 M
NetIntangiblesPurchaseAndSale565000.0767000.0699000.0519000.0343000.0617000.0495000.0
NetInvestmentPropertiesPurchaseAndSale-264000.0297000.0104000.0747000.0-111000.01 M-2 M
NetInvestmentPurchaseAndSale-264000.0297000.0104000.0747000.0-111000.01 M-2 M
NetIssuancePaymentsOfDebt292 M-88 M-48 M-100 M438 M
NetLongTermDebtIssuance-148 M-54 M-88 M-245 M-55 M
NetPPEPurchaseAndSale-27 M-37 M-31 M-24 M-25 M-25 M-16 M47 M-16 M-20 M
Operating (gains) losses-5 M-5 M-3 M-144000.02 M-36 M-8 M-22 M
Other financing charges net5 M2 M4 M-24 M-23 M-17 M-8 M
Other investing changes net-264000.0297000.0104000.0747000.0-111000.01 M-2 M
Other non-cash items17 M20 M23 M23 M27 M79 M38 M30 M41 M51 M
Payment of cash dividends76 M92 M109 M122 M153 M154 M160 M209 M212 M264 M
PensionAndEmployeeBenefitExpense-5 M-5 M-3 M-144000.0
Purchase of property plant & equipment-26 M-36 M-31 M-24 M-25 M-25 M-16 M47 M-16 M-20 M
PurchaseOfInvestment-264000.0297000.0104000.0
PurchaseOfLongTermInvestments-264000.0297000.0104000.0
PurchaseOfPPE-29 M-39 M-33 M-25 M-27 M-27 M-23 M-27 M-31 M-32 M
Repayment of debt-148 M-54 M-88 M-245 M-55 M
RepaymentOfDebt-148 M-223 M-254 M-395 M-632 M
Repurchase of capital stock-36 M-7 M-31 M-8 M-10 M-10 M-8 M-11 M-7 M-315 M
SaleOfBusiness16 M
SaleOfIntangibles565000.0767000.0699000.0519000.0343000.0617000.0495000.0
SaleOfPPE2 M3 M2 M370000.02 M2 M8 M74 M15 M12 M
ShortTermDebtIssuance440 M135 M207 M295 M1,070 M
ShortTermDebtPayments-169 M-166 M-150 M-577 M
StockBasedCompensation11 M12 M12 M12 M14 M14 M21 M15 M21 M25 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