Statement of cash flow – Spreadsheet method Statement of cash flows: It is one of the financial statement that shows the cash and cash equivalents of a company for a particular period. It determines the net changes in cash through reporting the sources and uses of cash due to the operating, investing, and financing activities of a company. Spreadsheet method: The statement of cash flows also can be prepared as a spreadsheet. The spreadsheet for the statement of cash flow starts with the beginning balance and ends with the ending balances of accounts of the balances sheet. The spread includes two extra columns between the ending and beginning balance columns. One column is for debit and other for credit balance. To Prepare: Statement of cash flows using the spreadsheet in indirect method.

Question

Want to see the full answer?

Answer 1

Question

Chapter 14, Problem 14.38AP

To determine

Statement of cash flow – Spreadsheet method

Statement of cash flows: It is one of the financial statement that shows the cash and cash equivalents of a company for a particular period. It determines the net changes in cash through reporting the sources and uses of cash due to the operating, investing, and financing activities of a company.

Spreadsheet method:

The statement of cash flows also can be prepared as a spreadsheet.

The spreadsheet for the statement of cash flow starts with the beginning balance and ends with the ending balances of accounts of the balances sheet.

The spread includes two extra columns between the ending and beginning balance columns. One column is for debit and other for credit balance.

To Prepare: Statement of cash flows using the spreadsheet in indirect method.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

Use the information provided below to prepare the Cash Flow Statement of Chelsea Limited for the year ended 31 December 2021 using the answer template provided (see images) Additional information: (See images)¦ Selling and administrative expenses include depreciation as follows:Depreciation on buildings R96 000Depreciation on plant and machinery R160 000¦ There were purchases but no disposals of property, plant and equipment for the financial year ended 31 December2021.¦ Total dividends for the year ended 31 December 2021 and 31 December 2020 amounted toR288 000 and R388 000 respectively.¦ Inventories on 31 December 2019 amounted to R560 000.¦ All purchases and sales of inventories were on credit.¦ The number of shares in issue was 400 000.¦ Credit terms from creditors are 90 days.

Using a spreadsheet to prepare the statement of cash flows—indirect method The 2018 comparative balance sheet and income statement of Attleboro Group, Inc. follow. Attleboro disposed of a plant asset at book value in 2018. Prepare the spreadsheet for the 2018 statement of cash flows. Format cash flows from operating activities by the indirect method. A plant asset was disposed of for $0. The cost and accumulated depreciation of the disposed asset was $13,600. There were no sales of land, no retirement of common stock, and no treasury stock transactions. Assume plant asset and land acquisitions were for cash.

Using a spreadsheet to prepare the statement of cash flows—indirect method The 2018 comparative balance sheet and income statement of Appleton Group, Inc. follow. Appleton disposed of a plant asset at book value during 2018. Prepare the spreadsheet for the 2018 statement of cash flows. Format cash flows from operating activities by the indirect method. A plant asset was disposed of for $0. The cost and accumulated depredation of the disposed asset was $11,600. There were no sales of land, no retirement of common stock, and no treasury stock transactions. Assume plant asset and land acquisitions were for cash.