Basic
| # | Problem | Worksheet | Combined | Description |
|---|---|---|---|---|
| B-15.01 | excel | Correction of an error – entry and reporting | ||
| B-15.02 | excel | Disposal of a business unit | ||
| B-15.03 | excel | Reporting Comprehensive Income | ||
| B-15.04 | excel | Reporting changes in accounting methods | ||
| B-15.05 | excel | Concepts including OCI/ROA/EBIT/EBITDA/etc. | ||
| B-15.06 | excel | Earnings per share | ||
| B-15.07 | excel | P/E, PEG, Dividend rates | ||
| B-15.08 | excel | Book value per share | ||
| B-15.09 | excel | Return on assets and return on equity | ||
| B-15.10 | excel | Qualitative characteristics of accounting | ||
| B-15.11 | excel | Identification of professional organizations | ||
| B-15.12 | excel | Accounting assumptions | ||
| B-15.13 | excel | Concepts in international accounting | ||
| B-15.14 | excel | Foreign currency transactions – purchasing activity | ||
| B-15.15 | excel | Foreign currency transactions – sales activity |
Involved
| # | Problem | Worksheet | Combined | Description |
|---|---|---|---|---|
| I-15.01 | excel | Income reporting for complex fact situation | ||
| I-15.02 | excel | Earnings per share – basic and diluted | ||
| I-15.03 | excel | Ratios and valuations | ||
| I-15.04 | excel | Team-based approach to foreign currency transactions |
Self-Grading
| Problem | Description | |
|---|---|---|
| 1 | excel | Self-Grading Problem |
MyExceLab
| Description | Problem | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Calculating Basic EPS | excel | |||||||||||||||
| Profit and Equity Ratios | excel | |||||||||||||||
| Special Reporting | excel | |||||||||||||||
| Accounting Qualities | excel | |||||||||||||||
| Key Assumptions | excel | |||||||||||||||
| Foreign Currency Transactions | 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.