Trusted by Students Everywhere
Why Choose Us?
0% AI Guarantee

Human-written only.

24/7 Support

Anytime, anywhere.

Plagiarism Free

100% Original.

Expert Tutors

Masters & PhDs.

100% Confidential

Your privacy matters.

On-Time Delivery

Never miss a deadline.

Prepare, in good form, an aging schedule for December 31st

Finance Apr 19, 2021

Prepare, in good form, an aging schedule for December 31st. 

 

FHB, Inc. uses the aging of accounts receivable method for estimating bad debts. Based on the December 31st accounts receivable records, the amounts for each aging category are as follows:

 

Category 1: Current- not yet due: $ 200,000

Category 2: 1 to 30 days overdue   115,000

Category 3: 31 to 60 days overdue    45,000

Category 4: 61 to 90 days overdue     7,500

Category 5: Over 90 days past due    20,000

$ 387,500

 

Based on past history, the estimated percentages of uncollectible accounts receivable for each category is as follows:

 

Category 1: 1%

Category 2: 5%

Category 3: 10%

Category 4: 20%

Category 5: 50%

Expert Solution

An aging schedule for December 31st:

Aging Analysis Amount % Uncollectible Amount uncollectible
Current - Not Yet Due 200,000 1% 2,000
1 to 30 days overdue 115,000 5% 5,750
31 to 60 days overdue 45,000 10% 4,500
61 to 90 days overdue 7,500 20% 1,500
Over 90 days past due $20,000  50% 10,000
Total  387,500   23,750
Archived Solution
Unlocked Solution

You have full access to this solution. To save a copy with all formatting and attachments, use the button below.

Already a member? Sign In
Important Note: This solution is from our archive and has been purchased by others. Submitting it as-is may trigger plagiarism detection. Use it for reference only.

For ready-to-submit work, please order a fresh solution below.

Or get 100% fresh solution
Get Custom Quote
Secure Payment