Financial Data collected 20X1 20X2 Financial Department Note Cash Common Stock Accounts Receivable Retained earnings Inventories Prepaid Expenses Land Building China, Glass, etc. Accumulated depreciation Deferred income taxes ---Current Accounts payable Long-term debt Current portion of long-term debt Accrued Expense Marketable Securities 18,000 255,587 15,000 200,000 15,650 3,500 150,000 1,008,000 300,000 460,263 8,500 14,000 560,000 21,000 2,000 11,200 21,000 Business bank account balance at the end of the year 313,420 Common shares at the end of the year 7,600 Outstanding Accounts Receivable at the end of the year 160,000 Accumulated earning for previous years 32,000 Warehouse inventory balance at the end of the year 3,320 Advance payment for future 150,000 Land property balance at the end of the year 1,008,000 Building property balance at the end of the year 350,000 Other investment assets property 560,000 Total accumulated depreciation 8,400 Current deferred income tax owing 16,000 Owing balance at the end of the year 500,000 Total long-term loan borrowed from the bank 18,000 Current portion of the loan owing 2,100 Owing to utility providers 6,000 Investment in GIC and securities Date First Last Student ID MGMT(52A) In-class Assignment2 Required 1) Rearrange the Accounts order following the Balance Sheet Format 2) Calculate the sub-total for each category accounts on the Balance sheet 3) Calculate net working capital for 20x1 and 20x2 4) Calculate the amount change and percentage changes from 20x1 to 20x2. 5) Calculate the following ratio 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 (Assume the 2001 Revenue 1,300,000, profit is 65,000, Operating Cash flow is 201,000. 2002 Revenue 1,090,000, profit is 472,000, operating cash flow is $192,000 HERZO Dust Extraction Cutting Guard for 4 Financial Data collected 20X1 20X2 Financial Department Note Cash Common Stock Accounts Receivable Retained earnings Inventories Prepaid Expenses Land Building China, Glass, etc. Accumulated depreciation Deferred income taxes ---Current Accounts payable Long-term debt Current portion of long-term debt Accrued Expense Marketable Securities 18,000 255,587 15,000 200,000 15,650 3,500 150,000 1,008,000 300,000 460,263 8,500 14,000 560,000 21,000 2,000 11,200 21,000 Business bank account balance at the end of the year 313,420 Common shares at the end of the year 7,600 Outstanding Accounts Receivable at the end of the year 160,000 Accumulated earning for previous years 32,000 Warehouse inventory balance at the end of the year 3,320 Advance payment for future 150,000 Land property balance at the end of the year 1,008,000 Building property balance at the end of the year 350,000 Other investment assets property 560,000 Total accumulated depreciation 8,400 Current deferred income tax owing 16,000 Owing balance at the end of the year 500,000 Total long-term loan borrowed from the bank 18,000 Current portion of the loan owing 2,100 Owing to utility providers 6,000 Investment in GIC and securities Date First Last Student ID MGMT(52A) In-class Assignment2 Required 1) Rearrange the Accounts order following the Balance Sheet Format 2) Calculate the sub-total for each category accounts on the Balance sheet 3) Calculate net working capital for 20x1 and 20x2 4) Calculate the amount change and percentage changes from 20x1 to 20x2. 5) Calculate the following ratio 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 (Assume the 2001 Revenue 1,300,000, profit is 65,000, Operating Cash flow is 201,000. 2002 Revenue 1,090,000, profit is 472,000, operating cash flow is $192,000 HERZO Dust Extraction Cutting Guard for 4