The following balance sheets and income statement were taken from the records of Rosie-Lee Company:
Additional transactions were as follows:
Required:
Prepare a statement of cash flows using a worksheet similar to the one shown in Example 14.8 (p. 804). Use the indirect method to prepare the statement.
Construct a statement of cash flows with the help of a worksheet.
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 PM Company is shown in the table below:
Worksheet: R-L Company | ||||||||
For the year ended June 30, 20X2 | ||||||||
Transactions | ||||||||
Particulars | Beginning Balance ($) | Debit ($) | Credit ($) | Ending Balance ($) | ||||
Assets: | ||||||||
Cash | 270,000 | (1) 63,000 | Â | 333,000 | ||||
Accounts receivable | 126,000 | (2) 18,000 | Â | 144,000 | ||||
Investments | - | (3) 54,000 | Â | 54,000 | ||||
Plant and equipment | 180,000 | (4) 30,600 | (5) 21,600 | 189,000 | ||||
Accumulated depreciation | (54,000) | (5) 16,200 | (6) 19,800 | (57,600) | ||||
Land | 36,000 | (7) 18,000 | Â | 54,000 | ||||
   Total assets | 558,000 |  |  | 716,400 | ||||
 | ||||||||
Liabilities and stockholder’s equity: | ||||||||
Accounts payable | 72,000 | Â | (8) 18,000 | 90,000 | ||||
Mortgage payable | 108,000 | (9) 108,000 | Â | - | ||||
Bonds payable | - | Â | (10) 90,000 | 90,000 | ||||
Preferred stock | 36,000 | (11) 36,000 | - | - | ||||
Common stock | 180,000 | Â | (12) 108,000 | 288,000 | ||||
Retained earnings | 162,000 | (13) 36,000 | (14) 122,400 | 248,400 | ||||
   Total liabilities and stockholder’s equity | 252,000 |  |  | 716,400 | ||||
 |  | |||||||
 | Debit ($) | Credit ($) | ||||||
Cash flows from operating activities: | Â | Â | ||||||
Net income (loss) | (14) 122,400 | Â | ||||||
   Increase in accounts receivable | - | (2) 18,000 | ||||||
   Increase in accounts payable | (8) 18,000 |  | ||||||
   Depreciation expense | (6) 19,800 |  | ||||||
   Loss on sale of equipment | (5) 1,800 |  | ||||||
Cash flows from investing activities: | Â | Â | ||||||
   Sale of equipment | (5) 3,600 |  | ||||||
   Purchase of equipment |  | (4) 30,600 | ||||||
   Purchase of land |  | (7) 18,000 | ||||||
   Purchase of investments |  | (3) 54,000 | ||||||
Cash flows from financing activities: | Â | Â | ||||||
   Retirement of mortgage |  | (9) 108,000 | ||||||
   Retirement of preferred stock |  | (11) 36,000 | ||||||
   Issuance of bonds | (10) 90,000 |  | ||||||
   Issuance of common stock | (12) 108,000 |  | ||||||
   Payment of dividends | (10) 8,000 | (13) 36,000 | ||||||
Net increase in cash | Â | (1) 63,000 |
Table (1)
The analysis of transactions is as follows:
(1). Change in cash:
Date | Account Title and Explanation |
Debit ($) |
Credit ($) |
 | Cash | 63,000 |  |
 |     Net increase in cash |  | 63,000 |
 | (Being the change in cash recorded) |  |  |
Table (2)
Increase in accrual cash balance by $63,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 | 18,000 |  |
 |     Operating cash |  | 18,000 |
 | (Being the increase in accounts receivable recorded) |  |  |
Table (3)
Increase in accounts receivable by $18,000 is recognized on the income statement but is not collected. This cash inflow should be adjusted in the net income.
(3) Purchase of investments:
Date | Account Title and Explanation |
Debit ($) |
Credit ($) |
 | Investments | 54,000 |  |
 |     Operating cash |  | 54,000 |
 | (Being the purchase value of investments are recorded) |  |  |
Table (4)
The purchase value of investments is recorded by debiting the investment account and crediting the operating cash account.
(4) Purchase value of plant and equipment:
Date | Account Title and Explanation |
Debit ($) |
Credit ($) |
 | Plant and equipment | 30,6001 |  |
 |     Operating cash |  | 32,000 |
 | (Being the purchase value of plant and equipment recorded) |  |  |
Table (5)
The purchase value of the equipment which is $30,600 is debited and the operating cash account is credited.
(5). Sale value of equipment:
Date | Account Title and Explanation |
Debit ($) |
Credit ($) |
 | Operating cash | 1,800 |  |
 | Cash from investing activities | 3,600 |  |
 | Accumulated depreciation | 16,200 |  |
 |     Plant and equipment |  | 21,600 |
 | (Being the loss on sale of equipment recorded) |  |  |
Table (6)
The operating cash flows are increased by $1,800; 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 $3,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.
(6). Accumulated depreciation expense:
Date | Account Title and Explanation |
Debit ($) |
Credit ($) |
 | Operating cash | 19,8002 |  |
 |     Accumulated depreciation |  | 19,800 |
 | (Being the accumulated depreciation recorded) |  |  |
Table (7)
There is net decrease in accumulated depreciation of $19,800.
(7). Value of land:
Date | Account Title and Explanation |
Debit ($) |
Credit ($) |
 | Land | 18,000 |  |
 |     Operating cash |  | 18,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...
Intermediate Accounting: Reporting And Analysis
Accounting Information Systems
Corporate Financial Accounting
Financial Accounting
Financial & Managerial Accounting
Financial And Managerial Accounting
College Accounting, Chapters 1-27
Accounting
Brief Principles of Macroeconomics (MindTap Course List)
Essentials of Economics (MindTap Course List)
Contemporary Marketing
Essentials of Business Communication (MindTap Course List)
Management, Loose-Leaf Version
MKTG 12:STUDENT ED.-TEXT
ECON: MICRO4 (New, Engaging Titles from 4LTR Press)
Accounting Information Systems
Fundamentals of Financial Management (MindTap Course List)
Foundations of Business (MindTap Course List)
Principles of Macroeconomics (MindTap Course List)
STATISTICS F/BUSINESS+ECONOMICS-TEXT
Fundamentals of Financial Management, Concise Edition (MindTap Course List)
Principles of Economics (MindTap Course List)
Principles of Microeconomics (MindTap Course List)
Financial Accounting
Financial & Managerial Accounting
College Accounting (Book Only): A Career Approach
Accounting (Text Only)
Exploring Economics
Fundamentals of Financial Management, Concise Edition (with Thomson ONE - Business School Edition, 1 term (6 months) Printed Access Card) (MindTap Course List)
Statistics for Business & Economics, Revised (MindTap Course List)
College Accounting (Book Only): A Career Approach
College Accounting, Chapters 1-27 (New in Accounting from Heintz and Parry)
Fundamentals of Financial Management (MindTap Course List)
Pkg Acc Infor Systems MS VISIO CD
Principles of Macroeconomics (MindTap Course List)
Corporate Financial Accounting
PAYROLL ACCT.,2019 ED.(LL)-TEXT
Survey of Accounting (Accounting I)
Cornerstones of Cost Management (Cornerstones Series)
Purchasing and Supply Chain Management
Economics For Today
Economics (MindTap Course List)
Microeconomics