Basic
| # | Problem | Worksheet | Combined | Description |
|---|---|---|---|---|
| B-16.01 | excel | Liquidity analysis | ||
| B-16.02 | excel | Debt service ratios | ||
| B-16.02 | excel | Debt service ratios (data set) | ||
| B-16.03 | excel | Analysis of receivables and inventory turnover | ||
| B-16.04 | excel | Profitability ratios and analysis | ||
| B-16.05 | excel | Demonstrating understanding of P/E, book value, and yields | ||
| B-16.06 | excel | Classification of cash flows | ||
| B-16.07 | excel | Direct calculation of operating cash flows | ||
| B-16.08 | excel | Indirect calculation of operating cash flows | ||
| B-16.09 | excel | Rearranging cash flows in good form – direct approach | ||
| B-16.10 | excel | Rearranging cash flows in good form – indirect approach | ||
| B-16.11 | excel | Knowledge of cash flow statement components | ||
| B-16.12 | excel | Company cash flow evaluation | ||
| B-16.13 | excel | Preparation of statement of cash flows (direct) | ||
| B-16.14 | excel | Preparation of statement of cash flows (indirect) |
Involved
| # | Problem | Worksheet | Combined | Description |
|---|---|---|---|---|
| I-16.01 | excel | Ratios from comprehensive financial statements | ||
| I-16.02 | excel | Preparation of statement of cash flows (direct) | ||
| I-16.03 | excel | Preparation of statement of cash flows (indirect) | ||
| I-16.04 | excel | Worksheet for a statement of cash flows | ||
| I-16.05 | 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.