Group 1 Automotive, Inc GPI Cash Flow

Group 1 automotive, inc (GPI)

CashFlow / TTM

Mar'20	Dec'19	Sep'19	Jun'19	Mar'19	Dec'18	Sep'18	Jun'18	Mar'18	Dec'17	Sep'17	Jun'17	Mar'17	Dec'16	Sep'16	Jun'16	Mar'16	Dec'15	Sep'15	Jun'15	Mar'15	Dec'14	Sep'14	Jun'14	Mar'14	Dec'13	Sep'13	Jun'13	Mar'13	Dec'12	Sep'12	Jun'12	Mar'12	Dec'11	Sep'11	Jun'11	Mar'11
CASH FLOWS FROM OPERATING ACTIVITIES:
Net Income (Loss) Attributable to Parent
29,752	38,600	156,600	153,396	160,634	157,800	237,547	232,605	215,275	213,400	133,781	139,266	146,713	147,065	82,851	92,746	92,475	93,999	146,062	126,963	97,516	93,004	96,048	102,651	123,177	113,992	109,403	107,973	99,210	100,209	103,932	94,091	90,149	82,394	0	0	0
Adjustments to reconcile net income (loss) to net cash provided by (used in) operating activities:
Depreciation and amortization
18,603	17,000	70,100	68,981	67,755	67,100	65,142	63,181	60,636	57,900	55,925	53,756	52,376	51,234	49,865	48,786	48,019	47,239	46,361	45,296	44,103	42,344	40,860	39,207	37,338	35,826	34,850	33,853	32,711	31,534	30,256	29,005	27,844	27,063	0	0	0
Change in operating lease assets
6,376	7,600	0	0	0	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Deferred income taxes
-388	4,100	3,000	3,047	4,913	3,500	-58,102	-51,604	-48,928	-46,100	15,917	17,273	14,665	14,162	13,096	11,768	13,564	11,884	18,960	11,509	12,726	12,319	12,305	22,034	16,198	22,412	19,128	16,495	19,346	13,282	19,299	16,789	20,839	24,824	0	0	0
Asset impairments
-	-	-	-	-	-	-	-	-	-	-	-	-	32,838	98,419	88,479	88,494	87,562	0	0	0	-	-	-	-	-	-	-	-	7,276	1,085	4,729	4,684	4,805	0	0	0
Stock-based compensation
5,120	6,100	18,900	18,812	19,138	18,700	18,494	18,332	18,468	18,900	20,800	21,363	21,636	21,073	19,563	19,567	19,474	18,851	18,308	17,579	17,240	16,012	15,297	14,825	14,156	13,899	13,461	12,976	12,440	11,931	11,529	11,276	11,069	10,919	0	0	0
Amortization of debt discount and issue costs
954	900	4,000	3,937	3,696	3,400	3,348	3,377	3,438	3,700	3,763	3,458	4,122	3,694	3,708	3,925	3,237	3,652	3,625	5,136	7,846	10,559	13,096	14,296	14,114	13,888	13,784	13,429	13,206	12,990	12,778	12,530	12,282	11,990	0	0	0
(Gain) loss on disposition of assets
22	5,800	5,700	12,099	32,062	26,800	26,952	21,172	1,036	800	1,711	2,372	2,365	2,675	10,062	8,829	10,317	9,719	100	16,852	15,970	15,994	17,313	2,022	10,481	11,043	16,034	13,023	5,511	4,941	0	0	0	-	-	-	-
Tax effect from excess stock-based compensation
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	2,523	2,177	2,112	1,841	2,725	2,967	2,977	2,993	3,273	3,297	3,133	2,875	2,842	2,714	2,644	2,478	0	0	0
Other
-366	-200	-1,000	-1,338	-1,140	-900	-748	-341	-465	400	503	176	506	-1,084	1,204	502	-182	-1,192	-6,074	-5,818	-5,871	-4,686	-3,411	-3,791	-3,405	-3,665	-4,657	-4,221	-4,349	-3,965	-3,728	-3,150	-3,023	-2,755	0	0	0
Changes in assets and liabilities, net of acquisitions and dispositions:
Accounts payable and accrued expenses
-98,118	101,600	82,000	69,626	54,818	18,400	-14,063	90,201	91,636	35,600	82,384	32,173	53,110	76,126	73,155	9,384	67,617	25,108	13,291	38,158	-19,540	37,344	105,555	25,247	34,433	41,144	1,080	58,531	75,302	29,874	56,599	69,760	74,429	77,027	0	0	0
Accounts and notes receivable
-41,645	-9,200	57,100	13,685	672	-2,900	-26,592	3,097	19,481	10,700	27,925	13,645	7,959	18,663	10,696	10,722	13,358	17,887	20,438	13,955	18,726	20,179	18,866	11,199	6,505	9,489	10,642	-4,828	12,078	6,777	15,103	36,558	18,014	17,875	0	0	0
Inventories
125,742	28,100	72,600	96,184	115,811	80,600	78,754	-145,437	-37,407	44,000	-86,934	40,766	-60,802	-79,319	57,341	119,976	240,902	186,634	120,380	85,802	12,399	-27,339	54,612	105,579	119,549	241,871	193,081	230,039	277,685	278,232	312,259	220,295	97,746	7,410	0	0	0
Contracts-in-transit and vehicle receivables
-135,183	-5,100	22,600	4,797	-33,380	-39,500	-51,973	30,180	78,403	33,500	80,475	6,883	9,743	15,621	-2,167	-23,480	-21,831	17,944	14,899	22,251	16,823	10,530	30,419	23,221	16,259	18,974	8,942	33,751	33,072	29,091	42,211	38,077	32,152	53,821	0	0	0
Prepaid expenses and other assets
-1,772	17,700	4,400	22,958	21,424	16,300	26,770	14,242	22,914	9,300	15,403	12,989	-4,074	-7,484	-13,303	-8,993	1,266	3,153	16,807	2,616	5,493	5,385	-13,818	-482	-2,874	-1,941	3,081	1,650	240	-2,448	1,217	6,053	8,191	11,246	0	0	0
Floorplan notes payable - manufacturer affiliates
-35,868	2,500	-23,400	-50,774	-30,865	-38,400	-10,764	49,614	107	8,300	-1,270	-42,417	31,166	12,630	-18,466	-65,372	-109,515	-87,516	-48,319	21,488	57,768	78,822	43,766	13,126	-26,517	-83,203	-89,041	-80,196	-63,945	-33,248	0	0	0	-	-	-	0
Deferred revenues
-222	-200	-400	-370	-323	-800	-775	11	9	500	410	-365	-426	-393	-326	-571	-614	-619	-914	-1,015	-1,131	-491	-312	310	655	230	291	-632	89	-163	-292	115	-1,099	-1,427	0	0	0
Operating lease liabilities
7,286	8,400	0	0	0	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net cash provided by (used in) operating activities
44,061	127,900	223,400	259,842	249,157	270,000	246,666	407,444	276,065	196,500	304,719	263,392	337,239	384,097	296,791	233,339	198,955	141,047	157,320	147,930	123,263	198,288	195,242	95,997	123,638	52,372	60,935	57,707	-3,946	-75,322	-109,093	-46,779	135,411	199,316	0	0	0
CASH FLOWS FROM INVESTING ACTIVITIES:
Payments to Acquire Businesses, Net of Cash Acquired
-	-	97,000	60,435	63,801	135,300	135,318	183,870	180,504	109,100	109,082	2,683	6,312	57,327	57,327	136,208	213,220	212,252	239,546	338,058	334,045	336,551	472,445	309,361	264,236	269,860	168,100	152,773	180,905	177,956	166,190	164,621	179,887	159,597	0	0	0
Proceeds from disposition of franchises, property and equipment
475	35,100	43,300	69,915	140,085	107,900	113,267	84,041	11,433	10,700	18,904	25,440	25,179	36,843	54,969	48,227	54,281	41,581	15,481	142,172	145,571	144,597	139,165	34,029	84,860	102,186	140,761	116,905	56,581	39,197	528	1,078	1,943	6,039	0	0	0
Purchases of property and equipment
31,589	41,700	162,200	162,008	134,763	141,000	189,790	236,764	217,297	215,800	175,139	153,515	169,270	156,521	167,605	142,038	130,797	120,252	137,386	130,152	146,454	150,392	130,313	124,284	109,982	102,858	84,504	97,357	90,845	88,491	83,383	75,520	62,869	60,558	0	0	0
Other
0	200	0	-850	-160	-500	-474	1,129	719	-1,600	-1,567	-1,690	-5,530	-2,965	-3,298	-3,476	-6,028	-6,421	-7,174	-7,714	2,879	4,705	6,109	4,821	113	-1,878	-2,133	-2,970	-2,952	-2,792	-3,736	-983	-1,522	-1,343	0	0	0
Net cash provided by (used in) investing activities
-31,114	-6,800	-216,000	-151,778	-58,419	-168,000	-211,367	-280,623	-387,087	-312,600	-263,750	-185,974	-144,873	-174,040	-166,665	-226,736	-283,708	-284,502	-354,277	-318,324	-337,807	-347,051	-469,702	-404,437	-289,471	-268,654	-109,710	-130,255	-212,217	-224,458	-245,309	-238,080	-239,291	-212,773	0	0	0
CASH FLOWS FROM FINANCING ACTIVITIES:
Borrowings on credit facility — floorplan line and other
1,691,556	1,631,500	7,158,700	6,937,032	6,929,652	6,954,300	7,072,302	6,973,318	7,080,921	7,019,100	6,610,278	6,593,860	6,535,835	6,597,406	7,068,625	7,379,837	7,616,145	7,557,237	7,313,960	7,646,933	7,925,398	7,832,014	7,718,731	6,994,033	6,337,715	6,379,328	6,221,226	6,023,478	5,887,929	5,700,108	5,377,017	5,180,200	4,945,688	4,825,956	0	0	0
Repayments on credit facility — floorplan line and other
1,665,645	1,697,500	7,049,200	6,833,965	6,865,108	6,870,100	7,034,625	7,131,027	7,062,056	6,957,900	6,636,870	6,638,611	6,598,839	6,676,161	7,173,130	7,363,661	7,539,057	7,504,516	7,195,457	7,507,399	7,931,980	7,802,719	7,587,596	6,873,073	6,205,338	6,153,677	6,091,619	5,873,051	5,636,096	5,453,148	5,031,868	4,899,179	4,837,413	4,777,442	0	0	0
Borrowings on credit facility — acquisition line
30,023	107,800	297,200	190,863	206,132	165,300	98,615	119,187	120,045	68,100	68,085	117,509	195,020	220,020	124,925	293,518	339,615	489,548	659,048	645,455	559,338	389,368	374,963	149,963	79,963	60,000	0	0	0	-	-	-	-	-	-	-	-
Repayments on credit facility — acquisition line
30,034	111,500	278,500	191,550	203,522	158,500	98,124	112,184	93,744	42,300	35,576	95,000	195,020	220,020	261,772	373,494	461,789	557,696	520,636	573,903	485,588	379,681	374,989	130,000	30,000	0	0	0	0	-	-	-	-	-	-	-	-
Borrowings on real estate credit facility
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	19,840	19,840	19,840	19,640	0	0	14,080	18,080	0	0	0	-	-	-	-
Principal payments on real estate credit facility
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	9,759	2,959	2,711	8,597	8,677	8,582	8,436	2,406	0	0	0	-	-	-	-
Debt issue costs
0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Borrowings on other debt
27,271	20,300	163,500	121,726	110,715	156,000	162,684	271,705	231,314	165,700	138,502	35,456	49,972	49,972	64,266	53,764	46,177	59,855	45,802	63,843	85,132	91,137	88,171	62,550	29,972	10,289	1,067	1,016	239	275	142	265	264	308	0	0	0
Principal payments on other debt
26,007	26,700	146,900	133,203	105,415	118,800	138,099	196,442	161,046	121,200	102,797	24,222	42,902	45,928	52,672	59,075	56,383	63,769	58,567	65,680	72,228	85,905	75,991	37,540	29,076	71,170	66,292	82,766	70,359	4,784	4,380	4,456	3,366	3,293	0	0	0
Borrowings on debt related to real estate
0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	112,179	99,868	81,896	63,191	55,345	37,470	54,985	67,094	70,685	0	0	0	-	-	-	-
Borrowings Of Long Term Debt Related To Real Estate Loans, Net of Debt Issue Costs
-	-	74,800	33,173	7,865	54,700	90,969	117,110	122,135	75,300	35,518	21,288	8,810	39,141	51,462	39,562	43,969	31,238	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Principal payments on debt related to real estate
7,636	20,900	121,100	81,419	74,545	91,500	91,331	78,871	60,388	29,400	27,887	27,145	26,756	25,463	69,883	69,935	71,159	72,079	41,967	58,073	54,898	59,950	43,210	40,228	45,211	36,978	40,692	23,480	16,172	15,197	9,388	8,685	8,077	7,775	0	0	0
Proceeds from employee stock purchase plan
5,430	2,100	8,900	8,594	8,408	7,600	4,404	4,624	6,492	7,100	6,612	6,219	4,081	3,868	2,455	1,463	1,111	214	-1,297	-1,489	-1,372	-321	-2,173	-2,299	-2,519	-1,822	0	0	0	-	-	-	-	-709	0	0	0
Payment of tax withholding for stock-based awards
0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Repurchases of common stock, amounts based on settlement date
48,900	0	75,300	132,624	174,701	183,900	108,606	52,351	49,299	40,100	40,094	51,385	95,661	127,606	158,333	179,598	113,243	97,473	86,601	52,981	36,035	36,802	20,500	20,495	20,495	3,553	0	2,821	11,937	11,317	0	0	0	-	-	-	-
Tax effect from stock-based compensation
-	-	-	-	-	-	-	-	-	-	-	-	-	249	-167	-618	-1,085	-2,142	-4,813	-4,383	-3,578	-1,841	2,725	2,967	2,977	2,993	3,273	3,297	3,133	2,875	2,842	2,714	2,644	2,478	0	0	0
Dividends paid
5,459	4,800	19,700	19,755	20,246	20,900	21,279	21,136	20,845	20,500	20,154	20,063	19,989	19,987	20,215	20,329	20,198	19,942	19,587	18,599	17,874	17,097	16,420	16,515	16,293	15,805	15,080	14,349	13,880	13,433	12,978	12,572	11,772	11,211	0	0	0
Net cash provided by (used in) financing activities
-18,501	-102,500	4,600	-108,802	-184,465	-109,500	-64,590	-107,549	111,129	121,500	-1,064	-79,099	-185,645	-205,007	-131,275	-4,239	82,523	121,009	175,083	178,150	215,992	171,650	301,246	321,313	182,015	235,993	38,546	75,293	214,288	290,823	383,263	282,835	80,403	8,649	0	0	0
Effect of exchange rate changes on cash
-3,381	-500	-1,700	-1,243	-3,866	-3,300	-3,767	-2,929	-213	0	667	6	1,564	2,145	2,099	-1,624	-1,668	-5,492	-6,810	-4,826	7,144	-2,127	-2,412	-2,430	-16,224	-4,146	-2,315	-1,437	-1,712	-1,288	-1,339	-717	-11	-140	0	0	0
Net increase (decrease) in cash, cash equivalents and restricted cash
-8,935	18,100	10,200	-2,081	2,307	-10,900	-33,058	16,343	-106	5,400	40,572	-1,675	8,285	7,195	950	740	-3,898	-27,938	-28,684	2,930	8,592	20,760	24,374	10,443	-42	15,565	-12,544	1,308	-3,587	-10,245	27,522	-2,741	-23,488	-4,948	0	0	0
SUPPLEMENTAL CASH FLOW INFORMATION:
Purchases of property and equipment, including real estate, accrued in accounts payable
-	-	-	-	8,282	-	-	-	7,538	-	6,344	5,764	913	15,900	49,415	48,230	44,959	32,720	20,951	26,241	30,545	21,166	14,094	9,955	7,425	11,155	2,808	4,057	9,584	6,045	0	0	0	-	-	-	-