Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Calculate the following ratios for EOG Resources Income Statement and Balance Statement attached. 1. Calculate the following profitability ratios: Profit Margin Gross Profit Margin Return

Calculate the following ratios for EOG Resources Income Statement and Balance Statement attached.

1. Calculate the following profitability ratios:

  • Profit Margin
  • Gross Profit Margin
  • Return on Equity (ROE)

2. Calculate the following Asset Utilization Ratio:

  • Asset Receivables Turnover
  • Asset Payable Turnover
  • Total Asset Turnover

3. Calculate the following Liquidity ratios:

  • Current Ratio
  • Quick Ratio

4. Calculate the following Debt Ratios:

  • Debt to Total Asset
  • Times Interest Earned
  • Fixed Charge Coverage
EOG Resources Income Statement
Breakdown TTM 2021 2020 2019
Total Revenue 22,386,000 19,669,000 9,873,240 16,941,727
Operating Revenue 22,386,000 19,669,000 9,873,240 16,941,727
Cost of Revenue 5,371,000 5,345,000 4,922,938 5,595,799
Exploration Development & Mineral Property Lease Expenses 1,183,000 1,135,000 1,063,374 1,366,993
Other Cost of Revenue 4,188,000 4,210,000 3,859,564 4,228,806
Gross Profit 17,015,000 14,324,000 4,950,302 11,345,928
Operating Expense 7,355,000 6,711,000 4,492,392 7,432,909
Selling General and Administrative 5,143,000 4,684,000 3,181,552 5,840,921
General & Administrative Expense 525,000 511,000 483,823 489,397
Other G and A 525,000 511,000 483,823 489,397
Selling & Marketing Expense 4,618,000 4,173,000 2,697,729 5,351,524
Other Taxes 1,222,000 1,047,000 477,934 800,164
Other Operating Expenses 990,000 980,000 832,906 791,824
Operating Income 9,660,000 7,613,000 457,910 3,913,019
Net Non Operating Interest Income Expense -179,000 -178,000 -205,266 -185,129
Interest Expense Non Operating 179,000 178,000 205,266 185,129
Total Other Finance Cost - - - 185,129
Other Income Expense -3,932,000 -1,502,000 -991,698 -182,623
Pretax Income 5,549,000 5,933,000 -739,054 3,545,267
Tax Provision 1,172,000 1,269,000 -134,482 810,357
Net Income Common Stockholders 4,377,000 4,664,000 -604,572 2,734,910
Net Income 4,377,000 4,664,000 -604,572 2,734,910
Net Income Including Non-Controlling Interests 4,377,000 4,664,000 -604,572 2,734,910
Net Income Continuous Operations 4,377,000 4,664,000 -604,572 2,734,910
Diluted NI Available to Com Stockholders 4,377,000 4,664,000 -604,572 2,734,910
Basic EPS - 8.03 -1.04 4.73
Diluted EPS - 7.99 -1.04 4.71
Basic Average Shares - 581,000 578,949 577,700
Diluted Average Shares - 584,000 578,949 580,800
Total Operating Income as Reported 5,716,000 6,102,000 -544,016 3,699,011
Total Expenses 12,726,000 12,056,000 9,415,330 13,028,708
Interest Expense 179,000 178,000 205,266 185,129
Net Interest Income -179,000 -178,000 -205,266 -185,129
Net Income from Continuing & Discontinued Operation 4,377,000 4,664,000 -604,572 2,734,910
Normalized Income 7,487,991 5,851,646 215,003 2,899,996
EBIT 5,728,000 6,111,000 -533,788 3,730,396
EBITDA 9,326,000 - - -
Reconciled Cost of Revenue 5,371,000 5,345,000 4,922,938 5,595,799
Reconciled Depreciation 3,598,000 3,651,000 3,400,353 3,749,704
Net Income from Continuing Operation Net Minority Interest 4,377,000 4,664,000 -604,572 2,734,910
Total Unusual Items Excluding Goodwill -3,944,000 -1,511,000 -1,001,926 -214,008
Total Unusual Items -3,944,000 -1,511,000 -1,001,926 -214,008
Normalized EBITDA 13,270,000 11,273,000 3,868,491 7,694,108
Tax Rate for Calcs 0 0 0 0
Tax Effect of Unusual Items -833,009 -323,354 -182,351 -48,922
EOG Resources Balance Sheet
Breakdown 2021 2020 2019
Total Assets 38,236,000 35,804,601 37,124,608
Current Assets 8,584,000 5,862,168 5,273,339
Cash, Cash Equivalents & Short Term Investments 5,209,000 3,328,928 2,027,972
Cash And Cash Equivalents 5,209,000 3,328,928 2,027,972
Receivables 2,335,000 1,545,293 2,153,323
Accounts receivable 2,335,000 1,522,256 2,001,658
Taxes Receivable 0 23,037 151,665
Inventory 584,000 629,401 767,297
Hedging Assets Current 0 64,559 1,299
Other Current Assets 456,000 293,987 323,448
Total non-current assets 29,652,000 29,942,433 31,851,269
Net PPE 28,426,000 28,598,627 30,364,595
Gross PPE 72,397,000 69,271,774 67,302,661
MINERAL_PROPERTIES 67,644,000 64,792,798 62,830,415
Other Properties 4,753,000 4,478,976 4,472,246
Accumulated Depreciation -43,971,000 -40,673,147 -36,938,066
Non Current Deferred Assets 11,000 2,127 2,363
Non Current Deferred Taxes Assets 11,000 2,127 2,363
Other Non Current Assets 1,215,000 1,341,679 1,484,311
Total Liabilities Net Minority Interest 16,056,000 15,502,714 15,483,892
Current Liabilities 4,042,000 3,460,104 4,486,988
Payables And Accrued Expenses 3,196,000 2,104,366 2,850,250
Payables 3,196,000 2,104,366 2,850,250
Accounts Payable 2,242,000 1,681,193 2,429,127
Total Tax Payable 518,000 205,754 254,850
Dividends Payable 436,000 217,419 166,273
Current Debt And Capital Lease Obligation 277,000 1,076,143 1,383,889
Current Debt 37,000 781,054 1,014,524
Other Current Borrowings 37,000 781,054 1,014,524
Current Capital Lease Obligation 277,000 295,089 369,365
Other Current Liabilities 569,000 279,595 252,849
Total Non Current Liabilities Net Minority Interest 12,014,000 12,042,610 10,996,904
Long Term Debt And Capital Lease Obligation 5,630,000 5,035,351 4,160,919
Long Term Debt 4,859,000 5,035,351 4,160,919
Long Term Capital Lease Obligation 771,000 - -
Non Current Deferred Liabilities 4,749,000 4,859,327 5,046,101
Non Current Deferred Taxes Liabilities 4,749,000 4,859,327 5,046,101
Other Non Current Liabilities 1,635,000 2,147,932 1,789,884
Total Equity Gross Minority Interest 22,180,000 20,301,887 21,640,716
Stockholders' Equity 22,180,000 20,301,887 21,640,716
Capital Stock 206,000 205,837 205,822
Common Stock 206,000 205,837 205,822
Retained Earnings 15,919,000 14,169,969 15,648,604
Additional Paid in Capital 6,087,000 5,945,024 5,817,475
Treasury Stock 20,000 6,615 26,533
Gains Losses Not Affecting Retained Earnings -12,000 -12,328 -4,652
Total Capitalization 27,039,000 25,337,238 25,801,635
Common Stock Equity 22,180,000 20,301,887 21,640,716
Capital Lease Obligations 1,048,000 295,089 369,365
Net Tangible Assets 22,180,000 20,301,887 21,640,716
Working Capital 4,542,000 2,402,064 786,351
Invested Capital 27,039,000 26,118,292 26,816,159
Tangible Book Value 22,180,000 20,301,887 21,640,716
Total Debt 5,907,000 6,111,494 5,544,808
Net Debt - 2,487,477 3,147,471
Share Issued 585,522 583,695 582,213
Ordinary Shares Number 585,264 583,571 581,914
Treasury Shares Number 257.268 124.265 298.82

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: Jerry J. Weygandt, Paul D. Kimmel, Donald E. Kieso

11th Edition

1119594596, 978-1119594598

More Books

Students also viewed these Accounting questions

Question

8. How can an interpreter influence the message?

Answered: 1 week ago