Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Group 1 Automotive Inc. logo

Group 1 Automotive Inc.

Sector: Consumer Cyclical   

Industry: Auto & Truck Dealerships

263.16
 
USD
  
-2.58
  
(-0.97%)
Optionable: Yes  Market Cap: 3,690 M  90-day average vol: 140,691

Previous close: 265.74  Open: 267.0  Bid: 105.37  Ask: 269.05
52 week range    
214.25   
   310.08
Peers   
PAG / 
AN / 
SAH / 
ABG / 
LAD / 
KMX / 
CRMT / 
CPRT / 
Last updated: Friday 19th April 2024
63
MarketXLS Rank
80
Value
38
Technical
73
Quality

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
Search for a stock

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord

Financials

GPI Balance Sheet

Annual
Dec-15Dec-16Dec-17Dec-18Dec-19Mar-20Dec-20Dec-21Dec-22Dec-23
"""debtc"""55 M72 M78 M93 M84 M379 M76 M246 M152 M130 M
Accounts payable280 M356 M413 M419 M528 M411 M430 M458 M488 M499 M
Accounts receivable161 M176 M189 M194 M225 M177 M192 M178 M199 M238 M
Accrued expenses466 M533 M590 M617 M734 M608 M648 M716 M760 M803 M
Accumulated depreciation & depletion-235 M-264 M-308 M-347 M-72 M-452 M-513 M-554 M-588 M
Additional paid in capital291 M291 M291 M293 M295 M288 M308 M326 M339 M349 M
Building & improvements1 M
Cash and equivalents13 M21 M29 M16 M24 M19 M69 M15 M48 M57 M
CashCashEquivalentsAndShortTermInvestments13 M21 M29 M16 M24 M19 M69 M15 M48 M57 M
CashEquivalents13 M21 M29 M16 M24 M19 M69 M
Common par257000.0257000.0255000.0300000.0300000.0300000.0300000.0300000.0300000.0300000.0
Common stock equity918 M930 M1,124 M1,096 M1,256 M1,175 M1,450 M1,825 M2,238 M2,674 M
CommonStock257000.0257000.0255000.0300000.0300000.0300000.0300000.0300000.0300000.0300000.0
Cost in excess855 M877 M913 M964 M1,008 M1,000 M997 M1,420 M1,662 M1,652 M
CurrentAccruedExpenses185 M176 M177 M198 M207 M197 M218 M259 M272 M303 M
CurrentCapitalLeaseObligation53 M57 M43 M38 M25 M24 M20 M26 M22 M21 M
CurrentDeferredTaxesAssets64 M70 M51 M46 M107 M122 M142 M139 M134 M
CurrentDeferredTaxesLiabilities144 M160 M120 M131 M141 M142 M317 M369 M386 M
Deferred revenues14 M
DerivativeProductLiabilities31 M20 M9 M2 M4 M42 M41 M11 M
DividendsPayable20 M20 M21 M20 M11 M-24 M-24 M-25 M
Float term debt834 M836 M1,318 M1,282 M1,432 M1,138 M1,281 M2,072 M2,191 M2,199 M
GoodwillAndOtherIntangibleAssets1,163 M1,162 M1,199 M1,224 M1,262 M1,252 M1,230 M1,813 M2,178 M2,353 M
Gross fixed assets (Plant Property & Equipment)1,269 M1,390 M1,627 M1,695 M1,839 M1,768 M2,244 M2,739 M2,932 M3,053 M
Intangibles308 M285 M286 M260 M254 M252 M233 M392 M516 M701 M
Inventories1,738 M1,652 M1,763 M1,844 M1,902 M1,993 M1,446 M1,073 M1,357 M1,963 M
InventoriesAdjustmentsAllowances-8 M-8 M-9 M-8 M-10 M-9 M-4 M-5 M-9 M
Invested capital1,752 M1,766 M2,442 M2,411 M3,267 M2,351 M3,509 M5,712 M6,380 M6,863 M
Leases169 M221 M271 M
LineOfCredit25 M24 M21 M18 M
LongTermCapitalLeaseObligation70 M69 M52 M49 M211 M209 M206 M257 M238 M209 M
LongTermDebtAndCapitalLeaseObligation834 M836 M1,318 M1,282 M1,643 M1,347 M1,487 M2,072 M2,191 M2,199 M
Net fixed assets (net PP&E)1,034 M1,126 M1,319 M1,348 M1,767 M1,768 M1,792 M2,226 M2,377 M2,465 M
Non-current deferred income taxes137 M162 M124 M135 M146 M136 M141 M181 M238 M257 M
NonCurrentDeferredLiabilities137 M162 M124 M135 M146 M136 M141 M181 M238 M257 M
NonCurrentDeferredTaxesAssets111 M124 M105 M98 M177 M153 M167 M149 M141 M
Number of employees15491.015491.015491.015491.015491.015491.015491.015491.015491.015491.0
Other current assets-111 M-85 M220 M26 M16 M12 M71 M151 M73 M493 M
Other equity adjustments-138 M-147 M-123 M-138 M-147 M-206 M-184 M
Other fixed assets2,226 M2,377 M2,465 M
Other non-current assets12 M24 M2 M293 M279 M138 M275 M264 M455 M165 M
Other non-current liabilities72 M84 M494 M1,361 M99 M102 M1,241 M128 M130 M1,292 M
Other receivable11,124 M11,601 M12,044 M2,691 M10,600 M13,482 M16,222 M17,874 M
OtherCurrentBorrowings3 M16 M
OtherCurrentLiabilities31 M393 M1,241 M418 M1,604 M1,654 M31 M581 M1,010 M420 M
OtherEquityInterest-119 M-138 M-700000.09 M
OtherInventories1,746 M1,660 M1,772 M1,844 M1,902 M1,446 M1,073 M1,357 M1,963 M
OtherPayable212 M157 M216 M141 M192 M1,100 M529 M366 M
Payables280 M356 M413 M419 M528 M411 M430 M458 M488 M499 M
Preferred securities of subsidiary trust1000000.01000000.01000000.01000000.0
PreferredStock1000000.01000000.01000000.01000000.0
Prepaid expenses5 M516000.042 M56 M96 M83 M15 M31 M31 M39 M
RecievablesAdjustmentsAllowances-3 M-3 M-3 M-3 M-3 M-3 M-3 M-4 M-5 M-4 M
Retained earnings926 M1,053 M1,246 M1,395 M1,542 M1,567 M1,818 M2,190 M3,096 M3,678 M
SecuritySoldNotYetRepurchased97 M128 M40 M184 M1 M
Short term debt55 M72 M78 M93 M59 M355 M56 M220 M130 M109 M
Total assets4,397 M4,462 M4,871 M5,001 M5,570 M5,441 M5,089 M5,749 M6,718 M7,774 M
Total current assets2,188 M2,151 M2,329 M2,402 M2,516 M2,399 M2,004 M1,666 M1,985 M2,791 M
Total current liabilities2,039 M2,053 M2,198 M2,387 M2,422 M2,640 M1,843 M1,544 M1,921 M2,506 M
Total equity918 M930 M1,124 M1,096 M1,256 M1,175 M1,450 M1,825 M2,238 M2,674 M
Total liabilities1,043 M1,081 M3,856 M3,905 M4,314 M4,225 M3,640 M3,924 M4,480 M5,100 M
Total non-current assets2,388 M2,787 M2,519 M2,864 M4,855 M3,157 M3,296 M4,302 M5,011 M4,983 M
Total non-current liabilities1,043 M1,081 M1,945 M2,778 M1,892 M1,584 M2,884 M2,381 M2,559 M3,747 M
TotalEquityGrossMinority1,241 M930 M1,124 M1,096 M1,256 M1,175 M1,450 M1,825 M2,238 M2,675 M
TotalEquityGrossMinorityInterest1,241 M930 M1,124 M1,096 M1,256 M1,175 M1,450 M1,825 M2,238 M2,675 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest4,397 M4,462 M4,871 M5,001 M5,570 M5,441 M5,089 M5,749 M6,718 M7,774 M
TotalNonCurrentLiabilitiesNetMinorityInteres1,043 M1,081 M1,945 M2,778 M1,892 M1,584 M2,884 M2,381 M2,559 M3,747 M
Treasury stock161 M-267 M-291 M-454 M-435 M-474 M-493 M-690 M-1,197 M-1,353 M
UnearnedIncome2,388 M2,787 M1,547 M1,608 M
Working capital149 M97 M131 M16 M94 M-241 M162 M123 M64 M286 M
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

MarketXLS is a complete Excel stock solution

Kevin Hsu

StockKevin.com

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.

Dave

Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University