|BAYN GY.xlsx
|
MasterMainModel
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAG
1Main
2Q120Q220Q320Q420Q121Q221Q321Q421Q122Q222Q322Q422Q123Q223Q323Q423201820192020202120222023202420252026202720282029
3Kerendia115211
4Betaferon807583757657234
5Nexavar11011391835646185
6Nubeqa49576976105127158178466
7Ultravist909097105112118101118436
8CT Fluid111115120117118120139124494
9Gadovist104102112108128127106118469
10Stivarga112124120144155159155133613
11Adempas140142328153162168169152652
12Aspirin Cardio159165170187201199201181788
13Yaz/Yasmin/Yasminelle191186178198212196184152790
14Kogenate/Kovaltry/Jivi211208219208212221206192847
15Adalat174207207239212232148177831
16Mirena/Kyleena/Jaydess2932762822953063772993031277
17Eylea7117637737748078118217893213
18Xarelto11641186124710871113111212049434516
19Other Pharma730839817856918738
20
21Consumer129013461405151214961548152415736080
22Pharma4494453949514624481849554855440719252
23Crop Science5021385046908447646146925569835125169
24Revenue1085497811104614639128191128111948143893674243545414004408150501
25COGS4546388751765680424757331681619871
26Gross Profit6308589494637139703486562726530630
27S&M2964301532843736335833941236314084
28R&D16381564145419281576157154126572
29G&A78375166173672165829622838
30Operating Expenses5385533053996400565556232073723494
31Operating Income92356440647391379303365287136
32Interest-653-322-201-390-4531-2554
33Pretax27037425381379264319974582
34Taxes+MI243431594281024504
35Net Income2733114791379022159734078
36
37Rev y/y-0.017077669239702220.18515595231615056-0.049259386841198790.064758454106280230.14564097910664464
38Adj rev y/y-0.011
39
40
41CFFO50897093
42CapEx26112949
43FCF24784144
44
45Headcount1007531017351078941038249953899637101369