Zoho Sheet

INTC: Income Statement-2009Q2

Save As Excel |

Loading...

Updating...

Please wait to edit...

Ready for editing X

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

1

2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62

Intel
($M)

27 Jun 2009

27 Jun 2009

28 Mar 2009

27 Dec 2008

27 Sep 2008

28 Jun 2008

29 Mar 2008

29 Dec 2007

29 Sep 2007

30 Jun 2007

31 Mar 2007

		(actual)	(predicted)	(actual)	(actual)	(actual)	(actual)	(actual)	(actual)	(actual)	(actual)	(actual)
Revenue		$8,024	$7,502	$7,145	$8,226	$10,217	$9,470	$9,673	$10,712	$10,090	$8,680	$8,852
Operating Expenses
	Cost of Goods Sold	($3,945)	($4,029)	($3,907)	($3,857)	($4,198)	($4,221)	($4,466)	($4,486)	($4,919)	($4,605)	($4,420)
	Depreciation
	Research & development	($1,303)	($1,317)	($1,317)	($1,316)	($1,471)	($1,468)	($1,467)	($1,481)	($1,521)	($1,353)	($1,400)
	Selling, General & Administrative	($1,250)	($1,200)	($1,200)	($1,263)	($1,416)	($1,430)	($1,349)	($1,464)	($1,381)	($1,290)	($1,282)
	Special operating charges	($1,538)	($115)	($74)	($251)	($34)	($96)	($329)	($234)	($125)	($82)	($75)
Operating income		($12)	$842	$647	$1,539	$3,098	$2,255	$2,062	$3,047	$2,144	$1,350	$1,675
	Gains on investments	($69)	($250)	($113)	($1,192)	($396)	($109)	($59)	($19)	$148	($1)	$29
	Gains on asset sales
	Net interest and other income	$31	$100	$95	$22	$131	$167	$168	$233	$211	$180	$169
Income before taxes		($50)	$692	$629	$369	$2,833	$2,313	$2,171	$3,261	$2,503	$1,529	$1,873
	Provisions for income taxes	($348)	($166)	$0	($135)	($819)	($712)	($728)	($990)	($712)	($251)	($237)
Net income before adjustments		($398)	$526	$629	$234	$2,014	$1,601	$1,443	$2,271	$1,791	$1,278	$1,636
	Minority interests
	Income from discontinued ops
Net income		($398)	$526	$629	$234	$2,014	$1,601	$1,443	$2,271	$1,791	$1,278	$1,636
Earnings Per Share		($0.07)	$0.09	$0.11	$0.04	$0.35	$0.28	$0.25	$0.38	$0.30	$0.22	$0.28

Shares Outstanding		5595	5650	5634	5623	5692	5800	5879	5988	5967	5917	5874
Price per share		$16.55		$15.03	$14.66	$18.73	$21.48	$21.18	$26.66	$25.86	$23.74	$19.13
Market Value		$92,597	$0	$84,679	$82,433	$106,611	$124,584	$124,517	$159,640	$154,307	$140,470	$112,370

Revenue growth from year-earlier		-15.3%	-20.8%	-26.1%	-23.2%	1.3%	9.1%	9.3%
Operating income growth from year-earlier		N/A	-62.7%	-68.6%	-49.5%	44.5%	67.0%	23.1%
Net income growth from year-earlier		N/A	-67.2%	-56.4%	-89.7%	12.5%	25.3%	-11.8%
EPS growth from year earlier		N/A	-66.3%	-54.5%	-89.0%	17.9%	27.8%	-11.9%

CGS/Revenue		49.2%	53.7%	54.7%	46.9%	41.1%	44.6%	46.2%	41.9%	48.8%	53.1%	49.9%
Gross Margin		50.8%	46.3%	45.3%	53.1%	58.9%	55.4%	53.8%	58.1%	51.2%	46.9%	50.1%
Depreciation/Revenue		0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%
R&D/Revenue		16.2%	17.6%	18.4%	16.0%	14.4%	15.5%	15.2%	13.8%	15.1%	15.6%	15.8%
SG&A/Revenue		15.6%	16.0%	16.8%	15.4%	13.9%	15.1%	13.9%	13.7%	13.7%	14.9%	14.5%
Income tax rate		N/A	24.0%	0.0%	36.6%	28.9%	30.8%	33.5%	30.4%	28.4%	16.4%	12.7%


Revenue (TTM)		$33,612	$33,090	$35,058	$37,586	$40,072	$39,945	$39,155	$38,334
Net Income (TTM)		$2,479	$3,403	$4,478	$5,292	$7,329	$7,106	$6,783	$6,976
EPS (TTM)		$0.44	$0.60	$0.79	$0.92	$1.26	$1.20	$1.14	$1.18

Revenue growth year-on-year		-15.9%	-17.2%	-10.5%	-2.0%	N/A	N/A	N/A	N/A
Net Income growth year-on-year		-65.1%	-52.1%	-34.0%	-24.1%	N/A	N/A	N/A	N/A

Price/Revenue (TTM)		2.8	0.0	2.4	2.2	2.7	3.1	3.2	4.2
Price/Earnings (TTM)		37.4	0.0	18.9	15.6	14.5	17.5	18.4	22.9

Sheet1

Sheet2

Sheet3

powered by ZOHOSheet

Processing...