use excel

Use the adjusted trial balance below as a starting point. These are prior to closing entries being posted. Note: To get the proper numbers in you might want to create a classified balance sheet (Don't forget to close expenses and revenue) Calculate the following financial ratios: Note: These ratios have been presented throughout the book. There is a overview of them in appendix A. A) Working Capital B) Current Ratio C) Quick Ratio D) Debt-To-Equity Ratio E) Accounts Receivable Turnover (All sales on credit) F) Total Asset Turnover G) Inventory Turnover H) Days' Sales in Inventory 1) Profit Margin J) Return on Total Assets K) Write a short analysis of inventory management. Have they done a better job this year of managing inventory? Assume ending inventory 2 years ago was equal to ending inventory last year