Basic

# Problem Worksheet Combined Description
B-15.01 pdf pdf excel Correction of an error – entry and reporting
B-15.02 pdf pdf excel Disposal of a business unit
B-15.03 pdf pdf excel Reporting Comprehensive Income
B-15.04 pdf pdf excel Reporting changes in accounting methods
B-15.05 pdf pdf excel Concepts including OCI/ROA/EBIT/EBITDA/etc.
B-15.06 pdf pdf excel Earnings per share
B-15.07 pdf pdf excel P/E, PEG, Dividend rates
B-15.08 pdf pdf excel Book value per share
B-15.09 pdf pdf excel Return on assets and return on equity
B-15.10 pdf pdf excel Qualitative characteristics of accounting
B-15.11 pdf pdf excel Identification of professional organizations
B-15.12 pdf pdf excel Accounting assumptions
B-15.13 pdf pdf excel Concepts in international accounting
B-15.14 pdf pdf excel Foreign currency transactions – purchasing activity
B-15.15 pdf pdf excel Foreign currency transactions – sales activity

 

Involved

# Problem Worksheet Combined Description
I-15.01 pdf pdf excel Income reporting for complex fact situation
I-15.02 pdf pdf excel Earnings per share – basic and diluted
I-15.03 pdf pdf excel Ratios and valuations
I-15.04 pdf pdf 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.