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