Managerial Accounting: The Cornerstone of Business Decision-Making
Managerial Accounting: The Cornerstone of Business Decision-Making
7th Edition
ISBN: 9781337115773
Author: Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher: Cengage Learning
bartleby

Videos

Textbook Question
Book Icon
Chapter 14, Problem 53P

Balance sheets for Brierwold Corporation follow:

Chapter 14, Problem 53P, Balance sheets for Brierwold Corporation follow: Additional transactions were as follows: a.

 Additional transactions were as follows:

  1. a. Purchased equipment costing $50,000.
  2. b. Sold equipment costing $60,000, with a book value of $25,000, for $40,000.
  3. c. Retired preferred stock at a cost of $110,000. (The premium is debited to Retained Earnings.)
  4. d. Issued 10,000 shares of common stock (par value, $4) for $10 per share.
  5. e. Reported a loss of $15,000 for the year.
  6. f. Purchased land for $50,000.

 Required:

 Prepare a statement of cash flows using the worksheet approach. Use the indirect method to prepare the statement.

Expert Solution & Answer
Check Mark
To determine

Construct a statement of cash flows with the help of a worksheet.

Explanation of Solution

Worksheet:

The chart prepared in a spreadsheet format as a helping tool in accounting is known as worksheet. With the help of worksheet, a cash flow statement can be prepared with less confusion and complexity.

The worksheet for the B Corporation is shown in the table below:

Worksheet: B Corporation
For the year ending
Transactions
ParticularsBeginning Balance ($)Debit ($)Credit ($)Ending Balance ($)
Assets:
Cash100,000(1) 50,000 150,000
Accounts receivable200,000 (2) 20,000180,000
Inventory400,000(3) 10,000 410,000
Plant and equipment700,000(4) 50,000(5) 60,000690,000
Accumulated depreciation(200,000)(5) 35,000(6) 80,000(245,000)
Land100,000(7) 50,000 150,000
    Total assets1,300,000  1,335,000
 
Liabilities and stockholder’s equity:
Accounts payable300,000(8) 50,000 250,000
Mortgage payable- (9) 110,000110,000
Preferred stock100,000(10) 100,000--
Common stock240,000 (11) 40,000280,000
Paid-in capital in excess of par360,000 (11) 60,000420,000
Retained earnings300,000(10) 10,000  
  (12) 15,000 275,000
    Total liabilities and stockholder’s equity1,300,000  1,335,000
  
 Debit ($)Credit ($)
Cash flows from operating activities:  
Net loss (12) 15,000
    Decrease in accounts receivable(2) 20,000 
    Increase in inventory(5) 1,800(3) 10,000
    Decrease in accounts payable (8) 50,000
    Depreciation expense(6) 80,000 
    Gain on sale of equipment (5) 15,000
Cash flows from investing activities:  
    Sale of equipment(5) 40,000 
    Purchase of equipment (4) 50,000
    Purchase of land (7) 50,000
Cash flows from financing activities:  
    Retirement of preferred stock (10) 110,000
    Receipt of mortgage(9) 110,000(11) 36,000
    Issuance of common stock(11) 100,000 
Net increase in cash (1) 50,000

Table (1)

The analysis of transactions is as follows:

(1). Change in cash:

DateAccount Title and Explanation

Debit

($)

Credit

($)

 Cash50,000 
      Net increase in cash 50,000
 (Being the change in cash recorded)  

Table (2)

Increase in accrual cash balance by $50,000 from the beginning to the end of the year is recorded.

(2). Change in accounts receivable:

DateAccount Title and Explanation

Debit

($)

Credit

($)

 Operating cash20,000 
      Accounts receivable 20,000
 (Being the decrease in accounts receivable recorded)  

Table (3)

Decrease in accounts receivable by $20,000 is recognized on the income statement but is not collected. This cash inflow should be adjusted in the net income.

(3) Purchase of inventory:

DateAccount Title and Explanation

Debit

($)

Credit

($)

 Inventory10,000 
      Operating cash 10,000
 (Being the purchase value of inventory are recorded)  

Table (4)

The purchase value of inventory is recorded by debiting the inventory account and crediting the operating cash account.

(4) Purchase value of plant and equipment:

DateAccount Title and Explanation

Debit

($)

Credit

($)

 Plant and equipment50,000 
      Operating cash 50,000
 (Being the purchase value of plant and equipment recorded)  

Table (5)

The purchase value of the equipment which is $50,000 is debited and the operating cash account is credited.

(5). Gain on sale of equipment:

DateAccount Title and Explanation

Debit

($)

Credit

($)

 Cash from investing activities40,000 
 Accumulated depreciation35,000 
      Plant and equipment 60,000
      Gain on sale of equipment 15,000
 (Being the gain on sale of equipment recorded)  

Table (6)

The cash from investing activities records the value at which the equipment is sold which is $40,000. The accumulated depreciation is debited to record the expense. The plant and equipment account is credited to record the original cost of the equipment. The gain value on the sale of equipment is credited.

(6). Accumulated depreciation expense:

DateAccount Title and Explanation

Debit

($)

Credit

($)

 Depreciation expense80,0001 
      Accumulated depreciation 80,000
 (Being the accumulated depreciation recorded)  

Table (7)

The accumulated depreciation of $80,000 is credited to record the depreciation expense.

(7). Value of land:

DateAccount Title and Explanation

Debit

($)

Credit

($)

 Land50,000 
      Operating cash 50,000
 (Being the fair value of land recorded)  

Table (8)

The fair value of the land is recorded by debiting the land account and crediting the operating cash.

(8). Accounts payable:

DateAccount Title and Explanation

Debit

($)

Credit

($)

 Accounts payable50,000 
      Operating cash 50,000
 (Being the decrease in accounts payable recorded)  

Table (9)

The decrease in accounts payable by $50,000 shows that all the purchases were not from cash. The increase in accounts payable should be added back to the net income. The decrease in liability is recorded, hence it is debited.

(9). Mortgage payable:

DateAccount Title and Explanation

Debit

($)

Credit

($)

 Operating cash110,000 
      Mortgage payable 110,000
 (Being the increase in mortgage payable recorded)  

Table (10)

The increase in mortgage payable shows that the cash inflow is more than the expense recognized in the year by $110,000. The increase in liability is recorded, hence mortgages payable is credited and operating cash is debited.

(10). Preferred stock:

DateAccount Title and Explanation

Debit

($)

Credit

($)

 Preferred stock100,000 
 Retained earnings10,000 
     Cash flow from financing activities 110,000
 (Being the retirement of preference stock recorded)  

Table (11)

The cash flow from financing activities records an outflow with the retirement of preferred stock.

(11). Common stock:

DateAccount Title and Explanation

Debit

($)

Credit

($)

 Noncash investing activities100,000 
      Common stock 40,000
      Paid-in capital in excess of par 60,000

Table (12)

The noncash investing activity is recorded with the fair value of the equipment. The amount which is obtained by issuing the common stock is credited and the excess amount is credited in the paid-in capital stock.

(13). The reporting of loss:

DateAccount Title and Explanation

Debit

($)

Credit

($)

 Retained earnings15,000 
      Cash flow from financing activities 15,000
 (Being the net loss recorded)  

Table (13)

The retained earnings is debited by the amount of the reported loss for the year.

The final step is the cash flow statement which is prepared from the worksheet. The worksheet derived statement is shown in the table below:

B Corporation
Statement of Cash Flows
For the year ending
 Amount ($)Amount ($)
Cash flows from operating activities:
Net income(15,000) 
Add/Deduct:  
    Decrease in accounts receivable20,000 
    Increase in inventory(10,000) 
    Decrease in accounts payable(50,000) 
    Depreciation expense80,000 
    Gain on sale of equipment(15,000) 
         Net cash from operating activities 10,000
Cash flows from investing activities:
    Sale of equipment40,000 
    Purchase of investments(50,000) 
    Purchase of land(50,000) 
         Net cash from investing activities (60,000)
Cash flows from financing activities:
    Retirement of mortgage(110,000) 
    Issuance of common stock100,000 
    Receipt of mortgage110,000 
         Net cash from financing activities 100,000
Net increase in cash 50,000

Table (14)

Working Note:

1.

Calculation of difference in accounts receivable:

(DifferenceinAccountsReceivable)=(EndingAccountsReceivableBeginningAccountsReceivable)=($180,000$200,000)=$20,000

2.

Calculation of difference in amount of inventories:

(DifferenceinInventories)=(EndingInventoriesBeginningInventories)=($410,000$400,000)=$10,000

3.

Calculation of difference in accounts payable:

(DifferenceinAccountsPayable)=(EndingAccountsPayableBeginningAccountsPayable)=($250,000$300,000)=$50,000

4.

Calculation of depreciation expense:

DepreciationExpense=(EndingValueofAccumulatedDepreciationBeginningValueofAccumulatedDepreciation+AccumulatedDepreciationforAssetSold)=($245,000$200,000+$35,000)=$80,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
a. Purchased 16,000 common shares of Heller Co. at $16 cash per share. b. Received a cash dividend of $1.25 per common share from Heller. c. Year-end market price of Heller common stock is $17.50 per share. d. Sold all 16,000 common shares of Heller for $252,480 cash. Note: For each account catégory, indicate the appropriate account name. Enter "N/A" for any account category that is not used for a given transaction. Note: Indicate a decrease in an account category by including a negative sign with the amount. Balance Sheet Transaction Cash Asset Noncash Assets Liabilities Contrib. Capital Earned Capital Income Statement Revenues Expenses Net Income (256,000)✔ 256,000 0 ✓ Cash = Investment = ✓ N/A ✔ N/A = N/A M/A N/A (b) 20,000 ▼ 20,000✓ 20,000 ✔ 0✓ = 20,000 ✓ Cash ✓ N/A ÷ N/A ÷ ✓ N/A = Retained earnings Dividend income = ✓ N/A = (c) 0✓ 24,000 ✔ 0✓ 0✓ 24,000 ▼ 24,000 く 24,000 Cash = Investment ✓ N/A = N/A Retained earnings nrealized gain ÷ (d) 252,480✔ (2.240,000) x- 28,480 x Cash ÷ ✓…
m. Sold, at $38 per share, 2,600 shares of treasury common stock purchased in (g). Description Debit Credit n. Received interest of $6,000 from the Solstice Corp. investment in (f). Description Debit Credit o. Sold Solstice Corp. bonds with a face value of $40,020 for $45,000, realizing a gain of $4,980. Description Debit Credit p. Recorded the payment of semiannual interest on the bonds issued in (c) and the amortization of the premium for 6 months. The amortization is determined using the straight-line method. Description Debit Credit q. Accrued interest for 3 months on the Dream Inc. bonds purchased in (1). Description Debit Credit
The Retained earnings account for Nathan Corporation had a credit balance of $800,000 at the end of 20X0. Selected transactions during 20X1 follow:   Net income was $130,000. Cash dividends declared were $60,000. Repurchased 100 shares of Nathan Corporation common stock, paying $20 per share. Each share has a $5 par value and was originally issued for $35. Sold 20 shares of Nathan Corporation common stock for $22 each.   Required: Calculate Nathan’s retained earnings balance as of the end of 20X1.

Chapter 14 Solutions

Managerial Accounting: The Cornerstone of Business Decision-Making

Ch. 14 - In computing the periods net operating cash flows,...Ch. 14 - Explain the reasoning for including the payment of...Ch. 14 - What are the advantages in using worksheets when...Ch. 14 - Prob. 14DQCh. 14 - Cash inflows from operating activities come from...Ch. 14 - Prob. 2MCQCh. 14 - Prob. 3MCQCh. 14 - Sources of cash include a. profitable operations....Ch. 14 - Uses of cash include a. cash dividends. b. the...Ch. 14 - Prob. 6MCQCh. 14 - Prob. 7MCQCh. 14 - Which of the following adjustments to net income...Ch. 14 - An increase in accounts receivable is deducted...Ch. 14 - An increase in inventories is deducted from net...Ch. 14 - The gain on sale of equipment is deducted from net...Ch. 14 - Which of the following is an investing activity?...Ch. 14 - Which of the following is a financing activity? a....Ch. 14 - Prob. 14MCQCh. 14 - A worksheet approach to preparing the statement of...Ch. 14 - In a completed worksheet, a. the debit column...Ch. 14 - Prob. 17BEACh. 14 - Prob. 18BEACh. 14 - Prob. 19BEACh. 14 - Prob. 20BEACh. 14 - Swasey Company earned net income of 1,800,000 in...Ch. 14 - Prob. 22BEACh. 14 - Prob. 23BEACh. 14 - During 20X2, Norton Company had the following...Ch. 14 - Prob. 25BEBCh. 14 - Prob. 26BEBCh. 14 - Roberts Company provided the following partial...Ch. 14 - Prob. 28BEBCh. 14 - Prob. 29BEBCh. 14 - Prob. 30BEBCh. 14 - Prob. 31BEBCh. 14 - During 20X2, Evans Company had the following...Ch. 14 - Stillwater Designs is a private company and...Ch. 14 - Prob. 34ECh. 14 - Jarem Company showed 189,000 in prepaid rent on...Ch. 14 - During the year, Hepworth Company earned a net...Ch. 14 - During 20X1, Craig Company had the following...Ch. 14 - Tidwell Company experienced the following during...Ch. 14 - Prob. 39ECh. 14 - Oliver Company provided the following information...Ch. 14 - Prob. 41ECh. 14 - Prob. 42ECh. 14 - Prob. 43ECh. 14 - Solpoder Corporation has the following comparative...Ch. 14 - Solpoder Corporation has the following comparative...Ch. 14 - The following financial statements were provided...Ch. 14 - Prob. 47PCh. 14 - Prob. 48PCh. 14 - Booth Manufacturing has provided the following...Ch. 14 - The following balance sheets and income statement...Ch. 14 - The following balance sheets and income statement...Ch. 14 - Balance sheets for Brierwold Corporation follow:...Ch. 14 - Balance sheets for Brierwold Corporation follow:...Ch. 14 - Prob. 54PCh. 14 - Prob. 55PCh. 14 - The following balance sheets were taken from the...Ch. 14 - The following balance sheets were taken from the...Ch. 14 - The comparative balance sheets and income...
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
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Earnings per share (EPS), basic and diluted; Author: Bionic Turtle;https://www.youtube.com/watch?v=i2IJTpvZmH4;License: Standard Youtube License