WRIGHT COMPANY
Spreadsheet for the Statement of Cash Flows
Dec.31 Changes Dec. 31
2017 Debits Credits 2018
Balance Sheet
Assets:
Cash 30 (15)12 42
Accounts receivable 75 (1) 2 73
Liabilities:
Accounts payable 35 (2) 7 28
Salaries payable 5 (3) 3 2
Interest payable 3 (5) 2 5
Shareholders’ Equity:
Income Statement
Revenues:
Sales revenue (1)380 380
Expenses:
Cost of goods sold (2)130 (130)
Problem 21–2
Problem 21–2 (continued)
Spreadsheet for the Statement of Cash Flows
(continued)
Dec.31 Changes Dec. 31
2017 Debits Credits 2018
Statement of Cash Flows
Operating activities:
Cash inflows:
From customers (1)382
Cash outflows:
Investing activities:
Sale of land (6) 7
Financing activities:
Repayment of notes payable (11)30
Problem 21–2 (concluded)
WRIGHT COMPANY
Statement of Cash Flows
For year ended December 31, 2018 (in $000)
Cash flows from operating activities:
Cash inflows:
From customers $382
Cash outflows:
Cash flows from investing activities:
Cash flows from financing activities:
Repayment of notes payable (30)
Net increase in cash 12
NATIONAL INTERCABLE COMPANY
Spreadsheet for the Statement of Cash Flows
Dec.31 Changes Dec. 31
2017 Debits Credits 2018
Balance Sheet
Assets:
Cash 55 (18)2 57
Accounts receivable 170 (1)11 181
Less: Allowance (6) (1) 2 (8)
Liabilities:
Accounts payable 45 (4)15 30
Shareholders’ Equity:
Common stock 290 (15)20 310
X Noncash investing and financing activity.
Problem 21–3
Problem 21–3 (continued)
Spreadsheet for the Statement of Cash Flows
(continued)
Dec.31 Changes Dec. 31
2017 Debits Credits 2018
Income Statement
Revenues:
Sales revenue (1)320 320
Expenses:
Cost of goods sold (4)125 (125)
Salaries expense (5)55 (55)
Problem 21–3 (continued)
Spreadsheet for the Statement of Cash Flows
(continued)
Dec.31 Changes Dec. 31
2017 Debits Credits 2018
Statement of Cash Flows
Operating activities:
Cash inflows:
From customers (1)304
From investment revenue (2) 9
Cash outflows:
Investing activities:
Financing activities:
Payment on lease liability (13)12
Net increase in cash (18) 2 2
____ ____
Totals 1,082 1,082
Problem 21–3 (concluded)
NATIONAL INTERCABLE COMPANY
Statement of Cash Flows
For year ended December 31, 2018 ($ in millions)
Cash flows from operating activities:
Cash inflows:
From customers $304
From investment revenue 9
Cash outflows:
Cash flows from investing activities:
Cash flows from financing activities:
Payment on lease liability (12)
Noncash investing and financing activities:
Acquired $80 million of equipment by 7-year lease.
DUX COMPANY
Problem 21–4
Spreadsheet for the Statement of Cash Flows
Dec.31 Changes Dec. 31
2017 Debits Credits 2018
Balance Sheet
Assets:
Cash 20 (17)13 33
Accounts receivable 50 (1) 2 48
Less: Allowance (3) (1) 1 (4)
Liabilities:
Accounts payable 20 (3) 7 13
Salaries payable 5 (4) 3 2
Shareholders’ Equity:
Common stock 200 (14)10 210
X Noncash investing and financing activity.
Problem 21–4 (continued)
Spreadsheet for the Statement of Cash Flows (continued)
Dec.31 Changes Dec. 31
2017 Debits Credits 2018
Income Statement
Revenues:
Expenses:
Cost of goods sold (3)120 (120)
Salaries expense (4)25 (25)
Statement of Cash Flows
Operating activities:
Cash inflows:
From customers (1)202
From dividends received (2) 2
Cash outflows:
Investing activities:
Sale of building (7) 7
Financing activities:
Totals 584 584
Problem 21–4 (concluded)
DUX COMPANY
Statement of Cash Flows
For year ended December 31, 2018 ($ in 000s)
Cash flows from operating activities:
Cash inflows:
From customers $202
From dividends received 2
Cash outflows:
Cash flows from investing activities:
Cash flows from financing activities:
Net increase in cash 13
Noncash investing and financing activities: