Problems – Chapter 7



# Problem Worksheet Combined Description
B-7.01 pdf pdf excel Costs and benefits of selling on credit
B-7.02 pdf pdf excel Credit card transactions
B-7.03 pdf pdf excel The direct write off method
B-7.04 pdf pdf excel Allowance method: Percentage of receivables
B-7.05 pdf pdf excel Allowance method: Aging of accounts
B-7.06 pdf pdf excel Critical thinking about account balances
B-7.07 pdf pdf excel Allowance method: Write-off of accounts
B-7.08 pdf pdf excel Monitoring receivables: Analysis and ratios
B-7.09 pdf pdf excel Notes receivable terminology
B-7.10 pdf pdf excel Notes receivable interest calculations
B-7.11 pdf pdf excel Accounting for notes receivable



# Problem Worksheet Combined Description
I-7.01 pdf pdf excel Direct write-off versus allowance methods
I-7.02 pdf pdf excel Allowances and account analysis
I-7.03 pdf pdf excel Journal entries and analysis of receivables and allowances
I-7.04 pdf pdf excel Aging of accounts receivables
I-7.05 pdf pdf excel Team-based analysis of receivables
I-7.06 pdf pdf excel Comprehensive notes receivable



  Problem Description
1 excel Self-Grading Problem



Description Problem                              
Direct Write-Off Method excel                              
Aging of Accounts Receivable excel                              
Journal Entries for Allowance Method excel                              
Accounts Receivable Ratios excel                              
Adjusting Entries For Notes Receivable excel                              


The preceding table includes links to “Basic” and “Involved” problems. Each excel link will download the file containing a spreadsheet for the problem and a template worksheet on which you can prepare the solution electronically. If you see a light bulb icon on a worksheet, just mouse over above the icon and a comment box will appear. The comments include useful suggestions for improving your spreadsheet skills.

You may not post or redistribute, electronically or otherwise, any solution material. Violation of this policy constitutes a copyright violation.

Alternative problems, with solutions, may be found at our partner website Bookboon. Video solutions to selected problems are available to students enrolling in the online course. The pdf version of the solutions manual also includes links to the video solutions. You can purchase the solutions manual in the bookstore.