Question: Please provide the things required in the question as i am not able to do it SquareFit owned by Chandler Bing, is a freestyle clothing
Please provide the things required in the question as i am not able to do it








SquareFit owned by Chandler Bing, is a freestyle clothing retailer. You were hired to account the transactions and report the status of the business. They use the perpetual inventory system and use the weigted average method to determine value for the inventory. Its balance sheet as at January 31, 2021, is presented below. SquareFit Classified Balance Sheet As at January 31 , 2021 Assets Cash $35,600 Accounts Receivable 18,190 Merchandise Inventory 46,720 Prepaid Insurance 4,400 Total Current Assets 104,910 Long-Term Assets Equipment 162,000 Accumulated Depreciation -52,000 110,000 Total Assets $214,910 Liabilities Current Liabilities Accounts Payable $14,800 Unearned Revenue $8,800 Salaries Payable $5,700 Current Portion of Bank Loan 11,160 Total Current Liabilities $40,460 Non-Current Liabilities Non-Current Portion of Bank Loan 23,840 Total Liabilities $64,300 Shareholders' Equity Common Shares 81,000 Retained Earnings 69,610 Total Shareholders' Equity 150,610 Total Liabilities & Equity $214,910 The bank loan has an annual interest rate of 9% and has monthly principal payment of $930. The inventory figure includes 1,460 units purchased at $32.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 Other Income 430 Equipment 140 EXPENSES Accumulated Depreciation 145 Cost of Goods Sold 500 LIABILITIES Employee Benefits Expense 510 Accounts Payable 200 Depreciation Expense 515 Interest Payable 205 Insurance Expense 520 CPP Payable 220 Interest Expense 525 El Payable 225 Office Supplies Expense 530 Income Tax Payable 230 Rent Expense 535 Salaries Payable 235 Salaries Expense 540 Unearned Revenue 240 Bank Charges Expense 545 Bank Loan 245 Maintenance Expense 550 SHAREHOLDERS' EQUITY Entertainment Expense 555 Common Shares 300 Shipping Expense 560 Retained Earnings 305 Cash Over and Short 565Transactions for the month of February: Feb 1 Paid rent for February amounting to $660, Cheque #3354 Feb 1 SquareFit decided to establish a petty cash fund for the office. A cheque #3355 of $600 was issued and cashed. Purchased merchandise from Arrow on account, invoice #425; 1100 units at $28 each. Terms Feb 5 the purchase were 4/10, net 30, FOB Destination. The seller paid the shipping cost amounting $55. Update the inventory table after each purchase. Feb 7 Sold mechandise to Prada, 800 units at $75 each with invoice #2341. The invoice terms were 3/10, net 30, FOB Destination. Feb 9 Some of goods purchased from Arrow was defective. Arrow agreed to a 5% allowance on the total purchased. Note: You will need to adjust the Inventory Valuation to reflect the above allowance Feb 12 Paid total liability with a cheque #3356 to Arrow for the February 5 purchased. The employees are paid bi-weekly. Paid the payroll for the first half of February. Gross pay is Feb 15 $12,500, CPP is $638, El is $235 and income tax is $2,500. Use the general journal to record thi Use cheque #3357. Feb 15 Record the employer's share of CPP (100%) and Er (140%) of what was deducted from employees. Feb 17 Prada paid invoice #2341 on time and took advantage of the early payment discount. Note: You will need to adjust the Inventory Valuation to reflect the discount. Feb 18 Bought Inventory from MaxMara with cheque #3358, 1400 units at $30 per unit. Feb 20 Sold 600 units at $90 each with invoice #2342 to ZARA. The invoice term 3/10, net 30, FOB shipping point Feb 20 Received $2,230 from Gucci for a sale on account last month. The remaining balance of the petty cash account was $266. Total expenses incurred using the Feb 25 petty cash fund this month amounting to $261. In this amount, it includes the shipping cost incurred on Feb 7 in the amount of $55 and the other costs are for the office supplies expense. Prepare the entry to replenish the petty cash fund with Chq#3359 . Made monthly bank loan payment of $1, 193 which includes $930 principal and $263 interest. Feb 28 Note: You need to debit the non-current portion of the bank loan for the principal payment. The current portion due will remain the same as the due date for the loan is greater than 12 months from balance sheet date. At the end of February, the following adjustment had to be journalized to properly report the balances of the company's accounts: Prepared the payroll for the second half of February to be paid on March 5. Gross pay is Feb 28 $13,900, CPP is $709, El is $261 and income tax is $2,780. The cheque will be prepared later. Use the general journal to record this. Feb 28 Record the employer's share of CPP (100%) and El (140%) of what was deducted from employees.Balance of Prepaid Insurance represents 11 months left on the policy, Record the adjustment of Feb 28 $400 to the current month expense. Feb 28 Of the beginning balance of unearned revenue, $2,640 still remains unearned. Feb 28 Monthly depreciation on the equipment was $2,000. Required: a) Prepare the journal entries for the month of February b)Post the above journal entries to the general ledger accounts. Opening balances have been entered for you from the Balance Sheet. c) Complete the bank reconciliation report. d) Prepare the journal entries from the bank reconciliation and post to the general ledger accounts. el Complete the 10-column worksheet. e) Prepare the journal entries for the adjusting entries f) Post the adjustments to the general ledger accounts. g) Prepare the multistep income statement, calculation of retained earnings, classified balance sheet h)Answer the analysis questions from 'a' to 'I'.Your accountant goes through the mall and opens the bank statement for the month of February provided by Bank. of Canada. It is shown below. Bank of Canada Prepared for SquareFit Date Information Withdrawal Deposit Balance Opening Balance 24.300.00 Feb 1 Paid Cho#3355 600.00 23.700.00 Feb 8 Deposit 11,300.00 35,000.00 Feb 14 Paid Cho#3356 28,089.60 6,910.40 Feb 15 Chq # 3357 9,127.00 -2,216.60 Feb 17 Deposit 58,200.00 55,983.40 Feb 18 Cho#3358 42,000.00 13,983.40 Feb 19 Chq#11140 3,390.00 10,593.40 Feb 25 Cho#3359 334.00 10,259.40 Feb 28 Auto debit loan payment 1,193.00 9,066.40 Feb 28 Service Charge 340,00 8,726.40 Feb 28 Interest 290.00 9,016.40 General Ledger Accounts Account: Cash GL NO: 101 Date Description PR DR CR Balance (DR or CR) Opening Balance 35,600.00 |DR Feb 1 Paid Chq#3354 GJ3 660.00 34,940.00 DR Feb 1 Paid Cho#3355 GJ3 600 34,340.00|DR Feb 12 Paid Cho#3356 G13 28,089.60 6,250.40 DR Feb 15 Paid Chq#3357 GIE 9,127.00 -2,876.60 |CR Feb 17 Received payment GJ3 58,200.00 55,323.40 DR Feb 18 Paid Inventory Cho# 3358 GJ3 42,000.00 13,323.40 DR Feb 20 Received payment GJ3 2,230.00 15,553.40 |DR Feb 25 Petty Cash Cho#3359 GJ3 334 15,219.40 DR Feb 28 Paid loan GJ3 1,193.00 14,026.40 |DR Additional Information: a) The $11,300 is already recorded in the ledger last month. b) Cheque number of the company has only three (4) digits. Required: Prepare the February bank reconciliation for SquareFit 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'sSquareFit Classified Balance Sheet As at January 31 , 2021 Assets Cash $35,600 Accounts Receivable $18,190 Merchandise Inventory $46,720 Prepaid Insurance $4,400 Total Current Assets 104,910 Long-Term Assets Equipment 162,000 Accumulated Depreciation -52,000 110,000 Total Assets $214,910 Liabilities Current Liabilities Accounts Payable $14,800 Unearned Revenue $8,800 Salaries Payable $5,700 Current Portion of Bank Loan $11,160 Total Current Liabilities $40,460 Non-Current Liabilities Non-Current Portion of Bank Loan 23.840 Total Liabilities $64,300 Shareholders' Equity Common Shares 81,000 Retained Earnings 69,610 Total Shareholders' Equity 150,610 Total Liabilities & Equity $214,910 Required: Using the balances of the General Ledger accounts as of Feb. 28, complete the financial statements.Based on the information above, answer the following questions. a) Calculate the current ratio as at February 28, 2021 b) Does SquareFit have a good or bad current ratio? Explain why or why not. c) 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 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
