Basic

# Problem Worksheet Combined Description
B-16.01 pdf pdf excel Liquidity analysis
B-16.02 pdf pdf excel Debt service ratios
B-16.02     excel Debt service ratios (data set)
B-16.03 pdf pdf excel Analysis of receivables and inventory turnover
B-16.04 pdf pdf excel Profitability ratios and analysis
B-16.05 pdf pdf excel Demonstrating understanding of P/E, book value, and yields
B-16.06 pdf pdf excel Classification of cash flows
B-16.07 pdf pdf excel Direct calculation of operating cash flows
B-16.08 pdf pdf excel Indirect calculation of operating cash flows
B-16.09 pdf pdf excel Rearranging cash flows in good form – direct approach
B-16.10 pdf pdf excel Rearranging cash flows in good form – indirect approach
B-16.11 pdf pdf excel Knowledge of cash flow statement components
B-16.12 pdf pdf excel Company cash flow evaluation
B-16.13 pdf pdf excel Preparation of statement of cash flows (direct)
B-16.14 pdf pdf excel Preparation of statement of cash flows (indirect)

 

Involved

# Problem Worksheet Combined Description
I-16.01 pdf pdf excel Ratios from comprehensive financial statements
I-16.02 pdf pdf excel Preparation of statement of cash flows (direct)
I-16.03 pdf pdf excel Preparation of statement of cash flows (indirect)
I-16.04 pdf pdf excel Worksheet for a statement of cash flows
I-16.05 pdf pdf excel Team-based approach to evaluation of cash flows

 

Self-Grading

  Problem Description
1 excel Self-Grading Problem

 

MyExceLab

Description Problem                              
Financial Statement Analysis excel                              
Cash Flow Categories excel                              
Calculating Operating Cash Flows excel                              
Indirect Reconciliation excel                              
Indirect Approach excel                              
Cash Flow Worksheet 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.