Hi, 
 
I'd like to have quarterly and annual earnings (with the relevant 
month) for Hansen, Coca-Cola, and Pepsico from 1999 to 2002. 
 
Thanks!

Reese:

It is very difficult to get the formatting correct in the GA answer
box for tabular data.  Researchers have an upload link which gives you
the following information in an Excel file. You may follow this link
at:
      http://www.lucidmatrix.com/uploads/answerspepsico.XLS

The following data is in that Excel file.  You may notice some
differences in teh Pepsico data.  It was taken from
http://www.pepsico.com  This complicated corporation has lots of
transactions and adjustments which make the data change from time to
time.  To maintain sanity, I took the data consistently from the
quarterly (pro forma) which may differ slightly from the final
results.

If you need clarification on this information, please don't hesitate
to ask.

Hansen Natural Corporation		(Sales in Millions for Hansen Corporation)
						
	1999					
						
Net Sales		15229	19142	20491	17441	72303
Earnings		909	1440	1337	-123	3563
Earnings % to Net Sales		6.0%	7.5%	6.5%	-0.7%	4.9%
EPS (diluted)		0.09	0.14	0.13	0.07	0.43
						
	2000					
						
Net Sales		15978	22667	22701	18386	79732
Earnings		688	1652	1365	210	3915
Earnings % to Net Sales		4.3%	7.3%	6.0%	1.1%	4.9%
EPS (diluted)		0.07	0.16	0.13	0.02	0.38
						
	2001					
						
Net Sales		18769	25715	26180	21616	92280
Earnings		325	1108	1259	327	3019
Earnings % to Net Sales		1.7%	4.3%	4.8%	1.5%	3.3%
EPS (diluted)		0.03	0.11	0.12	0.03	0.29
						
	2001					
						
Net Sales		22507	32667			
Earnings		411	1270			
Earnings % to Net Sales		1.8%	3.9%			
EPS (diluted)		0.04	0.12			
						
						
PEPSICO		(Sales in Billions for Pepsico)				
	1999					
						
Net Sales		5114	4982	4594	3554	18244
Earnings		333	743	484	490	2050
Earnings % to Net Sales		6.5%	14.9%	10.5%	13.8%	11.2%
EPS (diluted)		0.23	0.49	0.32	0.36	1.40
						
	2000					
						
Net Sales		4191	4928	4909	6116	20144
Earnings		422	563	587	567	2139
Earnings % to Net Sales		10.1%	11.4%	12.0%	9.3%	10.6%
EPS (diluted)		0.29	0.38	0.4	0.38	1.45
						
	2001					
						
Net Sales		4539	5281	6906	7986	24712
Earnings		498	652	866	764	2780
Earnings % to Net Sales		11.0%	12.3%	12.5%	9.6%	11.2%
EPS (diluted)		0.34	0.45	0.48	0.42	1.69
						
	2001					
						
Net Sales		5101	6178			
Earnings		681	940			
Earnings % to Net Sales		13.4%	15.2%			
EPS (diluted)		0.38	0.52			


Coca-Cola Corporation		(Sales in Billions for Coca Cola)				
	1999					
						
Net Sales		4400	5335	5139	4931	19805
Earnings		747	942	787	-45	2431
Earnings % to Net Sales		17.0%	17.7%	15.3%	-0.9%	12.3%
EPS (diluted)		0.31	0.37	0.32	-0.02	0.98
						
	2000					
						
Net Sales		4256	5621	5543	4903	20323
Earnings		-58	926	1067	242	2177
Earnings % to Net Sales		-1.4%	16.5%	19.2%	4.9%	10.7%
EPS (diluted)		-0.02	0.38	0.43	0.1	0.89
						
	2001					
						
Net Sales		4479	5293	5397	4923	20092
Earnings		863	1118	1074	914	3969
Earnings % to Net Sales		19.3%	21.1%	19.9%	18.6%	19.8%
EPS (diluted)		0.35	0.45	0.43	0.37	1.60
						
	2001					
						
Net Sales		4079	5368			
Earnings		-125	1290			
Earnings % to Net Sales		-3.1%	24.0%			
EPS (diluted)		-0.05	0.52

---

Clarification of Answer by seedy-ga on 25 Sep 2002 05:03 PDT

Search critera were listed on your previous question. 

The uplink area shown in the anwer purges after 30 days so be sure to
download it if you want to save it.

seedy

thanks!! that was perfect and very timely.