Zoho Sheet

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

Conoco Phillips ($M)		30 Sep 2009	30 Sep 2009	30 Jun 2009	31 Mar 2009	31 Dec 2008	30 Sep 2008	30 Jun 2008	31 Mar 2008	31 Dec 2007	30 Sep 2007	30 Jun 2007	31 Mar 2007
		(actual)	(predicted)	(actual)	(actual)	(actual)	(actual)	(actual)	(actual)	(actual)	(actual)	(actual)	(actual)
Revenue		$40,173	$41,000	$35,448	$30,741	$44,504	$70,044	$71,411	$54,883	$52,685	$46,062	$47,370	$41,320
Operating Expenses
	Cost of Goods Sold	($30,542)	($31,160)	($27,182)	($22,304)	($32,978)	($52,667)	($54,325)	($40,511)	($38,046)	($33,482)	($33,377)	($29,207)
	Depreciation	($2,327)	($2,400)	($2,347)	($2,230)	($2,264)	($2,361)	($2,178)	($2,209)	($2,206)	($2,052)	($2,016)	($2,024)
	Exploration	($386)	($250)	($243)	($225)	($473)	($267)	($288)	($309)	($268)	($218)	($259)	($262)
	Selling, General & Administrative	($4,632)	($4,510)	($4,191)	($3,939)	($4,628)	($6,132)	($6,425)	($5,681)	($5,942)	($5,152)	($5,301)	($4,901)
	Special operating charges	($135)	($200)	($17)	($238)	($27,257)	($225)	($115)	($67)	($254)	($249)	($4,588)	($79)
Operating income		$2,151	$2,480	$1,468	$1,805	($23,096)	$8,392	$8,080	$6,106	$5,969	$4,909	$1,829	$4,847
	Gains on investments	$1,015	$900	$1,076	$415	($7,545)	$1,214	$1,812	$1,359	$1,338	$1,314	$1,506	$929
	Gains on asset sales
	Net interest and other income	($219)	($200)	($162)	($186)	$256	($124)	($80)	$103	$39	$166	$202	$311
Income before taxes		$2,947	$3,180	$2,382	$2,034	($30,385)	$9,482	$9,812	$7,568	$7,346	$6,389	$3,537	$6,087
	Provisions for income taxes	($1,427)	($1,399)	($1,068)	($1,178)	($1,360)	($4,279)	($4,356)	($3,410)	($2,953)	($2,691)	($3,217)	($2,520)
Net income before adjustments		$1,520	$1,781	$1,314	$856	($31,745)	$5,203	$5,456	$4,158	$4,393	$3,698	$320	$3,567
	Minority interests	($17)	($20)	($16)	($16)	($19)	($15)	($17)	($19)	($22)	($25)	($19)	($21)
	Income from discontinued ops
Net income		$1,503	$1,761	$1,298	$840	($31,764)	$5,188	$5,439	$4,139	$4,371	$3,673	$301	$3,546
Earnings Per Share		$1.00	$1.17	$0.87	$0.56	($21.38)	$3.40	$3.50	$2.62	$2.71	$2.23	$0.18	$2.12

Shares Outstanding		1498	1500	1496	1495	1486	1528	1555	1582	1612	1644	1658	1669
Price per share		$45.16		$42.06	$39.16	$51.80	$73.25	$94.39	$76.21	$88.30	$87.77	$78.50	$68.35
Market Value		$67,659	$0	$62,909	$58,554	$76,975	$111,926	$146,776	$120,564	$142,340	$144,294	$130,153	$114,076

Revenue growth from year-earlier		-42.6%	-41.5%	-50.4%	-44.0%	-15.5%	52.1%	50.8%	32.8%
Operating income growth from year-earlier		-74.4%	-70.4%	-81.8%	-70.4%	N/A	71.0%	341.8%	26.0%
Net income growth from year-earlier		-71.0%	-66.1%	-76.1%	-79.7%	N/A	41.2%	1707.0%	16.7%
EPS growth from year earlier		-70.5%	-65.4%	-75.2%	-78.5%	N/A	52.0%	1826.7%	23.1%

CGS/Revenue		76.0%	76.0%	76.7%	72.6%	74.1%	75.2%	76.1%	73.8%	72.2%	72.7%	70.5%	70.7%
Gross Margin		24.0%	24.0%	23.3%	27.4%	25.9%	24.8%	23.9%	26.2%	27.8%	27.3%	29.5%	29.3%
Depreciation/Revenue		5.8%	5.9%	6.6%	7.3%	5.1%	3.4%	3.0%	4.0%	4.2%	4.5%	4.3%	4.9%
R&D/Revenue		1.0%	0.6%	0.7%	0.7%	1.1%	0.4%	0.4%	0.6%	0.5%	0.5%	0.5%	0.6%
SG&A/Revenue		11.5%	11.0%	11.8%	12.8%	10.4%	8.8%	9.0%	10.4%	11.3%	11.2%	11.2%	11.9%
Income tax rate		48.4%	44.0%	44.8%	57.9%	N/A	45.1%	44.4%	45.1%	40.2%	42.1%	91.0%	41.4%


Revenue (TTM)		$150,866	$151,693	$180,737	$216,700	$240,842	$249,023	$225,041	$201,000	$187,437
Net Income (TTM)		($28,123)	N/A	N/A	N/A	N/A	$19,137	$17,622	$12,484	$11,891
EPS (TTM)		($18.83)	$0.00	$0.00	$0.00	$0.00	$12.19	$11.03	$7.69	$7.23

Revenue growth year-on-year		-39.42%	-39.08%	-19.69%	7.81%	28.49%	N/A	N/A	N/A	N/A
Net Income growth year-on-year		N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A

Price/Revenue (TTM)		0.45	0	0.35	0.27	0.32	0.45	0.65	0.6	0.76
Price/Earnings (TTM)		-2.41	N/A	N/A	N/A	N/A	5.85	8.33	9.66	11.97

Sheet1

Sheet2

Sheet3