Downside's financial data extraction

Connecting to database

CINTAS CORP

SEC Form 10-K filed 2010-07-30 for the period ending 2010-05-31

(Debug messages on)

Selected tables from the SEC filing

Table 0

Table column format standardization was unsuccessful.


		Management's Report on Internal Control over Financial Reporting		32
		Reports of Ernst & Young LLP, Independent Registered Public Accounting Firm		33
		Consolidated Statements of Income		35
		Consolidated Balance Sheets		36
		Consolidated Statements of Shareholders' Equity		37
		Consolidated Statements of Cash Flows		38
		Notes to Consolidated Financial Statements		39

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

Row 1
    [2..2)   [0..0] (stub): 'Management's Report on Internal Control over Financial Reporting'
    [4..4)   [1..1] ( num): '32'
      Attributes: num=>32 [1..1]  

Row 2
    [2..2)   [0..0] (stub): 'Reports of Ernst & Young LLP, Independent Registered Public Accounting Firm'
    [4..4)   [1..1] ( num): '33'
      Attributes: num=>33 [1..1]  

Row 3
    [2..2)   [0..0] (stub): 'Consolidated Statements of Income'
    [4..4)   [1..1] ( num): '35'
      Attributes: num=>35 [1..1]  

Row 4
    [2..2)   [0..0] (stub): 'Consolidated Balance Sheets'
    [4..4)   [1..1] ( num): '36'
      Attributes: num=>36 [1..1]  

Row 5
    [2..2)   [0..0] (stub): 'Consolidated Statements of Shareholders' Equity'
    [4..4)   [1..1] ( num): '37'
      Attributes: num=>37 [1..1]  

Row 6
    [2..2)   [0..0] (stub): 'Consolidated Statements of Cash Flows'
    [4..4)   [1..1] ( num): '38'
      Attributes: num=>38 [1..1]  

Row 7
    [2..2)   [0..0] (stub): 'Notes to Consolidated Financial Statements'
    [4..4)   [1..1] ( num): '39'
      Attributes: num=>39 [1..1]  



Prototype ranges:
7 rows: 7 6 5 4 3 2 1 
    [2..2)   [0..0] (stub): ''
    [4..4)   [1..1] ( num): ''

Best data column prototype:
7 rows: 7 6 5 4 3 2 1 
    [2..2)   [0..0] (stub): ''
    [4..4)   [1..1] ( num): ''

Table attributes: balancesheet,incomestatement,cash

Table 1

Financial table in standard format

Condensed Consolidating Income Statement



Year Ended May 31, 2010		Cintas Corporation		Corp. 2			Subsidiary Guarantors			Non- Guarantors			Eliminations			Cintas Corporation Consolidated
Revenue:
Rental uniforms and ancillary products	$		$	1,970,303		$	518,254		$	180,847		$	(100,047	)	$	2,569,357
Other services				1,216,779			351,368			66,229			(656,394	)		977,982
Equity in net income of affiliates		215,620											(215,620	)

		215,620		3,187,082			869,622			247,076			(972,061	)		3,547,339
Costs and expenses (income):
Cost of rental uniforms and ancillary products				1,226,076			332,935			111,340			(220,775	)		1,449,576
Cost of other services				798,841			297,890			41,316			(538,101	)		599,946
Selling and administrative expenses				1,037,945			(20,140	)		67,669			885			1,086,359
Legal settlements, net of insurance proceeds							23,529									23,529
Restructuring charges				(1,080	)		(1,800	)								(2,880	)

Operating income		215,620		125,300			237,208			26,751			(214,070	)		390,809
Interest income				(268	)		(1,130	)		(297	)					(1,695	)
Interest expense (income)				51,486			(2,897	)		23						48,612

Income before income taxes		215,620		74,082			241,235			27,025			(214,070	)		343,892
Income taxes				27,936			91,239			9,123			(26	)		128,272

Net income	$	215,620	$	46,146		$	149,996		$	17,902		$	(214,044	)	$	215,620

CINTAS CORP CIK:723254


Revenue:
Rental uniforms and ancillary products $	$1,970,303	$518,254	$180,847	$(100,047)	$2,569,357
Other services	1,216,779	351,368	66,229	(656,394)	977,982
Equity in net income of affiliates 215,620				(215,620)
	3,187,082	869,622	247,076	(972,061)	3,547,339
Costs and expenses (income):
Cost of rental uniforms and ancillary products	1,226,076	332,935	111,340	(220,775)	1,449,576
Cost of other services	798,841	297,890	41,316	(538,101)	599,946
Selling and administrative expenses	1,037,945	(20,140)	67,669	885	1,086,359
Legal settlements, net of insurance proceeds		23,529			23,529
Restructuring charges	(1,080)	(1,800)			(2,880)
Operating income 215,620	125,300	237,208	26,751	(214,070)	390,809
Interest income	(268)	(1,130)	(297)		(1,695)
Interest expense (income)	51,486	(2,897)	23		48,612
Income before income taxes 215,620	74,082	241,235	27,025	(214,070)	343,892
Income taxes	27,936	91,239	9,123	(26)	128,272
Net income $215,620	$46,146	$149,996	$17,902	$(214,044)	$215,620

Table 2

Financial table in standard format

Condensed Consolidating Income Statement



Year Ended May 31, 2009		Cintas Corporation		Corp. 2		Subsidiary Guarantors			Non- Guarantors			Eliminations			Cintas Corporation Consolidated
Revenue:
Rental uniforms and ancillary products	$		$	2,101,857	$	569,780		$	175,711		$	(92,333	)	$	2,755,015
Other services				1,295,603		397,426			60,414			(733,773	)		1,019,670
Equity in net income of affiliates		226,357										(226,357	)

		226,357		3,397,460		967,206			236,125			(1,052,463	)		3,774,685
Costs and expenses (income):
Cost of rental uniforms and ancillary products				1,242,048		368,125			106,856			(154,799	)		1,562,230
Cost of other services				958,634		348,159			38,449			(683,658	)		661,584
Selling and administrative expenses				1,051,221		(27,889	)		57,953			1,424			1,082,709
Restructuring charges				6,575		3,531			103						10,209
Impairment of long-lived assets				25,713		17,328			5,847						48,888

Operating income		226,357		113,269		257,952			26,917			(215,430	)		409,065
Interest income						(930	)		(1,834	)					(2,764	)
Interest expense (income)				53,197		(2,982	)		21						50,236

Income before income taxes		226,357		60,072		261,864			28,730			(215,430	)		361,593
Income taxes				17,152		110,001			8,083						135,236

Net income	$	226,357	$	42,920	$	151,863		$	20,647		$	(215,430	)	$	226,357

CINTAS CORP CIK:723254


Revenue:
Rental uniforms and ancillary products $	$2,101,857	$569,780	$175,711	$(92,333)	$2,755,015
Other services	1,295,603	397,426	60,414	(733,773)	1,019,670
Equity in net income of affiliates 226,357				(226,357)
	3,397,460	967,206	236,125	(1,052,463)	3,774,685
Costs and expenses (income):
Cost of rental uniforms and ancillary products	1,242,048	368,125	106,856	(154,799)	1,562,230
Cost of other services	958,634	348,159	38,449	(683,658)	661,584
Selling and administrative expenses	1,051,221	(27,889)	57,953	1,424	1,082,709
Restructuring charges	6,575	3,531	103		10,209
Impairment of long-lived assets	25,713	17,328	5,847		48,888
Operating income 226,357	113,269	257,952	26,917	(215,430)	409,065
Interest income		(930)	(1,834)		(2,764)
Interest expense (income)	53,197	(2,982)	21		50,236
Income before income taxes 226,357	60,072	261,864	28,730	(215,430)	361,593
Income taxes	17,152	110,001	8,083		135,236
Net income $226,357	$42,920	$151,863	$20,647	$(215,430)	$226,357

Table 3

Financial table in standard format

Condensed Consolidating Income Statement



Year Ended May 31, 2008		Cintas Corporation		Corp. 2		Subsidiary Guarantors			Non- Guarantors			Eliminations			Cintas Corporation Consolidated
Revenue:
Rental uniforms and ancillary products	$		$	2,059,920	$	578,426		$	197,333		$	(1,111	)	$	2,834,568
Other services				1,418,749		536,881			66,873			(919,171	)		1,103,332
Equity in net income of affiliates		335,405										(335,405	)

		335,405		3,478,669		1,115,307			264,206			(1,255,687	)		3,937,900
Costs and expenses (income):
Cost of rental uniforms and ancillary products				1,262,373		372,225			115,822			(168,802	)		1,581,618
Cost of other services				928,838		456,759			41,750			(752,665	)		674,682
Selling and administrative expenses				1,078,984		(27,702	)		57,239			(4,376	)		1,104,145

Operating income		335,405		208,474		314,025			49,395			(329,844	)		577,455
Interest income						(1,450	)		(4,622	)					(6,072	)
Interest expense (income)				54,153		(7,107	)		5,777						52,823

Income before income taxes		335,405		154,321		322,582			48,240			(329,844	)		530,704
Income taxes				57,779		120,776			16,744						195,299

Net income	$	335,405	$	96,542	$	201,806		$	31,496		$	(329,844	)	$	335,405

CINTAS CORP CIK:723254


Revenue:
Rental uniforms and ancillary products $	$2,059,920	$578,426	$197,333	$(1,111)	$2,834,568
Other services	1,418,749	536,881	66,873	(919,171)	1,103,332
Equity in net income of affiliates 335,405				(335,405)
	3,478,669	1,115,307	264,206	(1,255,687)	3,937,900
Costs and expenses (income):
Cost of rental uniforms and ancillary products	1,262,373	372,225	115,822	(168,802)	1,581,618
Cost of other services	928,838	456,759	41,750	(752,665)	674,682
Selling and administrative expenses	1,078,984	(27,702)	57,239	(4,376)	1,104,145
Operating income 335,405	208,474	314,025	49,395	(329,844)	577,455
Interest income		(1,450)	(4,622)		(6,072)
Interest expense (income)	54,153	(7,107)	5,777		52,823
Income before income taxes 335,405	154,321	322,582	48,240	(329,844)	530,704
Income taxes	57,779	120,776	16,744		195,299
Net income $335,405	$96,542	$201,806	$31,496	$(329,844)	$335,405

Table 4

Financial table in standard format

Condensed Consolidating Balance Sheet



As of May 31, 2010		Cintas Corporation			Corp. 2		Subsidiary Guarantors			Non- Guarantors			Eliminations			Cintas Corporation Consolidated
Assets
Current assets:
Cash and cash equivalents	$			$	34,905	$	339,702		$	36,674		$			$	411,281
Marketable securities							21,954			132,852						154,806
Accounts receivable, net					265,594		74,256			26,451						366,301
Inventories, net					144,826		16,857			9,420			(1,619	)		169,484
Uniforms and other rental items in service					256,398		70,489			25,514			(20,295	)		332,106
Income taxes, current					5,306		(591	)		10,976						15,691
Deferred tax asset (liability)							54,474			(2,059	)					52,415
Prepaid expenses					5,565		6,371			1,487						13,423
Assets held for sale							9,437									9,437

Total current assets					712,594		592,949			241,315			(21,914	)		1,524,944
Property and equipment, at cost, net					591,040		240,462			63,020						894,522
Goodwill							1,310,675			46,250						1,356,925
Service contracts, net					98,335		880			4,230						103,445
Other assets, net		2,032,649			1,608,188		814,657			322,707			(4,688,301	)		89,900

	$	2,032,649		$	3,010,157	$	2,959,623		$	677,522		$	(4,710,215	)	$	3,969,736

Liabilities and Shareholders' Equity
Current liabilities:
Accounts payable	$	(465,247	)	$	164,131	$	343,454		$	(8,614	)	$	38,023		$	71,747
Accrued compensation and related liabilities					42,181		21,730			3,013						66,924
Accrued liabilities					53,432		178,698			13,092			(820	)		244,402
Long-term debt due within one year					805		(196	)								609

Total current liabilities		(465,247	)		260,549		543,686			7,491			37,203			383,682
Long-term liabilities:
Long-term debt due after one year					795,541		(10,917	)					820			785,444
Deferred income taxes							145,563			4,997						150,560
Accrued liabilities							115,549			472						116,021

Total long-term liabilities					795,541		250,195			5,469			820			1,052,025
Total shareholders' equity		2,497,896			1,954,067		2,165,742			664,562			(4,748,238	)		2,534,029

	$	2,032,649		$	3,010,157	$	2,959,623		$	677,522		$	(4,710,215	)	$	3,969,736

CINTAS CORP CIK:723254


Assets
Current assets:
Cash and cash equivalents $	$34,905	$339,702	$36,674	$411,281
Marketable securities		21,954	132,852	154,806
Accounts receivable, net	265,594	74,256	26,451	366,301
Inventories, net	144,826	16,857	9,420	169,484
Uniforms and other rental items in service	256,398	70,489	25,514	332,106
Income taxes, current	5,306	(591)	10,976	15,691
Deferred tax asset (liability)		54,474	(2,059)	52,415
Prepaid expenses	5,565	6,371	1,487	13,423
Assets held for sale		9,437		9,437
Total current assets	712,594	592,949	241,315	1,524,944
Property and equipment, at cost, net	591,040	240,462	63,020	894,522
Goodwill		1,310,675	46,250	1,356,925
Service contracts, net	98,335	880	4,230	103,445
Other assets, net 2,032,649	1,608,188	814,657	322,707	89,900
	$3,010,157	$2,959,623	$677,522	$3,969,736
Liabilities and Shareholders' Equity
Current liabilities:
Accounts payable $(465,247)	$164,131	$343,454	$(8,614)	$71,747
Accrued compensation and related liabilities	42,181	21,730	3,013	66,924
Accrued liabilities	53,432	178,698	13,092	244,402
Long-term debt due within one year	805	(196)		609
Total current liabilities (465,247)	260,549	543,686	7,491	383,682
Long-term liabilities:
Long-term debt due after one year	795,541	(10,917)		785,444
Deferred income taxes		145,563	4,997	150,560
Accrued liabilities		115,549	472	116,021
Total long-term liabilities	795,541	250,195	5,469	1,052,025
Total shareholders' equity 2,497,896	1,954,067	2,165,742	664,562	2,534,029
	$3,010,157	$2,959,623	$677,522	$3,969,736

Data column 1: Unable to interpret date in column header
Data column 2: Unable to interpret date in column header
Data column 3: Unable to interpret date in column header
Data column 4: Unable to interpret date in column header
Row "Cash and cash equivalents $": Multi-column field in a numeric row
Row "Inventories, net": Multi-column field in a numeric row
Row "Uniforms and other rental items in service": Multi-column field in a numeric row
Row "Total current assets": Multi-column field in a numeric row
Row "Other assets, net 2,032,649": Multi-column field in a numeric row
Row "???": Multi-column field in a numeric row
Row "???": Multi-column field in a numeric row
Row "Accounts payable $(465,247)": Multi-column field in a numeric row
Row "Accrued liabilities": Multi-column field in a numeric row
Row "Total current liabilities (465,247)": Multi-column field in a numeric row
Row "Long-term debt due after one year": Multi-column field in a numeric row
Row "Total long-term liabilities": Multi-column field in a numeric row
Row "Total shareholders' equity 2,497,896": Multi-column field in a numeric row
Row "???": Multi-column field in a numeric row
Row "???": Multi-column field in a numeric row

Table 5

Financial table in standard format

Condensed Consolidating Balance Sheet



As of May 31, 2009		Cintas Corporation			Corp. 2		Subsidiary Guarantors		Non- Guarantors			Eliminations			Cintas Corporation Consolidated
Assets
Current assets:
Cash and cash equivalents	$			$	39,397	$	76,979	$	13,369		$			$	129,745
Marketable securities									120,393						120,393
Accounts receivable, net					275,878		88,158		21,944			(28,302	)		357,678
Inventories, net					194,604		2,505		8,248			(3,006	)		202,351
Uniforms and other rental items in service					258,766		76,167		20,998			(20,484	)		335,447
Income taxes, current					3,172		15,865		6,475						25,512
Deferred tax asset (liability)							67,298		(930	)					66,368
Prepaid expenses					6,178		9,473		1,384						17,035
Assets held for sale							15,744								15,744

Total current assets					777,995		352,189		191,881			(51,792	)		1,270,273
Property and equipment, at cost, net					636,348		227,325		50,954						914,627
Goodwill							1,293,559		37,829						1,331,388
Service contracts, net					118,459		1,658		4,213						124,330
Other assets, net		1,876,863			1,598,027		1,782,517		336,264			(5,513,338	)		80,333

	$	1,876,863		$	3,130,829	$	3,657,248	$	621,141		$	(5,565,130	)	$	3,720,951

Liabilities and Shareholders' Equity
Current liabilities:
Accounts payable	$	(465,247	)	$	162,162	$	371,731	$	(20,013	)	$	21,332		$	69,965
Accrued compensation and related liabilities					32,119		14,296		1,999						48,414
Accrued liabilities					43,066		131,618		8,066			(858	)		181,892
Long-term debt due within one year					749		68					(219	)		598

Total current liabilities		(465,247	)		238,096		517,713		(9,948	)		20,255			300,869
Long-term liabilities:
Long-term debt due after one year					796,351		241		24,511			(35,045	)		786,058
Deferred income taxes							145,444		3,588						149,032
Accrued liabilities							117,210		373						117,583

Total long-term liabilities					796,351		262,895		28,472			(35,045	)		1,052,673
Total shareholders' equity		2,342,110			2,096,382		2,876,640		602,617			(5,550,340	)		2,367,409

	$	1,876,863		$	3,130,829	$	3,657,248	$	621,141		$	(5,565,130	)	$	3,720,951

CINTAS CORP CIK:723254


Assets
Current assets:
Cash and cash equivalents $	$39,397	$76,979	$13,369	$129,745
Marketable securities			120,393	120,393
Accounts receivable, net	275,878	88,158	21,944	357,678
Inventories, net	194,604	2,505	8,248	202,351
Uniforms and other rental items in service	258,766	76,167	20,998	335,447
Income taxes, current	3,172	15,865	6,475	25,512
Deferred tax asset (liability)		67,298	(930)	66,368
Prepaid expenses	6,178	9,473	1,384	17,035
Assets held for sale		15,744		15,744
Total current assets	777,995	352,189	191,881	1,270,273
Property and equipment, at cost, net	636,348	227,325	50,954	914,627
Goodwill		1,293,559	37,829	1,331,388
Service contracts, net	118,459	1,658	4,213	124,330
Other assets, net 1,876,863	1,598,027	1,782,517	336,264	80,333
	$3,130,829	$3,657,248	$621,141	$3,720,951
Liabilities and Shareholders' Equity
Current liabilities:
Accounts payable $(465,247)	$162,162	$371,731	$(20,013)	$69,965
Accrued compensation and related liabilities	32,119	14,296	1,999	48,414
Accrued liabilities	43,066	131,618	8,066	181,892
Long-term debt due within one year	749	68		598
Total current liabilities (465,247)	238,096	517,713	(9,948)	300,869
Long-term liabilities:
Long-term debt due after one year	796,351	241	24,511	786,058
Deferred income taxes		145,444	3,588	149,032
Accrued liabilities		117,210	373	117,583
Total long-term liabilities	796,351	262,895	28,472	1,052,673
Total shareholders' equity 2,342,110	2,096,382	2,876,640	602,617	2,367,409
	$3,130,829	$3,657,248	$621,141	$3,720,951

Data column 1: Unable to interpret date in column header
Data column 2: Unable to interpret date in column header
Data column 3: Unable to interpret date in column header
Data column 4: Unable to interpret date in column header
Row "Cash and cash equivalents $": Multi-column field in a numeric row
Row "Accounts receivable, net": Multi-column field in a numeric row
Row "Inventories, net": Multi-column field in a numeric row
Row "Uniforms and other rental items in service": Multi-column field in a numeric row
Row "Total current assets": Multi-column field in a numeric row
Row "Other assets, net 1,876,863": Multi-column field in a numeric row
Row "???": Multi-column field in a numeric row
Row "???": Multi-column field in a numeric row
Row "Accounts payable $(465,247)": Multi-column field in a numeric row
Row "Accrued liabilities": Multi-column field in a numeric row
Row "Long-term debt due within one year": Multi-column field in a numeric row
Row "Total current liabilities (465,247)": Multi-column field in a numeric row
Row "Long-term debt due after one year": Multi-column field in a numeric row
Row "Total long-term liabilities": Multi-column field in a numeric row
Row "Total shareholders' equity 2,342,110": Multi-column field in a numeric row
Row "???": Multi-column field in a numeric row
Row "???": Multi-column field in a numeric row

Original filing from SEC EDGAR system.