The comparative balance sheets for Metlock, Inc. as of December 31 are presented below. Metlock, Inc. Comparative Balance Sheets December 31 Assets   2022     2021   Cash   $ 66,640     $ 44,100   Accounts receivable   49,000     56,840   Inventory   148,421     139,160   Prepaid expenses   14,974     20,580   Land   142,100     127,400   Buildings   196,000     196,000   Accumulated depreciation—buildings   (58,800 )   (39,200 ) Equipment   220,500     151,900   Accumulated depreciation—equipment   (44,100 )   (34,300 ) Total   $734,735     $662,480                 Liabilities and Stockholders’ Equity             Accounts payable   $ 43,835     $ 35,280   Bonds payable   294,000     294,000   Common stock, $1 par   196,000     156,800   Retained earnings   200,900     176,400   Total   $734,735     $662,480   Additional information: 1.   Operating expenses include depreciation expense of $41,160 ($19,600 of depreciation expense for buildings and $21,560 for equipment). 2.   Land was sold for cash at book value. 3.   Cash dividends of $11,760 were paid. 4.   Net income for 2022 was $36,260. 5.   Equipment was purchased for $90,160 cash. In addition, equipment costing $21,560 with a book value of $9,800 was sold for $7,840 cash. 6.   39,200 shares of $1 par value common stock were issued in exchange for land with a fair value of $39,200. Prepare a statement of cash flows for the year ended December 31, 2022, using the indirect method.

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter14: Statement Of Cash Flows (cashflow)
Section: Chapter Questions
Problem 1R: The comparative balance sheet of Prime Sports Gear, Inc., at December 31, the end of the fiscal...
icon
Related questions
icon
Concept explainers
Topic Video
Question

The comparative balance sheets for Metlock, Inc. as of December 31 are presented below.

Metlock, Inc.
Comparative Balance Sheets
December 31
Assets
 
2022
   
2021
 
Cash
 
$ 66,640
   
$ 44,100
 
Accounts receivable
 
49,000
   
56,840
 
Inventory
 
148,421
   
139,160
 
Prepaid expenses
 
14,974
   
20,580
 
Land
 
142,100
   
127,400
 
Buildings
 
196,000
   
196,000
 
Accumulated depreciation—buildings
 
(58,800
)
 
(39,200
)
Equipment
 
220,500
   
151,900
 
Accumulated depreciation—equipment
 
(44,100
)
 
(34,300
)
Total
 
$734,735
   
$662,480
 
             
Liabilities and Stockholders’ Equity
           
Accounts payable
 
$ 43,835
   
$ 35,280
 
Bonds payable
 
294,000
   
294,000
 
Common stock, $1 par
 
196,000
   
156,800
 
Retained earnings
 
200,900
   
176,400
 
Total
 
$734,735
   
$662,480
 


Additional information:

1.   Operating expenses include depreciation expense of $41,160 ($19,600 of depreciation expense for buildings and $21,560 for equipment).
2.   Land was sold for cash at book value.
3.   Cash dividends of $11,760 were paid.
4.   Net income for 2022 was $36,260.
5.   Equipment was purchased for $90,160 cash. In addition, equipment costing $21,560 with a book value of $9,800 was sold for $7,840 cash.
6.   39,200 shares of $1 par value common stock were issued in exchange for land with a fair value of $39,200.


Prepare a statement of cash flows for the year ended December 31, 2022, using the indirect method. (Show amounts that decrease cash flow with either a - sign e.g. -15,000 or in parenthesis e.g. (15,000).)

Metlock, Inc.
Statement of Cash Flows
Choose the accounting period                                                           December 31, 2022For the Year Ended December 31, 2022For the Quarter Ended December 31, 2022
Select an opening name for section one                                                           Cash at Beginning of PeriodCash at End of PeriodCash Flows from Financing ActivitiesCash Flows from Investing ActivitiesCash Flows from Operating ActivitiesNet Cash Provided by Financing ActivitiesNet Cash Provided by Investing ActivitiesNet Cash Provided by Operating ActivitiesNet Cash used by Financing ActivitiesNet Cash used by Investing ActivitiesNet Cash used by Operating ActivitiesNet Decrease in CashNet Increase in CashNoncash Investing and Financing Activities
   
Select an item                                                           Acquired Land by Issuance of Common StockDecrease in Accounts PayableDecrease in Accounts ReceivableDecrease in InventoryDecrease in Prepaid ExpensesDepreciation ExpenseIncrease in Accounts PayableIncrease in Accounts ReceivableIncrease in InventoryIncrease in Prepaid ExpensesGain on Disposal of Plant AssetsLoss on Disposal of Plant AssetsNet IncomePayment of Cash DividendsPurchase of EquipmentSale of EquipmentSale of Land
 
$Enter a dollar amount 
Adjustments to reconcile net income to
   
Selet an opening subsection name                                                           Cash at Beginning of PeriodCash at End of PeriodCash Flows from Financing ActivitiesCash Flows from Investing ActivitiesCash Flows from Operating ActivitiesNet Cash Provided by Financing ActivitiesNet Cash Provided by Investing ActivitiesNet Cash Provided by Operating ActivitiesNet Cash used by Financing ActivitiesNet Cash used by Investing ActivitiesNet Cash used by Operating ActivitiesNet Decrease in CashNet Increase in CashNoncash Investing and Financing Activities
   
Select an item                                                           Acquired Land by Issuance of Common StockDecrease in Accounts PayableDecrease in Accounts ReceivableDecrease in InventoryDecrease in Prepaid ExpensesDepreciation ExpenseIncrease in Accounts PayableIncrease in Accounts ReceivableIncrease in InventoryIncrease in Prepaid ExpensesGain on Disposal of Plant AssetsLoss on Disposal of Plant AssetsNet IncomePayment of Cash DividendsPurchase of EquipmentSale of EquipmentSale of Land
$Enter a dollar amount 
 
Select an item
Enter a dollar amount
 
Select an item
Enter a dollar amount
 
Select an item
Enter a dollar amount  
Select an item
Enter a dollar amount
 
Select an item
Enter a dollar amount
 
   
Enter a total amount for this subsection
Select a closing name for section one
 
Enter a total amount for section one
     
Select an opening name for section two
   
Select an item
Enter a dollar amount
 
Select an item
Enter a dollar amount
 
Select an item
Enter a dollar amount
 
Select a closing name for section two
 
Enter a total amount for section two
     
Select an opening name for section three
   
Select an item 
 
Enter a total amount for section three
     
Select an item
 
Enter a total amount for three sections
Select an item
 
Enter a dollar amount
Select a closing name for three sections
 
$Enter a total of the two previous amounts 
     
Select an opening name for section four
   
Select an item
 
$Enter a dollar amount 
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Financial Statements
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
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Financial Accounting: The Impact on Decision Make…
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Financial Accounting
Financial Accounting
Accounting
ISBN:
9781305088436
Author:
Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Financial Accounting Intro Concepts Meth/Uses
Financial Accounting Intro Concepts Meth/Uses
Finance
ISBN:
9781285595047
Author:
Weil
Publisher:
Cengage
Fundamentals Of Financial Management, Concise Edi…
Fundamentals Of Financial Management, Concise Edi…
Finance
ISBN:
9781337902571
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning