Basic
| # | Problem | Worksheet | Combined | Description |
|---|---|---|---|---|
| B-5.01 | excel | Sales, returns and allowances | ||
| B-5.02 | excel | Sales discounts | ||
| B-5.03 | excel | Purchase transactions, business papers, net vs. gross | ||
| B-5.04 | excel | Sales and freight cost | ||
| B-5.05 | excel | Purchases and freight cost | ||
| B-5.06 | excel | Calculating values for a merchandising income statement | ||
| B-5.07 | excel | Preparing a merchandising income statement | ||
| B-5.08 | excel | Closing entries | ||
| B-5.09 | excel | Perpetual inventory | ||
| B-5.10 | excel | Single-step and multiple-step income statements | ||
| B-5.11 | excel | Profit margin analysis | ||
| B-5.12 | excel | Control structure |
Involved
| # | Problem | Worksheet | Combined | Description |
|---|---|---|---|---|
| I-5.01 | excel | Comprehensive merchandising entries | ||
| I-5.02 | excel | Gross vs. net recording of purchases, entries and reporting | ||
| I-5.03 | excel | Merchandising income statement and closing | ||
| I-5.04 | excel | Perpetual inventory vs. periodic inventory | ||
| I-5.05 | excel | Single-step and multiple-step income statements, profit margins | ||
| I-5.06 | excel | Team-based study of controls |
Self-Grading
| Problem | Description | |
|---|---|---|
| 1 | excel | Self-Grading Problem |
MyExceLab
| Description | Problem | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Sales Terminology and Concepts | excel | |||||||||||||||
| Gross v. Net Entries and Impact | excel | |||||||||||||||
| Buyer and Seller Entries | excel | |||||||||||||||
| Calculating Cost of Goods Sold | excel | |||||||||||||||
| Detailed Income Statement | excel | |||||||||||||||
| Closing Accounts with Debits and Credits | excel | |||||||||||||||
| Comparing Periodic and Perpetual Systems | excel | |||||||||||||||
| Analysis of Profit Margins | excel | |||||||||||||||
| Control Strengths and Weaknesses | 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.