30-60 Days60-120 days120-180 days180-240 days240-300 days300-365 daysOver 365 daysRequirements:5%10%150%25%40%70%100a. With the aid of a spread sheet use the above information to create a debtor's agingschedule with the additional columns if necessary.b. Draft a sample of an appropriate letter which the accountant could sent to KarenWhite to make payment on his accountsShow the entries for the total amount of provisions for bad debt to be created.C. QuestionCarlene Johnson is the Accountant in the Finance Department at Fairway Trading Limited whomanages the company Accounts Receivables. She was given the following information by theFinance Manager which was extracted from the debtor's ledger as at December 31, 2022.Category of Total value ofCustomersSalesTo Customer$KeithGreenKaren WhiteJune HindsJohn Wayne180,0000240,000390,000380,000Paul Gayle 346,000Date of SalesDecember 16, 30 days2021December 10, 60 days2021November15, 202230 daysJune 26, 202230 days30 daysAugust 25,2022TermsPercentage provision tobe createdDate of LastPayment onA/CJanuary 15,2022February14, 2022December 20,2022October 24,2022September24, 2022TotalAmountPaid to Dateon AccountS90,500180,000170,000295,000235,000The Accountant decided that she would age the debt outstanding in the following category andthe percentage to be provided for bad debt in the amount stated beside each categoryaccordingly.Aging CategoryHEART Collegs ofQUET INSTIT

Accounts receivable arise out of the ordinary sale of goods to the customers and the hence regarded…

Answered: Carlene Johnson is the Accountant in…

Financial Accounting

15th Edition

ISBN:9781337272124

Author:Carl Warren, James M. Reeve, Jonathan Duchac

Publisher:Carl Warren, James M. Reeve, Jonathan Duchac

Chapter4: Completing The Accounting Cycle

Section: Chapter Questions

Problem 5CP

See similar textbooks

Similar questions

How effective is the organization in collecting its receivables? Use the Hillside, Inc. Balance Sheet information in cells A2 through D18 and cells A21 through B38 to complete the Financial Performance Calculations in cells A40 through C60. Table 1: Hillside, Inc. Balance Sheet ($ in Millions) ASSETS LIABILITIES Cash & Marketable Securities 449.90 Accounts Payable 1,611.20 Accounts Receivable 954.80 Salaries Payable 225.20 Inventories 3,645.20 Other Current Liabilities 1,118.80 Other Current Assets 116.60 Total Current Liabilities 2,955.20 Total Current Assets 5,165.27 Other Liabilities 693.40 Machinery & Equipment 1,688.90 Land 1,129.70 Total Liabilities 3,648.60 Buildings 2,348.40 Depreciation (575.60) SHAREHOLDER'S…
The data below are from the records of DUSK, INC. on December 31, 2019. The amount to be shown as total current liabilities on Dusk's statement of financial position at December 31, 2019, is Accounts payable Cash balance DEF Bank Cash overdraft with ABS Bank Customers accounts with credit balances Didends in arrears on preference shares P680.000 1.240.000 80 000 25.000 400.000 Employees income tax payable Estimated warranty payable 100.000 50 000 Estimated premium claims outstanding Income tax payable Notes payable (issued in 2019 maturing in 20 semi-annual installments beginning on April 1. 2020) Salaries payable 90.000 400.000 4,000,000 400,000 Your answer
Cullumber, Inc. reported the following item in its balance sheet at December 31, 2022: Accounts receivable, net of $986 allowance $59678 Which statement is true? Cullumber’s customers owe $60664. During the year, customers charged $59678 on account. Cullumber expects its customers to pay $58692. The balance owed by customers is $59678.
The chief accountant for Bramble Corporation provides you with the following list of accounts receivable written off in the current year. Date March 31 June 30 September 30 December 31 Customer E. L. Masters Company Stephen Crane Associates Amy Lowell's Dress Shop R. Frost, Inc. Amount $7,500 6,600 6.900 Net income would be $ 9,100 Bramble follows the policy of debiting Bad Debt Expense as accounts are written off. The chief accountant maintains that this procedure is appropriate for financial statement purposes because the Internal Revenue Service will not accept other methods for recognizing bad debts. All of Bramble's sales are on a 30-day credit basis. Sales for the current year total $2,200,000. The balance in Accounts Receivable at year-end is $81,100 and an analysis of customer risk and charge-off experience indicates that 12% of receivables will be uncollectible (assume a zero balance in the allowance). (b) By what amount would income before taxes differ if bad debt expense was…
Kings Company has the following data relating to accounts receivable for the year ended December 31, 2023: Accounts Receivable, January 1 P 325,000Allowance for Bad Debts, January 1 18,400Sales during the year, all on account, terms: 5/10, 3/15, n/30 2,800,000Cash received from customers during the year 2,260,000Accounts written off during the year 17,500Sales returns and allowances 14,280 An analysis of cash received from customers during the year revealed that P1,140,000 was received from customers availing the 10-day discount period, P873,000 was received from customers availing the 15-day discount period, P12,000 represented recovery of accounts written off, and the balance…
Kings Company has the following data relating to accounts receivable for the year ended December 31, 2023: Accounts Receivable, January 1 P 325,000Allowance for Bad Debts, January 1 18,400Sales during the year, all on account, terms: 5/10, 3/15, n/30 2,800,000Cash received from customers during the year 2,260,000Accounts written off during the year 17,500Sales returns and allowances 14,280 An analysis of cash received from customers during the year revealed that P1,140,000 was received from customers availing the 10-day discount period, P873,000 was received from customers availing the 15-day discount period, P12,000 represented recovery of accounts written off, and the balance…
You were able to obtain the following from the accountant for Agdangan Corp. related to the company’s liabilities as of December 31, 2007.Accounts payable P650,000 Notes payable – trade 190,000 Notes payable – bank 800,000 Wages and salaries payable 15,000 Interest payable ? Mortgage notes payable – 10% 60,000 Mortgage notes payable – 12% 1,500,000 Bonds payable 2,000,000 The following additional information pertains to these liabilities. All trade notes payable are due within six months of the balance sheet date.Bank notes-payable include two separate notes payable to Allied Bank. a. A P300,000, 8% note issued March 1, 2005, payable on demand. Interest is payable every six months. b. A 1-year, P500,000, 11 ½% note issued January 2, 2007. On December 30, 2007, Agdangan negotiated a written agreement with Allied Bank to replace the note with a 2-year, P500,000 10% note to be issued January 2,2008. The interest was paid on December 31, 2007. The 10% mortgage note was issued October 1,…
Sport Enterprises have individual accounts for their debtors in a debtors subsidiary ledger and have a debtors control account in the general ledger. The balance of the debtors control account at 1 May 2021 is R169 200. The following information was provided for the month ending 31 May 2021: NB: Insert the amount of R4 500 for the credit note in additional amount 3.4 1. Journals provided the following totals for relevant transactions: For the month ended 31 May 2021: Sales journal: Dehtors column 762 000 Sales returns journal 6 300 Cash receipts journal: Debtors column 586 800 2 100 General Journal: Interest charged on overdue debtors' accounts General Journal: Debtors balances written off as irrecoverable 2 700 2. The debtors ledger clerk submitted the following: List of debtors balances as at 31 May 2021 – debit balances C Gale 31 500 Н Bot 132 300 G Hunt 182 700 I Khune 18 900 R Nadal 9 000 3. Additional information to be taken.into.account (not included in the above): 3.1 No entry…
The following accounting records show information regarding the debtors of funky tunes; Cash receipt Journal for the month ended 31 January 2020. Date (January) Receipts Details Total VAT Debtors Cash sales Other 5 712 H Stoop 1 035 135 900 8 714 - 718 Cash 27 600 3 600 24 000 12 457 M Lubbe 1 150 1 150 21 923 B Zaba 575 515 27 418 S Nintendo 2 300 2 300 31 Interest received 150 150 Total 32 810 3 735 4 865 24 000 150 Sales Journal for the month ended 31 January 2020. Date (January) Invoice Details Total VAT Sales 5 582 S Nintendo 966 126 840 6 583 M Lubbe 456 56 400 12 586 B Fouche 920 120 800 14 587 B Riley 1 000 1 000 22 590 S Nintendo 345 45 345 Total 3 687 347 3 385 The accountant prepared the following debtor's control account in the general ledger: Debtors Control A/C Date Details Amount Date Details Amount 1 Jan 2020 Balance 14 800 31 Jan 2020 Sales (SJ) 3 340 31 Jan 2020 Bank (CRJ)…
The following selected accounts and their current balances appear in the ledger of Clairemont Co. for the fiscal year ended May 31, 2019: Instructions 1. Prepare a multiple-step income statement. 2. Prepare a statement of owners equity. 3. Prepare a balance sheet, assuming that the current portion of the note payable is 50,000. 4. Briefly explain how multiple-step and single-step income statements differ.
Aron Larson is a customer of Bank Enterprises. Mr. Larson took out a loan in the amount of $120,000 on August 1. On December 31, Bank Enterprises determines the loan to be uncollectible. Larson had not paid anything toward the balance due on account. What is the journal entry recording the bad debt write-off?
Questions: The following is a summary of Jane’s bank account for the year ended 31 December 2021: $ $ Balance 1.January .2002 4,100 Payments to creditors for goods 67,360 Receipts from debtors 91,190 Rent 3,950 Balance 31Dec.2002 6,300 Insurance 1,470 Sundry expenses 610 Drawings 28,200 101,590 101,590 All of the…

SEE MORE QUESTIONS

Recommended textbooks for you

Financial Accounting

Accounting

ISBN:

9781337272124

Author:

Carl Warren, James M. Reeve, Jonathan Duchac

Publisher:

Cengage Learning

Principles of Accounting Volume 1

Accounting

ISBN:

9781947172685

Author:

OpenStax

Publisher:

OpenStax College

Century 21 Accounting Multicolumn Journal

Accounting

ISBN:

9781337679503

Author:

Gilbertson

Publisher:

Cengage

Financial Accounting

Accounting

ISBN:

9781337272124

Author:

Carl Warren, James M. Reeve, Jonathan Duchac

Publisher:

Cengage Learning

Principles of Accounting Volume 1

Accounting

ISBN:

9781947172685

Author:

OpenStax

Publisher:

OpenStax College

Century 21 Accounting Multicolumn Journal

Accounting

ISBN:

9781337679503

Author:

Gilbertson

Publisher:

Cengage

SEE MORE TEXTBOOKS