|ELV.xlsx
|
MainModel
ABCDEFGHIJKLMNOPQRSTU
1Main
2Q120Q220Q320Q420Q121Q221Q321Q421Q122Q222Q322Q422201920202021
3Medical Membership4292545374410004292545374
4
5
6Premiums27676285333039530769327853307633722
7Product2737304233533525330135683972
8Fees+Investment1972227620742287200919882245
9Revenue32385338513582236581380953863239939
10COGS26012273772664533506310983184632841
11Gross Profit6373647491773075699767867098
12MLR397737703750457042994318
13SG&A3925382139464222434142694514
14Operating Income244826535231-1147265625172584
15Interest Expense-192-205-201-200-201-208-213
16Pretax Income225624485030-1347245523092371
17Taxes511544487279541496528
18Net Income174519044543-1626191418131843
19EPS-6.7253794220414077.937267256692047.5525335256984037.712115910683471
20Shares241.770746241.140929240.051897238.974624
21
22Cash42039
23Medical Receivables10555
24Other Receivables3651
25OCA5496
26PP&E4197
27Goodwill34917
28ONCA2171
29Assets103026
30
31Claims21549
32DR3702
33AP4963
34Debt23772
35OCL9384
36Tax1825
37ONCL1788
38SE36043
39L+SE103026
40
41MLR0.123375555189998350.12804697230294762
42
43Model NI174519044543-1626191418131843
44Reported NI1667180115021125179516501613
45CFFO25051683250416722541245249246061106888364
46CapEx204285258340254295305