Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
3rd Edition
ISBN: 9781337788281
Author: James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher: Cengage Learning
bartleby

Concept explainers

bartleby

Videos

Textbook Question
Book Icon
Chapter 21, Problem 16P

Comprehensive The following are Farrell Corporation’s balance sheets as of December 31, 2019, and 2018, and the statement of income and retained earnings for the year ended December 31, 2019:

Chapter 21, Problem 16P, Comprehensive The following are Farrell Corporations balance sheets as of December 31, 2019, and , example  1

Chapter 21, Problem 16P, Comprehensive The following are Farrell Corporations balance sheets as of December 31, 2019, and , example  2

Additional information:

  1. a. On January 2, 2019, Farrell sold equipment costing $45,000, with a book value of $24,000, for $19,000 cash.
  2. b. On April 2, 2019, Farrell issued 1, 000 shares of common stock for $23,000 cash.
  3. c. On May 14, 2019, Farrell sold all of its treasury stock for $25,000 cash.
  4. d. On June 1, 2019, Farrell paid $50, 000 to retire bonds with a face value (and book value) of $50, 000.
  5. e. On July 2, 2019, Farrell purchased equipment for $63, 000 cash.
  6. 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.
  7. 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. 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. 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. 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. 2. Prepare the statement of cash flows. (A separate schedule reconciling net income to cash provided by operating activities is not necessary.)

1.

Expert Solution
Check Mark
To determine

Prepare a spreadsheet to support the statement of cash flows under direct method of F Company for the year ended December 31, 2019.

Explanation of Solution

Statement of cash flows: This statement reports all the cash transactions which are responsible for inflow and outflow of cash, and result of these transactions is reported as ending balance of cash at the end of reported period. Statement of cash flows includes the changes in cash balance due to operating, investing, and financing activities.

Worksheet: A worksheet is a spreadsheet used while preparing a financial statement. It is a type of form having multiple columns and it is used in the adjustment process. The use of a worksheet is optional for any organization. A worksheet can neither be considered as a journal nor a part of the general ledger.

Prepare a spreadsheet to support the statement of cash flows under direct method.

Intermediate Accounting: Reporting And Analysis, Chapter 21, Problem 16P , additional homework tip  1

Table (1)

Intermediate Accounting: Reporting And Analysis, Chapter 21, Problem 16P , additional homework tip  2

Table (2)

Working notes:

a) Net sales for the year are $1,950,000.

b) Cost of goods sold is $1,150,000.

c) Other operating expenses are $505,000.

f) Interest expense is $15,000.

h) Loss on sale of equipment is $5,000.

i) Income tax expense is $90,000.

j) Calculate the accounts receivable.

Decrease in accounts receivable = (Beginnig year's accounts receivable – Ending year's accounts receivable) = $305,000$2,95,00=$10,000

k) Calculate the increase in inventory.

Increase in inventory=(Beginning year's inventoryEnding year's inventory)=$431,0000$549,000=$118,000

l) Calculate the accounts payable.

Increase in Accounts Payable = (Beginnig year's accounts payable – Ending year's accounts payable) = $563,000$604,000=$41,000

m) Calculate the deferred tax

Increase in Deferred Tax =(Closing balance of deferred tax Opening balance of deferred tax)=$30,000$41,000=$11,000

n) Calculate proceeds from sale of common stock.

(Proceeds from Sale of Common Stock)=(Issuance of common stock+Additional paid in capital)=$10,000+$13,0000=$23,000

o) Calculate proceeds from sale of treasury stock.

(Proceeds from Sale of Treasury Stock)=(Issuance of treasury  stock+Additional paid in capital)=$17,000+$8,000=$25,000

p) Calculate the payment to retire bonds.

Bonds payable=(Beginning year's bonds payableEnding year's bonds payable)=$210,000$160,000=$50,000

q) Purchase of equipment is $63,000.

r-1) Issuance of long-term note is $150,000.

r-2) Calculate issuance of long-term note to purchase land.

(Issuance of Long-term Note to Purchase Land)=(Beginning year's purchase of landEnding year's purchase of land)=$350,000200,000=$150,000

s) Payment of cash dividends is $43,000.

t) Calculate net increase in cash.

Net increase in cash=(Beginnig year's cashEnding year's cash)=$225,000180,000=$45,000

Conclusion

Therefore, net increase in cash is $45,000.

2.

Expert Solution
Check Mark
To determine

Prepare a statement of cash flows of F Company for the year 2019.

Explanation of Solution

Prepare a statement of cash flows of F Company for the year 2019.

F Company
Statement of cash flows
For Year Ended December 31, 2019
ParticularsAmount($)Amount($)
Operating Activities:  
Cash inflows:  
Collections from customers1,960,000 
Cash inflows from operating activities 1,960,000
Cash outflows:  
Payments to suppliers(1,227,000) 
Other operating payments(505,000) 
Payments of interest(15,000) 
Payments of income taxes(79,000) 
Cash outflows from operating activities (1,826,000)
Net cash provided by operating activities 134,000
Investing Activities:  
Proceeds from sale of equipment19,000 
Payment for purchase of equipment (63,000) 
Net cash used for investing activities (44,000)
Financing  Activities:  
Proceeds from sale of common stock23,000 
Proceeds from sale of treasury stock25,000 
Payment to retire bonds(50,000) 
Payment of cash dividend(43,000) 
Net cash used for financing activities (45,000)
Net increase in cash (see Schedule 1) 45,000
Cash, January 1, 2019 180,000
Cash, December 31,2019 225,000
Schedule 1: Investing and Financing Activities Not Affecting Cash  
Investing Activities:  
Purchase of land by issuance of long-term note (150,000)
Financing  Activities:  
Issuance of long-term note to purchase land 150,000

Table (3)

Conclusion

Therefore, the net increase in cash is $45,000.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
General Accounting question
Hello tutor please provide answer accounting questions
Answer?? Financial accounting

Chapter 21 Solutions

Intermediate Accounting: Reporting And Analysis

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
Background pattern image
Accounting
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.
Recommended textbooks for you
Text book image
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning
Text book image
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Text book image
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Text book image
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Text book image
Income Tax Fundamentals 2020
Accounting
ISBN:9780357391129
Author:WHITTENBURG
Publisher:Cengage
The KEY to Understanding Financial Statements; Author: Accounting Stuff;https://www.youtube.com/watch?v=_F6a0ddbjtI;License: Standard Youtube License