Estimating Bad Debts - Percent of Sales Method

This assignment will provide you with an opportunity to practice calculating bad debts on accounts receivable using the percent of sales 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.