I need answer for this horizontal balance sheet

Financial Data collected 20X1 20X2 Financial Department Note Cash 30,600 37,170 Business bank account balance at the end of the year Common Stock 434,498 554,753 Common shares at the end of the year Accounts Receivable 25,500 13,452 Outstanding Accounts Receivable at the end of the year Retained earnings 280,500 226,560 Accumulated earning for previous years Inventories 26,605 56,640 Warehouse inventory balance at the end of the year Prepaid Expenses 5,950 5,876 Advance payment for future Land 255,000 265,500 Land property balance at the end of the year Building 1,713,600 1,784,160 Building property balance at the end of the year China, Glass, etc. 510,000 619,500 Other investment assets property Accumulated depreciation 782,447 991,200 Total accumulated depreciation Deferred income taxes ---Current 14,450 14,868 Current deferred income tax owing Accounts payable 23,800 28,320 Owing balance at the end of the year Long-term debt 952,000 885,000 10 Year total long-term loan borrowed from the bank Current portion of long-term debt 95,200 88,500 Current Year portion of the long-term loan owing Accrued Expense 3,400 3,717 Owing to utility providers Marketable Securities 19,040 10,620 Investment in GIC and securities Required Other Info 1) Rearrange the Accounts order following the Balance Sheet Format 2001 Total Revenue 5,200,000 2) Calculate the sub-total for each category accounts on the Balance sheet 2002 Total Revenue 4,360,000 3) Calculate net working capital for 20x1 and 20x2 4) Calculate the amount change and percentage changes from 20x1 to 20x2. 2001 Net profit 325,000 5) Calculate the following ratio 2002 Net profit 2,360,000 Current Ratio Acid Test Ratio A/R turn-over Ratio and Avg collection period Solvency Ratio Debt to Equity Ratio Asset turn-over Ratio Profit Margin ROA ROE