Intermediate Accounting: Reporting And Analysis
3rd Edition
ISBN: 9781337788281
Author: James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 21, Problem 13GI
To determine
Explain the spreadsheet method in analyzing the information for a company’s statement of
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
What is the purpose of the “changes” columns of a spreadsheet to prepare a statement of cash flows?
A company uses a spreadsheet to prepare its statement of cash flows. Indicate whether each of the followingitems would be recorded in the Debit column or Credit column of the spreadsheet’s statement of cashflows section. Net income
Why might a spreadsheet be helpful when completing the statement of cash flows?
Chapter 21 Solutions
Intermediate Accounting: Reporting And Analysis
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. 5GICh. 21 - Prob. 6GICh. 21 - Prob. 7GICh. 21 - Prob. 8GICh. 21 - Prob. 9GICh. 21 - List the three operating cash inflows that a...
Ch. 21 - Prob. 11GICh. 21 - Prob. 12GICh. 21 - Prob. 13GICh. 21 - Dunn Company recognized a 5,000 unrealized holding...Ch. 21 - Jordan Company recognized a 5,000 unrealized...Ch. 21 - Indicate how a company computes the amount of...Ch. 21 - Prob. 17GICh. 21 - Prob. 18GICh. 21 - Prob. 19GICh. 21 - Which of the following would be considered a cash...Ch. 21 - In a statement of cash flows (indirect method),...Ch. 21 - The net cash provided by operating activities in...Ch. 21 - The retirement of long-term debt by the issuance...Ch. 21 - Prob. 5MCCh. 21 - Selected information from Brook Corporations...Ch. 21 - Prob. 7MCCh. 21 - Prob. 8MCCh. 21 - Which of the following need not be disclosed in a...Ch. 21 - The following information was taken from Oregon...Ch. 21 - Prob. 1RECh. 21 - Prob. 2RECh. 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. 9RECh. 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. 14RECh. 21 - Prob. 1ECh. 21 - Prob. 2ECh. 21 - Visual Inspection Noble Companys accounting...Ch. 21 - Prob. 4ECh. 21 - Prob. 5ECh. 21 - Prob. 6ECh. 21 - Prob. 7ECh. 21 - Prob. 8ECh. 21 - Partially Completed Spreadsheet Hanks Company has...Ch. 21 - Spreadsheet The following 2019 information is...Ch. 21 - Spreadsheet and Statement The following 2019...Ch. 21 - Fixed Asset Transactions The following is an...Ch. 21 - Retirement of Debt Moore Company is preparing its...Ch. 21 - Interest and Income Taxes Staggs Company has...Ch. 21 - Investments On October 4, 2019, Collins Company...Ch. 21 - Statement of Cash Flows The following is a list of...Ch. 21 - Investing Activities and Depreciable Assets...Ch. 21 - Spreadsheet and Statement The following 2019...Ch. 21 - (Appendix 21.1) Operating Cash Flows The following...Ch. 21 - (Appendix 21.1) Statement of Cash Flows The...Ch. 21 - (Appendix 21.1) Visual Inspection The following...Ch. 21 - Prob. 22ECh. 21 - Classification of Cash Flows A company's statement...Ch. 21 - Prob. 2PCh. 21 - Statement of Cash Flows The following is a list of...Ch. 21 - Statement of Cash Flows The following is a list of...Ch. 21 - Partially Completed Spreadsheet The following...Ch. 21 - Spreadsheet and Statement of Cash Flows The...Ch. 21 - Prob. 7PCh. 21 - Spreadsheet from Trial Balance Heinz Companys post...Ch. 21 - Prepare Ending Balance Sheet On December 31, 2019,...Ch. 21 - Infrequent Transactions The following transactions...Ch. 21 - Prob. 11PCh. 21 - Comprehensive Angel Company has prepared its...Ch. 21 - Comprehensive The following are Farrell...Ch. 21 - (Appendix 21.1) Operating Cash Flows Refer to the...Ch. 21 - (Appendix 21.1) Statement of Cash Flows The...Ch. 21 - Comprehensive The following are Farrell...Ch. 21 - (Appendix 21.1) Comprehensive The following are...Ch. 21 - Prob. 18PCh. 21 - Financial Statement Interrelationships Prepare an...Ch. 21 - Statement of Cash Flows A friend of yours is...Ch. 21 - Prob. 3CCh. 21 - Operating, Investing, and Financing Activities The...Ch. 21 - Prob. 5CCh. 21 - Spreadsheet Method The spreadsheet method is...Ch. 21 - Prob. 7CCh. 21 - Inflows and Outflows Alfred Engineering Company is...Ch. 21 - Ethics and Cash Flows You are the accountant for...
Knowledge Booster
Similar questions
- A company uses a spreadsheet to prepare its statement of cash flows. Indicate whether each of the followingitems would be recorded in the Debit column or Credit column of the spreadsheet’s statement of cashflows section. Payment of cash dividendsarrow_forwardWhich of the following statements concerning the entries made on the spreadsheet used to prepare the statement of cash flows is true? a.The entries are not posted to the ledger. b.The entries are used in preparing the data on the spreadsheet. c.The entries are used in summarizing the data on the spreadsheet. d.All of these choices are correct.arrow_forwardExplain how a worksheet may be helpful in preparing a statement of cash flows.arrow_forward
- What are the steps necessary to create a statement of cash flows in quickbooks.arrow_forwardA company uses a spreadsheet to prepare its statement of cash flows. Indicate whether each of the followingitems would be recorded in the Debit column or Credit column of the spreadsheet’s statement of cashflows section. Increase in accounts receivablearrow_forwardArticulation of the Statement of Cash Flows with Other Financial Statements. Describe how the statement of cash flows is linked to each of the other financial statements (income statement and balance sheet). Also, review how the other financial statements are linked with each other. Please explain without copying from another source.arrow_forward
- When using the Spreadsheet (work sheet) method to analyze noncash accounts, it is best to start with Group of answer choices cash net income retained earnings revenuearrow_forwardSpecify every aspect of the link between the income statement, the balance sheet, and the cash flow statement.arrow_forwardPlease explain how to prepare a statement of cash flows (indirect method) including analyzing tables? Please provide an example. Thank you,arrow_forward
- What advantage do you see in compiling financial data into standardized statements like the Income Statement, Statement of Cash Flows and the Balance Sheet?arrow_forwardI have attached the screenshot of the question. Apply Financial Statement Linkages to Understand TransactionsConsider the effects of the independent transactions, a through g, on a company’s balance sheet, income statement, and statement of cash flow. Complete the table below to explain the effects and financial statement linkages. Use “+” to indicate the account increases and “−” to indicate the account decreases. Refer to Exhibit 2-10 as a guide for the linkages a b c d e f g Balance Sheet Cash Noncash assets 355030 Total liabilities 241272 Contributed capital 35867 Retained earnings Other equity Statement of Cash Flows Operating cash flow Investing cash flow Financing cash flow Income Statement Revenues…arrow_forwardHow would I input the formulas into excel to get those numbers for the statement of cash flowsarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningIntermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning