Exercise 12-16A (Static) Indirect: Cash flows spreadsheet LO P4

Complete the following Spreadsheet for the preparation of statement of cash flows under the indirect method. (The statement of cash flows is not required.) (Enter all amounts as positive values.)

Additional information:

1. Net income for the year was $100,000.
2. Dividends of $80,000 cash were declared and paid.
3. The only noncash expense was $70,000 of depreciation.
4. Purchased plant assets for $90,000 cash.
5. Notes payable of $20,000 were issued for $20,000 cash.
6. $50,000 increase in accounts receivable.
7. $30,000 decrease in inventory.
8. $10,000 decrease in accounts payable.

Exercise 12-16A (Static) Indirect: Cash flows spreadsheet LO P4

Complete the following Spreadsheet for the preparation of statement of cash flows under the indirect method. (The statement of cash flows is not required.) (Enter all amounts as positive values.)

Additional information:

1. Net income for the year was $100,000.
2. Dividends of $80,000 cash were declared and paid.
3. The only noncash expense was $70,000 of depreciation.
4. Purchased plant assets for $90,000 cash.
5. Notes payable of $20,000 were issued for $20,000 cash.
6. $50,000 increase in accounts receivable.
7. $30,000 decrease in inventory.
8. $10,000 decrease in accounts payable.