Chapter 10 Comprehensive Problem Set Long-term Assets
PROPERTY,  PLANT,  AND EQUIPMENT



   
Obtain the entire Long-term Assets Problem Workbook via the linked image at right, above.
Our high volume production process makes this an economical option as compared to printing these files on your own printer!
Back to Chapter 10   Back to Home Page

 

 

LINKS

OBJECTIVE

EXCEL PROBLEM WORKSHEET  

Basic

B-10.01

Balance sheet presentation of property, plant & equipment
 

B-10.02

Determining asset acquisition cost and recording
 

B-10.03

Identification of capital expenditures
 

B-10.04

Lump sum purchase price allocation
 

B-10.05

Lease classification
 

B-10.06

Straight-line depreciation
 

B-10.07

Units-of-output depreciation
 

B-10.08

Double-declining balance depreciation
 

B-10.09

Change in estimate for depreciation
           

Involved

I-10.01

Terminology and  concepts
 

I-10.02

Evaluation of property, plant, and equipment
 

I-10.03

Depreciation calculations with alternative methods
 

I-10.04

Fractional year depreciation calculations
 

I-10.05

Using spreadsheet software for depreciation calculations
 

I-10.06

Team-based analysis of depreciation methods used

The preceding table includes links to "Basic" and "Involved" problems.  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.  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.   Alternative problems, with solutions, may be found under the "Exercises" tab within each chapter.  Video solutions to selected problems are available to students enrolling in the online course.