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
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?
. 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. 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_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_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_forward
- Use the following excerpts from OpenAir Companys financial information to prepare a statement of cash flows (indirect method) for the year 2018.arrow_forwardInstructions: 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_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
- Required:(a) Prepare Vanguard low Statement for the year ended 31 December 2019 with the following classifications using the direct method: (i) Cash flows from operations;(ii) Cash flows from investing activities;(iii) Cash flows from financing activities. (b) Discuss the importance of analysing the cash flow statement. (c) Explain why it is possible to have a negative cash flow from operations but a positive net income. Give an example of such a scenario.arrow_forwardPlease answer correct ,, and provide answer in text formarrow_forwardPrepare the following financial reports for the month of January 2020: a) Income Statement b) Balance Sheet c) Statement of Financial Position d) Statement of Cash Flows See the tabulation table.arrow_forward
- Hought Office Machines, Inc.'s accountants assembled the following selected data for the year ended December 31, 2018: E (Click the icon to view the current accounts.) E (Click the icon to view the transaction data.) Requirement 1. Prepare Hought Office Machines, Inc.'s statement of cash flows using the indirect method to report operating activities. List noncash investing and financing activities on an accompanying schedule. Complete the statement one section at a time, beginning with the cash flows from operating activities. (Use parentheses or a minus sign for numbers to be subtracted.) Hought Office Machines, Inc. Data Table Statement of Cash Flows Year Ended December 31, 2018 Cash flows from operating activities: Transaction Data for 2018: Net income Net income..... $ 60,000 Adjustments to reconcile net income to net cash Purchase of treasury stock. 14,300 provided by (used for) operating activities: Issuance of common stock for cash. 36,600 Loss on sale of equipment. 6,000…arrow_forwardThe income statement and additional data of Newbury Travel Products, Inc., follow: (Click the icon to view the income statement.) (Click the icon to view the additional data.) Requirements 1. Prepare Newbury's statement of cash flows for the year ended December 31, 2021, using the indirect method. 2. Evaluate the company's cash flows for the year. In your evaluation, mention all three categories of cash flows and give the rationale for your evaluation. Data table Newbury Travel Products, Inc. Income Statement Year Ended December 31, 2021 Revenues: Service revenue $ 238,000 Dividend revenue 8,600 $ 246,600 Expenses: Cost of goods sold 97,000 Salary expense 61,000 Depreciation expense 21,000 Advertising expense 3,000 Interest expense 2,100 12,000 196,100 Income tax expense ge $ 50,500 Net income - Xarrow_forwardRequire: • Cash Flow (should follow the given format)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
Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning
Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
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