Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Develop common size and common base-quarter (do not combine quarters to have annual numbers) indexed balance sheets and income statements for all the quarters in
Develop common size and common base-quarter (do not combine quarters to have annual numbers) indexed balance sheets and income statements for all the quarters in the excel file. Please do not include the original financial statements in the indexed financial statements.
9/30/18 6/30/18 91,557 122,123 505 104,308 113,377 501 127 Unit Corp Balance Sheet (in thousands except per share amounts) 6/30/19 3/31/19 12/31/18 Current assets: Cash and cash equivalents 669 3,891 6,452 Accounts receivable 89,876 93,875 119,397 Materials and supplies 516 495 473 Current derivative asset 8,513 3,464 12,870 Income taxes receivable 2,405 2,054 2,054 Assets held for sale 19,500 19,728 22,511 Prepaid expenses and other 9,106 7,504 6,602 Total current assets 130,585 131,011 170,359 Property and equipment: Oil and matural gas properties Proved properties 6,212,323 6,104,092 6,018,568 Unproved properties 336,214 339,957 330,216 Drilling equipment 1,284,295 1,279,735 1,284,419 Gas gathering and processing equipment 798,503 781,970 767,388 Saltwater disposal systems 69,212 69,010 68,339 Corporate land and building 59,080 59,080 59,081 Transportation equipment 30,019 30,327 29,524 Other 57,900 57,624 57,507 9,419 223,604 8,731 227,044 5,901,661 332,886 1,632,540 751,715 67,074 59,081 29.103 56,750 5,809,850 325,595 1,612,817 736,488 65,218 59,081 29,918 56,381 Less accumulated depreciation, depletion, amortization and impairment Net property and equipment Goodwill Right of use asset Other assets Total assets 6,182,726 2,432,316 62,808 6,325,160 2,505, 62,808 6,263,504 2,431,844 62,808 6,289,575 2,557,971 62,808 8,302 33,863 2,793,529 6,225,220 2,496,575 62,808 4,551 34,235 2,729,180 32,570 2,698,053 28,703 2,820,765 28,113 2,749,809 131,129 45,175 132,899 48,084 149,945 49,664 4,519 13,887 194,710 756,590 256 3,556 102,700 142,485 143,552 67,743 1,051 13,067 14,150 239,563 643,921 1,542 2,369 14,310 197,662 685,031 475 1,952 103,832 144,369 14,250 213,859 644,475 114,411 49,064 4,648 18,555 14,036 200,714 643,371 910 293 101,234 144,748 101,410 164,964 102,928 158,232 Current liabilities: Accounts payable Accrued liabilities Income tax payable Current operating lease liability Current portion of other long-term liabilities Total current liabilities Long-term debt less debt issuance costs Non-current derivative liability Operating lease liability Other long-term liabilities Deferred income taxes Commitments and contingencies Shareholders' equity: Preferred stocks Common stocks Capital in excess of par value Accumulated other comprehensive loss Retained earinings Total shareholders' equity attributetable to Unit Corp Non-controlling interests in subsidiaries Total shareholders' equity Total liabilities and shareholders' equity 10,590 638,769 -487 741,001 10,578 633,361 -457 749,510 10,414 628,108 -481 752,840 10,414 626,746 -103 830,680 10,414 622,120 -65 811,781 1,389,873 1,392,992 1,390,881 1,467,737 1,444,250 203,359 1,593,232 2,793,529 202,867 1,595,859 2,729,180 202,563 1,593,444 2,698,053 201,628 1,669,365 2,820,765 199,404 1,643,654 2,749,809 6/30/18 102,318 46,926 54,059 203,303 32,418 31,894 39,703 104,015 58,373 Unit Corp Income Statement (in thousands except per share amounts) 6/30/19 3/31/19 12/31/18 9/30/18 Revenues: Oil and natural gas 77,815 86,095 106,019 111,623 Contract drilling 43,037 51,555 52,965 50,612 Gas gathering and processing 44,294 52,441 55,804 57,823 Total revenues 165,146 189,691 214,788 220,058 Expenses: Operating costs: Oil and natual gas 36,242 32,714 31,156 32,139 Contract drilling 29,308 31,401 35,792 32,032 Gas gathering and processing 32,491 39,355 43,395 43,134 Total operating costs 98,041 103,470 110,343 107,305 Depreciation, depletion and amortization 66,292 62,126 64,629 63,537 Impairments 147,884 General and administrative 10,064 9,741 9,955 9,278 (Gain) loss on dis sition of assets -422 1,615 -129 -253 Total operating expenses 173,975 176,952 332,682 179,867 Income (loss) from operations -8,829 12,739 -117,894 40,191 Other income (expense): Interest, net -8,995 -8,538 -7,816 -7,945 Gain (loss) on derivatives 7,927 -6,932 22,424 -4,385 Other, net 6 5 5 6 Total other income (expense) -1,062 -15,465 14,613 -12,324 Income (loss) before income taxes -9,891 -2,726 -103,281 27,867 Income tax expense (benefit) Current -3,131 Deferred -1,874 -444 -23,245 6,744 Total income taxes -1,874 -444 -26,376 6,744 Net income (loss) -8,017 -2,282 - 76,905 21,123 Net income attributable to non-controlling i 492 1,222 935 2,224 Net income (loss) attributable to Unit -8,509 -3,504 -77,840 18,899 Net income (loss) per common share -0.16 -0.07 -1.49 0.36 8,712 -161 170,939 32,364 -7,729 -14,461 5 -22,185 10,179 2,029 2,029 8,150 2,362 5,788 0.11
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