Problems: Chapter Ten

Long_term Assets Problem Workbook

 
 
Obtain the entire Long-Term Assets Problem Workbook via the linked image at left. Our high volume production process makes this an economical option as compared to printing these files on your own printer!

 

       
               
Basic
 
Problem
Worksheet
Combined
  Objective
               
  B-10.01   pdf link
pdf link
Excel link
  Balance sheet presentation of property, plant & equipment
               
  B-10.02  
pdf link
pdf link
Excel link
  Determining asset acquisition cost and recording
               
  B-10.03  
pdf link
pdf link
Excel link
  Identification of capital expenditures
               
  B-10.04  
pdf link
pdf link
Excel link
  Lump sum purchase price allocation
               
  B-10.05  
pdf link
pdf link
Excel link
  Lease classification
               
  B-10.06  
pdf link
pdf link
Excel link
  Straight-line depreciation
               
  B-10.07  
pdf link
pdf link
Excel link
  Units-of-output depreciation
               
  B-10.08  
pdf link
pdf link
Excel link
  Double-declining balance depreciation
     
   
  B-10.09  
pdf link
pdf link
Excel link
  Change in estimate for depreciation
               
               
               
Involved
 
Problem
Worksheet
Combined
  Objective
               
  I-10.01  
pdf link
pdf link
Excel link
  Terminology and concepts
               
  I-10.02  
pdf link
pdf link
Excel link
  Evaluation of property, plant, and equipment
               
  I-10.03  
pdf link
pdf link
Excel link
  Depreciation calculations with alternative methods
               
  I-10.04  
pdf link
pdf link
Excel link
  Fractional year depreciation calculations
               
  I-10.05  
pdf link
pdf link
Excel with light bulb icon
  Using spreadsheet software for depreciation calculations
     
   
  I-10.06  
pdf link
pdf link
Excel link
  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.