home page
Chapter 16
-- Comprehensive Problem Set
Financial
Analysis and the Statement of Cash Flows
Back to Chapter 16
The following table includes links
to "Basic" and
"Involved" problems based on
Chapter 16. 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.
In the alternative, the pdf (
) icons will download the
"problem" and a
preprinted
"worksheet" that you
can easily print. The pdfs facilitate preparation of handwritten
solutions.
Electronic spreadsheets are very
useful accounting tools. 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. Because different instructors have different philosophies and policies regarding access to solutions, I am not able to provide access to solutions for individual students; you must work through your instructor. Your instructor may contact me by email and I will gladly grant the necessary authorization and access. Thank you.
|
|
|
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 |
|