Your accountant goes through the mail and opens the bank statement for the month of February provided by Bank of Canada. It is shown below. . Date Feb 1 Feb 8 Feb 14 Bank of Canada Prepared for Tees R Us Information Withdrawal Deposit Opening Balance Paid Chq#3355 500.00 Deposit 11,300.00 Paid Ch#3356 28,089.60 Paid Cha#3357 9,127.00 Deposit 58,200.00 Cha#3358 42,000.00 Chq#11140 3,390.00 Cha#3359 350.00 Auto debit loan payment 1,076.00 Service Charge 34.00 Interest 290.00 Balance 24,300.00 23,800.00 35,100.00 7,010.40 -2,116.60 56,083.40 14,083.40 10,693.40 10,343.40 Feb 15 Feb 17 Feb 18 Feb 19 Feb 25 Feb 28 9,267,40 Feb 28 Feb 28 | | | 9,233.40 9,523.40 101 PR DR GJ3 GJ3 General Ledger Accounts Account: Cash Date Description Opening Balance Feb 1 Paid Ch#3354 Feb 1 Paid Chq#3355 Feb 12 Paid Chg83356 Feb 15 Paid Cha#3357 Feb 17 Received payment Feb 18 Paid inventory Ch#3358 Feb 20 Received payment Feb 25 Petty Cash Cha#3359 Feb 28 Paid loan GJ3 GL No: CR Balance (DR or CR) 35,600.00 DR 660.00 34,940.00 DR 500.00 34,440.00 DR 28,089.60 6,350.40 IDR 9,127.00 2,776.60 ICR 55,423.40 IDR 42,000.00 13,423.40 DR 16,623.40 DR 350.00 16,273,40 DR 1,076.00 15,197.40 DR GJ3 GJE 58,200.00 GIE GJ3 3,200.00 GJ3 G3 Additional Information: a) The $11,300 is already recorded in the ledger last month. b) Cheque number of the company has (4) digits. Required: Prepare the February bank reconciliation for Tees R Us using the bank statement and general ledger provided. Compare the information in the general ledger to the bank statement. Once reconciled, record the relevant journal entries in the general journal and post the entries in the general ledger to bring the company's record up to date. . Tees R Us Classified Balance Sheet As at January 31, 2021 , Assets Cash $35,600 $16,870 $12,500 $ $4,400 69,370 Accounts Receivable Merchandise Inventory Prepaid Insurance Total Current Assets Long-Term Assets Equipment Accumulated Depreciation Total Assets 162,000 -52,000 110,000 $179,370 Liabilities Current Liabilities Accounts Payable Unearned Revenue Salaries Payable Current Portion of Bank Loan Total Current Liabilities Non-Current Liabilities Non-Current Portion of Bank Loan Total Liabilities $12,000 $9,000 $5,700 $11,160 $37,860 23,840 $61,700 Shareholders' Equity Common Shares Retained Earnings Total Shareholders' Equity Total Liabilities & Equity 81,000 36,670 117,670 $179,370 Required: 3)Using the balances of the General Ledger accounts as of Feb. 28, complete the financial statements. 1) Prepare a multistep income statement. Tees R Us R Income Statement For the Month Ended February 28, 2021 Sales Revenue Sales Discounts Net Sales Cost of Goods Sold Gross Profit Operating Expenses Employee Benefits Expense Depreciation Expense Insurance Expense Office Supplies Expense Rent Expense Salaries Expense Bank Charges Expense Shipping Expense Cash Over & Short Total Operating Expenses Operating Income Other Income and Expenses Interest Expense Interest Revenue Total Other Income and Expenses Net Income 2) Prepare a calculation of retained earnings Calculation of Retained Earnings For the Month Ended February 28, 2021 Retained Earnings, Beginning Add: Net Income Less: Dividends Retained Earnings, End 3) Prepare a classified balance sheet. Assume that $ of the bank loan will be paid off in the 12 months. Tees R Us Balance Sheet As at February 28, 2021 Assets Current Assets Cash Petty Cash Accounts Receivable Merchandise Inventory Prepaid Insurance Total Current Assets Long-Term Assets Equipment Accumulated Depreciation Total Assets Liabilities Current Liabilities Accounts Payable CPP Payable El Payable Income Tax Payable Salaries Payable Unearned Revenue Current Portion of Bank Loan Total Current Liabilities Non-Current Liabilities Non-Current Portion of Bank Loan Total Liabilities Shareholders' Equity Common Shares Retained Earnings Total Liabilities & Shareholders' Equity 3) Prepare a classified balance sheet. Assume that $ of the bank loan will be paid off in the 12 months. Tees R Us Balance Sheet As at February 28, 2021 Assets Current Assets Cash Petty Cash Accounts Receivable Merchandise Inventory Prepaid Insurance Total Current Assets Long-Term Assets Equipment Accumulated Depreciation Total Assets Liabilities Current Liabilities Accounts Payable CPP Payable El Payable Income Tax Payable Salaries Payable Unearned Revenue Current Portion of Bank Loan Total Current Liabilities Non-Current Liabilities Non-Current Portion of Bank Loan Total Liabilities Shareholders' Equity Common Shares Retained Earnings Total Liabilities & Shareholders' Equity h)Based on the information above, answer the following questions. a) Calculate the current ratio as at February 28, 2021 b) Does Tees R Us have a good or bad current ratio? Explain why or why not. #DIV/0! Calculate the inventory days on hand ratio as at February 28, 2021. (Since this is for the month, do not multiply by 365 in the formula. Instead multiply by 31 days.) d) Last month, the inventory days on hand ratio was 39 days. Has the ratio improved? Why or why not? e) Calculate the debt to equity ratio as at February 28, 2021. f) Calculate the gross profit margin as at February 28, 2021. g) Last month, the gross profit margin percentage was 70%. What could have caused this decrease in gross margin percentage? h) Calculate the inventory turnover as at February 28, 2021. i) If inventory turnover last month was 0.81, is the company holding on to inventory for a longer or shorter period of time