In: Accounting
Preparing a Statement of Cash Flows (Direct Method)
Rainbow Company's income statement and comparative balance sheets follow.
| RAINBOW COMPANY Income Statement For Year Ended December 31, 2016  | 
|||
|---|---|---|---|
| Sales | $1,125,000 | ||
| Dividend Income | 22,500 | ||
| Total Revenue | 1,147,500 | ||
| Cost of Goods Sold | $660,000 | ||
| Wages and Other Operating Expenses | 195,000 | ||
| Depreciation Expense | 58,500 | ||
| Patent Amortization Expense | 10,500 | ||
| Interest Expense | 19,500 | ||
| Income Tax Expense | 66,000 | ||
| Loss on Sale of Equipment | 7,500 | ||
| Gain on Sale of Investments | (4,500) | 1,012,500 | |
| Net Income | $135,000 | ||
| RAINBOW COMPANY Balance Sheets  | 
|||
|---|---|---|---|
| December 31, 2016 | December 31, 2015 | ||
| Assets | |||
| Cash and Cash Equivalents | $28,500 | $37,500 | |
| Accounts Receivable | 60,000 | 45,000 | |
| Inventory | 154,500 | 115,500 | |
| Prepaid Expenses | 15,000 | 9,000 | |
| Long-Term Investments | - | 85,500 | |
| Land | 285,000 | 150,000 | |
| Buildings | 667,500 | 525,000 | |
| Accumulated Depreciation-Buildings | (136,500) | (112,500) | |
| Equipment | 268,500 | 337,500 | |
| Accumulated depreciation-Equipment | (63,000) | (69,000) | |
| Patents | 75,000 | 48,000 | |
| Total Assets | $1,354,500 | $1,171,500 | |
| Liabilities and Stockholders' Equity | |||
| Accounts Payable | $30,000 | $24,000 | |
| Interest Payable | 9,000 | 7,500 | |
| Income Tax Payable | 12,000 | 15,000 | |
| Bonds Payable | 232,500 | 187,500 | |
| Preferred Stock ($100 par value) | 150,000 | 112,500 | |
| Common Stock ($5 par value) | 568,500 | 546,000 | |
| Paid-in capital in excess of par value-Common | 199,500 | 186,000 | |
| Retained Earnings | 153,000 | 93,000 | |
| Total Liabilities and Stockholders' Equity | $1,354,500 | $1,171,500 | |
During 2016, the following transactions and events occurred:
| 1 | Sold long-term investments costing $85,500 for $90,000 cash. | |
| 2 | Purchased land for cash. | |
| 3 | Capitalized an expenditure made to improve the building. | |
| 4 | Sold equipment for $21,000 cash that originally cost $69,000 and had $40,500 accumulated depreciation. | |
| 5 | Issued bonds payable at face value for cash. | |
| 6 | Acquired a patent with a fair value of $37,500 by issuing 375 shares of preferred stock at par value. | |
| 7 | Declared and paid a $75,000 cash dividend. | |
| 8 | Issued 4,500 shares of common stock for cash at $8 per share. | |
| 9 | Recorded depreciation of $24,000 on buildings and $34,500 on equipment. | 
Required
a. Compute the change in cash and cash equivalents that occurred
during 2016.
$Answer
b. Prepare a 2016 statement of cash flows using the direct method.
Use one cash outflow for "cash paid for wages and other operating
expenses." Accounts payable relate to inventory purchases only.
| RAINBOW COMPANY STATEMENT OF CASH FLOWS (Direct Method) FOR YEAR ENDED DECEMBER 31, 2016  | 
|||
|---|---|---|---|
| Cash flows from operating activities | |||
| Cash received from customers | |||
| Cash received as dividends | |||
| Cash paid for merchandise purchased | |||
| Cash paid for wages and other operating expenses | |||
| Cash paid for interest | |||
| Cash paid for income taxes | |||
| Net cash from operating activities | |||
| Cash flows from investing activities | |||
| Sale of investments | |||
| Patent amortizationIssuance of preferred stock to acquire patentIssuance of bonds payableNet incomeNet change in cashPurchase of landBeginning cash balance | |||
| Improvements to building | |||
| Sale of equipment | |||
| Net cash from investing activities | |||
| Cash flows from financing activities | |||
| Patent amortizationIssuance of preferred stock to acquire patentIssuance of bonds payableNet incomeNet change in cashPurchase of landBeginning cash balance | |||
| Issuance of common stock | |||
| Payment of dividends | |||
| Net cash from financing activities | |||
| Patent amortizationIssuance of preferred stock to acquire patentIssuance of bonds payableNet incomeNet change in cashPurchase of landBeginning cash balance | |||
| Patent amortizationIssuance of preferred stock to acquire patentIssuance of bonds payableNet incomeNet change in cashPurchase of landBeginning cash balance | |||
| Ending cash balance | |||
c. Prepare separate schedules showing (1) cash paid for interest and for income taxes and (2) noncash investing and financing transactions.
| (1) Reconciliation of net income to net cash flow from operating activities | ||
| Patent amortizationIssuance of preferred stock to acquire patentIssuance of bonds payableNet incomeNet change in cashPurchase of landBeginning cash balance | ||
| Add (deduct) items to convert net income to cash basis | ||
| Depreciation | ||
| Patent amortizationIssuance of preferred stock to acquire patentIssuance of bonds payableNet incomeNet change in cashPurchase of landBeginning cash balance | ||
| Loss on sale of equipment | ||
| Gain on sale of investments | ||
| Accounts receivable increase | ||
| Inventory increase | ||
| Prepaid expenses increase | ||
| Accounts payable increase | ||
| Interest payable increase | ||
| Income tax payable decrease | ||
| Net cash provided by operating activities | ||
| (2) Schedule of noncash investing and financing activities: | ||
| Patent amortizationIssuance of preferred stock to acquire patentIssuance of bonds payableNet incomeNet change in cashPurchase of landBeginning cash balance | ||
a.
| Cash and Cash Equivalents, December 31, 2016 | 28500 | 
| Cash and Cash Equivalents, December 31, 2015 | 37500 | 
| Cash decrease during 2016 | 9000 | 
b.
| RAINBOW COMPANY | ||
| STATEMENT OF CASH FLOWS (DIRECT METHOD) | ||
| FOR YEAR ENDED DECEMBER 31, 2016 | ||
| Cash Flows from operating activities | ||
| Cash received from customers | 1110000 | |
| Cash received as dividends | 22500 | |
| Cash paid for merchandise purchased | -693000 | |
| Cash paid for wages and other operating expenses | -201000 | |
| Cash paid for interest | -18000 | |
| Cash paid for income taxes | -69000 | |
| Net cash from operating activities | 151500 | |
| Cash Flows from investing activities | ||
| Sale of investments | 90000 | |
| Purchase of land | -135000 | |
| Improvements to building | -142500 | |
| Sale of equipment | 21000 | |
| Net cash from investing activities | -166500 | |
| Cash Flows from financing activities | ||
| Issuance of bonds payable | 45000 | |
| Issuance of common stock (4500 x $8) | 36000 | |
| Payment of dividends | -75000 | |
| Net cash from financing activities | 6000 | |
| Net change in cash | -9000 | |
| Beginning cash balance | 37500 | |
| Ending cash balance | 28500 | |
Workings:
| Cash receipts from customers | |
| Sales Revenue | 1125000 | 
| Less: Increase in Accounts Receivable | -15000 | 
| 1110000 | |
| Cash paid for merchandise purchased | |
| Cost of goods sold | 660000 | 
| Add: Increase in Inventory | 39000 | 
| Less: Increase in Accounts Payable | -6000 | 
| 693000 | |
| Cash paid for wages and other operating expenses | |
| Wages and other operating expenses | 195000 | 
| Add: Increase in prepaid expenses | 6000 | 
| 201000 | |
| Cash paid for interest | |
| Interest expense | 19500 | 
| Less: Increase in Interest Payable | -1500 | 
| 18000 | |
| Cash paid for income taxes | |
| Income tax expense | 66000 | 
| Add: Decrease Income tax payable | 3000 | 
| 69000 | 
c.
| (1) Supplemental Cash Flow Disclosures | |
| Cash Paid for Interest | 18000 | 
| Cash Paid for Income Taxes | 69000 | 
| (2) Schedule of Noncash Investing and Financing Activities | |
| Issuance of Preferred Stock to acquire Patent | 37500 | 
Note: The format provided for c(1) is incorrect. Kindly fill appropriately in the required format since the same has not been given with the question.