Log out Go to App
Go to App

Learning Materials

Features

Discover

Chapter 14: 15SE (page 732)

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

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.

Start your free trial

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

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.

Preparing the statement of cash flows—direct method The income statement and additional data of Value Corporation follow:

  1. Collections from customers are \(13,000 more than sales.
  2. Dividend revenue, interest expense, and income tax expense equal their cash amounts.
  3. Payments to suppliers are the sum of cost of goods sold plus advertising expense.
  4. Payments to employees are \)3,000 more than salaries expense.
  5. Cash payment for the acquisition of plant assets is \(102,000.
  6. Cash receipts from sale of land total \)29,000.
  7. Cash receipts from issuance of common stock total \(38,000.
  8. Payment of long-term notes payable is \)10,000.
  9. Payment of dividends is \(9,000.
  10. Cash balance at June 30, 2017, was \)21,000; at June 30, 2018, it was $43,000.
    Prepare Value Corporation’s statement of cash flows for the year ended June 30, 2018. Use the direct method.

Preparing the direct method statement of cash flows Use the data in Short Exercise S14A-12 and your results. Prepare the business’s complete statement of cash flows for the year ended June 30, 2018, using the direct method for operating activities

Classifying transactions on the statement of cash flows—indirect method Consider the following transactions:

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

Use the Rouse Exercise Equipment data in Exercises E14-23 and E14-24. Rouse plansto purchase a truck for \(23,000 and a forklift for \)125,000 next year. In addition, itplans to pay cash dividends of $3,500. Assuming Rouse plans similar activity for 2019,what would be the amount of free cash flow?
See all solutions

Recommended explanations on Business Studies Textbooks

Human Resources

Read Explanation

Business Case Studies

Read Explanation

Organizational Behavior

Read Explanation

Managerial Economics

Read Explanation

Intermediate Accounting

Read Explanation

Change Management

Read Explanation
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