Estimating Bad Debts - Aging of A/R Method

This assignment will provide you with an opportunity to practice calculating bad debts on accounts receivable using the aging of accounts receivable method. You will also get practice preparing the journal entries necessary to record these bad debts using the same method.

Relevant Excel Functions

This assignment will require you to be able to use some or all of the following Excel functions. Click on the hyperlinked section number next to the relevant Excel skill to be directed to a page showing how to perform the assigned task in Excel:

  • Cell References (1.5)

  • SUM Function (1.14)

  • Basic Calculations (1.3)

  • IF Statement (1.11)

Want to try our built-in assessments?


Use the Request Full Access button to gain access to this assessment.