A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM	BN	BO	BP	BQ	BR	BS	BT	BU	BV	BW	BX	BY	BZ	CA	CB	CC	CD	CE	CF	CG	CH	CI	CJ	CK	CL	CM	CN	CO	CP	CQ	CR	CS	CT	CU	CV	CW	CX	CY	CZ	DA	DB	DC	DD	DE	DF	DG	DH	DI	DJ	DK	DL	DM	DN	DO	DP
1	Main		6/1/2005	9/1/2005	12/31/2005	3/1/2006	6/1/2006	9/1/2006	12/31/2006	3/1/2007	6/1/2007	9/1/2007	12/1/2007	39508	39600	9/1/2008	12/31/2008	3/31/2009	6/30/2009	9/30/2009	12/31/2009	3/31/2010																																																				38047	38412	38777	39142	39508	39873	40238	40603	40969	41334	41699	42064
2			Q106	Q206	Q306	Q406	Q107	Q207	Q307	Q407	Q108	Q208	Q308	Q408	Q109	Q209	Q309	Q409	Q110	Q210	Q310	Q410	Q111	Q211	Q311	Q411	Q112	Q212	Q312	Q412	Q113	Q213	Q313	Q413	Q114	Q214	Q314	Q414	Q115	Q215	Q315	Q415	Q116	Q216	Q316	Q416	Q117	Q217	Q317	Q417	Q118	Q218	Q318	Q418	Q119	Q219	Q319	Q419	Q120	Q220	Q320	Q420	Q121	Q221	Q321	Q421	Q122	Q222	Q322	Q422				2004	2005	2006	2007	2008	2009	2010	2011	2012	2013	2014	2015
3		Byetta LAR end-user																																																																															1250	1500	1750	2000	2200
4		Risperdal Consta end-user	144	161	169	185.39999999999998	205	232	226	261.20000000000005	278.7	293.6	295.1	309	343.1	337.5	318.8	325	347.8	352.6	352.6	352.6																																																						659.4	924.2	1176.4	1324.4	1405.6
5		Imputed Rate	0.025027777777777777	0.025062111801242237	0.02501775147928994	0.030744336569579294	0.025068292682926832	0.02505603448275862	0.025101769911504423	0.024984686064318525	0.025052027269465378	0.025027247956403268	0.02502202643171806	0.025058252427184468	0.025010201107548816	0.025004444444444444	0.024999999999999998	0.025406153846153846	0.025017251293847038	0.025008508224617126	0.025575723199092452	0.026142938173567776																																																						0.026640885653624508	0.02504977277645531	0.02503995239714383	0.025103443068559345	0.02543753557199772
6
7		Risperdal Consta royalty	3.604	4.035	4.228	5.7	5.139	5.813	5.673	6.526	6.982	7.348	7.384	7.743	8.581	8.439	7.97	8.257	8.701	8.818	9.017999999999999	9.217999999999998																																																				3.79	9.636	17.567	23.151	29.457	33.247	35.754999999999995	35.039899999999996	34.339102	33.65231996	32.979273560799996	32.319688089584
8		Manufacturing Revenue	13.983	13.526	14.715	22.677	22.193	26.122	28.763	28.338	31.517	24.137	14.275	31.771	38.61	33.039	20.533	24.662	28.804	32.835	27.835	22.835																																										40.89400000000002				32.52599999999999						25.736	40.488	64.90100000000001	105.416	101.7	114.136	112.309	110.06282	107.8615636	105.70433232799999	103.59024568144	101.5184407678112
9		Vumerity																																																														20.3				26.2
10		AP Royalties																																																														81.1				26.6
11		Vivitrol												0	0	0	0	4.467	4.226	4.643	5.643	6.643																																										88.4				96.1											30	21.155
12		Aristada																																																														72.4				74.6
13		Other	7.251	29.127000000000002	22.475	26.315	24.206000000000003	29.235	27.977	29.98	6.989	5.909	5.127	2.025	1.351	5.833	3.736	6.489	5.765000000000001	1.861																																												0.615				0.106						9.528	26.002	85.168	111.39800000000001	20.049999999999997	9
14		Byetta LAR royalties																																																																															93.75	112.5	131.25	150	165
15		Lybalvi																																																														0				20.1
16		Total Revenue	24.838	46.688	41.418	54.692	51.538000000000004	61.17	62.413	64.84400000000001	45.488	37.394	26.785999999999998	41.539	48.542	47.311	32.239	43.87499999999999	47.495999999999995	48.157	42.496	38.696																																										303.70900000000006				276.23199999999997						39.054	76.12599999999999	167.63600000000002	239.96500000000003	151.207	186.38299999999998	169.219	238.85272	254.70066559999998	270.60665228799996	286.56951924224	298.8381288573952
17		COGS	4.517	4.36	6.077	8.535	9.338	11.822	12.989	11.06	10.145	9.218	7.499	13.815	14.314	11.671	5.236	11.475	12.366	14.592	10.624	9.674																																										53.124				58.36						19.037	16.834	23.489	45.2	40.7	42.696	47.256	54.9361256	56.034146432	56.82739698047999	57.31390384844798	59.76762577147903
18		Gross Margin	20.321	42.328	35.341	46.157	42.2	49.348	49.42399999999999	53.784000000000006	35.343	28.176	19.287	27.724000000000004	34.228	35.64	27.002999999999997	32.39999999999999	35.129999999999995	33.565	31.872	29.022																																										250.58500000000006				217.87199999999996						20.017000000000003	59.29199999999999	144.14700000000002	194.76500000000004	110.50699999999999	143.68699999999998	121.963	183.9165944	198.66651916799998	213.77925530751997	229.25561539379203	239.07050308591616
19		R&D	21.622	19.37	22.501	25.575	25.863	29.817	29.908	31.727	32.619	28.317	30.395	33.937	22.261	18.41	22.169	24.838	16.785999999999998	19.764000000000003	1	1																																										97.473				92.873						91.097	91.065	89.068	117.3	125.3	87.678	38.55	1	1	1	1	1
20		SG&A	8.952	9.109	9.332	12.99	16.53	15.677	16.365	17.827	15.4	14.487	15.249	14.372	11.926	9.579	12.068	20.835	17.168	12.269999999999998	1	1																																										139.188				150.377						26.029	28.823	40.383	66.4	59.5	54.408	31.437999999999995	3	3	3	3	3
21		Operating Expenses	30.573999999999998	28.479	31.833000000000002	38.565	42.393	45.494	46.272999999999996	49.554	48.019	42.804	45.644	48.309	34.187	27.989	34.237	45.673	33.95399999999999	32.034	2	2																																										236.661				243.25						117.12599999999999	119.888	129.451	183.7	184.8	142.086	69.988	4	4	4	4	4
22		Operating Income	-10.252999999999997	13.849000000000004	3.507999999999999	7.591999999999999	-0.19299999999999784	3.853999999999999	3.1509999999999962	4.230000000000004	-12.675999999999995	-14.628000000000004	-26.357	-20.584999999999994	0.04100000000000392	7.651	-7.234000000000005	-13.27300000000001	1.176000000000002	1.5309999999999988	29.872	27.022																																										13.924000000000063				-25.378000000000043						-97.10899999999998	-60.59600000000002	14.696000000000026	11.065000000000055	-74.29300000000002	1.6009999999999707	51.974999999999994	179.9165944	194.66651916799998	209.77925530751997	225.25561539379203	235.07050308591616
23		Interest Income	-3.2	-1.6	-1.8	-2.2	-0.4	0.03600000000000014	0.20799999999999977	-0.3919999999999998	0.35499999999999976	1.3200000000000005	-0.18900000000000028	-0.49799999999999955	-0.7739999999999999	-2.216	-0.8960000000000004	-0.45200000000000007	-0.21100000000000013	-0.5449999999999999	0	0																																										-2.0060000000000002				0.33699999999999974						-1	-6.2	-8.8	1	17.834	-4.338000000000001	0	0	0	0	0	0
24		Pretax Income	-13.452999999999996	12.249000000000004	1.707999999999999	5.391999999999999	-0.5929999999999979	3.8899999999999992	3.358999999999996	3.838000000000004	-12.320999999999994	-13.308000000000003	-26.546	-21.082999999999995	-0.732999999999996	5.435	-8.130000000000006	-13.72500000000001	0.9650000000000019	0.9859999999999989	29.872	27.022																																										11.918000000000063				-25.041000000000043						-98.10899999999998	-66.79600000000002	5.896000000000026	12.065000000000055	-56.45900000000002	-2.7370000000000303	51.974999999999994	179.9165944	194.66651916799998	209.77925530751997	225.25561539379203	235.07050308591616
25		Income Tax						0.164	0.426	-0.337	2.382	0.2	3.189	-0.08	1.03	-0.063	-0.33	-0.13	-0.07	-0.06	10.4552	9.457699999999999																																										3.291				-3.114						0	0	0	2	5.851	-0.9579500000000105	18.191249999999997	62.97080804	68.13328170879998	73.42273935763198	78.8394653878272	82.27467608007065
26		Net Income	-13.452999999999996	12.249000000000004	1.707999999999999	5.391999999999999	-0.5929999999999979	3.725999999999999	2.932999999999996	4.175000000000004	-14.702999999999994	-13.508000000000003	-29.735	-21.002999999999997	-1.762999999999996	5.497999999999999	-7.800000000000006	-13.59500000000001	1.035000000000002	1.045999999999999	19.416800000000002	17.5643																																										8.627000000000063				-21.927000000000042						-98.10899999999998	-66.79600000000002	5.896000000000026	10.065000000000055	-62.31000000000002	-1.7790500000000198	33.78375	116.94578636	126.5332374592	136.35651594988798	146.41615000596482	152.79582700584552	152.79582700584552	152.79582700584552	152.79582700584552	152.79582700584552	152.79582700584552	152.79582700584552	152.79582700584552	152.79582700584552	152.79582700584552	152.79582700584552	152.79582700584552	152.79582700584552	152.79582700584552	152.79582700584552	152.79582700584552	152.79582700584552	152.79582700584552	152.79582700584552	152.79582700584552	152.79582700584552	152.79582700584552	152.79582700584552	152.79582700584552	152.79582700584552	152.79582700584552	152.79582700584552	152.79582700584552	152.79582700584552	152.79582700584552	152.79582700584552	152.79582700584552	152.79582700584552	152.79582700584552	152.79582700584552	152.79582700584552
27		EPS	-0.14879991151421298	0.12680255489187262	0.017659222497932166	0.05405297030695509	-0.005944623774485212	0.03530314658480429	0.028001069253241136	0.04013111098294792	-0.1411158353408643	-0.12949240281838664	-0.2861500856477472	-0.21449361206711667	-0.01824466268588751	0.05647315008833559	-0.08140432904047262	-0.14325907816813852	0.01084201043347093	0.011023754821575353	0.20463292793457416	0.18510949982083763																																										0.05113629627873379				-0.12997166668642515						-1.1952414019955409	-0.7414034230914381	0.06054817872803666	0.10065000000000054	-0.6054040399133335	-0.018497906176973094	0.35550615595075236	1.230619660738714	1.3315083390424076	1.4348786272744183	1.5407360834048702	1.6078693781526414
28		Shares	90.41	96.599	96.72	99.754	99.754	105.543	104.746	104.034	104.191	104.315	103.914	97.919	96.631	97.356	95.818	94.898	95.462	94.886	94.886	94.886																																										168.706				168.706						82.083	90.094	97.377	100	102.923	96.17575	95.03	95.03	95.03	95.03	95.03	95.03
29
30		Gross Margin	0.8181415572912473	0.906614119259767	0.8532763532763533	0.8439442697286622	0.8188133028056968	0.8067353277750531	0.7918863057375867	0.8294368021713651	0.7769741470277877	0.7534898646841739	0.7200403195699246	0.6674209778762128	0.7051213382225702	0.7533131829807022	0.8375880145165793	0.7384615384615384	0.7396412329459323	0.6969910916377682	0.75	0.75																																																				0.5125467301684847	0.778866615873683	0.8598809324965998	0.8116391973829518	0.7308325672753245	0.74	0.76	0.77	0.78	0.79	0.8	0.8	0.08	1650.3381280117906
31		R&D % of Sales	0.8705209759239874	0.41488176833447565	0.5432662127577382	0.4676186645213194	0.5018238969304202	0.48744482589504656	0.47919503949497705	0.48928196903337234	0.7170902215969047	0.7572605230785688	1.13473456283133	0.8169912612243915	0.4585925590210539	0.3891272642725793	0.6876453984304725	0.5661082621082623	0.3534192353040256	0.41040762505970063	0.023531626506024094	0.025842464337399215																																																				2.3325907717519327	1.1962404434752911	0.5313178553532654	0.4888212864376054	0.8286653395676127	0.4704184394499499	0.22781129778570963	0.004186680394512568	0.003926177411607047	0.0036954006545845174	0.003489554655513416	0.003346293205032071	0.09	1472.711162610742
32		SG&A % of Sales	0.36041549239069165	0.19510366689513364	0.22531266599063213	0.2375118847363417	0.3207342155302883	0.2562857609939513	0.26220498934516845	0.27492134970082044	0.33855082659162855	0.38741509333048085	0.5692899275741059	0.3459881075615686	0.24568414980841333	0.20246877047621062	0.3743292285740873	0.474871794871795	0.3614620178541351	0.25479161907926157	0.023531626506024094	0.025842464337399215																																																				0.6664874276642597	0.37862228410792637	0.2408969433773175	0.276707019773717	0.39350030091199484	0.29191503516951656	0.18578292035764304	0.012560041183537705	0.011778532234821141	0.011086201963753553	0.010468663966540247	0.010038879615096212
33		Operating Margin	-0.4127949110234317	0.2966286840301577	0.08469747452798299	0.1388137204710012	-0.003744809655011794	0.06300474088605525	0.05048627689744118	0.06523348343717235	-0.2786669011607456	-0.39118575172487574	-0.9839841708355112	-0.4955583909097473	0.0008446293931029607	0.16171714823191224	-0.22438661248798059	-0.3025185185185188	0.024759979787771644	0.03179184749880597	0.7029367469879517	0.6983150713252015																																																				-2.4865314692477076	-0.7959961117095345	0.087666133766017	0.04611089117162942	-0.49133307320428304	0.008589839202072994	0.30714636063326217	0.7532532784219498	0.7642952903535718	0.775218397381662	0.7860417813779464	0.7866148271798717
34		Pretax Margin	-0.5416297608503098	0.26235863605209053	0.04123810903471918	0.0985884590068017	-0.01150607318871508	0.06359326467222494	0.053818915930975854	0.05918820553944858	-0.2708626450932113	-0.3558859710113923	-0.991040095572314	-0.5075471243891282	-0.015100325491327015	0.11487814673120415	-0.2521790378113467	-0.3128205128205131	0.020317500421088132	0.020474697344103638	0.7029367469879517	0.6983150713252015																																																				-2.512137041020125	-0.8774400336284585	0.035171442888162596	0.050278165565811904	-0.37338879813765247	-0.014684815675249516	0.30714636063326217	0.7532532784219498	0.7642952903535718	0.775218397381662	0.7860417813779464	0.7866148271798717
35		Tax Rate	0	0	0	0	0	0.04215938303341903	0.1268234593629058	-0.08780614903595614	-0.19332846359873396	-0.015028554253080851	-0.12013109319671514	0.003794526395674241	-1.4051841746248372	-0.01159153633854646	0.04059040590405901	0.009471766848816022	-0.07253886010362681	-0.060851926977687695	0.35	0.35																																																				0	0	0	0.16576875259013601	0	0	0.2	0.31	0.31	0.31	0.31	0.31
36		Net Margin	-0.5416297608503098	0.26235863605209053	0.04123810903471918	0.0985884590068017	-0.01150607318871508	0.06091221186856301	0.04699341483344809	0.06438529393621621	-0.32322810411537095	-0.36123442263464733	-1.110094825655193	-0.5056212234285851	-0.03631906390342375	0.11620976094354377	-0.2419429883060891	-0.30985754985755015	0.021791308741788824	0.021720622131777292	0.4569088855421687	0.45390479636138104																																																				-2.512137041020125	-0.8774400336284585	0.035171442888162596	0.041943616777446936	-0.41208409663573786	-0.009545130188912185	0.19964513441162043	0.48961463097426733	0.4967919387298217	0.5038919582980802	0.5109271578956652	0.5112996376669167
37
38		Risperdal Consta					0.42361111111111116	0.44099378881987583	0.3372781065088757	0.40884573894282683	0.3595121951219511	0.26551724137931054	0.30575221238938055	0.183001531393568	0.23107283817725155	0.1495231607629426	0.0803117587258555	0.05177993527508096	0.013698630136986356	0.04474074074074075	0.10602258469259729	0.0849230769230771
39		Risperdal Consta royalty					0.4259156492785794	0.44064436183395284	0.3417691579943236	0.14491228070175421	0.3586300836738665	0.2640633063822466	0.30160408954697693	0.1864848299111248	0.22901747350329416	0.14847577572128468	0.07936078006500535	0.06638253906754477	0.013984384104416936	0.044910534423509896	0.13149309912170626	0.11638609664527055																																																					1.5424802110817941	0.8230593607305938	0.31786873114362146	0.14618761600495925	0.06184490658792475	0.02730300921487241	0.011802095444168992	0.0051559756019043035	0.0022406143916692024	0.0009762760539302265
40		Manufacturing Revenue					0.5871415289994995	0.931243530977377	0.9546721032959566	0.2496361952639239	0.4201324742035777	-0.075989587321032	-0.5037026735736885	0.12114475262897884	0.2250531459212488	0.36881136843849704	0.43838879159369526	-0.22375751471467697	-0.253975653975654	-0.0061745210206120005	0.35562265621195155	-0.07408158300218948																																																					0.5732048492384207	0.6029687808733455	0.6242584860017562	0.6514866463716541	0.677195919548737	0.7053263928975794	0.7338928557301463	0.76399739486015	0.795138463882844	0.8276520918831995
41		Total Revenue					1.0749657782430146	0.31018677176148035	0.5069052102950407	0.18562129744752442	-0.11738911094726234	-0.3886872649991826	-0.5708265906141349	-0.3594010239960521	0.06713858600070344	0.2652029737391026	0.2035764951840513	0.05623630804785851	-0.021548349882576034	0.017881676565703497	0.3181550296225071	-0.11803988603988591																																																					0.9492497567470679	1.20208601529044	0.4314646018754922	-0.3698789406788491	0.23263473251899702	-0.09208994382534885	0.41150059981444165	0.06635028313682168	0.062449725643747955	0.05898918899174421
42		Gross Margin					1.0766694552433442	0.16584766584766575	0.39848900710223223	0.16524037524102542	-0.16248815165876773	-0.42903461133176624	-0.6097644868889608	-0.4845307154544102	-0.03154797272444332	0.2649063032367973	0.4000622180743505	0.1686625306593561	0.02635269370106319	-0.05822109988776658	0.18031329852238653	-0.10425925925925905																																																					1.9620822301044103	1.4311374215745807	0.3511554177332863	-0.4326136626190539	0.30025247269403743	-0.1511897388072685	0.5079704041389603	0.08019898811262438	0.07607087597251394	0.07239411543467766
43		Operating Expenses					0.3865702884804083	0.5974577759050528	0.4536173153645586	0.28494749124854146	0.1327105890123368	-0.05912867630896379	-0.013593240118427552	-0.0251241070347501	-0.2880526458276932	-0.3461125128492665	-0.24991236526158966	-0.05456540189198689	-0.006815456167549194	0.1445210618457251	-0.9415836667932354	-0.9562104525649727																																																					0.02358144220753733	0.07976611504070452	0.4190697638488694	0.005988023952095967	-0.23113636363636358	-0.5074250805849978	-0.9428473452591872	0	0	0
44		R&D					0.19614281750069362	0.5393391843056272	0.3291853695391316	0.24054740957966758	0.2612225959865444	-0.05030687191870409	0.01628326869065133	0.06965675922715664	-0.3175449891167724	-0.3498605078221563	-0.2706366178647803	-0.26811444735834034	-0.2459458245361844	0.07354698533405779	-0.9548919662591908	-0.9597391094291006																																																					-0.00035127391681388787	-0.021929391094273276	0.316971302824808	0.1	0.07500000000000001	0.05625000000000001	0.0421875	0.031640625000000006	0.023730468750000004	0.0177978515625
45		SG&A					0.8465147453083111	0.7210451202107806	0.7536433776253748	0.37236335642802176	-0.06836055656382345	-0.07590738023856602	-0.06819431714023816	-0.19380714646323005	-0.22558441558441555	-0.3387864982398011	-0.2086038428749427	0.4496938491511273	0.4395438537648835	0.280927027873473	-0.9171362280411004	-0.9520038396928245																																																					0.107341811056898	0.4010685910557541	0.6442562464403339	0.38422221618432867	0.2881666621382465	0.21612499660368487	0.16209374745276364	0.12157031058957274	0.09117773294217955	0.06838329970663466
46		Operating Income					-0.981176241100166	-0.7217127590439745	-0.10176738882554248	-0.4428345626975758	-	-	-	-5.8664302600472755	-1.0032344588198172	-1.523038009297238	-0.7255378077929959	-0.35521010444498347	-	-0.7998954385047707	-	-																																																					-0.3760001647633069	-1.242524259026999	-0.24707403375067805	-7.714234071396263	-1.0215498095379103	-	2.4615987378547386	0.0819820140392784	0.07763397734808986	0.07377450198107005
47		Net Income					-0.9559206125027876	-0.695811903012491	0.7172131147540968	-0.22570474777447969	-	-	-	-6.030658682634725	-0.8800924981296336	-1.4070180633698548	-0.7376828653102403	-0.35271151740227535	-1.587067498581965	-	-	-																																																					-0.31916541805542775	-1.0882687586083002	0.7070895522388079	-7.1907600596124865	-0.9714484031455622	-	2.461598737854738	0.08198201403927863	0.07763397734808963	0.07377450198107027
48		EPS					-0.9600495476509917	-0.7215896271576856	0.5856343197737026	-0.25755956138854075	-	-	-	-6.344821182704286	-0.870711443249316	-1.4361116857761864	-0.7155187675160023	-0.33210561942836947	-1.5942565571166942	-	-	-																																																					-0.37970403145873943	-1.081666980273126	0.6623125932835838	-7.014943267892004	-0.9694453539166651	-	2.461598737854738	0.08198201403927863	0.07763397734808963	0.07377450198107027
49		Shares					0.10335139918150649	0.09258895019617186	0.08298180314309334	0.04290554764721222	0.04447941937165423	-0.011635068171266805	-0.007943024077291638	-0.05877886075706029	-0.07255905020587194	-0.06671140296218192	-0.07791057990261185	-0.03085203076011811	-0.012097567033353629	-0.025370804059328678	-0.009726773675092337	-0.000126451558515428																																																					0.09759633541659052	0.08083779163984284	0.026936545590847905	0.01	0.01	0.01	0.01	0.01	0.01	0.01
50
51
52
53		Net Cash																	310.695	305.99600000000004	325.41280000000006	342.97710000000006																																																										342.97710000000006	459.92288636000006	586.4561238192	722.812639769088	869.2287897750529
54		Cash																	380.419	369.52500000000003
55		A/R																	27.899	33.699
56		Inventory																	20.528	18.524
57		Prepaids																	5.403	7.856
58		PP&E																	97.52	94.467
59		Other																	3.442	3.206
60		Total																	535.211	527.277
61
62		A/P																	23.888	28.272
63		D/R																	7.885999999999999	6.995
64		Debt																	69.724	63.529
65		Other																	6.846	6.45
66		SE																	426.867	422.031
67		L+SE																	535.211	527.277
68
69		Model NI																	1.035000000000002	1.045999999999999
70		Reported NI																	-10.165	-8.709
71		Stock Based Compensation																	3.23	4.208
72		Depreciation																	9.948	5.533999999999999
73		Other Non Cash Charges																	0.481	1.612
74		Change in A/R																	-3.311	-5.800000000000001
75		Change in Inventory																	1.167	-1.157
76		Change in A/P																	-11.882	3.1799999999999997
77		Change in D/R																	-4.192	-0.891
78		Change in Other Liabilities																	-0.427	-0.49300000000000005
79		Debt reconciliation																	-0.485	-0.5239999999999999
80		CFFO																	-15.635999999999997	-3.0400000000000014
81		CapEx																	-2.076	-1.6399999999999997
82		FCF																	-17.711999999999996	-4.6800000000000015