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

Videos

Textbook Question
Book Icon
Chapter 21, Problem 8P

Spreadsheet from Trial Balance Heinz Company’s post closing trial balance as of December 31, 2018, and the adjusted trial balance as of December 31, 2019, are shown here:

Chapter 21, Problem 8P, Spreadsheet from Trial Balance Heinz Companys post closing trial balance as of December 31, 2018,

A review of the accounting records reveals the following additional information:

  1. a. Bomb payable with a face value, book value, and market value of $14,000 were retired on June 30, 2019.
  2. b. Bonds payable with a face value of $8,000 were issued at 90.25 on August 1, 2019. They mature on August 1, 2024. The company uses the straight-line method to amortize the bond discount.
  3. c. The company sold a building that had an original cost of $8,000 and a book value of $4,800. The company received $2,200 in cash for the building and recorded a loss of $2,600.
  4. d. Equipment with a cost of $4,000 and a book value of $1,400 was exchanged for an acre of land valued at $2,700. No cash was exchanged.
  5. e. Long-term investments in bonds being held to maturity with a cost of $ 1,000 were sold for $800.
  6. f. Sixty-five shares of common stock were exchanged for a patent. The common stock was selling for $20 per share at the time of the exchange.

Required:

Prepare a spreadsheet to support a statement of cash flows for 2019.

Expert Solution & Answer
Check Mark
To determine

Prepare a spreadsheet to support a cash flow statement of H Company for the year 2019.

Explanation of Solution

Statement of cash flows: Cash flow 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.

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

Table (1)

A statement of cash flows of H Company for the year 2019:

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

Table (2)

Working notes:

(a) Calculate the net loss.

ParticularsAmount($)Amount($)
Revenues :  
Sales  49,550
Interest revenue 790
Gain on exchange of assets 1,300
Total revenue 51,640
Expenses:  
Cost of goods sold23,800 
Wages expense16,510 
Other operating expenses1,100 
Depreciation expense: buildings 2,700 
Depreciation expense: equipment3,100 
Patent amortization815 
Interest expense1,715 
Loss on sale of investments200 
Loss on sale of building(2,600) 
Income tax expense500 
Total expenses (53,040)
Net Loss (1,400)

Table (2)

Note: The $31,850 ending retained earnings balance is derived by subtracting the $1,400 net loss and the $2,100 dividends from the $35,350 beginning retained earnings balance.

(e) Calculate the increase in accounts receivable.

Increase in Accounts Receivable=(Beginning yera's accounts receivableEnding year's accounts receivable)=$5,900$6,215=$315

(f) Calculate the increase in inventories.

Increase in inventories=(Beginning year's inventoriesEnding year's inventories)=$15,300$15,530=$230

(g) Calculate the decrease in prepaid items.

Decerase in prepaid items=(Beginning year's prepaid items Ending year's prepaid items)=$1,400$1,000=$400

(h) Calculate the increase in accounts payable.

Increase in Accounts Payable=(Beginning year's accounts payableEnding year's accounts payable)=$8,900$9,195=$295

(i) Calculate the decrease in interest payable.

Decrease in Interest Payable=(Beginning year's interest payableEnding year's interest payable)=$630$330=$330

(j) Calculate the increase in wages payable.

Increase in Wages Payable=(Beginning year's wages payableEnding year's wages payable)=$2,500$2,600=$100

(l) Proceeds from issuance of bonds payable.

(Proceeds from Issuance of Bonds Payable)=(Payment to retire bonds payableBonds payable)=$14,000$6,000=$8,000

(m) Students may have difficulty with the extraordinary loss transaction. This may be shown in journal entry form as follows:

DateAccounts and ExplanationDebit ($)Credit ($)
Proceeds from sale of building2,200 
Accumulated Depreciation3,200
 Ordinary Loss(net)2,600
 Buildings 8000
 (To record the sale of  building)  

Table (3)

(n-1) Calculate the exchange of equipment for land.

Exchange of Equipment for Land=(Purchase of equipmentAccumulated depreciation+Gain on exchange of equipment for land)=$4,000$2,600+1,300=$2,700

(o)Calculate the proceeds from sale of long-term investment.

(Proceeds from Sale of Long-Term Investment)=(Purchase of long term investmentProceeds from sale of long-term investment)=$1,000$200=$800

(p-1) Calculate the issuance of common stock for patent.

(Issuance of Common Stock for Patent)=(Issuance of common stock+Additional paid-in capital )=$650+$650=$1,300

(p-2) Acquisition of patent by issuing common stock is $1,300,

(r) Calculate the bond discount amortization.

Bond Discount Amortization=( Proceeds from issuance of bonds payableDiscount on bonds payable)=$780$715=$65

(s) Calculate net increase in cash.

Net Increase in Cash=(Beginning year's cashEnding year's cash)=$2,700$3,520=$820 

Conclusion

Therefore, the net increase in cash is $820.

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
Heinz Company’s post-closing trial balance as of December 31, 2018, and the adjusted trial balance as of December 31, 2019, are shown here: A review of the accounting records reveals the following additional information: a. Bonds payable with a face value, book value, and market value of $14,000 were retired On June 30, 2019.                                                        b. Bonds payable with a face value of $8,000 were issued at 90.25 On August 1, 2019. They mature on August 1, 2024. The company uses the straight-line method to amortize the bond discount.                                    c. The company sold a building that had an original cost of $8,000 and a book value of $4,800. The company received $2,200 in cash for the building and recorded a loss of $2,600.                                                                       d. Equipment with a cost of $4,000 and a book value of $1,400 was exchanged for an acre of land valued at $2,700. No cash was exchanged.      e.…
Accounting for Notes Receivable On November 30, 2019, Tucker Products performed computer programming services for Thomas Inc. in exchange for a 5-month, $125,000, 9% note receivable. Thomas paid Tucker the full amount of interest and principal on April 30, 2020. Required: Prepare the necessary entries for Tucker to record the transactions described above. For a compound transaction, if an amount box does not require an entry, leave it blank. If required, round amounts to the nearest dollar.         Nov. 30, 2019 Notes Receivable        Sales Revenue        Record issuance of the note     Dec. 31, 2019 Interest Receivable        Interest Income        Record accrued interest income     Apr. 30, 2020 Cash        Notes Receivable        Interest Receivable        Interest Income
Accounting for Notes Receivable—Honoured and Dishonoured On November 30, 2018, Tucker Products performed computer programming services for Damascus Inc. in exchange for a five-month, $75,000, 10% note receivable. Damascus Inc. paid Tucker the full amount of interest and principal on April 30, 2019. Tucker has a December 31 year-end. Required: 1.  Prepare the necessary entries for Tucker to record the transactions described above. For a compound transaction, if those boxes in which no entry is required, leave the box blank. If required, round amounts to the nearest dollar. 2018, Nov. 30                 (Record adjusting entry for bad debt expense estimate)     2018, Dec. 31                 (Record accrued interest income)     2019, Apr. 30                                 (Record collection of note receivable)     2.  Prepare the journal entry required if the note is dishonoured on April 30, 2019. For those boxes in which no entry is required,…

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.
Similar questions
SEE MORE QUESTIONS
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
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Text book image
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
7.2 Ch 7: Notes Payable and Interest, Revenue recognition explained; Author: Accounting Prof - making it easy, The finance storyteller;https://www.youtube.com/watch?v=wMC3wCdPnRg;License: Standard YouTube License, CC-BY