Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
LPL Financial Holdings Inc. logo

LPL Financial Holdings Inc.

Sector: Financial Services   

Industry: Capital Markets

259.11
 
USD
  
-1.00
  
(-0.38%)
Optionable: Yes  Market Cap: 19,366 M  90-day average vol: 543,193

Previous close: 260.11  Open: 260.01  Bid: 259.11  Ask: 286.0
52 week range    
179.00   
   274.35
Peers   
MS / 
RJF / 
NMR / 
TROW / 
SCHW / 
WFC / 
Last updated: Thursday 18th April 2024
52
MarketXLS Rank
40
Value
38
Technical
78
Quality

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

LPLA Cash Flow

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
(Increase) Decrease in other current assets-46 M-31 M-30 M-23 M-52 M-63 M-129 M-672 M-490 M-846 M
(Increase) Decrease in other current liabilities137 M212 M183 M118 M
(Increase) Decrease in other working capital-55 M-116 M-3 M-9 M19 M-31 M16 M
(Increase) Decrease in payables64 M146 M175 M144 M93 M205 M248 M93 M28 M47 M
(Increase) Decrease in receivables-45 M-6 M-29 M-56 M-60 M-80 M-47 M-145 M-61 M-65 M
Acquisitions-323 M-28 M-26 M-31 M-246 M-56 M-453 M
Amortization of intangibles39 M38 M38 M38 M60 M65 M67 M79 M88 M107 M
AmortizationOfFinancingCostsAndDiscounts4 M3 M6 M4 M4 M5 M
AssetImpairmentCharge9 M14 M16 M
Cash at beginning of period517 M412 M1,424 M1,559 M1,626 M1,562 M1,472 M1,799 M2,072 M3,137 M
Cash at end of period412 M725 M1,559 M1,626 M1,562 M1,472 M1,799 M2,072 M3,137 M2,581 M
Cash flow232 M279 M389 M453 M582 M624 M790 M453 M1,946 M513 M
CashFlowFromContinuingInvestingActivities-93 M-75 M-127 M-438 M-162 M-181 M-187 M-459 M-376 M-860 M
ChangeInAccountPayable77 M134 M34 M66 M44 M87 M-7 M12 M51 M31 M
ChangeInAccruedExpense11 M-17 M-1 M19 M17 M8 M13 M
ChangeInDeferredCharges-9 M998000.0-3 M9 M8 M2 M12 M
ChangeInFederalFundsAndSecuritiesSoldForRepurchase-1 M-408000.0-195000.0
ChangeInLoans-49 M-29 M-92 M-86 M-146 M-248 M-220 M
ChangeInPayablesAndAccruedExpense76 M129 M174 M162 M110 M213 M261 M93 M28 M47 M
ChangeInWorkingCapital-79 M-52 M18 M-2 M-120 M-207 M18 M-512 M-340 M-747 M
ChangesInAccountReceivables8 M26 M-2 M-2 M-69 M-21 M28 M
CommonStockDividendPaid-96 M-96 M-89 M-90 M-88 M-83 M-79 M-80 M-80 M-92 M
CommonStockPayments-275 M-391 M-25 M-114 M-418 M-500 M-150 M-90 M-325 M-1,100 M
Current deferred income taxes-24 M-30 M-12 M-9 M-2 M-19 M-24 M18 M-93 M-68 M
Deferred income taxes-24 M-30 M-12 M-9 M-2 M-19 M-24 M18 M-93 M-68 M
Depreciation97 M73 M76 M84 M88 M96 M110 M151 M200 M247 M
Depreciation unreconciled97 M112 M114 M122 M148 M161 M177 M236 M294 M363 M
DepreciationAndAmortization97 M112 M114 M122 M148 M161 M177 M236 M294 M363 M
ExcessTaxBenefitFromStockBasedCompensation-9 M-4 M-65000.0
FinancingCashFlow-243 M108 M-127 M51 M-483 M-533 M-275 M279 M-504 M-209 M
Free cash flow150 M207 M147 M341 M449 M467 M634 M237 M1,639 M109 M
GainLossOnSaleOfPPE2 M
IncomeTaxPaidSupplementalData139 M132 M123 M139 M122 M213 M169 M145 M238 M536 M
InterestPaidSupplementalData52 M51 M92 M93 M124 M127 M107 M104 M119 M191 M
Issuance of capital stock42 M29 M19 M
Issuance of debt45 M-45 M-821 M-101 M269 M
IssuanceOfCapitalStock42 M29 M19 M
IssuanceOfDebt94 M561 M-18 M182 M-15 M16 M-56 M437 M-103 M1,005 M
Net cash from financing activities-243 M108 M-127 M51 M-483 M-533 M-275 M279 M-504 M-209 M
Net cash from investing activities-93 M-75 M-127 M-438 M-162 M-181 M-187 M-459 M-376 M-860 M
Net cash from operating activities232 M279 M389 M453 M582 M624 M790 M453 M1,946 M513 M
Net change in cash & cash equivalents-104 M312 M135 M67 M-64 M-90 M327 M273 M1,065 M-556 M
Net income from continuing operations178 M169 M192 M239 M439 M560 M473 M642 M2,004 M841 M
NetBusinessPurchaseAndSale-323 M-28 M-26 M-31 M-246 M-56 M-453 M
NetCommonStockIssuance-275 M-391 M-25 M-114 M-418 M-500 M-150 M-48 M-296 M-1,081 M
NetIntangiblesPurchaseAndSale-9 M-160 M-28 M
NetInvestmentPropertiesPurchaseAndSale-2 M-1 M980000.0-3 M-1 M1 M-1 M3 M-6 M775000.0
NetInvestmentPurchaseAndSale-2 M-1 M980000.0-3 M-1 M1 M-1 M3 M-6 M775000.0
NetIssuancePaymentsOfDebt94 M561 M-18 M182 M-15 M16 M-56 M437 M-103 M1,005 M
NetLongTermDebtIssuance99 M574 M-19 M198 M-24 M-12 M-12 M1,258 M-2 M736 M
NetPPEPurchaseAndSale7 M10000.012000.0-216 M-307 M-403 M
Operating (gains) losses34 M38 M45 M22 M72 M3 M113 M24 M
Other financing charges net5 M792000.0-1 M-3 M-5 M-6 M-19 M-29 M-25 M-40 M
Other investing changes net141000.0-1 M1 M-4000.0
Other non-cash items4 M14 M48 M50 M81 M86 M-7 M43 M81 M124 M
Payment of cash dividends96 M96 M89 M90 M88 M83 M79 M80 M80 M92 M
ProceedsFromStockOptionExercised29 M33 M7 M84 M52 M40 M30 M
ProvisionForLoanLeaseAndOtherLosses4 M3 M6 M7 M6 M
Purchase of property plant & equipment-99 M-73 M-128 M-112 M-133 M-156 M-156 M-216 M-307 M-403 M
Purchase of short term investments110 M768 M2,612 M400 M1,300 M749 M
PurchaseOfFixedMaturitySecurities-2 M-11 M-5 M
PurchaseOfIntangibles-9 M-160 M-28 M
PurchaseOfInvestment-7 M-5 M-4 M-6 M-6 M-4 M-7 M-2 M-11 M-5 M
PurchaseOfPPE-216 M-307 M-403 M
Repayment of debt-11 M-194 M-19 M-2,413 M-24 M-412 M-12 M-42 M-2 M-13 M
RepaymentOfDebt-16 M-588 M-18 M-2,429 M-15 M-907 M-1,862 M-2,448 M-918 M-1,462 M
Repurchase of capital stock-275 M-391 M-25 M-114 M-418 M-500 M-150 M-90 M-325 M-1,100 M
Revenue per share39 M38 M38 M38 M60 M65 M67 M85 M94 M116 M
SaleOfInvestment6 M3 M5 M3 M5 M5 M5 M5 M5 M6 M
SaleOfPPE7 M10000.012000.0
SalesOfFixedMaturitySecurities5 M5 M6 M
ShortTermDebtIssuance523 M1,806 M1,585 M815 M1,718 M
ShortTermDebtPayments-478 M-1,851 M-2,406 M-916 M-1,449 M
StockBasedCompensation28 M29 M25 M29 M29 M33 M34 M44 M53 M69 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