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-2A
Name:
Section:
0%
Score:
Key Code:
[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:
Depreciation
Net cash flow from operating activities
Net cash flow used for investing activities
Net cash flow from financing activities
Cash balance, January 1, 20Y8
Cash balance, December 31, 20Y8
Optional:
Balance, Balance,
Dec. 31, 20Y7 Debit Credit Dec. 31, 20Y8
Cash 110,000 95,000
Accounts receivable (net) 280,000 260,000
Inventory 450,000 520,000
Prepaid expenses 5,000 15,000
Equipment 800,000 1,130,000
Accum. depr. – equipment (190,000) (235,000)
Accounts payable (75,000) (100,000)
Mortgage note payable (500,000) –
Common stock, $10 par (200,000) (500,000)
Paid-in capital in excess of par (100,000) (400,000)
Transactions
Cash flows from (used for) investing activities:
Cash flows from (used for) financing activities:
Yellow Dog Enterprises Inc.
Spreadsheet (Work Sheet) for Statement of Cash Flows
For the Year Ended December 31, 20Y8
Net increase (decrease) in cash
For the Year Ended December 31, 20Y8
Cash flows from (used for) operating activities:
Yellow Dog Enterprises Inc.
Statement of Cash Flows
Depreciation
Decrease in accounts receivable
Increase in inventory
Increase in prepaid expenses
Increase in accounts payable
Investing activities:
Purchase of equipment
Financing activities:
Payment of cash dividends
Sale of common stock
Instructions
Answers are entered in the cells with gray backgrounds.
but is provided as an aid in determining amounts for the statement.
Net income 250,000$
Adjustments to reconcile net income to net cash
flow from operating activities:
Depreciation 135,000
Net cash flow from operating activities 350,000$
Cash paid for purchase of equipment
Cash flows from (used for) investing activities:
Net cash flow used for investing activities (420,000)
Cash received from sale of common stock
Cash paid for dividends
Cash flows from (used for) financing activities:
Cash paid to retire mortgage note payable
Net cash flow from financing activities 55,000
(15,000)$
Cash balance, January 1, 20Y8 110,000
Cash balance, December 31, 20Y8 95,000$
Optional:
Balance, Balance,
Dec. 31, 20Y7 Debit Credit Dec. 31, 20Y8
Problem 15-2A
Name:
Section:
Solution
ON
An asterisk (*) will appear to the right of an incorrect entry. The optional work sheet will not be graded,
Score:
Yellow Dog Enterprises Inc.
Cells with non-gray backgrounds are protected and cannot be edited.
Transactions
Statement of Cash Flows
For the Year Ended December 31, 20Y8
Cash flows from (used for) operating activities:
Net increase (decrease) in cash
Spreadsheet (Work Sheet) for Statement of Cash Flows
For the Year Ended December 31, 20Y8
Yellow Dog Enterprises Inc.
Financing activities:
Payment of cash dividends (b) 45,000
Sale of common stock (c) 600,000
Payment of mortgage note payable (d) 500,000