Downside's financial data extraction

Connecting to database

HASBRO INC

SEC Form 10-Q filed 2010-07-30 for the period ending 2010-06-27

(Debug messages on)

Selected tables from the SEC filing

Table 0

Table column format standardization was unsuccessful.

HASBRO, INC. AND SUBSIDIARIES

Consolidated Balance Sheets

(Thousands of Dollars Except Share Data)

(Unaudited)

Unable to find the column headers.

Table internal representation dump (debug use)

First numeric data row: 0
First row with column header attributes: 
Last row with column header attributes:  

Row 0
    [0..0)   [0..0] (stub): 'HASBRO, INC. AND SUBSIDIARIES'

Row 1
    [0..0)   [0..0] (stub): 'Consolidated Balance Sheets'

Row 2
    [0..0)   [0..0] (stub): '(Thousands of Dollars Except Share Data)'

Row 3
    [0..0)   [0..0] (stub): '(Unaudited)'



Prototype ranges:
Row 3
    [0..0)   [0..0] (stub): ''

Best data column prototype:
Row 3
    [0..0)   [0..0] (stub): ''

Table attributes: balancesheet

Table 1

Table column format standardization was unsuccessful.

HASBRO, INC. AND SUBSIDIARIES

Consolidated Balance Sheets (continued)

(Thousands of Dollars Except Share Data)

(Unaudited)

Unable to find the column headers.

Table internal representation dump (debug use)

First numeric data row: 0
First row with column header attributes: 
Last row with column header attributes:  

Row 0
    [0..0)   [0..0] (stub): 'HASBRO, INC. AND SUBSIDIARIES'

Row 1
    [0..0)   [0..0] (stub): 'Consolidated Balance Sheets (continued)'

Row 2
    [0..0)   [0..0] (stub): '(Thousands of Dollars Except Share Data)'

Row 3
    [0..0)   [0..0] (stub): '(Unaudited)'



Prototype ranges:
Row 3
    [0..0)   [0..0] (stub): ''

Best data column prototype:
Row 3
    [0..0)   [0..0] (stub): ''

Table attributes: balancesheet

Table 2

Financial table in standard format

HASBRO, INC. AND SUBSIDIARIES
Consolidated Statements of Operations
(Thousands of Dollars Except Per Share Data)
(Unaudited)


	Quarter Ended					Six Months Ended
	-----------------------------------					------------------------------------
	June 27, 2010			June 28, 2009		June 27, 2010		June 28, 2009
	-------------------			------------------		-------------------		-------------------
Net revenues	$	737,791		792,202		1,410,162		1,413,542
Costs and expenses
Cost of sales		300,322		319,452		563,001		564,205
Royalties		50,052		73,826		93,834		128,279
Product development		47,466		43,529		87,790		80,660
Advertising		71,998		81,677		143,172		143,986
Amortization		11,315		18,792		22,699		38,679
Selling, distribution and administration		176,912		181,853		350,613		343,443
		------------		------------		------------		------------
Total costs and expenses		658,065		719,129		1,261,109		1,299,252
		------------		------------		------------		------------
Operating profit		79,726		73,073		149,053		114,290
		------------		------------		------------		------------
Nonoperating (income) expense
Interest expense		21,922		17,503		38,714		27,218
Interest income		(2,106	)	(739	)	(2,936	)	(2,004	)
Other (income) expense, net		(1,127	)	(545	)	(1,992	)	3,635
		------------		------------		------------		------------
Total nonoperating expense, net		18,689		16,219		33,786		28,849
		------------		------------		------------		------------
Earnings before income taxes		61,037		56,854		115,267		85,441
Income taxes		17,406		17,579		12,693		26,436
		------------		------------		------------		------------
Net earnings	$	43,631		39,275		102,574		59,005
		=======		=======		=======		=======

Net earnings per common share
Basic	$	0.30		0.28		0.73		0.42
		=======		=======		=======		=======
Diluted	$	0.29		0.26		0.69		0.40
		=======		=======		=======		=======
Cash dividends declared per
common share	$	0.25		0.20		0.50		0.40
		=======		=======		=======		=======

HASBRO INC CIK:46080
	2010-03-27 to 2010-06-27 (3-months)	2009-03-28 to 2009-06-28 (3-months)	2009-12-27 to 2010-06-27 (6-months)	2008-12-28 to 2009-06-28 (6-months)

Net revenues	$737,791	792,202	1,410,162	1,413,542
Costs and expenses
Cost of sales	300,322	319,452	563,001	564,205
Royalties	50,052	73,826	93,834	128,279
Product development	47,466	43,529	87,790	80,660
Advertising	71,998	81,677	143,172	143,986
Amortization	11,315	18,792	22,699	38,679
Selling, distribution and administration	176,912	181,853	350,613	343,443

Total costs and expenses	658,065	719,129	1,261,109	1,299,252

Operating profit	79,726	73,073	149,053	114,290

Nonoperating (income) expense
Interest expense	21,922	17,503	38,714	27,218
Interest income	(2,106)	(739)	(2,936)	(2,004)
Other (income) expense, net	(1,127)	(545)	(1,992)	3,635

Total nonoperating expense, net	18,689	16,219	33,786	28,849

Earnings before income taxes	61,037	56,854	115,267	85,441
Income taxes	17,406	17,579	12,693	26,436

Net earnings	$43,631	39,275	102,574	59,005

Net earnings per common share
Basic	$0.30	0.28	0.73	0.42

Diluted	$0.29	0.26	0.69	0.40

Cash dividends declared per
common share	$0.25	0.20	0.50	0.40

Table 3

Financial table in standard format

Item 6. Exhibits (continued)
	4.5	Second Supplemental Indenture, dated as of May 13, 2009, between the Company and the Bank of Nova Scotia Trust Company of New York. (Incorporated by reference to Exhibit 4.1 to the Companys Current Report on Form 8-K filed May 13, 2009, File No. 1-6682.)

	4.6	Third Supplemental Indenture, dated as of March 11, 2010, between the Company and the Bank of Nova Scotia Trust Company of New York. (Incorporated by reference to Exhibit 4.1 to the Companys Current Report on Form 8-K filed March 11, 2010, File No. 1-6682.)

	4.7	Revolving Credit Agreement, dated as of June 23, 2006, by and among Hasbro, Inc., Hasbro SA, Bank of America, N.A., Citizens Bank of Massachusetts, Commerzbank AG, New York and Grand Cayman Branches, BNP Paribas, Banc of America Securities LLC and the other banks party thereto. (Incorporated by reference to Exhibit 10.1 to the Companys Current Report on Form 8-K dated June 23, 2006, File No. 1-6682.)

	12	Computation of Ratio of Earnings to Fixed Charges
		Quarter Ended June 27, 2010.

	31.1	Certification of the Chief Executive Officer Pursuant to Rule 13a-14(a) under the Securities Exchange Act of 1934.

	31.2	Certification of the Chief Financial Officer Pursuant to Rule 13a-14(a) under the Securities Exchange Act of 1934.

	32.1*	Certification of the Chief Executive Officer Pursuant to Rule 13a-14(b) under the Securities Exchange Act of 1934.

	32.2*	Certification of the Chief Financial Officer Pursuant to Rule 13a-14(b) under the Securities Exchange Act of 1934.

	101*	The following materials from the Companys Quarterly Report on Form 10-Q for the quarter ended June 27, 2010, formatted in Extensible Business Reporting Language (XBRL): (i) the Consolidated Balance Sheets, (ii) the Consolidated Statements of Operations, (iii) the Consolidated Statements of Cash Flows, (iv) the Consolidated Statements of Comprehensive Earnings and (v) the Condensed Notes to Consolidated Financial Statements, tagged as blocks of text.

		* Furnished herewith.

HASBRO INC CIK:46080

	31.1
	31.2
32.1*
32.2*
101*
* Furnished herewith.

Data column 1: "numyear" is ambiguous (2009 or 2009 or 2010 or 2010 or 2006 or 2006 or 2010)
Data column 1: "month" is ambiguous (5 or 5 or 3 or 3 or 6 or 6 or 6)
Data column 1: "dayofmonth" is ambiguous (13 or 13 or 11 or 11 or 23 or 23 or 27)
Data column 1: Unable to interpret date in column header

Table 4

Financial table in standard format

Exhibit
No.		Exhibits
-------		-----------

3.1		Restated Articles of Incorporation of the Company. (Incorporated by reference to Exhibit 3.1 to the Companys Quarterly Report on Form 10-Q for the period ended July 2, 2000, File No. 1-6682.)

3.2		Amendment to Articles of Incorporation, dated June 28, 2000. (Incorporated by reference to Exhibit 3.4 to the Companys Quarterly Report on Form 10-Q for the period ended July 2, 2000, File No. 1-6682.)

3.3		Amendment to Articles of Incorporation, dated May 19, 2003. (Incorporated by reference to Exhibit 3.3 to the Companys Quarterly Report on Form 10-Q for the period ended June 29, 2003, File No. 1-6682.)

3.4		Amended and Restated Bylaws of the Company, as amended. (Incorporated by reference to Exhibit 3(d) to the Companys Annual Report on Form 10-K for the fiscal year ended December 31, 2006, File No. 1-6682.)

3.5		Certificate of Designations of Series C Junior Participating Preference Stock of Hasbro, Inc. dated June 29, 1999. (Incorporated by reference to Exhibit 3.2 to the Companys Quarterly Report on Form 10-Q for the period ended July 2, 2000, File No. 1-6682.)

3.6		Certificate of Vote(s) authorizing a decrease of class or series of any class of shares. (Incorporated by reference to Exhibit 3.3 to the Companys Quarterly Report on Form 10-Q for the period ended July 2, 2000, File No 1-6682.)

4.1		Indenture, dated as of July 17, 1998, by and between the Company and Citibank, N.A. as Trustee. (Incorporated by reference to Exhibit 4.1 to the Companys Current Report on Form 8-K dated July 14, 1998, File No. 1-6682.)

4.2		Indenture, dated as of March 15, 2000, by and between the Company and the Bank of Nova Scotia Trust Company of New York. (Incorporated by reference to Exhibit 4(b) (i) to the Companys Annual Report on Form 10-K for the year ended December 26, 1999, File No. 1-6682.)

4.3		Indenture, dated as of November 30, 2001, by and between the Company and The Bank of Nova Scotia Trust Company of New York. (Incorporated by reference to Exhibit 4.1 to the Companys Registration Statement on Form S-3, File No. 333-83250, filed February 22, 2002.)

4.4		First Supplemental Indenture, dated as of September 17, 2007, between the Company and the Bank of Nova Scotia Trust Company of New York. (Incorporated by reference to Exhibit 4.1 to the Companys Current Report on Form 8-K filed September 17, 2007, File No. 1-6682.)

4.5		Second Supplemental Indenture, dated as of May 13, 2009, between the Company and the Bank of Nova Scotia Trust Company of New York. (Incorporated by reference to Exhibit 4.1 to the Companys Current Report on Form 8-K filed May 13, 2009, File No. 1-6682.)

4.6		Third Supplemental Indenture, dated as of March 11, 2010, between the Company and the Bank of Nova Scotia Trust Company of New York. (Incorporated by reference to Exhibit 4.1 to the Companys Current Report on Form 8-K filed March 11, 2010, File No. 1-6682.)

4.7		Revolving Credit Agreement, dated as of June 23, 2006, by and among Hasbro, Inc., Hasbro SA, Bank of America, N.A., Citizens Bank of Massachusetts, Commerzbank AG, New York and Grand Cayman Branches, BNP Paribas, Banc of America Securities LLC and the other banks party thereto. (Incorporated by reference to Exhibit 10.1 to the Companys Current Report on Form 8-K dated June 23, 2006, File No. 1-6682.)

12		Computation of Ratio of Earnings to Fixed Charges -
		Quarter Ended June 27, 2010.

31.1		Certification of the Chief Executive Officer Pursuant to Rule 13a-14(a) under the Securities Exchange Act of 1934.

31.2		Certification of the Chief Financial Officer Pursuant to Rule 13a-14(a) under the Securities Exchange Act of 1934.

32.1*		Certification of the Chief Executive Officer Pursuant to Rule 13a-14(b) under the Securities Exchange Act of 1934.

32.2*		Certification of the Chief Financial Officer Pursuant to Rule 13a-14(b) under the Securities Exchange Act of 1934.

101*		The following materials from the Companys Quarterly Report on Form 10-Q for the quarter ended June 27, 2010, formatted in Extensible Business Reporting Language (XBRL): (i) the Consolidated Balance Sheets, (ii) the Consolidated Statements of Operations, (iii) the Consolidated Statements of Cash Flows, (iv) the Consolidated Statements of Comprehensive Earnings and (v) the Condensed Notes to Consolidated Financial Statements, tagged as blocks of text.

		* Furnished herewith.

HASBRO INC CIK:46080

	31.1
	31.2
32.1*
32.2*
101*
* Furnished herewith.

Data column 1: "numyear" is ambiguous (2000 or 2000 or 2000 or 2003 or 2003 or 2006 or 1999 or 2000 or 2000 or 1998 or 1998 or 2000 or 1999 or 2001 or 2002 or 2007 or 2007 or 2009 or 2009 or 2010 or 2010 or 2006 or 2006 or 2010)
Data column 1: "month" is ambiguous (7 or 6 or 7 or 5 or 6 or 12 or 6 or 7 or 7 or 7 or 7 or 3 or 12 or 11 or 2 or 9 or 9 or 5 or 5 or 3 or 3 or 6 or 6 or 6)
Data column 1: "dayofmonth" is ambiguous (2 or 28 or 2 or 19 or 29 or 31 or 29 or 2 or 2 or 17 or 14 or 15 or 26 or 30 or 22 or 17 or 17 or 13 or 13 or 11 or 11 or 23 or 23 or 27)
Data column 1: Unable to interpret date in column header

Original filing from SEC EDGAR system.