Horngren's Financial & Managerial Accounting, The Financial Chapters (Book & Access Card)
5th Edition
ISBN: 9780134078939
Author: Tracie L. Miller-Nobles, Brenda L. Mattison, Ella Mae Matsumura
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 14, Problem 14.45BP
Using a spreadsheet to prepare the statement of
The 2016 comparative
Prepare the spreadsheet for the 2016 statement of cash flows. Format cash flows from operating activities by the indirect method. A plant asset was disposed of for $0. The cost and
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Using a spreadsheet to prepare the statement of cash flows—indirect method
The 2018 comparative balance sheet and income statement of Attleboro Group, Inc. follow. Attleboro disposed of a plant asset at book value in 2018.
Prepare the spreadsheet for the 2018 statement of cash flows. Format cash flows from operating activities by the indirect method. A plant asset was disposed of for $0. The cost and accumulated depreciation of the disposed asset was $13,600. There were no sales of land, no retirement of common stock, and no treasury stock transactions. Assume plant asset and land acquisitions were for cash.
Using a spreadsheet to prepare the statement of cash flows—indirect method
The 2018 comparative balance sheet and income statement of Appleton Group, Inc. follow. Appleton disposed of a plant asset at book value during 2018.
Prepare the spreadsheet for the 2018 statement of cash flows. Format cash flows from operating activities by the indirect method. A plant asset was disposed of for $0. The cost and accumulated depredation of the disposed asset was $11,600. There were no sales of land, no retirement of common stock, and no treasury stock transactions. Assume plant asset and land acquisitions were for cash.
What amount was reported on the statement of cash flows as “cash flow from sale of equipment? Blue Spruce Corp.’s income statement reported a loss on the disposal of plant assets of $4,589.
Chapter 14 Solutions
Horngren's Financial & Managerial Accounting, The Financial Chapters (Book & Access Card)
Ch. 14 - The purposes of the statement of cash flows are to...Ch. 14 - The main categories of cash flow activities are a....Ch. 14 - Operating activities are most closely related to...Ch. 14 - Which item does not appear on a statement of cash...Ch. 14 - Leather Shop earned net income of 57,000 after...Ch. 14 - The Plant Assets account and Accumulated...Ch. 14 - Mountain Water Corp. issued common stock of 28,000...Ch. 14 - Prob. 8QCCh. 14 - Prob. 9AQCCh. 14 - If accrued liabilities increased during the year,...
Ch. 14 - Prob. 1RQCh. 14 - How does the statement of cash flows help users of...Ch. 14 - Describe the three basic types of cash flow...Ch. 14 - What types of transactions are reported in the...Ch. 14 - Prob. 5RQCh. 14 - Prob. 6RQCh. 14 - Explain why depreciation expense, depletion...Ch. 14 - Prob. 8RQCh. 14 - If current assets other than cash increase, what...Ch. 14 - If current liabilities increase, what is the...Ch. 14 - Prob. 11RQCh. 14 - Prob. 12RQCh. 14 - Prob. 13RQCh. 14 - Prob. 14RQCh. 14 - Prob. 15ARQCh. 14 - Prob. 16BRQCh. 14 - Describing the purposes of the statement of cash...Ch. 14 - Prob. 14.2SECh. 14 - Classifying items on the indirect statement of...Ch. 14 - Computing cash flows from operating...Ch. 14 - Prob. 14.5SECh. 14 - Prob. 14.6SECh. 14 - Prob. 14.7SECh. 14 - Prob. 14.8SECh. 14 - Prob. 14.9SECh. 14 - Prob. 14.10SECh. 14 - Preparing a statement of cash flows using the...Ch. 14 - Prob. 14.12SECh. 14 - Preparing the direct method statement of cash...Ch. 14 - Prob. 14.14SECh. 14 - Prob. 14.15SECh. 14 - Classifying cash flow items Consider the following...Ch. 14 - Prob. 14.17ECh. 14 - Prob. 14.18ECh. 14 - Prob. 14.19ECh. 14 - Prob. 14.20ECh. 14 - Prob. 14.21ECh. 14 - Prob. 14.22ECh. 14 - Prob. 14.23ECh. 14 - Prob. 14.24ECh. 14 - Prob. 14.25ECh. 14 - Prob. 14.26ECh. 14 - Prob. 14.27ECh. 14 - Prob. 14.28ECh. 14 - Prob. 14.29ECh. 14 - Prob. 14.30ECh. 14 - Using a spreadsheet to prepare the statement of...Ch. 14 - Prob. 14.32APCh. 14 - Prob. 14.33APCh. 14 - Prob. 14.34APCh. 14 - Prob. 14.35APCh. 14 - Preparing the statement of cash flows----direct...Ch. 14 - Prob. 14.37APCh. 14 - Prob. 14.38APCh. 14 - Prob. 14.39BPCh. 14 - Prob. 14.40BPCh. 14 - Prob. 14.41BPCh. 14 - Prob. 14.42BPCh. 14 - Prob. 14.43BPCh. 14 - Prob. 14.44BPCh. 14 - Using a spreadsheet to prepare the statement of...Ch. 14 - Prob. 14.46CPCh. 14 - Prob. 14.1CTDCCh. 14 - Moss Exports is having a bad year. Net income is...Ch. 14 - Details about a company's cash flows appear in a...
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 the information provided below to prepare the Cash Flow Statement of Chelsea Limited for the year ended 31 December 2021 using the answer template provided (see images) Additional information: (See images)¦ Selling and administrative expenses include depreciation as follows:Depreciation on buildings R96 000Depreciation on plant and machinery R160 000¦ There were purchases but no disposals of property, plant and equipment for the financial year ended 31 December2021.¦ Total dividends for the year ended 31 December 2021 and 31 December 2020 amounted toR288 000 and R388 000 respectively.¦ Inventories on 31 December 2019 amounted to R560 000.¦ All purchases and sales of inventories were on credit.¦ The number of shares in issue was 400 000.¦ Credit terms from creditors are 90 days.arrow_forward2. Use the following excerpts from Fromera Company's financial information to prepare the operating section of the statement of cash flows (indirect method) for the year 2018. https://opentextbc.ca 2018 Financial Statement 299,000 135,000 Sales Cost of goods sold Operating expenses, other than depreciation expense Depreciation expense Gain on sale of plant assets 27,000 17,000 16,500 136,500 Net Income Dec. 31, 2017 43,400 1,800 21,250 1,150 Dec. 31, 2018 45,300 1,600 22,500 900 Accounts receivable Inventory Accounts payable Accrued liabilities 3. Using the data in No. 2, compute the following: a. Current cash debt coverage ratio b. Free Cash Flowarrow_forwardCalculate the net cash flow from operating activities using the indirect method.arrow_forward
- Prepare the spreadsheet for the 2024 statement of cash flows. Format cash flows from operating activities by the indirect method. A plant asset was disposed of for $0. The cost of accumulated depreciation of the disposed as it was $12,600. There were no sales of land no retirement of common stock and no treasury stock transactions. Assume plant assets and land acquisitions were for cash. arrow_forwardUse the following information from Dubuque Company's financial statements to prepare the operating activities section of the statement of cash flows (indirect method) for the year 2018: 2018 Income Statement Balance Sheets Sales Cost of Goods Sold Operating Expenses, other than depreciation expense Depreciation Expense Gain on Sale of Plant Assets $ 299,000 (135,000) (27,000) (17,000) 16,500 136,500 Net Income Dec. 31, 2018 $45,300 1,600 22,500 900 Accounts Receivable Inventory Accounts Payable Accrued Liabilities Accounts Receivable Inventory Accounts Payable Accrued Liabilities Dec. 31, 2017 $43,400 1,800 21,250 1,150 PLEASE NOTE: Use the account and term names exactly, as shown above and the accounts will be listed in the same order as shown in the textbook examples. All dollar amounts will be rounded to whole dollars using "$" and commas as needed (i.e. $12,345) and decreases will be shown with parentheses - $(12,345).arrow_forwardof Take me to the text Squash Incorporated had net income for 2023 of $382,000. Included on the income statement was a loss on sale of equipment of $4,900, a gain on sale of investments of $16,300, depreciation of $7,300, loss on retirement of debt of $10,600, and interest of $3,200. Calculate the net cash provided (used) by operating activities using the indirect method Assume that the balances of current assets (except cash) and current liabilities remain the same as last year. Do not enter dollar signs or commas in the input boxes. Use the negative sign for a decrease in cash. Net cash provided (used) by operating activities $-385400 Check *arrow_forward
- Using the Exhibit below, assume that the depreciation expense on the Income Statement for the year was $38,000. When preparing the Statement of Cash Flow using the indirect method for the current year, which of the following statements would describe the proper presentation of depreciation expense on the Cash flow from operating activities section? EXHIBIT Increase (Decrease) Net Income (loss) $XXX Adjustments to reconcile net income to net cash flow from operating activities: Depreciation of fixed assets XXX Losses on disposal of assets XXX Gains on disposal of assets (XXX) Changes in current operating assets and liabilities:…arrow_forwardREQUIRED Study the statement of cash flows of Mantis Limited for the year ended 31 December 2021 and answer the following questions: Calculate the following for the year ended 31 December 2021: Depreciation Dividends paid Of what significance is this statement of cash flows to the shareholders of Mantis Limited? Comment on the following: Cash flows from operating activities (R181 800) 1.3.2. Increase in inventory (R808 000) Increase in receivables (R606 000) Interest paid (R80 800) Cash flows from investing activities (R2 343 200) INFORMATION MANTIS LIMITED STATEMENT OF CASH FLOWS FOR THE YEAR ENDED 31 DECEMBER 2021 R Cash flows from operating activities (181 800) Operating profit 979 700 Depreciation ? Profit before working capital changes ? Working capital changes (808 000) Increase in inventory (808 000) Increase in receivables…arrow_forwardit is about constructing cash flow statement using indirect method, how is it get the 45? And please explain the calculation.arrow_forward
- Use the following excerpts from Company's financial information to prepare the operating section of the statement of cash flows (indirect method) for the year 2018.arrow_forwardcash flow for years 2011,2012 Calculate year to year changes (comparative) in amount and percentages on the excel file. Comment on the comparative analysis (year to year) considering material changes over time. please do not provide solution in image format thank you!arrow_forwardThe net income for Adcock Co. for 2011 was $280000. For 2011, depreciation on plant asset was $70000, and the company incurred a loss on sale of plant asset of $12000. Compute net cash provided by operating activities under the indirect method?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Financial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage Learning
Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT
Financial Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT
The KEY to Understanding Financial Statements; Author: Accounting Stuff;https://www.youtube.com/watch?v=_F6a0ddbjtI;License: Standard Youtube License