Oil and Gas E&P Company Equity Valuation Model. Balance Sheet

Oil and Gas E&P Company Equity Valuation Model

Screenshot of Balance Sheet


	1994	1995	1996
Assets
Operating cash	2,922	4,481	3,054
Accounts receivable	28,915	21,820	30,031
Other current assets	17,884	37,664	41,833
Total current assets	49,721	63,965	74,918

Oil and gas reserves, on the basis of
successful efforts accounting:
Proved properties	913,865	963,330	1,079,523
Unproved and properties under development	6,890	47,431	111,192

Other property and equipment	8,268	8,811	8,773
Accumulated depreciation, depletion and amortization	(691,110)	(757,739)	(814,623)
Net property, plant and equipment	237,913	261,833	384,865

Other assets	11,191	12,379	19,459
Goodwill	0	0	0
Discontinued operations	0	0	0
Total Assets	298,825	338,177	479,242


Liabilities and Shareholders' Equity
Short-term debt and current portion of long-term debt	4,142	6,056	3,610
Accounts payable	8,065	10,007	7,676
Accrued liabilities	26,497	35,254	56,961
Total current liabilities	38,704	51,317	68,247

Long-term debt	149,249	163,249	246,230
Other long-term liabilities	10,349	10,494	11,162
Deferred income taxes	36,487	41,409	46,321
Total liabilities	234,789	266,469	371,960

Total shareholders' equity	64,037	71,708	107,282

Total liabilities and equity	298,826	338,177	479,242





COMMON-SIZE BALANCE SHEET DATA

	2002	2003	2004
Assets
Operating cash	0.98%	1.33%	0.64%
Accounts receivable	9.68%	6.45%	6.27%
Other current assets	5.98%	11.14%	8.73%
Total current assets	16.64%	18.91%	15.63%

Oil and gas reserves, on the basis of
successful efforts accounting:
Proved properties	305.82%	284.86%	225.26%
Unproved and properties under development	2.31%	14.03%	23.20%

Other property and equipment	2.77%	2.61%	1.83%
Accumulated depreciation, depletion and amortization	-231.28%	-224.07%	-169.98%
Net property, plant and equipment	79.62%	77.42%	80.31%

Other assets	3.75%	3.66%	4.06%
Goodwill	0.00%	0.00%	0.00%
Discontinued operations	0.00%	0.00%	0.00%
Total Assets	100.00%	100.00%	100.00%


Liabilities and Shareholders' Equity
Short-term debt and current portion of long-term debt	1.39%	1.79%	0.75%
Accounts payable	2.70%	2.96%	1.60%
Accrued liabilities	8.87%	10.42%	11.89%
Total current liabilities	12.95%	15.17%	14.24%

Long-term debt	49.95%	48.27%	51.38%
Other long-term liabilities	3.46%	3.10%	2.33%
Deferred income taxes	12.21%	12.24%	9.67%
Total liabilities	78.57%	78.80%	77.61%

Total shareholders' equity	21.43%	21.20%	22.39%

Total liabilities and equity	100.00%	100.00%	100.00%

Oil and Gas E&P Company Equity Valuation Model. Balance Sheet.

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS