Group 1 Automotive, Inc (GPI)

Import this data to Google Sheets with:

=jivedata("GPI","financials")

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

Group 1 Automotive, Inc

GPI • CIK 0001031203

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Revenue from Contract with Customer, Excluding Assessed Tax	$17,873,700	$19,934,300	$22,571,400	$22,154,800
Cost of Goods and Services Sold	$14,853,400	$16,693,300	$18,949,500	$18,622,100
Gross Profit	$3,020,300	$3,241,000	$3,621,800	$3,532,500
Selling, General and Administrative Expense	$1,926,800	$2,179,200	$2,545,500	$2,506,200
Restructuring Charges	—	$16,700	$28,400	$12,800
Other Operating Income (Expense), Net	—	$10,000	$0	$0
Operating Income (Loss)	$968,600	$909,100	$734,000	$692,800
Income (Loss) from Continuing Operations before Income Taxes, Noncontrolling Interest	$800,200	$658,500	$449,900	$403,400
Income Tax Expense (Benefit)	$198,200	$161,500	$126,200	$114,400
Income (Loss) from Continuing Operations, Net of Tax, Attributable to Parent	$602,000	$497,000	$323,700	$289,000
Income (Loss) from Discontinued Operations, Net of Tax, Attributable to Parent	$-400	$1,200	$1,500	$1,200
Net Income (Loss) Attributable to Parent	$601,600	$498,100	$325,200	$290,100
Interest Expense, Other	$99,800	$141,300	$182,900	$195,900
Other Nonoperating Income (Expense)	—	—	$200	$0
Weighted Average Number of Shares Outstanding, Basic	13,681,660	13,192,518	12,713,382	11,613,472
Weighted Average Number of Shares Outstanding, Diluted	13,734,799	13,249,884	12,737,232	11,634,982
Incremental Common Shares Attributable to Dilutive Effect of Share-based Payment Arrangements	53,139	57,366	23,850	21,510
Net Income (Loss) Available to Common Stockholders, Basic	$586,800	$487,600	$321,500	$287,300
Net Income (Loss) Available to Common Stockholders, Diluted	$586,900	$487,700	$321,500	$287,300

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Cash and Cash Equivalents, at Carrying Value	$57,200	$34,400	$32,500	$164,500
Property, Plant, and Equipment and Finance Lease Right-of-Use Asset, after Accumulated Depreciation and Amortization	$2,248,700	$2,856,500	$3,137,400	$3,101,700
Assets	$7,774,100	$9,824,200	$10,349,600	$10,286,500
Accounts and Financing Receivable, after Allowance for Credit Loss, Current	$238,400	$303,000	$308,400	$287,000
Operating Lease, Right-of-Use Asset	$216,500	$315,300	$276,000	$255,800
Inventory, Net	$1,963,400	$2,636,800	$2,741,300	$2,759,600
Goodwill	$1,651,900	$2,057,900	$2,204,900	$2,172,600
Prepaid Expense, Current	$38,900	$67,900	$65,300	$37,900
Indefinite-Lived Franchise Rights	$701,200	$948,100	$933,800	$947,400
Other Assets, Current	$25,100	$18,800	$17,400	$17,000
Other Assets, Noncurrent	$164,600	$149,100	$135,100	$136,100
Disposal Group, Including Discontinued Operation, Assets, Current	$99,100	$76,200	$171,400	$107,200
Assets, Current	$2,791,300	$3,497,300	$3,662,600	$3,672,900
Long-term Debt and Lease Obligation	$1,989,400	$2,737,900	$3,440,500	$3,048,400
Operating Lease, Liability, Noncurrent	$209,400	$276,200	$229,900	$207,000
Deferred Income Tax Liabilities, Net	$256,600	$295,800	$331,100	$325,900
Other Liabilities, Noncurrent	$138,600	$143,300	$155,800	$151,500
Long-term Debt and Lease Obligation, Current	$109,400	$175,300	$259,000	$314,600
Operating Lease, Liability, Current	$20,900	$25,800	$25,100	$25,300
Accounts Payable, Current	$499,300	$738,000	$732,800	$685,600
Accrued Liabilities, Current	$303,400	$418,600	$432,000	$394,700
Disposal Group, Including Discontinued Operation, Liabilities, Current	$7,200	$17,100	$38,500	$0
Liabilities, Current	$2,505,700	$3,396,800	$3,403,100	$3,601,500
Preferred Stock, Value, Issued	$0	$0	$0	$0
Common Stock, Value, Issued	$300	$200	$200	$200
Additional Paid in Capital, Common Stock	$349,100	$356,100	$388,500	$401,500
Retained Earnings (Accumulated Deficit)	$3,649,800	$4,122,400	$4,421,900	$4,642,300
Accumulated Other Comprehensive Income (Loss), Net of Tax	$28,100	$1,600	$31,600	$20,900
Treasury Stock, Common, Value	$1,352,800	$1,506,200	$2,053,200	$2,112,800
Stockholders' Equity Attributable to Parent	$2,674,400	$2,974,300	$2,789,100	$2,952,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	50,000,000	50,000,000	50,000,000	50,000,000
Common Stock, Shares, Issued	25,131,460	24,989,807	24,941,249	24,922,415
Treasury Stock, Common, Shares	11,447,422	11,711,022	12,897,840	12,996,502

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Net Income (Loss) Attributable to Parent	$601,600	$498,100	$325,200	$290,100
Net Cash Provided by (Used in) Operating Activities	$190,200	$586,300	$694,500	$439,200
Effect of Exchange Rate on Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents	$100	$-7,600	$6,000	$-900
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents, Period Increase (Decrease), Including Exchange Rate Effect	$9,400	$-22,800	$-1,900	$111,800
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents	$57,200	$34,400	$32,500	$3,700
Payments to Acquire Businesses, Net of Cash Acquired	$366,100	$1,276,800	$546,800	$446,000
Operating Lease, Right-of-Use Asset, Amortization Expense	$25,300	$27,200	$30,600	$30,700
Deferred Income Tax Expense (Benefit)	$18,700	$23,600	$24,800	$3,100
Payments to Acquire Property, Plant, and Equipment	$185,400	$245,100	$270,000	$272,900
Asset Impairment Charges	$32,900	$34,800	$199,600	$198,700
Payments for (Proceeds from) Other Investing Activities	$8,300	$-9,600	$0	$1,500
Share-based Payment Arrangement, Noncash Expense	$20,100	$25,200	$29,000	$32,000
Net Cash Provided by (Used in) Investing Activities	$-366,100	$-1,282,600	$-671,300	$-277,800
Amortization of Debt Issuance Costs and Discounts	$3,000	$4,000	$5,400	$5,400
Gain (Loss) on Disposition of Assets	$23,300	$59,500	$18,700	$50,000
Unrealized Gain (Loss) on Derivatives	$3,700	$-300	$-1,300	$200
Other Noncash Income (Expense)	$2,700	$100	$400	$-100
Payments of Debt Issuance Costs	$300	$10,800	$7,200	$200
Proceeds from Issuance of Senior Long-term Debt	$0	$500,000	$0	$0
Proceeds from Issuance of Other Long-term Debt	$150,200	$706,400	$119,300	$120,000
Repayments of Other Long-term Debt	$223,600	$193,300	$260,500	$319,200
Payment, Tax Withholding, Share-based Payment Arrangement	$12,100	$33,000	$13,400	$10,800
Payments for Repurchase of Common Stock	$172,800	$161,600	$554,800	$459,900
Payments of Ordinary Dividends, Common Stock	$25,200	$25,200	$25,600	$25,600
Net Cash Provided by (Used in) Financing Activities	$185,200	$681,100	$-31,100	$-48,500
Increase (Decrease) in Accounts Payable and Accrued Liabilities	$39,200	$90,700	$-27,200	$-43,000
Increase (Decrease) in Accounts and Other Receivables	$37,400	$32,900	$2,200	$-3,100
Increase (Decrease) in Retail Related Inventories	$567,600	$254,400	$47,700	$207,100
Increase (Decrease) in Prepaid Expense and Other Assets	$21,200	$18,100	$4,400	$-7,900
Increase (Decrease) in Contract with Customer, Liability	$-900	$-1,300	$-1,100	$-3,000
IncreaseDecreaseInOperatingLeaseLiability	$-24,400	$-22,900	$-29,300	$-29,800

Loading financial statements…

Import this data to Google Sheets with:

=jivedata("GPI","financials")

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