Find the ratios for 2007-Q1, 2006,2005,2004.
G H I 2007- 2006 2005 2004 Amount Percent Amount Percent Amount Percent Amount Percent 2.93% 7.97% 7.65% 33.67% 34.74% 3L 80% 278 41 10% 243 41 33% 84.95 84.51% 0.73% 202 3L ROX -17.09% -12.39% 15.05 103 15. 49% 19.22% 100.00% 100.00% Cash Accounts receivable Inventory Total current assets Property and equipment accumulated depreciation Total PPSE, Net 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 100,00% 15.31% 6.32% 32.8% 76% 179% 206% 2. % 24 3.61% SL 44.21% 17. * 23. 76% 0.95% TL 33% 452 67.97% 404 63 71% 28 67% 69.01% 30.99% 100.00% 32.03% JL 29% 100.00% 100.00% 100.00% AutoSave OFF A AE sro - Insert Draw Page Layout Formulas Home Data Review 12 X = = = LOW Calibri (Body) - BI U v P A A E12 Xv fx A 1 Solvency Ratios B C D E 2007-01 2006 2005 2004 3 Current 4 Quick 5 Debt to Equity Gross Profit Margin 7 Pre-Tax Profit Margin 8 Return on Assets 9 Return on Equity 10 Sales to Assets 11 Inventory Turnover 12 Inventory Days 13 ACCT. Receivable Turnover 14 Collection Period (Days) 15 Acct Receivable Turnover 16 Accounts Payable Days G H I 2007- 2006 2005 2004 Amount Percent Amount Percent Amount Percent Amount Percent 2.93% 7.97% 7.65% 33.67% 34.74% 3L 80% 278 41 10% 243 41 33% 84.95 84.51% 0.73% 202 3L ROX -17.09% -12.39% 15.05 103 15. 49% 19.22% 100.00% 100.00% Cash Accounts receivable Inventory Total current assets Property and equipment accumulated depreciation Total PPSE, Net 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 100,00% 15.31% 6.32% 32.8% 76% 179% 206% 2. % 24 3.61% SL 44.21% 17. * 23. 76% 0.95% TL 33% 452 67.97% 404 63 71% 28 67% 69.01% 30.99% 100.00% 32.03% JL 29% 100.00% 100.00% 100.00% AutoSave OFF A AE sro - Insert Draw Page Layout Formulas Home Data Review 12 X = = = LOW Calibri (Body) - BI U v P A A E12 Xv fx A 1 Solvency Ratios B C D E 2007-01 2006 2005 2004 3 Current 4 Quick 5 Debt to Equity Gross Profit Margin 7 Pre-Tax Profit Margin 8 Return on Assets 9 Return on Equity 10 Sales to Assets 11 Inventory Turnover 12 Inventory Days 13 ACCT. Receivable Turnover 14 Collection Period (Days) 15 Acct Receivable Turnover 16 Accounts Payable Days