Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

LPL Stock Annual Cash Flow. Download in Excel

Sector:    

Industry: 

 
USD
  
  
()
Previous close:   Open:   Bid:   Ask:
52 week range    
   
   
Mkt Cap:   Avg Vol (90 Days):
Ad slot not ready
Search for a stock

Financials

LPL Cash Flow

Annual
Invalid dateDec-17Dec-18Dec-19Dec-20Dec-21Dec-22
(Increase) Decrease in inventories-262,106 M-763,081 M159,474 M-342,427 M-1,123,239 M390,672 M
(Increase) Decrease in other current assets61,842 M-311,132 M-327,378 M116,845 M48,858 M425,713 M
(Increase) Decrease in other current liabilities-256,577 M-120,976 M-30,946 M-137,028 M-187,955 M-217,725 M
(Increase) Decrease in payables220,520 M156,305 M1,641,186 M234,298 M1,110,590 M-907,688 M
(Increase) Decrease in receivables481,444 M1,249,248 M-1,056,799 M-873,283 M-943,735 M1,778,418 M
AssetImpairmentCharge2,275,407 M253,921 M270,876 M1,637,271 M
CapitalExpenditureReported7,061,086 M8,459,397 M7,474,446 M2,948,694 M3,777,235 M5,909,862 M
Cash at beginning of period1,558,696 M2,602,560 M2,365,022 M3,336,003 M4,218,099 M3,541,597 M
Cash at end of period-5,529,949 M-3,456,118 M8,222,430 M3,823,108 M722,665 M7,678,994 M
Cash flow731,011 M108,877 M8,003,253 M2,062,499 M3,280,879 M9,625,509 M
CashFlowFromContinuingInvestingActivities-8,681,898 M-9,120,474 M-7,133,747 M-2,507,223 M-4,310,177 M-7,434,136 M
CashFlowFromDiscontinuedOperation2,208,007 M1,455,771 M362,324 M196,898 M77,152 M756,267 M
ChangeInAccountPayable113,590 M267,358 M-394,564 M1,387,084 M1,037,950 M-282,082 M
ChangeInPayablesAndAccruedExpense220,520 M156,305 M1,641,186 M234,298 M1,110,590 M-907,688 M
ChangeInWorkingCapital245,123 M210,364 M385,537 M-1,001,595 M-1,095,481 M1,469,390 M
ChangesInAccountReceivables484,448 M1,306,118 M-1,007,356 M-936,475 M-964,130 M1,833,491 M
CommonStockDividendPaid-178,908 M-178,908 M-232,580 M
Current deferred income taxes-472,164 M-526,299 M385,341 M-237,785 M
Deferred income taxes-472,164 M-526,299 M385,341 M-237,785 M
Depreciation3,695,051 M4,134,027 M4,500,701 M4,557,457 M
Depreciation unreconciled3,695,051 M4,134,027 M4,500,701 M4,557,457 M
DepreciationAndAmortization3,695,051 M4,134,027 M4,500,701 M4,557,457 M
EarningsLossesFromEquityInvestments-7,181 M-10,205 M4,591 M-10,145 M-3,417 M-758 M
FinancingCashFlow862,242 M2,952,919 M4,987,902 M931,829 M-2,466,136 M1,946,024 M
Free cash flow-6,168,149 M-8,207,472 M948,072 M-423,006 M-427,699 M3,898,460 M
GainLossOnInvestmentSecurities-431 M-708 M-3,227 M-34,418 M-27,100 M
GainLossOnSaleOfPPE5,109 M22,459 M44,983 M28,695 M
Issuance of debt-650,595 M-1,859,818 M-881,721 M-1,545,813 M-4,195,568 M-2,287,632 M
IssuanceOfDebt1,042,779 M2,851,309 M4,718,047 M770,949 M-2,466,136 M2,238,810 M
Net cash from financing activities862,242 M2,952,919 M4,987,902 M931,829 M-2,466,136 M1,946,024 M
Net cash from investing activities-8,681,898 M-9,120,474 M-7,133,747 M-2,507,223 M-4,310,177 M-7,434,136 M
Net cash from operating activities731,011 M108,877 M8,003,253 M2,062,499 M3,280,879 M9,625,509 M
Net change in cash & cash equivalents-7,088,645 M-6,058,678 M5,857,408 M487,105 M-3,495,434 M4,137,397 M
Net income from continuing operations1,201,979 M753,882 M2,711,789 M-336,029 M-665,264 M2,693,951 M
NetIntangiblesPurchaseAndSale-452,774 M-479,647 M-538,528 M-336,317 M-632,859 M-819,191 M
NetInvestmentPropertiesPurchaseAndSale-1,800,059 M-821,629 M-128,774 M-65,530 M-678,771 M-1,765,652 M
NetInvestmentPurchaseAndSale-1,800,059 M-821,629 M-128,774 M-65,530 M-678,771 M-1,765,652 M
NetIssuancePaymentsOfDebt1,042,779 M2,851,309 M4,718,047 M770,949 M-2,466,136 M2,238,810 M
NetLongTermDebtIssuance1,693,374 M4,711,127 M5,599,768 M2,316,762 M1,729,432 M4,526,442 M
NetPPEPurchaseAndSale-6,446,386 M-7,836,702 M-6,516,653 M-2,149,188 M-3,075,719 M-4,907,858 M
Operating (gains) losses-7,181 M-10,636 M171,989 M169,756 M151,389 M169,097 M
Other financing charges net-1,629 M280,518 M269,855 M160,880 M-60,206 M
Other investing changes net1,118 M8,268 M11,156 M13,720 M14,533 M-35 M
Other non-cash items-210,973 M-217,984 M1,981,311 M-23,955 M33,275 M1,377,302 M
Payment of cash dividends178,908 M178,908 M232,580 M
PensionAndEmployeeBenefitExpense162,997 M160,669 M144,241 M168,260 M
Purchase of property plant & equipment-6,899,160 M-8,316,349 M-7,055,181 M-2,485,505 M-3,708,578 M-5,727,049 M
Purchase of short term investments1,693,374 M4,711,127 M5,664,338 M2,378,962 M1,796,373 M4,608,738 M
PurchaseOfIntangibles-454,448 M-480,607 M-540,996 M-353,313 M-635,805 M-830,583 M
PurchaseOfInvestment-1,806,366 M-834,033 M-145,237 M-80,536 M-701,458 M-1,772,344 M
PurchaseOfLongTermInvestments-1,806,366 M-834,033 M-145,237 M-80,536 M-701,458 M-1,772,344 M
PurchaseOfPPE-6,606,638 M-7,978,790 M-6,933,450 M-2,595,381 M-3,141,430 M-5,079,279 M
Repayment of debt-64,570 M-62,200 M-66,941 M-82,296 M
RepaymentOfDebt-650,595 M-2,411,982 M-2,787,299 M-3,846,819 M-6,836,266 M-6,857,752 M
Sale of Float term investments5,189 M4,136 M5,307 M1,286 M8,154 M6,727 M
SaleOfIntangibles1,674 M960 M2,468 M16,996 M2,946 M11,392 M
SaleOfInvestment5,189 M4,136 M5,307 M1,286 M8,154 M6,727 M
SaleOfPPE160,252 M142,088 M416,797 M446,193 M65,711 M171,421 M
ShortTermDebtIssuance552,164 M1,841,008 M2,238,806 M2,573,757 M4,487,824 M
ShortTermDebtPayments-650,595 M-2,411,982 M-2,722,729 M-3,784,619 M-6,769,325 M-6,775,456 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