Formula sheet
Formula sheet
A | B | C | D | E | F | G | H | I | J | K | L |
2 | |||||||||||
3 | Journal entry for transactions will be as follows: | ||||||||||
4 | Date | Account | Debit | Credit | |||||||
5 | 43345 | Notes Receivables | 48000 | ||||||||
6 | Accounts Receivables | =E5 | |||||||||
7 | |||||||||||
8 | 43349 | Cash | =F9+F10 | ||||||||
9 | Accounts Receivables | 12600 | |||||||||
10 | Interest Income | =F9*4%*(1/12) | |||||||||
11 | |||||||||||
12 | 43352 | Bad Debt Expense | 19200 | ||||||||
13 | Allowance for doubtful accounts | =E12 | |||||||||
14 | |||||||||||
15 | Allowance for doubtful accounts | 19200 | |||||||||
16 | Accounts Receivables | =E15 | |||||||||
17 | |||||||||||
18 | 43354 | Bad Debt Expense | 9120 | ||||||||
19 | Allowance for doubtful accounts | =E18 | |||||||||
20 | |||||||||||
21 | Allowance for doubtful accounts | 9120 | |||||||||
22 | Accounts Receivables | =E21 | |||||||||
23 | |||||||||||
24 | 43361 | Accounts Receivables | 15000 | ||||||||
25 | Allowance for doubtful accounts | =E24 | |||||||||
26 | |||||||||||
27 | Cash | =E24 | |||||||||
28 | Accounts Receivables | =E27 | |||||||||
29 | |||||||||||
30 | 43370 | Cash | =F31+F32 | ||||||||
31 | Notes Receivable | 48000 | |||||||||
32 | Interest Income ($48,000*8%*(25/365)) | =F31*8%*(25/365) | |||||||||
33 | |||||||||||
34 | 43370 | Bad Debt Expense | 5040 | ||||||||
35 | Allowance for doubtful accounts | =E34 | |||||||||
36 | |||||||||||
37 | Allowance for doubtful accounts | 5040 | |||||||||
38 | Accounts Receivables | =E37 | |||||||||
39 | |||||||||||
40 | 43373 | Accounts Receivables | =F42*85% | ||||||||
41 | Cash | =F42-E40 | |||||||||
42 | Sales | 720000 | |||||||||
43 | |||||||||||
44 | Cash | 601200 | |||||||||
45 | Accounts Receivables | =E44 | |||||||||
46 | |||||||||||
47 | 43373 | Bad Debt Expense | 75000 | ||||||||
48 | Allowance for doubtful accounts | =E47 | |||||||||
49 | |||||||||||
50 | |||||||||||
51 | 2) | ||||||||||
52 | |||||||||||
53 | Credit Sales | =E40 | |||||||||
54 | % Uncollectible | 0.08 | |||||||||
55 | |||||||||||
56 | Adjusting Entry will be as follows: | ||||||||||
57 | 43373 | Bad Debt Expense ($612,000*8%) | =D53*D54 | ||||||||
58 | Allowance for doubtful accounts | =E57 | |||||||||
59 | |||||||||||
60 | 3) | ||||||||||
61 | |||||||||||
62 | Estimating the uncollectible accounts based on the aging of accounts receivables is more accurate because, | ||||||||||
63 | higher the aging of the account lesser it the chances of it being collected and hence higher % of the uncollectible amount with higher aging. | ||||||||||
64 | Also, we can specifically identify which account is more likely to default. | ||||||||||
65 | |||||||||||
66 | Whereas in the case of % of credit sales, it doesnot include the fact that which account is more likely to be uncollectible. | ||||||||||
67 | |||||||||||
68 | Thus Estimating the uncollectible accounts based on the aging of accounts receivables is more accurate. | ||||||||||
69 |
Can i get the solution of this sum plz Thanx Problem 9-10A Eastern Supply uses the...
The Generation Employment Agency started business on January 1, 2020. The company produced monthly financial statements and had total sales of $525,000 (of which $400,000 was on account) during the first four months.On April 30, Accounts Receivable had a balance of $236,400 (no accounts have been written off to date), which was made up of the following accounts aged according to the date of the sale: The following accounts receivable transactions took place in May 2020:May12Decided the PG Courier account was...
Refer to the information in Exercise 9.8 to complete the following requirements. Exercise 9-9 a. Estimate the balance of the Allowance for Doubtful Accounts assuming the company uses 4.5% of Percent of receivables total accounts receivable to estimate uncollectibles, instead of the aging of receivables method. method b. Prepare the adjusting entry to record bad debts expense using the estimate from part a. Assume the P3 unadjusted balance in the Allowance for Doubtful Accounts is a $12.000 credit. c. Prepare...
QS 7-9 Aging of receivables method LO P3 Net Zero Products, a wholesaler of sustainable raw materials. Prepared the following aging of receivables analysis. Days Past Due Accounts receivable Percent uncollectible Total $115,200 $80,000 1x 1 to 30 $18,000 3x 31 to 60 $ 7,200 5% 61 to 90 $ 4,000 8 Over 90 $ 6,000 11% 1. Estimate the balance of the Allowance for Doubtful Accounts using the aging of accounts receivable method. 2. Prepare the adjusting entry to...
Required information Problem 9-3A Aging accounts receivable and accounting for bad debts LO P2, P3 [The following information applies to the questions displayed below.] Jarden Company has credit sales of $2,200,000 for year 2017. On December 31, 2017, the company's Allowance for Doubtful Accounts has an unadjusted credit balance of $14,666. Jarden prepares a schedule of its December 31, 2017 accounts receivable by age. On the basis of past experience, it estimates the percent of receivables in each age category...
Can you please provide explanations? Thank you!
Allowance Method of Accounting for Uncollectibles The following transactions and adjusting entries were completed for Mitchell Co. during the current fiscal year. Mitchell Co. had a credit balance of $22,000 in the Allowance for Doubtful Accounts at the beginning of the year (prior to the entries below). January 30 Accepted a 90-day, 10% note for $40,000 on account from Thermo Flask, Inc. March 1 Received 50% of the $10,000 balance owed by Montgomery...
Net Zero Products, a wholesaler of sustainable raw materials. Prepared the following aging of receivables analysis. Days Past Due Total $129,000 $84,000 1 to 30 31 to 60 61 to 90 over 90 $22,000 $9,000 $6,000 $8,000 Accounts receivable Percent uncollectible 1. Estimate the balance of the Allowance for Doubtful Accounts using the aging of accounts receivable method. 2. Prepare the adjusting entry to record bad debts expense assuming the unadjusted balance in the Allowance for Doubtful Accounts is a...
Unit Assesment 7- prepare a receivables aging
This assessment addresses the following course
objective(s):
Record various business transactions in accordance with
generally accepted accounting principles.
In this assignment, we will estimate the amount for the
allowance account by analyzing and aging Accounts Receivable.
Wright Company estimates uncollectible accounts using the allowance method at December 31. It prepared the following aging of receivables analysis. Total Days Past Due 01-30 411,000 105000 29 1.109 000 Accounts receivable Percent uncollectible 31-60 515000 5%...
Required information Problem 9-3A Aging accounts receivable and accounting for bad debts LO P2, P3 (The following information applies to the questions displayed below.) Jarden Company has credit sales of $2,500,000 for year 2017. On December 31, 2017, the company's Allowance for Doubtful Accounts has an unadjusted credit balance of $14,900. Jarden prepares a schedule of its December 31, 2017, accounts receivable by age. On the basis of past experience, it estimates the percent of receivables in each age category...
7 Assignment Exercise 7-7 Aging of receivables method LO P3 Daley Company estimates uncollectible accounts using the allowance method at December 31. It prepared the following aging of receivables analysis. ints Days Past Due Skipped 1 Total $635,000 0 $400,000 to 30 $103,000 31 to 60 61 to 90 $49,000 $31,000 Over 90 $43,000 Book Accounts receivable Percent uncollectible Hint Print references a. Complete the below table to calculate the estimated balance of Allowance for Doubtful Accounts using the aging...
Required information Problem 9-3A Aging accounts receivable and accounting for bad debts LO P2, P3 The following information applies to the questions displayed below.] Jarden Company has credit sales of $2,400,000 for year 2017. On December 31, 2017, the company's Allowance for Doubtful Accounts has an unadjusted credit balance of $14,904. Jarden prepares a schedule of its December 31, 2017, accounts receivable by age. On the basis of past experience, it estimates the percent of receivables in each age category...