Log out Go to App
Go to App

Learning Materials

Features

Discover

Chapter 14: Q15SE (page 774)

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.

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

Question: Computing cash flows from operating activities—indirect method

Winding Road Cellular accountants have assembled the following data for the year ended April 30, 2018:

Cash receipt from sale of land \( 27,000

Net income \) 55,000

Depreciation expense 2,000

Cash purchase of equipment 44,000

Cash payment of dividends 5,800

Decrease in current liabilities 20,000

Cash receipt from issuance of common stock 17,000

Increase in current assets other than cash 27,000

Prepare the operating activities section using the indirect method for Winding Road Cellular’s statement of cash flows for the year ended April 30, 2018.

Moss Exports is having a bad year. Net income is only \(60,000. Also, two important overseas customers are falling behind in their payments to Moss, and Moss’s accounts receivable are ballooning. The company desperately needs a loan. The Moss Exports Board of Directors is considering ways to put the best face on the company’s financial statements. Moss’s bank closely examines cash flow from operating activities. Daniel Peavey, Moss’s controller, suggests reclassifying the receivables from the slow-paying clients as long-term. He explains to the board that removing the \)80,000 increase in accounts receivable from current assets will increase net cash provided by operations. This approach may help Moss get the loan.

Requirements

  1. Using only the amounts given, compute net cash provided by operations, both without and with the reclassification of the receivables. Which reporting makes Moss look better?
  2. Under what condition would the reclassification of the receivables be ethical? Unethical?

Question: Big Island, Inc. began 2018 with cash of \(40,000. During the year, Big Island earned revenue of \)200,000 and collected \(120,000 from customers. Expenses for the year totaled \)160,000, of which Big Island paid \(65,000 in cash to suppliers and \)80,000 in cash to employees. The company received \(2,000 cash for interest revenue and paid \)10,000 for income taxes. Big Island also paid \(35,000 to purchase equipment and a cash dividend of \)15,000 to its stockholders during 2018. Prepare the company’s operating activities section of the statement of cash flows for the year ended December 31, 2018. Use the direct method.

Preparing the statement of cash flows—indirect method with non-cash transactions the 2018 income statement and comparative balance sheet of Sweet Valley, Inc. follow:

Additionally, Sweet Valley purchased land of \(20,900 by financing it 100% with long-term notes payable during 2018. During the year, there were no sales of land, no retirements of stock, and no treasury stock transactions. A plant asset was disposed of for \)0. The cost and the accumulated depreciation of the disposed asset were $13,240. Plant asset was acquired for cash.

Requirements

1. Prepare the 2018 statement of cash flows, formatting operating activities by the indirect method.

2. How will what you learned in this problem help you evaluate an investment?

Question: Muench, Inc.’s accountant has partially completed the spreadsheet for the statement of cash flows. Fill in the remaining missing information.
See all solutions

Recommended explanations on Business Studies Textbooks

Introduction to Business

Read Explanation

Managers

Read Explanation

Nature of Business

Read Explanation

Organizational Communication

Read Explanation

Business Operations

Read Explanation

Influences On Business

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