Additional transactions were as follows:
- a. Purchased equipment costing $50,000.
- b. Sold equipment costing $60,000, with a book value of $25,000, for $40,000.
- c. Retired
preferred stock at a cost of $110,000. (The premium is debited toRetained Earnings .) - d. Issued 10,000 shares of common stock (par value, $4) for $10 per share.
- e. Reported a loss of $15,000 for the year.
- f. Purchased land for $50,000.
Required:
Prepare a statement of
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 | |||||
Particulars | Beginning Balance ($) | Debit ($) | Credit ($) | Ending Balance ($) | |
Assets: | |||||
Cash | 100,000 | (1) 50,000 | 150,000 | ||
Accounts receivable | 200,000 | (2) 20,000 | 180,000 | ||
Inventory | 400,000 | (3) 10,000 | 410,000 | ||
Plant and equipment | 700,000 | (4) 50,000 | (5) 60,000 | 690,000 | |
Accumulated depreciation | (200,000) | (5) 35,000 | (6) 80,000 | (245,000) | |
Land | 100,000 | (7) 50,000 | 150,000 | ||
Total assets | 1,300,000 | 1,335,000 | |||
Liabilities and stockholder’s equity: | |||||
Accounts payable | 300,000 | (8) 50,000 | 250,000 | ||
Mortgage payable | - | (9) 110,000 | 110,000 | ||
Preferred stock | 100,000 | (10) 100,000 | - | - | |
Common stock | 240,000 | (11) 40,000 | 280,000 | ||
Paid-in capital in excess of par | 360,000 | (11) 60,000 | 420,000 | ||
Retained earnings | 300,000 | (10) 10,000 | |||
(12) 15,000 | 275,000 | ||||
Total liabilities and stockholder’s equity | 1,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:
Date | Account Title and Explanation |
Debit ($) |
Credit ($) |
Cash | 50,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:
Date | Account Title and Explanation |
Debit ($) |
Credit ($) |
Operating cash | 20,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:
Date | Account Title and Explanation |
Debit ($) |
Credit ($) |
Inventory | 10,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:
Date | Account Title and Explanation |
Debit ($) |
Credit ($) |
Plant and equipment | 50,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:
Date | Account Title and Explanation |
Debit ($) |
Credit ($) |
Cash from investing activities | 40,000 | ||
Accumulated depreciation | 35,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:
Date | Account Title and Explanation |
Debit ($) |
Credit ($) |
Depreciation expense | 80,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:
Date | Account Title and Explanation |
Debit ($) |
Credit ($) |
Land | 50,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:
Date | Account Title and Explanation |
Debit ($) |
Credit ($) |
Accounts payable | 50,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:
Date | Account Title and Explanation |
Debit ($) |
Credit ($) |
Operating cash | 110,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:
Date | Account Title and Explanation |
Debit ($) |
Credit ($) |
Preferred stock | 100,000 | ||
Retained earnings | 10,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:
Date | Account Title and Explanation |
Debit ($) |
Credit ($) |
Noncash investing activities | 100,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:
Date | Account Title and Explanation |
Debit ($) |
Credit ($) |
Retained earnings | 15,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 receivable | 20,000 | |
Increase in inventory | (10,000) | |
Decrease in accounts payable | (50,000) | |
Depreciation expense | 80,000 | |
Gain on sale of equipment | (15,000) | |
Net cash from operating activities | 10,000 | |
Cash flows from investing activities: | ||
Sale of equipment | 40,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 stock | 100,000 | |
Receipt of mortgage | 110,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:
2.
Calculation of difference in amount of inventories:
3.
Calculation of difference in accounts payable:
4.
Calculation of depreciation expense:
Want to see more full solutions like this?
Chapter 14 Solutions
Managerial Accounting: The Cornerstone of Business Decision-Making
- During 20X2, Norton Company had the following transactions: a. Cash dividends of 20,000 were paid. b. Equipment was sold for 9,600. It had an original cost of 36,000 and a book value of 18,000. The loss is included in operating expenses. c. Land with a fair market value of 50,000 was acquired by issuing common stock with a par value of 12,000. d. One thousand shares of preferred stock (no par) were sold for 14 per share. Norton provided the following income statement (for 20X2) and comparative balance sheets: Required: Prepare a worksheet for Norton Company.arrow_forwardThe 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.arrow_forwardThe following selected transactions occurred for Corner Corporation: Feb. 1 Purchased 420 shares of the company’s own common stock at $22 cash per share; the stock is now held in treasury. July 15 Issued 110 of the shares purchased on February 1 for $32 cash per share. Sept. 1 Issued 70 more of the shares purchased on February 1 for $17 cash per share. Required: Indicate the account, amount, and direction of the effect for the above transactions. (Enter any decreases to account balances with a minus sign.) Prepare journal entries for each of the transactions. (If no entry is required for a transaction/event, select "No Journal Entry Required" in the first account field.) What impact does the purchase of treasury stock have on dividends paid?arrow_forward
- Mario's Fencing has the following balance sheet: Assets Cash: $100,000 Accounts Receivable: $300,000 Fixed Assets: $600,000 TOTAL assets: $1,000,000 Liabilites: Accounts Payable: $150,000 Notes Payable: $50,000 CAPITAL ACCOUNTS Common Stocks (50,000 shares @ $2 par): $100,000 Captial in excess of par: $200,000 Retained earnings: $500,000 TOTAL: $1,000,000 The company's stock sells for $10 a share: A. Show the effect on the capital account(s) of a two-for-one split, breaking down by common stock, capital excess of par, and retained earnings. B. Show the effect on the capital accounts of a 10 percent stock dividend, breaking down by common stock, capital excess of par, and retained earnings. (Part b is separate from part a. Part b, assume the stock split has NOT taken place). C. Based on the balance in retained earnings, which of the two dividend plans is more restrictive on future cash dividends?arrow_forwardListed below are a few events and transactions of Kodax Company. Year 1 January 2 Purchased 72,000 shares of Grecco Company common stock for $566,000 cash. Grecco has 216,000 shares of common stock outstanding, and its activities will be significantly influenced by Kodax. September 1 Grecco declared and paid a cash dividend of $1.10 per share. December 31 Grecco announced that net income for the year is $513,900. Year 2 June 1 Grecco declared and paid a cash dividend of $3.90 per share. December 31 Grecco announced that net income for the year is $745,400. December 31 Kodax sold 12,000 shares of Grecco for $125,000 cash. Prepare journal entries to record the above transactions and events of Kodax Company. Note: Do not round intermediate calculations and round your final answers to the nearest dollar amount. View transaction list Journal entry worksheet 1 2 3 4 5 6 Purchased 72,000 shares of Grecco Company common stock for $566,000 cash. Grecco has 216,000 shares of common stock…arrow_forwardListed below are a few events and transactions of Kodax Company. Year 1 January 2 Purchased 40,000 shares of Grecco Company common stock for $431,000 cash. Grecco has 120,000 shares of common stock outstanding, and its activities will be significantly influenced by Kodax. September 1 Grecco declared and paid a cash dividend of $1.70 per share. December 31 Grecco announced that net income for the year is $489,900. Year 2 June 1 Grecco declared and paid a cash dividend of $1.70 per share. December 31 Grecco announced that net income for the year is $705,400. December 31 Kodax sold 9,000 shares of Grecco for $160,000 cash. Prepare journal entries to record the above transactions and events of Kodax Company. (Do not round intermediate calculations and round your final answers to the nearest dollar amount.) View transaction list Journal entry worksheet < 1 2 Note: Enter debits before credits. Date September 1, Year 1 3 Cash 4 Grecco declared and paid a cash dividend of $1.70 per share. 5 6…arrow_forward
- On January 1, Vienna Corporation purchased 40% of the outstanding common stock of the Marietta Corporation for $137,500. During the year, Marietta Corporation reported net income of $50,000 and paid cash dividends of $25,000.The balance of the Investment in the Marietta Corporation account on the books of Vienna Corporation at year-end is: Select one: A. $147,500 B. $135,000 C. $100,000 D. $110,000arrow_forwardThe income statement for Stellar Industries shows income before income taxes $750,000, income tax expense $225,000, and net income $525,000. If Stellar has 150,000 shares of common stock outstanding throughout the year, earnings per share is: a. $5.00 b. $3.50 c. $1.50 d. $2.00arrow_forwardanswer thisarrow_forward
- Hansen Inc. engaged in the following transactions during the current Hansen Inc. engaged in the following transactions during the current year: a. Repurchased 13,000 shares of its own $1 par common stock for $14 per share on January 14. b. Sold 2,000 treasury shares to employees for $6 per share on January 31. c. Repurchased 3,000 more shares of the $1 par common stock for $16 per share on July 24. d. Sold the remaining 11,000 shares from the January 14 purchase and 1,200 of the shares from the July 24 purchase to employees for $6.50 per share on August 1. Required: 1. Prepare journal entries for each of these transactions. 2. Determine what the effect on total stockholders’ equity is for each of the four transactions.arrow_forwardSuppose a company purchases 2,000 shares of its own $1 par value common stock for $16 per share. The company then resells 400 of these shares for $20 per share. Which of the following is recorded at the time of the resale? a. Credit Common Stock for $400. b. Credit Treasury Stock for $8,000. c. Credit Common Stock for $8,000. d. Credit Additional Paid-In Capital for $1,600.arrow_forwardGotham Inc. issued 10,000 shares of its $2 par value common stock for $25 per share. The journal entry to record this transaction should include the following: (check all that apply) Select one or more: a. debit "Common Stock" for $20,000. b. credit "Additional Paid-in Capital" for $250,000. c. debit "Cash" for $250,000. d. credit "Additional Paid-in Capital" for $230,000. e. credit "Common Stock" for $20,000. f. credit "Common Stock" for $250,000. g. credit "Additional Paid-in Capital" for $270,000.arrow_forward
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning