solve this 4Cash 5 Common Stock 6 Accounts Receivable 7 Retained earnings 8 Inventories 9 Prepaid Expenses 10 Land 11 Building 12 China, Glass, etc. 13 Accumulated depreciation 14 Deferred income taxes ---Current 15 Accounts payable 16 Long-term debt 17 Current portion of long-term debt 18 Accrued Expense 19 Marketable Securities 30,600 434,498 25,500 280,500 26,605 5,950 255,000 31 Debt to Equity Ratio 32 Asset turn-over Ratio. 33 Profit Margin 34 ROA 1,713,600 510,000 782,447 14,450 23,800 952,000 95,200 3,400 19,040 21 Required 22 1) Rearrange the Accounts order following the Balance Sheet Format 23 2) Calculate the sub-total for each category accounts on the Balance sheet 24 3) Calculate net working capital for 20x1 and 20x2 25 4) Calculate the amount change and percentage changes from 20x1 to 20x2. 26 5) Calculate the following ratio 27 Current Ratio 28 Acid Test Ratio 29 A/R turn-over Ratio and Avg collection period 30 Solvency Ratio 37,170 554,758 13,452 226,560 56,640 5,876 265,500 1,784,160 619,500 991,200 14,868 28,320 885,000 88,500 3,717 10,620 Other Info 2001 Total Revenue 2002 Total Revenue 2001 Net profit 2002 Net profit