PORLAR V H 5 , , FILE HOME INSERT MQ Problem Set Class - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW 127 1 X B C D E F G K L M H Ratios Calculation Liabilities and Equity 1 Balance Sheet($000) 2 Assets 3 4 Cash S 5. Marketable securities S 6 Accounts receivable $ 7 Inventory S 3 Total current assets S 9 Fixed assets (net) S 0 Total assets S Current Quick 0.15 Current Assets / Current Liabilities (Current Assets - Inventory Current Lab 1,500 2,500 15,000 30.000 52,000 35.000 87.000 Accounts payable $ 12,500 Notes payable 12.500 Total current liabilities $ 25.000 Long-term debt 22.000 Total liabilities $12.000 Common stock par value) $ 5,000 Contributed capital in excess of par $ 18,000 Retained earnings $12.000 Total stockholders' equity $40.000 Total liabilities and stockholders' equils 22.000 Awet Menacement Average collection period Inventory turnover Fixed asset turnover Total asset turnover 42 12 3.12 3.71 365 Accounts Receivable/Sales Cost of Goods sold/Inventory Net Sales/Net Fred Assets Sales/Total Assets 2 3 4 5 Income Statement (5000) Other info Einancial levere Dett Deto-equity Times interest earned Fixed charge coverage 054 11 3.67 Total Debt/Total Assets Total Debt Total Stockholders' Equity EBIT interest Expense EDIT:lease payment interest ease pa s Stock Price Book value/share Number of shares $9.50 $8.00 5.000 in thousands 20,77 7 Sales Call on credit) Cost of sales 5 9 Gross margin 5 Operating expenses S 1 EBIT $ 2 Interest $ 3 EBT $ Income Tax S 5 EAT s 130,000 103,000 27,000 16 000 11,000 3,000 8.000 3.000 5.000 Profily Gross profit margin Net profit margin Return on investment Return on stockholders' equity 575 12.50 Gross margin/Salon 100 Net Income Sales 100 Net Income Total Assets 100 Net Income / Total Stockholders' Equity Market based Price to earning Market price-to-book 0.26 | includes 200 in lease payments 3-14 ST