Downside's financial data extraction

Connecting to database

CE CASECNAN WATER & ENERGY CO IN

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

(Debug messages on)

Selected tables from the SEC filing

Table 0

Financial table in standard format

CE CASECNAN WATER AND ENERGY COMPANY, INC.
BALANCE SHEETS (Unaudited)
(Amounts in thousands, except share data)

	As of
	June 30,			December31,
	2010			2009

ASSETS

Current assets:
Cash and cash equivalents	$	27,582		$	20,068
Restricted cash and investments		34,565			37,447
Receivables, net		13,366			34,189
Other current assets		6,494			9,027
Total current assets		82,007			100,731

Property, plant and equipment, net		250,377			260,579
Other investments		18,936			19,572
Deferred income taxes		4,811			4,802
Other		31			68
Total assets	$	356,162		$	385,752

LIABILITIES AND SHAREHOLDERS EQUITY

Current liabilities:
Accounts payable and other accrued liabilities	$	660		$	1,670
Dividends payable		20,085			15,775
Accrued interest		128			256
Accrued property, income and other taxes		4,122			9,098
Payable to affiliates		5,489			2,802
Current portion of long-term debt		8,575			17,150
Total current liabilities		39,059			46,751

Commitments and contingencies (Note 5)

Shareholders equity:
Common stock 2,148,000 shares authorized, one Philippine peso ($0.038) par value; 767,162 shares issued and outstanding		29			29
Additional paid-in capital		123,807			123,807
Retained earnings		194,725			216,178
Accumulated other comprehensive loss, net		(1,458	)		(1,013	)
Total shareholders equity		317,103			339,001
Total liabilities and shareholders equity	$	356,162		$	385,752

CE CASECNAN WATER & ENERGY CO IN CIK:1006402
	2010-06-30
ASSETS
Current assets:
Cash and cash equivalents	$27,582	$20,068
Restricted cash and investments	34,565	37,447
Receivables, net	13,366	34,189
Other current assets	6,494	9,027
Total current assets	82,007	100,731
Property, plant and equipment, net	250,377	260,579
Other investments	18,936	19,572
Deferred income taxes	4,811	4,802
Other	31	68
Total assets	$356,162	$385,752
LIABILITIES AND SHAREHOLDERS EQUITY
Current liabilities:
Accounts payable and other accrued liabilities	$660	$1,670
Dividends payable	20,085	15,775
Accrued interest	128	256
Accrued property, income and other taxes	4,122	9,098
Payable to affiliates	5,489	2,802
Current portion of long-term debt	8,575	17,150
Total current liabilities	39,059	46,751
Commitments and contingencies (Note 5)
Shareholders equity:
Common stock 2,148,000 shares authorized, one Philippine peso ($0.038) par value; 767,162 shares issued and outstanding	29	29
Additional paid-in capital	123,807	123,807
Retained earnings	194,725	216,178
Accumulated other comprehensive loss, net	(1,458)	(1,013)
Total shareholders equity	317,103	339,001
Total liabilities and shareholders equity	$356,162	$385,752

Data column 2: Unable to interpret date in column header
Row "ASSETS": Multi-column field in a numeric row
Row "LIABILITIES AND SHAREHOLDERS EQUITY": Multi-column field in a numeric row

Table 1

Financial table in standard format

CE CASECNAN WATER AND ENERGY COMPANY, INC.
STATEMENTS OF OPERATIONS (Unaudited)
(Amounts in thousands)

	Three-Month Periods						Six-Month Periods
	Ended June 30,						Ended June 30,
	2010			2009			2010			2009

Revenue - Lease rentals and service contracts	$	22,013		$	32,433		$	44,027		$	55,932
Operating expenses:
Depreciation		5,484			5,500			10,967			10,994
Plant operations and other operating expenses		2,347			2,509			4,747			4,478
Total operating expenses		7,831			8,009			15,714			15,472

Operating income		14,182			24,424			28,313			40,460

Other income (expense):
Interest expense		(403	)		(858	)		(934	)		(1,874	)
Interest income		158			169			309			419
Other, net		435			738			1,698			1,431
Total other income (expense)		190			49			1,073			(24	)

Income before income tax expense		14,372			24,473			29,386			40,436

Income tax expense		2,876			4,906			6,039			8,263

Net income	$	11,496		$	19,567		$	23,347		$	32,173

CE CASECNAN WATER & ENERGY CO IN CIK:1006402
	2010-06-30	2009-06-30	2010-06-30	2009-06-30
Revenue - Lease rentals and service contracts	$22,013	$32,433	$44,027	$55,932
Operating expenses:
Depreciation	5,484	5,500	10,967	10,994
Plant operations and other operating expenses	2,347	2,509	4,747	4,478
Total operating expenses	7,831	8,009	15,714	15,472
Operating income	14,182	24,424	28,313	40,460
Other income (expense):
Interest expense	(403)	(858)	(934)	(1,874)
Interest income	158	169	309	419
Other, net	435	738	1,698	1,431
Total other income (expense)	190	49	1,073	(24)
Income before income tax expense	14,372	24,473	29,386	40,436
Income tax expense	2,876	4,906	6,039	8,263
Net income	$11,496	$19,567	$23,347	$32,173

Table 2

Financial table in standard format

Additionally, the Company has auction rate securities that are measured at fair value and are presented as other investments on the Balance Sheets. The fair value of the Companys investments in auction rate securities, where there is no current liquid market, is determined using internally developed discounted cash flow pricing models based on available observable market data and the Companys judgment about the assumptions, including liquidity and nonperformance risks, which market participants would use when pricing the asset. As such, the Company considers these securities to be valued using Level 3 inputs. The following table reconciles the beginning and ending balances of the Companys auction rate securities measured at fair value on a recurring basis using significant Level 3 inputs (in thousands):

	Three-Month Periods					Six-Month Periods
	Ended June30,					Ended June 30,
	2010			2009		2010			2009

Beginning balance	$	19,915		$	14,822	$	19,572		$	14,096
Unrealized (losses) gains included in other comprehensive (loss) income		(979	)		2,622		(636	)		3,348
Ending balance	$	18,936		$	17,444	$	18,936		$	17,444

CE CASECNAN WATER & ENERGY CO IN CIK:1006402
			2010-06-30	2009-06-30

Data column 1: Unable to interpret date in column header
Data column 2: Unable to interpret date in column header

Original filing from SEC EDGAR system.