1 Rearrange the Accounts order following the Balance Sheet Format 2 Calculate the sub-total for each categorv accounts on the Balance sheet 3 Calculate net working capital for 20x1 and 20x2 4 Calculate the amount change and percentage changes from zUx1 to zUxZ. 5 Calculate the following ratio
current ratio Acid lest RatIo A/R turn-over Ratio and Avg collection period Solvency Ratio
debt to equality ratio Debt to Fauity Ratio Profit Margin ROA ROE
Financial Data collected Cash Common Stock 21,600 174,704 48,000 576,600 Accounts Receivable Retained earnings Inventories 18,000 Prepaid Expenses 4,200 Land 202,200 Building 1,293,600 China, Glass, etc. 360,000 Accumulated depreciation 552,316 Deferred income taxes ---Current 58,500 Accounts payable 55,440 Long-term debt 600,000 Current portion of long-term debt 73,200 Accrued Expense 3,240 Marketable Securities 73,200 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 ROA ROE 20X1 20X2 Financial Department Note 30,480 Business bank account balance at the end of the year 194,843 Common shares at the end of the year 76,200 Outstanding Accounts Receivable at the end of the year 748,157 Accumulated earning for previous years 92,710 Warehouse inventory balance at the end of the year 4,216 Advance payment for future 213,995 Land property balance at the end of the year 1,369,060 Building property balance at the end of the year 469,900 Other investment assets property 711,200 Total accumulated depreciation 61,722 Current deferred income tax owing 60,325 Owing balance at the end of the year 584,200 Total long-term loan borrowed from the bank 73,660 Current portion of the above loan owing 4,064 Owing to utility providers 107,950 Investment in GIC and securities 2,600,000 2,180,000 195,000 1,416,000 Other Info: 2001 Total Revenue 2002 Total Revenue 2001 Net profit 2002 Net profit Financial Data collected Cash Common Stock 21,600 174,704 48,000 576,600 Accounts Receivable Retained earnings Inventories 18,000 Prepaid Expenses 4,200 Land 202,200 Building 1,293,600 China, Glass, etc. 360,000 Accumulated depreciation 552,316 Deferred income taxes ---Current 58,500 Accounts payable 55,440 Long-term debt 600,000 Current portion of long-term debt 73,200 Accrued Expense 3,240 Marketable Securities 73,200 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 ROA ROE 20X1 20X2 Financial Department Note 30,480 Business bank account balance at the end of the year 194,843 Common shares at the end of the year 76,200 Outstanding Accounts Receivable at the end of the year 748,157 Accumulated earning for previous years 92,710 Warehouse inventory balance at the end of the year 4,216 Advance payment for future 213,995 Land property balance at the end of the year 1,369,060 Building property balance at the end of the year 469,900 Other investment assets property 711,200 Total accumulated depreciation 61,722 Current deferred income tax owing 60,325 Owing balance at the end of the year 584,200 Total long-term loan borrowed from the bank 73,660 Current portion of the above loan owing 4,064 Owing to utility providers 107,950 Investment in GIC and securities 2,600,000 2,180,000 195,000 1,416,000 Other Info: 2001 Total Revenue 2002 Total Revenue 2001 Net profit 2002 Net profit
