Problem 14(13)-1B
Instructions
Answers are entered in the cells with gray backgrounds.
An asterisk (*) will appear to the right of an incorrect entry. The optional work sheet will not be graded,
but is provided as an aid in determining amounts for the statement.
Net income
Adjustments to reconcile net income to net cash
flow from operating activities:
Depreciation
Loss on inventory write down and fixed assets
Changes in current operating assets and liabilities:
Net cash flow from operating activities
Net cash flow used for investing activities
Net cash flow provided by financing activities
Cash at the beginning of the year
Cash at the end of the year
Optional:
Balance, Balance,
Dec. 31, 2013 Debit Credit Dec. 31, 2014
Cash 47,940 70,720
Cells with non-gray backgrounds are protected and cannot be edited.
MERRICK EQUIPMENT CO.
Statement of Cash Flows
Name:
Section:
For the Year Ended December 31, 2014
Score:
Key Code:
0%
[Key code here]
Transactions
Cash flows from financing activities:
Cash flows from investing activities:
Increase in cash
MERRICK EQUIPMENT CO.
Spreadsheet (Work Sheet) for Statement of Cash Flows
For the Year Ended December 31, 2014
Cash flows from operating activities:
Inventories 289,850 298,520
Problem 14(13)-1B
Instructions
Answers are entered in the cells with gray backgrounds.
but is provided as an aid in determining amounts for the statement.
Net income 141,680$
Optional:
Balance, Balance,
Dec. 31, 2013 Debit Credit Dec. 31, 2014
Cash 47,940 (m) 22,780 70,720
An asterisk (*) will appear to the right of an incorrect entry. The optional work sheet will not be graded,
MERRICK EQUIPMENT CO.
Cells with non-gray backgrounds are protected and cannot be edited.
ON
Score:
Transactions
Statement of Cash Flows
For the Year Ended December 31, 2014
Cash flows from operating activities:
For the Year Ended December 31, 2014
MERRICK EQUIPMENT CO.
Spreadsheet (Work Sheet) for Statement of Cash Flows
Name:
Section:
Solution
Cash received from sale of investments
Cash flows from financing activities:
Increase in cash
Less cash paid for purchase of land
Less cash paid for purchase of equipment
Cash flows from investing activities:
Cash received from sale of common stock
Less cash paid for dividends
Loss on sale of investments
