ADVANCE AUTO PARTS, INC. AAP Cash Flow

Advance auto parts, inc. (AAP)

CashFlow / TTM

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
387,984	486,896	444,431	436,605	429,620	423,847	554,905	535,058	504,272	475,505	353,370	371,218	408,769	459,622	452,076	458,701	484,099	-	503,013	504,721	494,211	493,825	458,658	440,311	417,694	391,758	407,546	393,219	375,954	387,670	389,054	405,104	418,605	394,682	376,356	358,401	346,205	346,053	332,419	306,800	286,219	270,373	0	0	0
Adjustments to reconcile net income to net cash provided by operating activities:
Depreciation and amortization
247,065	238,371	234,165	233,197	236,377	238,184	240,091	242,304	243,522	249,260	251,878	254,322	256,497	258,387	261,242	262,881	265,549	-	273,574	277,850	279,735	284,693	266,351	248,426	231,973	207,795	205,836	203,089	197,772	189,544	185,236	181,503	179,209	175,949	173,476	170,477	167,293	164,437	161,502	158,282	155,445	150,917	0	0	0
Amortization of deferred debt issuance costs
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0
Share-based compensation
40,263	37,438	36,533	34,772	31,102	27,760	26,376	27,742	30,535	35,267	36,944	31,248	26,172	20,452	22,652	28,345	34,638	-	31,677	27,068	23,517	21,705	22,650	20,961	17,660	13,191	9,614	10,549	12,310	15,236	17,453	18,841	19,183	19,553	20,802	20,960	21,597	22,311	21,977	21,606	22,185	19,682	0	0	0
Loss and impairment of long-lived assets
-7,527	-6,671	-14,102	-13,496	-12,873	-15,956	-18,681	-17,502	-20,039	-17,106	-6,089	-7,958	-4,790	-5,999	-7,747	-8,257	-8,995	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Provision (benefit) for deferred income taxes
23,544	23,148	6,580	7,691	8,366	15,956	-108,522	-124,062	-136,219	-151,263	-26,629	-7,247	5,345	20,213	25,397	10,716	3,151	-	2,739	27,786	38,060	48,468	33,803	15,857	6,214	-2,237	4,694	19,474	23,350	26,893	26,065	28,601	39,222	53,037	60,351	68,583	56,495	40,503	36,135	53,120	62,559	66,622	0	0	0
Loss on property and equipment, net
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	-	-1,190	-1,737	-2,981	-2,699	-10,496	-8,792	-6,137	-5,228	-7,959	-7,437	-6,751	-6,534	5,778	5,821	4,132	8,975	0	0	0
Other
-1,523	-12,437	-12,593	-12,734	-12,871	-2,195	-2,547	-2,452	-5,494	-3,123	2,434	1,578	5,744	2,039	-3,272	-2,618	-3,848	-	-2,662	-2,661	-2,657	-2,631	-2,467	-2,223	-2,960	-1,679	-1,594	-1,593	-1,574	-1,582	-3,108	-2,440	-852	-1,098	-1,248	-1,389	-1,175	-1,106	0	0	0	-	-	-	-
Excess tax benefit from share-based compensation
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	15,080	13,784	12,820	10,487	6,850	6,888	32,456	16,320	16,400	16,984	28,514	23,099	36,629	35,128	-5,031	9,663	6,126	5,289	5,377	7,260	-4,653	-3,914	-3,305	-3,219	0	0	0
Net change in:
Receivables, net
-55,223	62,837	23,156	47,417	66,216	21,471	21,788	-13,064	-64,242	-36,047	-10,086	21,413	33,625	41,642	22,354	2,593	18,174	-	32,757	36,968	56,228	48,209	103,961	86,527	97,182	32,428	55,840	103,406	76,456	89,482	86,397	32,657	330	15,372	47,984	56,049	58,399	31,667	-22,738	-25,492	-22,952	4,643	0	0	0
Inventories
99,287	63,130	208,248	213,950	210,498	206,125	-27,729	-127,765	-192,563	-167,548	-148,032	-133,723	-12,471	144,603	216,873	297,995	318,689	-	203,001	192,789	203,460	227,657	320,136	366,888	470,303	203,513	222,473	261,112	253,356	260,298	573,898	460,514	369,751	179,288	193,783	189,091	91,442	232,003	-182,431	-181,244	-64,219	-8,779	0	0	0
Other assets
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	36,470	34,932	47,869	63,482	17,621	14,072	16,675	-11,011	-8,138	-1,731	-19,536	-8,213	-25,961	-32,752	-51,206	-23,073	20,030	16,038	11,290	13,105	-9,892	-8,718	-503	-15,694	0	0	0
Accounts payable
30,385	245,785	381,743	408,412	391,382	285,493	104,631	-24,335	-163,406	-197,168	-280,330	-284,686	-264,535	-119,325	18,352	44,868	181,986	-	98,541	132,967	160,709	216,412	332,460	301,764	179,515	113,497	195,150	272,798	327,838	376,631	239,048	167,389	162,600	360,678	330,114	304,076	388,565	325,839	295,916	390,257	275,583	174,944	0	0	0
Accrued expenses
-11,361	-72,288	-58,511	-39,546	10,424	93,940	72,920	7,586	-12,823	-13,295	1,008	89,186	49,609	49,341	26,899	30,850	15,634	-	35,136	-5,302	21,371	-28,862	22,725	1,844	33,367	63,346	34,784	59,582	24,230	40,936	45,255	17,214	-896	-15,901	-4,729	2,543	8,308	38,715	35,366	43,184	21,830	20,778	0	0	0
Other assets and liabilities, net
-38,427	-14,418	2,161	-13,227	109,219	64,707	36,267	47,652	25,127	21,325	6,052	-6,701	-2,779	-16,898	-12,497	-27,577	-41,483	-27,823	9,237	10,649	11,991	6,673	-8,170	-3,455	-8,995	-4,128	5,133	1,718	10,230	8,756	6,025	14,485	16,886	15,775	18,351	10,318	6,350	4,696	-2,666	740	7,445	10,088	0	0	0
Net cash provided by operating activities
673,275	866,909	838,071	859,221	861,600	811,028	881,303	777,424	719,694	600,805	497,276	582,212	469,938	523,303	609,588	580,268	688,879	-	688,785	719,246	730,071	708,991	687,077	555,721	491,096	545,250	578,966	583,988	585,149	685,281	722,649	770,682	791,816	828,849	680,647	640,209	600,605	666,159	667,734	761,386	744,972	699,690	0	0	0
Cash flows from investing activities:
Purchases of property and equipment
291,790	270,129	257,807	243,325	220,553	193,715	133,930	129,209	158,953	189,758	216,306	244,003	235,700	259,559	277,728	258,132	266,847	-	228,136	236,711	224,955	228,446	209,609	190,123	193,162	195,757	217,662	236,805	251,843	271,182	261,834	262,815	261,709	268,129	259,932	251,853	227,793	199,585	207,470	201,424	203,393	192,934	0	0	0
Purchase of an indefinite-lived intangible asset
0	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Business acquisitions, net of cash acquired
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	18,860	18,030	4,279	2,060,783	2,059,742	2,058,110	2,056,215	186,137	190,248	195,580	195,228	8,369	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Sale of certain assets of acquired business
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	19,042	16,798	16,798	9,004	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from sales of property and equipment
8,227	8,709	9,152	9,876	1,911	1,888	6,429	10,366	10,682	11,099	6,849	2,230	1,932	2,212	1,575	1,086	1,202	-	460	1,339	1,254	992	732	727	642	745	6,948	6,453	6,521	6,573	522	528	455	1,288	1,152	1,159	1,163	235	5,027	5,382	7,412	7,395	0	0	0
Other, net
-	-	-	-	-	-	-	-	-	-20	2,005	2,247	4,504	4,697	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net cash used in investing activities
-485,312	-462,939	-248,655	-233,449	-218,642	-191,827	-127,501	-118,843	-148,444	-178,639	-211,462	-244,020	-238,272	-262,044	-278,821	-261,934	-284,101	-	-246,536	-253,402	-227,980	-2,288,237	-2,266,375	-2,245,262	-2,238,697	-362,107	-384,164	-409,134	-431,546	-272,978	-271,607	-285,420	-284,387	-289,974	-276,950	-250,694	-226,630	-199,350	-202,443	-196,042	-195,981	-185,539	0	0	0
Cash flows from financing activities:
Decrease in bank overdrafts
-8,761	-59,339	-15,364	-29,889	-6,463	32,014	-2,645	9,844	-6,587	14,004	-9,662	-23,431	-11,727	-5,573	-17,612	854	94	-	36,308	19,878	33,643	16,219	9,105	12,019	-11	-2,926	-1,597	-2	-23	-7,459	1,653	-1,736	-5,051	6,625	-4,907	-10,891	5,083	28	4,885	12,551	-7,984	-11,060	0	0	0
Decrease in financed vendor accounts payable
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-31,648	-50,310	-43,442	-17,557	-444	-1,643	-35,237	-77,623	-104,294	0	0	0
Issuance of senior unsecured notes
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	299,904	299,904	299,904	299,904	0	0	0	0	-	-	-	-	-	-	-	-
Payment of debt related costs
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	294	2,942	2,648	2,743	6,304	3,656	0	0	0	-	-	-	-	-	-	-	-
Proceeds from borrowings on revolving credit facility
0	-	-	-	0	-	-	-	-	534,400	647,900	757,400	925,600	799,600	795,200	734,200	533,200	-	806,700	1,021,300	1,153,200	2,238,200	1,940,700	1,677,600	1,527,600	0	0	0	117,000	58,500	2,856,900	2,570,100	1,819,900	1,435,200	-1,363,200	-1,076,400	-443,200	-75,000	-75,000	-75,000	-75,000	-173,400	0	0	0
Proceeds from issuance of senior unsecured notes
0	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Redemption of senior unsecured notes
0	310,047	0	0	0	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Payments on credit facilities
-	-	-	-	-	-	-	-	-	534,400	647,900	882,900	1,081,600	959,600	1,035,200	1,008,700	903,900	-	1,249,000	1,436,300	1,615,500	1,654,800	1,258,400	862,600	508,600	0	0	0	0	173,500	429,700	682,300	1,180,700	1,320,200	1,064,000	811,400	388,000	75,000	150,000	150,000	75,000	424,900	0	0	0
Payments on note payable
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-	0	0	0
Dividends paid
30,055	17,185	17,185	17,449	17,612	17,819	17,845	17,889	17,882	17,854	17,832	17,810	17,790	17,738	17,741	17,713	17,686	-	17,661	17,629	17,612	17,580	17,572	17,559	17,555	17,574	17,573	17,593	17,612	17,596	17,599	17,595	17,637	18,554	18,565	19,196	19,849	21,051	21,058	21,695	22,328	22,803	0	0	0
Proceeds from the issuance of common stock
3,391	3,334	3,268	3,151	3,124	3,200	3,224	3,492	3,794	4,076	4,236	4,591	4,483	4,532	4,742	4,884	4,907	-	4,942	4,882	4,951	6,578	5,508	4,790	4,156	3,611	4,922	5,264	6,384	8,495	15,786	16,802	20,504	21,056	21,452	25,532	42,566	42,160	36,584	34,432	28,608	35,402	0	0	0
Payment, Tax Withholding, Share-based Payment Arrangement
-	-	-	-	-	-	0	0	917	-	10,208	13,299	14,131	19,558	17,163	16,012	16,674	-	14,085	12,571	11,556	7,102	6,014	6,085	41,884	21,856	72,876	70,782	30,535	26,677	-29,058	-27,955	-25,738	-6,582	0	0	0	-	-	-	-	-	-	-	-
Excess tax benefit from share-based compensation
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	15,080	13,784	12,820	10,487	6,850	6,888	8,514	16,320	16,400	16,984	17,684	23,099	26,431	25,568	24,357	9,663	8,394	9,231	9,143	7,260	4,653	3,914	3,305	3,219	0	0	0
Repurchases of common stock
399,905	498,435	641,253	422,335	410,421	281,354	129,600	8,852	8,601	6,498	9,473	9,517	9,701	18,393	17,145	17,110	16,888	-	6,135	6,131	6,129	5,154	2,997	5,764	21,492	80,795	80,539	77,841	81,839	27,095	27,153	127,015	355,934	631,149	773,551	694,247	613,424	622,442	528,575	543,064	389,469	100,062	0	0	0
Contingent consideration related to previous business acquisition
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-4,726	-10,882	-10,882	-6,185	-10,911	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Other, net
-5,029	-481	-866	-853	992	44	-5,691	-5,789	-7,839	-8,600	-2,162	-2,193	-2,189	-390	-409	-397	-395	-	-383	-691	-768	-890	-917	-693	-690	-627	4,301	4,239	4,193	4,089	-949	-963	-913	-938	-1,129	-1,009	-1,518	-1,271	-1,551	-1,389	-1,110	-393	0	0	0
Net cash provided by (used in) financing activities
557,881	-882,153	-981,119	-777,241	-740,334	-263,915	-146,633	-13,268	-61,501	-14,872	-45,101	-187,159	-207,055	-217,120	-315,619	-328,429	-423,840	-	-424,234	-413,478	-456,998	575,911	1,106,006	1,238,339	1,423,648	331,217	-106,884	-102,479	-109,963	127,907	-37,588	-105,488	-197,012	-540,183	-532,270	-481,513	-453,594	-507,618	-487,004	-530,917	-466,607	-451,491	0	0	0
Effect of exchange rate changes on cash
-3,336	321	-4,577	-3,061	-4,437	-5,696	-465	-294	3,307	4,465	3,095	1,370	-2,232	257	-1,000	386	-1,051	-	-2,333	-5,276	-4,630	-4,465	0	0	-413	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net increase (decrease) in cash and cash equivalents
0	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Cash and Cash Equivalents, Period Increase (Decrease)
-	-	-	-	-	349,590	606,704	645,019	513,056	411,759	243,808	152,403	22,379	44,396	14,148	-9,709	-20,113	-	15,682	47,090	40,463	-1,007,800	-477,637	-453,523	-324,366	514,360	87,918	72,375	43,640	540,210	413,454	379,774	310,417	-1,308	-128,573	-91,998	-79,619	-40,809	-21,713	34,427	82,384	62,660	0	0	0
Supplemental cash flow information:
Interest paid
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	73,320	82,803	69,346	71,109	49,510	45,601	39,693	34,735	34,125	34,064	34,106	27,250	28,745	26,491	29,802	35,030	25,593	23,688	14,720	15,782	16,157	18,108	17,859	18,935	0	0	0
Income tax payments
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	230,847	240,446	242,504	268,624	269,604	266,638	248,899	219,424	228,328	180,117	178,429	162,677	163,295	193,634	186,179	170,541	142,885	134,874	162,664	164,987	164,219	144,227	131,829	126,391	0	0	0
Non-cash transactions:
Accrued purchases of property and equipment
37,087	26,201	34,630	36,358	20,968	15,365	17,541	13,205	8,402	14,335	8,736	8,858	15,196	21,176	46,988	53,478	50,569	-	24,426	25,585	32,107	28,877	25,817	24,195	16,814	20,714	19,101	10,024	21,054	26,142	37,174	48,502	38,277	35,648	0	0	0	-	-	-	-	-	-	-	-
Retirement of common stock
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	1,644,767	1,644,767	1,644,767	1,644,767	0	0	0	0	-	-	-	-	-	-	-	-
Accrued purchase price of business acquisition
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Receivable for sale of certain assets of acquired business
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-
Changes in other comprehensive income from post retirement benefits
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-737	-741	-746	-752	0	0	935	-	-	-	-	-	-	-	-	-	-	-	0	-	5,866	3,569	2,314	2,650	0	0	0
Total other comprehensive income (loss)
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Repurchases of common stock not settled
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-	-	-	0	-	-	-	-