Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Aging Schedule (Excel) Mets Company had a $1,000 credit balance in Allowance for Doubtful Accounts at December 31, 2018, before the current year's provision for
Aging Schedule (Excel) Mets Company had a $1,000 credit balance in Allowance for Doubtful Accounts at December 31, 2018, before the current year's provision for uncollectible accounts. An aging of the accounts receivable revealed the following: Estimated Percentage Uncollectible Current Accounts $110,000 2% 1-30 days past due 30,000 5% 31-60 days past due 20,000 8% 61-90 days past due 25,000 15% Over 90 days past due 15,000 40% Total Accounts Receivable $200.000 Instructions: You must show and explain your answers to receive credit and you need to set up an aging schedule using Excel. You earn more extra points by using formulas in your Excel schedule. (a) Determine the amount to recognize as bad debt expense on December 31, 2010. (b) What is the amount that is reported as the net balance for Accounts Receivable as on December 31, 2018? (c) Assume the same facts as above except that the Allowance for Doubtful Accounts account had a $500 debit balance before the current year's provision for uncollectible accounts. What is the amount of bad debt expense to recognize for the year. (d) What is the amount that is reported as the net balance for Accounts Receivable as of December 31, 2018
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started