home page


Chapter 5 -- Comprehensive Problem Set
Special Issues for Merchants
Back to Chapter 5

The following table includes links to "Basic" and "Involved" problems based on Chapter 5.  Each "Excel" icon ( ) link will download the file containing a spreadsheet for the problem and a template worksheet on which you can prepare the solution electronically.  In the alternative, the pdf (   ) icons will download the "problem" and a preprinted "worksheet" that you can easily print.  The pdfs facilitate preparation of handwritten solutions.

Electronic spreadsheets are very useful accounting tools.  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.

Solutions to these problems may be obtained from your instructor, however you may not post or redistribute, electronically or otherwise, any such solution material.  Solution material may be provided to you for your sole use only, at the discretion of your individual instructor.  Violation of this policy constitutes a copyright violation.  Because different instructors have different philosophies and policies regarding access to solutions, I am not able to provide access to solutions for individual students; you must work through your instructor.  Your instructor may contact me by email and I will gladly grant the necessary authorization and access.  Thank you.

 

 

LINKS

OBJECTIVE

    EXCEL PROBLEM WORKSHEET  

Basic

B-05.01

Sales, returns and allowances
 

B-05.02

Sales discounts
 

B-05.03

Purchase transactions, business papers, net vs. gross
 

B-05.04

Sales and freight cost
 

B-05.05

Purchases and freight cost
 

B-05.06

Calculating values for a merchandising income statement

 

B-05.07

Preparing a merchandising income statement
 

B-05.08

Closing entries

 

B-05.09

Perpetual inventory

 

B-05.10

Single-step and multiple-step income statements
 

B-05.11

Profit margin analysis
 

B-05.12

Control structure
           

Involved

I-05.01

Comprehensive merchandising entries

 

I-05.02

Gross vs. net recording of purchases, entries and reporting

 

I-05.03

Merchandising income statement and closing

 

I-05.04

Perpetual inventory vs. periodic inventory

 

I-05.05

Single-step and multiple-step income statements, profit margins

 

I-05.06

Team-based study of controls