Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PLEASE ANSWER PROBLEM 2 Problem One: Ignore GST for this problem. On 31 May 2019, Terrell Ltd, a service company, had a cash balance per

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

PLEASE ANSWER PROBLEM 2

Problem One: Ignore GST for this problem. On 31 May 2019, Terrell Ltd, a service company, had a cash balance per general ledger of $6,781.50. The bank statement from Home Town Bank on that date showed a balance of $6,854.60. Terrell Ltd provides its services, then bills its customers, who have the option of paying by bank transfer (Eftros), with a visa card, or by cheque. For all customers, Terrell Ltd records a receivable when a customer is billed. Customers paying by visa cail Terrell Ltd with their credit card data, and Terrell Ltd then journalises the cash receipt; however, there is a short time delay from the time the event is journalised by Terrell Ltd and the time Terrell Ltd's bank credits Terrell Ltd's, account (less a 2% credit card charge). Most suppliers are paid by bank or wire transfer, but a few International suppliers are paid by cheque. A comparison of the bank statement with the Cash general ledger account and supporting data revealed the following facts. 1. The statement showed that the bank balance had been reduced by $60 for miscellaneous charges, including the $20 mentioned in fact #6, and the $10 mentioned in fact #8, below. Terrell Ltd has a "Bank Charges Expense" general ledger account. 2. A customer direct deposit (Eftros transfer) of $836.15 was incorrectly recorded by Terrell Ltd as $886.15. 3. Outstanding checks at 31 May totalled $276.25. 4. Terrell Ltd had not yet informed the bank of customer visa credit card payments in the amount of $1,955.26. The company had correctly journalised this as a cash receipt less the $39.11 the bank will charge. 5. On 18 May, the company issued a cheque for $685 to Malaysia Travel Ltd for payment on account. The cheque, which cleared the bank in May, was incorrectly journalized and posted by Terrell Ltd for $658. 6. The bank statement disclosed that a $3,000 note receivable was collected by the bank for Terrell Ltd on 31 May, along with $80 of Interest. The bank charged a collection fee of $20. As of the end of April, Terrell Ltd had accrued $60 of Interest on the note. Terrell Ltd has both an Interest Receivable and an interest Revenue account in its general ledger. 7. The bank statement disclosed that the bank incorrectly charged Terrell Ltd for a $600 cheque written by Trump Charities. 8. The bank statement showed an NSF charge of $640 for a cheque Issued by Sandy Grifton. The cheque was for $630, but the bank charged Terrell Ltd $10 as a penalty. After calling Ms. Grifton, the company agreed to accept a new cheque from her in the amount of $640. Required: a) Prepare Terrell Ltd's journal entries suggested by the above facts. b) Prepare Terrell Ltd's bank reconciliation at 31 May 2017 as discussed in lecture and tutorial. Problem Two: P8.1 on page 8-32, but note the following additional Information: Assume all figures shown are GST Inclusive except for the $80,000 balance in the Allowance for doubtful accounts account. (Note that the $115,000 of expected bad debts in part c. is also GST Inclusive.) Obviously, incorporate GST Into parts of the problem, using the GST Clearing account, as needed. For part a., round figures to two decimal places. For parts b., C., and d., round figures to the nearest dollar. For d., also calculate the average collection period in days and analyse the liquidity of accounts receivable. Assume the collection period in days for the previous year was 100 and that Catu Medical's credit terms allow customers to pay in three monthly Instalments. Also assume the industry average is 90 days. Use 365 days even though 2020 is a leap year. Question No:1 Journal Entries DATE PARTICULARS DEBIT CREDIT MAY 31 Cash 3060 Misc. Expenses 20 Notes Receivables 3000 Interest Revenue 80 31 Accounts Receivables 680 cash 680 31 Sales Revenue 50 Cash 50 31 Accounts Payable 27 Cash 27 31 Misc. Expense 40 Cash 40 Question No:2 Bank Reconciliation Account TERRELL Ltd's Bank Reconciliation may 31, 2017 6854.60 Cash balance as per bank statement Add Deposit in transit 1866.15 Bank Erroe 600 2466.15 276,25 less Outstanding Checks Adjusted cash 9044.50 balance per bank Cash balance 6781.50 per books Add Collection of note Receivables 3060 9841.50 Less NSF Checks 680 50 Error on deposit Error in ckeck recording Check printing charges 27 40 797 Adjusted cash 9044.50 balance per book Problem One: Ignore GST for this problem. On 31 May 2019, Terrell Ltd, a service company, had a cash balance per general ledger of $6,781.50. The bank statement from Home Town Bank on that date showed a balance of $6,854.60. Terrell Ltd provides its services, then bills its customers, who have the option of paying by bank transfer (Eftros), with a visa card, or by cheque. For all customers, Terrell Ltd records a receivable when a customer is billed. Customers paying by visa cail Terrell Ltd with their credit card data, and Terrell Ltd then journalises the cash receipt; however, there is a short time delay from the time the event is journalised by Terrell Ltd and the time Terrell Ltd's bank credits Terrell Ltd's, account (less a 2% credit card charge). Most suppliers are paid by bank or wire transfer, but a few International suppliers are paid by cheque. A comparison of the bank statement with the Cash general ledger account and supporting data revealed the following facts. 1. The statement showed that the bank balance had been reduced by $60 for miscellaneous charges, including the $20 mentioned in fact #6, and the $10 mentioned in fact #8, below. Terrell Ltd has a "Bank Charges Expense" general ledger account. 2. A customer direct deposit (Eftros transfer) of $836.15 was incorrectly recorded by Terrell Ltd as $886.15. 3. Outstanding checks at 31 May totalled $276.25. 4. Terrell Ltd had not yet informed the bank of customer visa credit card payments in the amount of $1,955.26. The company had correctly journalised this as a cash receipt less the $39.11 the bank will charge. 5. On 18 May, the company issued a cheque for $685 to Malaysia Travel Ltd for payment on account. The cheque, which cleared the bank in May, was incorrectly journalized and posted by Terrell Ltd for $658. 6. The bank statement disclosed that a $3,000 note receivable was collected by the bank for Terrell Ltd on 31 May, along with $80 of Interest. The bank charged a collection fee of $20. As of the end of April, Terrell Ltd had accrued $60 of Interest on the note. Terrell Ltd has both an Interest Receivable and an interest Revenue account in its general ledger. 7. The bank statement disclosed that the bank incorrectly charged Terrell Ltd for a $600 cheque written by Trump Charities. 8. The bank statement showed an NSF charge of $640 for a cheque Issued by Sandy Grifton. The cheque was for $630, but the bank charged Terrell Ltd $10 as a penalty. After calling Ms. Grifton, the company agreed to accept a new cheque from her in the amount of $640. Required: a) Prepare Terrell Ltd's journal entries suggested by the above facts. b) Prepare Terrell Ltd's bank reconciliation at 31 May 2017 as discussed in lecture and tutorial. Problem Two: P8.1 on page 8-32, but note the following additional Information: Assume all figures shown are GST Inclusive except for the $80,000 balance in the Allowance for doubtful accounts account. (Note that the $115,000 of expected bad debts in part c. is also GST Inclusive.) Obviously, incorporate GST Into parts of the problem, using the GST Clearing account, as needed. For part a., round figures to two decimal places. For parts b., C., and d., round figures to the nearest dollar. For d., also calculate the average collection period in days and analyse the liquidity of accounts receivable. Assume the collection period in days for the previous year was 100 and that Catu Medical's credit terms allow customers to pay in three monthly Instalments. Also assume the industry average is 90 days. Use 365 days even though 2020 is a leap year. Question No:1 Journal Entries DATE PARTICULARS DEBIT CREDIT MAY 31 Cash 3060 Misc. Expenses 20 Notes Receivables 3000 Interest Revenue 80 31 Accounts Receivables 680 cash 680 31 Sales Revenue 50 Cash 50 31 Accounts Payable 27 Cash 27 31 Misc. Expense 40 Cash 40 Question No:2 Bank Reconciliation Account TERRELL Ltd's Bank Reconciliation may 31, 2017 6854.60 Cash balance as per bank statement Add Deposit in transit 1866.15 Bank Erroe 600 2466.15 276,25 less Outstanding Checks Adjusted cash 9044.50 balance per bank Cash balance 6781.50 per books Add Collection of note Receivables 3060 9841.50 Less NSF Checks 680 50 Error on deposit Error in ckeck recording Check printing charges 27 40 797 Adjusted cash 9044.50 balance per book

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Internet Fraud Casebook

Authors: Joseph T. Wells

1st Edition

0470643633, 9780470643631

More Books

Students also viewed these Accounting questions