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

276.00
 
USD
  
-1.68
  
(-0.61%)
Optionable: Yes  Market Cap: 21,125 M  90-day average vol: 494,307

Previous close: 277.68  Open: 278.48  Bid: 271.84  Ask: 280.12
52 week range    
200.18   
   289.88
Last updated: Wednesday 26th June 2024

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 Balance Sheet

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
Accounts payable988 M1,128 M449 M101 M129 M160 M399 M2 M3 M
Accounts receivable365 M339 M341 M344 M413 M434 M405 M579 M562 M589 M
Accrued expenses1,314 M1,455 M1,644 M1,528 M1,635 M1,775 M2,120 M384 M449 M486 M
Accumulated depreciation & depletion-289 M-329 M-356 M-427 M-308 M-388 M-490 M-624 M-817 M-1,057 M
Additional paid in capital1,355 M1,418 M1,445 M1,556 M1,634 M1,704 M1,763 M1,841 M1,913 M1,988 M
AllowanceForDoubtfulAccountsReceivable-1 M-2 M-466000.0-640000.0
AllowanceForLoansAndLeaseLosses-697000.0-2 M-3 M-5 M
AvailableForSaleSecurities73 M49 M53 M91 M
Building & improvements106 M106 M106 M108 M108 M
Cash and equivalents981 M1,396 M748 M811 M511 M590 M809 M495 M848 M466 M
CashAndDueFromBanks981 M1,396 M748 M811 M511 M590 M809 M
Common par118000.0119000.0120000.0123000.0125000.0126000.0127000.0129000.0130000.0130000.0
Common stock equity972 M716 M821 M965 M974 M1,024 M1,315 M1,671 M2,168 M2,079 M
CommonStock118000.0119000.0120000.0123000.0125000.0126000.0127000.0129000.0130000.0130000.0
Construction in progress45 M56 M67 M94 M147 M175 M38 M69 M35 M
Cost in excess1,366 M1,366 M1,366 M1,428 M1,490 M1,504 M1,514 M1,642 M1,642 M1,857 M
CurrentAccruedExpenses147 M130 M128 M277 M297 M317 M187 M
CurrentDeferredRevenue161 M138 M156 M
CurrentDeferredTaxesLiabilities-255 M-198 M-165 M
DeferredAssets401 M
DeferredTaxAssets24 M260 M297 M333 M
DividendsPayable-80 M-80 M-92 M
EmployeeBenefits65 M70 M77 M372 M
FederalFundsPurchasedAndSecuritiesSoldUnderAgreementToRepurchase302000.0268000.0183000.01 M169000.0176000.073 M
FinancialInstrumentsSoldUnderAgreementsToRepurchase302000.0268000.0183000.01 M169000.0176000.073 M
Float term debt1,625 M2,188 M2,175 M2,385 M2,372 M2,354 M2,345 M2,814 M2,717 M3,734 M
GoodwillAndOtherIntangibleAssets1,797 M1,758 M1,720 M1,842 M1,974 M1,943 M1,911 M2,097 M2,070 M2,528 M
Gross fixed assets (Plant Property & Equipment)503 M604 M743 M840 M770 M1,024 M1,175 M1,283 M1,597 M1,991 M
GrossAccountsReceivable341 M343 M345 M414 M579 M562 M589 M
GrossLoan120 M149 M195 M219 M299 M442 M588 M
GrossNotesReceivable964 M1,123 M1,480 M
HeldToMaturitySecurities9 M10 M9 M12 M13 M12 M13 M10 M16 M15 M
IncomeTaxPayable9 M5 M469000.033 M20 M28 M
Intangibles431 M392 M354 M414 M484 M440 M397 M455 M428 M672 M
Invested capital4,222 M5,092 M5,172 M5,735 M5,718 M5,822 M6,006 M7,299 M7,602 M9,547 M
Land & improvements5 M5 M5 M5 M5 M5 M5 M
Leases96 M77 M86 M82 M83 M84 M88 M97 M92 M89 M
LineOfCredit110 M45 M
LongTermCapitalLeaseObligation60 M106 M108 M105 M250 M247 M130 M125 M123 M
LongTermDebtAndCapitalLeaseObligation1,625 M2,248 M2,281 M2,493 M2,476 M2,604 M2,592 M2,814 M2,717 M3,734 M
Machinery furniture & equipment402 M417 M491 M580 M482 M579 M697 M
Net fixed assets (net PP&E)214 M275 M387 M413 M461 M636 M685 M659 M780 M933 M
Net loans120 M149 M195 M219 M299 M442 M588 M
Non-current deferred income taxes66 M36 M26 M16 M18 M2 M
NonCurrentDeferredLiabilities131 M102 M88 M88 M99 M85 M95 M
NonCurrentDeferredRevenue64 M65 M63 M72 M81 M83 M95 M
NotesReceivable964 M1,123 M1,480 M
Number of employees6099.06099.06099.06099.06099.06099.06099.06099.06099.06099.0
Other equity adjustments937000.0553000.0315000.0
Other receivable349 M341 M365 M425 M416 M476 M532 M684 M734 M793 M
OtherAssets187 M207 M243 M448 M305 M401 M59 M887 M1,023 M1,390 M
OtherLiabilities219 M223 M269 M28 M3,123 M4,149 M4,086 M
OtherPayable180 M189 M1,063 M1,149 M1,176 M1,278 M178 M72 M24 M27 M
Payables1,168 M1,326 M1,516 M1,251 M1,338 M1,458 M1,933 M
Prepaid expenses100 M115 M145 M173 M
RestrictedCashAndCashEquivalents1 M28 M811 M815 M1,051 M882 M990 M81 M90 M108 M
RestrictedCashAndInvestments1 M28 M811 M815 M1,051 M882 M990 M1,577 M2,290 M2,115 M
RestrictedInvestments1,496 M2,199 M2,007 M
Retained earnings396 M469 M570 M718 M1,070 M1,555 M1,943 M2,328 M3,101 M4,085 M
SecuritiesAndInvestments22 M22 M20 M30 M42 M58 M115 M49 M53 M91 M
SecurityBorrowed5 M6 M6 M12 M5 M18 M30 M10 M10 M4 M
Short term debt110 M45 M
Total assets4,042 M4,521 M4,835 M5,359 M5,477 M5,880 M6,596 M7,992 M9,482 M10,385 M
Total equity972 M716 M821 M965 M974 M1,024 M1,315 M1,671 M2,168 M2,079 M
Total liabilities3,070 M3,805 M4,014 M4,394 M4,503 M4,856 M5,281 M6,321 M7,315 M8,307 M
TotalEquityGrossMinority1,671 M2,168 M2,079 M
TotalEquityGrossMinorityInterest1,671 M2,168 M2,079 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest3,620 M4,189 M4,449 M4,898 M4,999 M5,322 M6,596 M7,992 M9,482 M10,385 M
TotalTaxPayable9 M5 M469000.033 M20 M28 M
TradingSecurities13 M12 M11 M18 M29 M46 M29 M39 M37 M76 M
Treasury stock-781 M-1,172 M-1,195 M-1,310 M-1,731 M-2,235 M-2,391 M-2,499 M-2,847 M-3,994 M
debtc110 M45 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