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.
Construct a worksheet for the N Company.
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 N Company is shown in the table below:
Worksheet: N Company | ||||
At December 31, 20X2 | ||||
Transactions | ||||
Particulars | 20X1 ($) | Debit ($) | Credit ($) | 20X2 ($) |
Assets: | ||||
Cash | 108,000 | (1) 114,000 | 222,000 | |
Accounts receivable | 66,000 | (2) 7,600 | 73,600 | |
Inventory | 96,000 | (3) 30,000 | 66,000 | |
Plant and equipment | 156,000 | (4) 36,000 | 120,000 | |
Accumulated depreciation | (78,000) | (4) 18,000 | (5) 12,000 | (72,000) |
Land | 30,000 | (6) 50,000 | 80,000 | |
Total assets | 378,000 | 489,600 | ||
Liabilities and stockholder’s equity: | ||||
Accounts payable | 48,000 | (7) 24,000 | 72,000 | |
Wages payable | 6,000 | (8) 2,400 | 3,600 | |
Bonds payable | 36,000 | (9) 14,000 | 22,000 | |
Preferred stock | 6,000 | (10) 14,000 | 20,000 | |
Common stock | 60,000 | (11) 12,000 | 72,000 | |
Paid-in capital in excess of par | 60,000 | (11) 38,000 | 98,000 | |
Retained earnings | 162,000 | (13) 20,000 | (12) 60,000 | 202,000 |
Total liabilities and stockholder’s equity | 378,000 | 489,600 |
Table (1)
The analysis of transactions is as follows:
(1). Change in cash:
Date | Account Title and Explanation |
Debit ($) |
Credit ($) |
Cash | 114,000 | ||
Net increase in cash | 114,000 | ||
(Being the change in cash recorded) |
Table (2)
Increase in accrual cash balance by $114,000 from the beginning to the end of the year is recorded.
(2). Change in accounts receivable:
Date | Account Title and Explanation |
Debit ($) |
Credit ($) |
Accounts receivable | 7,600 | ||
Operating cash | 7,600 | ||
(Being the increase in accounts receivable recorded) |
Table (3)
Increase in accounts receivable by $7,600 is recognized on the income statement but is not collected. This cash inflow should be adjusted in the net income.
(3). Decrease in inventory:
Date | Account Title and Explanation |
Debit ($) |
Credit ($) |
Operating cash | 30,000 | ||
Inventory | 30,000 | ||
(Being the increase in inventory recorded) |
Table (4)
With decrease in inventory by $30,000, the operating cash is increased. The decrease in inventory does not show an outflow of cash.
(4). Sale of equipment:
Date | Account Title and Explanation |
Debit ($) |
Credit ($) |
Operating cash | 8,400 | ||
Cash from investing activities | 9,600 | ||
Accumulated depreciation | 18,000 | ||
Plant and equipment | 36,000 | ||
(Being the loss on sale of equipment recorded) |
Table (5)
The operating cash flows are increased by $8,400; so, the loss on sale should be added back to the net income for the adjustment. The cash from investing activities records the value at which the equipment is sold which is $9,600. The accumulated depreciation is debited to record the expense. The plant and equipment account is credited to record the original cost of the equipment.
(5). Accumulated depreciation expense:
Date | Account Title and Explanation |
Debit ($) |
Credit ($) |
Operating cash | 6,000 | ||
Accumulated depreciation | 6,000 | ||
(Being the accumulated depreciation recorded) |
Table (6)
There is net decrease in accumulated depreciation of $6,000
(6). Land for common stock:
Date | Account Title and Explanation |
Debit ($) |
Credit ($) |
Land | 50,000 | ||
Noncash investing activities | 50,000 | ||
(Being fair value of land recorded) |
Table (7)
Land account is debited with the fair value at which land is acquired. The noncash investing activities is credited with the amount to record the cash inflow by investing activities.
(7). Accounts payable:
Date | Account Title and Explanation |
Debit ($) |
Credit ($) |
Operating cash | 24,000 | ||
Accounts payable | 24,000 | ||
(Being the increase in accounts payable recorded) |
Table (8)
The increase in accounts payable by $24,000 shows that all the purchases were not from cash. The increase in accounts payable should be added back to the net income. The increase in liability is recorded, hence it is credited.
(8). Wages payable:
Date | Account Title and Explanation |
Debit ($) |
Credit ($) |
Wages payable | 2,400 | ||
Operating cash | 2,400 | ||
(Being the decrease in wages payable recorded) |
Table (9)
The decrease in accounts payable shows that the cash outflow is more than the wages expense recognized in the year by $2,400. The decrease in liability is recorded, hence wages payable is debited and operating cash is credited.
(9). Bonds payable:
Date | Account Title and Explanation |
Debit ($) |
Credit ($) |
Bonds payable | 14,000 | ||
Cash flow from financing activities | 14,000 | ||
(Being the decrease in bonds payable recorded) |
Table (10)
The decrease in bonds payable by $14,000 shows a cash outflow from financing activities. With the decrease in bonds payable there is a reduction in debt.
(10). Preferred stock:
Date | Account Title and Explanation |
Debit ($) |
Credit ($) |
Cash flow from financing activities | 14,000 | ||
Preferred stock | 14,000 | ||
(Being the issuance of preferred stock recorded) |
Table (11)
The cash flow from financing activities records an inflow with the issuance of preferred stock.
(11). Land for common stock:
Date | Account Title and Explanation |
Debit ($) |
Credit ($) |
Noncash investing activities | 50,000 | ||
Common stock | 12,000 | ||
Paid-in capital in excess of par | 38,000 | ||
(Being the amount of acquisition of land recorded) |
Table (12)
The noncash investing activity is recorded with the fair value of the land. The amount which is obtained by issuing the common stock is credited and the excess amount is credited in the paid-in capital.
(12). Net income:
Date | Account Title and Explanation |
Debit ($) |
Credit ($) |
Operating cash | 60,000 | ||
Retained earnings | 60,000 | ||
(Being the amount of net income recorded) |
Table (13)
The value of net income is recorded in the section of operating cash flows.
(13). Payment of dividends:
Date | Account Title and Explanation |
Debit ($) |
Credit ($) |
Retained earnings | 20,000 | ||
Cash flow from financing activities | 20,000 | ||
(Being the payment of dividends recorded) |
Table (14)
The amount by which payment of dividends is made is debited from the retained earnings. As payment of dividends is a cash outflow as financing activity, cash flow from financing activity is credited.
The final step is the cash flow statement which is prepared from the worksheet. The worksheet derived statement is shown in the table below:
N Company | ||
Statement of Cash Flows | ||
For the year ended December 31, 20X2 | ||
Cash flows from operating activities: | ||
Debit ($) | Credit ($) | |
Net income | (12) 60,000 | |
Depreciation expense | (5) 12,000 | |
Loss on sale of equipment | (4) 8,400 | |
Decrease in inventory | (3) 30,000 | |
Increase in accounts payable | (7) 24,000 | |
Increase in accounts receivable | (2) 7,600 | |
Decrease in wages payable | (8) 2,400 | |
Cash flows from investing activities: | ||
Sale of equipment | (4) 9,600 | |
Cash flows from financing activities: | ||
Reduction in bonds payable | (9) 14,000 | |
Payment of dividends | (13) 20,000 | |
Issuance of preferred stock | (10) 14,000 | |
Net increase in cash | (1) 114,000 | |
Noncash investing and financing activities: | ||
Land acquired with common stock | (11) 50,000 | (6) 50,000 |
Table (15)
Want to see more full solutions like this?
Chapter 14 Solutions
Managerial Accounting: The Cornerstone of Business Decision-Making
- For each of the following separate transactions: Sold a building costing $37,000, with $22,800 of accumulated depreciation, for $10,800 cash, resulting in a $3,400 loss. Acquired machinery worth $12,800 by issuing $12,800 in notes payable. Issued 1,280 shares of common stock at par for $2 per share. Note payables with a carrying value of $41,400 were retired for $49,800 cash, resulting in a $8,400 loss. (a) Prepare the reconstructed journal entry.(b) Identify the effect it has, if any, on the investing section or financing section of the statement of cash flows.arrow_forwardRogrer Company received a machine with a fair value of $130,000 and a building with a fair value of $200,000 in exchange for 6,000 shares of $45 par value common stock and $50,000 cash. The entry to record this transaction would include: Select one: a. Credit to Common Stock for $280,000 b. Credit to Additional Paid in Capital for $10,000 c. Credit to Retained earnings for $10,000 d. Credit to Additional Paid in Capital for $280,000arrow_forwardanswer thisarrow_forward
- Urmilabenarrow_forwardSuppose Ningbo Steel had sales revenue of $10,000 sales revenue, cost of goods sold of $5,000, operating expenses of $3000, interest expense of $1,000, a tax rate of 20%, and 2,000 shares of common stock outstanding. Based on this information, earnings per share was: Select one: a. $1.20 b. $1.00 c. $0.80 d. $0.40 e. none of the abovearrow_forwardDigman Co. had retained earnings of $400,000 and $50,000 in cash.on January 15t. It made a net income of $300,000 in the year. The amortization expense was $250,000. Digman Co. issued additional common shares for $500,000 and borrowed $600,000 from the Bank of Toyland. Cash from financing activities was: Select one: $1,100,000 none of the above $ 600,000 $ 900,000 $ 500,000arrow_forward
- How to record the following transactions? 13. (!)Company repurchased from the market 20 of own shares at nominal value of 10 and purchase price of 4. All share were paid for in full cash. 14. Last year company issue 100 shares at a nominal price of $6 / share and issue price $7 / share with an emission expense $150. 15. The company received a return of the goods from client – value of goods 2 000. 16. Last year the company set up a warranty provision of 20 000. One of the clients asked for a repair of the products purchased which cost 2 800. Company used the warranty provision to settle the cost. 17.The company Alfa incurred R&D. Company stated that the research costs are equal 2 000 and second stage (development cost) of the project is not finished but usefulness of it is almost 3 000.18.Company obtained a grant from a government of 2 000 to conduct R&D activities over the next year.The company Alfa incurred R&D. Company stated that the second stage of the project…arrow_forwardSloan Corporation purchased 3,500 shares of its own $0.90 par value common stock for $170,000. As a result of this transaction, the company's stockholders' equity A. decreased by $170,000. B. increased by $170,000. C. increased by $166,850. OD. increased by $3,150.arrow_forwardCushenberry Corporation had the following transactions. 1. Sold land (cost $8,400) for $10,500. 2. Issued common stock at par for $23,700. 3. Recorded depreciation on buildings for $16,900. 4. Paid salaries of $6,400. 5. Issued 1,300 shares of $1 par value common stock for equipment worth $8,000. 6. Sold equipment (cost $11,800, accumulated depreciation $8,260) for $1,416. (a) For each transaction above, prepare the journal entry. (Credit account titles are automatically indented when amount is entered. Do not indent manually.) No. Account Titles and Explanation Debit Credit 1. 2. 3. 4. 5. 6.arrow_forward
- 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 ÷ ✓…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_forwardDristell Inc. had the following activities during the year (all transactions are for cash unless stated otherwise):a. A building with a book value of $400,000 was sold for $500,000.b. Additional common stock was issued for $160,000.c. Dristell purchased its own common stock as treasury stock at a cost of $75,000.d. Land was acquired by issuing a 6%, 10-year, $750,000 note payable to the seller.e. A dividend of $40,000 was paid to shareholders.f. An investment in Fleet Corp.’s common stock was made for $120,000.g. New equipment was purchased for $65,000.h. A $90,000 note payable issued three years ago was paid in full.i. A loan for $100,000 was made to one of Dristell’s suppliers. The supplier plans to repay Dristell this amount plus 10% interest within 18 months.Required: Calculate net cash flows from investing activities.arrow_forward
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningCornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning