Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can someone help me filling it? I already did on Excel, but I just wanted to check if my answers are correcr before passing them
Can someone help me filling it? I already did on Excel, but I just wanted to check if my answers are correcr before passing them to the paper and submit the task. Thank you!
Lacorte Inc, set up as a privateiy held corporation, operating as a rrady to wtar garments retales, of which 1005 af the Comsman Shares are owned by Ralph Lacorte. You were hired to account for transactiens for the month of April 2022, complete month end processing. prepare the financial statementi and perform a financial: ratio analvais as of the end of that month. They use perpetual inventory system and une the weigted avtrage cout method to determine value for the inventory. its balance sheat as at March 31, 2022, is presertied below. The bank loan has an annual interest rate of 7% and has monthly principal payment of $1,440. Required: a) Prepare the journal entries for the month of April. You will aiso need to update the inventory in the table for each purchase and sale found under the Inventory Valuation tab of this workbook. b) Post the above journal entries to the accounts. c) Complete the bank reconciliation report. d) Record the journal entries from the bank reconcillation and post amounts to general ledger accounts e) Complete the 10 -column worksheet. e) Post the adjusting entries to the accounts f) Journalize and post the adjustments g) Prepare the multistep income statement, calculation of retained earnings, classifled balance sheet found under the financial statements tab of this workbook. h)Answer the analysis questions from 'a' to 'i' found under the financial statements tab of this workbook. Transactions for the amonth of Aprilf: General Ledrer Accounty \begin{tabular}{|c|l|l|l|l|l|l|} \hline Account: & \multicolumn{2}{|l|}{ Accounts Receivable } & & Gt No: & 110 \\ \hline Date & Description & FR & DR & CR & lalance (DR or CR) \\ \hline & Opening Balance & & & & 16,870.00 & DR \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|c|c|c|c|c|} \hline Account: & \multicolumn{3}{l|}{ Prepaid thsurance } & & GL No: & 125 \\ \hline Date: & Description & PR & DR & CR & Balance (DR or CR) \\ \hline & Opening Balance & & & & 5,200.00 & DR \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|l|l|l|l|l|} \hline Account: & \multicolumn{3}{l|}{ Accounts Payable } & & Gt Noc & 200 \\ \hline Date & Description & Pg & DR & CR & Balance (D/ or CR) \\ \hline & Opening Aalance & & & & 12.00000 & cr \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|c|c|c|c|c|} \hline Account: & \multicolumn{3}{l|}{ Interent Payable } & & GL Nos & 20S \\ \hline Date & Description & FR & OR & CR. & Balance (Dit or CR) \\ \hline & Opening Balance & & & & 0.00 & CR \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|l|l|l|l|l|} \hline Account: & El Payable & \multicolumn{2}{|l|}{} & GL Nos & 225 \\ \hline Date & Description & PR & DR & CR & Balance (DR or CR) \\ \hline & Opening Balance & & & & 0.00 & CR \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|l|l|l|l|l|l|} \hline Account: & \multicolumn{3}{l|}{ Income Tax Payable } & GL No: & 230 \\ \hline Date & Description & PR & DR & CR & Balance (DR or CR) \\ \hline & Opening Balance & & & & 0.00 & CR \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|l|l|l|l|l|} \hline \multicolumn{1}{|c|}{ Account: } & \multicolumn{2}{l|}{ Salaries Payable } & Gl Nos & 235 \\ \hline Date & Description & PR & DA & CR & Balance (DR or CA) \\ \hline & Opening Balance & & & 6,100.00 & CA \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|l|l|l|l|l|} \hline Account: & \multicolumn{3}{|l|}{ Unearned Revenue } & & GL No: & 240 \\ \hline Date & Description & PR & DR & CR & Balance (DR or Cr) \\ \hline & Opening Balance & & & & 12,500.00 & CR \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|c|c|c|c|c|} \hline Account; & \multicolumn{3}{|l|}{ Bank Loan } & & GL No: & 245 \\ \hline Date & Description & PR & DR & CR & Balance (DR or CR) \\ \hline & Opening Balance & & & & 43,200,00 & CR \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|l|l|l|l|l|l|} \hline Account: & \multicolumn{2}{l|}{ Common Shares } & & GL No: & 300 \\ \hline Date & Description & PR & DR & CR & \multicolumn{2}{|c|}{ Balance (DR or CR) } \\ \hline & Opening Balance & & & & 76,000.00 & CR \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|c|c|c|c|c|} \hline \multicolumn{2}{|c|}{ Account: } & \multicolumn{2}{l|}{ Retained Earnings } & GL No: & 305 \\ \hline Date & Description & PR & DR & CR & \multicolumn{3}{|c|}{ Balance (DR or CR) } \\ \hline & Opening Balance & & & & 59,610.00 & CR \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|c|c|c|c|c|c|} \hline \multicolumn{2}{|l|}{ Account: } \\ \hline \multicolumn{3}{l|}{ Sales Revenue } & & GL No: & \multicolumn{4}{|c|}{400} \\ \hline Date & Description & PR & DR & CR & \multicolumn{2}{|c|}{ Balance (DR or CR) } \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|c|c|c|c|c|} \hline \multicolumn{1}{|c|}{ Account: } & \multicolumn{3}{l|}{ Sales Discounts } & GL No: & 405 \\ \hline Date & Description & PR & DR & CR & \multicolumn{2}{|c|}{ Balance (DR or CR) } \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|l|l|l|l|c|} \hline Account: & Interest Revenue & & Gt Nid: & 430 \\ \hline Date & Description & PR & DR & CH & \multicolumn{3}{|c|}{ Aalance (OA or CM) } \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|c|c|c|c|c|} \hline Ascount: & \multicolumn{3}{l|}{ Cost of Goods Sold } & Gt Nos & so0 \\ \hline Date & Description & PR & DR & CR & salance (DR er CR) \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|c|c|c|c|c|} \hline Account: & \multicolumn{2}{|c|}{ Employee Benefits Expense } & GL Nes & 510 \\ \hline Date & Description & PR & DR & CR & \multicolumn{2}{|l|}{ Balance (Dar or CR) } \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|c|c|c|c|c|} \hline Account: & \multicolumn{2}{l|}{ Depreciation Expense } & GL. NoC & S1S \\ \hline Date & Description & PR & DR & CR & Batance (DR or CR) \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|c|c|c|c|c|c|} \hline Account: & \multicolumn{3}{l|}{ Insurance Expense } & GL No: & S20 \\ \hline Date & Description & PR & DR & CR & Balance (DR or CR) \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|l|l|l|l|l|l|} \hline \multicolumn{2}{|c|}{ Account: } & Interest Expense & & GL No: & 525 \\ \hline Date & Description & PR & DR & CR & Falance (DR or CR) \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|c|c|c|c|c|} \hline Account: & \multicolumn{3}{l|}{ Office Supplies Expense } & GL Noc & 530 \\ \hline Date & Description & PR & DR & CR & Balance (DR or CR) \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|l|l|l|l|l|l|} \hline Account: & \multicolumn{2}{|l|}{ Rent Expense } & & GL No: & 535 \\ \hline Date & Description & PR & DR & CR & \multicolumn{2}{|c|}{ Balance (DR or CR) } \\ \hline & & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|l|l|l|l|l|} \hline Account: & \multicolumn{3}{l|}{ Salaries Expense } & & GL No: & 540 \\ \hline Date & Description & PR & DR & CR & \multicolumn{2}{|l|}{ Balance (DR or CR) } \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|l|l|l|l|l|l|} \hline Account: & \multicolumn{3}{l|}{ Bank Charges Expense } & GL No: & 545 \\ \hline Date & Description & PR & DR & CR & \multicolumn{2}{|l|}{ Balance (DR or CR) } \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|l|l|l|l|l|} \hline Account: & \multicolumn{3}{|l|}{ Entertainment Expense } & GL No: & 555 \\ \hline Date & Description & PR & DR & CR & \multicolumn{2}{|l|}{ Balance (DR or CR) } \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|l|l|l|l|c|} \hline Account: & \multicolumn{3}{l|}{ Shipping Expense } & GL No: & \multicolumn{1}{|l|}{560} \\ \hline Date & Description & PR & DR & CR & \multicolumn{2}{|l|}{ Balance (DR or CR) } \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|l|l|l|l|c|} \hline Account: & \multicolumn{3}{l|}{ Cash Over and Short } & GL No: & 565 \\ \hline Date & Description & PR & DR & CR & \multicolumn{2}{|c|}{ Balance (DR or CR) } \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} 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 720 units purchased at $42.00 each. Your accountant goes throush the moll aref opens be besk statentent for the nonth of Aari prowded by Bank of Commerce. it is shown beiow. Additional Information: a) The $27,400 is already recorded in the ledger last month. b) Cheque number of the company has (4) digitr. Reguired: Prepare the April bank reconcil ation for Lacorte inc: oting the bank statement and general ledger provided. Compare the informetion in the general ledger to the bank statement. Once reconciled, record the relevant journal entries in the general journal and post the tentries in the general ledger to bring the company's record up to date. Lacorte Inc. Bank Reconciliation Statement April 30, 2022 \begin{tabular}{|l|l|l|} \hline Explanation & Balance per books & Balance per Bank \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline \end{tabular} Required: Using the balances of the General Ledger accounts as of April 30, complete the financial statements. 1) Prepare a thultistep income statement. 2) Prepare a calculation of retained earnings 3) Prepare a classified balance sheet. Assume that $17,280 of tha han Lac will be paid off in the next 12 months. b) Does Lacorte inci have a good or bad curfent ratio? Explain wty of whin not. c) Calculate the inventory days on hand ratio as at April 30,2022 . (5ince this is for the month, do not multiply by 365 in the formula. Instead multiply by 31 days.) rras tree rasu improved? Why or why not? e) Calculate the debt to equity ratio as at April 30,2022 , f) Calculate the gross profit margin as at Apri 30. 2022. What could have cause the decrease in the gross profit marein? h) Calculate the inventory tumover as at April 30, 2022 . Is the company holding inventory longer or for a shorter period of time? Lacorte Inc, set up as a privateiy held corporation, operating as a rrady to wtar garments retales, of which 1005 af the Comsman Shares are owned by Ralph Lacorte. You were hired to account for transactiens for the month of April 2022, complete month end processing. prepare the financial statementi and perform a financial: ratio analvais as of the end of that month. They use perpetual inventory system and une the weigted avtrage cout method to determine value for the inventory. its balance sheat as at March 31, 2022, is presertied below. The bank loan has an annual interest rate of 7% and has monthly principal payment of $1,440. Required: a) Prepare the journal entries for the month of April. You will aiso need to update the inventory in the table for each purchase and sale found under the Inventory Valuation tab of this workbook. b) Post the above journal entries to the accounts. c) Complete the bank reconciliation report. d) Record the journal entries from the bank reconcillation and post amounts to general ledger accounts e) Complete the 10 -column worksheet. e) Post the adjusting entries to the accounts f) Journalize and post the adjustments g) Prepare the multistep income statement, calculation of retained earnings, classifled balance sheet found under the financial statements tab of this workbook. h)Answer the analysis questions from 'a' to 'i' found under the financial statements tab of this workbook. Transactions for the amonth of Aprilf: General Ledrer Accounty \begin{tabular}{|c|l|l|l|l|l|l|} \hline Account: & \multicolumn{2}{|l|}{ Accounts Receivable } & & Gt No: & 110 \\ \hline Date & Description & FR & DR & CR & lalance (DR or CR) \\ \hline & Opening Balance & & & & 16,870.00 & DR \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|c|c|c|c|c|} \hline Account: & \multicolumn{3}{l|}{ Prepaid thsurance } & & GL No: & 125 \\ \hline Date: & Description & PR & DR & CR & Balance (DR or CR) \\ \hline & Opening Balance & & & & 5,200.00 & DR \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|l|l|l|l|l|} \hline Account: & \multicolumn{3}{l|}{ Accounts Payable } & & Gt Noc & 200 \\ \hline Date & Description & Pg & DR & CR & Balance (D/ or CR) \\ \hline & Opening Aalance & & & & 12.00000 & cr \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|c|c|c|c|c|} \hline Account: & \multicolumn{3}{l|}{ Interent Payable } & & GL Nos & 20S \\ \hline Date & Description & FR & OR & CR. & Balance (Dit or CR) \\ \hline & Opening Balance & & & & 0.00 & CR \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|l|l|l|l|l|} \hline Account: & El Payable & \multicolumn{2}{|l|}{} & GL Nos & 225 \\ \hline Date & Description & PR & DR & CR & Balance (DR or CR) \\ \hline & Opening Balance & & & & 0.00 & CR \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|l|l|l|l|l|l|} \hline Account: & \multicolumn{3}{l|}{ Income Tax Payable } & GL No: & 230 \\ \hline Date & Description & PR & DR & CR & Balance (DR or CR) \\ \hline & Opening Balance & & & & 0.00 & CR \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|l|l|l|l|l|} \hline \multicolumn{1}{|c|}{ Account: } & \multicolumn{2}{l|}{ Salaries Payable } & Gl Nos & 235 \\ \hline Date & Description & PR & DA & CR & Balance (DR or CA) \\ \hline & Opening Balance & & & 6,100.00 & CA \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|l|l|l|l|l|} \hline Account: & \multicolumn{3}{|l|}{ Unearned Revenue } & & GL No: & 240 \\ \hline Date & Description & PR & DR & CR & Balance (DR or Cr) \\ \hline & Opening Balance & & & & 12,500.00 & CR \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|c|c|c|c|c|} \hline Account; & \multicolumn{3}{|l|}{ Bank Loan } & & GL No: & 245 \\ \hline Date & Description & PR & DR & CR & Balance (DR or CR) \\ \hline & Opening Balance & & & & 43,200,00 & CR \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|l|l|l|l|l|l|} \hline Account: & \multicolumn{2}{l|}{ Common Shares } & & GL No: & 300 \\ \hline Date & Description & PR & DR & CR & \multicolumn{2}{|c|}{ Balance (DR or CR) } \\ \hline & Opening Balance & & & & 76,000.00 & CR \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|c|c|c|c|c|} \hline \multicolumn{2}{|c|}{ Account: } & \multicolumn{2}{l|}{ Retained Earnings } & GL No: & 305 \\ \hline Date & Description & PR & DR & CR & \multicolumn{3}{|c|}{ Balance (DR or CR) } \\ \hline & Opening Balance & & & & 59,610.00 & CR \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|c|c|c|c|c|c|} \hline \multicolumn{2}{|l|}{ Account: } \\ \hline \multicolumn{3}{l|}{ Sales Revenue } & & GL No: & \multicolumn{4}{|c|}{400} \\ \hline Date & Description & PR & DR & CR & \multicolumn{2}{|c|}{ Balance (DR or CR) } \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|c|c|c|c|c|} \hline \multicolumn{1}{|c|}{ Account: } & \multicolumn{3}{l|}{ Sales Discounts } & GL No: & 405 \\ \hline Date & Description & PR & DR & CR & \multicolumn{2}{|c|}{ Balance (DR or CR) } \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|l|l|l|l|c|} \hline Account: & Interest Revenue & & Gt Nid: & 430 \\ \hline Date & Description & PR & DR & CH & \multicolumn{3}{|c|}{ Aalance (OA or CM) } \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|c|c|c|c|c|} \hline Ascount: & \multicolumn{3}{l|}{ Cost of Goods Sold } & Gt Nos & so0 \\ \hline Date & Description & PR & DR & CR & salance (DR er CR) \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|c|c|c|c|c|} \hline Account: & \multicolumn{2}{|c|}{ Employee Benefits Expense } & GL Nes & 510 \\ \hline Date & Description & PR & DR & CR & \multicolumn{2}{|l|}{ Balance (Dar or CR) } \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|c|c|c|c|c|} \hline Account: & \multicolumn{2}{l|}{ Depreciation Expense } & GL. NoC & S1S \\ \hline Date & Description & PR & DR & CR & Batance (DR or CR) \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|c|c|c|c|c|c|} \hline Account: & \multicolumn{3}{l|}{ Insurance Expense } & GL No: & S20 \\ \hline Date & Description & PR & DR & CR & Balance (DR or CR) \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|l|l|l|l|l|l|} \hline \multicolumn{2}{|c|}{ Account: } & Interest Expense & & GL No: & 525 \\ \hline Date & Description & PR & DR & CR & Falance (DR or CR) \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|c|c|c|c|c|} \hline Account: & \multicolumn{3}{l|}{ Office Supplies Expense } & GL Noc & 530 \\ \hline Date & Description & PR & DR & CR & Balance (DR or CR) \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|l|l|l|l|l|l|} \hline Account: & \multicolumn{2}{|l|}{ Rent Expense } & & GL No: & 535 \\ \hline Date & Description & PR & DR & CR & \multicolumn{2}{|c|}{ Balance (DR or CR) } \\ \hline & & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|l|l|l|l|l|} \hline Account: & \multicolumn{3}{l|}{ Salaries Expense } & & GL No: & 540 \\ \hline Date & Description & PR & DR & CR & \multicolumn{2}{|l|}{ Balance (DR or CR) } \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|l|l|l|l|l|l|} \hline Account: & \multicolumn{3}{l|}{ Bank Charges Expense } & GL No: & 545 \\ \hline Date & Description & PR & DR & CR & \multicolumn{2}{|l|}{ Balance (DR or CR) } \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|l|l|l|l|l|} \hline Account: & \multicolumn{3}{|l|}{ Entertainment Expense } & GL No: & 555 \\ \hline Date & Description & PR & DR & CR & \multicolumn{2}{|l|}{ Balance (DR or CR) } \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|l|l|l|l|c|} \hline Account: & \multicolumn{3}{l|}{ Shipping Expense } & GL No: & \multicolumn{1}{|l|}{560} \\ \hline Date & Description & PR & DR & CR & \multicolumn{2}{|l|}{ Balance (DR or CR) } \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|l|l|l|l|c|} \hline Account: & \multicolumn{3}{l|}{ Cash Over and Short } & GL No: & 565 \\ \hline Date & Description & PR & DR & CR & \multicolumn{2}{|c|}{ Balance (DR or CR) } \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} 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 720 units purchased at $42.00 each. Your accountant goes throush the moll aref opens be besk statentent for the nonth of Aari prowded by Bank of Commerce. it is shown beiow. Additional Information: a) The $27,400 is already recorded in the ledger last month. b) Cheque number of the company has (4) digitr. Reguired: Prepare the April bank reconcil ation for Lacorte inc: oting the bank statement and general ledger provided. Compare the informetion in the general ledger to the bank statement. Once reconciled, record the relevant journal entries in the general journal and post the tentries in the general ledger to bring the company's record up to date. Lacorte Inc. Bank Reconciliation Statement April 30, 2022 \begin{tabular}{|l|l|l|} \hline Explanation & Balance per books & Balance per Bank \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline \end{tabular} Required: Using the balances of the General Ledger accounts as of April 30, complete the financial statements. 1) Prepare a thultistep income statement. 2) Prepare a calculation of retained earnings 3) Prepare a classified balance sheet. Assume that $17,280 of tha han Lac will be paid off in the next 12 months. b) Does Lacorte inci have a good or bad curfent ratio? Explain wty of whin not. c) Calculate the inventory days on hand ratio as at April 30,2022 . (5ince this is for the month, do not multiply by 365 in the formula. Instead multiply by 31 days.) rras tree rasu improved? Why or why not? e) Calculate the debt to equity ratio as at April 30,2022 , f) Calculate the gross profit margin as at Apri 30. 2022. What could have cause the decrease in the gross profit marein? h) Calculate the inventory tumover as at April 30, 2022 . Is the company holding inventory longer or for a shorter period of time Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started