LPL Financial Holdings Inc. (LPLA)

Import this data to Google Sheets with:

=jivedata("LPLA","financials")

Full statements spill as a table. For one cell: =jivedata("LPLA","Revenue") or =jivedata("LPLA","Revenue","TTM"). Install the Jive Data add-on, then paste into a cell.

LPL Financial Holdings Inc.

LPLA • CIK 0001397911

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Income (Loss) from Continuing Operations before Income Taxes, Noncontrolling Interest	$1,444,775	$1,392,892	$1,149,507	$1,363,538
Income Tax Expense (Benefit)	$378,525	$334,276	$286,483	$356,671
Net Income (Loss) Attributable to Parent	$1,066,250	$1,058,616	$863,024	$1,006,867
Brokerage Commissions Revenue	$2,552,623	$3,305,487	$4,505,072	$4,843,335
Interest Income, Operating	$159,415	$187,606	$231,616	$202,531
Other Income	$119,024	$144,164	$172,412	$226,251
Revenues	$10,052,848	$12,385,107	$16,989,479	$19,609,504
Labor and Related Expense	$979,681	$1,136,717	$1,586,043	$1,685,749
Occupancy, Net	$248,620	$281,210	$577,224	$662,606
Depreciation, Depletion and Amortization, Nonproduction	$246,994	$308,527	$393,434	$393,434
Interest Expense, Debt	$186,804	$274,181	$403,406	$413,702
Floor Brokerage, Exchange and Clearance Fees	$105,984	$127,941	$178,133	$198,198
Amortization of Intangible Assets	$107,211	$135,234	$236,578	$285,070
Professional Fees	$72,583	$93,729	$218,738	$242,458
Communications and Information Technology	$75,717	$75,838	$85,846	$94,590
Other Expenses	$209,439	$218,493	$219,327	$235,431
Costs and Expenses	$8,608,073	$10,992,215	$15,839,972	$18,245,966
Weighted Average Number of Shares Outstanding, Basic	76,807,000	74,713,000	78,681,000	81,325,000
Weighted Average Number of Shares Outstanding, Diluted	77,861,000	75,427,000	79,061,000	81,544,000
Weighted Average Number Diluted Shares Outstanding Adjustment	1,054,000	714,000	380,000	219,000
Antidilutive Securities Excluded from Computation of Earnings Per Share, Amount	55,298	42,918	41,871	77,357

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Net Income (Loss) Attributable to Parent	$1,066,250	$1,058,616	$863,024	$1,006,867
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents, Period Increase (Decrease), Including Exchange Rate Effect	$-556,107	$102,889	$370,688	$370,688
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents	$2,581,163	$2,684,052	$3,054,740	$3,106,011
Depreciation	$246,994	$308,527	$393,434	$393,434
Payments to Acquire Property, Plant, and Equipment	$403,286	$562,531	$570,376	$679,127
Amortization of Intangible Assets	$107,211	$135,234	$236,578	$285,070
Payments to Acquire Businesses, Net of Cash Acquired	$453,475	$1,020,221	$1,787,592	$1,831,573
Amortization of Debt Issuance Costs	$8,731	$11,319	$21,601	$13,983
Payments to Acquire Held-to-maturity Securities	$4,725	$4,769	$5,100	$5,093
Share-based Payment Arrangement, Noncash Expense	$68,669	$91,761	$79,362	$86,432
Proceeds from Sale and Maturity of Held-to-maturity Securities	$5,500	$5,000	$5,100	$5,100
Accounts Receivable, Credit Loss Expense (Reversal)	$15,947	$18,970	$16,977	$27,438
Deferred Income Tax Expense (Benefit)	$-68,454	$-76,244	$52,935	$57,844
Proceeds from Sale of Other Investments	—	—	$7,271	$7,271
Interest Paid, Capitalized, Investing Activities	—	$9,611	$6,826	$9,365
Net Cash Provided by (Used in) Investing Activities	$-860,186	$-1,592,132	$-2,386,593	$-2,553,921
Business Combination, Contingent Consideration Arrangements, Change in Amount of Contingent Consideration, Liability	—	$41,721	$24,163	$21,989
Other Noncash Income (Expense)	$-39,172	$25,319	$4,938	$5,873
Net Cash Provided by (Used in) Operating Activities	$512,611	$277,589	$-411,404	$-252,164
Proceeds from Lines of Credit	$1,718,000	$1,430,000	$876,000	$1,787,000
Repayments of Lines of Credit	$1,438,000	$663,000	$1,844,000	$1,511,000
Proceeds from (Repayments of) Secured Debt	—	$1,020,000	$0	$0
Repayments of Unsecured Debt	$0	$1,027,200	$0	$0
Proceeds from Issuance of Senior Long-term Debt	$749,468	$998,325	$2,744,930	$0
Payments of Debt Issuance Costs	$13,474	$17,905	$31,236	$1,373
Payment for Debt Extinguishment or Debt Prepayment Cost	$0	—	$47,779	$47,779
Payment for Contingent Consideration Liability, Financing Activities	$0	$50,063	$47,395	$43,321
Payment, Tax Withholding, Share-based Payment Arrangement	$40,005	$41,288	$33,484	$22,546
Proceeds from Issuance of Common Stock	—	—	$1,725,000	$0
Payments for Repurchase of Common Stock	$1,100,101	$170,096	$100,004	$309,476
Payments of Dividends	$92,190	$89,727	$94,411	$96,049
Proceeds from Stock Options Exercised	$18,665	$28,728	$22,175	$19,794
Net Cash Provided by (Used in) Financing Activities	$-208,532	$1,417,432	$3,168,685	$-178,381
Interest Paid, Excluding Capitalized Interest, Operating Activities	$191,350	$268,351	$379,919	$427,612
Income Taxes Paid	$535,959	$320,259	$328,560	$257,831
Operating Lease, Payments	$27,714	$31,737	$39,452	$43,524
Capital Expenditures Incurred but Not yet Paid	$26,021	$36,260	$45,544	$61,578
Right-of-Use Asset Obtained in Exchange for Operating Lease Liability	$17,517	$37,115	$57,734	$60,223
Increase (Decrease) in Receivables from Brokers-Dealers and Clearing Organizations	$-6,207	$12,742	$-7,487	$112,973
Increase (Decrease) in Other Loans	$594,438	$1,103,933	$1,751,748	$1,805,194
Increase (Decrease) in Other Receivables	$71,328	$126,829	$270,373	$434,344
Increase (Decrease) in Debt Securities, Trading, and Equity Securities, FV-NI	$38,956	$-34,183	$-11,640	$15,007
Increase (Decrease) in Other Operating Assets	$213,043	$435,255	$413,296	$351,654
Increase (Decrease) in Payables to Broker-Dealers and Clearing Organizations	$15,585	$-34,149	$21,292	$325,804
Increase (Decrease) in Accounts Payable and Accrued Liabilities	$31,256	$36,977	$161,291	$176,382
Increase (Decrease) in Other Operating Liabilities	$117,805	$336,412	$-617,789	$-476,310
Cash and Cash Equivalents, at Carrying Value	$465,671	$967,079	$1,037,378	$832,656
Cash and Securities Segregated under Federal and Other Regulations	$2,007,312	$1,597,249	$1,792,064	$1,934,750
Restricted Cash and Cash Equivalents	$108,180	$119,724	$225,298	$338,605

Loading financial statements…

Import this data to Google Sheets with:

=jivedata("LPLA","financials")

Full statements spill as a table. For one cell: =jivedata("LPLA","Revenue") or =jivedata("LPLA","Revenue","TTM"). Install the Jive Data add-on, then paste into a cell.