Financial Statement Analysis.

Please make it as an Excel with formula.

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