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

thousands current year last year 2361_OK_Homebuilders Consolidated Balance Sheet Assets Current assets Cash and cash equivalents Receivables net of allowances Inventones 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 112.774 966,528 79.441 825,232 114,915 1.019,588 $5.015371 $4.757.550 Total assets Liabilities Current liabilities Accounts payable Accrued liabilities Total current liabilities Long term liabilities Long term notes payable Other long term liabilities Total long term liabilities 183,770 513414 697 184 172,716 409.882 582.598 2,925,536 1.817 2.927.353 2,576,525 2.517 2.579.042 $3,624,537 $3,161,640 Total liabilities Stockholders' equity Common stock Additional paid-in capital Other equity inc treasury stock Retained earings Total stockholders' equity 115,548 682,871 (874,298) 1.466.713 1.390.834 115,387 668,657 (579,390) 11391256 1.595.910 Total liabilities and stockholders' equity $5.015,371 $4.7574550 thousands current year last year 2361_OK_Homebuilders Consolidated Balance Sheet Assets Current assets Cash and cash equivalents Receivables net of allowances Inventones 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 112.774 966,528 79.441 825,232 114,915 1.019,588 $5.015371 $4.757.550 Total assets Liabilities Current liabilities Accounts payable Accrued liabilities Total current liabilities Long term liabilities Long term notes payable Other long term liabilities Total long term liabilities 183,770 513414 697 184 172,716 409.882 582.598 2,925,536 1.817 2.927.353 2,576,525 2.517 2.579.042 $3,624,537 $3,161,640 Total liabilities Stockholders' equity Common stock Additional paid-in capital Other equity inc treasury stock Retained earings Total stockholders' equity 115,548 682,871 (874,298) 1.466.713 1.390.834 115,387 668,657 (579,390) 11391256 1.595.910 Total liabilities and stockholders' equity $5.015,371 $4.7574550