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
Videos
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 solution
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?
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.
Requirements:
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.
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_forwardUsing 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_forward
- Use the following excerpts from OpenAir Companys financial information to prepare a statement of cash flows (indirect method) for the year 2018.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_forwardReconstruct 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 initialarrow_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 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_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_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_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_forwardPlease donot provide solution in image format and provide solution in step by step format and fast solution. You have the following data available for Al Maha Company, which is the income statement at the end of 2022and the statement of financial position (balance sheet) at the end of 2021 and 2022. You are required to:1- Preparing a statement of retained earnings at the end of 20222- A list of cash inflows and outflows at the end of 20223 - A statement of cash flows according to operating, investment and financing activity at the end of 20224 - Free Cash Flow Calculation (from Assets) Free cash flow = operating cash flow - change in net fixed assets - change in net working capital (current assets - current liabilities) Balance sheet at the end of 2021 and 2022 2022 2021 Cash 24000 21000 Receivables 45000 39000 Inventory 30000 27000 Net Fixed Assets = Total - Accumulated Depreciation = (40,000 - 18,000 =) 2021 20000 22000 ( 42000 - 22000 = ) 2022 Total assets…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 Learning
Principles 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