|CVS.xlsx
|
MainModel
ABCDEFGHIJKLMN
1Main
2Q120Q220Q320Q420Q121Q221Q321Q421Q122Q222Q322Q422
3Products47387505255252256794
4Premiums18960189832163121260
5Services2453281925052436
6Investment297289168146
7Revenue69097726167682680636
8COPS40894435204550949290
9Benefits15704159011795117606
10General8922886998769171
11OpEx65520682907333676067
12OpInc3577432634904569
13Interest-607-591-544-540
14Pretax2970373529464029
15Taxes7479526341078
16Net Income2223278323122951
17EPS1.68154311649016642.0972117558402411.74096385542168692.233913701741105
18Shares1322132713281321
19
20Revenue y/y0.111857244164001330.11044397928831118
21MLR0.82827004219409280.8376442079755570.82987379224261480.8281279397930386
22
23Net Cash-22343-18699
24Cash3393736117
25AR2645127233
26Inventories1816017375
27OCA55302541
28PP&E1284412764
29Lease1880118562
30Goodwill107603106695
31Separate Accounts46704140
32OA48774852
33Assets232873230279
34
35AP1273813238
36Pharmacy Claims1857218393
37HC Costs1026010400
38Policyholders41381628
39AE1661917728
40Other Insurance77507484
41Other Lease1963519356
42Debt5628054816
43DT58295450
44Separate Account46704140
45OLTL22422140
46S/E7414075506
47L+SE232873230279
48
49Receipts74192
50Inventory/Rx-44365
51Insurance Paid-16616
52Suppliers/Employees-8969
53Interest-583
54Taxes-96
55CFFO3563
56
57Investments-904
58PP&E-1051
59Acquisitions-7
60Other-31
61CFFI-1993
62
63Debt-14
64Buyback-2000
65Dividends-722
66ESOP86
67CFFF-2650
68
69CIC-1080