course supply chain management

subject data and financial management in supply chain

Financial Data collected Cash 21,600 Common Stock Accounts Receivable Retained earnings Inventories 174,704 48,000 576,600 18,000 4,200 Prepaid Expenses Land 202,200 Building 1,293,600 China, Glass, etc. 360,000 Accumulated depreciation 552,316 58,500 Deferred income taxes-Current Accounts payable $5,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 o 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 Advancement 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 stility providers 107,950 Investment in GIC and securities Other info: 2001 Total Revenue 2002 Total Revenue 2,600,000 2,180,000 2001 Net profit 195,000 1,416,000 2002 Net profit