Prepare a common size balance sheet for the current years balance sheet and a common size income statement for thr current years income statement using excel

2361_OK_Homebuilders thousands current year last year Consolidated Balance Sheet Assets Current assets Cash and cash equivalents Receivables net of allowances Inventories Other current assets Total current assets $569,685 152,682 3,313,747 12.729 4.048.843 $386,003 125,488 3,218,387 8.084 3.737.962 Long term assets Property, Plant and Equipment (net) Natural resources at cost less depletion Investments Deferred income taxes Other long term assets Total long term assets 71,558 782,196 112774 966.528 79,441 825,232 114 915 1.019.588 $5.015,371 $4.757550 Total assets Liabilities Current liabilities Accounts payable Accrued liabilities Total current liabilities 183,770 513.414 697.184 172,716 409.882 582.598 Long term liabilities Long term notes payable Other long term liabilities Total long term liabilities 2,925,536 1817 2.927.353 2,576,525 2.517 2.579.042 Total liabilities $3,624,537 $3,161,640 Stockholders' equity Common stock Additional paid-in capital Other equity inc treasury stock Retained earnings Total stockholders' equity 115,548 682,871 (874,298) 1.466.713 1,390.834 115,387 668,657 (579,390) 1391.256 1595.910 Total liabilities and stockholders' equity $5.015, 371 $4.757 550 2361_OK_Homebuilders thousands Retained earnings statement Retained earings, 1/1 Add net income Less dividends paid Retained eamings 12/31 $1,391,256 84,643 9.186 $1.466.713 Consolidated Income statement Net sales Less cost of goods sold (without depreciation) Gross margin General and administrative expenses Depreciation (not inventoried) Operating income Interest income Other income (loss) Income before interest and taxes (EBIT) Interest expense Income before taxes Income tax expense (refund) Net income thousands $3,032,030 2.539.368 492,662 343,298 3.411 145,953 458 2.488 148,899 21.856 127,043 42.400 $84.643