DONALDSON COMPANY, INC. (DCI)

Import this data to Google Sheets with:

=jivedata("DCI","financials")

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

DONALDSON COMPANY, INC.

DCI • CIK 0000029644

(in thousands, except per share data)	FY 2024	FY 2025	FY 2026	TTM
Net Income (Loss) Attributable to Parent	$414,000	$367,000	$453,800	$453,800
Antidilutive Securities Excluded from Computation of Earnings Per Share, Amount	0	700,000	0	0
Weighted Average Number of Shares Outstanding, Basic	120,700,000	118,700,000	115,800,000	115,800,000
Weighted Average Number Diluted Shares Outstanding Adjustment	1,900,000	1,700,000	2,100,000	2,100,000
Weighted Average Number of Shares Outstanding, Diluted	122,600,000	120,400,000	117,900,000	117,900,000

(in thousands, except per share data)	FY 2024	FY 2025	FY 2026	TTM
Cash and Cash Equivalents, at Carrying Value	$232,700	$180,400	$250,400	$250,400
Accounts Receivable, after Allowance for Credit Loss, Current	$629,700	$662,200	$758,100	$758,100
Property, Plant and Equipment, Net	$645,500	$644,500	$633,300	$633,300
Inventory, Net	$476,700	$513,600	$538,700	$538,700
Goodwill	$478,400	$493,600	$1,086,800	$1,086,800
Prepaid Expense and Other Assets, Current	$99,000	$105,500	$122,500	$122,500
Intangible Assets, Net (Excluding Goodwill)	$171,900	$97,400	$304,600	$304,600
Assets, Current	$1,438,100	$1,461,700	$1,669,700	$1,669,700
Other Assets, Noncurrent	$180,400	$280,000	$292,400	$292,400
Assets	$2,914,300	$2,977,200	$3,986,800	$3,986,800
Long-term Debt and Lease Obligation	$483,400	$630,400	$1,280,000	$1,280,000
Accrued Income Taxes, Noncurrent	$39,800	$19,000	$19,000	$19,000
Deferred Income Tax Liabilities, Net	$16,100	$10,500	$28,300	$28,300
Other Liabilities, Noncurrent	$103,400	$106,600	$91,000	$91,000
Liabilities	$1,425,200	$1,523,700	$2,222,400	$2,222,400
Short-term Debt	$28,300	$31,200	$44,800	$44,800
Long-term Debt and Lease Obligation, Current	$25,000	$6,700	$0	$0
Accounts Payable, Current	$379,400	$368,600	$378,600	$378,600
Employee-related Liabilities, Current	$140,900	$144,300	$152,500	$152,500
Taxes Payable, Current	$42,600	$43,900	$20,500	$20,500
Other Liabilities, Current	$114,100	$162,500	$207,700	$207,700
Liabilities, Current	$782,500	$757,200	$804,100	$804,100
Preferred Stock, Value, Issued	$0	$0	$0	$0
Common Stock, Value, Issued	$758,200	$758,200	$758,200	$758,200
Additional Paid in Capital	$26,800	$35,800	$44,600	$44,600
Retained Earnings (Accumulated Deficit)	$2,377,500	$2,610,100	$2,920,300	$2,920,300
Accumulated Other Comprehensive Income (Loss), Net of Tax	$-198,900	$-180,700	$-146,200	$-146,200
Treasury Stock, Common, Value	$1,474,500	$1,769,900	$1,812,500	$1,812,500
Stockholders' Equity Attributable to Parent	$1,489,100	$1,453,500	$1,764,400	$1,764,400
Accounts Receivable, Allowance for Credit Loss, Current	$6,300	$2,900	$3,200	$3,200
Preferred Stock, Shares Authorized	1,000,000	1,000,000	1,000,000	1,000,000
Preferred Stock, Shares Issued	0	0	0	0
Common Stock, Shares Authorized	240,000,000	240,000,000	240,000,000	240,000,000
Common Stock, Shares, Issued	151,643,194	151,643,194	151,643,194	151,643,194
Treasury Stock, Common, Shares	31,533,192	35,600,740	35,649,047	35,649,047
Operating Lease, Right-of-Use Asset	$59,700	$60,500	$52,400	$52,400
Operating Lease, Liability, Current	$20,200	$24,100	$24,800	$24,800
Operating Lease, Liability, Noncurrent	$41,300	$37,800	$33,100	$33,100

(in thousands, except per share data)	FY 2024	FY 2025	FY 2026	TTM
Net Income (Loss) Attributable to Parent	$414,000	$367,000	$453,800	$453,800
Net Cash Provided by (Used in) Operating Activities	$492,500	$418,800	$493,700	$493,700
Effect of Exchange Rate on Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents	$-4,100	$1,000	$4,200	$4,200
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents, Period Increase (Decrease), Including Exchange Rate Effect	$45,600	$-52,300	$70,000	$70,000
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents	$232,700	$180,400	$250,400	$250,400
Depreciation, Depletion and Amortization	$98,400	$99,500	$106,000	$106,000
Payments to Acquire Property, Plant, and Equipment	$85,600	$78,900	$67,400	$67,400
Income (Loss) from Equity Method Investments, Net of Dividends or Distributions	$4,700	$3,600	$8,000	$8,000
Proceeds from Sale of Property, Plant, and Equipment	$700	$2,100	$10,500	$10,500
Deferred Income Tax Expense (Benefit)	$-24,300	$-24,000	$-300	$-300
Payments to Acquire Equity Method Investments	—	$71,200	$0	$0
Share-based Payment Arrangement, Noncash Expense	$22,000	$24,000	$24,700	$24,700
Payments to Acquire Businesses, Net of Cash Acquired	$2,000	$2,400	$822,600	$822,600
Impairment of Intangible Assets, Finite-lived	—	$62,000	$0	$0
Net Cash Provided by (Used in) Investing Activities	$-86,900	$-150,400	$-879,500	$-879,500
Gain (Loss) on Disposition of Property Plant Equipment	—	—	$9,300	$9,300
Other Noncash Income (Expense)	$-3,700	$5,900	$-9,800	$-9,800
Proceeds from Issuance of Long-term Debt	$119,700	$388,100	$858,900	$858,900
Repayments of Long-term Debt	$228,800	$265,000	$216,200	$216,200
Proceeds from (Repayments of) Short-term Debt	$-5,700	$1,200	$13,700	$13,700
Payments for Repurchase of Common Stock	$162,700	$331,500	$111,200	$111,200
Payment for Contingent Consideration Liability, Financing Activities	$1,700	$5,500	$2,300	$2,300
Payments of Ordinary Dividends, Common Stock	$122,800	$131,900	$141,200	$141,200
Payment, Tax Withholding, Share-based Payment Arrangement	$8,000	$5,700	$6,000	$6,000
Proceeds from Stock Options Exercised	$54,100	$28,600	$55,900	$55,900
Net Cash Provided by (Used in) Financing Activities	$-355,900	$-321,700	$451,600	$451,600
Income Taxes Paid, Net	$147,800	$176,200	$160,900	$160,900
Interest Paid, Excluding Capitalized Interest, Operating Activities	$23,400	$22,200	$33,100	$33,100
Capital Expenditures Incurred but Not yet Paid	$14,200	$10,700	$10,000	$10,000
Right-of-Use Asset Obtained in Exchange for Operating Lease Liability	$22,700	$24,000	$22,200	$22,200
Increase (Decrease) in Accounts Receivable	$39,400	$21,400	$75,100	$75,100
Increase (Decrease) in Inventories	$65,600	$32,200	$-800	$-800
Increase (Decrease) in Prepaid Expense and Other Assets	$28,300	$-6,300	$12,500	$12,500
Increase (Decrease) in Accounts Payable	$80,300	$-5,500	$-2,000	$-2,000
Increase (Decrease) in Income Taxes Payable	$4,400	$-34,400	$-25,700	$-25,700

Loading financial statements…

Import this data to Google Sheets with:

=jivedata("DCI","financials")

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