Answered step by step
Verified Expert Solution
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started