Horngren's Financial & Managerial Accounting, The Financial Chapters, Student Value Edition (5th Edition)
5th Edition
ISBN: 9780133851731
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 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.
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.
Use 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).
Chapter 14 Solutions
Horngren's Financial & Managerial Accounting, The Financial Chapters, Student Value Edition (5th Edition)
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
- 2. 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_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_forwardPrepare 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_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_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
- Prepare the company's statement of cash flows indirect method for the year ended December 31, 2024. Assume investments are purchased with cash. (Use a minus sign or parentheses for amounts that result in a decrease in cash. It a box is not used in the statement leave the box empty; do not select a label or enter a zero.) More info Superior calculated the following amounts for 2024: • Acquisition value of plant assets, $89,000. • Payment of dividends, $102,000. • Payment of long-term notes payable, $3,000. • Cash receipt from issuance of common stock. $15.000. Superior Exercise disposed of plant assets at book value. The cost and accumulated depreciation of the disposed asset was $43 500. No cash was received upon disposalarrow_forwardPreparing the statement of cash flows—indirect method with non-cash transactions The 2018 income statement and comparative balance sheet of Sweet Valley Inc follow: Additionally, Sweet Valley purchased land of $20,900 by financing it 100% with long-term notes payable during 2018. During the year, there were no sales of land, no retirements of stock, and no treasury stock transactions. A plant asset was disposed of for $0. The cost and the accumulated depreciation of the disposed asset was $13,240. Plant asset was acquired for cash. Requirements Prepare the 2018 statement of cash flows, formatting operating activities by the indirect method. How will what you learned in this problem help you evaluate an investment?arrow_forwardCleopatra's Boutique Inc reported net income of $73,000 for 2022. Included in the income statement were depreciation expense of $7,000 and again on disposal of plant assets of $2,500 Cleopatra's comparative balance sheets whos the following bainaces 12/01/21 12/31/22 Accounts receivable $17,000 $21.000 Accounts payable 6,000 2.200 Calculate net cash provided by operating activities for Cleopatra's Boutique, incarrow_forward
- Cemptex Corporation prepares its statement of cash flows using the indirect method to report operating activities. Net income for the 2016 fiscal year was $624,000. Depreciation and amortization expense of $87,000 was included with operating expenses in the income statement. The following information describes the changes in current assets and liabilities other than cash: Required: Prepare the operating activities section of the 2016 statement of cash flows.arrow_forwardUsing the financial statements and additional information below, prepare a cash flow statement for Papa Ltd for the year ended 31st December 2018 using the indirect method of calculating operating cash flow and write a brief comment on the cash flow for the period. Papa Ltd Statement of Profit or Loss Account for the year ended 31st December 2018 GHC Revenue 540,000 Cost of sales (155,000) Gross profit 385,000 Investment income – interest received 15,000 Loss on disposal of equipment (18,000) Depreciation (94,000) Administrative and selling expenses (25,000) Operating profit before interest 263,000 Interest expense (10,000) Profit before taxation 253,000 Taxation (56,000) Profit after tax 197,000 Statement of financial position as at 31st December 2018 2017 GHC GHC Non-current assets Vehicle at cost 180,000 150,000 Accumulated depreciation (137,000)…arrow_forwardOn its January 1, 2016, balance sheet, Calvin Company reported equipment of $60,000 and accumulated depreciation of $20,000. During 2016, Calvin sold equipment with an original cost of $5,000. Selected information from Calvin's 2016 statement of cash flows follows: Net income $20,000 Depreciation expense on equipment 2,000 Gain on sale of equipment 600 Proceeds from sale of equipment 1,500 Purchase of equipment 18,000 Required:Compute the amount of equipment and accumulated depreciation that should appear on Calvin's December 31, 2016, balance sheet.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning
Financial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage Learning
Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher: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:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
The KEY to Understanding Financial Statements; Author: Accounting Stuff;https://www.youtube.com/watch?v=_F6a0ddbjtI;License: Standard Youtube License