Basic

# Problem Worksheet Combined Description
B-10.01 pdf pdf excel Balance sheet presentation of property, plant & equipment
B-10.02 pdf pdf excel Determining asset acquisition cost and recording
B-10.03 pdf pdf excel Identification of capital expenditures
B-10.04 pdf pdf excel Lump sum purchase price allocation
B-10.05 pdf pdf excel Lease classification
B-10.06 pdf pdf excel Straight-line depreciation
B-10.07 pdf pdf excel Units-of-output depreciation
B-10.08 pdf pdf excel Double-declining balance depreciation
B-10.09 pdf pdf excel Change in estimate for depreciation

 

Involved

# Problem Worksheet Combined Description
I-10.01 pdf pdf excel Terminology and concepts
I-10.02 pdf pdf excel Evaluation of property, plant, and equipment
I-10.03 pdf pdf excel Depreciation calculations with alternative methods
I-10.04 pdf pdf excel Fractional year depreciation calculations
I-10.05 pdf pdf excel Using spreadsheet software for depreciation calculations
I-10.06 pdf pdf excel Team-based analysis of depreciation methods used

 

Self-Grading

  Problem Description
1 excel Self-Grading Problem

 

MyExceLab

Description Problem                              
Identification of Capital Expenditures excel                              
Lump Sum Acquisition excel                              
Applying Terminology excel                              
Depreciation Tables 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.