Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Clean up the financial statements and calculate the following ratios for all 3 years: 1. Profitability ratios - Profit margin Return on Asset Return on

Clean up the financial statements and calculate the following ratios for all 3 years:

1. Profitability ratios -

  • Profit margin
  • Return on Asset
  • Return on Equity

2. Asset Utilization ratios -

  • Receivables turnover
  • Inventory turnover
  • Account payables turnover

3. Liquidity ratios -

  • Current ratio
  • Quick ratio

4. Debt ratios -

  • Debt to total asset
  • Times interest earned
  • Fixed charge coverage
image text in transcribedimage text in transcribed
Cash and Cash Equivalents $ 3,328,928 $ 2,027,972 Accounts Receivable, Net 1,522,256 2,001,658 Inventories 629,401 767,297 Assets from Price Risk 64,559 1,299 Management Activities Income Taxes Receivable 23,037 151,665 Other 293,987 323,448 Total 5,862, 168 5,273,339 Property, Plant and Equipment Oil and Gas Properties 64, 792, 798 62,830,415 (Successful Efforts Method) Other Property, Plant and 4,478,976 4,472,246 Equipment Total Property, Plant and 69,271,774 67,302,661 Equipment Less: Accumulated Depreciation, -40,673, 147 -36,938, 066 Depletion and Amortization Total Property, Plant and 28,598,627 30,364,595 Equipment, Net Deferred Income Taxes 2, 127 2,363 Other Assets 1,341,679 1,484,311 Total Assets S 35,804,60 S 37,124,60 8 LIABILITIES AND STOCKHOLDERS' EQUITY Current Liabilities Accounts Payable $ 1,681, 193 $ 2,429,127 Accrued Taxes Payable 205,754 254,850 Dividends Payable 217,419 166,273 Liabilities from Price Risk 20, 194 Management Activities Current Portion of Long-Term 781,054 1,014,524 Current Portion of Operating 295,089 369,365 Lease Liabilities Other 279.595 232,655 Total 3,460, 104 4,486,988 Long-Term Debt 5,035,351 4,160,919 Other Liabilities 2, 147,932 1,789,884 Deferred Income Taxes 4,859,327 5,046, 101 Commitments and Contingencies (Note 8) Stockholders' Equity Common Stock, $0.01 Par, 1,280,000,000 Shares Authorized and 583,694,850 Shares and 582,213,016 Shares Issued at December 31, 2020 and 2019 respectively 205,837 205,822 Additional Paid in Capital 5,945,024 5,817,475 Accumulated Other Comprehensive -12,328 -4,652 Loss Retained Earnings 14,169,969 15,648,604 Common Stock Held in Treasury, 124,265 Shares and 298,820 Shares at December 31, 2020 and 2019, respectively -6,615 -26,533 Total Stockholders' Equity 20,301,887 21,640, 716 Total Liabilities and S 35,804,60 S 37,124,60 Stockholders' EquityCrude Oil and Condensate S 5,785,609 9,612,532 S 9,517,440 Natural Gas Liquids 667,514 784,818 1,127,510 Natural Gas 837,133 1, 184,095 1,301,537 Gains (Losses ) on Mark-to- 1,144,737 180,275 165,640 Market Commodity Derivative Gathering, Processing and 2,582,984 5,360,282 5,230,355 Marketing Gains (Losses ) on Asset -46,883 123,613 174,562 Dispositions, Net Other, Net 60,954 134,358 89,635 Total 11,032.048 17,379,973 17,275,399 Operating Expenses Lease and Well 1,063.374 1,366,993 1,282,678 Transportation Costs 734,989 758300 746.876 Gathering and Processing Costs 459,211 479,102 436,973 Exploration Cost 145, 788 139,881 148,999 Dry Hole Costs 13.083 28,001 5.405 Impairments 2,099,780 517,896 347,021 Marketing Costs 2,697, 729 5,351,524 5,203,243 Depreciation, Depletion and 3,400.353 3,749,704 3,435,408 Amortization General and Administrative 483.82 489 397 426.969 Taxes Other Than Income 477,934 300,164 772,48 Total 11,576,064 13,680,962 12,806,053 Operating Income (Loss) 544.016 3,699,011 4,469,346 Other Income, Net 10.228 31.385 16,704 Income (Loss) Before Interest 533,788 3,730.396 486,050 Expense and Income Taxes Interest Expense Incurred 236.154 223,421 269.549 Capitalized -30,838 38,292 24,497 Net Interest Expense 205,266 185,129 245,052 Income (Loss) Before Income 739,054 3,545,267 4,240,998 Taxes Income Tax Provision (Benefit) -134,482 810.35 821,958 Net Income (Loss) 604,572 2,734,910 3,419,040 Net Income (Loss) Per Share Basic -1.04 4.73 5.93 Diluted -1.04 4.71 5.89 Average Number of Common Shares Basic 578.949 577,670 576,578 Diluted 578,949 580.777 580,441 Comprehensive Income (Loss) Net Income (Loss) 604,572 S 2,734,910 S 3,419,040 Other Comprehensive Income L 035) Foreign Currency Translation -7.346 -2,883 16,816 Adjustments Other, Net of Tax -330 -678 1.123 Other Comprehensive Income (Loss) -7.676 -3,561 17,939 Comprehensive Income (L 093) -612.148 2,731.349 S 3,436,97

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

Principles Of Accounting And Principles Of Financial Accounting

Authors: Belverd E Needles, Marian Powers, Susan V Crosson

12th Edition

1133962459, 9781133962458

More Books

Students also viewed these Accounting questions