Zoho Sheet - PG: Income Statement-2009Q3

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

PG: Income Statement-2009Q3

Sheet1

Sheet2

Sheet3