Basic

# Problem Worksheet Combined Description
B-9.01 pdf pdf excel Classification of investments
B-9.02 pdf pdf excel Considering fair value standards
B-9.03 pdf pdf excel Trading versus available-for-sale, and other comprehensive income
B-9.04 pdf pdf excel Accounting for available-for-sale investments
B-9.05 pdf pdf excel Bond investment purchased at par
B-9.06 pdf pdf excel Bond investment purchased at a premium
B-9.07 pdf pdf excel Bond investment purchased at a discount
B-9.08 pdf pdf excel Accounting for equity method investments
B-9.09 pdf pdf excel Basic consolidated balance sheet
B-9.10 pdf pdf excel Goodwill in a consolidated balance sheet

 

Involved

# Problem Worksheet Combined Description
I-9.01 pdf pdf excel Stock investment accounting
I-9.02 pdf pdf excel Bonds and amortization table
I-9.03 pdf pdf excel Bond investment accounting
I-9.04 pdf pdf excel Equity method accounting and analysis
I-9.05 pdf pdf excel Preparing a consolidated balance sheet
I-9.06 pdf pdf excel Team-based consideration of investment accounting

 

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.