Explanation Statement of cash flows: This statement reports all the cash transactions which are responsible for inflow and outflow of cash, and result of these transactions is reported as ending balance of cash at the end of reported period. Statement of cash flows includes the changes in cash balance due to operating, investing, and financing activities. Worksheet: A worksheet is a spreadsheet used while preparing a financial statement. It is a type of form having multiple columns and it is used in the adjustment process. The use of a worksheet is optional for any organization. A worksheet can neither be considered as a journal nor a part of the general ledger. Direct method: Under direct method, cash receipts from customers ( cash inflows ) and cash payments to suppliers ( cash outflows ) are reported under the operating activities. Prepare a spreadsheet for operating cash flows using direct method. Table (1) Prepare a statement of cash flows using direct method. Table (2) Working notes: a) Net sales for the year 2016 are $49,550. b) Interest received for the year 2016 is $790. c) Cost of goods sold for the year 2016 is $23,800. e) Other operating expenses paid during the year are $1,100. f) Payment of interest during the year is $1,715. g) Income tax paid during the year is $500. k) Calculate the changes in accounts receivable . Change in accounts receivable = Closing balance − Opening balance =$6,215 − $ 5 , 900 = $ 315 l) Calculate the change in inventories. Change in inventories = Closing balance − Opening balance =$15,530 − $ 15 , 300 = $ 230 m) Calculate the change in prepaid items. Change in prepaid items = Opening balance − closing balance =$1,400 − $ 1 , 000 Decrease in prepaid items = $ 400 n) Calculate the change in accounts payable. Change in accounts payable= Closing balance − Opening balance =$9,195 − $ 8 , 900 = $ 295 o) Calculate the change in Interest payable

Cengagenowv2, 1 Term Printed Access Card For Wahlen/jones/pagach’s Intermediate Accounting: Reporting And Analysis, 2017 Update, 2nd

2nd Edition

ISBN: 9781337912259

Author: James M. Wahlen, Jefferson P. Jones, Donald Pagach

Publisher: Cengage Learning

See similar textbooks

Videos

Question

Chapter 21, Problem 18P

To determine

Prepare a spreadsheet for operating cash flows using direct method for the year 2016.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Chapter 21, Problem 17P

Chapter 21, Problem 1C

Students have asked these similar questions

I am trying to find the accurate solution to this general accounting problem with the correct explanation.

PLEASE HELP. FILL ALL CELLS FROM LEFT TO RIGHT. Notice, the dropdowns are choosing whether its a debit or credit.

Please do part b please.

Chapter 21 Solutions

Cengagenowv2, 1 Term Printed Access Card For Wahlen/jones/pagach’s Intermediate Accounting: Reporting And Analysis, 2017 Update, 2nd

Ch. 21 - What information does the statement of cash flows...Ch. 21 - Briefly describe the three types of activities a...Ch. 21 - Thompson Company sold a piece of equipment that...Ch. 21 - Give two examples of a companys (a) cash inflows...Ch. 21 - Prob. 5GI Ch. 21 - Prob. 6GI Ch. 21 - Prob. 7GI Ch. 21 - Prob. 8GI Ch. 21 - Prob. 9GI Ch. 21 - List the three operating cash inflows that a...

Ch. 21 - Prob. 11GI Ch. 21 - Prob. 12GI Ch. 21 - Prob. 13GI Ch. 21 - Prob. 14GI Ch. 21 - Prob. 15GI Ch. 21 - Indicate how a company computes the amount of...Ch. 21 - Prob. 17GI Ch. 21 - Prob. 18GI Ch. 21 - Prob. 19GI Ch. 21 - Which of the following would be considered a cash...Ch. 21 - In a statement of cash flows (indirect method),...Ch. 21 - Prob. 3MC Ch. 21 - The retirement of long-term debt by the issuance...Ch. 21 - Prob. 5MC Ch. 21 - Prob. 6MC Ch. 21 - Prob. 7MC Ch. 21 - Prob. 8MC Ch. 21 - Which of the following need not be disclosed in a...Ch. 21 - Prob. 10MC Ch. 21 - Prob. 1RE Ch. 21 - Prob. 2RE Ch. 21 - Given the following information, convert Cardinal...Ch. 21 - Given the following information, convert Robin...Ch. 21 - In the current year, Harrisburg Corporation had...Ch. 21 - Tifton Co. had the following cash transactions...Ch. 21 - Tifton Co. had the following cash transactions...Ch. 21 - Trenton Corporation has the following items....Ch. 21 - Prob. 9RE Ch. 21 - In the current year, Harrisburg Corporation...Ch. 21 - Providence Company sold equipment for 25,000 cash....Ch. 21 - Annapolis Corporation paid 270,000 to retire bonds...Ch. 21 - Given the following information, compute Lemon...Ch. 21 - Prob. 14RE Ch. 21 - 38619-15.1-1BYL AID: 1825 | 13/07/2019 The ways by...Ch. 21 - Visual Inspection Gordon Companys accounting...Ch. 21 - Prob. 3E Ch. 21 - Prob. 4E Ch. 21 - Prob. 5E Ch. 21 - Prob. 6E Ch. 21 - Prob. 7E Ch. 21 - Prob. 8E Ch. 21 - Prob. 9E Ch. 21 - Prob. 10E Ch. 21 - Prob. 11E Ch. 21 - Fixed Asset Transactions The following is an...Ch. 21 - Prob. 13E Ch. 21 - Prob. 14E Ch. 21 - Prob. 15E Ch. 21 - Prob. 16E Ch. 21 - Prob. 17E Ch. 21 - Prob. 18E Ch. 21 - Prob. 19E Ch. 21 - Prob. 20E Ch. 21 - Prob. 21E Ch. 21 - Prob. 22E Ch. 21 - Classification of Cash Flows A company's statement...Ch. 21 - Prob. 2P Ch. 21 - Prob. 3P Ch. 21 - Prob. 4P Ch. 21 - Prob. 5P Ch. 21 - Spreadsheet and Statement of Cash Flows The...Ch. 21 - Prob. 7P Ch. 21 - Prob. 8P Ch. 21 - Prob. 9P Ch. 21 - Prob. 10P Ch. 21 - Prob. 11P Ch. 21 - Prob. 12P Ch. 21 - Prob. 13P Ch. 21 - Prob. 14P Ch. 21 - Prob. 15P Ch. 21 - Prob. 16P Ch. 21 - Prob. 17P Ch. 21 - Prob. 18P Ch. 21 - Financial Statement Interrelationships Prepare an...Ch. 21 - Statement of Cash Flows A friend of yours is...Ch. 21 - Prob. 3C Ch. 21 - Operating, Investing, and Financing Activities The...Ch. 21 - Prob. 5C Ch. 21 - Spreadsheet Method The spreadsheet method is...Ch. 21 - Prob. 7C Ch. 21 - Inflows and Outflows Alfred Engineering Company is...Ch. 21 - Ethics and Cash Flows You are the accountant for...

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions

SEE MORE QUESTIONS

Recommended textbooks for you

Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Century 21 Accounting General Journal
Accounting
ISBN:9781337680059
Author:Gilbertson
Publisher:Cengage

Intermediate Accounting: Reporting And Analysis

Accounting

ISBN:9781337788281

Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach

Publisher:Cengage Learning

Financial Accounting

Accounting

ISBN:9781305088436

Author:Carl Warren, Jim Reeve, Jonathan Duchac

Publisher:Cengage Learning

Cornerstones of Financial Accounting

Accounting

ISBN:9781337690881

Author:Jay Rich, Jeff Jones

Publisher:Cengage Learning

Principles of Accounting Volume 1

Accounting

ISBN:9781947172685

Author:OpenStax

Publisher:OpenStax College

Managerial Accounting: The Cornerstone of Busines...

Accounting

ISBN:9781337115773

Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Publisher:Cengage Learning

Century 21 Accounting General Journal

Accounting

ISBN:9781337680059

Author:Gilbertson

Publisher:Cengage

SEE MORE TEXTBOOKS

7.2 Ch 7: Notes Payable and Interest, Revenue recognition explained; Author: Accounting Prof - making it easy, The finance storyteller;https://www.youtube.com/watch?v=wMC3wCdPnRg;License: Standard YouTube License, CC-BY

Prepare a spreadsheet for operating cash flows using direct method for the year 2016.

Solution Summary: The author explains how to prepare a spreadsheet for operating cash flows using direct method for the year 2016.

Videos

Prepare a spreadsheet for operating cash flows using direct method for the year 2016.

Want to see the full answer?

Chapter 21 Solutions