Excel Inc. has provided the following information relating to its sales for the past year, which endedDecember 31, 20x1.АсcountDebitCreditEstimated % of accounts receivable that will be uncollectable4%Opening Balances:Jan. 1, 20x1 balance in the allowance for doubtful account$2,000 cr|(this is before any adjusting entries)Jan. 1, 20x1 balance in the accounts receivable account$37,000 drDuring 20x1:Credit sales (20x1)$450,000$6,200Write offs of uncollectible accounts receivable (20x1)$900Collections of previously written off amounts (20x1)Cash received in payment of accounts receivable (20x1)$426,000Required –1) Calculate the balance in the Accounts Receivable account at December 31, 20x1.2) Calculate the balance in the Allowance for Doubtful Accounts at December 31, 20x1.3) Prepare any journal entries required at December 31, 20x1 to record bad debt expense for the year.

The allowance for uncollectible accounts is created to record estimated bad debt expense for the…

Excel Inc. has provided the following information relating to its sales for the past year, which ended December 31, 20x1. Account Debit Estimated % of accounts receivable that will be uncollectable 4% Opening Balances: Jan. 1, 20x1 balance in the allowance for doubtful account (this is before any adjusting entries) $2,000 cr Jan. 1, 20x1 balance in the accounts receivable account $37,000 dr During 20x1: Credit sales (20x1) Write offs of uncollectible accounts receivable (20x1) Collections of previously written off amounts (20x1) Cash received in payment of accounts receivable (20x1) $450,000 $6,200 $900 $426,000 Required - 1) Calculate the balance in the Accounts Receivable account at December 31, 20x1. 2) Calculate the balance in the Allowance for Doubtful Accounts at December 31, 20x1. 3) Prepare any journal entries required at December 31, 20x1 to record bad debt expense for the year.

Excel Inc. has provided the following information relating to its sales for the past year, which ended December 31, 20x1. Account Debit Estimated % of accounts receivable that will be uncollectable 4% Opening Balances: Jan. 1, 20x1 balance in the allowance for doubtful account (this is before any adjusting entries) $2,000 cr Jan. 1, 20x1 balance in the accounts receivable account $37,000 dr During 20x1: Credit sales (20x1) Write offs of uncollectible accounts receivable (20x1) Collections of previously written off amounts (20x1) Cash received in payment of accounts receivable (20x1) $450,000 $6,200 $900 $426,000 Required - 1) Calculate the balance in the Accounts Receivable account at December 31, 20x1. 2) Calculate the balance in the Allowance for Doubtful Accounts at December 31, 20x1. 3) Prepare any journal entries required at December 31, 20x1 to record bad debt expense for the year.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Daley Company prepared the following aging of receivables analysis at December 31. Total 0 Accounts receivable Percent uncollectible $ 625,000 $ 407,000 1 to 30 $ 101,000 Days Past Due 31 to 60 $ 47,000 61 to 90 $ 29,000 Over 90 $ 41,000 3% 4% 7% 9% 12% a. Estimate the balance of the Allowance for Doubtful Accounts assuming the company uses 5% of total accounts receivable to estimate uncollectibles, instead of the aging of receivables method. b. Prepare the adjusting entry to record bad debts expense using the estimate from part a. Assume the unadjusted balance in the Allowance for Doubtful Accounts is a $13,100 credit. c. Prepare the adjusting entry to record bad debts expense using the estimate from part a. Assume the unadjusted balance in the Allowance for Doubtful Accounts is a $2,100 debit. Answer is not complete. Complete this question by entering your answers in the tabs below. Req A Req B and C Estimate the balance of the Allowance for Doubtful Accounts assuming the company…
At the end of the prior year, Durney's Outdoor Outfitters reported the following information. Accounts Receivable, December 31, prior year Accounts Receivable (Gross) (A) $ 48,283 Allowance for Doubtful Accounts (XA) 8,474 Accounts Receivable (Net) (A) $ 39,809 During the current year, sales on account were $306,673, collections on account were $290,750, write-offs of bad debts were $7,059, and the bad debt expense adjustment was $4,775. Required: 1-a. Complete the Accounts Receivable and Allowance for Doubtful Accounts T-accounts to determine the balance sheet values. 1-b. Complete the amounts related to Accounts Receivable and Bad Debt Expense that would be reported on the income statement for the current year. 1-c. Complete the amounts related to Accounts Receivable and Bad Debt Expense that would be reported on the balance sheet for the current year.
Sipacore Ltd. has an Accounts Receivable amount of $363,700 and an unadjusted credit balance in Allowance for Expected Credit Losses of $8,600 at March 31. The company's accounts receivable and percentage estimates of uncollectible accounts are as follows: Number of Days Outstanding 0-30 (a) 31-60 61-90 Over 90 Total Your answer is correct. Age of Accounts 0-30 days 31-60 days Accounts Receivable $258,000 45,800 32,600 27,300 $363,700 61-90 days Over 90 days Prepare an aging schedule to determine the total estimated uncollectibles at March 31. Amount % $258,000 2% 45,800 10% 32,600 30% Estimated Percentage Uncollectible 27,300 50% 2% 10% 30% 50% Estimated Uncollectible 5160 4580 9780 13650 33170
Daley Company prepared the following aging of receivables analysis at December 31. Days Past Due 31 to 60 $ 47,000 Accounts receivable Percent uncollectible Req A Complete this question by entering your answers in the tabs below. Req B and C Not due: 1 to 30: 31 to 60: 61 to 90: Over 90: a. Complete the table below to calculate the estimated balance of Allowance for Doubtful Accounts using aging of accounts receivable. b. Prepare the adjusting entry to record bad debts expense using the estimate from part a. Assume the unadjusted balance in the Allowance for Doubtful Accounts is a $4,700 credit. Accounts Receivable c. Prepare the adjusting entry to record bad debts expense using the estimate from part a. Assume the unadjusted balance in the Allowance for Doubtful Accounts is a $1,200 debit. X Total O $625,000 $ 407,000 X X X Complete the table below to calculate the estimated balance of Allowance for Doubtful Accounts using aging of accounts receivable. X Percent Uncollectible (%) = 3%…
Accounts receivable turnover and days’ sales in receivables Financial statement data for years ending December 31 for Schultze-Solutions Company follow: 20Y2 20Y1 Sales $1,848,000 $1,881,000 Accounts receivable: Beginning of year 195,300 184,700 End of year 224,700 195,300 a. Determine the accounts receivable turnover for 20Y2 and 20Y1. If required, round the final answers to one decimal place. AccountsReceivableTurnover 20Y2 fill in the blank 1 20Y1 fill in the blank 2 b. Determine the days’ sales in receivables for 20Y2 and 20Y1. Use 365 days, if required round the final answers to one decimal place. Days’ Salesin Receivables 20Y2 fill in the blank 3 days 20Y1 fill in the blank 4 days c. Does the change in accounts receivable turnover and the days’ sales in receivables from 20Y1 to 20Y2 indicate a favorable or unfavorable change
At December 31, Hawke Company reports the following results for its calendar year. Cash sales $ 280,000 Credit sales $ 700,000 In addition, its unadjusted trial balance includes the following items. Accounts receivable $ 630,000 debit Allowance for doubtful accounts $ 5,000 debit 3. An aging analysis estimates that 4% of year-end accounts receivable are uncollectible. Show how Accounts Receivable and the Allowance for Doubtful Accounts appear on its December 31 balance sheet. Only typing answer Please explain step by step without table and graph
At the end of the current year, the accounts receivable account has a debit balance of $1,117,000 and sales for the year total $12,670,000. a. The allowance account before adjustment has a credit balance of $15,100. Bad debt expense is estimated at 1/2 of 1% of sales. b. The allowance account before adjustment has a credit balance of $15,100. An aging of the accounts in the customer ledger indicates estimated doubtful accounts of $48,300. c. The allowance account before adjustment has a debit balance of $6,400. Bad debt expense is estimated at 1/4 of 1% of sales. d. The allowance account before adjustment has a debit balance of $6,400. An aging of the accounts in the customer ledger indicates estimated doubtful accounts of $53,100. Determine the amount of the adjusting entry to provide for doubtful accounts under each of the assumptions (a through d) listed above. a. b. $ C. $ d. $
Keel Company's December 31 balances from the prior year related to accounts receivable follow. Accounts receivable (Dr.) Allowance for doubtful accounts (Cr.) $500,000 10,000 During the current year, $15,000 of accounts receivable is considered uncollectible, and no more effort to collect these accounts will be made. Total sales for the current year are $2,000,000, of which $400,000 are cash sales. A total of $1,500,000 cash was collected during the current year from sales that were originally made on account. Required a. Assuming that Keel applies the allowance method to estimate net accounts receivable and uses 10% of accounts receivable as its estimate of expected credit losses, prepare the disclosure on gross and net accounts receivable on the balance sheet at December 31 of the current year. • Note: Do not use negative signs in your answers. Balance Sheet, December 31 Accounts receivable Less: Allowance for doubtful accounts Accounts receivable, net 0
A company reports the following: Sales $1,332,250 Average accounts receivable (net) 53,290 Determine (a) the accounts receivable turnover and (b) the number of days' sales in receivables. Round interim calculations to the nearest dollar and final answers to one decimal place. Assume a 365-day year. a. Accounts receivable turnover fill in the blank 1 b. Number of days' sales in receivables fill in the blank 2 days
Daley Company prepared the following aging of receivables analysis at December 31. Days Past Due 31 to 60 $ 48,000 Accounts receivable Percent uncollectible Total $ 630,000 0 $ 408,000 Req A 1% Req B and C 1 to 30 $ 102,000 Complete this question by entering your answers in the tabs below. 2% 5% 61 to 90 $ 30,000 7% a. Estimate the balance of the Allowance for Doubtful Accounts assuming the company uses 6% of total accounts receivable to estimate uncollectibles, instead of the aging of receivables method. b. Prepare the adjusting entry to record bad debts expense using the estimate from part a. Assume the unadjusted balance in the Allowance for Doubtful Accounts is a $13,200 credit. Over 90 $ 42,000 c. Prepare the adjusting entry to record bad debts expense using the estimate from part a. Assume the unadjusted balance in the Allowance for Doubtful Accounts is a $2,200 debit. 10% Estimate the balance of the Allowance for Doubtful Accounts assuming the company uses 6% of total accounts…