Goulet Inc., set up as a privately held corporation, operating as a ready to wear garments...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Goulet Inc., set up as a privately held corporation, operating as a ready to wear garments retailer, of which 100% of the Common Shares are owned by Lawrence Goulet. You were hired to account for transactions for the month of August 2023, complete month end processing, prepare the financial statements and perform a financial ratio analysis as of the end of that month. They use perpetual inventory system and use the weigted average method to determine value for the inventory. Its balance sheet as at July 31, 2023, is presented below. Goulet Inc. Classified Balance Sheet As at July 31, 2023 Assets Cash $81,240 Accounts Receivable 30,090 Merchandise Inventory 27,600 Prepaid Insurance 9,200 Total Current Assets 148,130 Long-Term Assets Equipment 175,000 Accumulated Depreciation -92,000 83,000 Total Assets $231,130 Liabilities Current Liabilities Accounts Payable $29,200 Unearned Revenue $17,000 Salaries Payable $9,600 Current Portion of Bank Loan 22,560 Total Current Liabilities $78,360 Non-Current Liabilities Non-Current Portion of Bank Loan 33,840 Total Liabilities $112,200 Shareholders' Equity Common Shares Retained Earnings Total Shareholders' Equity 93,200 25,730 118,930 $231,130 Total Liabilities & Equity Notes Relating to Balances: Customers and balances Suppliers and Balances Vachon Inc. $7,120 Design Shirts Co. $15,400 Dunn Inc. $9,250 Printed Shirts Corp. $8,300 Picard Inc. $6,620 Gabe Clothing Co. $5,500 Moreau Inc. $4,100 Total $29,200 Duncan Inc. $3,000 Total $30,090 The bank loan has an annual interest rate of 7% and has monthly principal payment of $1,880. 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 565 Required: a) Prepare the journal entries for the month of August. You will also need to update the inventory in the table for each purchase and sale, return or allowance, found under the Inventory Valuation tab of this workbook. b) Post the above journal entries to the general ledger accounts. c) Complete the bank reconciliation report. d) Record the journal entries from the bank reconciliation and post amounts to general ledger accounts. e) Prepare the multistep income statement, calculation of retained earnings, classified balance sheet found under the financial statements tab of this workbook. f) Answer the analysis questions from 'a' to 'i' found under the financial statements tab of this workbook. Transactions for the month of August: Aug 1 Aug 1 Aug 5 Aug 5 Aug 7 Paid the amount owing from July 31 for salaries payable amounting to $9,600, Cheque #7107. Paid rent for August amounting to $1050, Cheque #7108 Goulet Inc. decided to establish a petty cash fund for the office. A cheque #7109 of $600 was issued and cashed. Purchased merchandise from Design Shirts Co. on account, invoice #425; 6,100 units at $26 each. Terms of the purchase were net 30, FOB Destination. The seller paid the shipping cost amounting to $522. Note: Update the Inventory Valuation table after each purchase. Sold mechandise on accout to Dunn Inc., 4,250 units at $60 each with invoice #100102. The invoice terms were 3/10, net 30, FOB Destination. Note: Update the Inventory Valuation table after each sale. Aug 12 Paid $15,400 with a cheque #7110 to Design Shirts Co. for the July invoices owing. Aug 14 Dunn Inc. paid invoice #100102 less the discount. Aug 15 Aug 15 Aug 18 The employees are paid bi-weekly. Paid the payroll for the first half of August, cheque #7111. Gross pay is $17,500, CPP is $893, El is $329 and income tax is $3,500. Use the general journal to record this. Record the employer's share of CPP (100%) and El (140%) of what was deducted from employees. Bought inventory from Gabe Clothing Co. with cheque #7112, 3,600 units at $22 per unit. Note: Update Inventory Valuation table to reflect purchase. Aug 20 Aug 20 Received $7,120 from Vachon Inc. for a sale on account last month. Sold 3,000 units on account at $63 each with invoice #100103 to Moreau Inc.. The invoice term 3/10, net 30, FOB shipping point. Note: Update Inventory Valuation table. Aug 25 Aug 31 Aug 31 Aug 31 The remaining balance of the petty cash account was $245. Total expenses incurred using the petty cash fund this month amounting to $230. In this amount, it includes the shipping cost incurred on August 7 in the amount of $166 and the other costs are for the office supplies expense. Prepare the entry to replenish the petty cash fund with Chq #7113. Made monthly bank loan payment of $2,209 which includes $1,880 principal and $329 interest. Prepared the payroll for the second half of August to be paid on September 5. Gross pay is $19,000, CPP is $969, El is $357 and income tax is $3,800. The cheque will be prepared later. Use the general journal to record this. Record the employer's share of CPP (100%) and El (140%) of what was deducted from employees. General Journal Page 3 Date Account Title and Explanation PR DR CR Page 4 General Journal Date Account Title and Explanation PR DR CR General Journal Date Account Title and Explanation PR DR Page 5 CR General Ledger Accounts Account: Cash Date Description Opening Balance Account: Petty Cash Date Description Opening Balance PR DR CR GL No: 101 Balance (DR or CR) 81,240.00 DR GL No: PR DR CR 105 Balance (DR or CR) 0.00 DR Account: Accounts Receivable GL No: 110 Date Description PR DR CR Opening Balance Balance (DR or CR) 30,090.00 DR Account: Merchandise Inventory Date Description Opening Balance GL No: PR DR CR Account: Prepaid Insurance Date Description PR DR CR Opening Balance 120 Balance (DR or CR) 27,600.00 DR GL No: 125 Balance (DR or CR) 9,200.00 DR Account: Date Equipment Description Opening Balance PR DR CR GL No: 140 Balance (DR or CR) 175,000.00 DR GL No: PR DR CR Account: Date Accumulated Depreciation Description Opening Balance Account: Date Accounts Payable Description Opening Balance R PR 145 Balance (DR or CR) 92,000.00 CR GL No: DR CR 200 Balance (DR or CR) 29,200.00 CR Account: Interest Payable GL No: 205 Date Description PR DR CR Opening Balance Balance (DR or CR) 0.00 CR Account: Date CPP Payable Description Opening Balance Account: El Payable Date Description Account: Date Opening Balance Income Tax Payable Description Opening Balance GL No: PR DR CR 220 Balance (DR or CR) 0.00 CR GL No: PR DR CR PR DR CR 225 Balance (DR or CR) 0.00 CR GL No: 230 Balance (DR or CR) 0.00 CR Account: Date Salaries Payable Description Opening Balance GL No: PR DR CR 235 Balance (DR or CR) 9,600.00 CR Account: Unearned Revenue GL No: 240 Date Description PR DR CR Opening Balance Balance (DR or CR) 17,000.00 CR Account: Bank Loan GL No: 245 Date Description PR DR CR Opening Balance Balance (DR or CR) 56,400.00 CR Account: Common Shares GL No: 300 Date Description PR DR CR Opening Balance Balance (DR or CR) 93,200.00 CR Account: Retained Earnings GL No: 305 Date Description PR DR CR Opening Balance Balance (DR or CR) 25,730.00 CR Account: Sales Revenue GL No: Date Description PR DR CR 400 Balance (DR or CR) Account: Date Account: Date Sales Discounts Description GL No: PR DR CR 405 Balance (DR or CR) Sales Returns and Allowances Description PR DR CR GL No: 410 Balance (DR or CR) Account: Date Account: Date Interest Revenue Description Cost of Goods Sold Description PR DR CR PR DR CR Account: Employee Benefits Expense Date Description Account: Depreciation Expense Date Description PR DR CR PR DR CR Account: Insurance Expense Date Description PR DR CR GL No: 420 Balance (DR or CR) GL No: 500 Balance (DR or CR) GL No: 510 Balance (DR or CR) GL No: 515 Balance (DR or CR) GL No: 520 Balance (DR or CR) Account: Interest Expense GL No: Date Description PR DR CR 525 Balance (DR or CR) Account: Date Account: Date Office Supplies Expense Description Rent Expense Description PR DR CR PR DR CR GL No: 530 Balance (DR or CR) GL No: 535 Balance (DR or CR) Account: Date Account: Date Salaries Expense Description Bank Charges Expense Description PR DR CR PR DR CR Account: Entertainment Expense Date Description PR DR CR Account: Date Account: Date Shipping Expense Description Cash Over and Short Description GL No: 540 Balance (DR or CR) GL No: 545 Balance (DR or CR) GL No: 555 Balance (DR or CR) GL No: PR DR CR 560 Balance (DR or CR) PR DR CR GL No: 565 Balance (DR or CR) Notes: Round unit cost to 2 decimal places, then apply to quanity sold when determining total cost of goods sold. Use this chart to keep track of inventory values The inventory figure includes 1,200 units purchased at $23.00 each. Date Quantity Purchases Unit Cost Value Quantity Sales Unit Cost Value Quantity Balance Unit Cost Value 1,200 23.00 27,600.00 Your accountant goes through the mail and opens the bank statement for the month of August provided by Bank of Commerce. It is shown below. Bank of Commerce Prepared for Goulet Inc. Date Information Withdrawal Deposit Balance Opening Balance 49,780.00 Aug 1 Paid Chq#7107 9,600.00 40,180.00 Aug 1 Deposit 31,460.00 71,640.00 Aug 5 Paid Chq#7109 600.00 71,040.00 Aug 14 Paid Chq#7110 15,400.00 55,640.00 Aug 14 Deposit 247,350.00 302,990.00 Aug 15 Paid Chq#7111 12,778.00 290,212.00 Aug 18 Paid Chq#7112 79,200.00 211,012.00 Aug 20 Chq#45210 8,470.00 202,542.00 Aug 25 Chq #7113 355.00 202,187.00 Aug 31 Auto debit loan payment 2,209.00 199,978.00 Aug 31 Service Charge 240.00 199,738.00 Aug 31 Interest 125.00 199,863.00 General Ledger Accounts Account: Date Cash Description PR DR CR GL No: Balance (DR or CR) Opening Balance 81,240.00 DR Aug 1 Paid Chq #7107 9,600.00 71,640.00 DR Aug 1 Paid Chq#7108 GJ3 1,050.00 70,590.00 DR Aug 5 Paid Chq#7109 GJ3 600.00 69,990.00 DR Aug 12 Paid Chq#7110 GJ3 15,400.00 54,590.00 DR Aug 14 Received payment GJ3 247,350.00 301,940.00 DR Aug 15 Paid Chq#7111 GJ3 12,778.00 289,162.00 DR Aug 18 Paid inventory Chq#7112 GJ3 79,200.00 209,962.00 DR Aug 25 Petty Cash Chq#7113 GJ3 355.00 216,727.00 DR Aug 30 Received payment GJ3 7,120.00 217,082.00 DR Aug 31 Paid loan GJ3 2,209.00 214,518.00 DR Additional Information: a) The $31,460 is already recorded in the ledger last month. b) Cheque number of the company has (4) digits. Required: Prepare the August bank reconciliation for Goulet Inc. using the bank statement and general ledger provided. Compare the information in the general ledger to the bank statement. Once reconciled, record the 101 relevant journal entries in the general journal and post the entries in the general ledger to bring the company's record up to date. Goulet Inc. Bank Reconciliation Statement August 31, 2023 Explanation Balance per Balance per books Bank Assets Cash Goulet Inc. Classified Balance Sheet As at July 31, 2023 Accounts Receivable Merchandise Inventory Prepaid Insurance $81,240 $30,090 $27,600 $9,200 148,130 Total Current Assets Long-Term Assets Equipment 175,000 Accumulated Depreciation -92,000 83,000 Total Assets $231,130 Liabilities Current Liabilities Accounts Payable $29,200 Unearned Revenue $17,000 Salaries Payable $9,600 Current Portion of Bank Loan $22,560 Total Current Liabilities $78,360 Non-Current Liabilities Non-Current Portion of Bank Loan Total Liabilities 33,840 $112,200 Shareholders' Equity Common Shares Retained Earnings Total Shareholders' Equity Total Liabilities & Equity 93,200 25,730 118,930 $231,130 Required: Using the balances of the General Ledger accounts as of August 31, complete the financial statements. 1) Prepare a multistep income statement. Goulet Inc. Income Statement For the Month Ended August 31, 2023 2) Prepare a calculation of retained earnings Calculation of Retained Earnings For the Month Ended August 31, 2023 3) Prepare a classified balance sheet. Assume that $22,560 of the bank loan will be paid off in the 12 months. Goulet Inc. Balance Sheet As at August 31, 2023 Based on the information above, answer the following questions. a) Calculate the current ratio as at August 31, 2023. b) Does Goulet Inc. have a good or bad current ratio? Explain why or why not. c) Calculate the inventory days on hand ratio as at August 31, 2023. (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 7 days. Has the ratio improved? Why or why not? e) Calculate the debt to equity ratio as at August 31, 2023. f) Calculate the gross profit margin as at August 31, 2023. g) Last month, the gross profit margin percentage was 63%. What could have caused this decrease in gross margin percentage? h) Calculate the inventory turnover as at August 31, 2023. i) If inventory turnover last month was 4.43 is the company holding on to inventory for a longer or shorter period of time? Goulet Inc., set up as a privately held corporation, operating as a ready to wear garments retailer, of which 100% of the Common Shares are owned by Lawrence Goulet. You were hired to account for transactions for the month of August 2023, complete month end processing, prepare the financial statements and perform a financial ratio analysis as of the end of that month. They use perpetual inventory system and use the weigted average method to determine value for the inventory. Its balance sheet as at July 31, 2023, is presented below. Goulet Inc. Classified Balance Sheet As at July 31, 2023 Assets Cash $81,240 Accounts Receivable 30,090 Merchandise Inventory 27,600 Prepaid Insurance 9,200 Total Current Assets 148,130 Long-Term Assets Equipment 175,000 Accumulated Depreciation -92,000 83,000 Total Assets $231,130 Liabilities Current Liabilities Accounts Payable $29,200 Unearned Revenue $17,000 Salaries Payable $9,600 Current Portion of Bank Loan 22,560 Total Current Liabilities $78,360 Non-Current Liabilities Non-Current Portion of Bank Loan 33,840 Total Liabilities $112,200 Shareholders' Equity Common Shares Retained Earnings Total Shareholders' Equity 93,200 25,730 118,930 $231,130 Total Liabilities & Equity Notes Relating to Balances: Customers and balances Suppliers and Balances Vachon Inc. $7,120 Design Shirts Co. $15,400 Dunn Inc. $9,250 Printed Shirts Corp. $8,300 Picard Inc. $6,620 Gabe Clothing Co. $5,500 Moreau Inc. $4,100 Total $29,200 Duncan Inc. $3,000 Total $30,090 The bank loan has an annual interest rate of 7% and has monthly principal payment of $1,880. Goulet Inc., set up as a privately held corporation, operating as a ready to wear garments retailer, of which 100% of the Common Shares are owned by Lawrence Goulet. You were hired to account for transactions for the month of August 2023, complete month end processing, prepare the financial statements and perform a financial ratio analysis as of the end of that month. They use perpetual inventory system and use the weigted average method to determine value for the inventory. Its balance sheet as at July 31, 2023, is presented below. Goulet Inc. Classified Balance Sheet As at July 31, 2023 Assets Cash $81,240 Accounts Receivable 30,090 Merchandise Inventory 27,600 Prepaid Insurance 9,200 Total Current Assets 148,130 Long-Term Assets Equipment 175,000 Accumulated Depreciation -92,000 83,000 Total Assets $231,130 Liabilities Current Liabilities Accounts Payable $29,200 Unearned Revenue $17,000 Salaries Payable $9,600 Current Portion of Bank Loan 22,560 Total Current Liabilities $78,360 Non-Current Liabilities Non-Current Portion of Bank Loan 33,840 Total Liabilities $112,200 Shareholders' Equity Common Shares Retained Earnings Total Shareholders' Equity 93,200 25,730 118,930 $231,130 Total Liabilities & Equity Notes Relating to Balances: Customers and balances Suppliers and Balances Vachon Inc. $7,120 Design Shirts Co. $15,400 Dunn Inc. $9,250 Printed Shirts Corp. $8,300 Picard Inc. $6,620 Gabe Clothing Co. $5,500 Moreau Inc. $4,100 Total $29,200 Duncan Inc. $3,000 Total $30,090 The bank loan has an annual interest rate of 7% and has monthly principal payment of $1,880. 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 565 Required: a) Prepare the journal entries for the month of August. You will also need to update the inventory in the table for each purchase and sale, return or allowance, found under the Inventory Valuation tab of this workbook. b) Post the above journal entries to the general ledger accounts. c) Complete the bank reconciliation report. d) Record the journal entries from the bank reconciliation and post amounts to general ledger accounts. e) Prepare the multistep income statement, calculation of retained earnings, classified balance sheet found under the financial statements tab of this workbook. f) Answer the analysis questions from 'a' to 'i' found under the financial statements tab of this workbook. 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 565 Required: a) Prepare the journal entries for the month of August. You will also need to update the inventory in the table for each purchase and sale, return or allowance, found under the Inventory Valuation tab of this workbook. b) Post the above journal entries to the general ledger accounts. c) Complete the bank reconciliation report. d) Record the journal entries from the bank reconciliation and post amounts to general ledger accounts. e) Prepare the multistep income statement, calculation of retained earnings, classified balance sheet found under the financial statements tab of this workbook. f) Answer the analysis questions from 'a' to 'i' found under the financial statements tab of this workbook. Transactions for the month of August: Aug 1 Aug 1 Aug 5 Aug 5 Aug 7 Paid the amount owing from July 31 for salaries payable amounting to $9,600, Cheque #7107. Paid rent for August amounting to $1050, Cheque #7108 Goulet Inc. decided to establish a petty cash fund for the office. A cheque #7109 of $600 was issued and cashed. Purchased merchandise from Design Shirts Co. on account, invoice #425; 6,100 units at $26 each. Terms of the purchase were net 30, FOB Destination. The seller paid the shipping cost amounting to $522. Note: Update the Inventory Valuation table after each purchase. Sold mechandise on accout to Dunn Inc., 4,250 units at $60 each with invoice #100102. The invoice terms were 3/10, net 30, FOB Destination. Note: Update the Inventory Valuation table after each sale. Aug 12 Paid $15,400 with a cheque #7110 to Design Shirts Co. for the July invoices owing. Aug 14 Dunn Inc. paid invoice #100102 less the discount. Aug 15 Aug 15 Aug 18 The employees are paid bi-weekly. Paid the payroll for the first half of August, cheque #7111. Gross pay is $17,500, CPP is $893, El is $329 and income tax is $3,500. Use the general journal to record this. Record the employer's share of CPP (100%) and El (140%) of what was deducted from employees. Bought inventory from Gabe Clothing Co. with cheque #7112, 3,600 units at $22 per unit. Note: Update Inventory Valuation table to reflect purchase. Aug 20 Aug 20 Received $7,120 from Vachon Inc. for a sale on account last month. Sold 3,000 units on account at $63 each with invoice #100103 to Moreau Inc.. The invoice term 3/10, net 30, FOB shipping point. Note: Update Inventory Valuation table. Aug 25 Aug 31 Aug 31 Aug 31 The remaining balance of the petty cash account was $245. Total expenses incurred using the petty cash fund this month amounting to $230. In this amount, it includes the shipping cost incurred on August 7 in the amount of $166 and the other costs are for the office supplies expense. Prepare the entry to replenish the petty cash fund with Chq #7113. Made monthly bank loan payment of $2,209 which includes $1,880 principal and $329 interest. Prepared the payroll for the second half of August to be paid on September 5. Gross pay is $19,000, CPP is $969, El is $357 and income tax is $3,800. The cheque will be prepared later. Use the general journal to record this. Record the employer's share of CPP (100%) and El (140%) of what was deducted from employees. Transactions for the month of August: Aug 1 Aug 1 Aug 5 Aug 5 Aug 7 Paid the amount owing from July 31 for salaries payable amounting to $9,600, Cheque #7107. Paid rent for August amounting to $1050, Cheque #7108 Goulet Inc. decided to establish a petty cash fund for the office. A cheque #7109 of $600 was issued and cashed. Purchased merchandise from Design Shirts Co. on account, invoice #425; 6,100 units at $26 each. Terms of the purchase were net 30, FOB Destination. The seller paid the shipping cost amounting to $522. Note: Update the Inventory Valuation table after each purchase. Sold mechandise on accout to Dunn Inc., 4,250 units at $60 each with invoice #100102. The invoice terms were 3/10, net 30, FOB Destination. Note: Update the Inventory Valuation table after each sale. Aug 12 Paid $15,400 with a cheque #7110 to Design Shirts Co. for the July invoices owing. Aug 14 Dunn Inc. paid invoice #100102 less the discount. Aug 15 Aug 15 Aug 18 The employees are paid bi-weekly. Paid the payroll for the first half of August, cheque #7111. Gross pay is $17,500, CPP is $893, El is $329 and income tax is $3,500. Use the general journal to record this. Record the employer's share of CPP (100%) and El (140%) of what was deducted from employees. Bought inventory from Gabe Clothing Co. with cheque #7112, 3,600 units at $22 per unit. Note: Update Inventory Valuation table to reflect purchase. Aug 20 Aug 20 Received $7,120 from Vachon Inc. for a sale on account last month. Sold 3,000 units on account at $63 each with invoice #100103 to Moreau Inc.. The invoice term 3/10, net 30, FOB shipping point. Note: Update Inventory Valuation table. Aug 25 Aug 31 Aug 31 Aug 31 The remaining balance of the petty cash account was $245. Total expenses incurred using the petty cash fund this month amounting to $230. In this amount, it includes the shipping cost incurred on August 7 in the amount of $166 and the other costs are for the office supplies expense. Prepare the entry to replenish the petty cash fund with Chq #7113. Made monthly bank loan payment of $2,209 which includes $1,880 principal and $329 interest. Prepared the payroll for the second half of August to be paid on September 5. Gross pay is $19,000, CPP is $969, El is $357 and income tax is $3,800. The cheque will be prepared later. Use the general journal to record this. Record the employer's share of CPP (100%) and El (140%) of what was deducted from employees. General Journal Page 3 Date Account Title and Explanation PR DR CR General Journal Page 3 Date Account Title and Explanation PR DR CR Page 4 General Journal Date Account Title and Explanation PR DR CR Page 4 General Journal Date Account Title and Explanation PR DR CR General Journal Date Account Title and Explanation PR DR Page 5 CR General Journal Date Account Title and Explanation PR DR Page 5 CR General Ledger Accounts Account: Cash Date Description Opening Balance Account: Petty Cash Date Description Opening Balance PR DR CR GL No: 101 Balance (DR or CR) 81,240.00 DR GL No: PR DR CR 105 Balance (DR or CR) 0.00 DR Account: Accounts Receivable GL No: 110 Date Description PR DR CR Opening Balance Balance (DR or CR) 30,090.00 DR Account: Merchandise Inventory Date Description Opening Balance GL No: PR DR CR Account: Prepaid Insurance Date Description PR DR CR Opening Balance 120 Balance (DR or CR) 27,600.00 DR GL No: 125 Balance (DR or CR) 9,200.00 DR General Ledger Accounts Account: Cash Date Description Opening Balance Account: Petty Cash Date Description Opening Balance PR DR CR GL No: 101 Balance (DR or CR) 81,240.00 DR GL No: PR DR CR 105 Balance (DR or CR) 0.00 DR Account: Accounts Receivable GL No: 110 Date Description PR DR CR Opening Balance Balance (DR or CR) 30,090.00 DR Account: Merchandise Inventory Date Description Opening Balance GL No: PR DR CR Account: Prepaid Insurance Date Description PR DR CR Opening Balance 120 Balance (DR or CR) 27,600.00 DR GL No: 125 Balance (DR or CR) 9,200.00 DR Account: Date Equipment Description Opening Balance PR DR CR GL No: 140 Balance (DR or CR) 175,000.00 DR GL No: PR DR CR Account: Date Accumulated Depreciation Description Opening Balance Account: Date Accounts Payable Description Opening Balance R PR 145 Balance (DR or CR) 92,000.00 CR GL No: DR CR 200 Balance (DR or CR) 29,200.00 CR Account: Interest Payable GL No: 205 Date Description PR DR CR Opening Balance Balance (DR or CR) 0.00 CR Account: Date CPP Payable Description Opening Balance Account: El Payable Date Description Account: Date Opening Balance Income Tax Payable Description Opening Balance GL No: PR DR CR 220 Balance (DR or CR) 0.00 CR GL No: PR DR CR PR DR CR 225 Balance (DR or CR) 0.00 CR GL No: 230 Balance (DR or CR) 0.00 CR Account: Date Equipment Description Opening Balance PR DR CR GL No: 140 Balance (DR or CR) 175,000.00 DR GL No: PR DR CR Account: Date Accumulated Depreciation Description Opening Balance Account: Date Accounts Payable Description Opening Balance R PR 145 Balance (DR or CR) 92,000.00 CR GL No: DR CR 200 Balance (DR or CR) 29,200.00 CR Account: Interest Payable GL No: 205 Date Description PR DR CR Opening Balance Balance (DR or CR) 0.00 CR Account: Date CPP Payable Description Opening Balance Account: El Payable Date Description Account: Date Opening Balance Income Tax Payable Description Opening Balance GL No: PR DR CR 220 Balance (DR or CR) 0.00 CR GL No: PR DR CR PR DR CR 225 Balance (DR or CR) 0.00 CR GL No: 230 Balance (DR or CR) 0.00 CR Account: Date Salaries Payable Description Opening Balance GL No: PR DR CR 235 Balance (DR or CR) 9,600.00 CR Account: Unearned Revenue GL No: 240 Date Description PR DR CR Opening Balance Balance (DR or CR) 17,000.00 CR Account: Bank Loan GL No: 245 Date Description PR DR CR Opening Balance Balance (DR or CR) 56,400.00 CR Account: Common Shares GL No: 300 Date Description PR DR CR Opening Balance Balance (DR or CR) 93,200.00 CR Account: Retained Earnings GL No: 305 Date Description PR DR CR Opening Balance Balance (DR or CR) 25,730.00 CR Account: Sales Revenue GL No: Date Description PR DR CR 400 Balance (DR or CR) Account: Date Account: Date Sales Discounts Description GL No: PR DR CR 405 Balance (DR or CR) Sales Returns and Allowances Description PR DR CR GL No: 410 Balance (DR or CR) Account: Date Salaries Payable Description Opening Balance GL No: PR DR CR 235 Balance (DR or CR) 9,600.00 CR Account: Unearned Revenue GL No: 240 Date Description PR DR CR Opening Balance Balance (DR or CR) 17,000.00 CR Account: Bank Loan GL No: 245 Date Description PR DR CR Opening Balance Balance (DR or CR) 56,400.00 CR Account: Common Shares GL No: 300 Date Description PR DR CR Opening Balance Balance (DR or CR) 93,200.00 CR Account: Retained Earnings GL No: 305 Date Description PR DR CR Opening Balance Balance (DR or CR) 25,730.00 CR Account: Sales Revenue GL No: Date Description PR DR CR 400 Balance (DR or CR) Account: Date Account: Date Sales Discounts Description GL No: PR DR CR 405 Balance (DR or CR) Sales Returns and Allowances Description PR DR CR GL No: 410 Balance (DR or CR) Account: Date Account: Date Interest Revenue Description Cost of Goods Sold Description PR DR CR PR DR CR Account: Employee Benefits Expense Date Description Account: Depreciation Expense Date Description PR DR CR PR DR CR Account: Insurance Expense Date Description PR DR CR GL No: 420 Balance (DR or CR) GL No: 500 Balance (DR or CR) GL No: 510 Balance (DR or CR) GL No: 515 Balance (DR or CR) GL No: 520 Balance (DR or CR) Account: Interest Expense GL No: Date Description PR DR CR 525 Balance (DR or CR) Account: Date Account: Date Office Supplies Expense Description Rent Expense Description PR DR CR PR DR CR GL No: 530 Balance (DR or CR) GL No: 535 Balance (DR or CR) Account: Date Account: Date Interest Revenue Description Cost of Goods Sold Description PR DR CR PR DR CR Account: Employee Benefits Expense Date Description Account: Depreciation Expense Date Description PR DR CR PR DR CR Account: Insurance Expense Date Description PR DR CR GL No: 420 Balance (DR or CR) GL No: 500 Balance (DR or CR) GL No: 510 Balance (DR or CR) GL No: 515 Balance (DR or CR) GL No: 520 Balance (DR or CR) Account: Interest Expense GL No: Date Description PR DR CR 525 Balance (DR or CR) Account: Date Account: Date Office Supplies Expense Description Rent Expense Description PR DR CR PR DR CR GL No: 530 Balance (DR or CR) GL No: 535 Balance (DR or CR) Account: Date Account: Date Salaries Expense Description Bank Charges Expense Description PR DR CR PR DR CR Account: Entertainment Expense Date Description PR DR CR Account: Date Account: Date Shipping Expense Description Cash Over and Short Description GL No: 540 Balance (DR or CR) GL No: 545 Balance (DR or CR) GL No: 555 Balance (DR or CR) GL No: PR DR CR 560 Balance (DR or CR) PR DR CR GL No: 565 Balance (DR or CR) Account: Date Account: Date Salaries Expense Description Bank Charges Expense Description PR DR CR PR DR CR Account: Entertainment Expense Date Description PR DR CR Account: Date Account: Date Shipping Expense Description Cash Over and Short Description GL No: 540 Balance (DR or CR) GL No: 545 Balance (DR or CR) GL No: 555 Balance (DR or CR) GL No: PR DR CR 560 Balance (DR or CR) PR DR CR GL No: 565 Balance (DR or CR) Notes: Round unit cost to 2 decimal places, then apply to quanity sold when determining total cost of goods sold. Use this chart to keep track of inventory values The inventory figure includes 1,200 units purchased at $23.00 each. Date Quantity Purchases Unit Cost Value Quantity Sales Unit Cost Value Quantity Balance Unit Cost Value 1,200 23.00 27,600.00 Notes: Round unit cost to 2 decimal places, then apply to quanity sold when determining total cost of goods sold. Use this chart to keep track of inventory values The inventory figure includes 1,200 units purchased at $23.00 each. Date Quantity Purchases Unit Cost Value Quantity Sales Unit Cost Value Quantity Balance Unit Cost Value 1,200 23.00 27,600.00 Your accountant goes through the mail and opens the bank statement for the month of August provided by Bank of Commerce. It is shown below. Bank of Commerce Prepared for Goulet Inc. Date Information Withdrawal Deposit Balance Opening Balance 49,780.00 Aug 1 Paid Chq#7107 9,600.00 40,180.00 Aug 1 Deposit 31,460.00 71,640.00 Aug 5 Paid Chq#7109 600.00 71,040.00 Aug 14 Paid Chq#7110 15,400.00 55,640.00 Aug 14 Deposit 247,350.00 302,990.00 Aug 15 Paid Chq#7111 12,778.00 290,212.00 Aug 18 Paid Chq#7112 79,200.00 211,012.00 Aug 20 Chq#45210 8,470.00 202,542.00 Aug 25 Chq #7113 355.00 202,187.00 Aug 31 Auto debit loan payment 2,209.00 199,978.00 Aug 31 Service Charge 240.00 199,738.00 Aug 31 Interest 125.00 199,863.00 Your accountant goes through the mail and opens the bank statement for the month of August provided by Bank of Commerce. It is shown below. Bank of Commerce Prepared for Goulet Inc. Date Information Withdrawal Deposit Balance Opening Balance 49,780.00 Aug 1 Paid Chq#7107 9,600.00 40,180.00 Aug 1 Deposit 31,460.00 71,640.00 Aug 5 Paid Chq#7109 600.00 71,040.00 Aug 14 Paid Chq#7110 15,400.00 55,640.00 Aug 14 Deposit 247,350.00 302,990.00 Aug 15 Paid Chq#7111 12,778.00 290,212.00 Aug 18 Paid Chq#7112 79,200.00 211,012.00 Aug 20 Chq#45210 8,470.00 202,542.00 Aug 25 Chq #7113 355.00 202,187.00 Aug 31 Auto debit loan payment 2,209.00 199,978.00 Aug 31 Service Charge 240.00 199,738.00 Aug 31 Interest 125.00 199,863.00 General Ledger Accounts Account: Date Cash Description PR DR CR GL No: Balance (DR or CR) Opening Balance 81,240.00 DR Aug 1 Paid Chq #7107 9,600.00 71,640.00 DR Aug 1 Paid Chq#7108 GJ3 1,050.00 70,590.00 DR Aug 5 Paid Chq#7109 GJ3 600.00 69,990.00 DR Aug 12 Paid Chq#7110 GJ3 15,400.00 54,590.00 DR Aug 14 Received payment GJ3 247,350.00 301,940.00 DR Aug 15 Paid Chq#7111 GJ3 12,778.00 289,162.00 DR Aug 18 Paid inventory Chq#7112 GJ3 79,200.00 209,962.00 DR Aug 25 Petty Cash Chq#7113 GJ3 355.00 216,727.00 DR Aug 30 Received payment GJ3 7,120.00 217,082.00 DR Aug 31 Paid loan GJ3 2,209.00 214,518.00 DR Additional Information: a) The $31,460 is already recorded in the ledger last month. b) Cheque number of the company has (4) digits. Required: Prepare the August bank reconciliation for Goulet Inc. using the bank statement and general ledger provided. Compare the information in the general ledger to the bank statement. Once reconciled, record the 101 General Ledger Accounts Account: Date Cash Description PR DR CR GL No: Balance (DR or CR) Opening Balance 81,240.00 DR Aug 1 Paid Chq #7107 9,600.00 71,640.00 DR Aug 1 Paid Chq#7108 GJ3 1,050.00 70,590.00 DR Aug 5 Paid Chq#7109 GJ3 600.00 69,990.00 DR Aug 12 Paid Chq#7110 GJ3 15,400.00 54,590.00 DR Aug 14 Received payment GJ3 247,350.00 301,940.00 DR Aug 15 Paid Chq#7111 GJ3 12,778.00 289,162.00 DR Aug 18 Paid inventory Chq#7112 GJ3 79,200.00 209,962.00 DR Aug 25 Petty Cash Chq#7113 GJ3 355.00 216,727.00 DR Aug 30 Received payment GJ3 7,120.00 217,082.00 DR Aug 31 Paid loan GJ3 2,209.00 214,518.00 DR Additional Information: a) The $31,460 is already recorded in the ledger last month. b) Cheque number of the company has (4) digits. Required: Prepare the August bank reconciliation for Goulet Inc. using the bank statement and general ledger provided. Compare the information in the general ledger to the bank statement. Once reconciled, record the 101 relevant journal entries in the general journal and post the entries in the general ledger to bring the company's record up to date. Goulet Inc. Bank Reconciliation Statement August 31, 2023 Explanation Balance per Balance per books Bank relevant journal entries in the general journal and post the entries in the general ledger to bring the company's record up to date. Goulet Inc. Bank Reconciliation Statement August 31, 2023 Explanation Balance per Balance per books Bank Assets Cash Goulet Inc. Classified Balance Sheet As at July 31, 2023 Accounts Receivable Merchandise Inventory Prepaid Insurance $81,240 $30,090 $27,600 $9,200 148,130 Total Current Assets Long-Term Assets Equipment 175,000 Accumulated Depreciation -92,000 83,000 Total Assets $231,130 Liabilities Current Liabilities Accounts Payable $29,200 Unearned Revenue $17,000 Salaries Payable $9,600 Current Portion of Bank Loan $22,560 Total Current Liabilities $78,360 Non-Current Liabilities Non-Current Portion of Bank Loan Total Liabilities 33,840 $112,200 Shareholders' Equity Common Shares Retained Earnings Total Shareholders' Equity Total Liabilities & Equity 93,200 25,730 118,930 $231,130 Required: Using the balances of the General Ledger accounts as of August 31, complete the financial statements. Assets Cash Goulet Inc. Classified Balance Sheet As at July 31, 2023 Accounts Receivable Merchandise Inventory Prepaid Insurance $81,240 $30,090 $27,600 $9,200 148,130 Total Current Assets Long-Term Assets Equipment 175,000 Accumulated Depreciation -92,000 83,000 Total Assets $231,130 Liabilities Current Liabilities Accounts Payable $29,200 Unearned Revenue $17,000 Salaries Payable $9,600 Current Portion of Bank Loan $22,560 Total Current Liabilities $78,360 Non-Current Liabilities Non-Current Portion of Bank Loan Total Liabilities 33,840 $112,200 Shareholders' Equity Common Shares Retained Earnings Total Shareholders' Equity Total Liabilities & Equity 93,200 25,730 118,930 $231,130 Required: Using the balances of the General Ledger accounts as of August 31, complete the financial statements. 1) Prepare a multistep income statement. Goulet Inc. Income Statement For the Month Ended August 31, 2023 2) Prepare a calculation of retained earnings Calculation of Retained Earnings For the Month Ended August 31, 2023 1) Prepare a multistep income statement. Goulet Inc. Income Statement For the Month Ended August 31, 2023 2) Prepare a calculation of retained earnings Calculation of Retained Earnings For the Month Ended August 31, 2023 3) Prepare a classified balance sheet. Assume that $22,560 of the bank loan will be paid off in the 12 months. Goulet Inc. Balance Sheet As at August 31, 2023 3) Prepare a classified balance sheet. Assume that $22,560 of the bank loan will be paid off in the 12 months. Goulet Inc. Balance Sheet As at August 31, 2023 Based on the information above, answer the following questions. a) Calculate the current ratio as at August 31, 2023. b) Does Goulet Inc. have a good or bad current ratio? Explain why or why not. c) Calculate the inventory days on hand ratio as at August 31, 2023. (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 7 days. Has the ratio improved? Why or why not? e) Calculate the debt to equity ratio as at August 31, 2023. f) Calculate the gross profit margin as at August 31, 2023. Based on the information above, answer the following questions. a) Calculate the current ratio as at August 31, 2023. b) Does Goulet Inc. have a good or bad current ratio? Explain why or why not. c) Calculate the inventory days on hand ratio as at August 31, 2023. (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 7 days. Has the ratio improved? Why or why not? e) Calculate the debt to equity ratio as at August 31, 2023. f) Calculate the gross profit margin as at August 31, 2023. g) Last month, the gross profit margin percentage was 63%. What could have caused this decrease in gross margin percentage? h) Calculate the inventory turnover as at August 31, 2023. i) If inventory turnover last month was 4.43 is the company holding on to inventory for a longer or shorter period of time? g) Last month, the gross profit margin percentage was 63%. What could have caused this decrease in gross margin percentage? h) Calculate the inventory turnover as at August 31, 2023. i) If inventory turnover last month was 4.43 is the company holding on to inventory for a longer or shorter period of time?
Expert Answer:
Answer rating: 100% (QA)
a Bank Reconciliation Statement Balance per Books 21672700 Balance per Bank 19986300 Reconciling Ite... View the full answer
Related Book For
Financial Accounting Tools for Business Decision Making
ISBN: 978-1118644942
6th Canadian edition
Authors: Paul D. Kimmel, Jerry J. Weygandt, Donald E. Kieso, Barbara Trenholm, Wayne Irvine
Posted Date:
Students also viewed these accounting questions
-
Discuss any of the established brands of the business concerned with woolworths in Australia
-
Burger King recently merged with Tim Horton's of Canada. Do some research on the issues involved in this merger and discuss the pros and cons from both the U.S. and Canadian perspective. Do you think...
-
Consider a modified version of the vacuum environment in Exercise 2.7, in which the geography of the environmentits extent, boundaries, and obstaclesis unknown, as is the initial dirt configuration....
-
Which of the following is an advantage of a sole proprietorship? a. The owners personal assets are protected. b. The owner can raise greater sources of funds by selling shares of ownership. c. The...
-
On April 1, 2011, Petey Ltd. paid $150 for a call to buy 500 shares of NorthernTel at a strike price of $25 per share any time during the next six months. The market price of NorthernTels shares was...
-
Part 1 of 3 Required information [The following information applies to the questions displayed below] Simon Company's year-end balance sheets follow 2 points ellook Pr References At December 31...
-
Determine the maximum power delivered to the variable resistor R shown in the circuit of Fig. 4.136. 2 Vx 10 (4 20 20 : 10 . www
-
You plan to pursue graduate study and expect to study part-time for 3 years. The annual spending including tuition and other related expenses are estimated to be $80,000 payable at the end of each...
-
Briefly summarise the processes used by the organisation to manage sales, invoicing, purchasing, payments and receipts and give at least one detailed reason for each process to show why it is...
-
How do micro-level interactions intersect with broader macro-level structures, such as institutional arrangements, cultural discourses, and historical contexts, to produce and reproduce patterns of...
-
In what ways do micro-level phenomena, such as everyday rituals, conversational rituals, and nonverbal communication, contribute to the construction and maintenance of social order and cohesion...
-
How do microsociological analyses contribute to our understanding of deviance and social control mechanisms, including the labeling process, social stigma, and informal social sanctions, within...
-
Never On Time airlines' flights have been constantly delayed lately. They received several complaints from their customers. They hired you as a consultant to determine the cause(s) of the problem by...
-
The following information relates to the company Highland Enterprises Ltd for year ended 31 st March 2021: Operating profit is 500,000. The following items are included in expenses: 80,000...
-
If a process has a six-sigma capability, what is the process capability index? a. 1 b. 2 c. 6 d. 12
-
On August 31, 2015, the Rijo Equipment Repair Corp.'s post-closing trial balance was as follows. The company prepares adjusting entries monthly. During September, the following transactions were...
-
Listed below are statements of cash flows for three companies in millions of dollars. Each company went public in 2014 and then commenced operations by acquiring a number of restaurants. Despite the...
-
At the beginning of the year, Point Claire Shipping Ltd., a company that has a perpetual inventory system, had $25,000 of merchandise inventory. During the year, inventory costing $100,000 was...
-
The energy levels of an imperfect Fermi gas in the presence of an external magnetic field \(\boldsymbol{H}\), to the first order in \(a\), may be written as...
-
Solve the Gross-Pitaevskii equation and evaluate the mean field energy, see equations (11.2.21) and (11.2.23), for a uniform Bose gas to show that this method yields precisely equation (11.2.6).
-
Solve the Gross-Pitaevskii equation and evaluate the mean field energy, see equations (11.2.21) and (11.2.23), for an isotropic harmonic oscillator trap with frequency \(\omega_{0}\) for the case \(N...
Study smarter with the SolutionInn App