|SGEN.xlsx
|
MainModel
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBXBYBZCACBCCCDCECFCGCHCICJCKCLCMCNCOCPCQCRCS
1Main
2Q419Q120Q220Q320Q420Q121Q221Q321Q421Q122Q222Q322Q422Q123Q223Q323Q423201520162017201820192020202120222023202420252026202720282029203020312032203320342035
3Adcetris166.2164.1167.5163.3163.7162.55181.9184.8176.3181201.9219.089193.93000000000004199.10000000000002222.09000000000003240.99790000000002213.32300000000006226.052265.766307.562476.903627.733658.6705.55795.9190000000001875.5109000000002901.7762270000003928.8295138100003956.6943992243004985.39523120102941014.95708813706041045.40580078117231076.7679748046075
4Padcev0.234.557.261.86969.7582.49592.7100.2123.6105101.97000000000001110.22000000000001135.96115.50000000000001112.1670000000000300000.244222.5339.85430.77000000000004473.84700000000004568.6164682.3396799999999784.6906319999998863.1596951999999889.0544860559999915.7261206376799943.1979042568103
5Tukysa0015.842.461.470.38386.694.190.5898895.04191.40589.8988.8895.9914100000119.6334362.541366.16641000000004384.4747305000001403.6984670250001423.88339037625013445.0775598950627467.33143788981585490.69800978430663515.232910273522
6Tivdak00000000.16.111.417.21621263136410000006.19999999999999965.6134201301.5361.8434.16455.86800000000005478.66140000000007502.5944700000001
7Royalty72.27320.3631.235039.227.236.29641.0284628.239.143.90450.631.02000000000000343.01000000000000548.2944000000000155.66000000000000440.9867.45566.05683.44138.49190.795150.524161.804177.98440000000002183.323932188.82364996194.4883594588200.323010242564206.33270054984092212.52268156633616218.89836201332625
8Collab51.115.66.30267.92.24.816.614.715.226.738.30738.30738.30738.30738.30738.30769.7784.926108.63294.357150.2450076.614153.2280000000
9Revenue238.67299999999997218.95999999999998271.735267.5333.29999999999995329.8383.596407.528415.20000000000005411.29999999999995470.8510.3500.84800000000007496.052560.2570000000001567.9793000000001556.4484100000001336.80199999999996418.147482.25654.7916.7131091.49500000000011536.12400000000031893.2482180.736712239.19128950000052505.19131079500042721.55678105935072928.1154965386563033.5437126327173143.0140127694953256.691621348266
10COGS11.92829.42148.24461.861.864.13578.0982.6586.787.626106.1108.122105.17808000000002104.17091999999997117.65397000000002119.27565299999998116.8541660999999954.11888.2929999999999943.952201.265311.57500000000005407.02608000000004457.95470909999995447.8382578999999501.03826215899994544.3113562118701585.6230993077311606.7087425265431628.602802553899651.3383242696532
11Gross Profit226.74499999999998189.539223.491205.7271.49999999999994265.665305.506324.87800000000004328.50000000000006323.674364.70000000000005402.178395.66992000000005391.88108000000005442.60303000000005448.7036470000001439.5942439000001336.80199999999996418.147428.132566.407872.761890.23000000000011224.54900000000021486.221921722.78200090000021791.35303160000062004.15304863600042177.24542484748052342.4923972309252426.8349701061742514.4112102155962605.3532970786127
12R&D201.061195.199198.077217.67216.184230.426234.861459.092304.3297.659304.254384.605456.7565.309719.374827.131228.6789999999999986.518
13SG&A115.229122.249125.642127.579158.365159.842165.13180.281210.9174.225220.259210.378221.44500000000002182.93625231.27195220.8969232.51725000000002167.233261.096373.932533.835716.153826.307400412424.36437.0908450.203524463.70962972477.6209186116491.949546169948
14OpEx316.29317.448323.719345.24899999999997374.549390.26800000000003399.991639.373515.2471.884524.513594.983221.44500000000002182.93625231.27195220.8969232.5172500000000200623.933826.4051093.3061360.96500000000011944.83199999999991812.825400412424.36437.0908450.203524463.70962972477.6209186116491.949546169948
15OpInc-89.54500000000004-127.90899999999999-100.22799999999998-139.54899999999998-103.04900000000004-124.60300000000001-94.48500000000001-314.495-186.7-148.21000000000004-159.813-192.80499999999995174.22492000000003208.94483000000005211.33108000000004227.80674700000012207.07699390000008336.80199999999996418.147-195.801-259.99799999999993-220.54500000000007-470.735-720.2829999999997-326.60308000000011322.78200090000021379.35303160000061579.79304863600051740.15462484748061892.28887323092481963.12534038617382036.7902916039962113.4037509086647
16Interest64.244-56.04772.7751.2230.89815.0275.228-4.9-2.19-1.6094.27836.91413.65261.89518.8490000000000076.3549999999999990.4789999999999996558.1378076000000191.27988300400001126.57507295449604167.52790787266795213.31228865795154263.8467165432846317.29404590959155373.7920700099176
17Pretax Income-25.301000000000045-183.956-27.452999999999975-138.32599999999996-102.15100000000004-123.60300000000001-89.45800000000001-309.267-191.6-150.40000000000003-161.422-188.52699999999996174.22492000000003208.94483000000005211.33108000000004227.80674700000012207.07699390000008336.80199999999996418.147-158.887-246.34599999999995-158.65000000000006-451.886-713.9279999999997-326.12408000000011380.91980850000031470.63291460400071706.36812159049671907.68253272014862105.60116188887652226.9720569294582354.08433751358732487.1958209185823
18Taxes0003.242-1.211001.112-2.3451.2540.1072.289-33.357-23.65302.0309999999999997-1.2333.6500000000000004276.18396170000005294.12658292080016341.27362431809934381.53650654402975421.1202323777753445.39441138589166470.8168675027175497.43916418371646
19Net Income-25.301000000000045-183.956-27.452999999999975-141.56799999999996-100.94000000000004-123.60300000000001-89.45800000000001-310.379-189.255-151.65400000000002-161.529-190.81599999999995174.22492000000003208.94483000000005211.33108000000004227.80674700000012207.07699390000008336.80199999999996418.147-125.53-222.69299999999996-158.65000000000006-453.91700000000003-712.6949999999997-329.77408000000011104.73584680000021176.50633168320061365.09449727239731526.1460261761191684.48092951110131781.57764554356661883.26747001086981989.75665673486581969.85909016751731950.1604992658421930.65889427318351911.35230533045161892.2387822771471873.31639445437551854.58323050983181836.03739820473331817.6770242226861799.5002539804591781.50525144065451763.6901989262481746.05329693698561728.59276396761561711.30683632793941694.193767964661677.25183028501351660.47931198216341643.87451886234181627.43577367371841611.16141593698131595.04980177761151579.09930375983531563.3083107222371547.67522761501461532.19847533886451516.87649058547571501.7077256796211486.69064842282481471.82374193859641457.10550451921041442.53444947401821428.1091049792781413.82801392948521399.68973379019031385.69283645228851371.83590808776561358.11754900688791344.5363735168191331.09100978165071317.78009968383411304.60229868699571291.55627570012581278.64071294312451265.85430581369341253.19576275555641240.66380512800081228.25716707672091215.97459540595361203.8148494518941191.7767009573751179.85893394780121168.06034460832321156.379741162241144.81594375061761133.36778431311151122.03410646998031110.81376540528051099.7056277512277
20EPS-0.14174150284872378-1.067339715694807-0.15831632123455922-0.7783721965944014-0.5425714900021503-0.6823240408501242-0.49253419076353877-1.7025446646517064-1.0336437368579152-0.8257907834051198-0.8771837410736104-1.0325988138014630.94281635568639341.13070279016407671.14361595740075341.23277385925797711.12059501439456292.6071494921971762.9709334545919597-0.8767653344881053-1.4125336969966062-0.9586218564574803-2.5441175440292683-3.91496011953154-1.78890595842555245.9927952458447256.382124352749217.4051474269430918.2787941358336539.1377041265845439.66441894253985210.2160497223173510.79371531883254
21Shares178.501172.35173.406181.877186.04181.15181.628182.303183.095183.647184.145184.792184.792184.792184.792184.792184.792129.184140.746143.174157.655165.498178.41825182.044184.34400000000002184.34400000000002184.34400000000002184.34400000000002184.34400000000002184.34400000000002184.34400000000002184.34400000000002184.34400000000002
22
23Revenue y/y0.396471322688364270.50621118012422370.411654737152004730.52346915887850480.24572457245724610.247119466343238110.22733292317959530.25218389902043550.206281310211946070.206058837831266880.190010620220900650.113030178326474660.111012542727534140.241521724930374710.153302546712041470.35759460860549510.400203146479303440.190661635648234680.40735779824919050.232483835940327620.151849472441011550.0268049688125808760.118792897481481590.086366845251306890.075897264726148220.036005484147974440.0360866071192269540.03616834290808746Discount0.08
24Adcetris y/y-0.015042117930204602-0.0094454600853137730.085970149253731480.131659522351500250.076970067196090450.113503537373115910.109950522264980810.185546536796536770.100000000000000090.100000000000000090.100000000000000090.100000000000000090.100000000000000090.175685240564118050.157266166477276980.55059142546868590.31626976554980770.0491721798917694740.07128757971454580.12808305577209290.100000000000000090.0300000000000000270.0300000000000000270.0300000000000000270.0300000000000000270.0300000000000000270.0300000000000000270.030000000000000027Maturity-0.01
25Gross Margin0.95002367255617510.86563299232736580.8224593813825970.76897196261682240.81458145814581450.80553365676167380.79642644865952720.79719184939439750.79118497109826590.78695356187697550.77463891248937990.78812071330589850.790.790.790.790.79110.88778019699326070.86513975866809220.95205478704894550.81560611821400930.79716806716124480.78501174700831580.790.80.80.80.80.80.80.8ROIC0.03
26NPV22199.019174395693
27Cash18501763.70200000000021937.92692000000032146.87175000000022358.202832586.00957700000032793.08657090000041937.92692000000033042.66276680000064219.1690984832015584.26359575559857110.4096219317188794.89055144281910576.46819698638512459.73566699725414449.49232373212119.56497461195261
28A/R486.755
29Inventories364.97
30Prepaids144.192
31PP&E230.302
32Lease49.308
33Goodwill518.0029999999999
34ONCA61.846
35Assets3619.078000000001
36
37AP144.499
38AL581.499
39Leases46.703
40OLTL24.566
41S/E2821.811
42L+SE3619.0780000000004
43
44Headcount1605