URGENT! PLEASE HELP ME WITH RATIOS!
Comprehensive Problem 2- St of Cash Flows and Ratios Algo C. Manuel Inc. C. Manuel Inc. Comparative Balance Sheets Income Statement For years ended December 31, 2017 and 2018 December 31, 2018 and 2017 2018 2017 Change Current assets: 2018 2017 Sales (all on credit) Cost of goods sold Gross margin $755,000 $717,000 $103,490 36,000 44,000 $56,100 $47,390 Cash Accounts recelvable (net) Inventory Prepaid expenses Other current assets (383.000) (314.000). 372,000 403,000 30,000 6,000 42,000 2,000 2,000 4,500 -2.500 51,000 37,000 2.880 Depreciation expense Other operating 4400 1520 51,370 162,000 134,000 Total current assets 188.370 137,000 expenses Total operating 199,000 185,000 expenses 173,000 218,000 54,000 24,000 Operating income 78,000 Long-term Investments Other income 305,000 255,000 50,000 Plant assets (expenses) (4.700) (3,500) Less: accumulated depreciation Interest expense (77,800) (51,000) 26,800 Galn on sale of investments Loss on sale of plant 5,100 Total plant assets 227,200 7,300 204,000 23.200 395,000 98,570 (4,500) (5.400) Total assets 493,570 assets Total other income (16,500) (3,800) (expenses) Current liabilities: ncome before income Accounts payable $25,500 $26,000 $-500 171,100 214,200 axes 7,200 (51,330) (64,260) $119,770$149,940 Accrued liabilities 1,200 ncome taxes expense 6,000 Net income Income taxes payable 15,000 -10,900 47,000 -10,200 4,100 36,800 Total current liabilities Long term liabilities Notes Payable C. Manuel Inc. 175,000 61,000 Statement of Retained Earnings For the year ended December 31, 2018 2017 236.000 272.800 Total liabilities 222,000 50,800 2018 $0 Stockholders' equity Common stock, $5 par value Additional paid-in capital $35,000 Ret. earnings, Jan. 1 Add: net income 110,000 119,770 149,940 110,000 C Deduct: Dividends (72.000) (114,940) 28,000 28,000 ncrease in retained earnings Ret. earnings, Dec. 31 Retained earnings 47770 35,000 35.000 477ZO 82.770 $82,770 $35.000 Total stockholders' equity 173,000 220,770 47,770 Total liabilities and $493,570 $395,000 $98,570 stockholders' equity Other information: Shares of common stock outstaning Earnings per share Dividends per share Market price per share, common stock 22,000 22,000 $5.44 $3.27 $6.82 $5.22 $17 $13 Cash Flows Horiz Analysis Horiz Analysis Vertic Analysis Vertic Analysis Inc St Ratios from Oper Bal St Inc St Bal Sheet Enter Numerator Value Choose Numerator Enter Denominator Ratio Choose Denominator Value Current ratio Acid-test ratio Inventory turnover Days' sales in inventory Accounts receivable turnover Days' sales in receivables Total asset turnover Debt-to-equity ratio Profit margin Return on total assets Return on common stockholders' equity Price/earnings ratio (P/E) Dividend yield
