Comparative Balance SheetsYEAR 1Assets Cash $ 69,000Accounts receivable, net 76,000Inventory 124,000Prepaid expenses 10,400Total current assets 279,400Machinery 140,000Accumulated depreciation—Machinery (21,500)Total assets $ 397,900Liabilities Accounts payable $ 67,500Salaries payable 20,000Income taxes payable 8,800Total current liabilities 96,300Notes payable (long term) 85,000Total liabilities 181,300Equity Common stock, no par value 185,000Retained earnings 31,600Total liabilities and equity $ 397,900YEAR 2Assets Cash $ 92,500 Accounts receivable, net 102,500Inventory 88,800 Prepaid expenses 6,900 Total current assets 290,700 Machinery 149,000 Accumulated depreciation—Machinery (39,500) Total assets $ 400,200 Liabilities Accounts payable $ 50,000 Salaries payable 8,500 Income taxes payable 5,900 Total current liabilities 64,400 Notes payable (long term) 55,000 Total liabilities 119,400 Equity Common stock, no par value 270,000 Retained earnings 10,800 Total liabilities and equity $ 400,200
Income StatementFor Year Ended December 31, Year 2Sales $ 803,000Cost of goods sold 436,000Gross profit 367,000Operating expenses (excluding depreciation) 92,000Depreciation expense 83,600 191,400Other gains (losses) Gain on sale of machinery 4,500Income before taxes 195,900Income taxes expense 46,390Net income $149,510
Additional Information1. A $30,000 note payable is retired at its $30,000 carrying (book) value in exchange for cash.2. The only changes affecting retained earnings are net income and cash dividends paid.3. New machinery is acquired for $82,600 cash.4. Received cash for the sale of machinery that had cost $73,600, yielding a $4,500 gain.5. Prepaid Expenses and Salaries Payable relate to Operating Expenses on the income statement.6. All purchases and sales of inventory are on credit.
Prepare a statement of cash flows using the indirect method for the year ended December 31, Year 2
The correct answer and explanation is:
Here is the statement of cash flows using the indirect method:
Statement of Cash Flows
For the Year Ended December 31, Year 2
Cash Flows from Operating Activities
Net income: $149,510
Adjustments to reconcile net income to net cash provided by operating activities:
- Depreciation expense: $83,600
- Gain on sale of machinery: $(4,500)
- Changes in current assets and liabilities:
- Increase in accounts receivable: $(26,500)
- Decrease in inventory: $35,200
- Decrease in prepaid expenses: $3,500
- Decrease in accounts payable: $(17,500)
- Decrease in salaries payable: $(11,500)
- Decrease in income taxes payable: $(2,900)
Net cash provided by operating activities: $208,910
Cash Flows from Investing Activities
- Purchase of new machinery: $(82,600)
- Cash received from sale of machinery: $78,100
Net cash used in investing activities: $(4,500)
Cash Flows from Financing Activities
- Repayment of note payable: $(30,000)
- Issuance of common stock: $85,000
- Cash dividends paid: $(170,310)
Net cash used in financing activities: $(115,310)
Net Increase in Cash: $89,100
Cash at Beginning of Year: $69,000
Cash at End of Year: $92,500
Explanation:
The statement of cash flows using the indirect method starts with net income of $149,510. Non-cash expenses like depreciation ($83,600) are added back, while gains on sales of machinery ($4,500) are subtracted.
Changes in working capital accounts (current assets and liabilities) impact cash flows. An increase in accounts receivable ($26,500) means more sales on credit, reducing cash. A decrease in inventory ($35,200) frees up cash. Prepaid expenses decrease ($3,500), adding cash, while reductions in accounts payable ($17,500), salaries payable ($11,500), and income taxes payable ($2,900) reduce cash flow.
Investing activities include purchasing new machinery for $82,600 and selling old machinery for $78,100 (which had a book value of $73,600, yielding a gain of $4,500). The net impact is a $4,500 cash outflow.
Financing activities show a $30,000 repayment of long-term debt, $85,000 raised from issuing stock, and $170,310 in dividends paid, leading to a net cash outflow of $115,310.
Finally, adding up all sections results in a net cash increase of $89,100, aligning with the change in cash from $69,000 to $92,500 over the year.
Now, generating the image.
Here is the generated infographic for the statement of cash flows. Let me know if you need any modifications or explanations!
