Problems: Chapter Sixteen

Using Accounting Information Problem Workbook

 
 
Obtain the entire Using Information 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-16.01   pdf link
pdf link
Excel link
  Liquidity analysis
               
  B-16.02  
pdf link
pdf link
Excel link
  Debt service ratios
               
  B-16.02  
Excel with light bulb icon
  Debt service ratios (data set)
               
  B-16.03  
pdf link
pdf link
Excel link
  Analysis of receivables and inventory turnover
               
  B-16.04  
pdf link
pdf link
Excel link
  Profitability ratios and analysis
               
  B-16.05  
pdf link
pdf link
Excel link
  Demonstrating understanding of P/E, book value, and yields
               
  B-16.06  
pdf link
pdf link
Excel link
  Classification of cash flows
               
  B-16.07  
pdf link
pdf link
Excel link
  Direct calculation of operating cash flows
               
  B-16.08  
pdf link
pdf link
Excel link
  Indirect calculation of operating cash flows
     
   
  B-16.09  
pdf link
pdf link
Excel link
  Rearranging cash flows in good form - direct approach
     
   
  B-16.10  
pdf link
pdf link
Excel link
  Rearranging cash flows in good form - indirect approach
     
   
  B-16.11  
pdf link
pdf link
Excel link
  Knowledge of cash flow statement components
     
   
  B-16.12  
pdf link
pdf link
Excel link
  Company cash flow evaluation
     
   
  B-16.13  
pdf link
pdf link
Excel link
  Preparation of statement of cash flows (direct)
     
   
  B-16.14  
pdf link
pdf link
Excel link
  Preparation of statement of cash flows (indirect)
               
               
               
Involved
 
Problem
Worksheet
Combined
  Objective
               
  I-16.01  
pdf link
pdf link
Excel link
  Ratios from comprehensive financial statements
               
  I-16.02  
pdf link
pdf link
Excel link
  Preparation of statement of cash flows (direct)
               
  I-16.03  
pdf link
pdf link
Excel link
  Preparation of statement of cash flows (indirect)
               
  I-16.04  
pdf link
pdf link
Excel link
  Worksheet for a statement of cash flows
               
  I-16.05  
pdf link
pdf link
Excel link
  Team-based approach to evaluation of cash flows

 

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.