Basic
| # | Problem | Worksheet | Combined | Description |
|---|---|---|---|---|
| B-3.01 | excel | Terminology | ||
| B-3.02 | excel | Revenue recognition principles | ||
| B-3.03 | excel | Expense recognition principles | ||
| B-3.04 | excel | Prepaid expenses | ||
| B-3.05 | excel | Depreciation | ||
| B-3.06 | excel | Unearned revenue | ||
| B-3.07 | excel | Accrued expenses and accrued revenues | ||
| B-3.08 | excel | Various adjustments from trial balance and other information | ||
| B-3.09 | excel | T-account analysis and adjusting entries | ||
| B-3.10 | excel | Cash to accrual conversion |
Involved
| # | Problem | Worksheet | Combined | Description |
|---|---|---|---|---|
| I-3.01 | excel | Income measurement terms and concepts | ||
| I-3.02 | excel | Team-based approach to learn about income measurement | ||
| I-3.03 | excel | Business papers and adjustments | ||
| I-3.04 | excel | Comprehensive fact set and adjustments | ||
| I-3.05 | excel | Evaluation of adjustment errors and corrections | ||
| I-3.06 | excel | Balance sheet versus income statement approaches to adjustments | ||
| I-3.07 | excel | Cash and accrual-basis |
Self-Grading
| Problem | Description | |
|---|---|---|
| 1 | excel | Self-Grading Problem |
MyExceLab
| Description | Problem | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Key Terms to Note | excel | |||||||||||||||
| Financial Statement Presentation of Prepaids | excel | |||||||||||||||
| Adjustment Calculations and Entries | excel | |||||||||||||||
| Supplies Calculations and Entries | excel | |||||||||||||||
| Adjusting for the Effects of Depreciation | excel | |||||||||||||||
| Learning Reinforcement for Adjusting Entries | excel | |||||||||||||||
| Balance Sheet vs. Income Statement Adjustments | excel | |||||||||||||||
| Conversion Tables for Cash to Accrual | 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 site 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.