Cornerstones of Financial Accounting
4th Edition
ISBN: 9781337690881
Author: Jay Rich, Jeff Jones
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 11, Problem 59PSA
Using a Spreadsheet to Prepare a Statement of
Jane Bahr, a controller of Endicott & Thurston, prepared the following balance sheets at the end of 2019 and 2018:
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.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents 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. Please show all dollar amount to thousands of dollars.
b) On another sheet, create a statement of cash flows for 2019. Do not enter any numbers directly on this sheet. All formulas should be linked directly to the source on previous worksheets.
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?
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. 1DQCh. 11 - Prob. 2DQCh. 11 - How is a statement of cash flows different from an...Ch. 11 - Prob. 4DQCh. 11 - What are the three categories into which inflows...Ch. 11 - Prob. 6DQCh. 11 - Why are direct exchanges of long-term debt for...Ch. 11 - Describe the relationship between changes in cash...Ch. 11 - What are two ways to report a companys net cash...Ch. 11 - Why are depreciation, depletion, and amortization...
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
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
- Use a spreadsheet and the following financial information from Mineola Companys financial statements to build a template that automatically calculates the net operating cash flow. It should be suitable for use in preparing the operating section of the statement of cash flows (indirect method) for the year 2018.arrow_forwardPreparing a Statement of Cash Flows Volusia Company reported the following comparative balance sheets for 2019: Required: Prepare a statement of cash flows for Volusia using the indirect method to compute net cash flow from operating activities.arrow_forwardUse the following excerpts from OpenAir Companys financial information to prepare a statement of cash flows (indirect method) for the year 2018.arrow_forward
- Using a Spreadsheet to Prepare a Statement of Cash Flows Fleet Limousine Service Inc. began operations in late March 2019. At the end of 2019, the following balance sheet was prepared for Fleet. Required: 1. Using a spreadsheet, prepare a statement of cash flows for 2019. Assume Fleet Limousine uses the indirect method. 2. CONCEPTUAL CONNECTION Discuss whether Fleet Limousine appeals to have matched the timing of inflows and outflows of cash.arrow_forwardRequirements: 1. How can the owners use the cash flow information or what can the statement of cash flows helps the owners to do? 2. Reconstruct the company’s comparative balance sheet for 2019/2020 using the above information and compute and show the missing figures to include the appropriate sign as a positive or negative figure. 3. Prepare a complete statement of cash flows for 2020 using the indirect method using the information above.arrow_forward. 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.arrow_forward
- Instructions: Using the following adjusted trial balance, complete the following for 2019: Use the Jaymie Corporation example in Chapter 3 for guidance. In the absence of other guidance, assume the circumstances for your project are similar to the example shown. 1) Income statement 2) Statement of shareholders' equity 3) Balance sheet 4) In place of completing a full statement of cash flows, review the Statement of Cash Flows within Example 3.9 in the text and advise an error (or at least a questionable treatment) of an item presented by the authors that you have discovered. Create the financial statements using Excel and submit for grading via the assignment in Blackboard. Add your answer to item 4) within the same Excel workbook clearly identified as the response to item 4).…arrow_forward2. Reconstruct the company's comparative balance sheet for 2020/2021 using the information provided and compute and show the missing figures to include the appropriate sign as positive or negative figure. 3. Prepare a complete statement of cash flows for 2021 using the indirect method using the information provided.arrow_forward2. Reconstruct the company’s comparative balance sheet for 2020/2021 using the information given and compute and show the missing figures to include the appropriate sign as a positive or negative figure. 3. Prepare a complete statement of cash flows for 2021 using the indirect method using the information givenarrow_forward
- 2. Reconstruct the company's comparative balance sheet for 2020/2021 using the information provided and compute and show the missing figures to include the appropriate sign as a positive or negative figure. 3. Prepare a complete statement of cash flows for 2021 using the indirect method.arrow_forwardRequired: a. Calculate: Cash receipts from customers. Cash payments for operating expenses. b. Prepare the operating activities section of the statement of cash flows for 2020.arrow_forwardPreparing the statement of cash flows—indirect method Accountants for Morganson, Inc. have assembled the following data for the year ended December 31, 2018: Prepare Morganson’s statement of cash flows using the indirect method. Include accompanying schedule of non-cash investing and financing activities.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
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
The KEY to Understanding Financial Statements; Author: Accounting Stuff;https://www.youtube.com/watch?v=_F6a0ddbjtI;License: Standard Youtube License