Automatic Data Processing, Inc. (ADP)

Import this data to Google Sheets with:

=jivedata("ADP","financials")

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

Automatic Data Processing, Inc.

ADP • CIK 0000008670

(in thousands, except per share data)	FY 2024	FY 2025	FY 2026	TTM
Net Income (Loss) Attributable to Parent	$3,752,000	$4,079,700	$4,413,500	$4,413,500
Weighted Average Number of Shares Outstanding, Basic	410,600,000	407,100,000	402,300,000	402,300,000
Incremental Common Shares Attributable to Dilutive Effect of Call Options and Warrants	700,000	600,000	300,000	300,000
Weighted Average Number of Shares Outstanding, Diluted	412,200,000	408,700,000	403,300,000	403,300,000

(in thousands, except per share data)	FY 2024	FY 2025	FY 2026	TTM
Cash and Cash Equivalents, at Carrying Value	$2,913,400	$3,347,800	$4,230,100	$4,230,100
Marketable Securities, Current	$384,000	$4,498,800	$0	$0
Property, Plant and Equipment, Net	$685,600	$655,400	$641,300	$641,300
Accounts Receivable, after Allowance for Credit Loss, Current	$3,428,200	$3,579,100	$3,521,100	$3,521,100
Operating Lease, Right-of-Use Asset	$370,600	$374,100	$388,600	$388,600
Other Assets, Current	$1,204,800	$840,800	$852,100	$852,100
Capitalized Contract Cost, Net	$2,965,000	$3,154,100	$3,244,100	$3,244,100
Other Assets, Noncurrent	$1,102,100	$1,052,600	$1,420,500	$1,420,500
Goodwill	$2,353,600	$3,273,500	$3,284,400	$3,284,400
Assets, Current	$45,542,500	$43,252,200	$52,561,100	$52,561,100
Intangible Assets, Net (Excluding Goodwill)	$1,336,000	$1,603,000	$1,653,300	$1,653,300
Assets	$54,362,700	$53,369,300	$63,193,300	$63,193,300
Long-term Debt, Excluding Current Maturities	$2,991,300	$3,974,700	$4,964,100	$4,964,100
Operating Lease, Liability, Noncurrent	$328,600	$321,200	$306,700	$306,700
Other Liabilities, Noncurrent	$990,800	$1,058,300	$1,141,400	$1,141,400
Deferred Income Tax Liabilities, Net	$64,300	$163,600	$339,100	$339,100
Contract with Customer, Liability, Noncurrent	$360,100	$385,200	$385,900	$385,900
Liabilities	$49,815,100	$47,181,300	$57,162,100	$57,162,100
Accounts Payable, Current	$100,600	$169,100	$162,500	$162,500
Accrued Liabilities, Current	$3,350,100	$3,092,400	$3,218,500	$3,218,500
Employee-related Liabilities, Current	$958,700	$973,100	$1,039,400	$1,039,400
Dividends Payable	$566,400	$620,600	$671,900	$671,900
Contract with Customer, Liability, Current	$199,800	$262,800	$267,500	$267,500
Commercial Paper	$0	$4,769,500	$0	$0
Accrued Income Taxes, Current	$15,100	$9,100	$110,300	$110,300
Liabilities, Current	$45,080,000	$41,278,300	$50,024,900	$50,024,900
Preferred Stock, Value, Issued	$0	$0	$0	$0
Common Stock, Value, Issued	$63,900	$63,900	$63,900	$63,900
Additional Paid in Capital, Common Stock	$2,406,900	$2,788,300	$3,067,900	$3,067,900
Retained Earnings (Accumulated Deficit)	$23,622,200	$25,240,600	$26,967,400	$26,967,400
Treasury Stock, Value	$19,737,100	$21,021,400	$23,165,900	$23,165,900
Accumulated Other Comprehensive Income (Loss), Net of Tax	$-1,808,300	$-883,400	$-902,100	$-902,100
Stockholders' Equity Attributable to Parent	$4,547,600	$6,188,000	$6,031,200	$6,031,200
Accounts Receivable, Allowance for Credit Loss, Current	$52,200	$47,100	$44,500	$44,500
Preferred Stock, Shares Authorized	300,000	300,000	300,000	300,000
Preferred Stock, Shares Issued	0	0	0	0
Common Stock, Shares Authorized	1,000,000,000	1,000,000,000	1,000,000,000	1,000,000,000
Common Stock, Shares, Issued	638,700,000	638,700,000	638,700,000	638,700,000
Common Stock, Shares, Outstanding	408,100,000	405,300,000	397,800,000	397,800,000
Treasury Stock, Common, Shares	230,600,000	233,400,000	240,900,000	240,900,000
Marketable Securities, Noncurrent	$0	—	$138,600	$138,600
Investments	$3,297,400	$7,846,600	$4,368,700	$4,368,700
Assets for Plan Benefits, Defined Benefit Plan	$286,300	$334,200	$431,100	$431,100
Liability, Defined Benefit Pension Plan, Current	$11,100	$5,900	$6,500	$6,500
Liability, Defined Benefit Pension Plan, Noncurrent	$101,800	$108,700	$102,800	$102,800
Defined Benefit Plan, Funded (Unfunded) Status of Plan	$173,400	$219,600	$321,800	$321,800

(in thousands, except per share data)	FY 2024	FY 2025	FY 2026	TTM
Net Income (Loss) Attributable to Parent	$3,752,000	$4,079,700	$4,413,500	$4,413,500
Net Cash Provided by (Used in) Operating Activities	$4,157,600	$4,939,700	$5,441,200	$5,441,200
Effect of Exchange Rate on Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents	$-22,400	$37,300	$-37,800	$-37,800
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents, Period Increase (Decrease), Including Exchange Rate Effect	$1,314,500	$-5,031,400	$5,570,600	$5,570,600
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents	$10,086,000	$5,054,600	$10,625,200	$10,625,200
Depreciation, Depletion and Amortization	$561,900	$582,400	$585,900	$585,900
Payments to Acquire Marketable Securities	$6,835,300	$7,857,900	$12,359,700	$12,359,700
Capitalized Contract Cost, Amortization	$1,067,600	$1,145,300	$1,200,500	$1,200,500
Proceeds from Sale and Maturity of Debt Securities, Available-for-sale	—	$6,539,100	$8,344,700	$8,344,700
Payments to Acquire Other Property, Plant, and Equipment	$208,400	$168,700	$196,600	$196,600
Share-based Payment Arrangement, Noncash Expense	$243,500	$266,100	$242,600	$242,600
Payments to Acquire Intangible Assets	$355,000	$378,300	$468,500	$468,500
Accounts Receivable, Credit Loss Expense (Reversal)	$54,600	$53,200	$47,500	$47,500
Payments to Acquire Businesses, Net of Cash Acquired	$33,600	$1,165,100	$22,800	$22,800
Increase (Decrease) in Obligation, Pension Benefits	$-22,900	$-19,700	$-15,400	$-15,400
Proceeds from Sale of Property, Plant, and Equipment	$28,300	$10,800	$0	$0
Accretion (Amortization) of Discounts and Premiums, Investments	$42,600	$72,200	$88,200	$88,200
Payments for (Proceeds from) Other Investing Activities	$24,500	$14,900	$10,900	$10,900
Other Noncash Income (Expense)	$1,700	$-13,400	$-4,200	$-4,200
Net Cash Provided by (Used in) Investing Activities	$-1,389,000	$-3,035,000	$-4,713,800	$-4,713,800
Repayments of Long-term Debt	$900	$1,001,200	$1,100	$1,100
Proceeds from Issuance of Long-term Debt	—	$1,980,300	$985,700	$985,700
Payments for Repurchase of Common Stock	$1,231,700	$1,280,500	$2,083,300	$2,083,300
Payments of Dividends	$2,183,100	$2,398,900	$2,626,300	$2,626,300
Proceeds from (Repayments of) Commercial Paper	—	$4,769,500	$-4,769,500	$-4,769,500
Net Cash Provided by (Used in) Financing Activities	$-1,431,700	$-6,973,400	$4,881,000	$4,881,000
Cash and Cash Equivalents, at Carrying Value	$2,913,400	$3,347,800	$4,230,100	$4,230,100
Restricted Cash and Cash Equivalents	$7,172,600	$1,706,800	$6,395,100	$6,395,100
Interest Paid, Excluding Capitalized Interest, Operating Activities	$353,900	$426,800	$439,600	$439,600
Income Taxes Paid, Net	$1,185,200	$1,198,000	$1,006,700	$1,006,700
Increase (Decrease) in Accounts and Notes Receivable	$483,700	$146,600	$-1,000	$-1,000
Increase (Decrease) in Contract with Customer, Asset	$1,271,200	$1,290,300	$1,307,900	$1,307,900
Increase (Decrease) in Other Operating Assets	$157,200	$59,800	$204,500	$204,500
Increase (Decrease) in Accounts Payable, Trade	$1,800	$60,600	$-4,500	$-4,500
Increase (Decrease) in Accrued Liabilities	$492,900	$290,600	$410,100	$410,100

Loading financial statements…

Import this data to Google Sheets with:

=jivedata("ADP","financials")

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