Zoho Sheet

Product Links

Languages

Themes

Feedback

Sign Up Now

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

S

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

Procter & Gamble
($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		$19,807	$19,800	$18,662	$18,417	$20,368	$20,983	$20,885	$20,026	$21,038	$20,199	$19,272	$18,694
Operating Expenses
	Cost of Goods Sold	($9,398)	($9,841)	($9,267)	($9,161)	($9,850)	($10,558)	($10,572)	($9,679)	($10,028)	($9,519)	($9,477)	($9,057)
	Depreciation
	Research & development
	Selling, General & Administrative	($5,961)	($5,940)	($5,822)	($5,526)	($6,267)	($6,039)	($6,577)	($6,334)	($6,420)	($6,262)	($6,395)	($5,991)
	Special operating charges
Operating income		$4,448	$4,019	$3,573	$3,730	$4,251	$4,386	$3,736	$4,013	$4,590	$4,418	$3,400	$3,646
	Gains on investments
	Gains on asset sales
	Net interest and other income	($264)	($80)	($289)	($243)	($263)	($59)	($289)	($354)	($196)	($166)	($192)	($110)
Income before taxes		$4,184	$3,939	$3,284	$3,487	$3,988	$4,327	$3,447	$3,659	$4,394	$4,252	$3,208	$3,536
	Provisions for income taxes	($1,157)	($985)	($813)	($902)	($1,026)	($1,212)	($497)	($1,009)	($1,200)	($1,173)	($940)	($1,024)
Net income before adjustments		$3,027	$2,955	$2,471	$2,585	$2,962	$3,115	$2,950	$2,650	$3,194	$3,079	$2,268	$2,512
	Minority interests
	Income from discontinued ops	$280			$28	$2,042	$233	$66	$60	$76
Net income		$3,307	$2,955	$2,471	$2,613	$5,004	$3,348	$3,016	$2,710	$3,270	$3,079	$2,268	$2,512
Earnings Per Share		$1.06	$0.96	$0.80	$0.84	$1.58	$1.03	$0.92	$0.82	$0.98	$0.92	$0.67	$0.74

Shares Outstanding		3109.6	3090	3097	3105	3171	3239.5	3270.1	3301	3342	3354	3378	3397
Price per share		$57.92		$51.10	$47.09	$61.82	$69.69	$60.81	$70.07	$73.42	$70.34	$61.19	$63.16
Market Value		$180,108	$0	$158,241	$146,214	$196,031	$225,761	$198,855	$231,301	$245,370	$235,920	$206,700	$214,555

Revenue growth from year-earlier		-5.6%	-5.6%	-10.6%	-8.0%	-3.2%	3.9%	8.4%	7.1%
Operating income growth from year-earlier		1.4%	-8.4%	-4.4%	-7.1%	-7.4%	-0.7%	9.9%	10.1%
Net income growth from year-earlier		-1.2%	-11.8%	-18.1%	-3.6%	53.0%	8.7%	33.0%	7.9%
EPS growth from year earlier		2.9%	-7.5%	-13.5%	2.5%	61.3%	12.6%	37.4%	11.0%

CGS/Revenue		47.4%	49.7%	49.7%	49.7%	48.4%	50.3%	50.6%	48.3%	47.7%	47.1%	49.2%	48.4%
Gross Margin		52.6%	50.3%	50.3%	50.3%	51.6%	49.7%	49.4%	51.7%	52.3%	52.9%	50.8%	51.6%
Depreciation/Revenue		0.0%	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		0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%
SG&A/Revenue		30.1%	30.0%	31.2%	30.0%	30.8%	28.8%	31.5%	31.6%	30.5%	31.0%	33.2%	32.0%
Income tax rate		27.7%	25.0%	24.8%	25.9%	25.7%	28.0%	14.4%	27.6%	27.3%	27.6%	29.3%	29.0%


Revenue (TTM)		$77,254	$77,247	$78,430	$80,653	$82,262	$82,932	$82,148	$80,535	$79,203
Net Income (TTM)		$13,395	$13,043	$13,436	$13,981	$14,078	$12,344	$12,075	$11,327	$11,129
EPS (TTM)		$4.29	$4.19	$4.26	$4.37	$4.34	$3.75	$3.64	$3.39	$3.30

Revenue growth year-on-year		-6.8%	-6.9%	-4.5%	0.1%	3.9%	N/A	N/A	N/A	N/A
Net Income growth year-on-year		8.5%	5.7%	11.3%	23.4%	26.5%	N/A	N/A	N/A	N/A

Price/Revenue (TTM)		2.3	0.0	2.0	1.8	2.4	2.7	2.4	2.9	3.1
Price/Earnings (TTM)		13.4	0.0	11.8	10.5	13.9	18.3	16.5	20.4	22.0

Sheet1

Sheet2

Sheet3

Processing...