Chapter 16 Comprehensive Problem Set Using Information
FINANCIAL  ANALYSIS  AND
THE  STATEMENT  OF  CASH  FLOWS




   
Obtain the entire Using Information 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 16   Back to Home Page

 

 

LINKS

OBJECTIVE

EXCEL PROBLEM WORKSHEET  

Basic

B-16.01

Liquidity analysis
 

B-16.02

Debt service ratios
 

B-16.03

Analysis of receivables and inventory turnover
 

B-16.04

Profitability ratios and analysis
 

B-16.05

Demonstrating understanding of P/E, book value, and yields
 

B-16.06

Classification of cash flows
 

B-16.07

Direct calculation of operating cash flows
 

B-16.08

Indirect calculation of operating cash flows

 

B-16.09

Rearranging cash flows in good form - direct approach

 

B-16.10

Rearranging cash flows in good form - indirect approach

 

B-16.11

Knowledge of cash flow statement components
 

B-16.12

Company cash flow evaluation
 

B-16.13

Preparation of statement of cash flows (direct)
 

B-16.14

Preparation of statement of cash flows (indirect)
           

Involved

I-16.01

Ratios from comprehensive financial statements

 

I-16.02

Preparation of statement of cash flows (direct)

 

I-16.03

Preparation of statement of cash flows (indirect)

 

I-16.04

Worksheet for a statement of cash flows

 

I-16.05

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.