Zoho Sheet

PEP: 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

PepsiCo ($M)

13 Jun 2009

13 Jun 2009

21 Mar 2009

27 Dec 2008

6 Sep 2008

14 Jun 2008

22 Mar 2008

29 Dec 2007

8 Sep 2007

16 Jun 2007

24 Mar 2007

		(actual)	(predicted)	(actual)	(actual)	(actual)	(actual)	(actual)	(actual)	(actual)	(actual)	(actual)
Revenue		$10,592	$10,890	$8,263	$12,729	$11,244	$10,945	$8,333	$12,346	$10,171	$9,607	$7,350
Operating Expenses
	Cost of Goods Sold	($4,881)	($4,977)	($3,744)	($6,171)	($5,268)	($5,078)	($3,834)	($5,784)	($4,627)	($4,342)	($3,285)
	Depreciation
	Research & development
	Selling, General & Administrative	($3,507)	($3,703)	($2,921)	($5,324)	($3,979)	($3,658)	($2,934)	($4,811)	($3,467)	($3,295)	($2,635)
	Special operating charges	($14)	($15)	($10)	($21)	($13)	($18)	($12)	($21)	($15)	($11)	($11)
Operating income		$2,190	$2,196	$1,588	$1,213	$1,984	$2,191	$1,553	$1,730	$2,062	$1,959	$1,419
	Gains on investments	$119	$25	$25	($65)	$201	$168	$70	$95	$218	$173	$74
	Gains on asset sales
	Net interest and other income	($73)	($110)	($98)	($136)	($59)	($36)	($57)	($28)	($36)	($15)	($20)
Income before taxes		$2,236	$2,111	$1,515	$1,012	$2,126	$2,323	$1,566	$1,797	$2,244	$2,117	$1,473
	Provisions for income taxes	($568)	($549)	($374)	($293)	($550)	($618)	($418)	($535)	($501)	($560)	($377)
Net income before adjustments		$1,668	$1,562	$1,141	$719	$1,576	$1,705	$1,148	$1,262	$1,743	$1,557	$1,096
	Minority interests	($8)		($6)			($6)
	Income from discontinued ops
Net income		$1,660	$1,562	$1,135	$719	$1,576	$1,699	$1,148	$1,262	$1,743	$1,557	$1,096
Earnings Per Share		$1.06	$1.00	$0.72	$0.46	$0.99	$1.05	$0.70	$0.77	$1.06	$0.94	$0.66

Shares Outstanding		1572	1565	1570	1578	1593	1612	1632	1645	1651	1665	1673
Price per share		$54.96		$51.48	$54.77	$71.27	$63.59	$72.20	$75.90	$73.26	$64.85	$63.56
Market Value		$86,397	$0	$80,824	$86,427	$113,533	$102,507	$117,830	$124,856	$120,952	$107,975	$106,336

Revenue growth from year-earlier		-3.2%	-0.5%	-0.8%	3.1%	10.5%	13.9%	13.4%
Operating income growth from year-earlier		0.0%	0.2%	2.3%	-29.9%	-3.8%	11.8%	9.4%
Net income growth from year-earlier		-2.3%	-8.1%	-1.1%	-43.0%	-9.6%	9.1%	4.7%
EPS growth from year earlier		0.2%	-5.3%	2.8%	-40.6%	-6.3%	12.7%	7.4%

CGS/Revenue		46.1%	45.7%	45.3%	48.5%	46.9%	46.4%	46.0%	46.8%	45.5%	45.2%	44.7%
Gross Margin		53.9%	54.3%	54.7%	51.5%	53.1%	53.6%	54.0%	53.2%	54.5%	54.8%	55.3%
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		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		33.1%	34.0%	35.4%	41.8%	35.4%	33.4%	35.2%	39.0%	34.1%	34.3%	35.9%
Income tax rate		25.4%	26.0%	24.7%	29.0%	25.9%	26.6%	26.7%	29.8%	22.3%	26.5%	25.6%


Revenue (TTM)		$42,828	$43,126	$43,181	$43,251	$42,868	$41,795	$40,457	$39,474
Net Income (TTM)		$5,090	$4,992	$5,129	$5,142	$5,685	$5,852	$5,710	$5,658
EPS (TTM)		$3.23	$3.17	$3.23	$3.21	$3.51	$3.58	$3.46	$3.41

Revenue growth year-on-year		2.5%	3.2%	6.7%	9.6%	N/A	N/A	N/A	N/A
Net Income growth year-on-year		-13.0%	-14.7%	-10.2%	-9.1%	N/A	N/A	N/A	N/A

Price/Revenue (TTM)		2.0	0.0	1.9	2.0	2.6	2.5	2.9	3.2
Price/Earnings (TTM)		17.0	0.0	15.8	16.8	20.0	17.5	20.6	22.1

Sheet1

Sheet2

Sheet3

powered by ZOHOSheet

Processing...