Log out Go to App
Go to App

Learning Materials

Features

Discover

Chapter 14: Q16RQ (page 769)

Why might a spreadsheet be helpful when completing the statement of cash flows?

Short Answer

Expert verified

The spreadsheets help in the creating cash flow statement because it makes the calculation of cash flow statement from the balance sheet and profit and loss accounts easier.

Step by step solution

01

Definition of break-even point

The statement of cash flow is defined as the financial statement which records the movements of cash outflow and inflow throughout the year of the company.

02

Usage of the spreadsheet when completing the statement of cash flows

The spreadsheets are useful for the companies in preparing the cash flow statement because the companies face complex situations. It helps in detailing the opening and ending balances of the accounts on the balance sheet as well as the debit and credit accounts.

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

Boundary Rare Coins (BRC) was formed on January 1, 2018. Additional data for the year follow:

  1. On January 1, 2018, BRC issued no-par common stock for \(475,000.
  2. Early in January, BRC made the following cash payments:For store fixtures, \)53,000;For merchandise inventory, \(260,000;For rent expense on the store building, \)13,000
  3. Later in the year, BRC purchased merchandise inventory on account for \(240,000. Before year-end, BRC paid \)160,000 of these accounts payable.
  4. During 2018, BRC sold 2,200 units of merchandise inventory for \(450 each. Before year-end, the company collected 85% of this amount. Cost of goods sold for the year was \)330,000, and ending merchandise inventory totaled \(170,000.
  5. The store employs three people. The combined annual payroll is \)80,000, of which BRC still owes \(4,000 at year-end.
  6. At the end of the year, BRC paid income tax of \)24,000. There are no income taxes payable.
  7. Late in 2018, BRC paid cash dividends of $40,000.
  8. For store fixtures, BRC uses the straight-line depreciation method, over five years, with zero residual value.

Requirements

  1. Prepare BRC’s income statement for the year ended December 31, 2018. Use the single-step format, with all revenues listed together and all expenses listed together.
  2. Prepare BRC’s balance sheet at December 31, 2018.
  3. Prepare BRC’s statement of cash flows for the year ended December 31, 2018. Format cash flows from operating activities by 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: What types of transactions are reported in the non-cash investing and financing activities section of the statement of cash flows?

Question: Owl, Inc.’s accountants have assembled the following data for the year ended December 31, 2018: Cash receipt from sale of equipment \( 20,000

Depreciation expense 12,000

Cash payment of dividends 4,000

Cash receipt from issuance of common stock 12,000

Net income 30,000

Cash purchase of land 25,000

Increase in current liabilities 10,000

Decrease in current assets other than cash 8,000

Prepare Owl’s statement of cash flows using the indirect method for the year ended December 31, 2018. Assume beginning and ending Cash are \)12,000 and $75,000 respectively

The comparative balance sheet of Jackson Educational Supply at December 31, 2018, reported the following:


20182017
Current

Assets:
Cash\( 87,700
\) 23,500
Accounts Receivable15,30022,000
Merchandise Inventory
62,600
60,400
Current

Liabilities:
Accounts Payable
28,100
26,100
Accrued Liabilities
10,600
11,300

Jackson’s transactions during 2018 included the following:

Payment of cash dividends \( 16,200

Depreciation expense \) 16,700

Purchase of equipment with cash 54,700

Purchase of building with cash 98,000

Issuance of long-term notes payable to borrow cash 48,000

Net income 57,600

Issuance of common stock for cash 105,000

Requirements

  1. Prepare the statement of cash flows of Jackson Educational Supply for the year ended December 31, 2018. Use the indirect method to report cash flows from operating activities.
  2. Evaluate Jackson’s cash flows for the year. Mention all three categories of cash flows, and give the reason for your evaluation.
  3. If Jackson plans similar activity for 2019, what is its expected free cash flow?
See all solutions

Recommended explanations on Business Studies Textbooks

Introduction to Business

Read Explanation

Managerial Economics

Read Explanation

Strategic Analysis

Read Explanation

Business Case Studies

Read Explanation

Business Operations

Read Explanation

Organizational Communication

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