FORMULAS DATA REVIEW VIEW Wrap Ted General FILE HOME INSERT PAGE LAYOUT X Cut Calibri -111 Copy Paste BIU- Format Painter Clipboard Font -Ai & A. Merge & Center - $ . % 8. Conditional Format as Cell Formatting Table Styles Styles Alignment Number N34 X & fi B D E F H Ratios Calculation Liabilities and Equity Liquidity Current Quick 1 Balance Sheet(5000) 2 Assets 3 4 Cash $ 5 Marketable securities $ 6 Accounts receivable $ 7 Inventory s 8 Total current assets S 9 Fixed assets (net) S 10 Total assets S 11 25,000 1,500 2,500 15,000 33.000 52,000 35.000 87.000 Accounts payable 5 12,500 Notes payable $ 12.500 Total current liabilities $ Long-term debt $ 22.000 Total liabilities S 47.000 Common stock (par value) $ 5,000 Contributed capital in excess of par S 18,000 Retained earnings 17.000 Total stockholders' equity $40.000 Total liabilities and stockholders' equit S. 87.000 Asset Management Average collection period Inventory turnover Fixed-asset turnover Total asset turnover 12 13 Other info Financial leverate Debt Debt-to-equity Times interest earned Fixed charge coverage Stock Price Book value/share Number of shares $9.50 $8.00 5,000 in thousands 14 15 Income Statement (5000) 16 17 Sales (all on credit) $ 18 Cost of sales $ 19 Gross margin $ 20 Operating expenses S 21 EBIT $ 22 Interest 5 23 EBT $ 24 Income Tax $ EAT S 130,000 103,000 27,000 16,000 11,000 3.000 8,000 3,000 Profitability Gross profit margin Net profit margin Return on investment Return on stockholders' equity 5,000 26 Market-based Price-to earnings Market price-to-book 27 includes 200 in lease payments 3-14 ST READY