Warning: foreach() argument must be of type array|object, bool given in /var/www/html/web/app/themes/studypress-core-theme/template-parts/header/mobile-offcanvas.php on line 20

Using a spreadsheet to complete the statement of cash flows— indirect method

Companies can use a spreadsheet to complete the statement of cash flows. Each item that follows is recorded in the transaction analysis columns of the spreadsheet.

  1. Net income
  2. Increases in current assets (other than Cash)
  3. Decreases in current liabilities
  4. Cash payment for acquisition of plant assets
  5. Cash receipt from issuance of common stock
  6. Depreciation expense

Identify each as being recorded by a Debit or Credit in the statement of cash flows section of the spreadsheet

Short Answer

Expert verified
  1. Debit
  2. Credit
  3. Credit
  4. Credit
  5. Debit
  6. Debit

Step by step solution

01

Step-by-Step SolutionStep 1: Statement of cash flow using indirect method and spreadsheet

Organizations can use a spreadsheet to prepare cash flow statements using the indirect method. In the spreadsheet first balance sheet is prepared followed by the cash flow statement.

02

Identification of transaction as debit or credit

Particulars

Debit or Credit

Net Income

Debit

Increase in current assets (other than cash)

Credit

Decreases in current liabilities

Credit

Cash payment for acquisition of plant assets

Credit

Cash receipt from issuance of common stock

Debit

Depreciation Expense

Debit

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with Vaia!

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

Classifying cash flow items Consider the following transactions:

  1. Purchased equipment for \(130,000 cash.
  2. Issued \)14 par preferred stock for cash.
  3. Cash received from sales to customers of \(35,000.
  4. Cash paid to vendors, \)17,000.
  5. Sold building for \(19,000 gain for cash.
  6. Purchased treasury stock for \)28,000.
  7. Retired a notes payable with 1,250 shares of the company’s common stock.

Identify the category of the statement of cash flows in which each transaction would be reported.

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 depreciation 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.

Preparing the direct method statement of cash flows Red Toy Company reported the following comparative balance sheet:

Requirements

1. Compute the collections from customers during 2018 for Red Toy Company. Sales Revenue totaled \(134,000.

2. Compute the payments for inventory during 2018. Cost of Goods Sold was \)79,000.

Question: Describe the five steps used to prepare the statement of cash flows by the indirect method.

Preparing operating activities using the direct method Amy’s Learning Center has assembled the following data for the year ended June 30, 2018:

Payments to suppliers $ 115,000

Cash payment for purchase of equipment 39,000

Payments to employees 66,000

Payment of notes payable 34,000

Payment of dividends 7,500

Cash receipt from issuance of stock 22,000

Collections from customers 188,000

Cash receipt from sale of land 58,000

Cash balance, June 30, 2017 41,000 Prepare the operating activities section of the business’s statement of cash flows for the year ended June 30, 2018, using the direct method.

See all solutions

Recommended explanations on Business Studies Textbooks

View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.

Sign-up for free