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
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
INTERM.ACCT.:REPORTING...-CENGAGENOWV2
- 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_forwardPartially Completed Spreadsheet Hanks Company has prepared the following changes in account balances for the spreadsheet to support its 2019 statement of cash flows: Additional information: The net income was 1,300. Depreciation expense was 350, and patent amortization expense was 100. At the end of 2019, long-term investments were purchased at a cost of 1,550. Land that cost 700 was sold for 900. On December 31, 2019, bonds payable with a face value of 2,000 were issued for equipment valued at 2,300. Two hundred shares of common stock were issued at 7 per share. Forty shares of common stock were issued as a small stock dividend, the relevant market price being 5 per share. Cash dividends declared and paid totaled 600. Required: On the basis of the preceding information, complete the spreadsheet.arrow_forward
- Selected information from Brook Corporations accounting records and financial statements for 2019 follows: On the statement of cash flows for the year ended December 31, 2019, Brook should disclose a net increase in cash in the amount of: a. 1,700,000 b. 2,400,000 c. 3,700,000 d. 4,200,000arrow_forwardJordan Company recognized a 5,000 unrealized holding gain on investment in Starbuckss common stock during 2019. The company classified as equity investments. How would this information be reported in a statement of cash flows prepared using the indirect method?arrow_forwardComprehensive The following are Farrell Corporations balance sheets as of December 31, 2019, and 2018, and the statement of income and retained earnings for the year ended December 31, 2019: Additional information: a. On January 2, 2019, Farrell sold equipment costing 45,000, with a book value of 24,000, for 19,000 cash. b. On April 2, 2019, Farrell issued 1, 000 shares of common stock for 23,000 cash. c. On May 14, 2019, Farrell sold all of its treasury stock for 25,000 cash. d. On June 1, 2019, Farrell paid 50, 000 to retire bonds with a face value (and book value) of 50, 000. e. On July 2, 2019, Farrell purchased equipment for 63, 000 cash. f. On December 31, 2019, land with a fair market value of 150,000 was purchased through the issuance of a long-term note in the amount of 150,000. The note bears interest at the rate of 15% and is due on December 31, 2021. g. Deferred taxes payable represent temporary differences relating to the use of accelerated depreciation methods for income tax reporting and the straight-line method for financial statement reporting. Required: 1. Prepare a spreadsheet to support a statement of cash flows for Farrell for the year ended December 31, 2019, based on the preceding information. 2. Prepare the statement of cash flows. (Appendix 21.1) Spreadsheet and Statement Refer to the information for Farrell Corporation in P21-13. Required: 1. Using the direct method for operating cash flows, prepare a spreadsheet to support a 2019 statement of cash flows. (Hint: Combine the income statement and December 31, 2019, balance sheet items for the adjusted trial balance. Use a retained earnings balance of 291,000 in this adjusted trial balance.) 2. Prepare the statement of cash flows. (A separate schedule reconciling net income to cash provided by operating activities is not necessary.)arrow_forward
- Comprehensive The following are Farrell Corporations balance sheets as of December 31, 2019, and 2018, and the statement of income and retained earnings for the year ended December 31, 2019: Additional information: a. On January 2, 2019, Farrell sold equipment costing 45,000, with a book value of 24,000, for 19,000 cash. b. On April 2, 2019, Farrell issued 1,000 shares of common stock for 23,000 cash. c. On May 14, 2019, Farrell sold all of its treasury stock for 25,000 cash. d. On June 1, 2019, Farrell paid 50,000 to retire bonds with a face value (and book value) of 50,000. e. On July 2, 2019, Farrell purchased equipment for 63,000 cash. f. On December 31, 2019. land with a fair market value of 150,000 was purchased through the issuance of a long-term note in the amount of 150,000. The note bears interest at the rate of 15% and is due on December 31, 2021. g. Deferred taxes payable represent temporary differences relating to the use of accelerated depreciation methods for income tax reporting and the straight-line method for financial statement reporting. Required: 1. Prepare a spreadsheet to support a statement of cash flows for Farrell for the year ended December 31, 2019, based on the preceding information. 2. Prepare the statement of cash flows.arrow_forwardEXPANDED STATEMENT OF CASH FLOWS Financial statements for McDowell Company as well as additional information relevant to cash flows during the period are given below and on the next page. Additional information: 1. Store equipment was sold in 20-2 for 35,000. Additional information on the store equipment sold is provided below. 2. Depreciation expense for the year was 112,000. 3. The following purchases were made for cash: 4. Declared and paid cash dividends of 60,000. 5. Issued 10,000 shares of 10 par common stock for 142 per share. 6. Acquired additional office equipment by issuing a note payable for 16,000. REQUIRED Prepare a statement of cash flows explaining the change in cash and cash equivalents for the year ended December 31, 20-2. SCHEDULE FOR CALCULATION OF CASH GENERATED FROM OPERATING ACTIVITIES Using the information provided in Problem 23-12A for McDowell Company, prepare the following: 1. A schedule for the calculation of cash generated from operating activities for McDowellCompany for the year ended December 31, 20-2. 2. A partial statement of cash flows for McDowell Company reporting cash from operating activities under the direct method for the year ended December 31, 20-2.arrow_forwardVisual Inspection Noble Companys accounting records provided the following changes in account balances and other information for 2019: Additional information: Net income was 9,900. Dividends were declared and paid. Land was sold for 1,700. No land was purchased. A building was purchased for 23,000. No buildings and equipment were sold. Bonds payable were issued at the end of the year. Two hundred shares of stock were issued for 15 per share. The beginning cash balance was 4,800. Required: Using visual inspection, prepare a 2019 statement of cash flows for Noble.arrow_forward
- Preparing 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_forwardEXPANDED STATEMENT OF CASH FLOWS Financial statements for McGinnis Company as well as additional information relevant to cash flows during the period are given below and on the next page. Additional information: 1. Office equipment was sold in 20-2 for 35,000. Additional information on the office equipment sold is provided below. 2. Depreciation expense for the year was 70,000. 3. The following purchases were made for cash: 4. Declared and paid cash dividends of 40,000. 5. Issued 10,000 shares of 10 par common stock for 22 per share. 6. Acquired additional office equipment by issuing a note payable for 8,000. REQUIRED Prepare a statement of cash flows explaining the change in cash and cash equivalents for the year ended December 31, 20-2.arrow_forwardEXPANDED STATEMENT OF CASH FLOWS Financial statements for McGinnis Company as well as additional information relevant to cash flows during the period are given below and on the next page. Additional information: 1. Office equipment was sold in 20-2 for 35,000. Additional information on the office equipment sold is provided below. 2. Depreciation expense for the year was 70,000. 3. The following purchases were made for cash: 4. Declared and paid cash dividends of 40,000. 5. Issued 10,000 shares of 10 par common stock for 22 per share. 6. Acquired additional office equipment by issuing a note payable for 8,000. REQUIRED Prepare a statement of cash flows explaining the change in cash and cash equivalents for the year ended December 31, 20-2. STATEMENT OF CASH FLOWS UNDER THE DIRECT METHOD Using the information provided in Problem 23-12B for McGinnis Company, prepare the following: 1. A schedule for the calculation of cash generated from operating activities for McGinnis Company for the year ended December 31, 20-2. 2. A statement of cash flows for McGinnis Company prepared under the direct method for the year ended December 31, 20-2.arrow_forward
- Intermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage LearningCollege Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningCollege Accounting (Book Only): A Career ApproachAccountingISBN:9781337280570Author:Scott, Cathy J.Publisher:South-Western College Pub