XL GROUP LTD XL Cash Flow

Xl group ltd (XL)

CashFlow / Quarterly

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	Dec'10	Sep'10	Jun'10	Mar'10
Cash flows provided by (used in) operating activities:
Net Income (Loss), Including Portion Attributable to Noncontrolling Interest
336,800	161,233	59,857	-1,073,886	310,043	213,849	309,614	128,677	48,826	83,028	234,579	85,171	919,918	73,671	142,973	109,967	-275,578	291,476	303,567	170,670	275,878	386,532	84,843	207,746	224,609	213,185	-514,091	76,391	227,765	-193,948	195,528	110,049	193,925	143,879
Adjustments to reconcile net income (loss) to net cash provided by (used in) operating activities:
Marketable Securities, Gain (Loss)
90,805	-83,355	84,688	43,274	56,628	37,286	31,095	143,676	104,617	92,750	-	-	-	-	11,195	4,341	72,697	19,229	12,258	-1,958	40,968	36,509	11,182	-5,493	-12,394	20,803	-50,024	-62,354	-9,544	-66,437	-104,486	-68,755	-61,386	-36,176
Derivative, Gain (Loss) on Derivative, Net
16,126	4,221	-13,323	-20,434	-906	-7,069	-253	5,490	906	-3,622	-4,004	-7,903	48,509	16,521	11,346	5,131	11,599	1,810	4,138	880	-5,105	7,885	2,565	6,254	-4,300	702	23,561	-26,916	-10,950	3,567	-5,940	12,473	-19,896	-20,480
Amortization of premiums (discounts) on fixed maturities
-28,602	-32,298	-37,717	-38,923	-41,373	-42,178	-49,627	-52,979	-43,371	-47,505	-51,706	-65,784	-41,336	-35,998	-35,828	-41,175	-37,358	-39,488	-39,097	-43,429	-46,312	-37,783	-49,534	-44,579	-38,562	-36,678	-36,878	-40,313	-23,078	-19,861	-21,515	-18,958	-10,292	-10,104
(Income) loss from investment and operating affiliates
56,251	39,800	-12,928	41,337	65,157	28,921	41,887	18,729	26,983	-19,797	-26,730	-5,455	32,790	45,467	22,256	39,367	36,293	31,999	57,130	29,669	79,368	63,219	34,363	18,812	23,555	35,661	-22,677	28,429	56,501	40,786	95,453	17,140	40,097	19,784
Loss (gain) sale of subsidiaries
-	-	-	-	-	-	-	-	-	-	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Gain on sale of operating affiliate
-	-	-	-	-	-	-	-	-	-	0	0	340,407	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Share-based compensation
16,462	15,448	14,654	19,586	17,265	12,694	20,487	17,288	22,519	20,707	16,736	18,054	21,346	18,295	15,983	24,741	24,589	15,974	1,042	17,047	13,314	15,086	5,645	14,032	16,623	11,172	9,182	9,171	10,716	12,156	20,885	7,586	9,306	6,280
Depreciation and amortization
22,435	22,481	42,929	17,542	17,138	19,429	32,049	27,371	36,051	22,592	41,651	21,313	18,442	10,907	12,607	14,404	14,146	14,961	12,082	20,454	10,584	13,109	15,545	14,256	13,620	13,859	13,256	12,296	12,279	11,969	11,324	10,764	8,277	10,058
Accretion of convertible debt
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	251	251	249
Accretion of deposit liabilities
5,596	11,125	12,241	-3,011	8,583	11,430	10,851	8,317	12,761	12,055	11,535	11,211	10,843	10,044	8,059	10,898	-18,239	10,477	10,477	11,312	12,903	12,564	15,684	15,733	33,406	16,446	19,307	23,211	23,394	16,887	23,218	29,864	29,369	21,860
Changes in:
Unpaid losses and loss expenses
70,611	-240,207	-359,792	2,897,375	52,988	290,788	252,375	169,702	321,076	330,160	-228,000	182,176	-243,839	77,832	-556,447	-135,885	192,746	72,058	-174,107	-208,456	176,066	117,861	-321,203	77,672	86,544	444,959	-58,017	-117,935	-37,278	-29,810	137,221	-69,666	192,348	-52,377
Future policy benefit reserves
-99,996	-51,981	-72,513	-41,733	-65,448	-55,634	-5,292	-38,674	-58,272	-59,858	-70,532	-85,444	-73,563	-49,279	-56,970	-79,032	-43,422	-49,780	-36,642	-38,134	-42,033	-48,114	-54,566	-44,155	-51,114	-37,565	-70,571	-39,900	-36,158	-24,989	-60,237	-12,528	-48,560	-76,245
Funds withheld on GreyCastle life retrocession arrangements, net
-175,766	-24,578	-5,719	-56,367	-111,454	-107,596	-19,533	-70,144	-12,567	-121,272	2,806	-57,338	13,158	-169,569	-221,112	55,072	-52,104	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Unearned premiums
66,088	1,310,888	-52,331	-596,083	159,026	1,222,570	-295,357	-542,076	125,390	1,148,149	-753,999	-642,459	212,511	655,733	-270,997	-324,544	227,928	621,009	-420,970	-265,206	114,580	636,875	-341,378	-194,409	63,334	655,416	-520,306	-6,966	98,334	524,331	-337,120	-118,268	-13,453	334,886
Premiums receivable
291,703	979,464	-163,924	84,353	127,484	1,152,760	-210,504	-540,847	513,698	1,322,085	-490,705	-625,234	441,890	517,881	-277,683	-530,153	198,345	594,243	-314,186	-438,217	150,209	629,528	-252,531	-359,653	166,695	573,122	-416,847	-204,070	176,003	476,200	-103,833	-290,935	-72,711	372,830
Unpaid losses and loss expenses recoverable
-90,887	36,804	-270,703	-1,047,280	-104,201	-153,063	-104,596	-66,251	-106,647	-82,729	-92,701	-91,415	-106,470	-148,962	186,182	-367,628	108,011	28,747	-65,463	-66,480	92,073	2,973	660,373	-54,269	-54,469	-245,960	-26,926	82,148	54,975	-112,365	47,232	88,742	-61,504	-228
Ceded unearned premiums
-79,498	730,516	-117,487	-282,858	33,367	797,191	-193,385	-253,610	-59,866	436,332	-253,189	-327,219	197,342	146,049	-60,743	-86,870	228,545	110,310	13,476	-39,269	157,276	65,191	-136,714	-32,001	106,591	47,201	-254,680	49,138	99,763	84,247	5,353	6,484	-102,941	7,858
Reinsurance balances receivable
-113,340	-272,531	150,578	-314,030	-104,958	-59,052	-62,888	38,260	-99,717	-49,781	3,237	-57,743	46,768	10,057	31,726	-21,192	31,954	-60,224	-21,705	9,808	-7,186	-41,234	157,134	187	-33,360	38,319	-58,708	46,958	-43,153	5,617	-23,986	-45,405	-88,987	-43,101
Deferred acquisition costs and value of business acquired
-129,025	205,798	27,770	-83,431	-31,603	205,830	-25,335	-60,957	-7,155	156,373	-166,542	-65,315	33,062	72,340	-60,607	-26,938	-273,390	56,937	-56,391	-27,027	4,339	70,547	-46,980	-13,272	-20,891	81,792	-50,978	13,799	16,426	62,634	-41,497	7,556	23,831	-2,125
Reinsurance balances payable
-259,264	695,220	-20,028	234,756	56,287	849,492	-188,944	-210,810	337,510	460,982	-160,289	-175,727	480,960	84,261	-104,078	-155,908	151,185	269,717	-177,637	-139,243	348,759	129,253	-365,499	-13,915	183,877	243,696	-443,949	133,029	59,026	220,048	-190,524	-27,907	-83,228	48,446
Deferred tax asset - net
2,205	-25,190	41,101	27,455	1,794	-10,852	30,626	-13,109	16,179	7,945	9,305	68,903	-16,165	-14,119	-8,407	-9,429	50,973	598	25,537	-5,783	-8,089	17,565	52,614	-1,730	-13,085	-9,243	-4,220	-3,494	8,341	42,956	-51,475	-1,628	-21,174	-29,834
Derivatives
-36,259	-8,162	-6,773	47,330	36,403	-58,104	-73,569	5,213	-32,819	-17,863	-21,637	-53,918	32,009	-141,754	-48,449	-39,044	33,029	12,277	36,887	53,882	-15,770	-52,675	42,315	-21,184	-46,291	17,908	-123,828	-16,587	99,859	-53,240	174,253	-65,951	-151,261	-80,068
Other assets
-20,502	42,006	-127,812	64,082	17,356	100,791	-70,298	-21,294	71,181	47,084	-47,724	-32,690	31,953	31,407	-77,811	28,989	-10,253	25,731	-54,203	22,419	34,532	24,197	-74,221	77,271	18,460	-42,434	-43,104	106,309	-42,299	3,841	-26,976	150,751	-34,315	-20,947
Other liabilities
50,522	-51,327	-15,397	36,113	-128,553	-128,606	-36,052	24,142	90,809	-128,752	112,981	99,099	35,287	-94,545	6,757	132,236	-209,700	-77,037	20,686	100,176	-37,479	-23,052	-57,725	90,678	62,911	-45,522	11,889	-9,913	8,544	-103,843	-3,240	126,142	-21,397	-133,651
Other
75,670	-25,022	50,332	-83,297	-48,550	9,323	11,193	-5,151	17,888	41,618	23,400	7,250	-39,767	-17,851	11,505	17,548	-14,048	-20,452	9,635	-15,543	-98	-3,696	-2,830	31,367	38,547	-8,835	-7,530	84,017	14,342	-38,859	173,081	41,176	-88,309	-43,909
Total adjustments
-710,293	-399,357	-210,352	1,379,642	-384,488	-261,346	-43,490	353,904	290,414	-227,067	-99,598	403,825	-934,392	-38,693	92,186	264,429	429,139	-91,408	-376,479	322,566	-61,869	-240,888	77,083	202,838	105,617	-59,815	475,776	181,799	-183,773	257,283	-430,048	348,200	-29,719	62,942
Net Cash Provided by (Used in) Operating Activities, Continuing Operations
-373,493	-238,124	-150,495	305,756	-74,445	-47,497	266,124	482,581	339,240	-144,039	134,981	488,996	-14,474	34,978	235,159	374,396	153,561	200,068	-72,912	493,236	214,009	145,644	161,926	410,584	330,226	153,370	-38,315	258,190	43,992	63,335	-234,520	458,249	164,206	206,821
Cash flows provided by (used in) investing activities:
Proceeds from sale of fixed maturities and short-term investments
3,062,109	4,369,199	4,347,750	4,966,766	3,895,605	2,492,005	3,176,337	2,131,288	3,677,878	3,772,077	6,299,520	4,216,582	4,878,185	1,473,941	847,879	1,004,574	1,936,733	1,106,926	1,299,081	932,234	911,723	1,198,391	1,147,903	484,547	472,510	1,499,832	1,857,434	744,236	1,367,523	1,122,182	1,399,641	1,420,366	1,111,013	1,275,670
Proceeds from redemption of fixed maturities and short-term investments
738,787	701,404	675,981	710,333	855,826	1,228,356	837,551	921,841	1,139,096	949,221	963,304	849,248	884,883	1,053,739	920,792	843,682	780,961	1,056,358	865,595	876,046	1,092,591	1,174,101	1,367,025	932,228	1,033,967	1,246,431	895,510	1,374,514	636,768	689,130	737,532	675,558	767,771	670,954
Proceeds from sale of equity securities
5,352	78,716	300,660	227,975	182,535	46,379	437,449	296,372	52,063	62,895	220,794	172,574	81,894	189,473	201,221	74,741	219,066	76,382	150,455	20,773	36,864	37,446	9,583	88,853	115,546	7,635	15,918	32,091	87,378	70,349	48,946	29,549	34,849	2,495
Purchases of fixed maturities and short term investments
3,864,656	4,917,191	4,825,451	5,737,322	5,086,017	3,633,007	3,900,644	3,200,937	4,030,429	4,325,679	6,997,127	4,678,741	5,206,892	2,835,304	1,541,266	1,815,883	2,389,662	1,411,447	2,663,605	2,372,188	1,846,158	2,262,022	3,028,215	1,780,717	707,966	3,385,981	2,118,076	1,884,277	2,339,214	1,188,395	2,571,371	1,676,847	1,510,303	2,340,341
Purchases of equity securities
11,724	33,230	11,858	37,423	229,362	47,967	492,361	355,644	200,031	55,411	130,712	197,087	145,394	94,141	119,185	86,639	158,847	80,833	175,872	26,619	122,072	209,793	72,468	91,900	78,601	119,052	60,138	189,113	133,472	248,446	86,334	30,603	29,899	11,127
Proceeds from sale of affiliates
57,859	244,340	217,911	138,767	68,624	168,237	72,041	171,122	112,390	41,538	24,193	638,226	8,240	77,916	8,883	75,421	11,307	145,174	-4,002	98,968	50,009	45,979	-	-	-	-	-	-	-	-	-	-	-	-
Purchases of affiliates
27,208	76,014	56,199	67,944	15,965	35,926	124,837	147,662	161,837	247,049	186,111	61,447	4,261	29,037	77,252	97,487	110,282	86,205	63,962	30,086	151,264	108,366	-	-	-	-	-	-	-	-	-	-	-	-
Purchase of subsidiaries, net of acquired cash
-	-	-	-	-	-	0	23,148	0	69,745	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Change in restricted cash
-	-	-	-	-	-	3,386	-31,740	20,839	6,027	7,182	12,172	135,638	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Investment affiliates, net
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	19,978	4,079	34,358	-	155,266	-39,486	51,170	88,805	56,124	87,351	86,828
Other, net
3,203	26,782	35,403	42,274	18,302	-23,429	-4,144	-85,297	-25,954	-82,141	16,851	50,652	55,375	32,141	35,241	62,028	-9,853	106,075	35,684	26,558	11,638	-121,771	-34,437	-14,743	82,948	45,333	-3,422	48,379	-4,774	-4,103	-20,605	-12,977	70,477	-61,749
Net Cash Provided by (Used in) Investing Activities, Continuing Operations
-42,684	340,442	615,521	152,755	-347,056	241,506	10,148	-70,587	594,245	203,961	169,828	315,979	-153,821	-195,554	205,831	-63,619	869,129	700,280	-627,994	-527,430	-39,945	-2,493	-604,802	-332,268	756,587	-762,110	563,401	184,338	-415,729	500,093	-362,176	487,124	390,305	-253,772
Cash flows provided by (used in) financing activities:
Proceeds from issuance of ordinary shares and exercise of stock options
14,351	46,504	994	7,010	19,334	23,296	4,119	4,008	1,236	491	2,072	3,077	3,055	1,772	956	2,354	1,747	1,310	2,905	1,333	5,137	3,248	762	3,437	272	942	575,137	107	1,089	0	-	-	-	-
Buybacks of common shares
394	1,663	28	120,957	250,141	200,488	144,913	221,751	328,485	355,901	176,702	179,884	110,419	1,966	175,179	275,120	175,158	176,496	150,097	150,097	151,003	224,420	51,772	125,180	125,488	100,490	100,082	308,037	92,401	166,502	251,209	268,975	0	1,840
Repurchase of preference shares
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	94,157
Employee withholding on share-based compensation
0	16,696	33	199	1,086	22,871	398	224	873	27,074	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Dividends paid on common shares
113,726	0	56,327	56,316	57,197	58,392	53,415	55,615	55,870	57,861	59,486	59,977	48,131	40,922	40,130	42,434	43,209	43,847	39,024	79,156	41,170	805	33,046	33,438	67,097	1,218	-	-	-	-	31,982	33,368	34,204	34,194
Dividends paid on preference ordinary shares
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	34,021	118	2,194	32,500	5,573
Distributions to non-controlling interests
29,148	15,946	15,092	35,505	48,308	25,400	36,977	27,788	37,825	27,857	37,042	27,185	46,284	7,172	37,002	2,961	35,494	3,008	35,644	3,006	35,763	3,257	35,704	3,353	35,945	3,985	32,903	2,981	33,312	2,287	-	-	-	-
Contributions from non-controlling interests
1,485	439	10,109	49,449	-1	26	41,130	5,264	247	883	13,318	5,634	2,089	2,569	23,422	3,345	14,493	7,001	7,247	500	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from the issuance of debt
-	-	-	-	-	-	-	-	-	-	0	0	0	980,600	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Contingent consideration paid on business combination
0	5,000	-	-	7,304	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Repayment of debt
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	600,000	575,000	0	0	0	-	-	-	-
Deposit liabilities
47,989	71,124	158	23,257	3,379	7,771	5,994	48,681	6,261	8,546	4,814	30,556	10,600	38,788	1,756	52,673	196,599	17,270	6,598	43,671	5,413	38,704	20,574	57,466	26,473	30,437	36,145	63,907	25,917	26,648	23,307	559,392	16,121	47,999
Net Cash Provided by (Used in) Financing Activities, Continuing Operations
-175,421	-63,486	-60,535	-601,872	210,229	-291,600	-196,448	-344,787	-436,079	-475,865	-379,026	-288,891	-210,290	896,093	-229,689	-967,489	-434,220	-232,310	371,404	-274,097	-228,212	-263,938	-140,334	-216,000	-253,231	-735,188	141,277	-85,942	-184,593	-229,458	-343,616	-863,139	-82,825	-183,763
Effects of exchange rate changes on foreign currency cash
-17,621	7,503	1,375	11,901	13,150	30,273	-46,113	9,321	-1,554	-19,396	-9,617	-16,855	9,492	-47,397	-43,221	-60,693	6,622	7,177	-559	19,102	943	-24,304	4,283	23,843	-28,754	25,121	-17,521	-39,645	29,867	28,967	5,551	74,201	-46,011	-37,464
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents, Period Increase (Decrease), Including Exchange Rate Effect
-609,219	46,335	405,866	-131,460	-198,122	-67,318	33,711	76,528	495,852	-435,339	-83,834	499,229	-369,093	688,120	168,080	-717,405	595,092	675,215	-330,061	-289,189	-53,205	-145,091	-578,927	-113,841	804,828	-1,318,807	648,842	316,941	-526,463	362,937	-934,761	156,435	425,675	-268,178
Life Funds Withheld Assets
Derivative, Gain (Loss) on Derivative, Net
-36,120	22,921	-89,656	-31,662	-34,596	-50,101	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-