XL GROUP LTD XL Cash Flow

Xl group ltd (XL)
CashFlow / TTM

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
-515	-542	-490	-240	962	700	570	495	451	1,322	1,313	1,221	1,246	51	268	429	490	1,041	1,136	917	954	903	730	131	0	3	-403	305	339	305	643	0	0	0
Adjustments to reconcile net income (loss) to net cash provided by (used in) operating activities:
Marketable Securities, Gain (Loss)
135	101	221	168	268	316	372	0	0	0	-	-	-	-	107	108	102	70	87	86	83	29	14	-47	-103	-101	-188	-242	-249	-301	-270	0	0	0
Derivative, Gain (Loss) on Derivative, Net
-13	-30	-41	-28	-2	-0	2	-1	-14	32	53	68	81	44	29	22	18	1	7	6	11	12	5	26	-6	-13	-10	-40	-0	-9	-33	0	0	0
Amortization of premiums (discounts) on fixed maturities
-137	-150	-160	-172	-186	-188	-193	-195	-208	-206	-194	-178	-154	-150	-153	-157	-159	-168	-166	-177	-178	-170	-169	-156	-152	-136	-120	-104	-83	-70	-60	0	0	0
(Income) loss from investment and operating affiliates
124	133	122	177	154	116	67	-0	-24	-19	46	95	139	143	129	164	155	198	229	206	195	139	112	55	64	97	103	221	209	193	172	0	0	0
Loss (gain) sale of subsidiaries
-	-	-	-	-	-	-	-	-	-	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Gain on sale of operating affiliate
-	-	-	-	-	-	-	-	-	-	340	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Share-based compensation
66	66	64	70	67	72	81	77	78	76	74	73	80	83	81	66	58	47	46	51	48	51	47	51	46	40	41	52	51	49	44	0	0	0
Depreciation and amortization
105	100	97	86	95	114	118	127	121	103	92	63	56	52	56	55	61	58	56	59	53	56	57	54	53	51	49	47	46	42	40	0	0	0
Accretion of convertible debt
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0
Accretion of deposit liabilities
25	28	29	27	39	43	43	44	47	45	43	40	39	10	11	13	14	45	47	52	56	77	81	84	92	82	82	86	93	99	104	0	0	0
Changes in:
Unpaid losses and loss expenses
2,367	2,350	2,881	3,493	765	1,033	1,073	592	605	40	-211	-540	-858	-421	-427	-45	-117	-134	-88	-235	50	-39	287	551	355	231	-243	-47	0	230	207	0	0	0
Future policy benefit reserves
-266	-231	-235	-168	-165	-157	-162	-227	-274	-289	-278	-265	-258	-228	-229	-208	-167	-166	-164	-182	-188	-197	-187	-203	-199	-184	-171	-161	-133	-146	-197	0	0	0
Funds withheld on GreyCastle life retrocession arrangements, net
-262	-198	-281	-294	-308	-209	-223	-201	-188	-162	-210	-434	-322	-387	-218	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Unearned premiums
728	821	733	490	544	510	436	-22	-122	-35	-528	-45	272	288	253	103	162	49	65	144	215	164	182	4	191	226	95	278	167	55	-133	0	0	0
Premiums receivable
1,191	1,027	1,200	1,154	528	915	1,084	804	719	648	-156	56	151	-91	-15	-51	40	-7	27	88	167	184	127	-36	118	128	31	344	257	8	-94	0	0	0
Unpaid losses and loss expenses recoverable
-1,372	-1,385	-1,575	-1,409	-428	-430	-360	-348	-373	-373	-439	-160	-436	-222	-44	-296	4	-11	-36	688	701	554	305	-381	-245	-135	-2	71	78	-37	74	0	0	0
Ceded unearned premiums
250	363	430	354	383	290	-70	-130	-203	53	-237	-44	195	226	191	265	313	241	196	46	53	3	-14	-132	-51	-58	-21	238	195	-6	-83	0	0	0
Reinsurance balances receivable
-549	-540	-327	-540	-188	-183	-174	-108	-204	-57	2	30	67	52	-17	-71	-40	-79	-60	118	108	82	162	-53	-6	-16	-49	-14	-106	-152	-201	0	0	0
Deferred acquisition costs and value of business acquired
21	118	118	65	87	112	62	-78	-82	-42	-126	-20	17	-288	-303	-299	-299	-22	-8	0	14	-10	0	-3	23	61	41	51	45	52	-12	0	0	0
Reinsurance balances payable
650	966	1,120	951	506	787	398	427	462	605	229	285	305	-24	160	87	104	301	161	-26	98	-66	48	-30	116	-8	-31	221	60	-81	-253	0	0	0
Deferred tax asset - net
45	45	59	49	8	22	41	20	102	69	47	30	-48	19	33	67	71	12	29	56	60	55	28	-28	-30	-8	43	-3	-1	-31	-104	0	0	0
Derivatives
-3	68	18	-47	-90	-159	-119	-67	-126	-61	-185	-212	-197	-196	-42	43	136	87	22	27	-47	-77	-7	-173	-168	-22	-93	204	154	-96	-123	0	0	0
Other assets
-42	-4	54	111	26	80	26	49	37	-1	-17	-47	14	-27	-33	-9	-16	28	26	6	61	45	-20	10	39	-21	24	40	85	93	68	0	0	0
Other liabilities
19	-159	-236	-257	-269	-49	-49	99	174	118	152	46	79	-165	-147	-133	-165	6	60	-18	-27	72	50	119	19	-35	-93	-108	27	-2	-32	0	0	0
Other
17	-106	-72	-111	-33	33	65	77	90	32	-26	-38	-28	-2	-5	-7	-40	-26	-9	-22	24	63	58	53	106	81	51	232	189	87	82	0	0	0
Total adjustments
59	385	523	690	-335	339	373	317	367	-857	-668	-477	-616	747	694	225	283	-207	-356	96	-22	144	325	724	703	413	731	-174	-8	145	-48	0	0	0
Net Cash Provided by (Used in) Operating Activities, Continuing Operations
-456	-157	33	449	626	1,040	943	812	819	465	644	744	630	798	963	655	773	834	779	1,014	932	1,048	1,056	855	703	417	327	130	331	451	594	0	0	0
Cash flows provided by (used in) investing activities:
Proceeds from sale of fixed maturities and short-term investments
16,745	17,579	15,702	14,530	11,695	11,477	12,757	15,880	17,966	19,166	16,868	11,416	8,204	5,263	4,896	5,347	5,274	4,249	4,341	4,190	3,742	3,303	3,604	4,314	4,574	5,469	5,091	4,633	5,309	5,053	5,206	0	0	0
Proceeds from redemption of fixed maturities and short-term investments
2,826	2,943	3,470	3,632	3,843	4,126	3,847	3,973	3,900	3,646	3,751	3,708	3,703	3,599	3,601	3,546	3,578	3,890	4,008	4,509	4,565	4,507	4,579	4,108	4,550	4,153	3,595	3,437	2,738	2,869	2,851	0	0	0
Proceeds from sale of equity securities
612	789	757	894	962	832	848	632	508	538	664	645	547	684	571	520	466	284	245	104	172	251	221	227	171	143	205	238	236	183	115	0	0	0
Purchases of fixed maturities and short term investments
19,344	20,565	19,281	18,356	15,820	14,765	15,457	18,554	20,031	21,208	19,718	14,262	11,399	8,582	7,158	8,280	8,836	8,293	9,143	9,508	8,917	7,778	8,902	7,992	8,096	9,727	7,529	7,983	7,775	6,946	8,098	0	0	0
Purchases of equity securities
94	311	326	807	1,125	1,096	1,103	741	583	528	567	555	445	458	445	502	442	405	534	430	496	452	362	349	446	501	631	657	498	395	157	0	0	0
Proceeds from sale of affiliates
658	669	593	447	480	523	397	349	816	712	748	733	170	173	240	227	251	290	190	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Purchases of affiliates
227	216	176	244	324	470	681	742	656	498	280	171	208	314	371	357	290	331	353	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Purchase of subsidiaries, net of acquired cash
-	-	-	-	-	-	92	0	0	0	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Change in restricted cash
-	-	-	-	-	-	-1	2	46	161	154	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Investment affiliates, net
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	-	255	156	283	319	0	0	0
Other, net
107	122	72	33	-94	-138	-197	-176	-40	40	155	173	184	119	193	193	158	179	-47	-118	-159	-88	79	110	173	85	36	18	-42	32	-24	0	0	0
Net Cash Provided by (Used in) Investing Activities, Continuing Operations
1,066	761	662	57	-165	775	737	897	1,284	535	136	172	-207	815	1,711	877	413	-495	-1,197	-1,174	-979	-182	-942	225	742	-430	832	-93	209	1,015	261	0	0	0
Cash flows provided by (used in) financing activities:
Proceeds from issuance of ordinary shares and exercise of stock options
68	73	50	53	50	32	9	7	6	8	9	8	8	6	6	8	7	10	12	10	12	7	5	579	576	577	576	0	0	0	-	-	-	-
Buybacks of common shares
123	372	571	716	817	895	1,051	1,082	1,040	822	468	467	562	627	801	776	651	627	675	577	552	526	402	451	634	601	667	818	779	686	522	0	0	0
Repurchase of preference shares
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	94	0	0	0
Employee withholding on share-based compensation
16	18	24	24	24	24	28	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Dividends paid on common shares
226	169	228	225	224	223	222	228	233	225	208	189	171	166	169	168	205	203	160	154	108	134	134	0	0	0	-	-	-	-	133	0	0	0
Dividends paid on preference ordinary shares
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	68	40	0	0	0
Distributions to non-controlling interests
95	114	124	146	138	127	130	130	129	138	117	117	93	82	78	77	77	77	77	77	78	78	78	76	75	73	71	0	0	0	-	-	-	-
Contributions from non-controlling interests
61	59	59	90	46	46	47	19	20	21	23	33	31	43	48	32	29	14	7	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from the issuance of debt
-	-	-	-	-	-	-	-	-	-	980	980	980	980	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Contingent consideration paid on business combination
0	0	-	-	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Repayment of debt
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	600	1,175	1,175	1,175	575	0	0	0	-	-	-	-
Deposit liabilities
142	97	34	40	65	68	69	68	50	54	84	81	103	289	268	273	264	72	94	108	122	143	134	150	156	156	152	139	635	625	646	0	0	0
Net Cash Provided by (Used in) Financing Activities, Continuing Operations
-901	-515	-743	-879	-622	-1,268	-1,453	-1,635	-1,579	-1,354	17	167	-511	-735	-1,863	-1,262	-569	-363	-394	-906	-848	-873	-1,344	-1,063	-933	-864	-358	-843	-1,620	-1,519	-1,473	0	0	0
Effects of exchange rate changes on foreign currency cash
3	33	56	9	6	-8	-57	-21	-47	-36	-64	-97	-141	-144	-90	-47	32	26	-4	0	4	-24	24	2	-60	-2	1	24	138	62	-3	0	0	0
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents, Period Increase (Decrease), Including Exchange Rate Effect
-288	122	8	-363	-155	538	170	53	475	-389	734	986	-230	733	720	222	651	2	-817	-1,066	-891	-33	-1,206	21	451	-879	802	-781	-941	10	-620	0	0	0
Life Funds Withheld Assets
Derivative, Gain (Loss) on Derivative, Net
-134	-132	-206	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-