Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
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
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
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
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669167c095673_312669167c022a40.jpg)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started