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.
Problem 15-1A
Name:
Section:
Score:
Key Code:
0%
[Key code here]
Cells with non-gray backgrounds are protected and cannot be edited.
Net income
Adjustments to reconcile net income to net cash
flow from operating activities:
Changes in current operating assets and liabilities:
Net cash flow from operating activities
Cash flows from (used for) investing activities:
Net cash flow used for investing activities
Cash flows from (used for) financing activities:
Net cash flow from financing activities
Cash balance, January 1, 20Y3
Cash balance, December 31, 20Y3
Optional:
Balance, Balance,
Transactions
For the Year Ended December 31, 20Y3
Spreadsheet (Work Sheet) for Statement of Cash Flows
Livers Inc.
Cash flows from (used for) operating activities:
Net increase (decrease) in cash
Instructions
Answers are entered in the cells with gray backgrounds.
but is provided as an aid in determining amounts for the statement.
Net income 500,000$
Adjustments to reconcile net income to net cash
Gain on sale of investments
Net cash flow from operating activities 490,000$
Cash paid for purchase of land
Cash paid for purchase of equipment
Cash flows from (used for) investing activities:
Cash received from sale of investments
Net cash flow used for investing activities (525,000)
Cash flows from (used for) financing activities:
Cash received from sale of common stock
Cash paid for dividends
Net cash flow from financing activities 40,000
Net increase (decrease) in cash
Optional:
Statement of Cash Flows
For the Year Ended December 31, 20Y3
Cash flows from (used for) operating activities:
Livers Inc.
Spreadsheet (Work Sheet) for Statement of Cash Flows
Problem 15-1A
Name:
Section:
Solution
ON
Score:
An asterisk (*) will appear to the right of an incorrect entry. The optional work sheet will not be graded,
Livers Inc.
Cells with non-gray backgrounds are protected and cannot be edited.
Balance, Balance,
Dec. 31, 20Y2 Debit Credit
Dec. 31, 20Y3
Cash 150,000 (m) 5,000 155,000
Accounts receivable (net) 400,000 (l) 50,000 450,000
Operating activities:
Net income (a) 500,000
Depreciation (g) 100,000
Gain on sale of investments (j) 75,000
Increase in accounts receivable (l) 50,000
Transactions
For the Year Ended December 31, 20Y3