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.

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

Accountants for Benson, Inc. have assembled the following data for the year ended December 31, 2018:

2018 2017 Current Assets: Cash \( 105,100 \) 18,000 Accounts Receivable 64,400 68,900 Merchandise Inventory 86,000 82,000 Current Liabilities: Accounts Payable 58,000 56,100 Income Tax Payable 14,700 16,900

Transaction Data for 2018:

Issuance of common stock for cash \( 37,000

Payment of notes payable \) 47,100

Depreciation expense 24,000

Payment of cash dividends 53,000

Purchase of equipment with cash 69,000

Issuance of notes payable to borrow cash 68,000

Acquisition of land by issuing long-term notes payable 123,000

Gain on sale of building 4,500

Book value of building sold 61,000

Net income 66,000

Prepare Benson’s statement of cash flows using the indirect method. Include an accompanying schedule of non-cash investing and financing activities

Preparing operating activities cash flow—direct method

The accounting records of Four Seasons Parts reveal the following:

Payment of salaries and wages \( 34,000

Net income \) 21,000

Depreciation expense 10,000

Payment of income tax 16,000

Payment of interest 17,000

Collection of dividend revenue 5,000

Payment of dividends 5,000

Payment to suppliers 51,000

Collections from customers 116,000

Compute cash flows from operating activities using the direct method for the year ended December 31, 2018.

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

Additionally, Rolling Hills purchased land of \(21,100 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 was $13,410. The plant acquisition was 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: Classifying items on the indirect statement of cash flows

Destiny Corporation is preparing its statement of cash flows by the indirect method. Destiny has the following items for you to consider in preparing the statement:

a. Increase in accounts payable

b. Payment of dividends

c. Decrease in accrued liabilities

d. Issuance of common stock

e. Gain on sale of building

f. Loss on sale of land

g. Depreciation expense

h. Increase in merchandise inventory

i. Decrease in accounts receivable

j. Purchase of equipment

Identify each item as a(n): • Operating activity—addition to net income (O+) or subtraction from net income (O-) • Investing activity—cash inflow (I+) or cash outflow (I-) • Financing activity—cash inflow (F+) or cash outflow (F-) • Activity that is not used to prepare the indirect statement of cash flows (N)

Preparing the statement of cash flows—indirect method The income statement of Boost Plus, Inc. follows: Gross Profit Net Sales Revenue Cost of Goods Sold Salaries Expense 137,000 94,000 3,000 56,000 \( 54,000 81,000 Depreciation Expense––Plant Assets Net Income Before Income Taxes Income Tax Expense Net Income Total Operating Expenses 27,000 \) 53,000 BOOST PLUS, INC. Income Statement Year Ended September 30, 2018 Operating Expenses: \( 231,000 Additional data follow: a. Acquisition of plant assets is \)124,000. Of this amount, \(108,000 is paid in cash and \)16,000 by signing a note payable. b. Cash receipt from sale of land totals \(20,000. There was no gain or loss. c. Cash receipts from issuance of common stock total \)36,000. d. Payment of notes payable is \(15,000. e. Payment of dividends is \)5,000. f. From the balance sheet: September 30 2018 2017 Cash \( 39,000 \) 13,000 Accounts Receivable 46,000 61,000 Merchandise Inventory 94,000 88,000 Land 82,000 102,000 Plant Assets 214,000 90,000 Accumulated Depreciation (61,000) (34,000) Accounts Payable 32,000 15,000 Accrued Liabilities 12,000 20,000 Notes Payable (long-term) 16,000 15,000 Common Stock, no par 40,000 4,000 Retained Earnings 314,000 266,000 Prepare Boost Plus’s statement of cash flows for the year ended September 30, 2018, using the indirect method. Include a separate section for non-cash investing and financing activities

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