|UNH.xlsx
|
MainModels
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1Main
2Q117Q217Q317Q418Q118Q218Q318Q418Q119Q219Q319Q419Q120Q220Q320Q420Q121Q221Q321Q421Q122Q222Q322Q422
3Members Risk-based7840798579508010
4Members Fee-based18395185951846018480
5Commercial Domestic26235265802641026490
6Medicare Advantage6385649068906945
7Medcaid7130765578107990
8Medicare Supplement4390439543554355
9Community & Senior17905185401905519290
10Commercial Global5485551055005465
11Part D3750370033603330
12
13Optum Health Customers99100100101
14Optum Backlog21.322.422.823.6
15Optum Rx342353352357
16
17E&I Domestic1494215567
18E&I Global21182247
19Medicare & Retirement2530428625
20Community & State1311015666
21Optum3830345082
22Optum Health1330017583
23Optum Insight29573282
24Optum Rx2252424805
25
26Premiums-Medical968711803
27
28Premiums55486562336407063896
29Products8340843393409496
30Services5918609963726645
31Investment452556367295
32Revenue70196713218014980332
33Medical44904465465252352093
34Operating10223103591140111709
35COPS7572766084878596
36OpEx62699645657241172398
37OpInc7497675677387934
38Interest-397-410-433-467
39Pretax7100634673057467
40Taxes1480119614901466
41Net Income5620515058156001
42EPS5.872518286311395.3870292887029296.095387840670866.316842105263158
43Shares957956954950
44
45MLR0.80928522510182750.82773460423594690.8197752458248790.8152779516714661
46
47Revenue y/y0.14178870590916870.12634427447736285
48Premiums y/y0.154705691525790280.13627229562712295
49
50Cash7074970391
51AR1887118718
52Other Receivables1199412439
53AUM41554017
54Prepaids56135218
55PP&E91839421
56Goodwill8746695444
57Other Assets1320714524
58Assets221238230172
59
60Medical Costs2867628978
61AP2505825145
62Debt4749351391
63DR26752212
64OCL2506426771
65DT29542581
66OL1167111967
67SE7764781127
68L+SE221238230172
69
70
71
72
73
74
75Acquisitions-468-236-204