HD Income Statement
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
HD Income Statement
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
Edit
|
Publish
|
Revert Publish
|
URL
|
Clone
Home Depot ($M)
1 Feb 2009
2 Nov 2008
3 Aug 2008
4 May 2008
3 Feb 2008
(predicted)
(actual)
(actual)
(actual)
(actual)
Revenue
$14,480
$17,784
$20,990
$17,907
$17,659
Operating Expenses
Cost of Goods Sold
($9,673)
($11,790)
($14,026)
($11,835)
($11,605)
Depreciation
($450)
($446)
($452)
($444)
($452)
Research & development
$0
$0
$0
$0
$0
Selling, General & Administrative
($3,620)
($4,225)
($4,470)
($4,357)
($4,353)
Special operating charges
($390)
$0
$0
($543)
$0
Operating income
$347
$1,323
$2,042
$728
$1,249
Gains on investments
($163)
$0
$0
$0
$0
Gains on asset sales
$0
$0
$0
$0
$0
Net interest and other income
($170)
($151)
($157)
($164)
($192)
Income before taxes
$14
$1,172
$1,885
$564
$1,057
Provisions for income taxes
($5)
($416)
($683)
($208)
($386)
Net income before adjustments
$9
$756
$1,202
$356
$671
Minority interests
$0
$0
$0
$0
$0
Income from discontinued ops
($55)
$0
$0
$0
$0
Net income
($46)
$756
$1,202
$356
$671
Earnings Per Share
-$0.03
$0.45
$0.71
$0.21
$0.40
Shares Outstanding
1690
1687
1685
1683
1680
Revenue growth from year-earlier
-18.0%
Operating income growth from year-earlier
-72.2%
Net income growth from year-earlier
-106.9%
EPS growth from year earlier
-106.8%
CGS/Revenue
66.8%
66.3%
66.8%
66.1%
65.7%
Gross Margin
33.2%
33.7%
33.2%
33.9%
34.3%
Depreciation/Revenue
3.1%
2.5%
2.2%
2.5%
2.6%
R&D/Revenue
0.0%
0.0%
0.0%
0.0%
0.0%
SG&A/Revenue
25.0%
23.8%
21.3%
24.3%
24.7%
Income tax rate
37.2%
35.5%
36.2%
36.9%
36.5%
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