Basic
| # | Problem | Worksheet | Combined | Description |
|---|---|---|---|---|
| B-7.01 | excel | Costs and benefits of selling on credit | ||
| B-7.02 | excel | Credit card transactions | ||
| B-7.03 | excel | The direct write off method | ||
| B-7.04 | excel | Allowance method: Percentage of receivables | ||
| B-7.05 | excel | Allowance method: Aging of accounts | ||
| B-7.06 | excel | Critical thinking about account balances | ||
| B-7.07 | excel | Allowance method: Write-off of accounts | ||
| B-7.08 | excel | Monitoring receivables: Analysis and ratios | ||
| B-7.09 | excel | Notes receivable terminology | ||
| B-7.10 | excel | Notes receivable interest calculations | ||
| B-7.11 | excel | Accounting for notes receivable |
Involved
| # | Problem | Worksheet | Combined | Description |
|---|---|---|---|---|
| I-7.01 | excel | Direct write-off versus allowance methods | ||
| I-7.02 | excel | Allowances and account analysis | ||
| I-7.03 | excel | Journal entries and analysis of receivables and allowances | ||
| I-7.04 | excel | Aging of accounts receivables | ||
| I-7.05 | excel | Team-based analysis of receivables | ||
| I-7.06 | excel | Comprehensive notes receivable |
Self-Grading
| Problem | Description | |
|---|---|---|
| 1 | excel | Self-Grading Problem |
MyExceLab
| 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.