Northern Reflections sells outdoor sporting equipment. You have been working for the company since i inception a few years ago and have been promoted to be their accounting manager. They use the perpe inventory system and use the weigted average method to determine value for the inventory. The opening balances for the month of September are as follows: Northern Reflections Balance Sheet As at September 30, 2020 Assets Current Assets Cash $27,200 Accounts Receivable 16,000 Merchandise Inventory 13,000 Total Current Assets 56,200 Proptery, Plant & Equipment Equipment 130,000 Accumulated Depreciation -35,000 95,000 Total Assets $151,200 Liabilities Current Liabilities Accounts Payable $16,200 Current Portion of Bank Loan 6,000 Total Current Liabilities $22,200 Non-Current Liabilities Non-Current Portion of Bank Loan Total Liabilities Shareholders' Equity Common Shares Retained Earnings Total Shareholders' Equity Total Liabilities & Equity 18,000 $40,200 50,000 61,000 111,000 $151,200 The bank loan has an annual interest rate of 5% and has monthly principal payment of $500. The inventory figure includes 500 units purchased at $26.00 each. The Chart of Accounts (GL no.) is shown below: Account Description Account # Account Description Account # ASSETS REVENUE Cash 101 Sales Revenue 400 Petty Cash 105 Sales Discounts 405 Accounts Receivable 110 Sales Returns and Allowances 410 Merchandise Inventory 120 Interest Revenue 420 Prepaid Insurance 125 EXPENSES Equipment 140 Cost of Goods Sold 500 Accumulated Depreciation 145 Employee Benefits Expense 510 LIABILITIES Depreciation Expense 515 Accounts Payable 200 Insurance Expense 520 Interest Payable 205 Interest Expense 525 CPP Payable 220 Office Supplies Expense 530 El Payable 225 Rent Expense 535 Income Tax Payable 230 Salaries Expense 540 Salaries Payable 235 Bank Charges Expense 545 Unearned Revenue 240 Maintenance Expense 550 Bank Loan 245 Entertainment Expense 555 SHAREHOLDERS' EQUITY Common Shares 300 Retained Earnings 305 Transactions for the month of October: Oct 1 Oct 2 Oct 5 Bought inventory from Outdoor Muzi on account, invoice #5455; 900 units at $28 each. Terms of the purchase were 4/10, net 30. Update the inventory table after each purchase. Sold goods to Outback Kian, 600 units at $80 each with invoice #4741. The invoice terms were 5/10, net 30. Update the inventory table after each sale. Paid $1,100 with cheque #143 to Outdoor Muzi for an amount owing from last month. Bought inventory from Climb Foe with cheque #144, 650 units at $29 per unit. Oct 5 Oct 7 Returned 150 defective units to Climb Foe and received cash. Oct 8 Received $800 from Firewood Bill for a sale on account last month. Oct 10 Oct 31 Oct 31 Required: Outback Kian paid invoice #4741 on time and took advantage of the early payment discount. Prepared the payroll for October. Gross pay is $8,000, CPP is $408, El is $150 and income tax is $1,600. The employer matches CPP contributions and pays 1.4 times the El deduction. Use the general journal to record this. The cheque will be prepared later. Made monthly bank loan payment of $600 which includes $500 principal and $100 interest. i) Record the transactions above in the general journal and then post amounts to the General Ledger. Note: Also remember to enter your posting references. ii) Use this chart to keep track of transactions that involved inventory values Purchases Sales Balance Date Quantity Unit Cost Value Quantity Unit Cost Value Quantity Unit Cost Value 500 26.00 13,000.00 iii) Using the following information, prepare the bank reconciliation for October 31, 2020 Your staff accountant goes through the mail and opens the bank statement for the month of October provided by Fansh Bank. It is shown below. Fanshawe Local Bank Prepared for Northern Reflections Date Information Withdrawal Deposit Balance Opening Balance 13,000.00 Oct 2 Deposit 14,200.00 27,200.00 Oct 5 Chq#143 1,100.00 26,100.00 Oct 8 Deposit 45,600.00 71,700.00 Oct 8 Deposit 4,350.00 76,050.00 Oct 11 Chq#8240 2,400.00 73,650.00 Oct 31 Service Charge 60.00 73,590.00 Oct 31 Interest 5.00 73,595.00 Ot 31 Loan 600.00 72,995.00 General Ledger Accounts Account: Date Cash GL No: Description PR DR CR Balance (DR or CR) Opening Balance 27,200.00 DR Oct 5 Chq#143 GJ3 1,100.00 26,100.00 DR Oct 5 Chq#144 GJ3 18,850.00 7,250.00 CR Oct 7 Return of inventory GJ3 4,350.00 11,600.00 CR Oct 8 Deposit GJ3 800.00 12,400.00 CR Oct 10 Deposit GJ3 45,600.00 58,000.00 DR Oct 31 Loan 600 57,400.00 DR Additional Information: a) The $14,200 is already recorded in the ledger last month. b) Cheque number of the company has only three (3) digits. Required: Prepare the October bank reconciliation for Northern Reflections 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. 101 NOTE: DON'T FORGET TO RECORD ANY JOURNAL ENTRIES RESULTING FROM THE BANK RECONCILIATION IN THE GENERAL JOURNAL AND POST TO THE RELEVANT LEDGER ACCOUNTS Cash balance per bank statement: Add: Deduct: Northern Reflections Bank Reconciliation Statement October 31, 2020 Cash balance per books: Add: Deduct: Adjusted Bank Balance Adjusted Bank Balance iv) Prepare the financial statements for the month ended October 31, 2020. Northern Reflections Balance Sheet As at September 30, 2020 Assets Current Assets Cash Accounts Receivable Merchandise Inventory Total Current Assets $27,200 16,000 13,000 56,200 Proptery, Plant & Equipment Equipment 130,000 Accumulated Depreciation -35,000 95,000 Total Assets $151,200 Liabilities Current Liabilities Accounts Payable $16,200 Current Portion of Bank Loan 6,000 Cash Accounts Receivable Merchandise Inventory Total Current Assets $27,200 16,000 13.000 56,200 Proptery, Plant & Equipment Equipment 130,000 Accumulated Depreciation -35,000 95,000 Total Assets $151,200 Liabilities Current Liabilities Accounts Payable $16,200 Current Portion of Bank Loan 6,000 Total Current Liabilities $22,200 Non-Current Liabilities Non-Current Portion of Bank Loan Total Liabilities Shareholders' Equity Common Shares Retained Earnings Total Shareholders' Equity Total Liabilities & Equity 18,000 $40,200 50,000 61,000 111,000 $151,200 1) Prepare a multistep income statement. Northern Reflections Income Statement For the Month Ended October 31, 2020 2) Prepare a calculation of retained earnings Calculation of Retained Earnings For the Month Ended October 31, 2020 3) Prepare a classified balance sheet. Assume that $6,000 of the bank loan will be paid off in the next year. Northern Reflections Balance Sheet As at October 31, 2020 v) Based on the information above, answer the following questions. a) Calculate the current ratio as at October 31, 2020 b) Does Norther Reflections have a good or bad current ratio? Explain why or why not. c) Calculate the inventory days on hand ratio as at October 31, 2020. (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 37 days. Has the ratio improved? Why or why not? f) Calculate the gross profit margin as at October 31, 2020. g) Last month, the gross profit margin percentage was 75%. What could have caused this decrease in gross margin percentage? h) Calculate the inventory turnover as at October 31, 2020. i) If inventory turnover last month was 0.837, is the company holding on to inventory for a longer or shorter period of time? iii) Using the following information, prepare the bank reconciliation for October 31, 2020 Your staff accountant goes through the mail and opens the bank statement for the month of October provided by Fanshaw Bank. It is shown below. Fanshawe Local Bank Prepared for Northern Reflections Date Information Withdrawal Deposit Balance Opening Balance 13,000.00 Oct 2 Deposit 14,200.00 27,200.00 Oct 5 Chq#143 1,100.00 26,100.00 Oct 8 Deposit 45,600.00 71,700.00 Oct 8 Deposit 4,350.00 76,050.00 Oct 11 Chq#8240 2,400.00 73,650.00 Oct 31 Service Charge 60.00 73,590.00 Oct 31 Interest 5.00 73,595.00 Oct 31 Loan 600 72,995.00 General Ledger Accounts Account: Cash GL No: Date Description PR DR CR Balance (DR or CR) Opening Balance 27,200.00 DR Oct 5 Chq#143 GJ3 1,100.00 26,100.00 DR Oct 5 Chq#144 GJ3 18,850.00 7,250.00 CR Oct 7 Return of inventory GJ3 4,350.00 11,600.00 CR Oct 8 Deposit GJ3 800.00 12,400.00 CR Oct 10 Deposit GJ3 45,600.00 58,000.00 DR Oct. 31 Loan 600.00 57,400 DR Additional Information: a) The $14,200 is already recorded in the ledger last month. b) Cheque number of the company has only three (3) digits. Required: Prepare the October bank reconciliation for Northern Reflections 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. 101