ratios

Tools Data Window Excel File Edit View Insert Format O AutoSave OFF BES U = Home Insert Draw Page Layout Formulas Data Review View EE Jour ub Calibri (Body) 12 AA BI U v EBA F A B C D E Solvency Ratios 2007-01 2006 2005 2004 3 Current 1.54396728 1.63636364 1.24336283 2.13963964 4 Quick 32.593047 5 Debt to Equity 0.7132948 0.69005102 0.67969925 0.68707483 6 Gross Profit Margin 7 Pre-Tax Profit Margin 8 Return on Assets 9 Return on Equity 10 Sales to Assets 0.14437086 0.63663664 0.67793594 0.67368421 11 Inventory Turnover 12 Inventory Days 13 ACCT Receivable Turnover 14 Collection Period (Days) 15 Acct Receivable Turnover 16 Accounts Payable Days A A = & Wrap Text General Calibri (Body) 11 BIVA x 755 = E Paste Merge & Center $ - % , B6 x B 2007-01 Amount 2006 Percent Amount Percent 3 Cash 202 4 Accounts receivable 5 Inventory 6 Total current assets 7 Property and equipment 8 accumulated depreciation 9 Total PPSE, Net 10 Total Assets 11 Accounts payable 12 Line of credit payable 13 Accrued expenses 14 Long-term debt, current portion 15 Current liabilities 16 Long-term debt 17 Total Liabilities 18 Net Worth 19 Total Liabilities and net worth 3.70% 33.53% 49.94% 87.28% 29.13% -16.42% 12.72% 100.00% 23.47% 28.90% 2.93% 33.67% 48.34% 84.95% 32.14% -17.09% 15.05% 100.00% 15.31% 31.76% 1.79% 3.06% 51.91% 17.09% 69.01% 30.99% 100.00% F G 2005 Amount Percent 7.97% 231 34.74% 41.80% 84.51% 30.38% -99 -14.89% 103 15.49% 665 100.00% 6.32% 214 32.18% 14 2.11% 24 3.61% 294 44.21% 158 23.76% 452 67.97% 213 32.03% 100.00% HI 2004 Amount Percent 7.65% 31.80% 41.33% 80.78% 31.80% -12.59% 19.22% 100.00% 6.12% 25.34% 2.21% 4.08% 222 37.76% 182 30.95% 404 68.71% 31.29% 588 100.00% 1.39% 2.77% 56.53% 14.80% 71.33% 28.67% 184 865 100.00% 665 wN 5 Net Sales 6 COGS 7 Gross profit on Sales 8 Operating Expense 9 Interest Expense 10 Net Income before Taxes 11 Income taxes 12 Net Income First Quarter 2007 2006 2005 2004 Amount Percent Amount Percent Amount Percent Amount Percent 608.00 100.00% $ 2,242.00 100.00% $ 1,916.00 100.00% $ 1,624.00 100.00% 499.00 82.10% $ 1,818.00 81.10% $ 1,535.00 80.11% $ 1,304.00 80.30% 109.00 18.00% $ 424.00 18.90% $ 381.00 19.90% $ 320,00 19.70% 94.00 15.50% $ 347.00 15.50% $ 307.00 16.02% $ 272.00 8.00 1.30% $ 31.00 1.40% $ 30.00 1.60% $ 27.00 1.70% 7.00 1.15% $ 46.00 2.05% S 44.00 2.30% $ 21.00 1.30% 2.00 0.33% $ 16.00 0.71% $ 15.00 0.78% $ 7.00 0.43% 5.00 0.82% $ 30.00 1.34% $ 29.00 1.50% $ 14.00 0.86% 16.80%