The adjusted trial balance of Galimuyod Company as of December 31, 2017 shows the following: DebitCreditAccounts receivableP1,000,000 Allowance for bad debts P40,000 Additional information: · Cash sales of the company represents 10% of gross sales.· 90% of the credit sales customers do not take advantage of the 2/10, n/30 terms.· It is expected that cash discount of P6,000 will be taken on accounts receivable outstanding at December 31, 2018.· Sales returns in 2018 amounted to P400,000. All returns were from charge sales.· During 2018, accounts totaling to P44,000 were written off as uncollectible; bad debt recoveries during the year amounted to P3,000.· The allowance for bad debts is adjusted so that it represents certain percentage of the outstanding accounts receivable at year end. The required percentage at December 31, 2018 is 150% of the rate used on December 31, 2017.Based on the above and the result of your audit, the allowance for doubtful accounts as of December 31, 2018 isSelect one:a.P146,640b.P 20,000c.P120,000d.P180,000
Question
The adjusted trial balance of Galimuyod Company as of December 31, 2017 shows the following: DebitCreditAccounts receivableP1,000,000 Allowance for bad debts P40,000 Additional information: · Cash sales of the company represents 10% of gross sales.· 90% of the credit sales customers do not take advantage of the 2/10, n/30 terms.· It is expected that cash discount of P6,000 will be taken on accounts receivable outstanding at December 31, 2018.· Sales returns in 2018 amounted to P400,000. All returns were from charge sales.· During 2018, accounts totaling to P44,000 were written off as uncollectible; bad debt recoveries during the year amounted to P3,000.· The allowance for bad debts is adjusted so that it represents certain percentage of the outstanding accounts receivable at year end. The required percentage at December 31, 2018 is 150% of the rate used on December 31, 2017.Based on the above and the result of your audit, the allowance for doubtful accounts as of December 31, 2018 isSelect one:a.P146,640b.P 20,000c.P120,000d.P180,000
Solution
To solve this problem, we need to follow these steps:
-
Determine the rate used on December 31, 2017. This can be calculated by dividing the allowance for bad debts by the accounts receivable: P40,000 / P1,000,000 = 0.04 or 4%.
-
Determine the rate to be used on December 31, 2018. According to the problem, this is 150% of the rate used on December 31, 2017: 0.04 * 1.5 = 0.06 or 6%.
-
Determine the accounts receivable outstanding at December 31, 2018. This is the accounts receivable at December 31, 2017, minus the cash discount expected to be taken, plus the sales returns, minus the accounts written off as uncollectible, plus the bad debt recoveries: P1,000,000 - P6,000 + P400,000 - P44,000 + P3,000 = P1,353,000.
-
Finally, calculate the allowance for doubtful accounts as of December 31, 2018. This is the accounts receivable outstanding at December 31, 2018, multiplied by the rate to be used on December 31, 2018: P1,353,000 * 0.06 = P81,180.
Therefore, none of the options (a.P146,640, b.P 20,000, c.P120,000, d.P180,000) provided in the question are correct. The allowance for doubtful accounts as of December 31, 2018 should be P81,180.
Similar Questions
Your audit disclosed that on December 31, 2018, the accounts receivable control account of Alilem Company had a balance of P2,865,000. An analysis of the accounts receivable account showed the following: Accounts known to be worthlessP 37,500Advance payments to creditors on purchase orders150,000Advances to affiliated companies375,000Customers’ accounts reporting credit balances arising from sales return (225,000)Interest receivable on bonds150,000Other trade accounts receivable – unassigned750,000Subscriptions receivable for common stock due in 30 days825,000Trade accounts receivable - assigned (Finance company’s equity in assigned accounts is P150,000) 375,000Trade installment receivable due 1 – 18 months, including unearned finance charges of P30,000 330,000Trade receivables from officers due currently22,500Trade accounts on which post-dated checks are held (no entries were made on receipts of checks) 75,000 P2,865,000 Based on the above and the result of your audit, determine the adjusted balance of the trade accounts receivable as of December 31, 2018.Select one:a.P1,447,500b.P1,485,000c.P1,147,500d.P1,522,500
The following summarized trial balance appeared in the books of MakossaEnterprises.Purchases and SalesDR _120,000CR200,000Debtors and creditors 80,000 50,000Cash 40,000Other assets and other Liabilities 240,000 200,000Suspense Account 30,000Total 480,000 480,000Subsequent investigations revealed the following errors:i) A sales invoice of Sh.20,000 had not been recognized in the books of accountsii) A cash receipt from a debtor of Sh.15,000 had not been adjusted in the debtors accountiii) A cash payment to a creditor of Sh.9,500 had been debited to the creditor’s account asSh.4,900iv) A purchase of a computer of Sh.50,000 for use in office work had been debited tothe purchases accountP.O. Box 90830100 Eldoret – KenyaTelephone: 0728458276Fax: 254-20-891084Email:[email protected]/ACD/EXM/SEPT - DEC 2022/GABA/BCOM Page 2ISO 9001:2015 Certified by the Kenya Bureau of Standards.v) The accountant had failed to bring forward a balance of Sh.19,600 in the wagespayable account in the post-closing trial balance of the previous financial yearRequired:i) Journal entries to correct the identified accounting errors (5 Marks)ii) The suspense account (5 Marks)iii) The corrected trial balance
From the trial balance of Ajith and the adjustments given below, prepare tradin and profit and loss A/c for the year ended 31st March 2022 and the balance shee as on that date. Debit Credit Particulars Opening stock 15,000 Capital 25,000 Furniture and fixtures 30,000 Returns outward 1,000 Purchases 40,000 Bills payable 10,000 Sales returns 2,000 Sales 1,24,000 Carriage inwards 10,000 Provision for doubtful debts 500 Office rent 23,000 Sundry debtors 20,100 Bank balance 19,600 Bad debts 900 Provision for discount on debtors 100 1,60,600 1,60,600 (a) Stock at the end of the year was ₹8,000 (b) Further bad debts amounted to ₹ 100 (c) Create 2% provision for doubtful debts on sundry debtors (d) Create 1% provision for discount on sundry debtors
n the audit of Pasig Company’s cash account, you obtained the following information: The company’s bookkeeper prepared the following bank reconciliation as of November 30, 2018: Bank balance – November 30, 2018 P90,800Undeposited collections 5,000Bank service charges 100Bank collection of customer’s note (8,000)Outstanding checks: NumberAmount 7159P3,000 77675,000 79152,000 (10,000)Book balance – November 30, 2018 P77,900 Additional data are given as follows: a. Company recordings for December:Total collections from customersP165,000Total checks drawn98,000 b. Bank statement totals for December :ChargesP123,800Credits169,000 c. Check no. 7159 dated November 25, 2018, was entered as P3,000 in payment of a voucher for P30,000. Upon examination of the checks returned by the bank, the actual amount of the check was P30,000. d. Check no. 8113 dated December 20, 2018 was issued to replace a mutilated check (no.7767), which was returned by the payee. Both checks were recorded in the amount drawn, P5,000, but no entry was made to cancel check no. 7767. e. The December bank statement included a check drawn by Sipag Company for P1,500. f. Undeposited collections on December 31, 2018 - P8,000. g. The service charge for December was P150 which was charged by the bank to another client. h. The bank collected a note receivable of P7,000 on December 28, 2018, but the collection was not received on time to be recorded by Pasig.i. The outstanding checks on December 31, 2018, were: Check No.AmountCheck No.Amount7767P5,0008910P2,30088561,30089254,100 Based on the above and the result of your audit, determine the adjusted cash balance as of November 30, 2018.Select one:a.P63,800b.P58,800c.P90,800d.P85,800
Bantay Company's unadjusted trial balance at December 31, 2023, included the following accounts: Debit CreditAccounts receivable 1,000,000 Allowance for doubtful accounts 40,000 Sales 15,000,000Sales returns and allowances 700,000 Bantay Company estimates its bad debt expense to be 1 1/2% of net sales. Determine its bad debt expense for 2023.
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.