|BIIB.xlsx
|
MainModel
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBXBY
1Main
2Q120Q220Q320Q420Q121Q221Q321Q421Q122Q222Q322Q422Q123Q223Q323Q4232010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067
3Tecfidera953.1607.9479.3487.6498.6486.5409.9397.9339297.1274.5278.53237.29999999999998207.974432.73841.119521443.91155.1200000000001924.0960000000001739.2768000000001591.4214400000001473.13715200000007378.5097216000001302.8077772800001242.2462218240001193.7969774592001155.0375819673601124.0300655738880899.2240524591104779.3792419672883863.5033935738307150.80271485906456540.64217188725165632.51373750980132426.01099000784106
4Vumerity14.438.973.690.9120.9124.9128136.8137.8150.8108.295.7696.46000000000001105.565.564.3410.29999999999995553.4000000000001608.7400000000001669.6140000000001736.5754000000002758.6726620000002781.4328418600002804.8758271158002829.0221019292743853.8927649871525426.94638249357627341.55710599486105273.24568479588885218.5965478367111174.8772382693689139.90179061549512111.921432492396189.5371459939168871.629716795133557.30377343610681
5Avonex380.5356.4311.1310.9301.3285.4229.6258.7255.1230.1172.4206.96204.08184.081665.89999999999991491.91208.6999999999998973.5876.15788.535709.6815638.71335574.8420150000001517.3578135465.62203215000005419.05982893500004377.15384604150006339.43846143735004305.494615293615274.9451537642535247.45063838782818222.70557454904537200.43501709414085180.39151538472677162.3523638462541146.11712746162868
6Plegridy93.699.689.489.586.292.38091.580.979.573.282.3500000000000172.8171.55435.9385.6357.40000000000003331.9315.30499999999995299.5397499999999284.5627624999999270.3346243749999256.8178931562499243.9769984984374231.77814857351552220.18924114483974209.17977908759775198.72079013321786188.78475062655696179.3455130952291170.37823744046764161.85932556844426153.76635929002205146.07804132552096138.7741392592449131.83543229628265
7Tysabri516.5475.2503.3524.2522.8512.7520.8516.2505.5488.4472.8464.58000000000004454.95439.561892.21946.120632030.92051.20900000000032071.72109000000051760.96292650000031496.81848752500011272.295714396251081.4513572368126919.2336536512906781.348605603597664.1463147630574564.5243675485988479.84571241630897407.8688555538626346.6885272207832294.6852481376657250.48246091701586212.91009177946347180.97357801254395153.82754131066235
8Fampyra26.825.126.626.126.226.726.225.52222.924.124.124.124.197.1103.1105.6000000000000196.686.9478.24670.4213999999999963.37925999999999557.04133451.337200646.2034805441.58313248600000437.424819237433.6823373136630.31410358229427.28269322406459824.5544239016581422.09898151149232619.88908336034309317.90017502430878316.11015752187790514.499141769690116
9Spinraza494.4498520.5499.7444.1440.7472.5431431.1458.8443.3431431.1458.820972052.11905.00000000000021793.39999999999991614.061452.6541307.38861176.649741058.984766953.0862894857.7776604600001771.9998944140001694.7999049726001625.31991447534562.7879230278061506.5091307250255455.85821765252297410.2723958872707369.24515629854363332.3206406686893299.08857660182036269.1797189416383
10Benepali124.2117.6121.7121.5120.8134.4114.7115.8110.2100.3109104.2299.1890.27486.2481.6498.4441396.90000000000003357.21000000000004321.48900000000003289.34010000000006260.40609000000006234.36548100000007210.92893290000006189.83603961000006170.85243564900006153.76719208410006138.39047287569005124.55142558812105112.09628302930895100.8866547263780590.7979892537402581.7181903283662373.5463712955296166.19173416597665
11Imraldi56.253.757.955.657.462.557.157.657.752.154.451.8451.9300000000000146.89184216.3233.4224.5202.05181.84500000000003163.66050000000004147.29445000000004132.56500500000004119.30850450000004107.3776540500000396.6398886450000386.9758997805000378.2783098024500270.4504788222050363.4054309399845357.0648878459860851.3583990613874746.22255915524872441.6003032397238537.44027291575146433.69624562417632
12Flixabi27.526.125.525.324.62422.520.51919.320.418.4517.117.3768.197.999.481.373.1765.8530000000000159.2677000000000153.34093000000001448.0068370000000143.2061533000000138.8855379700000134.9969841730000131.4972857557000128.34755718013000725.51280146211700722.9615213159053120.66536918431477718.598832265883316.7389490392949715.06505413536547213.55854872182892612.202693849646034
13Byooviz00000000.50.73.18.612.616.620.60004.350100908172.965.6100000000000159.04900000000001453.14410000000001647.82969000000001443.0467210000000138.74204890000001534.8678440100000131.38105960900001228.24295364810001325.4186582832900122.8767924549610120.5891132094649118.53020188851842
14Fumaderm3.13.12.83.12.52.72.22.71.51.82.42.42.42.415.212.211.1000000000000018.2000000000000017.3800000000000016.6420000000000015.9778000000000015.3800200000000014.8420180000000014.3578162000000013.9220345800000013.5298311220000013.1768480098000012.8591632088200012.5732468879380012.3159221991442012.0843299792297811.87589698130680321.68830728317612281.51947655485851051.36752889937265951.2307760094353937
15Qalsody52025
16Leqembi-18.93030050015004000600080008400882092619446.229635.14449827.84728799999910024.40423375999910224.89231843519910429.39016480390310637.97796809998210850.7375274619811067.75227801122111289.10732357144711514.889470042875
17Aduhelm0001.60.312.80.11.60.3002.90000000000000044.84.323.88800000000000033.49920000000000053.14928000000000052.83435200000000042.55091680000000042.29582512000000042.06624260800000051.85961834720000051.67365651248000051.50629086123200051.35566177510880051.22009559759792041.09808603783812830.98827743405431550.88944969064888390.80050472158399550.720454249425596
18Product2690.29999999999932301.59999999999952211.70000000000032235.99999999999952205.70000000000032193.79999999999972066.32054.79999999999971962.10000000000011904.49999999999981744.41807.792028.01000000000022194.149999999999611379.80000000000110692.28847.1999999999997987.7000000000018941.34410999.84384000000312252.76358913575.494343913396.106018412513319.99407975105213335.9038392040813156.7527755525912580.78420159713112394.10044665836712266.08242888553812188.1220709217212153.08871488925812155.06550066412112189.13449222231212251.20132647902412337.85193288165512446.235301053905
19Ocrevus272.4202.4209.3264.3261.2252.3281.1311.1283.6283.6283.6283.6748897.6734.8844.5000000000001760.0500000000001684.0450000000001615.6405000000001554.0764500000001498.66880500000013448.80192450000015403.9217320500002363.52955884500017327.17660296050013294.45894266445015265.01304839800514238.51174355820464214.66056920238418193.19451228214578173.8750610539312156.48755494853808140.83879945368426126.75491950831584
20Rituxan/Gazyva287.7216.6179.7151.1152.9147.1135.8136.8112.5112.5112.5112.51542.41080.2483.69999999999993419.7377.73339.95700000000005305.96130000000005275.36517000000003247.82865300000003223.04578770000003200.74120893000003180.66708803700004162.60037923330003146.34034130997003131.70630717897302118.53567646107572106.6821088149681696.0138979334713486.412508140124277.7712573261117869.994131593500662.99471843415054
21CD20440436.3416.90000000000003447.90000000000003399.5399.5399.5399.54401301.10000000000011170.99000000000021053.8910000000003948.5019000000003853.6517100000003768.2865390000003691.4578851000002622.3120965900002560.0808869310002504.0727982379002453.6655184141102408.29896657269916367.46906991542926330.72216292388634297.6499466314977267.88495196834793241.09645677151315216.98681109436183195.28812998492566
22Other125.713293.399157.8126.266.198129.5191.6319.198129.5191.6707.7774.6476.3485.20000000000005436.68000000000006393.01200000000006353.71080000000006318.33972000000006286.50574800000004257.8551732232.06965588000003208.86269029200002187.97642126280002169.17877913652152.260901222868137.0348111005812123.33132999052309110.9981969914707899.898377292323789.9085395630913480.917685606782272.82591704610398
23Revenue3376.0999999999992852.59999999999952694.00000000000052774.99999999999952778.90000000000052734.09999999999952531.82589.12508.52543.999999999999524632701.392953.113181.349999999999514377.90000000000113444.60000000000210981.99999999999811038.20000000000311686.79399999999813470.74884000000414476.57808900000215576.927393915197.395763412514941.15485025105214794.94853265408214469.89299965759213762.6104032916313457.74402818341913223.36165225808313049.6733719570112928.4848858210212852.92205450270712817.2053906770412816.4651350882812846.58936062998512904.0989860274
24COGS449.1490.6478.1459.7511.8660.1753.9484469.5570.9662.81955.41805.22109.72278.32103.622922424.73479120000052605.7840560200022803.8469309022735.53123741425042689.40787304518932663.0907358777352604.58073993836662477.26987259249472422.39392507301642380.2050974064552348.94120695226232327.12727944778452313.52596981048742307.0969703218672306.96372431589042312.3860849133982322.7378174849327
25Gross Profit2926.9999999999992361.99999999999952215.90000000000052315.29999999999972267.10000000000042073.99999999999951777.92105.120391973.09999999999951800.22701.392953.113181.349999999999512422.50000000000211639.4000000000018872.38759.9000000000019583.17107999999811046.01404880000311870.7940329812773.08046299812461.8645259982512251.74697720586312131.85779677634711865.31225971922511285.34053069913511035.35010311040210843.15655485162810700.73216500474710601.35760637323610539.3960846922210510.10842035517310509.5014107723910534.20327571658710581.361168542468
26R&D1140.91726514.2585.1702.4699.5551.7528.6549.2601.6570.62280.63990.92501.20000000000032231.1000000000004
27SG&A573.1806.3595637.3654.1787.9634.9572.6563.3632.86052374.72504.52674.32403.62283.41999999999962169.24899999999932060.78654999999941957.74722249999921859.85986137499911766.8668683062491678.52352489093641594.59734864638951514.867481214071439.12410715336641367.1679017956981298.8095067059131233.86903137061721172.17557980208631113.5668008119821057.88846077138281004.9940377328136954.7443358461728
28OpEx17142532.31109.21222.41356.51487.41186.61101.21112.51234.41175.60004655.2999999999996495.45175.54634.7000000000012283.41999999999962169.24899999999932060.78654999999941957.74722249999921859.85986137499911766.8668683062491678.52352489093641594.59734864638951514.867481214071439.12410715336641367.1679017956981298.8095067059131233.86903137061721172.17557980208631113.5668008119821057.88846077138281004.9940377328136954.7443358461728
29OpInc1212.999999999999-170.300000000000641106.70000000000051092.8999999999996910.6000000000004586.5999999999995591.30000000000021003.8999999999999926.5738.6999999999994624.60000000000012701.392953.113181.34999999999957767.2000000000035144.0000000000023696.79999999999934125.2000000000017299.7510799999988876.7650488000049810.00748298000110815.33324049810602.00466462325110484.88010889961310453.33427188541110270.7149110728359770.4730494850659596.2259959570379475.988653055939401.9226582988349367.4885750026199367.2205048901349396.541619543199451.6129500010079529.2092379837749626.616832696294
30Interest Income-55.599999999999994749.9-438.4-15.2-481.7-114.8-380.629.4101.3-113.1-69.4324.9730.3-1050.1-363
31Pretax Income1157.3999999999992579.5999999999993668.30000000000051077.6999999999996428.9000000000004471.79999999999944210.700000000000161033.31027.8625.5999999999993555.20000000000022701.392953.113181.34999999999958092.1000000000025874.3000000000022646.69999999999943762.20000000000077299.7510799999988876.7650488000049810.00748298000110815.33324049810602.00466462325110484.88010889961310453.33427188541110270.7149110728359770.4730494850659596.2259959570379475.988653055939401.9226582988349367.4885750026199367.2205048901349396.541619543199451.6129500010079529.2092379837749626.616832696294
32Taxes256.3-4.99999999999999956.800000000000004951.8-38.136.8000000000000143.60000000000001210.79999999999998236.254.350.7540.278590.6220000000001636.271237.41052.21007.3544.91459.95021599999971775.35300976000081962.00149659600042163.06664809962120.40093292465052096.97602177992262090.66685437708252054.1429822145671954.0946098970131919.24519919140741895.19773061118621880.3845316597671873.49771500052381873.44410097802691879.30832390863821890.32259000020141905.84184759675491925.323366539259
33Net Income901.0999999999992584.5999999999993611.5000000000006125.89999999999964467.0000000000004434.99999999999943167.10000000000014822.5791.5999999999999571.2999999999994504.500000000000172161.1122362.48800000000032545.07999999999956854.7000000000034822.1000000000021639.39999999999943217.30000000000065839.8008639999997101.4120390400037848.00598638400158652.2665923983998481.60373169868387.904087119698362.6674175083288216.5719288582687816.3784395880527676.9807967656297580.7909224447457521.5381266390677493.9908600020957493.77640391210757517.2332956345527561.2903600008057623.3673903870197701.293466157035
34Shares5.732188295165393.7961038961038924.0151017728168130.83877415056628683.14266487213997572.94915254237287751.13211382113821225.6258549931600555.4668508287292813.9345730027548173.4745179063360914.88369146005509916.27057851239669617.52809917355371636.5779082177161329.89522628642282610.95672514619882622.04385063377869640.0123389105858148.6564716618020153.7718806877972159.2824021404480958.11307798354642557.4710797336052857.2981666153362756.29716977634990453.55517944219289552.6000739757836951.9410135145237851.53503341308028551.3462888660643851.3448194855231851.5055381681024551.80740226105382452.232733061918652.76665615729384
35EPS157.2154152.3150.1148.6147.5147.6146.2144.8145.2145.2145.2145.2145.2187.4161.3149.625145.95145.95145.95145.95145.95145.95145.95145.95145.95145.95145.95145.95145.95145.95145.95145.95145.95145.95145.95
36Terminal-0.01
37Discount0.08
38Revenue y/y-0.1768904949497937-0.04154105026992916-0.06020786933927258-0.06699099099099082-0.09730468890568233-0.06952927837313927-0.0271743423651158440.043370283109960940.17724137931034490.2505306603773585-0.06491212207624197-0.183166475759784840.0051174649426337650.058759036799477690.152647068135196570.074667656634892720.07600893651353258-0.024364986809666034-0.016860843604424858-0.009785476361254264-0.02197071062998679-0.04887960100207367-0.022151784158279675-0.017416171345991494-0.013134956516251184-0.009286706470095663-0.005844678010273663-0.0027788750040038668-0.000057754835488421640.00235043166927773050.004476645417939462NPV73154.66616727483
39Product y/y-0.04683698296836969-0.06574128498440113-0.08103756708407861-0.11044112980006349-0.1318716382532592-0.15578570391521074-0.120211212770099160.033591560063197520.1520871619847728
40Gross Margin0.8669766890791150.82801654630863080.82253155159613970.83434234234234240.81582640613192270.75856771881057750.70222766411248920.81306245413464140.81283635638827990.77558962264150930.73089727974015431110.86399961051335740.86573047915148080.80789473684210530.79359859397365510.820.82000000000000010.81999999999999980.820.820.82000000000000010.820.820.820.820.820.820.820.820.82000000000000010.820.820.82Share504.51493908465403
41
42Net Debt124.399999999999641104.8000000000002846.69999999999981117.5999999999995
43Cash7401.59999999999973847127.77400.299999999999
44AR1567.61568.817051634.4
45CD20415.4431.4393.8
46Inventory1294.213751344.41281
47OCA2081.21495.51417.61412
48PP&E3355.13266.43298.63300.9
49Lease321.1424.5403.9399.1
50Goodwill7824.9000000000017750.17599.17565.1
51DT1235.71174.51226.41211.8
52Assets25081.424854.19999999999724554.10000000000224598.399999999998
53
54Taxes566.2259.9235.5
55AP383.2491.5491.2
56AE4018.23305.92521.42288.2
57Debt7277.26279.262816282.7
58DT480.6354.8334.7251.3
59Lease274.21198.1333327
60OLTL1167.8944.2935.5
61SE11863.412766.813388.413787
62L+SE25081.424854.19999999999724554.124598.399999999998