Basic
| # | Problem | Worksheet | Combined | Description |
|---|---|---|---|---|
| B-9.01 | excel | Classification of investments | ||
| B-9.02 | excel | Considering fair value standards | ||
| B-9.03 | excel | Trading versus available-for-sale, and other comprehensive income | ||
| B-9.04 | excel | Accounting for available-for-sale investments | ||
| B-9.05 | excel | Bond investment purchased at par | ||
| B-9.06 | excel | Bond investment purchased at a premium | ||
| B-9.07 | excel | Bond investment purchased at a discount | ||
| B-9.08 | excel | Accounting for equity method investments | ||
| B-9.09 | excel | Basic consolidated balance sheet | ||
| B-9.10 | excel | Goodwill in a consolidated balance sheet |
Involved
| # | Problem | Worksheet | Combined | Description |
|---|---|---|---|---|
| I-9.01 | excel | Investment accounting | ||
| I-9.02 | excel | Bonds and amortization table | ||
| I-9.03 | excel | Bond investment accounting | ||
| I-9.04 | excel | Equity method accounting and analysis | ||
| I-9.05 | excel | Preparing a consolidated balance sheet | ||
| I-9.06 | excel | Team-based consideration of investment accounting |
Self-Grading
| Problem | Description | |
|---|---|---|
| 1 | excel | Self-Grading Problem |
MyExceLab
| Description | Problem | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| General Methods for Investment Accounting | excel | |||||||||||||||
| Available-for-Sale Securities | excel | |||||||||||||||
| Bond Investment Accounting | excel | |||||||||||||||
| Equity Method | excel | |||||||||||||||
| Consolidation | 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.