Quest Diagnostics Inc (DGX)

Import this data to Google Sheets with:

=jivedata("DGX","financials")

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

Quest Diagnostics Inc

DGX • CIK 0001022079

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Revenue from Contract with Customer, Excluding Assessed Tax	$9,252,000	$9,872,000	$11,035,000	$11,560,000
Costs and Expenses	$7,990,000	$8,526,000	$9,479,000	$9,930,000
Operating Income (Loss)	$1,262,000	$1,346,000	$1,556,000	$1,630,000
Income (Loss) from Continuing Operations before Equity Method Investments, Income Taxes, Noncontrolling Interest	$1,130,000	$1,175,000	$1,318,000	$1,404,000
Income Tax Expense (Benefit)	$248,000	$273,000	$314,000	$320,000
Income (Loss) from Equity Method Investments	$26,000	$19,000	$42,000	$29,000
Net Income (Loss), Including Portion Attributable to Noncontrolling Interest	$908,000	$921,000	$1,046,000	$1,113,000
Net Income (Loss) Attributable to Noncontrolling Interest	$54,000	$50,000	$54,000	$51,000
Net Income (Loss) Attributable to Parent	$854,000	$871,000	$992,000	$1,062,000
Cost of Revenue	$6,199,000	$6,628,000	$7,370,000	$7,732,000
Selling, General and Administrative Expense	$1,642,000	$1,770,000	$1,967,000	$2,038,000
Amortization of Intangible Assets	$108,000	$127,000	$154,000	$151,000
Other Operating Income (Expense), Net	$-41,000	$-1,000	$12,000	$-9,000
Interest Income (Expense), Nonoperating, Net	—	$-201,000	$-264,000	$-256,000
Other Nonoperating Income (Expense)	$20,000	$30,000	$26,000	$30,000
Nonoperating Income (Expense)	$-132,000	$-171,000	$-238,000	$-226,000

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Cash and Cash Equivalents, at Carrying Value	$686,000	$549,000	$420,000	$626,000
Accounts Receivable, after Allowance for Credit Loss, Current	$1,210,000	$1,304,000	$1,408,000	$1,666,000
Inventory, Net	$190,000	$188,000	$189,000	$233,000
Prepaid Expense and Other Assets, Current	$286,000	$351,000	$361,000	$319,000
Assets, Current	$2,372,000	$2,392,000	$2,378,000	$2,844,000
Property, Plant and Equipment, Net	$1,816,000	$2,113,000	$2,203,000	$2,219,000
Operating Lease, Right-of-Use Asset	$602,000	$651,000	$657,000	$678,000
Goodwill	$7,733,000	$8,856,000	$8,945,000	$9,112,000
Intangible Assets, Net (Excluding Goodwill)	$1,166,000	$1,763,000	$1,636,000	$1,672,000
Equity Method Investments	$135,000	$123,000	$136,000	$137,000
Other Assets, Noncurrent	$198,000	$255,000	$270,000	$277,000
Assets	$14,022,000	$16,153,000	$16,225,000	$16,939,000
Long-term Debt and Lease Obligation	$4,410,000	$5,615,000	$5,167,000	$5,632,000
Operating Lease, Liability, Noncurrent	$503,000	$535,000	$537,000	$561,000
Other Liabilities, Noncurrent	$876,000	$938,000	$957,000	$1,059,000
Redeemable Noncontrolling Interest, Equity, Carrying Amount	$76,000	$83,000	$80,000	$80,000
Accounts Payable and Accrued Liabilities, Current	$1,359,000	$1,394,000	$1,600,000	$1,598,000
Long-term Debt, Current Maturities	$303,000	$602,000	$504,000	$10,000
Operating Lease, Liability, Current	$153,000	$173,000	$174,000	$180,000
Liabilities, Current	$1,815,000	$2,169,000	$2,278,000	$1,788,000
Stockholders' Equity Attributable to Noncontrolling Interest	$35,000	$35,000	$36,000	$303,000
Stockholders' Equity, Including Portion Attributable to Noncontrolling Interest	$6,342,000	$6,813,000	$7,206,000	$7,819,000
Common Stock, Value, Issued	$2,000	$2,000	$2,000	$2,000
Additional Paid in Capital, Common Stock	$2,320,000	$2,361,000	$2,381,000	$2,374,000
Retained Earnings (Accumulated Deficit)	$8,825,000	$9,360,000	$9,994,000	$10,374,000
Accumulated Other Comprehensive Income (Loss), Net of Tax	$-14,000	$-88,000	$-27,000	$-62,000
Treasury Stock, Value	$4,826,000	$4,857,000	$5,180,000	$5,172,000
Stockholders' Equity Attributable to Parent	$6,307,000	$6,778,000	$7,170,000	$7,516,000
Accounts Receivable, Allowance for Credit Loss, Current	$27,000	$29,000	$25,000	$28,000
Common Stock, Shares Authorized	600,000,000	600,000,000	600,000,000	600,000,000
Common Stock, Shares, Issued	162,000,000	162,000,000	162,000,000	162,000,000
Treasury Stock, Common, Shares	51,000,000	51,000,000	52,000,000	52,000,000

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Net Income (Loss), Including Portion Attributable to Noncontrolling Interest	$908,000	$921,000	$1,046,000	$1,113,000
Net Cash Provided by (Used in) Operating Activities	$1,272,000	$1,334,000	$1,886,000	$1,903,000
Effect of Exchange Rate on Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents	—	$-7,000	$4,000	$-3,000
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents, Period Increase (Decrease), Including Exchange Rate Effect	$371,000	$-137,000	$-129,000	$307,000
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents	$686,000	$549,000	$420,000	$625,000
Depreciation, Depletion and Amortization	$439,000	$493,000	$570,000	$580,000
Payments to Acquire Businesses, Net of Cash Acquired	$611,000	$2,164,000	$101,000	$122,000
Contract with Customer, Asset, Credit Loss Expense (Reversal)	—	—	$3,000	$4,000
Payments to Acquire Property, Plant, and Equipment	$408,000	$425,000	$527,000	$554,000
Deferred Income Tax Expense (Benefit)	$-49,000	$13,000	$105,000	$143,000
Payments for (Proceeds from) Other Investing Activities	$42,000	$-41,000	$3,000	$2,000
Share-based Payment Arrangement, Noncash Expense	$77,000	$88,000	$88,000	$88,000
Net Cash Provided by (Used in) Investing Activities	$-1,061,000	$-2,548,000	$-631,000	$-678,000
Other Noncash Income (Expense)	$-41,000	$-15,000	$-24,000	$-12,000
Proceeds from Issuance of Debt	$2,592,000	$1,846,000	$410,000	$504,000
Repayments of Debt	$1,844,000	$303,000	$1,012,000	$512,000
Payments for Repurchase of Common Stock	$275,000	$151,000	$450,000	$552,000
Proceeds from Stock Options Exercised	$72,000	$73,000	$79,000	$118,000
Payment, Tax Withholding, Share-based Payment Arrangement	$28,000	$24,000	$45,000	$41,000
Payments of Ordinary Dividends, Common Stock	$314,000	$331,000	$353,000	$363,000
Payments of Ordinary Dividends, Noncontrolling Interest	$57,000	$47,000	$56,000	$49,000
Proceeds from (Payments for) Other Financing Activities	$14,000	$21,000	$39,000	$-20,000
Net Cash Provided by (Used in) Financing Activities	$160,000	$1,084,000	$-1,388,000	$-915,000
Increase (Decrease) in Accounts Receivable	$15,000	$71,000	$106,000	$250,000
Increase (Decrease) in Accounts Payable and Accrued Liabilities	$-55,000	$-67,000	$129,000	$270,000
Increase (Decrease) in Income Taxes Payable	$-2,000	$16,000	$24,000	$19,000
Increase (Decrease) in Other Operating Assets and Liabilities, Net	$73,000	$79,000	$-3,000	$76,000

Loading financial statements…

Import this data to Google Sheets with:

=jivedata("DGX","financials")

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