Concept explainers
Spreadsheet and Statement The following 2019 information is available for Stewart Company:
Partial additional information:
- The equipment that was sold for cash had cost $400 and had a book value of $300.
- Land that was sold brought a cash price of $530.
- Fifty shares of stock were issued at par.
(Appendix 21.1) Operating Cash Flows Spreadsheet Method Refer to the information for Stewart Company in E21-11.
Required:
Raised only on the information presented and using the direct method, prepare the cash flows from operating activities section of the 2019 statement of cash flows for Stewart using the spreadsheet method.
Prepare operating activities section in the cash flow statement under direct method of S Company for the year 2019.
Explanation of Solution
Prepare operating activities section in the cash flow statement under direct method:
Table (1)
Table (2)
Working Note:
(a) Net income for the year ended 2019 is $1,140.
(b) Calculate the decrease in accounts receivable.
(c) Calculate an increase in inventory.
(d) Calculate the cost of land sold.
(e) Calculate the purchase of land.
Step 1: Calculate the balance amount of land after sale.
Step 2: Calculate the purchase of land.
(f) Calculate the Proceeds from Equipment.
(g) Calculate the Purchase of equipment.
Step 1: Calculate the balance amount of equipment after sales.
Step 2: Calculate the purchase of equipment.
(h) Calculate the Depreciation expense.
(i) Calculate an increase in accounts payable.
(j) Calculate the proceeds from issuance of common stock.
(k) Calculate the payment of dividend.
Step 1: Calculate the amount of retained earnings.
Step 2: Calculate the amount of dividend paid.
(I) Calculate the net increase in cash.
Table (3)
Working note 1:
Calculate the collection from customers.
Working note 2:
Calculate the payments to suppliers.
Working note 3:
Calculate the other operating payments.
Accumulated depreciation decreased by $50($200-$150) in total, caused by a $100 decreased due to the sale of equipment with a $400 cost and a $300 book value and a $50 increase due to depreciation expenses.
Therefore, the net cash provided by operating activities is $1,290.
Want to see more full solutions like this?
Chapter 21 Solutions
Intermediate Accounting: Reporting And Analysis
- Spreadsheet and Statement The following 2019 information is available for Stewart Company: Partial additional information: The equipment that was sold for cash had cost 400 and had a book value of 300. Land that was sold brought a cash price of 530. Fifty shares of stock were issued at par. Required: Making whatever additional assumptions that are necessary, 1. Prepare a spreadsheet to support a 2019 statement of cash flows for Stewart. 2. Prepare the statement of cash flows.arrow_forwardComprehensive: Balance Sheet from Statement of Cash Flows Mills Company prepared the following balance sheet at the beginning of 2019: Additional information related to the statement of cash flows: 1. The long-term bonds have a face value of 6,000 and were issued on December 31, 2019. 2. The building was purchased on December 30, 2019. 3. The land was sold at its original cost. 4. The common stock which was sold totaled 300 shares and had a par value of 10 per share. Required: Next Level Prepare a classified balance sheet for Mills as of December 31, 2019. (Hint. Review the information on the statement of cash flows and the balances in the beginning balance sheet accounts to determine the impact on the ending balance sheet accounts.)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 attached financial statements below and the additional information to prepare a Statement of Cash Flows using the indirect method. Mistletoe Inc. Statement of Financial Position As at December 31st, 2021 Assets 2021 2020 Current Cash $78,200 $39,000 FVPL Investments 110,600 54,000 Accounts receivable 144,000 72,000 Allowance for doubtful accounts (32,000) (21,000) Inventory 90,000 117,000 Total current assets $390,800 $261,000 Long-Term Assets Land $180,000 $144,000 Buildings 315,000 270,000 Equipment 264,000 185,000 Accumulated depreciation (130,000) (164,000) Total long-term assets 629,000 435,000 Total assets $1,019,800 $696,000 Liabilities and Shareholders’ Equity Current liabilities Accounts payable $45,000 $72,000 Income tax payable 32,400…arrow_forwardX vog /webapps/blackboard/execute/displaylearningUnit?course_id=_15367_18content_id=_1799353_18. Complete the following problem on an EXCEL spreadsheet. PA9.) Use the following excerpts from Yardley Company's financial information to prepare a statement of cash flows (indirect method) for the year 2018. 2018 Income Statement Balance Sheets $ 455,000 (221,500) Sales Cost of Goods Sold Operating Expenses, other than depreciation expense Depreciation Expense Gain on Sale of Plant Assets Net Income (24,000) 23,500 174,400 (o09'es) Dec. 31, 2018 Cash $321,450 39,750 Accounts Receivable Inventory Accounts Payable Accrued Liabilities 000'EE 00S'E Dec. 31, 2017 $133,500 yse) Accounts Receivable Inventory Accounts Payable Accrued Liabilities 00s'9E 000'SE 19,550 00z Additional information: Plant assets were sold for $40,000; book value $16,500 Dividends of $25,000 were declared and paid 73"F Sunnyarrow_forwardForecast the Statement of Cash Flows Following are the income statement and balance sheet for Medtronic PLC. Note: Complete the entire question using the following Excel template: Excel Template. Then enter the answers into the provided spaces below with two decimal places. Medtronic PLC Consolidated Statement of Income $ millions, For Fiscal Year Ended April 26, 2019 Net sales $30,557 Costs and expenses Cost of products sold 9,155 Research and development expense 2,330 Selling, general, and administrative expense 10,418 Amortization of intangible assets 1,764 Restructuring charges, net 198 Certain litigation charges, net 166 Other operating expense, net 258 Operating profit 6,268 Other nonoperating income, net (373) Interest expense 1,444 Income before income taxes 5,197 Income tax provision 547 Net income 4,650 Net income loss attributable to noncontrolling interests (19) Net income attributable to Medtronic $4,631 Medtronic…arrow_forward
- Preparing the statement of cash flows—direct method Boundary Rare Coins (BRC) was formed on January 1, 2018. Additional data for the year follow: On January 1, 2018, BRC issued no par common stock for $475,000. Early in January, BRC made the following cash payments: For store fixtures, $53,000 For merchandise inventory, $260,000 For rent expense on the store building, $13,000 Later in the year, BRC purchased merchandise inventory on account for $240,000. Before year-end, BRC paid $160,000 of this accounts payable. During 2018, BRC sold 2,200 units of merchandise inventory for $450 each. Before year-end, the company collected 85% of this amount The cost of goods sold for the year was $330,000, and ending merchandise inventory totaled $170,000. The store employs three people. The combined annual payroll is $80,000, of which BRC still owes $4,000 at year-end. At the end of the year, BRC paid an income tax of $24,000. There are no income taxes payable. Late in 2018, BRC paid cash…arrow_forwardPreparing the statement of cash flows—direct method Boundary Rare Coins (BRC) was formed on January 1, 2018. Additional data for the year follow: a. On January 1, 2018, BRC issued no par common stock for $475,000. b. Early in January, BRC made the following cash payments: For store fixtures, $53,000 For merchandise inventory, $260,000 For rent expense on the store building, $13,000 c. Later in the year, BRC purchased merchandise inventory on account for $240,000. Before year-end, BRC paid $160,000 of this accounts payable. d. During 2018, BRC sold 2,200 units of merchandise inventory for $450 each. Before year-end, the company collected 85% of this amount Cost of goods sold for the year was $330,000, and ending merchandise inventory totaled $170,000. e. The store employs three people. The combined annual payroll is $80,000, of which BRC still owes $4,000 at year-end. f. At the end of the year, BRC paid income tax of $24,000. There are no income taxes payable. g. Late in 2018, BRC…arrow_forwardUsing the information below, complete the operating cash flow section of the Statement of Cash Flows for Peter Ltd using direct method. Your presentation must be consistent with the requirements of AASB107. Ignore tax. Reporting date is 30 June. The balances of selected accounts of Peter Ltd at 30 June 2021 and 30 June 2022 were ($000): 2021 2022 Cash 3850 1200 Inventory 3750 4250 Accounts receivable 2800 3500 Allowance for doubtful debts 320 260 Land 5000 5000 Plant 2750 2800 Accumulated depreciation 490 450 Accounts payable 3200 3500 Rent payable 100 130 Salaries payable 120 190 Share capital 1000 1000 Sales (on credit) 7750 6550 Cost of goods sold 1250 1100 Doubtful debts expense 280 300 Rent expense 540 450 Salaries expense 800 750 Depreciation expense 260 180 Required: Peter Ltd’s operating cash flow section extracted from the Statement of Cash Flows for year ended 30 June 2022 (Direct Method)arrow_forward
- Preparing the statement of cash flows—direct methodDiversion Rare Coins (DRC) was formed on January 1, 2018. Additional data for the year follow: a. On January 1, 2018, DRC issued no par common stock for $450,000. b. Early in January, DRC made the following cash payments: For store fixtures, $46,000 For merchandise inventory, $310,000 For rent expense on a score building, $18,000 c. Later in the year, DRC purchased merchandise inventory on account for $238,000. Before year-end, DRC paid $138,000 of this accounts payable. d. During 2018, DRC sold 2,700 units of merchandise inventory for $400 each. Before year-end, the company collected 85% of this amount. Cost of goods sold or the year was $340,000, and ending merchandise inventory totaled $208,000. e. The store employs three people. The combined annual payroll is $97,000, of which DRC still owes $6,000 at year-end. f. Ac the end of the year, DRC paid income tax of $18,000. There was no income taxes payable. g. Late in 2018, DRC paid…arrow_forwardREQUIRED Use the information provided below to prepare the Cash Flow Statement for the year ended 30 June 2020. INFORMATION The information given below was extracted from the books of Siyakha Limited for the financial year ended 30 June 2020. STATEMENT OF FINANCIAL POSITION AS AT 30 JUNE: 2020 R 2019 R ASSETS Property, plant and equipment (See note to the financial statements below.) 14 826 000 13 998 000 Inventory 1 539 000 1 638 000 Accounts receivable 6 243 000 4 572 000 Bank 861 000 480 000 23 469 000 20 688 000 EQUITY AND LIABILITIES Ordinary Share Capital 9 300 000 8 220 000 Retained Income 2 031 000 1 701 000 Loan: OVS Bank 8 100 000 5 940 000 Accounts payable 3 795 000 3 549 000 Company tax payable 150 000 564 000 Dividends payable 93 000 714 000 23 469 000 20 688 000 STATEMENT OF COMPREHENSIVE INCOME FOR THE YEAR…arrow_forwardBelow is the data for Michael Ski Company . Prepare the cash flows from operating activities in the statement of cash flows using the direct method. (Do not prepare a reconciliation schedule.) David Ski Company had the following statements prepared as of December 31, 2020: Michael Ski Company Comparative Balance Sheet As of December 31 2020 2019 Cash 2,500 4,000 Account receivable 103,000 97,000 Short-term investment (Available-for-sale) 96,000 121,000 Inventories 91,000 54,000 Prepaid insurance 4,000 6,000 Ski equipment 89,000 43,000 Accumulated depr.-equipment (23,500) (18,000) Trademarks 79,000 83,000 Total asets 441,000 390,000 Account payable 92,200 75,000 income taxes payable 21,800 15,700 Wages payable 4,000 9,000 Short-term loans payable to bank 23,500 0 Long-term loans payable 75,000 125,000 Common stock, $1 par 100,000 100,000 Additional paid-in capital 20,000 20,000 Retained earnings 104,500 45,300 Total…arrow_forward
- Intermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage LearningCornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningCollege Accounting (Book Only): A Career ApproachAccountingISBN:9781337280570Author:Scott, Cathy J.Publisher:South-Western College Pub