Chapter 16 β Exercises & Cases
Multiple Choice Questionsβ
-
The statement of cash flows shows: a) Only profit b) Cash receipts and payments c) Only assets d) Only liabilities Answer: b) Statement of cash flows shows cash receipts and payments.
-
Operating activities include: a) Purchase of equipment b) Cash from customers c) Issuing shares d) Paying dividends Answer: b) Operating activities include cash from customers.
-
The indirect method starts with: a) Cash balance b) Net income c) Revenue d) Expenses Answer: b) Indirect method starts with net income.
Questionsβ
-
What is the purpose of the statement of cash flows?
-
How do operating, investing, and financing activities differ?
-
How is the indirect method used to calculate cash from operations?
-
What information is needed to prepare a statement of cash flows?
-
What are the Luxembourg requirements for cash flow statements?
Problems Set Aβ
Problem A-1: Operating Activities - Indirect Method
Calculate cash from operating activities:
- Net Income: β¬40,000
- Depreciation: β¬8,000
- Accounts Receivable increased: β¬3,000
- Inventory decreased: β¬2,000
- Accounts Payable increased: β¬2,000
- Salaries Payable decreased: β¬1,000
Problem A-2: Investing Activities
Record investing activities:
- Purchased equipment: β¬20,000 cash
- Sold equipment: β¬5,000 cash (cost β¬8,000, accumulated depreciation β¬3,000, book value β¬5,000)
- Purchased vehicle: β¬15,000 cash
Problem A-3: Financing Activities
Record financing activities:
- Borrowed β¬30,000
- Repaid loan principal: β¬10,000
- Paid interest: β¬2,000
- Paid dividends: β¬5,000
Problem A-4: Complete Operating Section
Calculate cash from operating activities:
- Net Income: β¬60,000
- Depreciation: β¬12,000
- Amortization: β¬2,000
- Gain on Sale of Equipment: β¬3,000
- Accounts Receivable: +β¬5,000
- Inventory: -β¬4,000
- Prepaid Expenses: +β¬1,000
- Accounts Payable: +β¬6,000
- VAT Payable: -β¬2,000
Problem A-5: Net Change in Cash
Calculate net change in cash:
- Cash from Operating: β¬50,000
- Cash from Investing: (β¬30,000)
- Cash from Financing: β¬20,000
Problems Set Bβ
Problem B-1: Complete Statement of Cash Flows
From the following information, prepare a complete statement of cash flows:
Income Statement:
- Net Income: β¬75,000
- Depreciation: β¬15,000
- Loss on Sale: β¬2,000
Balance Sheet Changes:
- Accounts Receivable: +β¬8,000
- Inventory: -β¬3,000
- Accounts Payable: +β¬5,000
- Salaries Payable: -β¬2,000
Investing Activities:
- Purchased Equipment: β¬25,000
- Sold Equipment: β¬8,000
Financing Activities:
- Borrowed: β¬30,000
- Repaid Loan: β¬15,000
- Paid Dividends: β¬10,000
Cash:
- Beginning: β¬20,000
- Ending: ?
Problem B-2: Operating Activities with Multiple Adjustments
Calculate cash from operating activities:
- Net Income: β¬100,000
- Depreciation: β¬20,000
- Amortization: β¬3,000
- Gain on Sale: β¬5,000
- Accounts Receivable: +β¬10,000
- Inventory: +β¬5,000
- Prepaid: -β¬2,000
- Accounts Payable: +β¬8,000
- VAT Payable: +β¬2,000
- Salaries Payable: -β¬3,000
- Interest Payable: +β¬1,000
Problem B-3: Cash Flow Analysis
A business has:
- Cash from Operating: β¬80,000
- Cash from Investing: (β¬50,000)
- Cash from Financing: β¬20,000
Analyze: a) Net change in cash b) Is the business generating enough cash from operations? c) What are the cash flow implications?
Problem B-4: Reconciliation
Reconcile net income to cash from operating activities:
- Net Income: β¬90,000
- Depreciation: β¬18,000
- Accounts Receivable: +β¬12,000
- Inventory: -β¬4,000
- Accounts Payable: +β¬7,000
- Other adjustments: β¬3,000
Comprehensive Problemβ
Comprehensive Problem 16: Complete Statement of Cash Flows
Le Petit Bistro needs to prepare a statement of cash flows for 2024.
Income Statement (2024):
- Net Income: β¬120,000
- Depreciation Expense: β¬25,000
- Amortization Expense: β¬3,000
- Loss on Sale of Equipment: β¬2,000
- Interest Expense: β¬5,000
Balance Sheet Changes (2023 to 2024):
Assets:
- Cash: β¬30,000 β β¬45,000
- Accounts Receivable: β¬40,000 β β¬50,000
- Inventory: β¬60,000 β β¬55,000
- Prepaid Expenses: β¬5,000 β β¬7,000
- Equipment: β¬200,000 β β¬230,000
- Accumulated Depreciation: (β¬50,000) β (β¬65,000)
Liabilities:
- Accounts Payable: β¬25,000 β β¬30,000
- VAT Payable: β¬8,000 β β¬10,000
- Salaries Payable: β¬12,000 β β¬10,000
- Long-Term Loan: β¬100,000 β β¬80,000
Equity:
- Share Capital: β¬150,000 β β¬150,000
- Retained Earnings: β¬90,000 β β¬162,000
Additional Information:
- Equipment purchased: β¬50,000 cash
- Equipment sold: Cost β¬20,000, Accumulated Depreciation β¬10,000, Cash received β¬8,000
- Loan repayment: β¬20,000 principal
- Dividends paid: β¬48,000
- Interest paid: β¬5,000
Required:
-
Calculate cash from operating activities using the indirect method.
-
Calculate cash from investing activities.
-
Calculate cash from financing activities.
-
Prepare complete statement of cash flows.
-
Reconcile beginning and ending cash balances.
-
Analyze cash flow: a) Is the business generating positive operating cash flow? b) What are the main uses of cash? c) How is the business financing its activities? d) What are the cash flow implications?
-
Explain Luxembourg requirements: a) PCN format requirements b) When statement of cash flows is required c) RCS filing requirements d) Disclosure requirements
Casesβ
Case 16-1: Cash Flow vs. Profit
Marie's restaurant shows a profit of β¬50,000, but her bank account only increased by β¬10,000. She's confused about the difference.
Questions for Analysis:
-
Why is there a difference between profit and cash flow?
-
What items on the income statement don't affect cash?
-
How can a business have profit but negative cash flow?
-
What adjustments are needed to reconcile net income to cash from operations?
-
How should Marie analyze her cash flow statement?
-
What actions should Marie take to improve cash flow?
Case 16-2: Cash Flow Management
A Luxembourg SME is experiencing cash flow problems despite being profitable. The business needs to:
- Understand cash flow patterns
- Improve cash collection
- Manage cash payments
- Plan for cash needs
Questions for Analysis:
-
How can the statement of cash flows help identify cash flow problems?
-
What are common causes of cash flow problems?
-
How can operating cash flow be improved?
-
What are the implications of negative operating cash flow?
-
How should the business plan for cash needs?
-
What are the Luxembourg requirements for cash flow reporting?
Solutions are published in supplementary/instructor/solutions/chapter_16_solutions.md.