Basic
| # | Problem | Worksheet | Combined | Description |
|---|---|---|---|---|
| B-4.01 | excel | Preparation of an adjusted trial balance | ||
| B-4.02 | excel | Preparing financial statements from an adjusted trial balance | ||
| B-4.03 | excel | Basic understanding of the worksheet | ||
| B-4.04 | excel | Temporary vs. real accounts | ||
| B-4.05 | excel | The closing process | ||
| B-4.06 | excel | The accounting cycle | ||
| B-4.07 | excel | Reversing entries | ||
| B-4.08 | excel | Classified balance sheet | ||
| B-4.09 | excel | Current and quick ratios |
Involved
| # | Problem | Worksheet | Combined | Description |
|---|---|---|---|---|
| I-4.01 | excel | Comprehensive problem from adjustments to financial statements | ||
| I-4.02 | excel | Analysis of adjustments by review of trial balances | ||
| I-4.03 | excel | Developing a worksheet and related financial statements | ||
| I-4.04 | excel | Team-based identification of errors and corrections | ||
| I-4.05 | excel | The complete accounting cycle | ||
| I-4.06 | excel | Classified balance sheet | ||
| I-4.07 | excel | Current and quick ratios from annual reports |
Self-Grading
| Problem | Description | |
|---|---|---|
| 1 | excel | Self-Grading Problem |
MyExceLab
| Description | Problem | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Steps in the Accounting Process | excel | |||||||||||||||
| Preparing Financial Statements from an Adjusted Trial Balance | excel | |||||||||||||||
| Closing Entries and Impact | excel | |||||||||||||||
| Reversing Entry Comprehension and Practice | excel | |||||||||||||||
| Preparing a Classified Balance Sheet | excel | |||||||||||||||
| Quick and Current Ratios | 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.