ADVANCE AUTO PARTS, INC. AAP Cash Flow

Advance auto parts, inc. (AAP)

CashFlow / Quarterly

Apr'20	Dec'19	Oct'19	Jul'19	Apr'19	Dec'18	Sep'18	Jun'18	Apr'18	Dec'17	Sep'17	Jun'17	Apr'17	Dec'16	Sep'16	Jul'16	Apr'16	Jan'16	Sep'15	Jul'15	Apr'15	Dec'14	Sep'14	Jul'14	Apr'14	Dec'13	Sep'13	Jul'13	Apr'13	Dec'12	Sep'12	Jul'12	Apr'12	Dec'11	Sep'11	Jul'11	Apr'11	Dec'10	Sep'10	Jul'10	Apr'10	Dec'09	Sep'09	Jul'09	Apr'09
Cash flows from operating activities:
Net income
43,588	95,907	123,669	124,820	142,500	53,442	115,843	117,835	136,727	184,500	95,996	87,049	107,960	62,365	113,844	124,600	158,813	-	120,469	149,998	148,112	84,434	122,177	139,488	147,726	49,267	103,830	116,871	121,790	65,055	89,503	99,606	133,506	66,439	105,553	113,107	109,583	48,113	87,598	100,911	109,431	34,479	61,979	80,330	93,585
Adjustments to reconcile net income to net cash provided by operating activities:
Depreciation and amortization
78,579	58,806	56,308	53,372	69,885	54,600	55,340	56,552	71,692	56,507	57,553	57,770	77,430	59,125	59,997	59,945	79,320	-	61,636	62,613	83,247	66,078	65,912	64,498	88,205	47,736	47,987	48,045	64,027	45,777	45,240	42,728	55,799	41,469	41,507	40,434	52,539	38,996	38,508	37,250	49,683	36,061	35,288	34,413	45,155
Amortization of deferred debt issuance costs
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	111
Share-based compensation
13,809	9,400	8,613	8,441	10,984	8,495	6,852	4,771	7,642	7,111	8,218	7,564	12,374	8,788	2,522	2,488	6,654	-	8,215	8,781	8,945	5,736	3,606	5,230	7,133	6,681	1,917	1,929	2,664	3,104	2,852	3,690	5,590	5,321	4,240	4,032	5,960	6,570	4,398	4,669	6,674	6,236	4,027	5,248	4,171
Loss and impairment of long-lived assets
-981	-2,258	-2,116	-2,172	-125	-9,689	-1,510	-1,549	-3,208	-12,414	-331	-4,086	-275	-1,397	-2,200	-918	-1,484	-	-2,710	-1,656	-5,371	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Provision (benefit) for deferred income taxes
146	15,495	4,723	3,180	-250	-1,073	5,834	3,855	7,340	-125,551	-9,706	-8,302	-7,704	-917	9,676	4,290	7,164	-	-5,005	-3,275	-5,206	16,225	20,042	6,999	5,202	1,560	2,096	-2,644	-3,249	8,491	16,876	1,232	294	7,663	19,412	11,853	14,109	14,977	27,644	-235	-1,883	10,609	44,629	9,204	2,180
Loss on property and equipment, net
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-534	-455	-	21	-523	100	-788	-526	-1,767	382	-8,585	1,178	888	1,291	-11,316	1,700	1,574	1,508	996	1,743	-115	6,351
Other
-434	-353	-365	-371	-11,348	-509	-506	-508	-672	-861	-411	-3,550	1,699	4,696	-1,267	616	-2,006	-	-613	-614	-818	-617	-612	-610	-792	-453	-368	-1,347	489	-368	-367	-1,328	481	-1,894	301	260	235	-2,044	160	474	304	-	-	-	-
Excess tax benefit from share-based compensation
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	1,856	1,937	6,498	4,789	560	973	4,165	1,152	598	26,541	-11,971	1,232	1,182	38,071	-17,386	14,762	-319	-2,088	-2,692	11,225	-1,156	-2,000	-809	-688	-417	-1,391	-723
Net change in:
Receivables, net
-59,303	-32,443	9,339	27,184	58,757	-72,124	33,600	45,983	14,012	-71,807	-1,252	-5,195	42,207	-45,846	30,247	7,017	50,224	-	10,486	22,598	53,526	-53,853	14,697	41,858	45,507	1,899	-2,737	52,513	-19,247	25,311	44,829	25,563	-6,221	22,226	-8,911	-6,764	8,821	54,838	-846	-4,414	-17,911	433	-3,600	-1,874	9,684
Inventories
104,899	38,145	19,300	-63,057	68,742	183,263	25,002	-66,509	64,369	-50,591	-75,034	-131,307	89,384	-31,075	-60,725	-10,055	246,458	-	20,397	10,639	171,865	100	10,185	21,310	196,062	92,579	56,937	124,725	-70,728	111,539	95,576	116,969	-63,786	425,139	-17,808	26,206	-254,249	439,634	-22,500	-71,443	-113,688	25,200	-21,313	45,582	-58,248
Other assets
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	6,024	9,653	845	19,948	4,486	22,590	16,458	-25,913	937	25,193	-11,228	-23,040	7,344	7,388	95	-40,788	553	-11,066	28,228	2,315	-3,439	-15,814	30,043	-20,682	-2,265	-7,599	14,852
Accounts payable
-112,459	17,963	85,820	39,061	102,941	153,921	112,489	22,031	-2,948	-26,941	-16,477	-117,040	-36,710	-110,103	-20,833	-96,889	108,500	-	5,683	40,229	45,678	6,951	40,109	67,971	101,381	122,999	9,413	-54,278	35,363	204,652	87,061	762	84,156	67,069	15,402	-4,027	282,234	36,505	-10,636	80,462	219,508	6,582	83,705	-34,212	118,869
Accrued expenses
-1,824	-42,616	-8,400	41,479	-62,751	-28,839	10,565	91,449	20,765	-49,859	-54,769	71,040	20,293	-35,556	33,409	31,463	20,025	-	37,360	16,247	39,494	-57,965	-3,078	42,920	-10,739	-6,378	-23,959	74,443	19,240	-34,940	839	39,091	35,946	-30,621	-27,202	20,981	20,941	-19,449	-19,930	26,746	51,348	-22,798	-12,112	5,392	50,296
Other assets and liabilities, net
33,250	-6,499	28,190	-93,368	57,259	10,080	12,802	29,078	12,747	-18,360	24,187	6,553	8,945	-33,633	11,434	10,475	-5,174	-29,232	-3,646	-3,431	8,486	7,828	-2,234	-2,089	3,168	-7,015	2,481	-7,629	8,035	2,246	-934	883	6,561	-485	7,526	3,284	5,450	2,091	-507	-684	3,796	-5,271	2,899	6,021	6,439
Net cash provided by operating activities
10,908	158,363	216,385	287,619	204,542	129,525	237,535	289,998	153,970	199,800	133,656	232,268	35,081	96,271	218,592	119,994	88,446	-	189,272	228,605	102,211	168,697	219,733	239,430	81,131	146,783	88,377	174,805	135,285	180,499	93,399	175,966	235,417	217,867	141,432	197,100	272,450	69,665	100,994	157,496	338,004	71,240	194,646	141,082	292,722
Cash flows from investing activities:
Purchases of property and equipment
82,973	100,905	57,799	50,113	61,312	88,583	43,317	27,341	34,474	28,798	38,596	57,085	65,279	55,346	66,293	48,782	89,138	-	46,697	57,497	57,038	66,904	55,272	45,741	60,529	48,067	35,786	48,780	63,124	69,972	54,929	63,818	82,463	60,624	55,910	62,712	88,883	52,427	47,831	38,652	60,675	60,312	41,785	40,621	50,216
Purchase of an indefinite-lived intangible asset
230	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Business acquisitions, net of cash acquired
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	2,462	15,998	433	-33	1,632	2,247	2,056,937	-1,074	0	352	186,859	3,037	5,332	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Sale of certain assets of acquired business
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	2,244	0	7,794	9,004	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from sales of property and equipment
71	-5	148	8,013	553	438	872	48	530	4,979	4,809	364	947	729	190	66	1,227	-	-299	182	295	282	580	97	33	22	575	12	136	6,225	80	80	188	174	86	7	1,021	38	93	11	93	4,830	448	2,041	76
Other, net
-	-	-	-	-	-	-	-	-	0	0	173	-193	2,025	242	2,430	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net cash used in investing activities
-83,132	-302,429	-57,651	-42,100	-60,759	-88,145	-42,445	-27,293	-33,944	-23,819	-33,787	-56,894	-64,139	-56,642	-66,345	-51,146	-87,911	-	-49,458	-73,313	-57,176	-66,589	-56,324	-47,891	-2,117,433	-44,727	-35,211	-41,326	-240,843	-66,784	-60,181	-63,738	-82,275	-65,413	-73,994	-62,705	-87,862	-52,389	-47,738	-38,641	-60,582	-55,482	-41,337	-38,580	-50,140
Cash flows from financing activities:
Decrease in bank overdrafts
0	12	10,914	-19,687	-50,578	43,987	-3,611	3,739	-12,101	9,328	8,878	-12,692	8,490	-14,338	-4,891	-988	14,644	-	13,575	-1,748	11,628	12,853	-2,855	12,017	-5,796	5,739	59	-13	-8,711	7,068	1,654	-34	-16,147	16,180	-1,735	-3,349	-4,471	4,648	-7,719	12,625	-9,526	9,505	-53	-7,910	-12,602
Decrease in financed vendor accounts payable
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	-31,648	-18,662	6,868	25,885	-14,535	-19,861	-26,726	-16,501	-41,206
Issuance of senior unsecured notes
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	0	299,904	0	0	0	0	-	-	-	-	-	-	-	-
Payment of debt related costs
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	294	0	0	2,648	0	95	3,561	0	-	-	-	-	-	-	-	-
Proceeds from borrowings on revolving credit facility
500,000	-	-	-	0	-	-	-	-	0	0	50,900	483,500	113,500	109,500	219,100	357,500	-	48,500	18,100	442,600	297,500	263,100	150,000	1,527,600	0	0	0	0	0	0	117,000	-58,500	2,798,400	-286,800	-633,200	-443,200	0	0	0	-75,000	0	0	0	-173,400
Proceeds from issuance of senior unsecured notes
498,240	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Redemption of senior unsecured notes
0	0	0	0	310,047	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Payments on credit facilities
-	-	-	-	-	-	-	-	-	0	0	80,900	453,500	113,500	235,000	279,600	331,500	-	208,500	174,800	469,300	396,400	395,800	354,000	508,600	0	0	0	0	0	0	0	173,500	256,200	252,600	498,400	313,000	0	0	75,000	0	75,000	0	0	349,900
Payments on note payable
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	232	-	172	114	226
Dividends paid
21,593	0	4,157	4,305	8,723	0	4,421	4,468	8,930	26	4,465	4,461	8,902	4	4,443	4,441	8,850	-	4,415	4,414	8,813	19	4,383	4,397	8,781	11	4,370	4,393	8,800	10	4,390	4,412	8,784	13	4,386	4,454	9,701	24	5,017	5,107	10,903	31	5,654	5,740	11,378
Proceeds from the issuance of common stock
735	976	710	970	678	910	593	943	754	934	861	1,245	1,036	1,094	1,216	1,137	1,085	-	1,358	1,160	1,352	1,072	1,298	1,229	2,979	2	580	595	2,434	1,313	922	1,715	4,545	8,604	1,938	5,417	5,097	9,000	6,018	22,451	4,691	3,424	3,866	16,627	11,485
Payment, Tax Withholding, Share-based Payment Arrangement
-	-	-	-	-	-	186	211	93	-	184	523	5,707	3,794	3,275	1,355	11,134	-	2,124	2,017	7,572	2,372	610	1,002	3,118	1,284	681	36,801	-16,910	52,304	-1,413	-3,446	-20,768	-3,431	-310	-1,229	-1,612	-	-	-	-	-	-	-	-
Excess tax benefit from share-based compensation
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	1,856	1,937	6,498	4,789	560	973	4,165	1,152	598	2,599	11,971	1,232	1,182	3,299	17,386	4,564	319	2,088	2,692	3,295	1,156	2,000	809	688	417	1,391	723
Repurchases of common stock
35,761	12,054	339,743	12,347	134,291	154,872	120,825	433	5,224	3,118	77	182	3,121	6,093	121	366	11,813	-	86	144	1,590	4,315	82	142	615	2,158	2,849	15,870	59,918	1,902	151	19,868	5,174	1,960	100,013	248,787	280,389	144,362	20,709	167,964	289,407	50,495	35,198	14,369	0
Contingent consideration related to previous business acquisition
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	-9,452	4,726	-6,156	0	-4,755	0	-	-	-	-	-	-	-	-	-	-	-	-
Other, net
-4,763	-385	17	102	-215	-770	30	1,947	-1,163	-6,505	-68	-103	-1,924	-67	-99	-99	-125	-	-87	-97	-110	-89	-395	-174	-232	-116	-171	-171	-169	4,812	-233	-217	-273	-226	-247	-167	-298	-417	-127	-676	-51	-697	35	-397	666
Net cash provided by (used in) financing activities
936,858	-11,289	-332,298	-35,390	-503,176	-110,255	-128,420	1,517	-26,757	7,027	4,945	-46,716	19,872	-23,202	-137,113	-66,612	9,807	-	-149,923	-162,023	-25,307	-86,981	-139,167	-205,543	1,007,602	443,114	-6,834	-20,234	-84,829	5,013	-2,429	-27,718	153,041	-160,482	-70,329	-119,242	-190,130	-152,569	-19,572	-91,323	-244,154	-131,955	-63,485	-27,013	-229,038
Effect of exchange rate changes on cash
-3,461	294	-429	260	196	-4,604	1,087	-1,116	-1,063	627	1,258	2,485	95	-743	-467	-1,117	2,584	-	919	-2,554	-578	-120	-2,024	-1,908	-413	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net increase (decrease) in cash and cash equivalents
861,173	-	-	-	-359,197	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Cash and Cash Equivalents, Period Increase (Decrease)
-	-	-	-	-	-73,479	67,757	263,106	92,206	183,635	106,072	131,143	-9,091	15,684	14,667	1,119	12,926	-	-9,190	-9,285	19,150	15,007	22,218	-15,912	-1,029,113	545,170	46,332	113,245	-190,387	118,728	30,789	84,510	306,183	-8,028	-2,891	15,153	-5,542	-135,293	33,684	27,532	33,268	-116,197	89,824	75,489	13,544
Supplemental cash flow information:
Interest paid
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	2,038	28,847	11,592	30,843	11,521	15,390	13,355	9,244	7,612	9,482	8,397	8,634	7,551	9,524	1,541	10,129	5,297	12,835	6,769	692	3,392	3,867	7,831	1,067	5,343	3,618	8,907
Income tax payments
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	76,299	59,856	48,930	45,762	85,898	61,914	75,050	46,742	82,932	44,175	45,575	55,646	34,721	42,487	29,823	56,264	65,060	35,032	14,185	28,608	57,049	62,822	16,508	27,840	37,057	50,424	11,070
Non-cash transactions:
Accrued purchases of property and equipment
25,080	-4,130	263	15,874	14,194	4,299	1,991	484	8,591	6,475	-2,345	-4,319	14,524	876	-2,223	2,019	20,504	-	4,267	-890	13,973	7,076	5,426	5,632	10,743	4,016	3,804	-1,749	14,643	2,403	-5,273	9,281	19,731	13,435	6,055	-944	17,102	-	-	-	-	-	-	-	-
Retirement of common stock
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	0	1,644,767	0	0	0	0	-	-	-	-	-	-	-	-
Accrued purchase price of business acquisition
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	2,057	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Receivable for sale of certain assets of acquired business
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-150	-6,570	7,794	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-
Changes in other comprehensive income from post retirement benefits
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-134	-134	-178	-291	-138	-139	-184	-	-	-	-	-	-	-	-	-	-	-	1,976	-	2,385	1,765	469	1,247	88	510	805
Total other comprehensive income (loss)
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	2,224	-	-113	-113	105	-	-	-	-	-	-	-	-	-	-	-	-
Repurchases of common stock not settled
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	8,991	-	-	-	0	-	-	-	-