Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
4th Edition
ISBN: 9781337690881
Author: Jay Rich, Jeff Jones
Publisher: Cengage Learning
bartleby

Concept explainers

bartleby

Videos

Textbook Question
Book Icon
Chapter 11, Problem 59PSA

Using a Spreadsheet to Prepare a Statement of Cash Flows

Jane Bahr, a controller of Endicott & Thurston, prepared the following balance sheets at the end of 2019 and 2018:

Chapter 11, Problem 59PSA, Using a Spreadsheet to Prepare a Statement of Cash Flows Jane Bahr, a controller of Endicott &

Required:

1. Using a spreadsheet, prepare a statement of cash flows for 2019. Assume Endicott & Thurston use the indirect method.

2. CONCEPTUAL CONNECTEON Discuss whether Endicott & Thurston appear to have matched the timing of inflows and outflows of cash.

Blurred answer
Students have asked these similar questions
a. Recreate the income statement and balance sheet using formulas wherever possible. Each statement should be on a separate worksheet. Try to duplicate the formatting exactly. b. On another worksheet, create a statement of cash flows for 2020. Do not enter any numbers directly on this worksheet. All formulas should be linked directly to the source on previous worksheets. C. Using Excel's outlining feature, create an outline on the statement of cash flows that, when collapsed, shows only the subtotals for each section. d. Suppose that sales were $425,000 in 2020 rather than $412,500. What is the 2020 net income and retained earnings? e. Undo the changes from part d, and change the tax rate to 20%. What is the 2020 net income and retained earnings?
. ABC company had the following transactions during the month of April 2020. They would like you, their accountant, to prepare a cash flow statement. Before preparing the statement, you first need to determine whether the items below results in a cash inflow or outflow in the statement of cash flows. Second, you are required to determine whether the transaction is an operating, investing, or financing activity by placing an √ in the appropriate columns.
Reconstruct the company’s comparative balance sheet for 2020/2021 using the information in line with your first name initial and compute and show the missing figures to include the appropriate sign as a positive or negative figure. Prepare a complete statement of cash flows for 2021 using the indirect method using the information in line with your first name initial

Chapter 11 Solutions

Cornerstones of Financial Accounting

Ch. 11 - Prob. 11DQCh. 11 - Prob. 12DQCh. 11 - What does an increase in inventory imply? How...Ch. 11 - Prob. 14DQCh. 11 - Prob. 15DQCh. 11 - Prob. 16DQCh. 11 - Prob. 17DQCh. 11 - What balance sheet account changes might you...Ch. 11 - Prob. 19DQCh. 11 - Prob. 20DQCh. 11 - Prob. 21DQCh. 11 - Prob. 22DQCh. 11 - Prob. 23DQCh. 11 - Prob. 24DQCh. 11 - Which of the following is not a use of the...Ch. 11 - Which of the following would be classified as a...Ch. 11 - Prob. 3MCQCh. 11 - Which of the following is an example of a cash...Ch. 11 - Prob. 5MCQCh. 11 - Which of the following statements is true? a. Net...Ch. 11 - Mullinix Inc. reported the following information:...Ch. 11 - Which item is added to net income when computing...Ch. 11 - Refer to the information for Cornett Company...Ch. 11 - Prob. 10MCQCh. 11 - Chasse Building Supply Inc. reported net cash...Ch. 11 - Smoltz Company reported the following information...Ch. 11 - Prob. 13MCQCh. 11 - Classification of Cash Flows Stanfield Inc....Ch. 11 - Classification of Cash Flows Patel Company...Ch. 11 - Prob. 16CECh. 11 - Analyzing Changes in Balance Sheet Accounts Refer...Ch. 11 - Prob. 18CECh. 11 - Prob. 19CECh. 11 - Determining Net Cash Flow from Investing...Ch. 11 - Prob. 21CECh. 11 - Prob. 22CECh. 11 - Cash Receipts from Customers Singleton Inc. had...Ch. 11 - Prob. 24CECh. 11 - Prob. 25CECh. 11 - Prob. 26BECh. 11 - Prob. 27BECh. 11 - Analyzing Balance Sheet Accounts A review of the...Ch. 11 - Prob. 29BECh. 11 - Prob. 30BECh. 11 - Prob. 31BECh. 11 - Prob. 32BECh. 11 - Prob. 33BECh. 11 - Classification of Cash Flows A review of the...Ch. 11 - Classification of Cash Flows The following are...Ch. 11 - Analyzing Changes in Balance Sheet Accounts A...Ch. 11 - Analyzing the Accounts Casey Company uses a...Ch. 11 - Analyzing the Accounts The controller for Summit...Ch. 11 - Reporting Net Cash Flow from Operating Activities...Ch. 11 - Prob. 40ECh. 11 - Determining Cash Flows from Investing Activities...Ch. 11 - Determining Cash Flows 1from Investing Activities...Ch. 11 - Determining Cash Flows from Financing Activities...Ch. 11 - Prob. 44ECh. 11 - Partial Statement of Cash Flows Service Company...Ch. 11 - Prob. 46ECh. 11 - Prob. 47ECh. 11 - Preparing Net Cash Flows from Operating...Ch. 11 - Preparing a Statement of Cash Flows-Direct Method...Ch. 11 - Preparing a Statement of Cash Flows-Direct Method...Ch. 11 - Prob. 51ECh. 11 - Prob. 52PSACh. 11 - Prob. 53PSACh. 11 - Classification of Cash Flows Rolling Meadows...Ch. 11 - Prob. 55PSACh. 11 - Preparing a Statement of Cash Flows Monon Cable...Ch. 11 - Prob. 57PSACh. 11 - Preparing Net Cash Flows from Operating...Ch. 11 - Using a Spreadsheet to Prepare a Statement of Cash...Ch. 11 - Prob. 52PSBCh. 11 - Prob. 53PSBCh. 11 - Prob. 54PSBCh. 11 - Preparing a Statement of Cash Flows Volusia...Ch. 11 - Prob. 56PSBCh. 11 - Prob. 57PSBCh. 11 - Prob. 58PSBCh. 11 - Using a Spreadsheet to Prepare a Statement of Cash...Ch. 11 - Prob. 60.1CCh. 11 - Prob. 60.2CCh. 11 - Prob. 60.3CCh. 11 - Prob. 61.1CCh. 11 - Profitability Declines and the Statement of Cash...Ch. 11 - Prob. 61.3CCh. 11 - Prob. 61.4CCh. 11 - Prob. 62.1CCh. 11 - Prob. 62.2CCh. 11 - Prob. 62.3CCh. 11 - Income, Cash Flow, and Future Losses On January L...Ch. 11 - Income, Cash Flow, and Future Losses On January L...Ch. 11 - Income, Cash Flow, and Future Losses On January L...Ch. 11 - Prob. 63.4CCh. 11 - Researching Accounting Standards: Dissenting Views...Ch. 11 - Prob. 64.2CCh. 11 - Prob. 65.1CCh. 11 - Prob. 65.2CCh. 11 - Prob. 65.3CCh. 11 - Prob. 65.4CCh. 11 - Prob. 65.5CCh. 11 - Prob. 65.6CCh. 11 - Prob. 65.7CCh. 11 - Prob. 65.8CCh. 11 - Prob. 66.1CCh. 11 - Prob. 66.2CCh. 11 - Prob. 66.3CCh. 11 - Prob. 66.4CCh. 11 - Comparative Analysis: Under Armour, Inc., versus...Ch. 11 - Prob. 67.1CCh. 11 - CONTINUING PROBLEM: FRONT ROW ENTERTAINMENT The...
Knowledge Booster
Background pattern image
Accounting
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
Text book image
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Text book image
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
Text book image
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Text book image
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
Text book image
International Financial Management
Finance
ISBN:9780357130698
Author:Madura
Publisher:Cengage
Text book image
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
The KEY to Understanding Financial Statements; Author: Accounting Stuff;https://www.youtube.com/watch?v=_F6a0ddbjtI;License: Standard Youtube License