Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. aging schedule (excel) mets company had a $1,000 c

Aging Schedule (Excel) Mets Company had a $1,000 credit balance in Allowance for Doubtful Accounts...

50.1K

Verified Solution

Question

Accounting

image
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

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

(1 point) Suppose that f(x)=(12−2x)e^x. (A) List all the critical values of f(x). Note: If there...

Basic Math
Q

Listed below are systolic blood pressure measurements​ (mm Hg) taken from the right and left arms...

Statistics
Q

The net primary productivity is the a total amount of plant b- -Organic matter available as...

Biology
Q

Describe at least one significant way that research methodologies differ in psychology, social sciences (archaeology), and the...

Psychology
Q

Please read the following case study and answer the questions to the best of your ability. Case...

Psychology
Q

Find an experimental study from a journal of your choice. (Provide the citation). Identify the explanatory variable Identify...

Basic Math
Q

Digital dashboards offer an effective and efficient way to view enterprisewide information at near real-time. According...

General Management
Q

Advertising & the First Amendment The question is often asked: Does the First Amendment protect advertisements? Advertising...

General Management
Q

A container of neon gas has the following properties 1 0 5 moles 2 T...

Physics
Q

Divide.(12x + 14x-22x-8) (6x + x)Your answer should give the quotient and the remainder.

Calculus
Q

Sommer Corporation is deciding whether to automate one phase of its production process. The equipment...

Accounting
Q

Phil, an Ontario resident, ordered a customized motorbike on February 1st with delivery on June...

Accounting