I need the attached problems solved on an excel document

Financial Statement Analysis ACCT 311 Examination 1 Problems Complete Problem 1 and 2 and submit to the dropbox Unit 3 Exam I Problems no later than October 1, 11:59PM. Prepare the Common size statements using Excel ( Make sure you use the functions). Save as an Excel document. ( 5 points each) Problem 1 1. Using the following balance sheet, prepare a common size balance sheet: Assets Current assets Cash 4 Short-term investments 9 Accounts receivable 32 Inventory 41 Prepaid expenses 2 Deferred taxes, current 7 Total current assets 95 Liabilities and stockholders' equity Current liabilities Accounts payable 28 Current portion of long-term debt 12 Total current liabilities 40 Long-term liabilities Long-term debt 48 Total liabilities 88 Long-term assets Property & equipment 53 Goodwill 30 Long-term investments 8 Other assets 1 Stockholders' equity Common stock and PIC 51 Retained earnings Total assets 169 12 Total stockholders' equity81 Total liabilities and equity 169 Problem 2 2. Using the following information prepare a common size income statement: Net sales Cost of goods sold Gross profit General and administrative expenses Selling expenses Operating profit Income tax expense Net profit $9,500 5,900 $3,600 1,250 920 $1,430 460 $ 970 \fProblem 2 Net sales $9,500 Cost of goods sold Gross profit General and administrative expenses Selling expenses Operating profit Income tax expense Net profit $3,600 $1,430 $970 Problem 1 Current assets Cash Short-term investments Accounts receivable Inventory Prepaid expenses Deferred taxes, current Total current assets Long-term assets Property & equipment Goodwill Long-term investments Other assets Total assets 4 2.37% 9 5.33% 32 18.93% 41 24.26% 2 1.18% 7 4.14% 95 56.21% 53 31.36% 12 7.10% 8 4.73% 1 0.59% 169 100.00% 100.00% 5900 62.11% 37.89% 1250 13.16% 920 9.68% 15.05% 460 4.84% 10.21% Current liabilities Accounts payable Current portion of long-term debt 28 16.57% 12 7.10% 40 23.67% Long-term liabilities Long-term debt 48 28.40% 88 52.07% Total liabilities Stockholders' equity Common stock and PIC Retained earnings Total stockholders' equity Total liabilities and equity 51 30.18% 30 17.75% 81 47.93% 169 100.00%