EIX: Income Statement-2009Q2
Save As Excel
|
Full Screen View
Exit Full Screen View
Coriander Green
Metallic Grey
Coriander Green
Metallic Grey
Loading...
Updating...
Please wait to edit...
Ready for editing
X
Local File
URL
Name of the Document:
Note:-
- Supported file formats: xls, xlsx, sxc, ods, csv and tsv
- Only unprotected files will be imported
CSV files have data in a structured format similar to a database table. Choose the desired import option based on the recommendations provided below:
Import as...
Tabular Data
Recommended for...
- Creating PIVOT Tables and Charts
- Faster loading and performance
- Auto Filters and Freeze Columns
Normal Spreadsheet
Useful for...
- Formatting options
- Formulas & Calculations, and
- Other regular spreadsheet operations
NOTE:
There will be no option inside the document to toggle between these two views.
Spreadsheet Name:
Template Name:
Save As New Document...
Save As New Template...
Mark As New Version...
New Template
From Templates List
Show Text Only
Show Icons Only
Show Icons & Text
EIX: Income Statement-2009Q2
by
ncarvin
1 view
Print
Export
Copy to My Account
Embed in Website/Blog
Tags:
Macro recorded successfully
View Macro
Macros List
|
Unsupported actions
|
Macro Recording in progress
Stop Recording
Cancel
|
Unsupported actions
|
Arial
Arial Black
Book Antiqua
Calibri
Comic Sans MS
Courier New
Garamond
Georgia
Lucida Console
MingLiU
MS Gothic
MS P Gothic
MS Mincho
MS P Mincho
MS Sans Serif
SimHei
Tahoma
Times New Roman
Trebuchet MS
Verdana
8
9
10
11
12
14
16
18
20
24
26
$
Macros
Auto Filter
Freeze Columns
This worksheet is a tabular data. Regular spreadsheet operations like cut/copy/paste, undo/redo, range selection, formulas and formatting are restricted in this mode.
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
Edit
|
Publish
|
Revert Publish
|
URL
|
Clone
Edison Int'l ($M)
30 Jun 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)
Revenue
$2,834
$3,023
$2,812
$3,228
$4,111
$3,477
$3,113
$3,144
$3,942
$3,047
$2,912
Operating Expenses
Cost of Goods Sold
($1,985)
($2,176)
($1,896)
($2,394)
($2,885)
($2,693)
($2,191)
($2,355)
($2,733)
($2,233)
($1,972)
Depreciation
($347)
($340)
($342)
($338)
($262)
($334)
($311)
($306)
($310)
($313)
($313)
Research & development
Selling, General & Administrative
Special operating charges
($866)
($300)
($21)
($30)
$0
$0
$17
($2)
$0
Operating income
($364)
$206
$553
$466
$964
$450
$628
$481
$899
$501
$627
Gains on investments
$6
($10)
($8)
($9)
$31
$9
$2
$7
$35
$20
$17
Gains on asset sales
$1
$56
($1)
Net interest and other income
($152)
($160)
($157)
($147)
($226)
($134)
($144)
($138)
($123)
($371)
($153)
Income before taxes
($510)
$36
$388
$310
$770
$381
$486
$350
$810
$150
$491
Provisions for income taxes
$524
($11)
($122)
($75)
($277)
($83)
($161)
($100)
($263)
$0
($129)
Net income before adjustments
$14
$25
$266
$235
$493
$298
$325
$250
$547
$150
$362
Minority interests
($23)
($20)
($19)
($18)
($60)
($36)
($21)
($36)
($82)
($59)
($32)
Income from discontinued ops
($7)
$3
$6
($1)
($5)
($3)
($4)
$2
$3
Net income
($16)
$5
$250
$217
$439
$261
$299
$211
$461
$93
$333
Earnings Per Share
($0.05)
$0.02
$0.76
$0.66
$1.34
$0.79
$0.91
$0.64
$1.40
$0.28
$1.01
Shares Outstanding
327
327
327
328
328
329
329
330
330
330
330
Price per share
$31.46
$28.81
$32.12
$39.90
$51.38
$49.02
$53.37
$55.45
$56.12
$49.13
Market Value
$10,287
$0
$9,421
$10,535
$13,087
$16,904
$16,128
$17,612
$18,299
$18,520
$16,213
Revenue growth from year-earlier
-18.5%
-13.1%
-9.7%
2.7%
4.3%
14.1%
6.9%
Operating income growth from year-earlier
N/A
-54.1%
-11.9%
-3.1%
7.2%
-10.2%
0.2%
Net income growth from year-earlier
N/A
-98.0%
-16.4%
2.8%
-4.8%
180.6%
-10.2%
EPS growth from year earlier
N/A
-98.0%
-15.9%
3.5%
-4.2%
181.5%
-9.9%
CGS/Revenue
70.0%
72.0%
67.4%
74.2%
70.2%
77.5%
70.4%
74.9%
69.3%
73.3%
67.7%
Gross Margin
30.0%
28.0%
32.6%
25.8%
29.8%
22.5%
29.6%
25.1%
30.7%
26.7%
32.3%
Depreciation/Revenue
12.2%
11.2%
12.2%
10.5%
6.4%
9.6%
10.0%
9.7%
7.9%
10.3%
10.7%
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
0.0%
0.0%
0.0%
0.0%
0.0%
0.0%
0.0%
0.0%
0.0%
0.0%
0.0%
Income tax rate
N/A
31.0%
31.4%
24.2%
36.0%
21.8%
33.1%
28.6%
32.5%
0.0%
26.3%
Revenue (TTM)
$12,985
$13,174
$13,628
$13,929
$13,845
$13,676
$13,246
$13,045
Net Income (TTM)
N/A
$911
$1,167
$1,216
$1,210
$1,232
$1,064
$1,098
EPS (TTM)
$0.00
$2.78
$3.56
$3.70
$3.68
$3.74
$3.23
$3.33
Revenue growth year-on-year
-5.05%
-3.67%
2.88%
6.78%
N/A
N/A
N/A
N/A
Net Income growth year-on-year
N/A
-26.05%
9.68%
10.75%
N/A
N/A
N/A
N/A
Price/Revenue (TTM)
0.79
0
0.69
0.76
0.95
1.24
1.22
1.35
Price/Earnings (TTM)
N/A
0
8.07
8.66
10.82
13.72
15.16
16.04
Sheet1
Sheet2
Sheet3
0
Export (.xls)
Export (.pdf)
Export (.xls)
Export (.pdf)
Export (.xls)
Export (.pdf)
powered by
Z
O
H
O
Sheet
Processing...
Assign Macro
Change Macro
View Code
Edit Label
More