70 07 Key Metrics Ratios After

Download as xls, pdf, or txt
Download as xls, pdf, or txt
You are on page 1of 16

Oil & Gas Reserves and Production to Financial Statements

Assumptions:

Last Historical Year: 12/31/2009


Standard Conversion Units: 1,000
Bbl to Mcf Factor: 6

XTO Energy Inc. - Reserves and Production

Historical
December 31, 2007 2008 2009

Days in Year: 365 366 365

End-of-Year Proved Developed Reserves:


Gas (Bcf): 6,031.5 7,290.3 7,353.1
Natural Gas Liquids (MMBbls): 52.9 52.5 62.7
Oil (MMBbls): 184.8 205.0 212.6
Total Proved Developed Reserves, Bcfe: 7,457.7 8,835.3 9,004.9
Total Proved Developed Reserves, MMBOE: 1,243.0 1,472.6 1,500.8

End-of-Year Proved Undeveloped Reserves:


Gas (Bcf): 3,409.6 4,512.6 5,148.6
Natural Gas Liquids (MMBbls): 13.9 23.3 30.5
Oil (MMBbls): 56.4 62.5 81.8
Total Proved Undeveloped Reserves, Bcfe: 3,831.4 5,027.4 5,822.4
Total Proved Undeveloped Reserves, MMBOE: 638.6 837.9 970.4

End-of-Year Proved Reserves:


Gas (Bcf): 9,441.1 11,802.9 12,501.7
Natural Gas Liquids (MMBbls): 66.8 75.8 93.2
Oil (MMBbls): 241.2 267.5 294.4
Total Proved Reserves, Bcfe: 11,289.1 13,862.7 14,827.3
Total Proved Reserves, MMBOE: 1,881.5 2,310.5 2,471.2

Annual Production:
Gas (Bcf): 532.1 697.4 855.0
Natural Gas Liquids (MMBbls): 4.9 5.7 7.5
Oil (MMBbls): 17.2 20.5 24.2
Total Annual Production, Bcfe: 664.8 854.7 1,045.2
Total Annual Production, MMBOE: 110.8 142.5 174.2

Reserve Life (Years): 17.0 16.2 14.2

XTO Energy Inc. - Revenue and Expenses


($ as Stated Except Revenue in Millions)
Historical
December 31, 2007 2008 2009

Average Realized Sale Prices:


Gas ($ Per Mcf): $ 7.50 $ 7.81 $ 7.13
Natural Gas Liquids ($ Per Bbl): 45.37 48.76 30.03
Oil ($ Per Bbl): 70.08 87.59 107.65

Total Production Revenue by Segment ($ in Millions):


Gas: $ 3,991 $ 5,447 $ 6,096
Natural Gas Liquids: 224 279 225
Oil and Condensate: 1,203 1,796 2,605
Total Revenue: $ 5,418 $ 7,522 $ 8,927

Expenses Per Mcfe of Production:


Production: $ 0.93 $ 1.10 $ 0.96
Taxes, Transportation & Other: 0.67 0.82 0.65
Depreciation, Depletion & Amortization: 1.78 2.37 2.95
Accretion of Discount in Asset Retirement Obligation: 0.03 0.04 0.04
General & Administrative (Excluding SBC): 0.25 0.25 0.21
Interest: 0.38 0.56 0.50
Total Expenses Per Mcfe: $ 4.04 $ 5.14 $ 5.31

Total Production-Linked Expenses ($ in Millions):


Production: $ 618 $ 940 $ 1,003
Taxes, Transportation & Other: 445 701 679
Depreciation, Depletion & Amortization: 1,183 2,026 3,083
Accretion of Discount in Asset Retirement Obligation: 20 34 42
General & Administrative (Excluding SBC): 166 214 219
Interest: 253 479 523
Total Production-Linked Expenses: $ 2,686 $ 4,393 $ 5,550

XTO Energy Inc. - Income Statement


($ in Millions Except Per Share Data)
Historical
December 31, 2007 2008 2009
Revenue:
Gas and Natural Gas Liquids: $ 4,215 $ 5,725 $ 6,322
Oil and Condensate: 1,203 1,796 2,605
Gas Gathering, Processing & Marketing: 100 168 125
Other: (5) 3 12
Total Revenue: 5,513 7,693 9,064

Expenses:
Production: 618 940 1,003
Taxes, Transportation & Other: 445 701 679
Exploration: 52 88 77
Depreciation, Depletion & Amortization: 1,183 2,026 3,083
Accretion of Discount in Asset Retirement Obligation: 20 34 42
Gas Gathering & Processing: 81 101 124
General & Administrative (Excluding SBC): 166 214 219
Stock-Based Compensation: 65 170 137
Derivative Fair Value (Gain) / Loss: (11) (85) 24
Total Expenses: 2,620 4,189 5,390

Operating Income: $ 2,893 $ 3,504 $ 3,674

Other (Income) / Expense:


Gain on Royalty Trusts: - - -
Net Interest Expense: 253 479 523
Total Other (Income) / Expense: 253 479 523

Pre-Tax Income: $ 2,641 $ 3,025 $ 3,151

Income Tax Expense:


Current: 292 140 333
Deferred: 659 974 811
Total Income Tax Expense: 951 1,114 1,144

Net Income: $ 1,690 $ 1,911 $ 2,007

XTO Energy Inc. - Equity Value and Enterprise Value


($ in Millions Except Per Share Data; Shares and Options as Stated)

Date: 12/11/2009
Current Share Price: $ 41.49

Exercise / Vesting
Equity Value Calculation: Number Price Net Dilution
Common Shares Outstanding: 583,344,525 583,344,525
Restricted Shares: 5,493,000 5,493,000
Options Outstanding: 18,366,000 $ 38.39 1,372,249
Performance Shares - A 390,000 $ 50.00 -
Performance Shares - B 228,000 $ 55.00 -
Performance Shares - C 245,000 $ 77.00 -
Performance Shares - D 245,000 $ 85.00 -
Warrants: 2,600,000 $ 20.78 1,297,807
Diluted Shares Outstanding: 591,507,580

Basic Equity Value: $ 24,203


Diluted Equity Value: $ 24,542

Enterprise Value Calculation:


Less: Cash & Cash-Equivalents: $ (9)
Less: Net Value of Hedges: (1,117)
Plus: Debt: 10,487
Plus: Asset Retirement Obligation: 783
Plus: Preferred Stock: -
Plus: Noncontrolling Interests: -
Enterprise Value: 34,686

XTO Energy Inc. - Key Metrics and Ratios

Historical
December 31, 2007 2008 2009
EBITDA ($ in Millions): $ 4,151 $ 5,649 $ 6,960
EBITDAX ($ in Millions): 4,203 5,737 7,037

Production Costs per Mcfe: $ 0.93 $ 1.10 $ 0.96


F&D Costs - All Sources (per Mcfe): $ 2.00 $ 4.35 $ 1.61
F&D Costs - Excl. Purchases / Sales (per Mcfe): $ 1.36 $ 2.70 $ 1.50

Production Replacement Ratio - All Sources: 512.2% 401.1% 192.3%


Production Replacement Ratio - Excl. Purchases / Sales: 308.5% 168.0% 190.1%

Proved Reserves (Bcfe): 11,289.1 13,862.7 14,827.3


Proved Developed Reserves / Proved Reserves: 66.1% 63.7% 60.7%
Reserve Life Ratio (Years): 17.0 16.2 14.2
Daily Production (Bcfe/d): 1.8 2.3 2.9
Proved Reserves % Oil: 12.8% 11.6% 11.9%

EV / EBITDA: 8.4x 6.1x 5.0x


EV / EBITDAX: 8.3x 6.0x 4.9x
EV / Proved Reserves: $ 3.07 $ 2.50 $ 2.34
EV / Daily Production: $ 19,044 $ 14,853 $ 12,112

XTO Energy Inc. - Replacement Ratios and F&D Costs


($ in Millions Except Reserve Additions in Bcfe)
Historical
December 31, 2007 2008 2009

Net Reserve Additions:


Revisions (Bcfe): 108 (847) (454)
Extensions, Additions, and Discoveries (Bcfe): 1,943 2,283 2,441
Purchases in Place (Bcfe): 1,363 1,994 23
Sales in Place (Bcfe): (8) (2) -
Total Net Reserve Additions (Bcfe): 3,405 3,428 2,010

Oil & Gas Production-Related Cash Expenses:


Acquisitions:
Proved Properties: $ 3,197 $ 7,845 $ 30
Unproved Properties - Acquisitions of Proved: 260 1,110 -
Unproved Properties - Other: 571 2,094 224
Development: 2,529 3,355 2,488
Exploration: 257 517 500
Total Oil & Gas Production-Related Cash Expenses: $ 6,814 $ 14,921 $ 3,242
Financial Statements - Normal Company vs. E&P Company vs. Diversified Oil & Gas
($ in Millions)

"Normal Company" - Income Statement XTO Energy - Income Statement Exxon-Mobil - Income Statement

Revenue: $ 42,905 Revenue: Revenue:


Cost of Goods Sold: 25,324 Gas & Natural Gas Liquids: $ 6,322 Sales and Other Operating:
Gross Profit: 17,581 Oil & Condensate: 2,605 Equity Affiliate Income:
Operating Expenses: Gas Gathering, Processing & Marketing: 125 Other Income:
Research & Development: 830 Other: 12 Total Revenue:
Selling, General & Administrative: 3,566 Total Revenue: 9,064
Total Operating Expenses: 4,397 Expenses:
Expenses: Crude Oil & Product Purchases:
Depreciation & Amortization of PP&E: 734 Production: 999 Production & Manufacturing Expenses:
Amortization of Intangibles: - Taxes, Transportation & Other: 678 Selling, General & Administrative:
Stock-Based Compensation: 710 Exploration: 77 Depreciation & Depletion:
Depreciation, Depletion & Amortization: 3,079 Exploration (Including Dry Holes):
Operating Income: $ 11,740 Accr. of Disc. in Asset Retirement Oblig.: 40 Interest Expense:
Interest Income: 407 Gas Gathering & Processing: 124 Sales-Based Taxes:
Interest Expense: - General & Administrative: 356 Other Taxes and Duties:
Other Income / (Expense): (81) Derivative Fair Value Gain / (Loss): 24 Total Expenses:
Pre-Tax Income: $ 12,066 Total Expenses: 5,377
Income Tax Provision: 3,831 Pre-Tax Income:
Operating Income: $ 3,687
Net Income: $ 8,235 Income Tax Expense:
Other (Income) / Expense:
Earnings Per Share (EPS): $9.08 Gain on Royalty Trusts: - Net Income:
Diluted Shares Outstanding: 907 Net Interest Expense: 524 Net Income to Noncontrolling Interest:
Total Other (Income) / Expense: 524 Net Income to Common:

Pre-Tax Income: $ 3,163 Earnings Per Share (EPS):


Diluted Shares Outstanding:
Income Tax Expense:
Current: 333
Deferred: 811
Total Income Tax Expense: 1,144

Net Income: $ 2,019


Earnings Per Share (EPS): $3.51
Diluted Shares Outstanding: 576

"Normal Company" - Balance Sheet XTO Energy - Balance Sheet Exxon-Mobil - Balance Sheet
Assets: Assets: Assets:
Current Assets: Current Assets: Current Assets:
Cash & Cash-Equivalents: $ 6,559 Cash & Cash-Equivalents: $ 9 Cash & Cash-Equivalents:
Short-Term Securities: 26,282 Accounts Receivable, Net: 965 Restricted Cash:
Accounts Receivable: 3,361 Derivative Fair Value: 1,222 Marketable Securities:
Inventory: 455 Current Income Tax Receivable: 170 Notes and Accounts Receivable, Net:
Prepaid Expenses: - Deferred Income Tax Benefit: - Crude Oil Inventories:
Deferred Tax Assets: 4 Other: 182 Material and Supply Inventory:
Other Current Assets: 3,140 Total Current Assets: 2,548 Other Current Assets:
Total Current Assets: 39,801 Total Current Assets:
PP&E:
Proved Properties: 34,180 Long-Term Assets:
Long-Term Assets: Unproved Properties: 3,691 Investments, Advances & Long-Term Re
Long-Term Securities: 2,554 Other: 2,810 Net PP&E:
Plants, Property & Equipment: 2,839 Total PP&E: 40,681 Net Other & Intangible Assets:
Goodwill: 207 Accumulated DD&A: (8,747) Total Long-Term Assets:
Other Intangible Assets: 354 Net PP&E: 31,934
Other Assets: 2,011 Total Assets:
Total Assets: $ 47,766 Derivative Fair Value: 68
Net Gas Gathering Contracts: 97 Liabilities & Shareholders' Equ
Liabilities & Shareholders' Equity: Goodwill: 1,475 Current Liabilities:
Current Liabilities: Other: 133 Notes and Loans Payable:
Accounts Payable: $ 5,601 Total Other Assets: 1,773 Accounts Payable & Accrued Liabilities:
Accrued Expenses: 3,852 Income Taxes Payable:
Deferred Revenue: 2,053 Total Assets: $ 36,255 Total Current Liabilities:
Total Current Liabilities: 11,506
Liabilities & Shareholders' Equity: Long-Term Liabilities:
Long-Term Liabilities: Current Liabilities: Long-Term Debt:
Deferred Revenue: 853 Accounts Payable: $ 1,482 Postretirement Benefits Reserve:
Long-Term Debt: - Payable to Royalty Trusts: 28 Deferred Income Taxes:
Other Long-Term Liabilities: 3,502 Current Portion of Long-Term Debt: 250 Other Long-Term Obligations:
Total Liabilities: $ 15,861 Derivative Fair Value: 167 Total Long-Term Liabilities:
Deferred Income Taxes: 342
Shareholders' Equity: Other: 32 Total Liabilities:
Preferred Stock: $ - Total Current Liabilities: 2,301
Noncontrolling Interests: - Stockholders' Equity:
Common Stock: 7,177 Long-Term Debt: 10,237 Common Stock (Without Par Value):
Additional Paid-In Capital: 1,185 Derivative Fair Value: 6 Treasury Stock:
Treasury Stock: - Deferred Income Taxes: 5,522 Earnings Reinvested:
Retained Earnings: 23,364 Asset Retirement Obligation: 783 Accumulated Other Comprehensive Inc
Accum. Other Comprehensive Income: 179 Other: 80 Total Stockholders' Equity:
Total Shareholders' Equity: $ 31,905 Total Long-Term Liabilities: 16,628
Noncontrolling Interests:
Total Liabilities & SE: $ 47,766 Stockholders' Equity:
Common Stock: $ 6 Total Equity:
Additional Paid-In Capital: 8,471
Treasury Stock: (177) Total Liabilities & Equity:
Retained Earnings: 8,317
Accum. Other Comprehensive Income: 709
Total Stockholders' Equity: $ 17,326

Total Liabilities & SE: $ 36,255

"Normal Company" - Cash Flow Statement XTO Energy - Cash Flow Statement Exxon-Mobil - Cash Flow Statement

Operating Activities: Operating Activities: Operating Activities:


Net Income: $ 8,235 Net Income: $ 2,019 Net Income to Common:
Depreciation & Amortization of PP&E: 734 Depreciation, Depletion & Amortization: 3,079 Net Income to Noncontrolling Interest:
Amortization of Intangibles: - Accr. of Disc. in Asset Retirement Oblig.: 40 Adjustments to NI:
Stock-Based Compensation: 710 Stock-Based Compensation: 137 Depreciation & Depletion:
Deferred Income Tax Expense: 1,040 Dry Hole Expense: 44 Deferred Income Taxes / (Credit):
Loss on PP&E: 26 Deferred Income Tax: 811 Pension Expense Above / (Below) Paym
Changes in Operating Assets & Liabilities: Gain on Royalty Trusts: - LT Obligations Above / (Below) Paymen
Accounts Receivable: (939) Gain on Debt Extinguish.: (17) Div. Received Above (Below) Equity in E
Inventory: 54 Non-Cash Derivatives Gain / (Loss): 130 Change in Notes and Accounts Receivab
Other Current Assets: 780 Other Non-Cash Items: (24) Change in Inventory:
Other Assets: (1,172) Net Change in Operating Assets/Liab.: (265) Change in Other Current Assets:
Accounts Payable: 81 Cash Flow from Operations: 5,954 Change in Acounts Payable:
Deferred Revenue: 521 Net (Gain) on Asset Sales:
Other Liabilities: 1,385 Investing Activities: All Other Items - Net
Cash Flow from Operations: 11,455 Proceeds from Sale of PP&E: 3 Cash Flow from Operations:
Property & Corporate Acquisitions: (264)
Investing Activities: Development & Capitalized Exploration: (3,190) Investing Activities:
Purchases of Securities: (46,724) Other Property Additions: (606) Capital Expenditures:
Proceeds from Maturities & Sales: 30,678 Cash Flow from Investing: (4,057) Sales of Investments and PP&E:
Purchases of LT Investments: (101) Decrease in Restricted Cash:
Capital Expenditures: (1,144) Financing Activities: Additional Investments and Advances:
Acquisition of Intangibles: (69) Proceeds from Long-Term Debt: 7,730 Collection of Advances:
Other: (74) Payments on Short-Term Debt: - Marketable Securities Additions:
Cash Flow from Investing: (17,434) Payments on Long-Term Debt: (9,183) Sales of Marketable Securities:
Net Common Stock Proceeds: - Cash Flow from Investing:
Financing Activities: Dividends: (287)
Proceeds from Common Stock: 475 Senior Note and Debt Costs: (2) Financing Activities:
Common Stock Repurchased: - Option and Warrant Proceeds: 23 Additions to Long-Term Debt:
Dividends Issued: - Stock Option Exercise Payments: (23) Payments of Long-Term Debt:
Tax Benefits from Stock-Based Comp: 270 Stock Option Tax Benefits: 20 Additions to Short-Term Debt:
Raise / (Pay Off) Long-Term Debt: - Treasury Stock Purchases & Other: (191) Payments of Short-Term Debt:
Cash Used for Equity Awards: (82) Cash Flow from Financing: (1,913) Other Debt Changes:
Cash Flow from Financing: 663 Cash Dividends to Common:
Cash Dividends to Noncontrolling Intere
Increase / (Decrease) in Cash: $ (5,316) Cash Increase / (Decrease): $ (16) Changes in Noncontrolling Interests:
Beginning Cash: 11,875 Beginning Cash: 25 Stock-Based Compensation Tax Benefit
Ending Cash: $ 6,559 Ending Cash: $ 9 Treasury Stock Purchased:
Common Stock Issued:
Cash Flow from Financing:

FX Rate Effect:

Cash Increase / (Decrease):


Beginning Cash:
Ending Cash:
bil - Income Statement

d Other Operating: $ 301,500


ffiliate Income: 7,143
1,943
310,586

il & Product Purchases: 152,806


tion & Manufacturing Expenses: 33,027
General & Administrative: 14,735
ation & Depletion: 11,917
tion (Including Dry Holes): 2,021
548
25,936
axes and Duties: 34,819
275,809

$ 34,777

15,119

$ 19,658
ome to Noncontrolling Interest: 378
me to Common: $ 19,280

er Share (EPS): $3.98


ares Outstanding: 4,848
bil - Balance Sheet
Assets:

Cash-Equivalents: $ 10,693
-
able Securities: 169
nd Accounts Receivable, Net: 27,645
il Inventories: 8,718
l and Supply Inventory: 2,835
urrent Assets: 5,175
55,235

ents, Advances & Long-Term Receivables: 31,665


139,116
er & Intangible Assets: 7,307
g-Term Assets: 178,088

$ 233,323

Liabilities & Shareholders' Equity:

nd Loans Payable: $ 2,476


s Payable & Accrued Liabilities: 41,275
Taxes Payable: 8,310
ent Liabilities: 52,061

m Liabilities:
7,129
rement Benefits Reserve: 17,942
d Income Taxes: 23,148
ong-Term Obligations: 17,651
g-Term Liabilities: 65,870

$ 117,931

ers' Equity:
n Stock (Without Par Value): $ 5,503
(166,410)
s Reinvested: 276,937
lated Other Comprehensive Income: (5,461)
kholders' Equity: $ 110,569

olling Interests: 4,823

$ 115,392

lities & Equity: $ 233,323

bil - Cash Flow Statement


ome to Common: $ 19,280
ome to Noncontrolling Interest: 378

ation & Depletion: 11,917


d Income Taxes / (Credit): -
Expense Above / (Below) Payments: (1,722)
ations Above / (Below) Payments: 731
eived Above (Below) Equity in Eq. Comp.: (483)
in Notes and Accounts Receivable: (3,170)
in Inventory: 459
in Other Current Assets: 132
in Acounts Payable: 1,420
n) on Asset Sales: (488)
r Items - Net (16)
from Operations: 28,438

Expenditures: (22,491)
Investments and PP&E: 1,545
e in Restricted Cash: -
nal Investments and Advances: (2,752)
on of Advances: 724
able Securities Additions: (16)
Marketable Securities: 571
from Investing: (22,419)

ns to Long-Term Debt: 225


ts of Long-Term Debt: (68)
ns to Short-Term Debt: 1,336
ts of Short-Term Debt: (1,575)
ebt Changes: (71)
vidends to Common: (8,023)
vidends to Noncontrolling Interests: (280)
s in Noncontrolling Interests: (113)
ased Compensation Tax Benefits: 237
y Stock Purchased: (19,703)
n Stock Issued: 752
from Financing: (27,283)

520

ase / (Decrease): $ (20,744)


31,437
$ 10,693

You might also like