Question

In: Accounting

Revise your worksheet to reflect these updated assumptions then answer the questions that follow. You have...

Revise your worksheet to reflect these updated assumptions then answer the questions that follow.

You have been provided with the following Aging Report to use to adjust the Allowance for Uncollectible Accounts for a company at year end.

Age Group Accounts
Receivable
Estimated
Percent
Uncollectible
Not yet due $ 90,000 5 %
1-30 days past due 40,000 10 %
31-60 days past due 28,000 20 %
61-90 days past due 22,000 40 %
Over 90 days past due 18,000 80 %
$ 198,000


Allowance for Uncollectible Accounts 2,100 Credit


After reviewing the data, you note the 'not yet due' category is overstated by 20%, while the 'Over 90 days' category is understated by 20%, (this error also caused the AR balance on the schedule to not equal the amount of Accounts Receivable on the balance sheet).

Also, you note the balance in the Allowance account is actually a debit, rather than a credit. Being that the normal balance for this account is a credit, the accountant hadn't noticed the issue.

Required:
1. Use your spreadsheet to recalculate the needed adjustment and account balances. What will be the balance in Accounts Receivable and the Allowance for Uncollectible Accounts based on the above information?

Solutions

Expert Solution

Please comment for any explanation,

Thanks,


Related Solutions

Revise your worksheet to reflect these updated assumptions then answer the questions that follow. You have...
Revise your worksheet to reflect these updated assumptions then answer the questions that follow. You have been provided with the following Aging Report to use to adjust the Allowance for Uncollectible Accounts for a company at year end. Age Group Accounts Receivable Estimated Percent Uncollectible Not yet due $ 112,000 5 % 1-30 days past due 51,000 10 % 31-60 days past due 50,000 20 % 61-90 days past due 44,000 40 % Over 90 days past due 29,000 80...
Revise the data in your worksheet to reflect the results for the subsequent period as shown...
Revise the data in your worksheet to reflect the results for the subsequent period as shown below: A B C D E F 1 Chapter 8: Applying Excel 2 3 Data 4 Exhibit 8-8: Standard Cost Card 5 Inputs Standard Quantity Standard Price 6 Direct materials 3.0 pounds $4.00 7 Direct labor 0.50 hours $22.00 per hour 8 Variable manufacturing overhead 0.50 hours $6.00 per hour 9 10 Actual results: 11     Actual output 2,190 units 12     Actual variable manufacturing overhead...
Requirement 2: Revise the data in your worksheet to reflect the results for the subsequent period...
Requirement 2: Revise the data in your worksheet to reflect the results for the subsequent period as shown below: A B C D E 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Chapter 9: Applying Excel Data Revenue $16.50 q Cost of ingredients $6.25 q Wages and salaries $10,400 Utilities $800 + $0.20 q Rent $2,200 Miscellaneous $600 + $0.80 q Actual results: Revenue $29,730 Cost of ingredients...
Revise your calculations based the new information provided below and then answer the questions that follow....
Revise your calculations based the new information provided below and then answer the questions that follow. A company lends $372,000 to an owner and accepts a three year, 7% note in return. The note was issued on June 1st of the current year, and will be due on June 1st of the final year of the note. Required: (a) Prepare the journal entry to be made when the company makes the loan and accepts the note in return. (If no...
Use the scenario below to frame your answer of the questions that follow As you join...
Use the scenario below to frame your answer of the questions that follow As you join some friends for coffee, they are discussing a group of classmates who seem to have problems with their identity development—some seem to have a rather incoherent, disjointed, incomplete sense of who they are; one seems to have made no exploration at all in any areas of his development and just does what his parents tell him, which he says is fine with him; and...
Using the worksheet you completed in Part 1, revise the given year end information with the...
Using the worksheet you completed in Part 1, revise the given year end information with the following values and then answer the questions below: Select year end company accounts and additional information: Account Name Account Balance Account Name Account Balance Supplies $ 18,300 Service revenue $ 149,400 Interest receivable 0 Interest revenue 0 Salaries payable 0 Supplies expense 0 Deferred revenue 12,900 Salaries expense 68,500 1. Supplies remaining at the end of the year. $ 8,300 2. Services remaining to...
Revise your planned strategies based on this evaluation and describe changes you have made in your...
Revise your planned strategies based on this evaluation and describe changes you have made in your plan and proposed outcomes.
Read the scenario below and answer the questions that follow in your role as a member...
Read the scenario below and answer the questions that follow in your role as a member of the senior management team at Oakwood. You are reviewing budgets and actual results for the month of April for the various business activities and today, you are focusing on Golf Cart Rentals. In the recent past, there has been some tension between the management of Golf Cart Rentals and Golf Course Operations, so some information about Golf Course Operations is included below. About...
Reflect on what you have learned in this module by answering these questions: As a Human...
Reflect on what you have learned in this module by answering these questions: As a Human Resource Manager, what can you do to ensure that your organization is considering current trends and meeting the needs of your employees? What techniques will you leverage to ensure that employees are performing appropriate job functions? What can you do as a Human Resource Manager to overcome challenges identified during job analysis?
Reflect on what you have learned in this module by answering these questions: As a Human...
Reflect on what you have learned in this module by answering these questions: As a Human Resource Manager, what can you do to ensure that your organization is considering current trends and meeting the needs of your employees? What techniques will you leverage to ensure that employees are performing appropriate job functions? What can you do as a Human Resource Manager to overcome challenges identified during job analysis?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT